Decision Tools

Article Table

Crop Production Economics
Title Author Date Downloads
KSU-Cover Crop Cost-Return Budget

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

August 10, 2016
Bermuda Hay Economics

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

July 8, 2016
Economics of Spraying Field Crops

An Excel spreadsheet to analyze the economics of spraying a crop field based on the anticipated yield response

July 8, 2016
Seasonal Cash Grain Prices

An Excel spreadsheet to evaluate seasonality in the Kansas grain market

June 30, 2016
KSU Irrigation Energy Cost

A spreadsheet to compare the costs of irrigation energy options

May 23, 2016
Guidance & Section Control Profit Calculator

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

May 20, 2016
Farm Management Guides Spreadsheet--Crops

Farm Management Guide budgets in spreadsheet form to budget your own farm enterprises

February 18, 2015
KSU-OptionStrategies

An Excel spreadsheet to compare alternative marketing strategies that use the futures and options markets

December 12, 2013
Miscellaneous
Title Author Date Downloads
USDA WASDE Data - Soybeans

The World Agricultural Supply and Demand Estimates (WASDE) are released on about the 10th of each month by USDA. This spreadsheet provides historical data for soybeans since 1973-present. 

July 12, 2016
USDA WASDE Data - Corn

The World Agricultural Supply and Demand Estimates (WASDE) are released on about the 10th of each month by USDA. This spreadsheet provides historical data for corn since 1973-present. 

July 12, 2016
USDA WASDE Data - Grain Sorghum

The World Agricultural Supply and Demand Estimates (WASDE) are released on about the 10th of each month by USDA. This spreadsheet provides historical data for grain sorghum since 1973-present. 

July 12, 2016
USDA WASDE Data - Wheat

The World Agricultural Supply and Demand Estimates (WASDE) are released on about the 10th of each month by USDA. This spreadsheet provides historical data for wheat since 1973-present. 

July 12, 2016
Balance Sheet Spreadsheet

An Excel spreadsheet to organize farm assets and liabilities into a balance sheet to evaluate changes in owner equity

June 30, 2016
Income Statement Spreadsheet

An Excel spreadsheet to organize farm records into a financial statement that measures net farm income or loss

June 30, 2016
Cash Flow Sheet Spreadsheet

An Excel spreadsheet to develop a cash flow statement to show cash-generating ability and cash requirements of the farm business

June 30, 2016
Tips and Exercises for Using Excel Spreadsheets

A manual and exercises used at Excel workshops to help users understand the basics of using Microsoft Excel (pdf)

June 29, 2016
KSU-HomeWastewaterTreatment

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

May 5, 2016
Beef
Title Author Date Downloads
KSU-SilageValue

A spreadsheet program to estimate the vaue of corn or grain sorghum silage based upon the price of grain, harvesting costs, and nutrients removed

July 8, 2016
KSU-Cattle Supplementation Cost

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

June 29, 2016
KSU-Beef Farm Management Guide Spreadsheet

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

June 1, 2016
KSU-Beef Cow Lease (Simple)

An Excel spreadsheet for establishing a calf-income split or cash rental rate for leasing a beef cow herd

June 1, 2016
K-State Feeder Cattle Risk Management Tool

An Excel spreadsheet for evaluating feeder cattle risk management strategies

May 31, 2016
Pasture Rental Rate Decision Tool

An Excel spreadsheet for establishing a pasture rental rate based on budgeted income and party contributions.

February 10, 2016
KSU-Beef Replacements

An Excel spreadsheet program to evaluate the economics value of purchasing beef replacement females

January 12, 2016
KSU-Bull vs AI Breeding Costs

An Excel spreadsheet to evaluate the economic costs and benefits of natural (bull) breeding versus artificial insemination (AI) in beef herds

November 11, 2015
Cattle Breakeven Prices Calf-Yearling

An Excel spreadsheet for calculating breakeven cattle prices between the calf and yearling stages

October 13, 2015
Cattle Breakeven Prices Yearling-Fed

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

October 13, 2015
KSU-BeefCowLease

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

January 20, 2013
Dairy
Title Author Date Downloads
KSU-SilageValue

A spreadsheet program to estimate the vaue of corn or grain sorghum silage based upon the price of grain, harvesting costs, and nutrients removed

July 8, 2016
KSU-Dairy Farm Management Guide Spreadsheet

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

June 1, 2016
Silage Storage: Economics of Bunkers, Piles, or Bags for Dairy

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

March 1, 2014
Land Leasing & Purchase
Title Author Date Downloads
KSU-Lease

An Excel spreadsheet to determine equitable crop share and cash lease rental arrangements

July 8, 2016
KSU-Landbuy

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

August 20, 2013
KSU-FlexRent

An Excel spreadsheet to calculate flexible cropland rents based on price, yield, or revenue

January 18, 2012
Machinery & Building
Title Author Date Downloads
KSU-Own Baler

An Excel spreadsheet to evaluate the economic costs of owning and operating a large square or large round hay baler

June 30, 2016
KSU-Own Combine

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

June 30, 2016
KSU-Own Tractor

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

June 30, 2016
KSU-Own Sprayer

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

June 30, 2016
KSU-Truck Cost

An Excel spreadsheet to estimate the cost of owning and operating a truck

June 30, 2016
KSU-Machinery Costs

An Excel spreadsheet to assist producers in calculating farm specific custom farming rates and benchmarking machinery costs

June 30, 2016
KSU-Building Cost-Rent

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

June 30, 2016
Guidance & Section Control Profit Calculator

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

May 20, 2016
Kansas Custom Rates Comparison for 2016

An Excel spreadsheet program to estimate custom rates for various farming operations given a user-entered projection for diesel fuel price

February 17, 2016
Swine
Title Author Date Downloads
KSU-Swine Farm Management Guide Spreadsheet

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

June 1, 2016
Sheep
Title Author Date Downloads
KSU-Sheep Farm Management Guide Spreadsheet

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

June 1, 2016
Policy & Risk Management
Title Author Date Downloads
AGR-Lite Whole-Farm Revenue Insurance

An Excel spreadsheet to assess the AGR-Lite whole farm insurance program for a farming operation

May 24, 2016