Montana State University

Duane Griffith

Montana State University
Extension Economics
P.O. Box 172800
Bozeman, MT 59717-2800

Tel: (406) 994-2580
Fax: (406) 994-4838
E-mail: griffith@montana.edu
Location: 210B Linfield Hall

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Financial & Risk Management Analysis
Software Downloads


Left Click below on bulleted links to run software and
Right Click to Download....

 

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.


The Flask Player files can be viewed on the Internet by left clicking, or to download on to your computer by right clicking as noted throughout.

Note:  Some File Descriptions include an option to view or download a PDF file.  PDF files allow you to see what a program or template does without having to have the software to run the program or template.  This option requires Adobe Acrobat Reader.  Inputs in these files are listed in blue text.  All calculated numbers/results are in black text and/or shaded in yellow. 

You may need to update your Flash player to run the software, to do so click on this link http://get.adobe.com/flashplayer/  to go to the Adobe download site.  After installing the current version of the Flash player, you can return to this site to run Flash enabled software on the web. 

If you don't have Adobe Acrobat, Get Acrobat Reader  Click here for a free download..........

_________________________________________________________________________________________

  • 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.

  • New Comparative Risk Management Analysis: Combo Policy Plans, Futures, Options (Right click to download) Updated February 2011

    There are two versions of this software posted here.  These version are identical except for the sample data loaded in each version.  One version has a Winter Wheat example and the other version has a spring wheat example built in.  In either version, you are allowed to change all relevant information and each version will give the same answer if the same set of information is entered.  The only difference is the built in example.

    Winter Wheat Example (Revised June 2011)
    Spring Wheat Example

    This software allows comparison of multiple levels of yield, price and revenue protection offered by futures and options contracts in combination with the new Combo Policy Plans offered by RMA.  The second portion of this manual provides examples of specific risk management strategies and how the available tools can be combined to implement effective strategies for “typical” situations to the worst case scenario.

    The Combo Policy consolidated several previous insurance policies into one policy.   The Combo Policy uses the Futures and Options markets when establishing the RMA Projected Harvest Price and Harvest Price.  Familiarity with all three of these risk protection tools will help evaluate possible risk protection strategies offered by any combination of these alternatives.  For comparative analysis, this software includes adjustments for the differences in the way futures, options and Combo Policy “plans” are implemented and the transactions cost incurred for each product so the bottom line provides an accurate comparison. (View/download user manual (PDF)

  • 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. 

  • New Loan Payment Comparisons (Right click to download)
    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.

  • RDFinancial

    This program is an Excel based template that has been compiled into a Flash file.  It’s intended use is to teach WHY producers should complete a full set of financial statements to assure adequate financial analysis for an operation.  RDFinancial is a very condensed version of financial statements that show the interaction and information flow among the four basic financial statements. A case farm built in to RDFinancial allows users to immediately see the financial implications of various types of transactions, such as increasing owner withdrawals, availability of off-farm inflows into the business, changes in cost of production or revenue for the case farm, debt load and structure, as well as many other aspects that affect the businesses financial position and performance. In addition to the financial statements, the Sweet Sixteen ratios recommended by the Farm Financial Standards Guidelines are calculated for the case farm.  The user is allowed to switch between screens to evaluate the implications of possible changes in the case farm data and the implications on the financial statements as well as the ratios and credit scores.  These ratios are also used in a simple credit scoring model that produces a credit score for an Operating and a Long Term loan.  This version of RDFinancial also allows the user to build example farm/ranch operations.  Download the Quick Start Tutorial for the version of the RDFinancial selected below on how to get started using RDFinancial.  

    The image of the Financial Statements page shows the condensed nature of the financial statements as well as one of the ways you can interact with the RDFinancial program.


    RD Financial Image

    Flash file versions:  (Right click to download):

    Presentation material and software used at the Ag Appreciation Weekend, October 28, 2011 in Bozeman, Montana.

    The theme for the held in conjunction with the annual Ag Appreciation Weekend activities in 2011 was Montana Agriculture in Volatile Times. Presentations included: U.S. and World Agriculture Status, Montana Agriculture Status, Government Debts and Deficits, The Farm Bill and the Debt Crisis, Volatility of Grain Prices, Volatility of Livestock Prices and Volatility of Input Prices and Montana’s Economic Outlook.

    The presentations on the volatility of grain, livestock and input prices utilized software to estimate the implications of this volatility on Montana grain and livestock operations.  Three Case Farm/Ranch operations were used.  Links to the presentation and the software for the Case Farm/Ranch operations are show below.

  • Quick Start Tutorial for these three Case Farm/Ranch Operations (PDF)THIS IS VERY IMPORANT INFORMATION, PLEASE READ

  • Montana Representative Large Small Grains Farm:
    Presenter: Anton Bekkerman
    RDFinancial Case Farm (right click to download)
    Slide Presentation (cannot be downloaded)

  • Montana Representative Large Livestock Operation
    Presenter: Eric Belasco
    RDFinancial Case Ranch (right click to download)
    Slide Presentation (PDF)

  • Montana Representative Farm/Ranch Operation:
    Presenter: Duane Griffith
    RDFinancial Case Farm/Ranch (right click to download)
    Slide presentation (PDF)

Other example RDFInancial Files: