Decision Tools

An Excel spreadsheet for beef cattle enterprise budgeting to evaluate potential income, costs and profitability. 

This spreadsheet allows a user to develop a detailed beef cow/calf enterprise budget to evaluate potential income, costs, and profitability.

This spreadsheet is a decision-aid tool for cattle producers to compare expected net profit difference between alternative calf vaccination programs. 

An Excel spreadsheet to evaluate the total costs of various protein supplement programs for cow/calf and stocker producers

An Excel spreadsheet for calculating breakeven cattle prices of yearlings placed on feed

A spreadsheet budgeting program to determine equitable share lease rental arrangements for beef cowherds (Oklahoma State/K-State version)

This calculator will show SCO and ECO payments based on final county yields and harvest price for a farmer's underlying crop insurance contract.

A tool to assess a farm's financial position relative to other similar farms in the same region. 

An Excel spreadsheet to build a balance sheet, income statement, and cash flow from farm records.  Financial ratios are also computed.

A spreadsheet to evaluate working capital needs for a 5-year horizon.  Presented at the 2016/2017 "Top 10 Considerations to Navigate the Struggling Farm Economy" programs.

This spreadsheet includes a cash only and accrual adjusted income statement.  This was presented at the 2020 Farm Finanical Skills for Kansas Women in Ag. series.

The World Agricultural Supply and Demand Estimates (WASDE) are released on about the 10th of each month by USDA. These spreadsheets provides historical data for corn,  grain sorghum, wheat, and soybeans, from 1973 to present. 

An Excel spreadsheet program to estimate the economic benefits and costs of streambank stabilization projects

An Excel spreadsheet program to estimate the economic costs of wastewater treatment systems for homeowners

Excel spreadsheet for dairy enterprise budgeting to evaluate potential income, costs and profitability.

A spreadsheet to evaluate the storage capacity requirements and the economic costs associated with storing silage in bunkers, piles, or plastic bags

Excel spreadsheet for dairy enterprise budgeting to evaluate potential income, costs and profitability.

An Excel spreadsheet for swine enterprise budgeting to evaluate potential income, costs and profitability.

An Excel spreadsheet to evaluate seasonality in the Kansas grain market

A spreadsheet tool to help producers evaluate the options they have once they hit the final planting date for corn and what might be most economical given projected harvest prices.

This spreadsheet is designed to help a producer make the decision to pull cattle at wheat jointing and harvest as a grain crop or to grazeout wheat

An Excel spreadsheet to analyze the economics of planting a cover crop based on short-term benefits

An Excel spreadsheet to analyze the economics of planting bermuda grass and harvesting as hay

A computer spreadsheet program to analyze the economics of investing in machine guidance and section control technologies

Instructional videos for using the Lease Simulation Tool:

1. General Overview
2. How to Create a New Budget
3. Cash Versus Share Rent
4. How to Interpret Results
5. How to Run Simulations

An Excel spreadsheet to analyze land purchase prices and land values in general

Accompanying article HERE

Accompanying article and video HERE

1. Click the link below to download the set-up file. 

2. Open the file, click "More Info", then the "Run Anyway" button. 

3. Click "Install", then "Finish" when completed. Locate the "Machinery Cost Calculator" on the desktop and double-click to open. 

Machinery Cost Calculator - Windows Version (Set-up)

An Excel spreadsheet to estimate the annual cost of owning and maintaining agricultural storage buildings to aid in determining estimates for building rent

An Excel spreadsheet to evaluate the economic costs of owning and operating a combine

An Excel spreadsheet to evaluate the economic costs of owning and operating a self-propelled crop sprayer

A computer spreadsheet program to analyze the economics of investing in machine guidance and section control technologies