ACTUARIAL RELEASE: Actuarial Release–21-018
United States Department of Agriculture
Farm and Foreign Agricultural Services
Risk Management Agency
1400 Independence Avenue, SW
Stop 0801
Washington, DC 20250-0801
Date
June 16, 2021
To:
All Insurance Providers
From:
Megan Heyns, Chief, Filing Branch /s/ Megan Heyns 6/16/2021
Subject:
Actuarial Release 21-018 - Actuarial Information Available
-
As of June 16, 2021 the following information is now available on the FTP site:
- 2020 Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.
- 2021 Actuarial Data Master for the 6/30, 11/30, 1/31 Filing Date, YTD, and Daily Files.
- 2022 Actuarial Data Master for the 4/30, 6/30 Filing Date, YTD, and Daily Files.
- 2022 Special Provisions for the 6/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.
- 2022 Actuarial Data Master are in the References/Actuarial_Data_Master/2022 directory.
- 2022 Special Provisions are in the Special_Provisions/2022 directory.
Additional notes and details regarding this data release:
2020 RY final county yields, final county revenues, and final county margins are issued for MP corn, soybeans, and rice, reference PM-21-030, 6/30 and 11/30 filings.
2020 RY final county yields and final county revenues are issued for SCO and ARPI plan crops, reference PM 21-030, 11/30 filing.
2021 RY Margin Protection (MP) now has yield year of 2020 records populated on ADM Historical Yield Trend to be used to calculate premium credits, 6/30 and 11/30 filings.
2021 RY ADM Date updated to correct the Insurance Attachment Date for HIP-WI Florida Oranges and Grapefruit, 1/31 filing.
2022 RY ADM Date updated to populate the missing End of Insurance Date for PRH Strawberries in California, 4/30 filing.
2022 RY ADM, Special Provisions, and related files are now issued for the 6/30 filing except crops in the Area Yield, SCO, ECO and HIP-WI plans and Dry Peas plans 01 ,02, 03 and 90, Triticale plan 90, Barley and Wheat plans 01, 02, 03, and Oats plan 90.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_210616.zip A00810_Price_Daily.txt
A01130_AreaCoverageLevel_Daily.txt403,173
3,006,9722020_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.txt190,205
38,613
196,460
187,538
87,582
1,604,374
25,059
719,581
1,837,851
139,539
17,604
725,130
1,219,151
124,8632020_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,027,730
234,337
1,028,381
1,068,266
497,075
9,403,571
186,696
3,954,845
9,157,164
536,646
137,256
4,220,868
6,893,323
873,6642020_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.txt1,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,867,130
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
5,645
14,197,790
1,368
1,000,756
15,9582021_ADM_Daily_210616.zip A00200_Date_Daily.txt
A01115_HistoricalYieldTrend_Daily.txt522
3,0262021_ADM_Filing_0131.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
A01200_DocumentBuilder_Filing.txt313,788
2,115
313,788
208,200
245,049
1,923,897
2,115
826,463
2,747,052
4,603,4342021_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.txt198,279
40,413
204,642
196,152
91,290
1,671,079
26,397
886,087
2,013,300
146,712
17,604
811,338
1,255,684
125,4392021_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,458,518
232,822
1,458,629
1,523,489
500,180
10,345,301
186,209
5,301,476
9,744,050
553,923
137,226
5,145,030
7,297,385
878,4402021_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.txt1,337
2,304,740
4,532,865
563
1,041
2,311,214
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
5,906
15,038,185
1,423
1,006,108
15,9582022_ADM_Daily_210616.zip A00030_InsuranceOffer_Daily.txt
A00045_Map_Daily.txt
A00050_Quality_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
A00470_IntendedUse_Daily.txt
A00510_Practice_Daily.txt
A00540_Type_Daily.txt
A00550_DocumentStructure_Daily.txt
A00570_InsuranceOption_Daily.txt
A00580_RateMethod_Daily.txt
A00590_SpoiGroup_Daily.txt
A01010_BaseRate_Daily.txt
A01020_Beta_Daily.txt
A01030_ComboRevenueFactor_Daily.txt
A01040_CoverageLevelDifferential_Daily.txt
A01050_SubCountyRate_Daily.txt
A01060_OptionRate_Daily.txt
A01090_UnitDiscount_Daily.txt
A01100_YieldAndTyield_Daily.txt
A01105_YieldExclusion_Daily.txt
A01110_HistoricalRevenueCapping_Daily.txt
A01200_DocumentBuilder_Daily.txt
A01210_Statement_Daily.txt
A01220_GuaranteeAdjustment_Daily.txt
A01230_ContiguousCounty_Daily.txt28,891
4,089
65
237
29,539
5
17
34
10
6
4
110
56
4
13
1
9
19,371
3,000
429,570
231,555
3,300
111,441
198
411,642
20,223
840
283,943
184
7,143
2,4922022_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.txt58,749
429,521
58,749
267,704
19,019
258,631
4,173
72,198
5,100
13,671
934,250
499,002
1232022_ADM_Filing_0630.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
A01100_YieldAndTyield_Filing.txt
A01105_YieldExclusion_Filing.txt
A01110_HistoricalRevenueCapping_Filing.txt
A01200_DocumentBuilder_Filing.txt
A01220_GuaranteeAdjustment_Filing.txt28,891
4,089
29,449
19,371
231,555
3,300
111,441
411,642
20,223
840
283,943
7,1432022_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
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
A01105_YieldExclusion_YTD.txt
A01110_HistoricalRevenueCapping_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,307
87,640
433,610
65
438
88,198
12
37
72
3,191
40
18
6
71
3
3
368
50
1
111
16
1
27
3
12
267,704
38,390
4,000
449,550
490,186
7,473
183,639
5,100
237
425,313
20,223
840
934,250
443,952
193
782,945
374
7,266
9,7162022_SPOI_0630.zip 2022 Special Provisions 06/30 Filing Date 2,712