Skip to main content

more options


Decision Making Tools

Below are links to a variety of spreadsheet based financial decision tools. The anaerobic digestion tools were created by Dr. Brent Gloy and the rest were created by Eddy LaDue, Emeritus W.I. Myers Professor of Agricultural Finance.  These tools are available for download and require the use of Microsoft Excel.  Documentation and instructions for using the tools is contained in the files.

 

Anaerobic Digestion Economic Analysis

Two Excel spreadsheets that assist in conducting financial assessments for AD projects on dairy operations. The first tool is designed as a general assessment tool, while the second is designed to utilize outputs from the U.S. EPA's Farmware program.

Download the general spreadsheet
Download the spreadsheet that utilizes Farmware outputs
Download the input worksheets
Download a bulletin describing an analysis using the spreadsheets

LEAP - Lease Analysis Program
An Excel spreadsheet for the economic analysis of capital leases. Version 2.1 can handle different values in each year for tax rates, interest rates and the opportunity cost of capital.

Download the spreadsheet (version 1)
Download the spreadsheet (version 2.1)
Download the instructions for the worksheet (version 1)

FISA  - A complete set of financial statements for agriculture
An Excel 5.0 file designed for calculating financial statements for agriculture consistent with the recommendations of the Farm Financial Standards Council (FFSC).
Download the spreadsheet
Download instructions for the program 

CashPro - Annual cash flow projection
An Excel 5.0 file to calculate annual cash flow projections
Download the spreadsheet
Download instructions for the program

MoCash - Monthly cash flow projection
An Excel 5.0 file to calculate monthly cash flow projections
Download the spreadsheet
Download spreadsheet 405
Download instructions for the program

Analyzing Replacement Equipment Purchases
An Excel file for "Analyzing Replacement Equipment Purchases"
Download the spreadsheet
Download the guide

BTLEASE - Before tax lease program
An Excel Spreadsheet to Calculate the Before Tax Implicit Rate of Interest on a Lease
Download the spreadsheet