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.
Net Worth Allocation
Provides an estimate of the separation of earned net worth and valuation of market valuation equity.
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.
Quick Cash Flow Projections
Prepares a quarterly cash flow projection and performs sensitivity analysis.
Personal Financial Statements
Prepares a family budget that produces a balance sheet and an income statement.
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.
Ethanol Plant Simulator
Simulate the performance of a dry mill ethanol plant over a 7-year period
New Company Simulator
With this program, the user can project earnings, financial conditions, and break even levels and prices
Specialty Commodity Breakeven Analysis
With this program, the user can enter budgets and calculate break even levels for a set of specialty commodities.