1.  

ACTUARIAL RELEASE: Actuarial Release–16-048

United States Department of Agriculture


Farm and Foreign Agricultural Services


Risk Management Agency


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

Date

December 15, 2016

To:

All Insurance Providers

From:

Zachary White, Chief, Actuarial Branch /s/ Zachary White    12/15/2016

Subject:

Actuarial Release 16-048 - Actuarial Information Available
As of December 15, 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 12/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.
Additional notes and details regarding this data release:
2016 ADM Price updated for dry pea and dry bean revenue endorsement harvest prices, reference PM-16-064, 6/30 and 11/30 filings.
In addition on the above update, 2016 CY organic practice Austrian dry peas (Type Code 098, Practice Codes 702, 713) in ND (38) and MT (30) incorrectly received a harvest price that differed from the projected price. Austrian peas do not receive revenue coverage (Insurance Plans 2, 3, 32, and 33). Thus RMA has set the harvest price to be equal to the projected price for these occurrences.
2017 ADM Price now issued for the December 31 contract change commodities of fresh market tomatoes and safflower.

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_161215.zip
A00810_Price_Daily.txt
19,378
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_161215.zip
A00810_Price_Daily.txt
894
2017_ADM_Filing_1231.zip
A00030_InsuranceOffer_Filing.txt
894
A00045_Map_Filing.txt
393
A00200_Date_Filing.txt
894
A00810_Price_Filing.txt
894
A01010_BaseRate_Filing.txt
492
A01040_CoverageLevelDifferential_Filing.txt
6,192
A01050_SubCountyRate_Filing.txt
144
A01060_OptionRate_Filing.txt
3,244
A01100_YieldAndTyield_Filing.txt
10,368
A01105_YieldExclusion_Filing.txt
483
A01130_AreaCoverageLevel_Filing.txt
2,412
A01200_DocumentBuilder_Filing.txt
5,835
2017_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
1,112
A00030_InsuranceOffer_YTD.txt
1,243,991
A00045_Map_YTD.txt
1,967,889
A00050_Quality_YTD.txt
510
A00070_SubsidyPercent_YTD.txt
479
A00200_Date_YTD.txt
1,250,495
A00400_AgrCommodity_YTD.txt
431
A00410_Class_YTD.txt
24
A00420_Commodity_YTD.txt
114
A00430_CommodityType_YTD.txt
339
A00440_County_YTD.txt
3,190
A00450_CroppingPractice_YTD.txt
75
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,014
A00520_State_YTD.txt
50
A00530_SubClass_YTD.txt
6
A00540_Type_YTD.txt
504
A00550_DocumentStructure_YTD.txt
20
A00560_EndorsementLength_YTD.txt
1
A00570_InsuranceOption_YTD.txt
43
A00580_RateMethod_YTD.txt
4
A00590_SpoiGroup_YTD.txt
95
A00615_Draw_YTD.txt
29,500
A00810_Price_YTD.txt
1,268,129
A01000_AgrRate_YTD.txt
9,898,224
A01010_BaseRate_YTD.txt
527,087
A01020_Beta_YTD.txt
121,500
A01030_ComboRevenueFactor_YTD.txt
2,857,140
A01040_CoverageLevelDifferential_YTD.txt
10,959,539
A01050_SubCountyRate_YTD.txt
194,071
A01060_OptionRate_YTD.txt
3,923,276
A01070_Proration_YTD.txt
384
A01090_UnitDiscount_YTD.txt
2,897
A01100_YieldAndTyield_YTD.txt
11,127,004
A01105_YieldExclusion_YTD.txt
615,027
A01110_HistoricalRevenueCapping_YTD.txt
156,294
A01115_HistoricalYieldTrend_YTD.txt
707,750
A01120_AreaDataSource_YTD.txt
124
A01125_ProductionArea_YTD.txt
175,798
A01130_AreaCoverageLevel_YTD.txt
12,182,684
A01135_AreaRate_YTD.txt
13,669,455
A01200_DocumentBuilder_YTD.txt
8,466,300
A01210_Statement_YTD.txt
1,209
USDA is an Equal Opportunity Employer and Provider

   Office

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