ACTUARIAL RELEASE: Actuarial Release22-020




1400 Independence Avenue, SW
Stop 0801
Washington, DC  20250-0801

Date

April 29, 2022

To:

All Insurance Providers

From:

Megan Heyns, Chief, Filing Branch /s/ Megan Heyns    4/29/2022

Subject:

Actuarial Release 22-020 - Actuarial Information Available

As of April 29, 2022 the following information is now available on the FTP site:

  • 2020 Actuarial Data Master for the 8/31 Filing Date, YTD, and Daily Files.
  • 2021 Actuarial Data Master for the 8/31, 10/31 Filing Date, YTD, and Daily Files.
  • 2023 Actuarial Data Master for the 4/30 Filing Date, YTD, and Daily Files.
  • 2023 Special Provisions for the 4/30 Filing Date.

Users can find this information in the following directories:

  • 2020 Actuarial Data Master are in the References/Actuarial_Data_Master/2020 directory.
  • 2021 Actuarial Data Master are in the References/Actuarial_Data_Master/2021 directory.
  • 2023 Actuarial Data Master are in the References/Actuarial_Data_Master/2023 directory.
  • 2023 Special Provisions are in the Special_Provisions/2023 directory.

Additional notes and details regarding this data release:

RY 2023 ADM and Special Provisions are now issued for DRP, LGM, and LRP, 4/30 filing.
RY 2021 ADM Area Coverage Level and ADM Price updated to issue final county yields and payment factors for SCO commodities, reference PM-22-031, 8/31 and 10/31 filings.
RY 2020 ADM Area Coverage Level and ADM Price updated to issue final county yields and payment factors for SCO commodities, reference PM-22-031, 8/31 filings.

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 https://www.rma.usda.gov/Policy-and-Procedure/Bulletins-and-Memos/Actuarial-Releases

File Name Contains Record Count
2020_ADM_Daily_220428.zip A00810_Price_Daily.txt
A01130_AreaCoverageLevel_Daily.txt
303
1,818
2020_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.txt
255,616
3,817,935
259,270
1,947,818
11,331,024
24,770
1,400,326
3,273
158,270
384
2,216,220
14,169
9,641,763
1,209,788
132
2020_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
A01200_DocumentBuilder_YTD.txt
A01210_Statement_YTD.txt
A01220_GuaranteeAdjustment_YTD.txt
A01230_ContiguousCounty_YTD.txt
1,311
1,825,334
4,524,603
555
906
1,835,894
412
28
135
376
3,191
94
27
14
54
3
3
1,212
50
6
583
21
1
57
4
106
4,481,700
3,693,114
11,331,024
862,976
121,500
2,877,120
14,515,000
217,929
5,725,732
2,747,436
4,181
13,335,105
693,135
154,860
636,463
96
179,727
15,545,369
11,959,714
6,400
14,197,790
1,368
1,000,756
15,958
2021_ADM_Daily_220428.zip A00810_Price_Daily.txt
A01130_AreaCoverageLevel_Daily.txt
18,666
132,204
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.txt
263,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_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,836
5,433
7,836
7,179
4,632
61,428
60
18,113
86,337
1,425
19,944
37,791
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,233
6
15,038,185
1,423
1,006,108
15,958
2023_ADM_Daily_220428.zip A00030_InsuranceOffer_Daily.txt
A00070_SubsidyPercent_Daily.txt
A00200_Date_Daily.txt
A00410_Class_Daily.txt
A00420_Commodity_Daily.txt
A00430_CommodityType_Daily.txt
A00440_County_Daily.txt
A00460_InsurancePlan_Daily.txt
A00480_Interval_Daily.txt
A00510_Practice_Daily.txt
A00520_State_Daily.txt
A00540_Type_Daily.txt
A00550_DocumentStructure_Daily.txt
A01040_CoverageLevelDifferential_Daily.txt
A01200_DocumentBuilder_Daily.txt
A01210_Statement_Daily.txt
19,800
57
19,800
3
6
12
1,821
3
54
110
20
22
1
3,200
189,200
28
2023_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
59,507
430,571
59,507
267,584
18,989
258,391
5,223
72,228
5,100
13,002
934,250
506,999
123
2023_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
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.txt
1,363
59,507
430,571
172
59,507
7
19
38
3,191
30
11
2
71
3
3
257
50
1
54
11
14
2
3
267,584
18,989
1,000
19,980
258,391
5,223
72,228
5,100
39
13,002
934,250
443,952
193
506,999
186
123
7,224
2023_SPOI_0430.zip 2023 Special Provisions 04/30 Filing Date 1,974
     
USDA is an Equal Opportunity Employer and Provider