Actuarial Release Bulletin 12-008

TO:

All Insurance Providers

Chris Aulbur

/s/ Ronald Mackenzie

FROM:

Chief, Actuarial Branch

SUBJECT:

Actuarial Release 12-008 - Actuarial Information Available

As of March 01, 2012 the following information is now available on the FTP site:


•	2012 Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.

Users can find this information in the following directories:


•	2012 Actuarial Data Master are in the References/Actuarial_Data_Master/2012 directory.

Additional notes and details regarding this data release:

2012 Prices and Volatilities are updated, reference PM-12-009; 6/30 and 11/30 filings.
2012 ADM Area Risk Rate updated for expected revenue amounts based on price's release for corn, grain sorghum, soybeans, and spring wheat; 11/30 filing.
2012 ADM Date updated for irrigated cotton 2 Oklahoma counties final planting dates, reference MGR-12-002; 11/30 filing.

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

2012_ADM_Daily_120301.zip	A00200_Date_Daily.txt	18
	A00810_Price_Daily.txt	196,511
	A01005_AreaRiskRate_Daily.txt	30,040


2012_ADM_Filing_0630.zip	A00010_AdmLayout_Filing.txt	991
	A00030_InsuranceOffer_Filing.txt	140,550
	A00045_Map_Filing.txt	1,488,536
	A00050_Quality_Filing.txt	212
	A00070_SubsidyPercent_Filing.txt	140
	A00200_Date_Filing.txt	145,920
	A00410_Class_Filing.txt	9
	A00420_Commodity_Filing.txt	16
	A00430_CommodityType_Filing.txt	41
	A00440_County_Filing.txt	2,806
	A00450_CroppingPractice_Filing.txt	12
	A00460_InsurancePlan_Filing.txt	9
	A00470_IntendedUse_Filing.txt	2
	A00480_Interval_Filing.txt	22
	A00490_IrrigationPractice_Filing.txt	3
	A00500_OrganicPractice_Filing.txt	3
	A00510_Practice_Filing.txt	156
	A00520_State_Filing.txt	45
	A00530_SubClass_Filing.txt	2
	A00540_Type_Filing.txt	61
	A00810_Price_Filing.txt	137,157
	A01005_AreaRiskRate_Filing.txt	7,527,345
	A01010_BaseRate_Filing.txt	76,449
	A01020_Beta_Filing.txt	37,000
	A01030_ComboRevenueFactor_Filing.txt	739,260
	A01040_CoverageLevelDifferential_Filing.txt	890,330
	A01050_SubCountyRate_Filing.txt	21,654
	A01060_OptionRate_Filing.txt	288,762
	A01090_UnitDiscount_Filing.txt	3,707
	A01100_YieldAndTyield_Filing.txt	938,454
	A01110_HistoricalRevenueCapping_Filing.txt	17,184
	A01200_DocumentBuilder_Filing.txt	1,071,393
	A01210_Statement_Filing.txt	250


2012_ADM_Filing_1130.zip	A00010_AdmLayout_Filing.txt	991
	A00030_InsuranceOffer_Filing.txt	359,084
	A00045_Map_Filing.txt	193,853
	A00050_Quality_Filing.txt	453
	A00070_SubsidyPercent_Filing.txt	215
	A00200_Date_Filing.txt	359,504
	A00410_Class_Filing.txt	14
	A00420_Commodity_Filing.txt	47
	A00430_CommodityType_Filing.txt	121
	A00440_County_Filing.txt	2,810
	A00450_CroppingPractice_Filing.txt	31
	A00460_InsurancePlan_Filing.txt	10
	A00470_IntendedUse_Filing.txt	7
	A00480_Interval_Filing.txt	1
	A00490_IrrigationPractice_Filing.txt	3
	A00500_OrganicPractice_Filing.txt	3
	A00510_Practice_Filing.txt	494
	A00520_State_Filing.txt	49
	A00530_SubClass_Filing.txt	2
	A00540_Type_Filing.txt	180
	A00810_Price_Filing.txt	341,681
	A01005_AreaRiskRate_Filing.txt	1,018,468
	A01010_BaseRate_Filing.txt	349,415
	A01020_Beta_Filing.txt	90,000
	A01030_ComboRevenueFactor_Filing.txt	1,948,050
	A01040_CoverageLevelDifferential_Filing.txt	2,884,679
	A01050_SubCountyRate_Filing.txt	123,793
	A01060_OptionRate_Filing.txt	1,576,193
	A01090_UnitDiscount_Filing.txt	2,522
	A01100_YieldAndTyield_Filing.txt	4,312,550
	A01110_HistoricalRevenueCapping_Filing.txt	134,880
	A01200_DocumentBuilder_Filing.txt	4,212,265
	A01210_Statement_Filing.txt	508


File Name	Contains	Record Count

2012_ADM_YTD.zip	A00010_AdmLayout_YTD.txt	991
	A00030_InsuranceOffer_YTD.txt	758,130
	A00045_Map_YTD.txt	1,697,959
	A00050_Quality_YTD.txt	523
	A00070_SubsidyPercent_YTD.txt	309
	A00200_Date_YTD.txt	763,920
	A00400_AgrCommodity_YTD.txt	399
	A00410_Class_YTD.txt	26
	A00420_Commodity_YTD.txt	135
	A00430_CommodityType_YTD.txt	342
	A00440_County_YTD.txt	3,188
	A00450_CroppingPractice_YTD.txt	75
	A00460_InsurancePlan_YTD.txt	20
	A00470_IntendedUse_YTD.txt	10
	A00480_Interval_YTD.txt	46
	A00490_IrrigationPractice_YTD.txt	3
	A00500_OrganicPractice_YTD.txt	3
	A00510_Practice_YTD.txt	1,035
	A00520_State_YTD.txt	50
	A00530_SubClass_YTD.txt	4
	A00540_Type_YTD.txt	509
	A00810_Price_YTD.txt	521,802
	A01000_AgrRate_YTD.txt	1,136,526
	A01005_AreaRiskRate_YTD.txt	8,546,653
	A01010_BaseRate_YTD.txt	685,834
	A01020_Beta_YTD.txt	121,000
	A01030_ComboRevenueFactor_YTD.txt	2,567,430
	A01040_CoverageLevelDifferential_YTD.txt	5,580,357
	A01050_SubCountyRate_YTD.txt	155,563
	A01060_OptionRate_YTD.txt	2,581,430
	A01070_Proration_YTD.txt	2,742,828
	A01090_UnitDiscount_YTD.txt	5,020
	A01100_YieldAndTyield_YTD.txt	7,014,134
	A01110_HistoricalRevenueCapping_YTD.txt	152,064
	A01200_DocumentBuilder_YTD.txt	10,742,832
	A01210_Statement_YTD.txt	1,165