Farm Management Decision Tools - Spreadsheets

2016 Southeast Missouri Crop Budgets (XLS) updated Dec. 2, 2015
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 two crop decision aid worksheets assist in making decisions on which crops to plant based on variable production costs and changes in yields and prices. The Crop Decision Aid - Breakeven Worksheet calculates the yield and price between two crops that give equal net returns. Crop Decision Aid - Net Returns Worksheet calculates the net return between two crops based on changes in yield and price.

The two summary worksheets compare the economic returns of irrigated and non-irrigated crops.  First develop a budget for each crop that will be in the analysis.  Update crop yields and prices in rows 5 and 6.

2016 Southeast Missouri Crop Budgets with Crop Rent Analysis (XLS) updated Dec. 3, 2015
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 2016 (XLS) updated December 2015
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 March 2016

University & Industry Spreadsheets and Decision Tools