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
Appraisal of Current Financial Position
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
Prepares financial statements for a farm based on beginning and ending balance sheets and revenue and expense items.
Benchmark Ratio Analysis
Provides key ratio calculations and benchmarks for Illinois farms based on Sales, Age, Farm Type, Tenure, and All Farms.
Cash Flow Planning
Prepares monthly pro-forma cash flows for an operation.
Cash to Accrual Income Approximation
Approximates accrual income from schedule F.
Estimation of Deferred Taxes
Estimates deferred taxes for financial statement preparation.
Ethanol Plant Simulator
Simulate the performance of a dry mill ethanol plant over a 7-year period
Farm Bill Scenario Analyzer
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
Provides an estimate of the separation of earned net worth and valuation of market valuation equity.
New Company Simulator
With this program, the user can project earnings, financial conditions, and break even levels and prices
Personal Financial Statements
Prepares a family budget that produces a balance sheet and an income statement.
Quick Cash Flow Projections
Prepares a quarterly cash flow projection and performs sensitivity analysis.
Ratio Calculator
Calculates the key financial ratios and provides a financial health index for levels and trends.
Repayment Capacity Analysis
The user can estimate the cash needs required to meet living, debt and investment payments.
Specialty Commodity Breakeven Analysis
With this program, the user can enter budgets and calculate break even levels for a set of specialty commodities.
Investment Analysis
Capital Budgeting
Worksheet to compute net present value, compare price and terms, evaluate IRR and MIRR for basic capital budgeting/investment analysis programs.
Grain Bin Analysis
Evaluates the feasibility of purchasing a grain bin.
Land Purchase Analysis
Calculates maximum bid prices for farmland and sensitivity to terms.
Lease vs. Purchase
Compares lease vs. purchase alternatives and calculates the terms to make the options equivalent in NPV.
Machinery Financing
Calculates annualized cash flows for different methods of financing machinery acquisitions.
MACRS Calculator
Calculates tax depreciation schedules for depreciable items.
Savings Calculator
Calculates how savings accumulates over time and the amount of savings needed to achieve specific targets.
Time Value Tools
Computes interest rate factors and solves basic time value of money problems.
Loan Analysis
Loan Amortization
Simple loan amortization program calculating principal, interest and outstanding balance.
Loan Comparison
Compares terms across different loans and evaluates the benefits of refinancing.
Revolving Loan Calculator
Calculates principal and interest balances for revolving loans.
Farm Management
Cash Rent with Bonus Worksheet
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.
ACRE Comparison Program
This program compares payments under ACRE and Traditional commodity program options available in the 2008 Farm Bill.
ACRE Payment Estimator
This program allows the user to estimate ACRE Payments.
Corn-Soybeans Rotation Tool
The user can evaluate the economic returns of changing corn-soybeans rotations.
Corn-Soybeans-Wheat Rotation Tool
The user can evaluate economic returns of changing corn-soybeans-wheat rotations.
Crop Insurance Calculator
Compares gross revenue under different crop insurance products.
Enterprise Allocation and Analysis
Estimates costs of production across farm enterprises.
Farmland Lease Analysis
Calculates revenues, costs, and returns for share rent, cash rent, and dry bushel farmland leases.
Grain Farm Budget and Projection Tool
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
Analyzes the cost of completing fieldwork and generates machinery costs.
Planting Decision Model
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
Beef Tool
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
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
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
Corn & Soybean Basis Tool
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
Inventory accounting system to track grain inventory from harvest to sale.
Grain Pricing Tool
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
2013 Crop Insurance Decision Tool - Spring (Excel 2007+)
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)
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
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.
2012 Crop Insurance Decision Tool
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
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
2009 Crop Insurance Decision Tool
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
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
Farm Rent Evaluator
Compares the risks and returns of different leases.
Marketing and Crop Insurance Risk Model
With this program, the user can estimate the impact alternative risk management strategies have on gross revenue distributions.
Yield and Land Database Tools
Illinois Crop Yield Database
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
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
Designed to assist with common computations related to the Illinois Soil Productivity measures and associated predicted yields.
Indiana Crop Yield Database
Iowa Crop Yield Database
Minnesota Crop Yield Database