Skip to main content

Actuarial Release-Actuarial 15-050

Date
To
All Insurance Providers
From
Chris Aulbur, Chief, Actuarial Branch /s/ Chris Aulbur
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 NameContainsRecord Count
2015_ADM_Daily_151218.zipA01005_AreaRiskRate_Daily.txt800,225
2015_ADM_Filing_0831.zipA00030_InsuranceOffer_Filing.txt93,557
 A00045_Map_Filing.txt1,317,572
 A00200_Date_Filing.txt93,557
 A00810_Price_Filing.txt86,063
 A01000_AgrRate_Filing.txt6,241,608
 A01005_AreaRiskRate_Filing.txt6,564,892
 A01010_BaseRate_Filing.txt19,154
 A01040_CoverageLevelDifferential_Filing.txt589,076
 A01050_SubCountyRate_Filing.txt6,249
 A01060_OptionRate_Filing.txt51,406
 A01070_Proration_Filing.txt384
 A01100_YieldAndTyield_Filing.txt2,378,097
 A01200_DocumentBuilder_Filing.txt470,423
2015_ADM_YTD.zipA00010_AdmLayout_YTD.txt1,049
 A00030_InsuranceOffer_YTD.txt1,191,404
 A00045_Map_YTD.txt1,684,344
 A00050_Quality_YTD.txt518
 A00070_SubsidyPercent_YTD.txt464
 A00200_Date_YTD.txt1,198,043
 A00400_AgrCommodity_YTD.txt405
 A00410_Class_YTD.txt27
 A00420_Commodity_YTD.txt126
 A00430_CommodityType_YTD.txt359
 A00440_County_YTD.txt3,190
 A00450_CroppingPractice_YTD.txt76
 A00460_InsurancePlan_YTD.txt24
 A00470_IntendedUse_YTD.txt12
 A00480_Interval_YTD.txt47
 A00490_IrrigationPractice_YTD.txt3
 A00500_OrganicPractice_YTD.txt3
 A00510_Practice_YTD.txt1,043
 A00520_State_YTD.txt50
 A00530_SubClass_YTD.txt4
 A00540_Type_YTD.txt542
 A00550_DocumentStructure_YTD.txt20
 A00560_EndorsementLength_YTD.txt1
 A00570_InsuranceOption_YTD.txt47
 A00580_RateMethod_YTD.txt4
 A00590_SpoiGroup_YTD.txt83
 A00810_Price_YTD.txt1,034,566
 A01000_AgrRate_YTD.txt6,241,608
 A01005_AreaRiskRate_YTD.txt61,701,500
 A01010_BaseRate_YTD.txt749,203
 A01020_Beta_YTD.txt121,500
 A01030_ComboRevenueFactor_YTD.txt2,827,170
 A01040_CoverageLevelDifferential_YTD.txt10,312,176
 A01050_SubCountyRate_YTD.txt177,763
 A01060_OptionRate_YTD.txt4,040,002
 A01070_Proration_YTD.txt2,739,732
 A01090_UnitDiscount_YTD.txt2,669
 A01100_YieldAndTyield_YTD.txt10,293,875
 A01105_YieldExclusion_YTD.txt420,588
 A01110_HistoricalRevenueCapping_YTD.txt156,804
 A01200_DocumentBuilder_YTD.txt13,962,997
 A01210_Statement_YTD.txt2,916
2016_ADM_Daily_151218.zipA00615_Draw_Daily.txt5,700
 A01005_AreaRiskRate_Daily.txt36,330
2016_ADM_Filing_0430.zipA00030_InsuranceOffer_Filing.txt14,944
 A00045_Map_Filing.txt102,327
 A00200_Date_Filing.txt14,944
 A00810_Price_Filing.txt12,675
 A01005_AreaRiskRate_Filing.txt450,492
 A01010_BaseRate_Filing.txt1,800
 A01040_CoverageLevelDifferential_Filing.txt56,706
 A01050_SubCountyRate_Filing.txt603
 A01060_OptionRate_Filing.txt3,252
 A01100_YieldAndTyield_Filing.txt4,275
 A01200_DocumentBuilder_Filing.txt100,572
2016_ADM_Filing_0630.zipA00030_InsuranceOffer_Filing.txt166,919
 A00045_Map_Filing.txt38,297
 A00200_Date_Filing.txt172,925
 A00810_Price_Filing.txt145,694
 A01005_AreaRiskRate_Filing.txt11,219,335
 A01010_BaseRate_Filing.txt81,159
 A01040_CoverageLevelDifferential_Filing.txt1,469,809
 A01050_SubCountyRate_Filing.txt23,625
 A01060_OptionRate_Filing.txt570,178
 A01100_YieldAndTyield_Filing.txt1,372,480
 A01105_YieldExclusion_Filing.txt120,786
 A01110_HistoricalRevenueCapping_Filing.txt17,742
 A01200_DocumentBuilder_Filing.txt1,587,211
2016_ADM_YTD.zipA00010_AdmLayout_YTD.txt1,072
 A00030_InsuranceOffer_YTD.txt1,474,160
 A00045_Map_YTD.txt1,954,672
 A00050_Quality_YTD.txt538
 A00070_SubsidyPercent_YTD.txt480
 A00200_Date_YTD.txt1,480,817
 A00400_AgrCommodity_YTD.txt400
 A00410_Class_YTD.txt24
 A00420_Commodity_YTD.txt130
 A00430_CommodityType_YTD.txt360
 A00440_County_YTD.txt3,190
 A00450_CroppingPractice_YTD.txt77
 A00460_InsurancePlan_YTD.txt25
 A00470_IntendedUse_YTD.txt12
 A00480_Interval_YTD.txt47
 A00490_IrrigationPractice_YTD.txt3
 A00500_OrganicPractice_YTD.txt3
 A00510_Practice_YTD.txt1,071
 A00520_State_YTD.txt50
 A00530_SubClass_YTD.txt6
 A00540_Type_YTD.txt546
 A00550_DocumentStructure_YTD.txt20
 A00560_EndorsementLength_YTD.txt1
 A00570_InsuranceOption_YTD.txt46
 A00580_RateMethod_YTD.txt4
 A00590_SpoiGroup_YTD.txt92
 A00615_Draw_YTD.txt28,500
 A00810_Price_YTD.txt694,834
 A01000_AgrRate_YTD.txt9,255,456
 A01005_AreaRiskRate_YTD.txt85,979,182
 A01010_BaseRate_YTD.txt755,783
 A01020_Beta_YTD.txt121,500
 A01030_ComboRevenueFactor_YTD.txt2,827,170
 A01040_CoverageLevelDifferential_YTD.txt12,312,169
 A01050_SubCountyRate_YTD.txt177,454
 A01060_OptionRate_YTD.txt4,543,545
 A01070_Proration_YTD.txt2,739,624
 A01090_UnitDiscount_YTD.txt2,801
 A01100_YieldAndTyield_YTD.txt10,558,009
 A01105_YieldExclusion_YTD.txt599,718
 A01110_HistoricalRevenueCapping_YTD.txt156,480
 A01115_HistoricalYieldTrend_YTD.txt23,084
 A01200_DocumentBuilder_YTD.txt17,379,135
 A01210_Statement_YTD.txt22,011