Date
To
All Insurance Providers
From
Scott Paschen, Chief, Filing Branch /s/ Scott Paschen 8/29/2024
Subject
Actuarial Release 24-034 - Actuarial Information Available
As of August 29, 2024 the following information is now available on the FTP site:
- 2024 Actuarial Data Master for the 4/30, 8/31 Filing Date, YTD, and Daily Files.
- 2025 Actuarial Data Master for the 8/31 Filing Date, YTD, and Daily Files.
Users can find this information in the following directories:
- 2024 Actuarial Data Master are in the References/Actuarial_Data_Master/2024 directory.
- 2025 Actuarial Data Master are in the References/Actuarial_Data_Master/2025 directory.
Additional notes and details regarding this data release:
2024 RY ADM Price and Area Coverage Level updated to populate final index values and payment factors for Annual Forage, Apiculture, and PRF intervals with an ending month of June, reference PM-24-053, 4/30 and 8/31 filings.
2025 RY ADM Option Rate update for Apples, 8/31 filing.
Please notify your data processing representative that this information is available for downloading. For questions regarding the actuarial information, please contact Scott Paschen by phone at 816-926-7589 or via email to scott.paschen@usda.gov
Archived release bulletins are located online at www.rma.usda.gov/Policy-and-Procedure/Bulletins-and-Memos/Actuarial-Releases
File Name | Contains | Record Count |
2024_ADM_Daily_240828.zip | A00810_Price_Daily.txt | 3,301,619 |
A01130_AreaCoverageLevel_Daily.txt | 1,357,445 | |
2024_ADM_Filing_0430.zip | A00030_InsuranceOffer_Filing.txt | 101,196 |
A00045_Map_Filing.txt | 1,241,183 | |
A00200_Date_Filing.txt | 101,196 | |
A00810_Price_Filing.txt | 764,693 | |
A01010_BaseRate_Filing.txt | 22,430 | |
A01040_CoverageLevelDifferential_Filing.txt | 447,538 | |
A01050_SubCountyRate_Filing.txt | 5,223 | |
A01060_OptionRate_Filing.txt | 165,800 | |
A01070_Proration_Filing.txt | 46,248 | |
A01100_YieldAndTyield_Filing.txt | 13,869 | |
A01130_AreaCoverageLevel_Filing.txt | 2,709,100 | |
A01200_DocumentBuilder_Filing.txt | 723,331 | |
A01220_GuaranteeAdjustment_Filing.txt | 147 | |
2024_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt | 360,695 |
A00045_Map_Filing.txt | 5,141,244 | |
A00200_Date_Filing.txt | 360,643 | |
A00810_Price_Filing.txt | 2,624,656 | |
A01000_AgrRate_Filing.txt | 11,557,080 | |
A01010_BaseRate_Filing.txt | 39,339 | |
A01040_CoverageLevelDifferential_Filing.txt | 2,012,618 | |
A01050_SubCountyRate_Filing.txt | 9,048 | |
A01060_OptionRate_Filing.txt | 280,854 | |
A01070_Proration_Filing.txt | 384 | |
A01100_YieldAndTyield_Filing.txt | 4,872,795 | |
A01105_YieldExclusion_Filing.txt | 23,154 | |
A01130_AreaCoverageLevel_Filing.txt | 12,957,741 | |
A01200_DocumentBuilder_Filing.txt | 1,754,494 | |
A01220_GuaranteeAdjustment_Filing.txt | 132 | |
2024_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,373 |
A00030_InsuranceOffer_YTD.txt | 2,711,843 | |
A00045_Map_YTD.txt | 6,718,785 | |
A00050_Quality_YTD.txt | 564 | |
A00070_SubsidyPercent_YTD.txt | 957 | |
A00200_Date_YTD.txt | 2,719,435 | |
A00400_AgrCommodity_YTD.txt | 417 | |
A00410_Class_YTD.txt | 31 | |
A00420_Commodity_YTD.txt | 147 | |
A00430_CommodityType_YTD.txt | 429 | |
A00440_County_YTD.txt | 3,192 | |
A00450_CroppingPractice_YTD.txt | 100 | |
A00460_InsurancePlan_YTD.txt | 37 | |
A00470_IntendedUse_YTD.txt | 14 | |
A00480_Interval_YTD.txt | 86 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00505_PaceDate_YTD.txt | 25,764 | |
A00506_PaceRate_YTD.txt | 438,048 | |
A00510_Practice_YTD.txt | 1,426 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 6 | |
A00540_Type_YTD.txt | 663 | |
A00550_DocumentStructure_YTD.txt | 22 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 67 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 172 | |
A00615_Draw_YTD.txt | 4,082,700 | |
A00810_Price_YTD.txt | 5,358,610 | |
A01000_AgrRate_YTD.txt | 11,557,080 | |
A01010_BaseRate_YTD.txt | 958,719 | |
A01020_Beta_YTD.txt | 145,500 | |
A01030_ComboRevenueFactor_YTD.txt | 3,956,490 | |
A01040_CoverageLevelDifferential_YTD.txt | 18,044,618 | |
A01050_SubCountyRate_YTD.txt | 294,194 | |
A01060_OptionRate_YTD.txt | 8,382,001 | |
A01070_Proration_YTD.txt | 3,068,256 | |
A01090_UnitDiscount_YTD.txt | 4,133 | |
A01100_YieldAndTyield_YTD.txt | 19,216,015 | |
A01105_YieldExclusion_YTD.txt | 886,458 | |
A01110_HistoricalRevenueCapping_YTD.txt | 154,530 | |
A01115_HistoricalYieldTrend_YTD.txt | 644,350 | |
A01120_AreaDataSource_YTD.txt | 101 | |
A01125_ProductionArea_YTD.txt | 220,452 | |
A01130_AreaCoverageLevel_YTD.txt | 22,147,651 | |
A01135_AreaRate_YTD.txt | 16,649,635 | |
A01140_HipRate_YTD.txt | 10,987 | |
A01145_HipTriggeringEvent_YTD.txt | 5 | |
A01200_DocumentBuilder_YTD.txt | 16,944,619 | |
A01210_Statement_YTD.txt | 1,502 | |
A01220_GuaranteeAdjustment_YTD.txt | 1,065,958 | |
A01230_ContiguousCounty_YTD.txt | 15,964 | |
2025_ADM_Daily_240828.zip | A01060_OptionRate_Daily.txt | 408 |
2025_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt | 381,732 |
A00045_Map_Filing.txt | 5,146,707 | |
A00200_Date_Filing.txt | 381,678 | |
A00810_Price_Filing.txt | 2,647,539 | |
A01000_AgrRate_Filing.txt | 11,550,960 | |
A01010_BaseRate_Filing.txt | 41,613 | |
A01040_CoverageLevelDifferential_Filing.txt | 2,069,654 | |
A01050_SubCountyRate_Filing.txt | 9,168 | |
A01060_OptionRate_Filing.txt | 319,673 | |
A01070_Proration_Filing.txt | 456 | |
A01100_YieldAndTyield_Filing.txt | 5,179,338 | |
A01105_YieldExclusion_Filing.txt | 26,091 | |
A01130_AreaCoverageLevel_Filing.txt | 13,008,687 | |
A01200_DocumentBuilder_Filing.txt | 1,758,060 | |
A01220_GuaranteeAdjustment_Filing.txt | 132 | |
2025_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,457 |
A00030_InsuranceOffer_YTD.txt | 853,768 | |
A00045_Map_YTD.txt | 6,424,946 | |
A00050_Quality_YTD.txt | 272 | |
A00070_SubsidyPercent_YTD.txt | 612 | |
A00200_Date_YTD.txt | 860,422 | |
A00400_AgrCommodity_YTD.txt | 417 | |
A00410_Class_YTD.txt | 24 | |
A00420_Commodity_YTD.txt | 95 | |
A00430_CommodityType_YTD.txt | 322 | |
A00440_County_YTD.txt | 3,194 | |
A00450_CroppingPractice_YTD.txt | 75 | |
A00460_InsurancePlan_YTD.txt | 32 | |
A00470_IntendedUse_YTD.txt | 11 | |
A00480_Interval_YTD.txt | 84 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 914 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 5 | |
A00540_Type_YTD.txt | 483 | |
A00550_DocumentStructure_YTD.txt | 23 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 47 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 63 | |
A00810_Price_YTD.txt | 3,658,514 | |
A01000_AgrRate_YTD.txt | 11,550,960 | |
A01010_BaseRate_YTD.txt | 202,659 | |
A01020_Beta_YTD.txt | 49,000 | |
A01030_ComboRevenueFactor_YTD.txt | 1,939,806 | |
A01040_CoverageLevelDifferential_YTD.txt | 4,971,985 | |
A01050_SubCountyRate_YTD.txt | 46,386 | |
A01060_OptionRate_YTD.txt | 1,864,131 | |
A01070_Proration_YTD.txt | 400,404 | |
A01090_UnitDiscount_YTD.txt | 2,138 | |
A01100_YieldAndTyield_YTD.txt | 7,966,377 | |
A01105_YieldExclusion_YTD.txt | 226,962 | |
A01110_HistoricalRevenueCapping_YTD.txt | 18,114 | |
A01115_HistoricalYieldTrend_YTD.txt | 140,221 | |
A01120_AreaDataSource_YTD.txt | 43 | |
A01125_ProductionArea_YTD.txt | 83,859 | |
A01130_AreaCoverageLevel_YTD.txt | 16,694,923 | |
A01135_AreaRate_YTD.txt | 5,852,695 | |
A01140_HipRate_YTD.txt | 3,352 | |
A01145_HipTriggeringEvent_YTD.txt | 2 | |
A01200_DocumentBuilder_YTD.txt | 4,919,800 | |
A01210_Statement_YTD.txt | 951 | |
A01220_GuaranteeAdjustment_YTD.txt | 144,684 | |
A01230_ContiguousCounty_YTD.txt | 24,307 |