Skip to main content

Actuarial Release-Actuarial Release–24-019

Date
To
All Insurance Providers
From
Scott Paschen, Chief, Filing Branch /s/ Scott Paschen 6/13/2024
Subject
Actuarial Release 24-019 - Actuarial Information Available

As of June 13, 2024 the following information is now available on the FTP site:

  • 2023 Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.
  • 2024 Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.
  • 2025 Actuarial Data Master for the 4/30 Filing Date, YTD, and Daily Files. 

Users can find this information in the following directories:

  • 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.
  • 2025 Actuarial Data Master are in the References/Actuarial_Data_Master/2025 directory. 

Additional notes and details regarding this data release:

2023 RY final county yields, final county revenues, and final county margins are issued for MP Corn, Soybeans, and Rice, reference PM-24-034, 6/30 and 11/30 filings.
2023 RY final county yields and final county revenues are issued for SCO, ECO and ARPI plan crops, reference PM 24-034, 11/30 filing.
2024 RY ADM Historical Yield Trend updated to populate yield year of 2023 records for Margin Protection (MP) to be used to calculate premium credits, 6/30 and 11/30 filings.
2025 RY ADM Layout updated with Price Factor and changes to the LGM record types.

Please notify your data processing representative that this information is available for downloading. For questions regarding the actuarial information, please contact Scott Paschen by phone at 816-926-7589 or via email to scott.paschen@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

   

2023_ADM_Daily_240613.zip

A00810_Price_Daily.txt

1,855,640

 

A01130_AreaCoverageLevel_Daily.txt

3,761,676

   
   

2023_ADM_Filing_0630.zip

A00030_InsuranceOffer_Filing.txt

284,328

 

A00045_Map_Filing.txt

41,040

 

A00200_Date_Filing.txt

291,735

 

A00810_Price_Filing.txt

283,599

 

A01010_BaseRate_Filing.txt

94,404

 

A01040_CoverageLevelDifferential_Filing.txt

1,904,913

 

A01050_SubCountyRate_Filing.txt

29,442

 

A01060_OptionRate_Filing.txt

1,043,785

 

A01100_YieldAndTyield_Filing.txt

2,224,332

 

A01105_YieldExclusion_Filing.txt

166,710

 

A01110_HistoricalRevenueCapping_Filing.txt

18,084

 

A01130_AreaCoverageLevel_Filing.txt

992,904

 

A01200_DocumentBuilder_Filing.txt

1,536,453

 

A01220_GuaranteeAdjustment_Filing.txt

129,117

   
   

2023_ADM_Filing_1130.zip

A00030_InsuranceOffer_Filing.txt

1,524,741

 

A00045_Map_Filing.txt

255,115

 

A00200_Date_Filing.txt

1,579,261

 

A00810_Price_Filing.txt

1,572,041

 

A01010_BaseRate_Filing.txt

516,764

 

A01040_CoverageLevelDifferential_Filing.txt

10,940,517

 

A01050_SubCountyRate_Filing.txt

215,876

 

A01060_OptionRate_Filing.txt

5,674,229

 

A01100_YieldAndTyield_Filing.txt

10,965,490

 

A01105_YieldExclusion_Filing.txt

627,087

 

A01110_HistoricalRevenueCapping_Filing.txt

136,506

 

A01130_AreaCoverageLevel_Filing.txt

5,301,420

 

A01200_DocumentBuilder_Filing.txt

8,066,855

 

A01220_GuaranteeAdjustment_Filing.txt

911,596

   
   

2023_ADM_YTD.zip

A00010_AdmLayout_YTD.txt

1,388

 

A00030_InsuranceOffer_YTD.txt

2,562,831

 

A00045_Map_YTD.txt

5,876,653

 

A00050_Quality_YTD.txt

564

 

A00070_SubsidyPercent_YTD.txt

924

 

A00200_Date_YTD.txt

2,731,613

 

A00400_AgrCommodity_YTD.txt

417

 

A00410_Class_YTD.txt

31

 

A00420_Commodity_YTD.txt

141

 

A00430_CommodityType_YTD.txt

424

 

A00440_County_YTD.txt

3,191

 

A00450_CroppingPractice_YTD.txt

89

 

A00460_InsurancePlan_YTD.txt

36

 

A00470_IntendedUse_YTD.txt

14

 

A00480_Interval_YTD.txt

77

 

A00490_IrrigationPractice_YTD.txt

3

 

A00500_OrganicPractice_YTD.txt

3

 

A00505_PaceDate_YTD.txt

25,764

 

A00506_PaceRate_YTD.txt

438,048

 

A00510_Practice_YTD.txt

1,342

 

A00520_State_YTD.txt

50

 

A00530_SubClass_YTD.txt

6

 

A00540_Type_YTD.txt

646

 

A00550_DocumentStructure_YTD.txt

22

 

A00570_InsuranceOption_YTD.txt

64

 

A00580_RateMethod_YTD.txt

4

 

A00590_SpoiGroup_YTD.txt

160

 

A00615_Draw_YTD.txt

1,295,900

 

A00810_Price_YTD.txt

4,796,970

 

A01000_AgrRate_YTD.txt

11,553,576

 

A01010_BaseRate_YTD.txt

910,778

 

A01020_Beta_YTD.txt

136,000

 

A01030_ComboRevenueFactor_YTD.txt

3,256,740

 

A01040_CoverageLevelDifferential_YTD.txt

17,025,370

 

A01050_SubCountyRate_YTD.txt

263,063

 

A01060_OptionRate_YTD.txt

7,954,728

 

A01070_Proration_YTD.txt

2,777,460

 

A01090_UnitDiscount_YTD.txt

3,288

 

A01100_YieldAndTyield_YTD.txt

17,897,674

 

A01105_YieldExclusion_YTD.txt

817,509

 

A01110_HistoricalRevenueCapping_YTD.txt

154,590

 

A01115_HistoricalYieldTrend_YTD.txt

655,527

 

A01120_AreaDataSource_YTD.txt

101

 

A01125_ProductionArea_YTD.txt

219,692

 

A01130_AreaCoverageLevel_YTD.txt

20,205,261

 

A01135_AreaRate_YTD.txt

15,480,754

 

A01140_HipRate_YTD.txt

8,845

 

A01145_HipTriggeringEvent_YTD.txt

4

 

A01200_DocumentBuilder_YTD.txt

16,428,812

 

A01210_Statement_YTD.txt

1,458

 

A01220_GuaranteeAdjustment_YTD.txt

1,042,954

 

A01230_ContiguousCounty_YTD.txt

15,958

   
   

2024_ADM_Daily_240613.zip

A01115_HistoricalYieldTrend_Daily.txt

6,762

   
   

2024_ADM_Filing_0630.zip

A00030_InsuranceOffer_Filing.txt

323,542

 

A00045_Map_Filing.txt

43,404

 

A00200_Date_Filing.txt

330,415

 

A00810_Price_Filing.txt

319,690

 

A01010_BaseRate_Filing.txt

101,719

 

A01040_CoverageLevelDifferential_Filing.txt

2,144,957

 

A01050_SubCountyRate_Filing.txt

31,770

 

A01060_OptionRate_Filing.txt

1,158,466

 

A01100_YieldAndTyield_Filing.txt

2,493,683

 

A01105_YieldExclusion_Filing.txt

191,742

 

A01110_HistoricalRevenueCapping_Filing.txt

18,114

 

A01130_AreaCoverageLevel_Filing.txt

1,096,608

 

A01200_DocumentBuilder_Filing.txt

1,749,994

 

A01220_GuaranteeAdjustment_Filing.txt

140,973

   
   

2024_ADM_Filing_1130.zip

A00030_InsuranceOffer_Filing.txt

1,545,867

 

A00045_Map_Filing.txt

285,610

 

A00200_Date_Filing.txt

1,546,638

 

A00810_Price_Filing.txt

1,592,636

 

A01010_BaseRate_Filing.txt

525,950

 

A01040_CoverageLevelDifferential_Filing.txt

11,302,825

 

A01050_SubCountyRate_Filing.txt

246,257

 

A01060_OptionRate_Filing.txt

5,779,753

 

A01100_YieldAndTyield_Filing.txt

11,685,500

 

A01105_YieldExclusion_Filing.txt

667,800

 

A01110_HistoricalRevenueCapping_Filing.txt

136,416

 

A01130_AreaCoverageLevel_Filing.txt

5,359,596

 

A01200_DocumentBuilder_Filing.txt

7,657,260

 

A01220_GuaranteeAdjustment_Filing.txt

922,696

   
   

2024_ADM_YTD.zip

A00010_AdmLayout_YTD.txt

1,373

 

A00030_InsuranceOffer_YTD.txt

2,711,843

 

A00045_Map_YTD.txt

6,718,785

 

A00050_Quality_YTD.txt

564

 

A00070_SubsidyPercent_YTD.txt

957

 

A00200_Date_YTD.txt

2,719,435

 

A00400_AgrCommodity_YTD.txt

417

 

A00410_Class_YTD.txt

31

 

A00420_Commodity_YTD.txt

147

 

A00430_CommodityType_YTD.txt

429

 

A00440_County_YTD.txt

3,192

 

A00450_CroppingPractice_YTD.txt

100

 

A00460_InsurancePlan_YTD.txt

37

 

A00470_IntendedUse_YTD.txt

14

 

A00480_Interval_YTD.txt

86

 

A00490_IrrigationPractice_YTD.txt

3

 

A00500_OrganicPractice_YTD.txt

3

 

A00505_PaceDate_YTD.txt

25,764

 

A00506_PaceRate_YTD.txt

438,048

 

A00510_Practice_YTD.txt

1,426

 

A00520_State_YTD.txt

50

 

A00530_SubClass_YTD.txt

6

 

A00540_Type_YTD.txt

663

 

A00550_DocumentStructure_YTD.txt

22

 

A00560_EndorsementLength_YTD.txt

1

 

A00570_InsuranceOption_YTD.txt

67

 

A00580_RateMethod_YTD.txt

4

 

A00590_SpoiGroup_YTD.txt

172

 

A00615_Draw_YTD.txt

4,082,700

 

A00810_Price_YTD.txt

5,358,610

 

A01000_AgrRate_YTD.txt

11,557,080

 

A01010_BaseRate_YTD.txt

958,719

 

A01020_Beta_YTD.txt

145,500

 

A01030_ComboRevenueFactor_YTD.txt

3,956,490

 

A01040_CoverageLevelDifferential_YTD.txt

18,044,618

 

A01050_SubCountyRate_YTD.txt

294,194

 

A01060_OptionRate_YTD.txt

8,382,001

 

A01070_Proration_YTD.txt

3,068,256

 

A01090_UnitDiscount_YTD.txt

4,133

 

A01100_YieldAndTyield_YTD.txt

19,216,015

 

A01105_YieldExclusion_YTD.txt

886,458

 

A01110_HistoricalRevenueCapping_YTD.txt

154,530

 

A01115_HistoricalYieldTrend_YTD.txt

644,350

 

A01120_AreaDataSource_YTD.txt

101

 

A01125_ProductionArea_YTD.txt

220,452

 

A01130_AreaCoverageLevel_YTD.txt

22,147,651

 

A01135_AreaRate_YTD.txt

16,649,635

 

A01140_HipRate_YTD.txt

9,736

 

A01145_HipTriggeringEvent_YTD.txt

2

 

A01200_DocumentBuilder_YTD.txt

16,944,619

 

A01210_Statement_YTD.txt

1,502

 

A01220_GuaranteeAdjustment_YTD.txt

1,065,958

 

A01230_ContiguousCounty_YTD.txt

15,964

   
   

2025_ADM_Daily_240613.zip

A00010_AdmLayout_Daily.txt

126

   
   

2025_ADM_YTD.zip

A00010_AdmLayout_YTD.txt

1,447

 

A00030_InsuranceOffer_YTD.txt

130,294

 

A00045_Map_YTD.txt

1,225,043

 

A00070_SubsidyPercent_YTD.txt

179

 

A00200_Date_YTD.txt

130,120

 

A00410_Class_YTD.txt

7

 

A00420_Commodity_YTD.txt

20

 

A00430_CommodityType_YTD.txt

48

 

A00440_County_YTD.txt

3,194

 

A00450_CroppingPractice_YTD.txt

41

 

A00460_InsurancePlan_YTD.txt

11

 

A00470_IntendedUse_YTD.txt

2

 

A00480_Interval_YTD.txt

79

 

A00490_IrrigationPractice_YTD.txt

3

 

A00500_OrganicPractice_YTD.txt

3

 

A00510_Practice_YTD.txt

323

 

A00520_State_YTD.txt

50

 

A00530_SubClass_YTD.txt

1

 

A00540_Type_YTD.txt

64

 

A00550_DocumentStructure_YTD.txt

11

 

A00560_EndorsementLength_YTD.txt

1

 

A00570_InsuranceOption_YTD.txt

17

 

A00580_RateMethod_YTD.txt

2

 

A00590_SpoiGroup_YTD.txt

3

 

A00810_Price_YTD.txt

756,587

 

A01010_BaseRate_YTD.txt

51,905

 

A01020_Beta_YTD.txt

1,000

 

A01030_ComboRevenueFactor_YTD.txt

19,998

 

A01040_CoverageLevelDifferential_YTD.txt

653,514

 

A01050_SubCountyRate_YTD.txt

5,223

 

A01060_OptionRate_YTD.txt

241,846

 

A01070_Proration_YTD.txt

399,948

 

A01090_UnitDiscount_YTD.txt

136

 

A01100_YieldAndTyield_YTD.txt

14,472

 

A01130_AreaCoverageLevel_YTD.txt

2,701,030

 

A01135_AreaRate_YTD.txt

1,281,509

 

A01140_HipRate_YTD.txt

348

 

A01200_DocumentBuilder_YTD.txt

1,429,833

 

A01210_Statement_YTD.txt

189

 

A01220_GuaranteeAdjustment_YTD.txt

147

 

A01230_ContiguousCounty_YTD.txt

15,160