ACTUARIAL RELEASE: Actuarial Release23-048




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

Date

November 17, 2023

To:

All Insurance Providers

From:

Megan Heyns, Chief, Filing Branch /s/ Megan Heyns    11/17/2023

Subject:

Actuarial Release 23-048 - Actuarial Information Available

As of November 17, 2023 the following information is now available on the FTP site:

  • 2024 Actuarial Data Master for the 11/30 Filing Date, YTD, and Daily Files.
  • 2024 Special Provisions for the 11/30 Filing Date. 

Users can find this information in the following directories:

  • 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 and Special Provisions are now released for Dry Peas (NE), Dry Beans (CO, NE, WY), Sesame, and Sweet Potato 11/30 filing.
2024 RY ADM Price records issued for 11/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
2024_ADM_Daily_231117.zip
A00030_InsuranceOffer_Daily.txt
A00045_Map_Daily.txt
A00070_SubsidyPercent_Daily.txt
A00200_Date_Daily.txt
A00430_CommodityType_Daily.txt
A00450_CroppingPractice_Daily.txt
A00510_Practice_Daily.txt
A00540_Type_Daily.txt
A00810_Price_Daily.txt
A01010_BaseRate_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
A01115_HistoricalYieldTrend_Daily.txt
A01125_ProductionArea_Daily.txt
A01130_AreaCoverageLevel_Daily.txt
A01135_AreaRate_Daily.txt
A01200_DocumentBuilder_Daily.txt
A01210_Statement_Daily.txt
A01220_GuaranteeAdjustment_Daily.txt
13,881
6,636
20
13,881
1
2
6
1
1,244,358
5,763
39,960
88,512
750
37,383
45
208,725
6,174
1,815
173
40,590
48,630
77,130
9
8,334
2024_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.txt
1,545,867
283,414
1,546,638
1,245,789
525,950
11,284,540
244,061
5,777,944
11,685,500
667,800
136,416
5,356,356
7,657,260
922,696
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.txt
1,373
2,343,573
6,714,906
555
919
2,351,165
417
31
132
410
3,192
100
37
14
85
3
3
25,764
438,048
1,351
50
6
628
22
1
60
4
172
4,040,700
4,943,000
11,557,080
696,227
145,500
3,956,490
15,975,879
290,315
7,419,291
46,632
4,131
19,216,015
886,458
154,530
637,588
101
220,452
22,144,357
16,646,341
7,221
2
11,947,812
1,405
1,065,958
15,964
2024_SPOI_1130.zip
2024 Special Provisions 11/30 Filing Date 18,070
     
USDA is an Equal Opportunity Employer and Provider