Farmdoc Search Subscribe About Contact Us friends of farmdoc
Home

Finance
Marketing & Outlook
Management
Law & Taxation
Policy
FASTtools
Crop Insurance
Presentations
Prices & Weather
Ag Links
Visit farmdoc daily
Visit farmdoc webinars
farmdoc Sponsors

To Download Spreadsheets: Check the box next to the spreadsheet, then scroll to the top or bottom of the page and click "Download."

Go To:  All | Financial Analysis | Investment Analysis | Loan Analysis | Farm Management |
            Livestock Management | Grain Marketing | Risk Management | Farm Database Tools

Sort By: Section | Date

Download

Tool

Size Date User Guide Demo

2018 Crop Insurance Decision Tool - Spring

64982k 3/2/2018 More
Calculates premiums, evaluates insurance payments, and provides historical data useful when making crop insurance decisions for multiple crops. Estimates are for crops in states that are harvested in 2018.

Illinois Soil Productivity Index Utilities

1283k 8/24/2017 More
Designed to assist with common computations related to the Illinois Soil Productivity measures and associated predicted yields.

Planting Decision Model

1363k 5/31/2017 More
With this program, the user can: 1) estimate the costs of planting corn and soybeans by planting date, 2) estimate the net returns from replanting, 3) prevented planting payments, and 4) compare crop rotations.

Grain Farm Budget and Projection Tool

8713k 4/3/2017 More
This program calculates per-acre budgets for different crops and a whole farm budget and includes breakevens. Projected financial statements and return sensitivities are available. The effects of farm level crop insurance and hedging can be analyzed.

Farm Rent Evaluator

8695k 4/3/2017 More
Compares the risks and returns of different leases.

Quick Cash Flow Projections

1998k 3/30/2017 More
Prepares a quarterly cash flow projection and performs sensitivity analysis.

2017 Crop Insurance Decision Tool - Spring

62326k 3/6/2017 More
Calculates premiums, evaluates insurance payments, and provides historical data useful when making crop insurance decisions for multiple crops. Estimates are for crops in states that are harvested in 2017.

Cash Flow Planning

1430k 11/2/2016 More
Prepares monthly pro-forma cash flows for an operation.

Grain Inventory Management

1246k 9/12/2016 More
Inventory accounting system to track grain inventory from harvest to sale.

Corn & Soybean Basis Tool

1168k 9/8/2016 More
The user can calculate, monitor, and evaluate the nearby basis, as well as cash and nearby futures prices for corn and soybeans in a given year.

Balance Sheet & Historical Financial Statements

1435k 3/7/2016 More
Prepares financial statements for a farm based on beginning and ending balance sheets and revenue and expense items.

2016 Crop Insurance Decision Tool - Spring

41566k 3/2/2016 More
Calculates premiums, evaluates insurance payments, and provides historical data useful when making crop insurance decisions for multiple crops. Estimates are for crops in states that are harvested in 2016.

Biomass Crop Budget Tool – Corn Stover

2155k 2/17/2016 More
The corn stover budget tool provides estimates of the breakeven price of that the producer would need to receive to cover the costs associated with the harvesting, collection, and storage of the stover.

Cash Rent with Bonus Worksheet

1145k 9/9/2015 More
Contains a worksheet that allows setting of parameters of cash rent with bonus leasing arrangements. The worksheet then calculates cash rents under alternative prices and yields.

Machinery Economics

1197k 8/28/2015 More
Analyzes the cost of completing fieldwork and generates machinery costs.

Biomass Crop Budget Tool – Miscanthus and Switchgrass

1848k 6/9/2015 More
The miscanthus and swithgrass budget tool provides estimates of the breakeven price of biomass that the producer would need to receive each year to match the returns earned under their current land use.

Grain Pricing Tool

1206k 6/20/2014 More
Enables the user to: 1) estimate the future distributions of corn and soybean, 2) calculate breakeven prices for storage and compare to projections, and 3) compare net returns of delivering grain to alternative locations and/or months.

Dairy Profitability Model

975k 2/24/2012 More
Calculates breakeven prices for a dairy operation including group feed cost summaries. A net income summary on a per cwt, per cow, and per farm basis after all costs is also generated.

Loan Amortization

1257k 11/7/2011 More
Simple loan amortization program calculating principal, interest and outstanding balance.

Farmland Lease Analysis

1280k 1/15/2010 More
Calculates revenues, costs, and returns for share rent, cash rent, and dry bushel farmland leases.

New Company Simulator

1454k 10/28/2009 More
With this program, the user can project earnings, financial conditions, and break even levels and prices

Marketing and Crop Insurance Risk Model

1902k 10/28/2009 More
With this program, the user can estimate the impact alternative risk management strategies have on gross revenue distributions.

Specialty Commodity Breakeven Analysis

1162k 10/28/2009 More
With this program, the user can enter budgets and calculate break even levels for a set of specialty commodities.

Cost of Feedstuffs Calculator

1313k 10/6/2009 More
With this program, the user can calculate the per unit cost of energy and crude protein with the cost of the feed ingredients on an as-fed basis.

Personal Financial Statements

2295k 8/27/2009 More
Prepares a family budget that produces a balance sheet and an income statement.

Iowa Crop Yield Database

1381k 7/20/2009 More
Used to access historic crop yield data from the period 1972-2008 for corn, soybeans, and wheat; sortable by state total, county level, and NASS crop reporting district.

Indiana Crop Yield Database

1360k 7/20/2009 More
Used to access historic crop yield data from the period 1972-2008 for corn, soybeans, and wheat; sortable by state total, county level, and NASS crop reporting district.

Minnesota Crop Yield Database

1315k 7/20/2009 More
Used to access historic crop yield data from the period 1972-2008 for corn, soybeans, and wheat; sortable by state total, county level, and NASS crop reporting district.

Illinois Crop Yield Database

1335k 7/20/2009 More
Used to access historic crop yield data from the period 1972-2008 for corn, soybeans, and wheat; sortable by state total, county level, and NASS crop reporting district.

Beef Tool

1030k 11/5/2008 More
Calculates the cost of feed rations for beef cattle, as well as net income produced per cwt., per cow, and per farm after all costs.

Enterprise Allocation and Analysis

955k 9/30/2008 More
Estimates costs of production across farm enterprises.

Ethanol Plant Simulator

1009k 5/12/2008 More
Simulate the performance of a dry mill ethanol plant over a 7-year period

Grain Bin Analysis

742k 2/13/2008 More
Evaluates the feasibility of purchasing a grain bin.

Revolving Loan Calculator

717k 10/23/2006 More
Calculates principal and interest balances for revolving loans.

Repayment Capacity Analysis

1067k 2/8/2006 More
The user can estimate the cash needs required to meet living, debt and investment payments.

Appraisal of Current Financial Position

717k 8/25/2005 More
Evaluates the potential operating loan needs of a farm business by taking a forward look at the business’ income, expenses, and cash flow requirements.

Estimation of Deferred Taxes

724k 8/25/2005 More
Estimates deferred taxes for financial statement preparation.

Land Purchase Analysis

856k 8/25/2005 More
Calculates maximum bid prices for farmland and sensitivity to terms.

Machinery Financing

807k 8/25/2005 More
Calculates annualized cash flows for different methods of financing machinery acquisitions.

Time Value Tools

868k 8/25/2005 More
Computes interest rate factors and solves basic time value of money problems.

Net Worth Allocation

719k 1/9/2005 More
Provides an estimate of the separation of earned net worth and valuation of market valuation equity.

Capital Budgeting

849k 1/9/2005 More
Worksheet to compute net present value, compare price and terms, evaluate IRR and MIRR for basic capital budgeting/investment analysis programs.

Cash to Accrual Income Approximation

752k 1/9/2005 More
Approximates accrual income from schedule F.

MACRS Calculator

748k 1/9/2005 More
Calculates tax depreciation schedules for depreciable items.

Savings Calculator

846k 1/9/2005 More
Calculates how savings accumulates over time and the amount of savings needed to achieve specific targets.

Loan Comparison

952k 1/9/2005 More
Compares terms across different loans and evaluates the benefits of refinancing.

Lease vs. Purchase

894k 1/9/2005 More
Compares lease vs. purchase alternatives and calculates the terms to make the options equivalent in NPV.
Department of Agricultural and Consumer Economics    College of Agricultural, Consumer and Environmental Sciences
Home | Finance | Marketing & Outlook | Management | Law & Taxation
Policy | FAST Tools | Crop Insurance | Prices & Weather
Search | Subscribe | About farmdoc | Contact Us | friends of farmdoc
E-mail: farmdoc@illinois.edu
University of Illinois