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 2013 (XLS) updated Dec. 11, 2012
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 Nov. 22, 2011
The variable and fixed costs of storing grain based on different size grain bins.

Economic Returns to Grain Drying (XLS) updated Nov. 22, 2011
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 9/4/09Grain Moisture Shrinkage Table, Calculation of wet bushels to dry bushels, Calculation of Grain Moisture Discounts, and Net Returns to Drying with LP Gas

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

Grain Drying Costs (XLSX)
Drying costs are based on variable moisture levels and points removed.

Moisture Conversion Calculator (XLS)

Farm Land Economics — Crop Plan (XLS)
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.

 

University Spreadsheets and Decision Tools