Spreadsheets - Excel

2014 Southeast Missouri Crop Budgets
Updated 12/24/13
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
Updated 12/24/13
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
Updated 12/11/12
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 & Storage Cost
Updated 11/22/11
The variable and fixed costs of storing grain based on different size grain bins.
Economic Returns to Grain Drying
Updated 11/22/11
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
Updated 9/4/09
Grain 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 Drying costs are based on 10 points removed.  Enter energy prices and crop yields on line 4.
Grain Drying Costs Drying costs are based on variable moisture levels and  points removed. 
Moisture Conversion Calculator  
Farm Land Economics - Crop Plan 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 %, farmland values, and net crop income. 
The Interest Rate Worksheet calculates the net economic and cash flow returns based on changes in financing %, farmland values, and interest rates.
Farm Land Economics - Net Income The spreadsheet helps a farmer to determine the economics of purchasing more farm land based on a the farm's net income.  
The Net Return Worksheet calculates the net economic and cash flow returns based on changes in financing %, farmland values, and net crop income. 
The Interest Rate Worksheet calculates the net economic and cash flow returns based on changes in financing %, farmland values, and interest rates.
Crop Insurance
Updated 3/13/13
Corn, Soybeans Wheat Cotton and Rice RP and RP-HPE Crop Insurance Options
Farm Record Book Version 2.4

Documentation- Word   Documentation - PDF

Updated 5/17/13

The farm record book file provides agricultural producers with a template for maintaining cash accounting records.  The Excel workbook consists of seven worksheets that interact to provide tracking and summary information that can be used to manage farm finances.

The Excel spreadsheet was developed by Whitney Wiegel, University of Missouri Extension Agricultural Business Specialist.  You can contact Whitney at the following:

Whitney Wiegel, University of Missouri Extension Agricultural Business Specialist; 14 E. 19th St., Suite 102 Higginsville, MO 64037
Phone:  660-584-3658
Email:  WiegelW@missouri.edu

Spreadsheets & Programs From Universities

Montana State University

Financial Management & Analysis, Machinery Management, Crop Production, Livestock and etc.

Illinois

A good source of financial spreadsheets.

Iowa State

Ag Decision Manager -  Decision Tools

Kentucky

Spreadsheets and Computer Software

Virginia Tech

Crop and Livestock Budgets

Georgia

Computer Decision Aids

Tennessee

Software Programs

Oklahoma State

Spreadsheets and Programs

Kansas State

Click on Decision Tools Links

UMC - Beef 
Decision Tools

Beef Spreadsheets and Programs from the University of Missouri Beef Focus Team
Decision Tools

AgEBB

Marketing, financial management, and general agricultural data from the University of Missouri.  Click on the File Sharing link for the spreadsheets.

 

To the Home Page To the Marketing Page To the Risk Management Page To the Farm Management Newsletter Page To the Agriculture Policy Page