ACTUARIAL RELEASE: Actuarial Release15-050




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

Date

December 18, 2015

To:

All Insurance Providers

From:

Chris Aulbur Chief, Actuarial Branch /s/ Chris Aulbur    12/18/2015

Subject:

Actuarial Release 15-050 - Actuarial Information Available
As of December 18, 2015 the following information is now available on the FTP site:
  • 2015 Actuarial Data Master for the 8/31 Filing Date, YTD, and Daily Files.
  • 2016 Actuarial Data Master for the 4/30, 6/30 Filing Date, YTD, and Daily Files
Users can find this information in the following directories:
  • 2015 Actuarial Data Master are in the References/Actuarial_Data_Master/2015 directory.
  • 2016 Actuarial Data Master are in the References/Actuarial_Data_Master/2016 directory.

Additional notes and details regarding this data release:

2015 and 2016 ADM Area Risk Rate updated final indices on intervals with an ending month of October for PRF/Apiculture and Annual Forage respectively, reference PM-15-063.
2016 Margin Protection ADM Draw updated on 5700 rows as InputCostDrawQuantity values for soybeans were set equal to corn previously, 6/30 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-1137, or via email to ronald.tilly@rma.usda.gov

Archived release bulletins are located online at Actuarial Bulletins.

File Name Contains Record Count
2015_ADM_Daily_151218.zip A01005_AreaRiskRate_Daily.txt 800,225
2015_ADM_Filing_0831.zip A00030_InsuranceOffer_Filing.txt 93,557
A00045_Map_Filing.txt 1,317,572
A00200_Date_Filing.txt 93,557
A00810_Price_Filing.txt 86,063
A01000_AgrRate_Filing.txt 6,241,608
A01005_AreaRiskRate_Filing.txt 6,564,892
A01010_BaseRate_Filing.txt 19,154
A01040_CoverageLevelDifferential_Filing.txt 589,076
A01050_SubCountyRate_Filing.txt 6,249
A01060_OptionRate_Filing.txt 51,406
A01070_Proration_Filing.txt 384
A01100_YieldAndTyield_Filing.txt 2,378,097
A01200_DocumentBuilder_Filing.txt 470,423
2015_ADM_YTD.zip A00010_AdmLayout_YTD.txt 1,049
A00030_InsuranceOffer_YTD.txt 1,191,404
A00045_Map_YTD.txt 1,684,344
A00050_Quality_YTD.txt 518
A00070_SubsidyPercent_YTD.txt 464
A00200_Date_YTD.txt 1,198,043
A00400_AgrCommodity_YTD.txt 405
A00410_Class_YTD.txt 27
A00420_Commodity_YTD.txt 126
A00430_CommodityType_YTD.txt 359
A00440_County_YTD.txt 3,190
A00450_CroppingPractice_YTD.txt 76
A00460_InsurancePlan_YTD.txt 24
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,043
A00520_State_YTD.txt 50
A00530_SubClass_YTD.txt 4
A00540_Type_YTD.txt 542
A00550_DocumentStructure_YTD.txt 20
A00560_EndorsementLength_YTD.txt 1
A00570_InsuranceOption_YTD.txt 47
A00580_RateMethod_YTD.txt 4
A00590_SpoiGroup_YTD.txt 83
A00810_Price_YTD.txt 1,034,566
A01000_AgrRate_YTD.txt 6,241,608
A01005_AreaRiskRate_YTD.txt 61,701,500
A01010_BaseRate_YTD.txt 749,203
A01020_Beta_YTD.txt 121,500
A01030_ComboRevenueFactor_YTD.txt 2,827,170
A01040_CoverageLevelDifferential_YTD.txt 10,312,176
A01050_SubCountyRate_YTD.txt 177,763
A01060_OptionRate_YTD.txt 4,040,002
A01070_Proration_YTD.txt 2,739,732
A01090_UnitDiscount_YTD.txt 2,669
A01100_YieldAndTyield_YTD.txt 10,293,875
A01105_YieldExclusion_YTD.txt 420,588
A01110_HistoricalRevenueCapping_YTD.txt 156,804
A01200_DocumentBuilder_YTD.txt 13,962,997
A01210_Statement_YTD.txt 2,916
2016_ADM_Daily_151218.zip A00615_Draw_Daily.txt 5,700
A01005_AreaRiskRate_Daily.txt 36,330
2016_ADM_Filing_0430.zip A00030_InsuranceOffer_Filing.txt 14,944
A00045_Map_Filing.txt 102,327
A00200_Date_Filing.txt 14,944
A00810_Price_Filing.txt 12,675
A01005_AreaRiskRate_Filing.txt 450,492
A01010_BaseRate_Filing.txt 1,800
A01040_CoverageLevelDifferential_Filing.txt 56,706
A01050_SubCountyRate_Filing.txt 603
A01060_OptionRate_Filing.txt 3,252
A01100_YieldAndTyield_Filing.txt 4,275
A01200_DocumentBuilder_Filing.txt 100,572
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 145,694
A01005_AreaRiskRate_Filing.txt 11,219,335
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_YTD.zip A00010_AdmLayout_YTD.txt 1,072
A00030_InsuranceOffer_YTD.txt 1,474,160
A00045_Map_YTD.txt 1,954,672
A00050_Quality_YTD.txt 538
A00070_SubsidyPercent_YTD.txt 480
A00200_Date_YTD.txt 1,480,817
A00400_AgrCommodity_YTD.txt 400
A00410_Class_YTD.txt 24
A00420_Commodity_YTD.txt 130
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,071
A00520_State_YTD.txt 50
A00530_SubClass_YTD.txt 6
A00540_Type_YTD.txt 546
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 28,500
A00810_Price_YTD.txt 694,834
A01000_AgrRate_YTD.txt 9,255,456
A01005_AreaRiskRate_YTD.txt 85,979,182
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,169
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,084
A01200_DocumentBuilder_YTD.txt 17,379,135
A01210_Statement_YTD.txt 22,011
USDA is an Equal Opportunity Employer and Provider