Decision Tools | AgManager.info

Article Table

Miscellaneous

Title

Author

Date

Downloads

U.S. Supply and Demand (WASDE) Spreadsheets

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.

Llewelyn

May 10, 2019

KSU-Streambank Stabilization

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

Reid

Smith

Williams

March 14, 2017

KSU-Vegetative Buffer

An Excel spreadsheet program to estimate the economic benefits and costs of vegetative buffers

Reid

Smith

Williams

March 14, 2017

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)

Llewelyn

Dhuyvetter

June 29, 2016

KSU-HomeWastewaterTreatment

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

Smith

Williams

May 5, 2016

Beef
Title	Author	Date	Downloads
K-State Feeder Cattle Risk Management Tool An Excel spreadsheet for evaluating feeder cattle risk management strategies	Tonsor Dhuyvetter	April 24, 2019	Excel (1.18 MB)
KSU-Beef Cow Lease (Simple) An Excel spreadsheet for establishing a calf-income split or cash rental rate for leasing a beef cow herd	Tonsor Reid	January 14, 2019	Excel Spreadsheet (660.23 KB)
KSU-Beef Farm Management Guide Spreadsheet An Excel spreadsheet for beef cattle enterprise budgeting to evaluate potential income, costs and profitability.	Tonsor Reid	December 19, 2018	Excel Spreadsheet (903.11 KB)
KSU-Beef Replacement Excel spreadsheet to evaluate the economic value of purchasing replacement females	Tonsor Dhuyvetter	January 17, 2017	Excel (1.08 MB) MP4 (22.42 MB) WMV (30.18 MB)
Pasture Rental Rate Decision Tool An Excel spreadsheet for establishing a pasture rental rate based on budgeted income and party contributions.	Taylor Reid	December 27, 2016	PDF publication (951.54 KB) Spreadsheet (1008.63 KB)
KSU-Cattle Supplementation Cost An Excel spreadsheet to evaluate the total costs of various protein supplement programs for cow/calf and stocker producers	Pendell Dhuyvetter Smith Blasi	June 29, 2016	Excel (1.93 MB)
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	Pendell Dhuyvetter Johnson	November 11, 2015	Excel (714.64 KB)
Cattle Breakeven Prices Yearling-Fed An Excel spreadsheet for calculating breakeven cattle prices of yearlings placed on feed	Tonsor Dhuyvetter Highfill	October 13, 2015	Excel (754.34 KB)
Cattle Breakeven Prices Calf-Yearling An Excel spreadsheet for calculating breakeven cattle prices between the calf and yearling stages	Tonsor Dhuyvetter Highfill	October 13, 2015	Excel (1.31 MB)
KSU-BeefCowLease A spreadsheet budgeting program to determine equitable share lease rental arrangements for beef cowherds (Oklahoma State/K-State version)	Dhuyvetter Doye	January 20, 2013	PDF-Article (666.14 KB) PDF-Form (144 KB) Excel (1.4 MB)

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	Tonsor Reid	December 19, 2018	Excel Spreadsheet (1.08 MB)

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	Pendell Reid	December 19, 2018	Excel Spreadsheet (1.01 MB)

Dairy
Title	Author	Date	Downloads
KSU-Dairy Farm Management Guide Spreadsheet Excel spreadsheets for dairy enterprise budgeting to evaluate potential income, costs and profitability	Tonsor Reid	December 19, 2018	Excel Spreadsheet (502.7 KB)
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	Reid Dhuyvetter	July 8, 2016	Excel
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	Dhuyvetter	March 1, 2014	PDF Publication (46.93 KB) Excel (762.94 KB)

Crop Production Economics
Title	Author	Date	Downloads
WASDE Quick Analysis Spreadsheet Dan O’Brien evaluates the numbers from the USDA WASDE grain supply and demand report.	O'Brien	September 13, 2018	Excel (186.62 KB)
Seasonal Cash Grain Prices An Excel spreadsheet to evaluate seasonality in the Kansas grain market	O'Brien Reid Dhuyvetter	September 10, 2018	Excel Spreadsheet (1.38 MB)
Methods of Valuing Corn or Grain Sorghum Silage A spreadsheet tool designed to look at silage pricing methods from both the owner and buyer perspectives.	Vandeveer Reid Holman	August 2, 2018	Paper (377.53 KB) Excel Spreadsheet (29.25 KB)
Wheat Grazeout Partial Budget 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	Reid Lollato Holman	April 17, 2018	Excel Spreadsheet (18.24 KB) Agronomy E-Update Article
KSU-Fertilizer Tool An Excel spreadsheet to calculate which combinations of fertilizers will meet the nutrient requirements of a field, at the lowest cost.	Ibendahl	March 30, 2017	PDF (178.23 KB) Excel (439.72 KB)
KSU-Cover Crop Cost-Return Budget An Excel spreadsheet to analyze the economics of planting a cover crop based on short-term benefits	Taylor Reid Shoup Farney	August 10, 2016	Excel Spreadsheet (1.08 MB)
Bermuda Hay Economics An Excel spreadsheet to analyze the economics of planting bermuda grass and harvesting as hay	Dhuyvetter Moyer	July 8, 2016	Excel (3.83 MB)
Economics of Spraying Field Crops An Excel spreadsheet to analyze the economics of spraying a crop field based on the anticipated yield response	Griffin Dhuyvetter Jardine	July 8, 2016	Excel (2.92 MB)
KSU Irrigation Energy Cost A spreadsheet to compare the costs of irrigation energy options	Griffin Dhuyvetter Dumler	May 23, 2016	Excel (1.03 MB)
Guidance & Section Control Profit Calculator A computer spreadsheet program to analyze the economics of investing in machine guidance and section control technologies	Dhuyvetter Smith Kastens	May 20, 2016	PDF (420.31 KB) Excel (1.39 MB) Video-WMV (18.59 MB)
KSU-OptionStrategies An Excel spreadsheet to compare alternative marketing strategies that use the futures and options markets	Dhuyvetter	December 12, 2013	Excel (968 KB)

Policy & Risk Management
Title	Author	Date	Downloads
Monthly Cash Flow for Operating Loan Determination A spreadsheet to assist in building a monthly cash flow statement to determine operating loan levels.	Reid Dikeman	August 8, 2018	Excel Spreadsheet (741.23 KB)
2017 SCO Payment Calculator Spreadsheet calculator for determining Supplemental Coverage Option (SCO) payments in 2017. Includes corn, soybeans, wheat and grain sorghum for all states/counties in the U.S.	Reid	July 26, 2018	Excel (11.44 MB)
Financial Benchmarking Tool A tool to assess a farm's financial position relative to other similar farms in the same region.	Herbel Reid Dikeman	June 18, 2018	PDF Instructions (403.6 KB) Excel Spreadsheet (2.32 MB)
KSU-Integrated Financial Statements An Excel spreadsheet to build a balance sheet, income statement, and cash flow from farm records. Financial ratios are also computed.	Herbel Reid Dikeman	December 6, 2017	Hand fill-in Statements (207.73 KB) Spreadsheet with Example Farm (280.83 KB) Blank Financial Statements Spreadsheet (277.94 KB)
KSU-Insurance Alternatives for Winter-Damaged Wheat An Excel spreadsheet for helping producers analyze options for wheat damaged by winter weather.	Vandeveer	May 11, 2017	Excel (148.59 KB)
Working Capital 5-Year Spreadsheet 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.	Featherstone	December 12, 2016	Spreadsheet (19.17 KB)
AGR-Lite Whole-Farm Revenue Insurance An Excel spreadsheet to assess the AGR-Lite whole farm insurance program for a farming operation	Llewelyn Barnaby	May 24, 2016	PDF-Instructions (65.48 KB) Excel (1.68 MB)

Land Leasing & Purchase
Title	Author	Date	Downloads
KSU-Lease An Excel spreadsheet to determine equitable crop share and cash lease rental arrangements	Taylor Dhuyvetter Kastens	July 8, 2016	User Guide (127.79 KB) Excel (487.44 KB)
KSU-Landbuy An Excel spreadsheet to analyze land purchase prices and land values in general	Taylor Dhuyvetter Kastens	August 20, 2013	PDF (880.93 KB) Excel (341.5 KB) Video Guide (47.9 MB) Audio Guide (10.69 MB)
KSU-FlexRent An Excel spreadsheet to calculate flexible cropland rents based on price, yield, or revenue	Taylor Dhuyvetter Kastens	January 18, 2012	PDF Publication (75.19 KB) Excel (337.5 KB)

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	Llewelyn Dhuyvetter Kastens	June 30, 2016	PDF Publication (198.74 KB) Excel (992.76 KB)
KSU-Own Combine An Excel spreadsheet to evaluate the economic costs of owning and operating a combine	Llewelyn Dhuyvetter Kastens	June 30, 2016	Excel (720.97 KB)
KSU-Own Tractor An Excel spreadsheet to evaluate the economic costs of owning and operating a tractor	Llewelyn Dhuyvetter Kastens	June 30, 2016	PDF Publication (2.14 MB) Excel (2.79 MB)
KSU-Own Sprayer An Excel spreadsheet to evaluate the economic costs of owning and operating a self-propelled crop sprayer	Llewelyn Dhuyvetter Kastens	June 30, 2016	PDF Publication (145.2 KB) Excel (1.65 MB)
KSU-Truck Cost An Excel spreadsheet to estimate the cost of owning and operating a truck	Llewelyn Dhuyvetter	June 30, 2016	Excel (249.2 KB)
KSU-Machinery Costs An Excel spreadsheet to assist producers in calculating farm specific custom farming rates and benchmarking machinery costs	Dhuyvetter Kastens Beaton	June 30, 2016	PDF (181.6 KB) Excel (902.45 KB)
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	Llewelyn Dhuyvetter Dumler	June 30, 2016	PDF Publication (136.36 KB) Excel (298.8 KB)
Guidance & Section Control Profit Calculator A computer spreadsheet program to analyze the economics of investing in machine guidance and section control technologies	Dhuyvetter Smith Kastens	May 20, 2016	User Guide (420.31 KB) Excel (1.39 MB) Video (18.59 MB)
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	Ibendahl	February 17, 2016	PDF Publication (157.54 KB) Excel (1.21 MB)