2021 Crop Insurance Decision Tool gets released

(Editor’s note: Gary Schnitkey, Ryan Batts, Krista Swanson, Nick Paulson are faculty members of the University of Illinois’ Department of Agricultural and Consumer Economics and Carl Zulauf is a professor at Ohio State University’s Department of Agricultural, Environmental and Development Economics. This article was initially published on farmdoc daily on Jan. 19.)

The 2021 Crop Insurance Decision Tool has been released to aid in crop insurance decisions. It is a Microsoft Excel workbook that can be downloaded from farmdoc at https://farmdoc.illinois.edu/fast-tools/crop-insurance-decision-tool. One sheet in this workbook provides farmer-paid premiums for different federally-regulated policies administered through the Risk Management Agency. This Premium Calculator has been revised to include Enhanced Coverage Option (ECO), a new plan available for the first time this year.
2021 Premium Calculator
Using corn in LaSalle County, Illinois as an example in Figure 1 (see top left corner), the 2021 Premium Calculator, gives farmer-paid premiums for a user-specified county and crop. Estimates are for crops in Midwest and Southeast states that are harvested in 2020.
Once a state and crop is selected, default values are brought in for all parameter items, which have blue lettering on yellow background. Defaults represent a typical case for the county, and can be changed.
Once county and crop have been selected, three sets of premiums are given in three panels 1) Individual Farm Level Plans, 2) Supplemental Coverage Option (SCO) and Enhanced Coverage Option (ECO), and 3) County Level Plans.
Individual Farm Level Plans
Farm-level plans insure yield or revenue using yields from the insured unit. There are three plans for farm coverage:
• Revenue Protection (RP). RP provides revenue insurance with the guarantee increase.
• Revenue Protection with the harvest price exclusion (RPhpe). RPhpe provides revenue insurance without a guarantee increase.
• Yield Protection (YP). YP provided yield insurance.
Premiums are given from the low coverage level of 50% up to the highest coverage level of 85%. For each plan, premiums are given for three different insurance units:
• Enterprise: All of one crop in a county.
• Basic: All of one crop in a county under the same ownership split. All owned and cash rent farmland will be in one basic unit, while each share rent farmland under differing ownership will form another unit.
• Optional: Divides basic units into units based on township sections.
Premiums are given for each type of unit based on parameters specific to that insurance unit, given in yellow at the top of the panel:
• Actual Production History yield is based on the last 10 years of yields with substitutions made for low yields. The APH yield for the example farm in Figure 1 is 183 bu/acre.
• TA/YE Adjustment indicates whether the Trend Adjustment and Yield Exclusion (YE) is used. In the example, the “TA” selection indicates that the trend adjustment is used.
• Trend Adjusted (TA) yield is the APH yield adjusted for trend. The TA yield for the example farm in Figure 1 is 195 bushels per acre.
• Rate yield typically is the historic yield from the unit. If no yields are substituted, the rate and APH yields often are the same. In the in Figure 1 example, rate yield is 183 bushels per acre, the same as the APH yield.
• Risk class indicates whether the farmland is in an area of high risk as denoted by the Risk Management Agency. In the example, “none selected” means that the unit does not contain high risk farmland.
• Acres are the total acres in the unit. The example unit in Figure 1 has 100 acres.
• Type of crop. The type of crop in the example, is “grain.”
• Practice in production. The type of crop in the example, is “non-irrigated”. Corn also has an “irrigated” practices.
The tool will bring in default values that represents the average or prominent inputs for the particular county.
Supplemental Coverage Option (SCO) and Enhanced Coverage Option (ECO)
When a farm-level plan is purchased, farmers also can purchase county-level products that provide coverage on top of the farm-level coverage:
• Supplemental Coverage Option (SCO) provides protection for 86 percent to the underlying farm level policy
• Enhanced Coverage Option (ECO) provides protection from either 90-95 percent down to 86 percent
ECO is new this year and can be purchased with or without SCO.  Use of either (or both) ECO and SCO requires the purchase of an underlying farm-level COMBO policy.
Users of the decision tool can choose the underlying farm-level product: RP, RPhpe, or YP. Based on this choice, the decision tool will bring in the appropriate SCO and ECO quotes.
In the example shown in Figure 1, SCO and ECO are shown for RP. The highest SCO premium is $4.34 per acre when the underlying RP policy has a coverage level of less than 65 percent. The lowest SCO premium is $.76 per acre for the 85-percent RP policy.
There are two premium costs for ECO, one for each of the coverage band options. ECO has an $8.02 per acre farmer paid premium to cover the band from 90 percent to 86 percent.
An ECO-95-percent policy provides coverage from 95-percent down to 86 percent for a farmer-paid premium of $24.04 per acre.
The SCO and ECO panel also shows total premium costs for combinations of the underling COMBO plan, SCO, and ECO. These are shown in green in the right-hand portion of the SCO and ECO panel.
In Figure 1, RP is used as the underlying policy at the enterprise unit level, as indicated by user inputs. Seven combinations are given:
1. RP (or the underlying COMBO product). These premiums are the same as in the “Individual Farm Level Plans” panel. An 85-percent RP policy has a farmer-paid premium of $18.70 per acre.
2. RP plus SCO. Purchasing an 85-percent RP and SCO has a cost of $19.46 per acre, the sum of the $18.70 RP and $.76 SCO premiums.
3. RP plus SCO plus ECO-90-percent. This combination has a $26.28 per acre farmer-paid premium ($18.70 RP + .76 SCO + $6.82 ECO-90 percent).
4. RP plus SCO plus ECO-95-percent. This combination has a $39.90 per acre farmer-paid premium ($18.70 RP + .76 SCO + $20.44 ECO-95 percent).
5. RP plus ECO-90 percent. SCO does not have to be purchased with ECO. This combination has a $25.52 per acre farmer-paid premium ($18.70 RP + $6.82 ECO-90 percent).
6. RP plus ECO-95 percent. SCO does not have to be purchased with ECO. This combination has a $39.14 per acre farmer-paid premium ($18.70 RP + $20.44 ECO-90 percent).
County Level Plans
County products make payments based on county revenue or county yields. Plans include
• Area Revenue Protection (ARP). ARP provides revenue insurance with the guarantee increase.
• Area Revenue Protection with the harvest price exclusion (RPhpe). RPhpe provides revenue insurance without a guarantee increase
• Area Yield Protection (YP). YP provides yield insurance.
Premiums are given for coverage levels from 70 percent to 90 perent in 5-percent increments. Area plans also can be purchased at protection levels from 120 percent down to 80 percent in 1-percent increments. The Tool gives premiums for an 120-percent protection levels, a user-specified level, and an 80-percent coverage level.
The premiums for the example are based on an expected yield of 217 bushels per acre.
Premium levels for the county-level products will vary based on expected yields across counties.