Actuarial Release Bulletin 18-013

TO:

All Insurance Providers

Zachary White

/s/ Zachary White

FROM:

Chief, Actuarial Branch

SUBJECT:

Actuarial Release 18-013 - Actuarial Information Available

As of March 13, 2018 the following information is now available on the FTP site:


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

Users can find this information in the following directories:


•	2018 Actuarial Data Master are in the References/Actuarial_Data_Master/2018 directory.
•	2018 Special Provisions are in the Special_Provisions/2018 directory.

Additional notes and details regarding this data release:

2018 Annual Forage final indices and payment factors issued on interval 636 for Growing Seasons 1 and 2 with an ending month of January, reference PM-18-016.

2018 ADM Date revised on Combo and SCO cotton, and ADM Document Builder revised on Combo cotton (including SPOI) for 56 counties in AL, GA, and SC to correct the final planting date to May 25 and add statement 25248. No changes to the End of Late Planting Period Date and Late Planting Period reduced from 15 to 10 days.

Please notify your data processing representative that this information is available for downloading. For questions regarding the actuarial information, please contact Ron Tilly by phone at (816) 926-1337, or via email to

ronald.tilly@rma.usda.gov. Archived release bulletins are located online at

https://www.rma.usda.gov/bulletins/actuarial/.


File Name	Contains	Record Count

2018_ADM_Daily_180313.zip	A00200_Date_Daily.txt	3,024
	A00810_Price_Daily.txt	16,140
	A01130_AreaCoverageLevel_Daily.txt	80,700
	A01200_DocumentBuilder_Daily.txt	1,512


2018_ADM_Filing_0430.zip	A00030_InsuranceOffer_Filing.txt	23,939
	A00045_Map_Filing.txt	441,423
	A00200_Date_Filing.txt	23,939
	A00810_Price_Filing.txt	207,578
	A01010_BaseRate_Filing.txt	1,911
	A01040_CoverageLevelDifferential_Filing.txt	95,813
	A01050_SubCountyRate_Filing.txt	603
	A01060_OptionRate_Filing.txt	3,539
	A01100_YieldAndTyield_Filing.txt	6,783
	A01130_AreaCoverageLevel_Filing.txt	894,610
	A01200_DocumentBuilder_Filing.txt	154,755
	A01220_GuaranteeAdjustment_Filing.txt	183


2018_ADM_Filing_1130.zip	A00030_InsuranceOffer_Filing.txt	887,120
	A00045_Map_Filing.txt	213,653
	A00200_Date_Filing.txt	887,771
	A00810_Price_Filing.txt	961,343
	A01010_BaseRate_Filing.txt	419,549
	A01040_CoverageLevelDifferential_Filing.txt	8,412,792
	A01050_SubCountyRate_Filing.txt	160,795
	A01060_OptionRate_Filing.txt	3,243,686
	A01100_YieldAndTyield_Filing.txt	7,581,728
	A01105_YieldExclusion_Filing.txt	478,074
	A01110_HistoricalRevenueCapping_Filing.txt	138,498
	A01130_AreaCoverageLevel_Filing.txt	3,985,032
	A01200_DocumentBuilder_Filing.txt	5,880,385
	A01220_GuaranteeAdjustment_Filing.txt	813,187


2018_ADM_YTD.zip	A00010_AdmLayout_YTD.txt	1,140
	A00030_InsuranceOffer_YTD.txt	1,585,673
	A00045_Map_YTD.txt	4,524,059
	A00050_Quality_YTD.txt	530
	A00070_SubsidyPercent_YTD.txt	501
	A00200_Date_YTD.txt	1,592,507
	A00400_AgrCommodity_YTD.txt	435
	A00410_Class_YTD.txt	24
	A00420_Commodity_YTD.txt	128
	A00430_CommodityType_YTD.txt	364
	A00440_County_YTD.txt	3,190
	A00450_CroppingPractice_YTD.txt	82
	A00460_InsurancePlan_YTD.txt	25
	A00470_IntendedUse_YTD.txt	12
	A00480_Interval_YTD.txt	41
	A00490_IrrigationPractice_YTD.txt	3
	A00500_OrganicPractice_YTD.txt	3
	A00510_Practice_YTD.txt	1,114
	A00520_State_YTD.txt	50
	A00530_SubClass_YTD.txt	6
	A00540_Type_YTD.txt	552
	A00550_DocumentStructure_YTD.txt	21
	A00560_EndorsementLength_YTD.txt	1
	A00570_InsuranceOption_YTD.txt	49
	A00580_RateMethod_YTD.txt	4
	A00590_SpoiGroup_YTD.txt	103
	A00615_Draw_YTD.txt	24,022,100
	A00810_Price_YTD.txt	3,495,091
	A01000_AgrRate_YTD.txt	10,747,415
	A01010_BaseRate_YTD.txt	771,607
	A01020_Beta_YTD.txt	121,500
	A01030_ComboRevenueFactor_YTD.txt	2,857,140
	A01040_CoverageLevelDifferential_YTD.txt	13,210,970
	A01050_SubCountyRate_YTD.txt	191,605
	A01060_OptionRate_YTD.txt	4,764,292
	A01070_Proration_YTD.txt	2,738,688
	A01090_UnitDiscount_YTD.txt	2,851
	A01100_YieldAndTyield_YTD.txt	11,391,731
	A01105_YieldExclusion_YTD.txt	624,090
	A01110_HistoricalRevenueCapping_YTD.txt	156,186
	A01115_HistoricalYieldTrend_YTD.txt	799,388
	A01120_AreaDataSource_YTD.txt	128
	A01125_ProductionArea_YTD.txt	177,946
	A01130_AreaCoverageLevel_YTD.txt	15,257,677
	A01135_AreaRate_YTD.txt	11,507,018
	A01200_DocumentBuilder_YTD.txt	13,720,315
	A01210_Statement_YTD.txt	1,292
	A01220_GuaranteeAdjustment_YTD.txt	997,825


2018_SPOI_1130.zip	2018 Special Provisions 11/30 Filing Date	15,970