Crop calculation spreadsheets

2014 Southeast Missouri Crop Budgets (XLS) updated Nov. 27, 2013
The budgets are for the major crops grown in Southeast Missouri — corn, soybeans, wheat, grain sorghum, cotton, rice, popcorn, and southern peas. They include irrigated, non-irrigated, Roundup Ready, Liberty Link, Conventional, no-till and double crop.

The Crop Analysis worksheet calculates the breakeven net income between two crops based on changes in yield and price. This will help a farmer in making planting decisions of planting one crop over another.

2014 Southeast Missouri Crop Budgets with Crop Rent Analysis (XLS) updated Nov. 27, 2013
The budgets are for the major crops grown in Southeast Missouri — corn, soybeans, wheat, grain sorghum, cotton, rice, popcorn and southern peas. They include irrigated, non-irrigated, Roundup Ready, Liberty Link, Conventional, no-till and double crop. 

The budgets also gives the net returns based on variable and total costs for both the tenant and landowner based on different crop share rental arrangements.

Irrigation Systems 2014 (XLS) updated November 2013
Calculates the economic and cash flow costs of different center pivot and furrow irrigation systems. It also calculates the contributions of the tenant and landowner in determining a fair rental agreement.

Grain Bin and Storage Cost (XLS) updated February 2014
The variable and fixed costs of storing grain based on different size grain bins.

Economic Returns to Grain Drying (XLS) updated September 2014
This spreadsheet is designed to help a farmer to determine the economic returns to grain drying from different moisture levels.

Grain Shrinkage Table and other Grain Moisture Calculations (XLS) Updated September 2014
Grain Moisture Shrinkage Table, Calculation of wet bushels to dry bushels, Calculation of Grain Moisture Discounts, Net Returns to Drying with LP Gas, and Grain Load Worksheets that calculated the wet and dry bushels of each truck load of grain.

Calculating Drying Costs Based on Energy Prices and Drying Systems (XLS) Updated February 2014
Drying costs are based on 10 points removed. Enter energy prices and crop yields on line 4.

Farm Land Economics — Crop Plan (XLS) updated September 2014
The spreadsheet helps a farmer to determine the economics of purchasing more farm land based on a the farm's crop plan. 
The Net Return Worksheet calculates the net economic and cash flow returns based on changes in financing percents, farmland values and net crop income.
The Interest Rate Worksheet calculates the net economic and cash flow returns based on changes in financing percents, farmland values and interest rates.

Farm Land Economics — Net Income per Acre Approach (XLS) updated September 2014

Crop Insurance RP and RP-HPE for Corn, Soybeans, Wheat, Rice and Cotton (XLS) updated September 2014

University & Industry Spreadsheets and Decision Tools