Date
To
All Insurance Providers
From
Megan Heyns, Chief, Filing Branch
Subject
Actuarial Release 23-042 - Actuarial Information Available
As of October 16, 2023 the following information is now available on the FTP site:
- 2022 Actuarial Data Master for the 2/28 Filing Date, YTD, and Daily Files.
- 2024 Actuarial Data Master for the 6/30 Filing Date, YTD, and Daily Files.
Users can find this information in the following directories:
- 2022 Actuarial Data Master are in the References/Actuarial_Data_Master/2022 directory.
- 2024 Actuarial Data Master are in the References/Actuarial_Data_Master/2024 directory.
Additional notes and details regarding this data release:
2024 RY ADM Price updated with projected prices and volatility factors for barley, oats, and wheat, reference PM-23-062, 6/30 filing. 2022 RY ADM Area Coverage Level and ADM Price updated to issue payment landings for Oysters, reference PM-23-063, 2/28 filing.
Please notify your data processing representative that this information is available for downloading. For questions regarding the actuarial information, please contact Megan Heyns by phone at (816) 926-5636, or via email to megan.heyns@rma.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 |
| 2022_ADM_Daily_231016.zip | A00810_Price_Daily.txt A01130_AreaCoverageLevel_Daily.txt | 9 54 |
| 2022_ADM_Filing_0228.zip | A00030_InsuranceOffer_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt | 9 9 9 54 54 27 |
| 2022_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 A00505_PaceDate_YTD.txt A00506_PaceRate_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 A00615_Draw_YTD.txt A00810_Price_YTD.txt A01000_AgrRate_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 A01115_HistoricalYieldTrend_YTD.txt A01120_AreaDataSource_YTD.txt A01125_ProductionArea_YTD.txt A01130_AreaCoverageLevel_YTD.txt A01135_AreaRate_YTD.txt A01140_HipRate_YTD.txt A01145_HipTriggeringEvent_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt A01220_GuaranteeAdjustment_YTD.txt A01230_ContiguousCounty_YTD.txt | 1,338 2,393,563 4,536,463 555 975 2,400,949 418 31 140 381 3,191 93 36 14 77 3 3 13,597 206,208 1,351 50 6 601 22 1 61 4 151 1,251,900 4,112,405 11,559,008 891,056 121,500 2,967,030 16,008,282 227,831 7,466,160 2,754,780 3,274 15,735,810 744,147 154,590 630,885 99 219,573 16,760,909 14,773,471 6,782 2 14,931,819 1,423 1,015,831 15,958 |
| 2024_ADM_Daily_231016.zip | A00810_Price_Daily.txt | 306,564 |
| 2024_ADM_Filing_0630.zip | A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01105_YieldExclusion_Filing.txt A01110_HistoricalRevenueCapping_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt A01220_GuaranteeAdjustment_Filing.txt | 323,542 43,404 330,415 306,564 101,719 2,144,957 31,770 1,155,394 2,493,683 191,742 18,114 1,096,608 1,749,994 140,973 |
| 2024_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 A00615_Draw_YTD.txt A00810_Price_YTD.txt A01000_AgrRate_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 A01115_HistoricalYieldTrend_YTD.txt A01120_AreaDataSource_YTD.txt A01125_ProductionArea_YTD.txt A01130_AreaCoverageLevel_YTD.txt A01135_AreaRate_YTD.txt A01140_HipRate_YTD.txt A01145_HipTriggeringEvent_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt A01220_GuaranteeAdjustment_YTD.txt A01230_ContiguousCounty_YTD.txt | 1,373 797,829 6,431,300 272 603 804,650 417 21 96 319 3,192 75 31 11 85 3 3 913 50 5 478 22 1 44 4 66 4,040,700 3,689,562 11,557,080 171,309 49,500 2,418,030 4,696,863 46,137 1,633,438 46,632 1,394 7,552,871 218,007 18,114 347,077 47 116,034 16,784,737 5,996,797 2,465 2 4,291,554 958 142,434 15,964 |