|
> Extension Economics > Farm Management
Software Downloads
Financial Management & Analysis
Click below on bulleted links to download software....
MACRO ALERT: Some of these spreadsheets contain macros to help print results for the program. You can download these spreadsheets to your computer but may still get a warning about macros. If you choose to open the spreadsheet on the Web, you may get a security message if your security settings on your computer are set at the highest level.
If you get a security warning, click okay. The program will open on the Web, but the print macros will not work.
- Beginning Balance Sheet
Allows producers to prepare a beginning balance sheet by entering information into schedules. The information is then transferred to a balance sheet. Additional misc information can be entered directly into the balance sheet. Calculates deferred taxes on current and non-current assets. Can be used by itself as well as with other linked programs. Conforms to Farm Financial Standards Guidelines (FFSG). View/download pdf file.
- Biodiesel Cash Flow/Income Statement Worksheet
This worksheet allows users to compare small scale oilseed processing and biodiesel production options based on their specific situation. This worksheet may be downloaded for your personal use.
- Capital Investment Analysis
Uses capital investment analysis to analyze alternative potential investments.
- Cash Flow Budgeting
Allows one to prepare a cash flow statement by filling in schedules. Any misc information can be entered directly into the cash flow statement. Also includes an Income Statement. Information directly shared with the Cash Flow Statement is transferred directly to the Income Statement. Both cash and accrual income are calculated. Accrual adjustment requires beginning and ending balance sheet information.
- Cash Flow Simple
A simple cash flow statement that doesn't require the user to provide information on supporting schedules, which is then transferred from the schedule to the cash flow statement. See below for a more detailed version of a cashflow, with schedules. View/download a pdf file.
- Ending Balance Sheet
Allows the user to prepare an ending balance sheet from schedules. The schedule information is then transferred to the balance sheet. Calculates deferred taxes for current and non-current assets and liabilities. Conforms to FFSG. View/download pdf file.
- Financial Statements
The 5 financial statement spreadsheets listed below are combined into one spreadsheet.
 Loan Payment Comparisons
This program allows the user to view the payments (principal and interest combined) for various loan amounts, loan periods and interest rates. The use can use sliders to change the basic parameters of a loan and evaluate the impact on loan payments for a change in one or more parameters.
- Owner's Equity
Used to reconcile financial statements. Information from beginning and ending balance sheets, the income statement, and the cash flow statement are required. This reconciles those statements.
- Ratios
Calculates the "Sweet 16" financial ratios and measures suggested by the FFSG. Uses information from other spreadsheets.
- Time Value of Money (Including 4 separate programs)
Combines the 4 programs that deal with the value of money. The programs deal with 1) annuities where you calculate how to reach a goal, 2) you currently have a fixed sum or annuity to invest and you want to know how much it will be worth in the future, 3) detailed loan amortization schedules, 4) quick comparisons of various loan amortization scenarios.
- Whole Farm Budgeting
Allows the specification of production intentions for an entire operation. Includes 3 simple plans, a land use plan, a livestock plan, and a livestock feed plan.
|
