Actuarial 18-016

ACTUARIAL RELEASE: Actuarial Release–18-016

Date

April 16, 2018

To:

All Insurance Providers

From:

Zachary White, Chief, Actuarial Branch /s/ Zachary White 4/16/2018

Subject:

Actuarial Release 18-016 - Actuarial Information Available

As of April 16, 2018 the following information is now available on the FTP site:

2016 Actuarial Data Master for the 6/30 Filing Date, YTD, and Daily Files.
2017 Actuarial Data Master for the 6/30, 9/30, 11/30 Filing Date, YTD, and Daily Files.
2018 Actuarial Data Master for the 4/30, 8/31 Filing Date, YTD, and Daily Files.

Users can find this information in the following directories:

2016 Actuarial Data Master are in the References/Actuarial_Data_Master/2016 directory.
2017 Actuarial Data Master are in the References/Actuarial_Data_Master/2017 directory.
2018 Actuarial Data Master are in the References/Actuarial_Data_Master/2018 directory.

Additional notes and details regarding this data release:

2018 Annual Forage, Apiculture, and PRF final indices and payment factors issued on interval 625 with an ending month of February, reference PM-18-021.
2016 Sugarcane plan 04 (ADM Area Risk Rate) and 2017 ARPI/SCO final county yields & final county revenues, and final margins on Margin Protection on multiple commodities are issued, reference PM-17-022, 6/30, 9/30, and 11/30 filings.

Please notify your data processing representative that this information is available for downloading. For questions regarding the actuarial information, please contact Ron Tilly by phone at (816) 926-1337, or via email to ronald.tilly@rma.usda.gov

Archived release bulletins are located online at www.rma.usda.gov/Policy-and-Procedure/Bulletins-and-Memos/Actuarial-Releases.

File Name	Contains	Record Count
2016_ADM_Daily_180416.zip	A01005_AreaRiskRate_Daily.txt	744
2016_ADM_Filing_0630.zip	A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01005_AreaRiskRate_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01105_YieldExclusion_Filing.txt A01110_HistoricalRevenueCapping_Filing.txt A01200_DocumentBuilder_Filing.txt	166,919 38,297 172,925 168,737 11,310,055 81,159 1,469,809 23,625 570,178 1,372,480 120,786 17,742 1,587,211
2016_ADM_YTD.zip	A00010_AdmLayout_YTD.txt A00030_InsuranceOffer_YTD.txt A00045_Map_YTD.txt A00050_Quality_YTD.txt A00070_SubsidyPercent_YTD.txt A00200_Date_YTD.txt A00400_AgrCommodity_YTD.txt A00410_Class_YTD.txt A00420_Commodity_YTD.txt A00430_CommodityType_YTD.txt A00440_County_YTD.txt A00450_CroppingPractice_YTD.txt A00460_InsurancePlan_YTD.txt A00470_IntendedUse_YTD.txt A00480_Interval_YTD.txt A00490_IrrigationPractice_YTD.txt A00500_OrganicPractice_YTD.txt A00510_Practice_YTD.txt A00520_State_YTD.txt A00530_SubClass_YTD.txt A00540_Type_YTD.txt A00550_DocumentStructure_YTD.txt A00560_EndorsementLength_YTD.txt A00570_InsuranceOption_YTD.txt A00580_RateMethod_YTD.txt A00590_SpoiGroup_YTD.txt A00615_Draw_YTD.txt A00810_Price_YTD.txt A01000_AgrRate_YTD.txt A01005_AreaRiskRate_YTD.txt A01010_BaseRate_YTD.txt A01020_Beta_YTD.txt A01030_ComboRevenueFactor_YTD.txt A01040_CoverageLevelDifferential_YTD.txt A01050_SubCountyRate_YTD.txt A01060_OptionRate_YTD.txt A01070_Proration_YTD.txt A01090_UnitDiscount_YTD.txt A01100_YieldAndTyield_YTD.txt A01105_YieldExclusion_YTD.txt A01110_HistoricalRevenueCapping_YTD.txt A01115_HistoricalYieldTrend_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt	1,072 1,474,169 1,954,672 538 480 1,480,826 400 24 131 360 3,190 77 25 12 47 3 3 1,072 50 6 547 20 1 46 4 92 74,100 1,511,463 9,263,808 87,267,262 755,783 121,500 2,827,170 12,312,223 177,454 4,543,545 2,739,624 2,801 10,558,009 599,718 156,480 23,482 17,395,677 22,016
2017_ADM_Daily_180416.zip	A00810_Price_Daily.txt A01130_AreaCoverageLevel_Daily.txt	143,465 991,128
2017_ADM_Filing_0630.zip	A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01105_YieldExclusion_Filing.txt A01110_HistoricalRevenueCapping_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt	170,930 38,187 176,783 172,748 82,470 1,463,639 23,787 591,628 1,483,536 127,068 17,706 659,377 1,107,631
2017_ADM_Filing_0930.zip	A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01105_YieldExclusion_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt	1,383 45 1,383 1,587 1,239 11,424 45 4,884 18,864 438 1,152 12,303
2017_ADM_Filing_1130.zip	A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01105_YieldExclusion_Filing.txt A01110_HistoricalRevenueCapping_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt	882,721 223,049 883,372 959,170 417,171 8,396,664 164,404 3,221,238 7,157,968 473,925 138,588 3,984,890 6,552,308
2017_ADM_YTD.zip	A00010_AdmLayout_YTD.txt A00030_InsuranceOffer_YTD.txt A00045_Map_YTD.txt A00050_Quality_YTD.txt A00070_SubsidyPercent_YTD.txt A00200_Date_YTD.txt A00400_AgrCommodity_YTD.txt A00410_Class_YTD.txt A00420_Commodity_YTD.txt A00430_CommodityType_YTD.txt A00440_County_YTD.txt A00450_CroppingPractice_YTD.txt A00460_InsurancePlan_YTD.txt A00470_IntendedUse_YTD.txt A00480_Interval_YTD.txt A00490_IrrigationPractice_YTD.txt A00500_OrganicPractice_YTD.txt A00510_Practice_YTD.txt A00520_State_YTD.txt A00530_SubClass_YTD.txt A00540_Type_YTD.txt A00550_DocumentStructure_YTD.txt A00560_EndorsementLength_YTD.txt A00570_InsuranceOption_YTD.txt A00580_RateMethod_YTD.txt A00590_SpoiGroup_YTD.txt A00615_Draw_YTD.txt A00810_Price_YTD.txt A01000_AgrRate_YTD.txt A01010_BaseRate_YTD.txt A01020_Beta_YTD.txt A01030_ComboRevenueFactor_YTD.txt A01040_CoverageLevelDifferential_YTD.txt A01050_SubCountyRate_YTD.txt A01060_OptionRate_YTD.txt A01070_Proration_YTD.txt A01090_UnitDiscount_YTD.txt A01100_YieldAndTyield_YTD.txt A01105_YieldExclusion_YTD.txt A01110_HistoricalRevenueCapping_YTD.txt A01115_HistoricalYieldTrend_YTD.txt A01120_AreaDataSource_YTD.txt A01125_ProductionArea_YTD.txt A01130_AreaCoverageLevel_YTD.txt A01135_AreaRate_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt	1,117 1,478,981 3,298,356 510 498 1,485,485 431 24 127 364 3,190 77 25 12 47 3 3 1,072 50 6 550 21 1 46 4 95 76,700 2,998,996 9,898,224 762,068 121,500 2,857,140 12,650,747 195,367 4,607,891 2,738,688 2,899 11,127,004 615,027 156,294 724,426 130 177,728 12,269,758 13,886,372 13,723,962 1,298
2018_ADM_Daily_180416.zip	A00810_Price_Daily.txt A01130_AreaCoverageLevel_Daily.txt	190,995 954,975
2018_ADM_Filing_0430.zip	A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt A01220_GuaranteeAdjustment_Filing.txt	23,939 441,423 23,939 207,578 1,911 95,813 603 3,539 6,783 894,610 154,755 183
2018_ADM_Filing_0831.zip	A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01000_AgrRate_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01070_Proration_Filing.txt A01100_YieldAndTyield_Filing.txt A01105_YieldExclusion_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt A01220_GuaranteeAdjustment_Filing.txt	247,208 3,819,018 247,208 1,946,024 10,747,415 23,426 1,379,312 3,300 94,395 384 2,072,562 12,228 9,640,959 897,107 198
2018_ADM_YTD.zip	A00010_AdmLayout_YTD.txt A00030_InsuranceOffer_YTD.txt A00045_Map_YTD.txt A00050_Quality_YTD.txt A00070_SubsidyPercent_YTD.txt A00200_Date_YTD.txt A00400_AgrCommodity_YTD.txt A00410_Class_YTD.txt A00420_Commodity_YTD.txt A00430_CommodityType_YTD.txt A00440_County_YTD.txt A00450_CroppingPractice_YTD.txt A00460_InsurancePlan_YTD.txt A00470_IntendedUse_YTD.txt A00480_Interval_YTD.txt A00490_IrrigationPractice_YTD.txt A00500_OrganicPractice_YTD.txt A00510_Practice_YTD.txt A00520_State_YTD.txt A00530_SubClass_YTD.txt A00540_Type_YTD.txt A00550_DocumentStructure_YTD.txt A00560_EndorsementLength_YTD.txt A00570_InsuranceOption_YTD.txt A00580_RateMethod_YTD.txt A00590_SpoiGroup_YTD.txt A00615_Draw_YTD.txt A00810_Price_YTD.txt A01000_AgrRate_YTD.txt A01010_BaseRate_YTD.txt A01020_Beta_YTD.txt A01030_ComboRevenueFactor_YTD.txt A01040_CoverageLevelDifferential_YTD.txt A01050_SubCountyRate_YTD.txt A01060_OptionRate_YTD.txt A01070_Proration_YTD.txt A01090_UnitDiscount_YTD.txt A01100_YieldAndTyield_YTD.txt A01105_YieldExclusion_YTD.txt A01110_HistoricalRevenueCapping_YTD.txt A01115_HistoricalYieldTrend_YTD.txt A01120_AreaDataSource_YTD.txt A01125_ProductionArea_YTD.txt A01130_AreaCoverageLevel_YTD.txt A01135_AreaRate_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt A01220_GuaranteeAdjustment_YTD.txt	1,140 1,585,673 4,524,059 530 501 1,592,507 435 24 128 364 3,190 82 25 12 41 3 3 1,114 50 6 552 21 1 49 4 103 24,022,100 3,495,091 10,747,415 771,607 121,500 2,857,140 13,210,970 191,605 4,764,292 2,738,688 2,851 11,391,731 624,090 156,186 799,388 128 177,946 15,257,677 11,507,018 13,720,315 1,292 997,825

USDA is an Equal Opportunity Employer and Provider

ACTUARIAL RELEASE: Actuarial Release–18-016

Date

To:

From:

Subject:

FCIC

Agent Locator

Common Questions

RMA Website Archive

Manage Your Farm Risk

Insurance Resources

Educational Resources

Beginning Farmers