ACTUARIAL RELEASE: Actuarial Release–23-052
United States Department of Agriculture
Farm and Foreign Agricultural Services
Risk Management Agency
1400 Independence Avenue, SW
Stop 0801
Washington, DC 20250-0801
Date
December 20, 2023
To:
All Insurance Providers
From:
Scott Pasche, Chief, Filing Branch /s/ Scott Paschen 12/20/2023
Subject:
Actuarial Release 23-052 - Actuarial Information Available
-
As of December 20, 2023 the following information is now available on the FTP site:
- 2022 Actuarial Data Master for the 11/30 Filing Date, YTD, and Daily Files.
- 2023 Actuarial Data Master for the 11/30 Filing Date, YTD, and Daily Files.
- 2024 Actuarial Data Master for the 8/31, 11/30, 12/31, 1/31 Filing Date, YTD, and Daily Files.
- 2024 Special Provisions for the 1/31 Filing Date.
Users can find this information in the following directories:
- 2022 Actuarial Data Master are in the References/Actuarial_Data_Master/2022 directory.
- 2023 Actuarial Data Master are in the References/Actuarial_Data_Master/2023 directory.
- 2024 Actuarial Data Master are in the References/Actuarial_Data_Master/2024 directory.
- 2024 Special Provisions are in the Special_Provisions/2024 directory.
Additional notes and details regarding this data release:
2024 RY ADM Price updated to issue price volatility for Silage Corn, 11/30 filing.
2024 RY ADM Date updated to correct Cancellation Date and Termination Date for Micro Farm, 8/31 filing.
2022, 2023, & 2024 RY ADM Quality updated with corrections for Flax Quality ID 62, 11/30 filings.
2024 RY ADM and Special Provisions are now issued for the 1/31 filing, except Prices.
2024 RY ADM Prices are issued for the 12/31 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_231219.zip
A00050_Quality_Daily.txt
9
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.txt1,338
2,393,563
4,536,463
564
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
2023_ADM_Daily_231219.zip
A00050_Quality_Daily.txt
9 2023_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
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.txt1,388
2,562,831
5,876,413
564
924
2,731,613
417
31
141
424
3,191
89
36
14
77
3
3
25,764
438,048
1,342
50
6
646
22
64
4
160
1,295,900
4,796,970
11,553,576
910,778
136,000
3,256,740
17,025,370
263,063
7,954,728
2,777,460
3,288
17,897,674
817,509
154,590
655,527
101
219,692
20,205,261
15,480,754
8,845
4
16,428,812
1,458
1,042,954
15,958
2024_ADM_Daily_231220.zip
A00030_InsuranceOffer_Daily.txt
A00045_Map_Daily.txt
A00050_Quality_Daily.txt
A00070_SubsidyPercent_Daily.txt
A00200_Date_Daily.txt
A00420_Commodity_Daily.txt
A00430_CommodityType_Daily.txt
A00480_Interval_Daily.txt
A00510_Practice_Daily.txt
A00540_Type_Daily.txt
A00570_InsuranceOption_Daily.txt
A00810_Price_Daily.txt
A01010_BaseRate_Daily.txt
A01040_CoverageLevelDifferential_Daily.txt
A01050_SubCountyRate_Daily.txt
A01060_OptionRate_Daily.txt
A01070_Proration_Daily.txt
A01090_UnitDiscount_Daily.txt
A01140_HipRate_Daily.txt
A01200_DocumentBuilder_Daily.txt
A01210_Statement_Daily.txt338,154
1,683
9
38
344,436
14
19
1
74
34
7
1,250,559
245,475
1,918,191
1,683
906,770
2,817,420
2
1,745
4,605,312
92
2024_ADM_Filing_0131.zip
A00030_InsuranceOffer_Filing.txt
A00045_Map_Filing.txt
A00200_Date_Filing.txt
A01010_BaseRate_Filing.txt
A01040_CoverageLevelDifferential_Filing.txt
A01050_SubCountyRate_Filing.txt
A01060_OptionRate_Filing.txt
A01070_Proration_Filing.txt
A01200_DocumentBuilder_Filing.txt338,154
1,683
338,154
245,475
1,918,191
1,683
906,770
2,817,420
4,605,312
2024_ADM_Filing_0831.zip
A00030_InsuranceOffer_Filing.txt
A00045_Map_Filing.txt
A00200_Date_Filing.txt
A00810_Price_Filing.txt
A01000_AgrRate_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
A01105_YieldExclusion_Filing.txt
A01130_AreaCoverageLevel_Filing.txt
A01200_DocumentBuilder_Filing.txt
A01220_GuaranteeAdjustment_Filing.txt360,695
5,141,244
360,643
2,624,656
11,557,080
39,339
2,012,618
9,048
280,854
384
4,872,795
23,154
12,957,741
1,754,494
1322024_ADM_Filing_1130.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.txt1,545,867
283,414
1,546,638
1,250,637
525,950
11,284,540
244,061
5,777,944
11,685,500
667,800
136,416
5,356,356
7,657,260
922,6962024_ADM_Filing_1231.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
A01130_AreaCoverageLevel_Filing.txt
A01200_DocumentBuilder_Filing.txt
A01220_GuaranteeAdjustment_Filing.txt1,446
192
1,446
1,353
537
7,551
117
4,837
13,731
651
3,264
6,312
828
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
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.txt1,373
2,681,727
6,716,589
564
957
2,689,319
417
31
146
429
3,192
100
37
14
86
3
3
25,764
438,048
1,425
50
6
662
22
1
67
4
172
4,040,700
4,949,201
11,557,080
941,702
145,500
3,956,490
17,894,070
291,998
8,326,061
2,864,052
4,133
19,216,015
886,458
154,530
637,588
101
220,452
22,144,357
16,646,341
8,966
2
16,553,124
1,497
1,065,958
15,9642024_SPOI_0131.zip
2024 Special Provisions 01/31 Filing Date
3,748