1.  

ACTUARIAL RELEASE: Actuarial Release–16-029

United States Department of Agriculture


Farm and Foreign Agricultural Services


Risk Management Agency


1400 Independence Avenue, SW
Stop 0801
Washington, DC  20250-0801

Date

August 01, 2016

To:

All Insurance Providers

From:

Zachary White Chief, Actuarial Branch /s/ Scott Paschen    8/1/2016

Subject:

Actuarial Release 16-029 - Actuarial Information Available
As of August 01, 2016 the following information is now available on the FTP site:
  • 2016 Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.
  • 2017 Actuarial Data Master for the 6/30, 8/31, 9/30, 10/31 Filing Date, YTD, and Daily Files.
  • 2017 Special Provisions for the 8/31, 9/30, 10/31 Filing Date.
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.
  • 2017 Special Provisions are in the Special_Provisions/2017 directory.
Additional notes and details regarding this data release:

2016 ADM Price updated for the harvest price announcement, PM-16-041, 6/30 and 11/30 filings.
2017 SCO canola and SCO dry peas ADM now includes rates and yields populated for canola and dry peas removed extra rate rows for a given price volatility, 6/30 filing.
2017 Special Provisions and ADM are now issued for the 8/31, 9/30, and 10/31 filings except for PRF/API, olives, and Whole Farm Revenue Protection (WFRP). 

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 Actuarial Bulletins. 
File Name
Contains
Record Count
2016_ADM_Daily_160801.zip
A00810_Price_Daily.txt
27,090
2016_ADM_Filing_0630.zip
A00030_InsuranceOffer_Filing.txt
166,919
A00045_Map_Filing.txt
38,297
A00200_Date_Filing.txt
172,925
A00810_Price_Filing.txt
168,737
A01005_AreaRiskRate_Filing.txt
11,310,055
A01010_BaseRate_Filing.txt
81,159
A01040_CoverageLevelDifferential_Filing.txt
1,469,809
A01050_SubCountyRate_Filing.txt
23,625
A01060_OptionRate_Filing.txt
570,178
A01100_YieldAndTyield_Filing.txt
1,372,480
A01105_YieldExclusion_Filing.txt
120,786
A01110_HistoricalRevenueCapping_Filing.txt
17,742
A01200_DocumentBuilder_Filing.txt
1,587,211
2016_ADM_Filing_1130.zip
A00030_InsuranceOffer_Filing.txt
886,327
A00045_Map_Filing.txt
214,856
A00200_Date_Filing.txt
886,978
A00810_Price_Filing.txt
962,662
A01005_AreaRiskRate_Filing.txt
68,327,558
A01010_BaseRate_Filing.txt
418,887
A01040_CoverageLevelDifferential_Filing.txt
8,123,808
A01050_SubCountyRate_Filing.txt
146,647
A01060_OptionRate_Filing.txt
3,205,652
A01100_YieldAndTyield_Filing.txt
6,836,241
A01105_YieldExclusion_Filing.txt
466,461
A01110_HistoricalRevenueCapping_Filing.txt
138,738
A01200_DocumentBuilder_Filing.txt
8,887,029
2016_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
1,072
A00030_InsuranceOffer_YTD.txt
1,474,169
A00045_Map_YTD.txt
1,954,672
A00050_Quality_YTD.txt
538
A00070_SubsidyPercent_YTD.txt
480
A00200_Date_YTD.txt
1,480,826
A00400_AgrCommodity_YTD.txt
400
A00410_Class_YTD.txt
24
A00420_Commodity_YTD.txt
131
A00430_CommodityType_YTD.txt
360
A00440_County_YTD.txt
3,190
A00450_CroppingPractice_YTD.txt
77
A00460_InsurancePlan_YTD.txt
25
A00470_IntendedUse_YTD.txt
12
A00480_Interval_YTD.txt
47
A00490_IrrigationPractice_YTD.txt
3
A00500_OrganicPractice_YTD.txt
3
A00510_Practice_YTD.txt
1,072
A00520_State_YTD.txt
50
A00530_SubClass_YTD.txt
6
A00540_Type_YTD.txt
547
A00550_DocumentStructure_YTD.txt
20
A00560_EndorsementLength_YTD.txt
1
A00570_InsuranceOption_YTD.txt
46
A00580_RateMethod_YTD.txt
4
A00590_SpoiGroup_YTD.txt
92
A00615_Draw_YTD.txt
74,100
A00810_Price_YTD.txt
1,511,463
A01000_AgrRate_YTD.txt
9,263,808
A01005_AreaRiskRate_YTD.txt
87,253,282
A01010_BaseRate_YTD.txt
755,783
A01020_Beta_YTD.txt
121,500
A01030_ComboRevenueFactor_YTD.txt
2,827,170
A01040_CoverageLevelDifferential_YTD.txt
12,312,223
A01050_SubCountyRate_YTD.txt
177,454
A01060_OptionRate_YTD.txt
4,543,545
A01070_Proration_YTD.txt
2,739,624
A01090_UnitDiscount_YTD.txt
2,801
A01100_YieldAndTyield_YTD.txt
10,558,009
A01105_YieldExclusion_YTD.txt
599,718
A01110_HistoricalRevenueCapping_YTD.txt
156,480
A01115_HistoricalYieldTrend_YTD.txt
23,482
A01200_DocumentBuilder_YTD.txt
17,395,677
A01210_Statement_YTD.txt
22,016
2017_ADM_Daily_160801.zip
A00030_InsuranceOffer_Daily.txt
43,238
A00045_Map_Daily.txt
12,222
A00050_Quality_Daily.txt
21
A00070_SubsidyPercent_Daily.txt
38
A00200_Date_Daily.txt
43,238
A00410_Class_Daily.txt
3
A00420_Commodity_Daily.txt
39
A00430_CommodityType_Daily.txt
178
A00450_CroppingPractice_Daily.txt
18
A00460_InsurancePlan_Daily.txt
2
A00470_IntendedUse_Daily.txt
1
A00510_Practice_Daily.txt
228
A00530_SubClass_Daily.txt
2
A00540_Type_Daily.txt
235
A00550_DocumentStructure_Daily.txt
1
A00570_InsuranceOption_Daily.txt
4
A00810_Price_Daily.txt
2,844
A01010_BaseRate_Daily.txt
24,812
A01040_CoverageLevelDifferential_Daily.txt
351,782
A01050_SubCountyRate_Daily.txt
5,133
A01060_OptionRate_Daily.txt
103,267
A01070_Proration_Daily.txt
384
A01090_UnitDiscount_Daily.txt
1
A01100_YieldAndTyield_Daily.txt
2,465,052
A01105_YieldExclusion_Daily.txt
13,248
A01115_HistoricalYieldTrend_Daily.txt
20,277
A01120_AreaDataSource_Daily.txt
21
A01125_ProductionArea_Daily.txt
6,895
A01130_AreaCoverageLevel_Daily.txt
152,070
A01135_AreaRate_Daily.txt
48,846
A01200_DocumentBuilder_Daily.txt
204,365
A01210_Statement_Daily.txt
313
2017_ADM_Filing_0630.zip
A00030_InsuranceOffer_Filing.txt
170,930
A00045_Map_Filing.txt
38,187
A00200_Date_Filing.txt
176,783
A00810_Price_Filing.txt
104,745
A01010_BaseRate_Filing.txt
82,470
A01040_CoverageLevelDifferential_Filing.txt
1,463,639
A01050_SubCountyRate_Filing.txt
23,787
A01060_OptionRate_Filing.txt
585,850
A01100_YieldAndTyield_Filing.txt
1,483,536
A01105_YieldExclusion_Filing.txt
127,068
A01110_HistoricalRevenueCapping_Filing.txt
17,706
A01130_AreaCoverageLevel_Filing.txt
655,422
A01200_DocumentBuilder_Filing.txt
1,107,631
2017_ADM_Filing_0831.zip
A00030_InsuranceOffer_Filing.txt
35,123
A00045_Map_Filing.txt
4,878
A00200_Date_Filing.txt
35,123
A01010_BaseRate_Filing.txt
19,322
A01040_CoverageLevelDifferential_Filing.txt
275,111
A01050_SubCountyRate_Filing.txt
3,432
A01060_OptionRate_Filing.txt
85,864
A01070_Proration_Filing.txt
384
A01100_YieldAndTyield_Filing.txt
2,380,332
A01105_YieldExclusion_Filing.txt
11,685
A01130_AreaCoverageLevel_Filing.txt
107,682
A01200_DocumentBuilder_Filing.txt
156,827
2017_ADM_Filing_0930.zip
A00030_InsuranceOffer_Filing.txt
1,383
A00045_Map_Filing.txt
45
A00200_Date_Filing.txt
1,383
A01010_BaseRate_Filing.txt
1,239
A01040_CoverageLevelDifferential_Filing.txt
11,424
A01050_SubCountyRate_Filing.txt
45
A01060_OptionRate_Filing.txt
4,884
A01100_YieldAndTyield_Filing.txt
18,864
A01105_YieldExclusion_Filing.txt
438
A01130_AreaCoverageLevel_Filing.txt
1,152
A01200_DocumentBuilder_Filing.txt
12,303
2017_ADM_Filing_1031.zip
A00030_InsuranceOffer_Filing.txt
6,732
A00045_Map_Filing.txt
7,299
A00200_Date_Filing.txt
6,732
A01010_BaseRate_Filing.txt
4,251
A01040_CoverageLevelDifferential_Filing.txt
65,247
A01050_SubCountyRate_Filing.txt
1,656
A01060_OptionRate_Filing.txt
12,519
A01100_YieldAndTyield_Filing.txt
65,856
A01105_YieldExclusion_Filing.txt
1,125
A01130_AreaCoverageLevel_Filing.txt
19,020
A01200_DocumentBuilder_Filing.txt
35,235
2017_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
1,112
A00030_InsuranceOffer_YTD.txt
229,223
A00045_Map_YTD.txt
152,736
A00050_Quality_YTD.txt
253
A00070_SubsidyPercent_YTD.txt
311
A00200_Date_YTD.txt
235,076
A00410_Class_YTD.txt
14
A00420_Commodity_YTD.txt
75
A00430_CommodityType_YTD.txt
244
A00440_County_YTD.txt
3,166
A00450_CroppingPractice_YTD.txt
50
A00460_InsurancePlan_YTD.txt
19
A00470_IntendedUse_YTD.txt
6
A00480_Interval_YTD.txt
39
A00490_IrrigationPractice_YTD.txt
3
A00500_OrganicPractice_YTD.txt
3
A00510_Practice_YTD.txt
531
A00520_State_YTD.txt
50
A00530_SubClass_YTD.txt
5
A00540_Type_YTD.txt
340
A00550_DocumentStructure_YTD.txt
20
A00560_EndorsementLength_YTD.txt
1
A00570_InsuranceOption_YTD.txt
29
A00580_RateMethod_YTD.txt
4
A00590_SpoiGroup_YTD.txt
21
A00810_Price_YTD.txt
117,531
A01010_BaseRate_YTD.txt
109,193
A01020_Beta_YTD.txt
37,500
A01030_ComboRevenueFactor_YTD.txt
889,110
A01040_CoverageLevelDifferential_YTD.txt
1,873,030
A01050_SubCountyRate_YTD.txt
29,523
A01060_OptionRate_YTD.txt
692,656
A01070_Proration_YTD.txt
384
A01090_UnitDiscount_YTD.txt
817
A01100_YieldAndTyield_YTD.txt
3,954,972
A01105_YieldExclusion_YTD.txt
140,316
A01110_HistoricalRevenueCapping_YTD.txt
17,706
A01115_HistoricalYieldTrend_YTD.txt
167,835
A01120_AreaDataSource_YTD.txt
51
A01125_ProductionArea_YTD.txt
58,548
A01130_AreaCoverageLevel_YTD.txt
1,233,768
A01135_AreaRate_YTD.txt
2,409,144
A01200_DocumentBuilder_YTD.txt
1,413,221
A01210_Statement_YTD.txt
715
2017_SPOI_0831.zip
2017 Special Provisions 08/31 Filing Date
1,026
2017_SPOI_0930.zip
2017 Special Provisions 09/30 Filing Date
84
2017_SPOI_1031.zip
2017 Special Provisions 10/31 Filing Date
342
USDA is an Equal Opportunity Employer and Provider

   Office

  • Beacon Facility, Mail Stop 0801
    P.O. Box 419205
    Kansas City, MO 64141-6205