Program
|
Description
|
Version
|
Date
Updated
|
Detailed
Description
|
| Financial
Planning |
Appraisal of
Current Financial Position
|
Simple
spreadsheet format for worksheet of Appraisal of Current Financial
Position |
1.1 |
12/1/99 |
 |
Cash
Flow Planning
|
Prepares
monthly pro-forma cash flows for an operation |
2.3 |
1/11/02 |
|
| Earned
Net Worth Calculator |
Provides
an estimate of the separation of earned net worth and valuation
of market valuation equity |
1.1 |
2/1/01 |
|
Financial
Statement Preparation
|
Prepares
financial statements for a farm based on beginning and ending
balance sheets and revenue and expense items |
1.5 |
12/1/99 |
|
| Deferred
Taxes Calculator |
Estimates
deferred taxes for financial statement preparation |
1.1 |
2/1/01 |
|
| Schedule
F to Accrual Income Approximation Tool |
Approximates
accrual income from schedule F |
1.1 |
2/1/01 |
|
| Investment
Analysis
|
|
|
|
|
Capital Budgeting
Analysis
|
Worksheet to compute net present value, compare price and terms,
evaluate IRR and MIRR for basic capital budgeting/investment
analysis programs. |
2.0 |
10/1/00 |
|
Grain
Bin Feasibility Analysis
|
Evaluates
the feasibility of purchasing a grain bin |
1.1 |
10/1/00 |
|
Land
Purchase Analysis
|
Calculates maximum bid prices for farmland and sensitivity to
terms |
2.0 |
1/11/02 |
|
Lease
vs. Purchase Analysis
|
Compare lease vs. purchase alternatives and calculate the terms
to make the options equivalent in NPV |
2.0 |
1/11/02 |
|
Machinery
Financing Model
|
Calculates
annualized cash flows for different methods of financing machinery
acquisitions |
1.4 |
11/18/01 |
|
MACRS Depreciation
|
Calculates
tax depreciation schedules for equipment purchases |
2.1 |
3/1/01 |
|
Time Value of
Money Factors
|
Uses
time value of money concepts in investment and financing decisions |
1.1 |
1/11/02 |
|
| Loan
Analysis
|
|
|
|
|
Loan Amortization
|
Simple
loan amortization program calculating principal, interest and
outstanding balance |
2.7 |
3/1/01 |
|
Loan
Comparison
|
Compares
terms across different loans and evaluate the benefits of refinancing. |
1.1 |
1/11/02 |
|
Revolving
Loan Calculator
|
Calculates
principal and interest balances for revolving loans |
1.0 |
10/1/00 |
|
| Other
Farm & Financial Management Tools |
Break
Even Analysis
|
Estimates
break even prices and produces a simple cash flow for a grain
farm |
1.1 |
6/8/01 |
|
Crop
Storage Decision Program
|
Calculates
the breakeven price of storage |
1.1 |
1/11/02 |
|
| Enterprise
Analysis |
Estimates
costs of production across farm enterprises |
2.01 |
1/11/02 |
|
Farmland
Lease Analysis
|
Calculates
revenues, costs, and returns for share rent, cash rent, and
dry bushel farmland leases |
1.1 |
6/8/01 |
|
MACRS Depreciation
|
Calculates
tax depreciation schedules for equipment purchases |
2.1 |
3/15/01 |
|
Machinery
Economics
|
Analyzes
the cost of completing fieldwork and generates machinery costs. |
1.1 |
1/11/02 |
|
Insurance
Payment Calculator
|
Compares
gross revenue under different crop insurance products |
1.1 |
7/1/99 |
|
| Farm
Data Base Tools |
Illinois
Historic Crop Production
|
County
Level Corn, Soybeans, and Wheat histories sortable by county
and time period |
2.1 |
3/16/02 |
|
Illinois
Historic Farmland Transactions
|
Actual
farmland transfers sortable by county, time period, and transaction
type |
2.1 |
6/8/01 |
|
