ACTUARIAL RELEASE: Actuarial Release–18-001
United States Department of Agriculture
Farm and Foreign Agricultural Services
Risk Management Agency
1400 Independence Avenue, SW
Stop 0801
Washington, DC 20250-0801
Date
January 11, 2018
To:
All Insurance Providers
From:
Zachary White, Chief, Actuarial Branch /s/ Zachary White 1/11/2018
Subject:
Actuarial Release 18-001 - Actuarial Information Available
-
As of January 11, 2018 the following information is now available on the FTP site:
- Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.
- 2018 Actuarial Data Master for the 8/31, 12/31 Filing Date, YTD, and Daily Files
Users can find this information in the following directories:
- 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:
2017 ADM Price updated for dry pea and dry bean revenue endorsement harvest prices, reference PM-17-001, 6/30 and 11/30 filings.
2018 ADM Guarantee Adjustment (A01220) revised to correct the factor (prevented planting guarantee adjustment) on PT & PF insurance option codes for California safflower (8/31 filing which has a 12/31 SCD) and PF for the remaining safflower states (12/31 filing).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 2017_ADM_Daily_180111.zipA00810_Price_Daily.txt15,1262017_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.txt170,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_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,3082017_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.txt1,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,2982018_ADM_Daily_180111.zip A01220_GuaranteeAdjustment_Daily.txt 540 2018_ADM_Filing_0831.zipA00030_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.txt247,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
1982018_ADM_Filing_1231.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
A01220_GuaranteeAdjustment_Filing.txt894
393
894
894
492
6,192
144
3,328
11,016
498
2,412
4,965
8162018 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.txt1,140
1,350,683
4,522,763
530
482
1,357,517
435
24
115
339
3,190
80
25
12
41
3
3
1,056
50
6
506
20
1
45
4
103
23,912,500
3,010,495
10,747,415
536,626
121,500
2,857,140
11,520,416
190,309
3,978,913
384
2,849
11,391,425
624,090
156,186
795,825
126
177,586
15,254,383
11,502,856
8,234,503
1,201
997,825