ACTUARIAL RELEASE: Actuarial Release15-049




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

Date

December 16, 2015

To:

All Insurance Providers

From:

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

Subject:

Actuarial Release 15-049 - Actuarial Information Available
As of December 16, 2015 the following information is now available on the FTP site:
  • 2015 Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.
  • 2016 Actuarial Data Master for the 8/31, 12/31, 1/31 Filing Date, YTD, and Daily Files.
  • 2016 Special Provisions for the 1/31 Filing Date.
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.
  • 2016 Special Provisions are in the Special_Provisions/2016 directory. 

Additional notes and details regarding this data release:

2015 ADM Price updated for dry pea and dry bean revenue endorsement harvest prices, reference PM-15-062, 6/30 and 11/30 filings.
2016 Special Provisions, ADM, and related files are now released for the 1/31 filing. The ADM Price will be issued later for Florida citrus and Florida fruit trees.
2016 ADM Price now issued for the December 31 contract change commodities of fresh market tomatoes and safflower.
2016 WFRP additional commodities added to California's Sacramento Valley region 6 expansion counties (011, 021, 067, 095, 101, and 103) to match Butte, Yolo, and Yuba counties (14,686 inserted rows into ADM AGR-Rate), 8/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-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_151216.zip A00810_Price_Daily.txt 9,342
2015_ADM_Filing_0630.zip A00030_InsuranceOffer_Filing.txt 103,257
A00045_Map_Filing.txt 38,037
A00200_Date_Filing.txt 109,245
A00810_Price_Filing.txt 104,901
A01005_AreaRiskRate_Filing.txt 3,592,206
A01010_BaseRate_Filing.txt 77,706
A01040_CoverageLevelDifferential_Filing.txt 892,896
A01050_SubCountyRate_Filing.txt 23,655
A01060_OptionRate_Filing.txt 337,586
A01100_YieldAndTyield_Filing.txt 1,232,154
A01110_HistoricalRevenueCapping_Filing.txt 17,190
A01200_DocumentBuilder_Filing.txt 1,093,065
2015_ADM_Filing_1130.zip A00030_InsuranceOffer_Filing.txt 745,769
A00045_Map_Filing.txt 232,040
A00200_Date_Filing.txt 746,420
A00810_Price_Filing.txt 808,088
A01005_AreaRiskRate_Filing.txt 50,758,986
A01010_BaseRate_Filing.txt 415,784
A01040_CoverageLevelDifferential_Filing.txt 7,110,613
A01050_SubCountyRate_Filing.txt 144,166
A01060_OptionRate_Filing.txt 2,972,066
A01100_YieldAndTyield_Filing.txt 6,593,468
A01105_YieldExclusion_Filing.txt 420,588
A01110_HistoricalRevenueCapping_Filing.txt 139,614
A01200_DocumentBuilder_Filing.txt 6,892,284
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_151216.zip A00030_InsuranceOffer_Daily.txt 228,468
A00045_Map_Daily.txt 1,296
A00200_Date_Daily.txt 228,468
A00420_Commodity_Daily.txt 11
A00430_CommodityType_Daily.txt 20
A00450_CroppingPractice_Daily.txt 2
A00510_Practice_Daily.txt 51
A00540_Type_Daily.txt 42
A00570_InsuranceOption_Daily.txt 3
A00810_Price_Daily.txt 9,291
A01000_AgrRate_Daily.txt 14,688
A01010_BaseRate_Daily.txt 228,468
A01040_CoverageLevelDifferential_Daily.txt 1,605,849
A01050_SubCountyRate_Daily.txt 1,296
A01060_OptionRate_Daily.txt 658,572
A01070_Proration_Daily.txt 2,739,240
A01090_UnitDiscount_Daily.txt 1
A01200_DocumentBuilder_Daily.txt 5,818,401
A01210_Statement_Daily.txt 72
2016_ADM_Filing_0131.zip A00030_InsuranceOffer_Filing.txt 228,468
A00045_Map_Filing.txt 1,296
A00200_Date_Filing.txt 228,468
A00810_Price_Filing.txt 8,397
A01010_BaseRate_Filing.txt 228,468
A01040_CoverageLevelDifferential_Filing.txt 1,605,849
A01050_SubCountyRate_Filing.txt 1,296
A01060_OptionRate_Filing.txt 658,572
A01070_Proration_Filing.txt 2,739,240
A01200_DocumentBuilder_Filing.txt 5,818,401
2016_ADM_Filing_0831.zip A00030_InsuranceOffer_Filing.txt 168,244
A00045_Map_Filing.txt 1,590,039
A00200_Date_Filing.txt 168,244
A00810_Price_Filing.txt 341,100
A01000_AgrRate_Filing.txt 9,255,456
A01005_AreaRiskRate_Filing.txt 7,142,467
A01010_BaseRate_Filing.txt 19,247
A01040_CoverageLevelDifferential_Filing.txt 971,310
A01050_SubCountyRate_Filing.txt 3,432
A01060_OptionRate_Filing.txt 85,388
A01070_Proration_Filing.txt 384
A01100_YieldAndTyield_Filing.txt 2,252,082
A01105_YieldExclusion_Filing.txt 11,238
A01200_DocumentBuilder_Filing.txt 918,792
2016_ADM_Filing_1231.zip A00030_InsuranceOffer_Filing.txt 894
A00045_Map_Filing.txt 453
A00200_Date_Filing.txt 894
A00810_Price_Filing.txt 894
A01005_AreaRiskRate_Filing.txt 2,412
A01010_BaseRate_Filing.txt 492
A01040_CoverageLevelDifferential_Filing.txt 6,192
A01050_SubCountyRate_Filing.txt 144
A01060_OptionRate_Filing.txt 3,214
A01100_YieldAndTyield_Filing.txt 10,260
A01105_YieldExclusion_Filing.txt 402
A01200_DocumentBuilder_Filing.txt 8,065
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
2016_SPOI_0131.zip 2016 Special Provisions 01/31 Filing Date 3,040
USDA is an Equal Opportunity Employer and Provider