ACTUARIAL RELEASE: Actuarial Release–23-016
United States Department of Agriculture
Farm and Foreign Agricultural Services
Risk Management Agency
1400 Independence Avenue, SW
Stop 0801
Washington, DC 20250-0801
Date
April 28, 2023
To:
All Insurance Providers
From:
Megan Heyns, Chief, Filing Branch /s/ Megan Heyns 4/28/2023
Subject:
Actuarial Release 23-016 - Actuarial Information Available
-
As of April 28, 2023 the following information is now available on the FTP site:
- 2021 Actuarial Data Master for the 8/31 Filing Date, YTD, and Daily Files.
- 2022 Actuarial Data Master for the 8/31, 10/31 Filing Date, YTD, and Daily Files.
- 2024 Actuarial Data Master for the 4/30 Filing Date, YTD, and Daily Files.
- 2024 Special Provisions for the 4/30 Filing Date.
Users can find this information in the following directories:
- 2021 Actuarial Data Master are in the References/Actuarial_Data_Master/2021 directory.
- 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.
- 2024 Special Provisions are in the Special_Provisions/2024 directory.
Additional notes and details regarding this data release:
RY 2021 ADM Area Coverage Level and ADM Price updated to issue final county yields and payment factors for SCO commodities, reference PM-23-020, 8/31 filings.
RY 2022 ADM Area Coverage Level and ADM Price updated to issue final county yields and payment factors for SCO commodities, reference PM-23-020, 8/31 and 10/31 filings.
RY 2024 ADM and Special Provisions are now issued for Annual Forage, LGM, and LRP, 4/30 filing.
RY 2024 ADM now issued for HIP-WI, 4/30 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 2021_ADM_Daily_230427.zip
A00810_Price_Daily.txt
A01130_AreaCoverageLevel_Daily.txt44,225
2,424
2021_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.txt263,266
3,822,381
263,266
1,953,572
11,365,296
29,225
1,486,699
7,719
177,974
384
2,915,340
19,341
9,648,693
1,255,457
132
2021_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,337
2,304,740
4,532,865
563
1,041
2,311,736
416
29
139
383
3,191
93
33
14
77
3
3
1,345
50
6
599
22
1
60
4
148
1,086,600
4,159,266
11,365,296
891,159
121,500
2,927,070
15,768,062
226,778
7,292,666
2,752,536
3,226
14,805,527
722,973
154,830
681,870
96
180,843
16,563,749
15,336,416
6,255
6
15,038,185
1,423
1,006,108
15,958
2022_ADM_Daily_230427.zip
A00810_Price_Daily.txt
A01130_AreaCoverageLevel_Daily.txt54,503
133,236
2022_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.txt269,957
3,822,486
269,957
1,953,959
11,559,008
29,414
1,539,798
7,824
191,757
384
3,075,942
21,255
9,649,881
1,311,256
132
2022_ADM_Filing_1031.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
7,842
5,433
7,842
9,333
4,635
61,479
60
18,124
91,218
1,425
19,968
37,335
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
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,704
2
14,931,819
1,423
1,015,831
15,958
2024_ADM_Daily_230427.zip
A00030_InsuranceOffer_Daily.txt
A00045_Map_Daily.txt
A00070_SubsidyPercent_Daily.txt
A00200_Date_Daily.txt
A00410_Class_Daily.txt
A00420_Commodity_Daily.txt
A00430_CommodityType_Daily.txt
A00450_CroppingPractice_Daily.txt
A00460_InsurancePlan_Daily.txt
A00480_Interval_Daily.txt
A00510_Practice_Daily.txt
A00540_Type_Daily.txt
A00550_DocumentStructure_Daily.txt
A00560_EndorsementLength_Daily.txt
A00570_InsuranceOption_Daily.txt
A00810_Price_Daily.txt
A01040_CoverageLevelDifferential_Daily.txt
A01060_OptionRate_Daily.txt
A01130_AreaCoverageLevel_Daily.txt
A01135_AreaRate_Daily.txt
A01140_HipRate_Daily.txt
A01200_DocumentBuilder_Daily.txt
A01210_Statement_Daily.txt
A01230_ContiguousCounty_Daily.txt77,222
1,219,820
69
77,222
3
7
10
12
4
70
187
22
1
1
2
736,904
251,370
128,845
2,701,030
1,281,509
311
537,983
40
2,933
2024_ADM_Filing_0430.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
A01070_Proration_Filing.txt
A01100_YieldAndTyield_Filing.txt
A01130_AreaCoverageLevel_Filing.txt
A01200_DocumentBuilder_Filing.txt
A01220_GuaranteeAdjustment_Filing.txt
97,023
1,225,043
97,023
756,497
19,001
422,791
5,223
165,800
5,100
13,869
2,701,030
698,293
147
2024_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
A00030_InsuranceOffer_YTD.txt
A00045_Map_YTD.txt
A00070_SubsidyPercent_YTD.txt
A00200_Date_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
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
A01130_AreaCoverageLevel_YTD.txt
A01135_AreaRate_YTD.txt
A01140_HipRate_YTD.txt
A01200_DocumentBuilder_YTD.txt
A01210_Statement_YTD.txt
A01220_GuaranteeAdjustment_YTD.txt
A01230_ContiguousCounty_YTD.txt1,373
97,023
1,225,043
181
97,023
7
20
39
3,192
38
11
2
79
3
3
321
50
1
56
11
1
15
2
3
756,497
19,001
1,000
19,980
422,791
5,223
165,800
5,100
39
13,869
2,701,030
1,281,509
311
698,293
188
147
7,224
2024_SPOI_0430.zip
2024 Special Provisions 04/30 Filing Date 2,002