Farmdoc Search Subscribe About Contact Us friends of farmdoc
Home
Finance
AgMAS
Management
Law & Taxation
Policy
FAST Tools
AgMAS
Crop Insurance
Presentations
Prices & Weather
Web Resources
Visit farmgate

farmdoc Sponsors

farmdoc Sponsors

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

Financial Analysis

Download

Tool

Size Date User Guide Demo

Appraisal of Current Financial Position

717k 8/25/2005 More Demo

Evaluates the potential operating loan needs of a farm business by taking a forward look at the business’ income, expenses, and cash flow requirements.

Balance Sheet & Historical Financial Statements

1406k 6/20/2014 More Demo

Prepares financial statements for a farm based on beginning and ending balance sheets and revenue and expense items.

Benchmark Ratio Analysis

2346k 2/13/2008 More Demo

Provides key ratio calculations and benchmarks for Illinois farms based on Sales, Age, Farm Type, Tenure, and All Farms.

Cash Flow Planning

1448k 6/20/2014 More Demo

Prepares monthly pro-forma cash flows for an operation.

Cash to Accrual Income Approximation

752k 1/9/2005 More Demo

Approximates accrual income from schedule F.

Estimation of Deferred Taxes

724k 8/25/2005 More Demo

Estimates deferred taxes for financial statement preparation.

Ethanol Plant Simulator

1009k 5/12/2008 More

Simulate the performance of a dry mill ethanol plant over a 7-year period

Farm Bill Scenario Analyzer

1089k 9/6/2007 More

Compares payments between the 2007 Farm Bill alternatives: The Bill passed by the House and the Durbin-Brown amendment offered in the Senate.

Net Worth Allocation

719k 1/9/2005 More Demo

Provides an estimate of the separation of earned net worth and valuation of market valuation equity.

New Company Simulator

1454k 10/28/2009 More

With this program, the user can project earnings, financial conditions, and break even levels and prices

Personal Financial Statements

2295k 8/27/2009 More

Prepares a family budget that produces a balance sheet and an income statement.

Quick Cash Flow Projections

2050k 5/13/2013 More Demo

Prepares a quarterly cash flow projection and performs sensitivity analysis.

Ratio Calculator

1396k 2/8/2006 More Demo

Calculates the key financial ratios and provides a financial health index for levels and trends.

Repayment Capacity Analysis

1067k 2/8/2006 More

The user can estimate the cash needs required to meet living, debt and investment payments.

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.


Investment Analysis

Download

Tool

Size Date User Guide Demo

Capital Budgeting

849k 1/9/2005 More Demo

Worksheet to compute net present value, compare price and terms, evaluate IRR and MIRR for basic capital budgeting/investment analysis programs.

Grain Bin Analysis

742k 2/13/2008 More

Evaluates the feasibility of purchasing a grain bin.

Land Purchase Analysis

856k 8/25/2005 More Demo

Calculates maximum bid prices for farmland and sensitivity to terms.

Lease vs. Purchase

894k 1/9/2005 More Demo

Compares lease vs. purchase alternatives and calculates the terms to make the options equivalent in NPV.

Machinery Financing

807k 8/25/2005 More Demo

Calculates annualized cash flows for different methods of financing machinery acquisitions.

MACRS Calculator

748k 1/9/2005 More Demo

Calculates tax depreciation schedules for depreciable items.

Savings Calculator

846k 1/9/2005 More Demo

Calculates how savings accumulates over time and the amount of savings needed to achieve specific targets.

Time Value Tools

868k 8/25/2005 More Demo

Computes interest rate factors and solves basic time value of money problems.


Loan Analysis

Download

Tool

Size Date User Guide Demo

Loan Amortization

1257k 11/7/2011 More Demo

Simple loan amortization program calculating principal, interest and outstanding balance.

Loan Comparison

952k 1/9/2005 More Demo

Compares terms across different loans and evaluates the benefits of refinancing.

Revolving Loan Calculator

717k 10/23/2006 More Demo

Calculates principal and interest balances for revolving loans.


Farm Management

Download

Tool

Size Date User Guide Demo

ACRE Comparison Program

2584k 5/5/2010 More

This program compares payments under ACRE and Traditional commodity program options available in the 2008 Farm Bill.

ACRE Payment Estimator

848k 4/14/2013 More

This program allows the user to estimate ACRE Payments.

Cash Rent with Bonus Worksheet

1146k 9/26/2011 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.

Corn-Soybeans Rotation Tool

1160k 1/15/2010 More Demo

The user can evaluate the economic returns of changing corn-soybeans rotations.

Corn-Soybeans-Wheat Rotation Tool

1109k 1/15/2010 More Demo

The user can evaluate economic returns of changing corn-soybeans-wheat rotations.

Crop Insurance Calculator

753k 1/9/2005 More Demo

Compares gross revenue under different crop insurance products.

Enterprise Allocation and Analysis

955k 9/30/2008 More Demo

Estimates costs of production across farm enterprises.

Farmland Lease Analysis

1280k 1/15/2010 More Demo

Calculates revenues, costs, and returns for share rent, cash rent, and dry bushel farmland leases.

Grain Farm Budget and Projection Tool

8659k 6/20/2014 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.

Machinery Economics

1197k 6/20/2014 More Demo

Analyzes the cost of completing fieldwork and generates machinery costs.

Planting Decision Model

1323k 6/20/2014 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.


Livestock Management

Download

Tool

Size Date User Guide Demo

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.

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.

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.


Grain Marketing and Management

Download

Tool

Size Date User Guide Demo

Corn & Soybean Basis Tool

1003k 10/12/2006 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.

Grain Inventory Management

882k 9/27/2007 More Demo

Inventory accounting system to track grain inventory from harvest to sale.

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.


Risk Management

Download

Tool

Size Date User Guide Demo

2014 Crop Insurance Decision Tool - Fall

24612k 9/20/2013 More

Calculates premiums, evaluates insurance payments, and provides historical data useful when making crop insurance decisions for multiple crops. Updated for wheat Fall 2013. Estimates are for crops in states that are harvested in 2014.

2013 Crop Insurance Decision Tool - Spring (Excel 2007+)

24716k 3/15/2013 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 2013.*Specifically for MS Excel 2007 and later*

2013 Crop Insurance Decision Tool - Spring (Excel 2003)

24712k 3/15/2013 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 2013.*Specifically for MS Excel 2003*

2013 Crop Insurance Decision Tool - Fall

20633k 9/12/2012 More

Calculates premiums, evaluates insurance payments, and provides historical data useful when making crop insurance decisions for multiple crops. Updated Fall 2012 for wheat. Estimates are for crops in states that are harvested in 2013.

2012 Crop Insurance Decision Tool - Spring

23361k 2/11/2013 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 2012.

2011 Crop Insurance Decision Tool

23509k 3/11/2011 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 2010.

2010 Crop Insurance Decision Tool

29164k 3/8/2010 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 2010.

2009 Crop Insurance Decision Tool

14644k 3/3/2009 More

Calculates premiums, evaluates insurance payments, and provides historical data useful when making crop insurance decisions for multiple crops. Estimates are for crops in midwest and southeast states that are harvested in 2009.

Late Planting Evaluator

1120k 6/19/2009 More

This program is designed to aid farmers evaluate the economic alternatives of late planting for three options given that a crop has not been planted

2014 Crop Insurance Decision Tool - Spring

28210k 3/7/2014 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 2014.

Farm Rent Evaluator

8642k 6/20/2014 More Demo

Compares the risks and returns of different leases.

Marketing and Crop Insurance Risk Model

1902k 10/28/2009 More Demo

With this program, the user can estimate the impact alternative risk management strategies have on gross revenue distributions.


Yield and Land Database Tools

Download

Tool

Size Date User Guide Demo

Illinois Crop Yield Database

1335k 7/20/2009 More Demo

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 Farmland Sales Database

2800k 6/8/2001 More

Database tool used to retrieve and analyze actual Illinois Farmland Sales data from 1979-2000 forecast. Price per acre, acreage, and turnover statistics, as well as individual parcel information can be accessed, and screened by specific acreage and price

Illinois Soil Productivity Index Utilities

908k 10/1/2013 More

Designed to assist with common computations related to the Illinois Soil Productivity measures and associated predicted yields.

Indiana Crop Yield Database

1360k 7/20/2009 More Demo

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.

Iowa Crop Yield Database

1381k 7/20/2009 More Demo

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.


Department of Agricultural and Consumer Economics    College of Agricultural, Consumer and Environmental Sciences
Home | Finance | Marketing & Outlook | Management | Law & Taxation
Policy | FAST Tools | AgMAS | Crop Insurance | Prices & Weather | Ag Links
Search | Subscribe | About farmdoc | Contact Us | friends of farmdoc
E-mail: farmdoc@illinois.edu
University of Illinois