| HAC Supplement to "USDA Payment Calculator for FSA Crop Disaster Prog." 1/ | ||||||||
| Access the USDA Calculator at http://disaster.fsa.usda.gov/agas03.htm | ||||||||
| Prepared by the House Agriculture Committee (HAC) Majority Staff 2/ | ||||||||
| 2002 Corn with CRC Crop Insurance: | A | B | C | |||||
| Formulas and Program, Market | Calculation | HAC | Input | USDA | ||||
| and Farm Variables | Column | Calc | Column | Row | ||||
| 1 | Production: Expected and Actual | |||||||
| 2 | Planted acres | 1.0 | <input> | 1.0 | [ 4 ] | |||
| 3 | * Expected Yield = Higher of APH Yield | 123.0 | <input B> | 123.0 | ||||
| 4 | or 1996 -00 County Average Harvested Yield | -- | <input> | 120.0 | ||||
| 5 | = Expected Production | 123.0 | [ B2 * B3 ] | -- | ||||
| 6 | Harvested Acres | 1.0 | <input> | 1.0 | ||||
| 7 | * Harvested yield | 12.3 | <input> | 12.3 | ||||
| 8 | = Harvested Production | 12.3 | [ B6 * B7 ] | -- | [ 7 ] | |||
| 9 | Crop Insurance (CI) Net Indemnity | |||||||
| 10 | Type of CI Policy | CRC | <input> | CRC | ||||
| 11 | Planted Acres [Cell A2] | 1.0 | [ B2 ] | -- | ||||
| * APH Yield [ Cell B3 ] | 123.0 | [ A3 ] | -- | |||||
| 12 | * CI Coverage Level | 75% | <input> | 75% | ||||
| 13 | = CI Covered Production | 92.3 | -- | |||||
| 14 | CI Covered Production | 92.3 | -- | |||||
| 15 | - Harvested Production [Cell A8] | 12.3 | -- | |||||
| 16 | = CI Covered Loss | 80.0 | -- | |||||
| 17 | CI Covered Loss | 80.0 | -- | |||||
| 18 | * CI Price Election | $2.59 | <input> | $2.59 | ||||
| 19 | = CI Gross Indemnity | $207.07 | -- | [ 11 ] | ||||
| 20 | Gross CI Indemnity | $207.07 | -- | |||||
| 21 | - Producer Paid CI Premium @ Rate of | $9.75 | <input> | 4.08% | [ 12 ] | |||
| 22 | = Net CI Indemnity Payment | $197.32 | -- | [ 13 ] | ||||
| 23 | Gross Disaster Payment Before 95% Cap | |||||||
| 24 | Disaster Eligible Acres | 1.0 | <input> | 1.0 | ||||
| 25 | * Disaster Yield = Expected Yield [Cell A3] | 123.0 | -- | |||||
| 26 | * Disaster Quantity Loss Threshold | 65% | <input> | -- | ||||
| 27 | = Disaster Production Guarantee | 80.0 | -- | |||||
| 28 | Disaster Production Guarantee | 80.0 | -- | [ 20 ] | ||||
| 29 | - Harvested Production [Cell A8] | 12.3 | -- | |||||
| 30 | = Disaster Quantity | 67.7 | -- | |||||
| 31 | Disaster Quantity | 67.7 | -- | |||||
| 32 | * Disaster Payment Rate = 50% of: | $1.00 | -- | |||||
| 33 | APH Price Election | -- | <input> | $2.00 | ||||
| 34 | = Gross Disaster Payment before 95% Cap | $67.65 | -- | [ 25 ] | ||||
| 35 | 95% Cap = 95% of Crop Value if No Loss | |||||||
| 36 | Planted Acres [Cell A2] | 1.0 | -- | |||||
| 37 | * Disaster Yield [Cell A25] | 123.0 | -- | |||||
| 38 | = Expected Production for Cap Calc | 123.0 | -- | |||||
| 39 | Expected Production for Cap Calc | 123.0 | -- | |||||
| 40 | * Crop Value Price: Higher of APH Price Elect. | $2.35 | <input> | $2.00 | ||||
| 41 | or Season Average Price | -- | <input> | $2.35 | ||||
| 42 | = 100% of Crop Value if No Loss | $289.05 | -- | |||||
| 43 | 95% Cap | $274.60 | -- | [ 31 ] | ||||
| 44 | Net Disaster Payment After 95% Cap | |||||||
| 45 | Harvested Production [Cell A8] | 12.3 | -- | |||||
| 46 | * Crop Value Price [Cell A40] | $2.35 | -- | |||||
| 47 | = Value of Crop Harvested | $28.91 | -- | [ 35 ] | ||||
| 48 | Value of Crop Harvested | $28.91 | -- | |||||
| 49 | + Net CI Indemnity Payment [Cell A22] | $197.32 | -- | [ 33 ] | ||||
| 50 | + Gross Disaster Payment before 95% Cap [Cell A34] | $67.65 | -- | |||||
| 51 | = Harv. Crop Value + Payments Before Cap | $293.88 | -- | [ 36 ] | ||||
| 52 | Harv. Crop Value + Payments before Cap | $293.88 | -- | |||||
| 53 | - 95% Cap [Cell 43] | $274.60 | -- | |||||
| 54 | = Difference | $19.28 | -- | |||||
| 55 | = Amount above 95% Cap = Difference | $19.28 | -- | [ 38 ] | ||||
| 56 | if Positive; Zero if Negative | -- | ||||||
| 57 | Disaster Payment before 95% Cap | $67.65 | -- | |||||
| 58 | - Amount above 95% Cap | $19.28 | -- | |||||
| 59 | = Net Disaster Payment after 95% Cap | $48.37 | -- | [ 39 ] | ||||
| 60 | Value of Crop Harvested + Crop Ins. + Net Disaster | |||||||
| 61 | Value of Crop Harvested [Cell 47] | $28.91 | -- | |||||
| 62 | + Net CI Indemnity Payment [Cell A22] | $197.32 | -- | |||||
| 63 | + Net Disaster Payment after 95% Cap [Cell A59] | $48.37 | -- | |||||
| 64 | = Harv. Crop Value + Payments After Cap 3/ | $274.60 | -- | |||||
| 1/ This House Agriculture Committee (HAC) spreadsheet provides more details on calculations underlying the USDA Calculator | ||||||||
| 2/ For more information, contact Craig Jagger: craig.jagger@mail.house.gov, 202 225-1130. | ||||||||
| 3/ Excludes Commodity Program Payments | ||||||||