Tools and Resources | Loss Estimation Worksheet

Loss Estimation Worksheet

The following information and decision tool is provided as a means to assist growers in making crop insurance and risk management decisions.

Understanding how loss payments are determined is an important part of choosing the correct crop insurance product. Multiple Peril Crop Insurance (MPCI), Crop Revenue Coverage (CRC), and Revenue Assurance (RA) currently account for nearly 95% of the protection in force. The Loss Estimation Worksheet is a loss estimator which demonstrates the differences in how losses are calculated under the MPCI, CRC, and RA programs.

This worksheet is strictly a simulation of loss payments based on a set of assumptions supplied by the user. Any differences in actual yield and/or price other than those selected could cause a substantial difference in performance.

NOTE: Loss estimates are provided for estimation and example purposes only. Actual losses may vary. Contact your agent for more information or click here to find an agent. This information and material is provided "as is" without express or implied warranty.

Begin: Enter Data
Your Average (APH) Yield From The Last 4-10 Years
Your Current Crop Insurance Product
Your Current Percent Insurance Coverage
Revenue Product Base Price:	Price History
MPCI Price Election:	Price History
Harvest Assumptions/Acre:	Actual Yield/Acre:
Revenue Product Harvest Price*:	Price History


* Maxiumum Upward and Downward Price Movement for CRC is as follows. The Harvest price must be within these limits of the Base price. +/- $1.50/bu. Corn +/- $.70/bu. Cotton +/- $.05/lb. Rice +/- $3.00/bu. Soybeans +/- $2.00/bu. Wheat
The Loss Estimation uses the Harvest Price option in the calculation.

Results: Insurance Needed
Crop Insurance Guarantee /Acre*
Revenue or Production to Count Against Guarantee/Acre
Estimated Insurance Loss Payment/Acre
*CRC, RA = Revenue / MPCI = Production