Date
To
All Insurance Providers
From
Chris Aulbur, Chief, Actuarial Branch /s/ Chris Aulbur
Subject
Actuarial Release 15-017 - Actuarial Information Available
As of April 15, 2015 the following information is now available on the FTP site:
- 2014 Actuarial Data Master for the 11/30 Filing Date, YTD, and Daily Files.
- 2015 Actuarial Data Master for the 4/30, 8/31 Filing Date, YTD, and Daily Files.
Users can find this information in the following directories:
- 2014 Actuarial Data Master are in the References/Actuarial_Data_Master/2014 directory.
- 2015 Actuarial Data Master are in the References/Actuarial_Data_Master/2015 directory.
Additional notes and details regarding this data release:
2014 ARPI ARPI final county yields and final county revenues on corn, grain sorghum, and soybeans are issued via ADM Area Risk Rate, reference PM-15-017, 11/30 filing.
2014 ADM Price updated to show corn silage harvest price equal to the projected price on insurance plans 05 & 06, 11/30 filing.
2015 ADM Area Risk Rate updated final indices on interval 636 with an ending month of January on Annual Forage (ANF) and interval 625 with an ending month of February for ANF/PRF/Apiculture, reference PM-15-018.
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 |
|---|---|---|
| 2014_ADM_Daily_150415.zip | A00810_Price_Daily.txt A01005_AreaRiskRate_Daily.txt | 1,512 187,296 |
| 2014_ADM_Filing_1130.zip | A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01005_AreaRiskRate_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01110_HistoricalRevenueCapping_Filing.txt A01200_DocumentBuilder_Filing.txt | 435,176 229,229 435,854 477,020 3,970,200 395,126 4,394,092 141,475 1,983,402 5,851,690 139,758 5,843,543 |
2014_ADM_YTD.zip | A00010_AdmLayout_YTD.txt A00030_InsuranceOffer_YTD.txt A00045_Map_YTD.txt A00050_Quality_YTD.txt A00070_SubsidyPercent_YTD.txt A00200_Date_YTD.txt A00400_AgrCommodity_YTD.txt A00410_Class_YTD.txt A00420_Commodity_YTD.txt A00430_CommodityType_YTD.txt A00440_County_YTD.txt A00450_CroppingPractice_YTD.txt A00460_InsurancePlan_YTD.txt A00470_IntendedUse_YTD.txt A00480_Interval_YTD.txt A00490_IrrigationPractice_YTD.txt A00500_OrganicPractice_YTD.txt A00510_Practice_YTD.txt A00520_State_YTD.txt A00530_SubClass_YTD.txt A00540_Type_YTD.txt A00550_DocumentStructure_YTD.txt A00560_EndorsementLength_YTD.txt A00570_InsuranceOption_YTD.txt A00580_RateMethod_YTD.txt A00590_SpoiGroup_YTD.txt A00810_Price_YTD.txt A01000_AgrRate_YTD.txt A01005_AreaRiskRate_YTD.txt A01010_BaseRate_YTD.txt A01020_Beta_YTD.txt A01030_ComboRevenueFactor_YTD.txt A01040_CoverageLevelDifferential_YTD.txt A01050_SubCountyRate_YTD.txt A01060_OptionRate_YTD.txt A01070_Proration_YTD.txt A01090_UnitDiscount_YTD.txt A01100_YieldAndTyield_YTD.txt A01110_HistoricalRevenueCapping_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt | 987 855,984 1,681,194 517 368 862,596 399 26 127 357 3,188 76 20 12 47 3 3 1,050 50 4 541 20 1 45 4 51 684,313 1,135,674 11,892,864 725,809 121,500 2,667,330 7,386,876 175,003 3,033,881 2,739,948 1,517 9,062,626 156,804 12,662,839 1,160 |
2015_ADM_Daily_150415.zip | A01005_AreaRiskRate_Daily.txt | 321,070 |
2015_ADM_Filing_0430.zip | A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01005_AreaRiskRate_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01200_DocumentBuilder_Filing.txt | 14,053 89,279 14,053 11,784 785,416 1,791 52,734 603 3,153 3,738 83,086 |
| 2015_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01000_AgrRate_Filing.txt A01005_AreaRiskRate_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01070_Proration_Filing.txt A01100_YieldAndTyield_Filing.txt A01200_DocumentBuilder_Filing.txt | 93,557 1,317,572 93,557 86,063 6,241,608 6,564,892 19,154 589,076 6,249 51,406 384 2,378,097 470,423 |
| 2015_ADM_YTD.zip | A00010_AdmLayout_YTD.txt A00030_InsuranceOffer_YTD.txt A00045_Map_YTD.txt A00050_Quality_YTD.txt A00070_SubsidyPercent_YTD.txt A00200_Date_YTD.txt A00400_AgrCommodity_YTD.txt A00410_Class_YTD.txt A00420_Commodity_YTD.txt A00430_CommodityType_YTD.txt A00440_County_YTD.txt A00450_CroppingPractice_YTD.txt A00460_InsurancePlan_YTD.txt A00470_IntendedUse_YTD.txt A00480_Interval_YTD.txt A00490_IrrigationPractice_YTD.txt A00500_OrganicPractice_YTD.txt A00510_Practice_YTD.txt A00520_State_YTD.txt A00530_SubClass_YTD.txt A00540_Type_YTD.txt A00550_DocumentStructure_YTD.txt A00560_EndorsementLength_YTD.txt A00570_InsuranceOption_YTD.txt A00580_RateMethod_YTD.txt A00590_SpoiGroup_YTD.txt A00810_Price_YTD.txt A01000_AgrRate_YTD.txt A01005_AreaRiskRate_YTD.txt A01010_BaseRate_YTD.txt A01020_Beta_YTD.txt A01030_ComboRevenueFactor_YTD.txt A01040_CoverageLevelDifferential_YTD.txt A01050_SubCountyRate_YTD.txt A01060_OptionRate_YTD.txt A01070_Proration_YTD.txt A01090_UnitDiscount_YTD.txt A01100_YieldAndTyield_YTD.txt A01105_YieldExclusion_YTD.txt A01110_HistoricalRevenueCapping_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt | ,1049 1,191,398 1,684,344 517 464 1,198,037 405 27 126 359 3,190 76 24 12 47 3 3 1,043 50 4 542 20 1 47 4 83 1,033,741 6,241,608 61,701,500 749,203 121,500 2,827,170 10,312,176 177,763 4,040,002 2,739,732 2,669 10,293,875 420,588 156,804 13,962,909 2,916 |