Investment Analysis Tools
Worksheets and calculators are useful tools for analyzing investment opportunities.
Use this worksheet to evaluate a value-added business investment opportunity. Evaluating Agricultural Value-Adding Business Opportunities for Equity Participation provides an explanation of how to use the worksheet.
For more information on this topic, see the links listed below of additional calculators and worksheets posted on related Web sites.
- Capital Budgeting – University of Illinois Extension -- Worksheet to compute net present value, compare price and terms, evaluate IRR and MIRR for basic capital budgeting/investment analysis programs.
- Lease vs. Purchase - University of Illinois Extension -- Compares lease vs. purchase alternatives and calculates the terms to make the options equivalent in NPV.
- Asset Allocator – CCH Financial Planning Toolkit – Your age, ability to tolerate risk and several other factors are used to calculate a desirable mix of stocks, bonds and cash.
- Investment Loan – CCH Financial Planning Toolkit -- This calculator helps illustrate the effect of using a loan to purchase an investment or appreciable asset. Using debt as leverage to purchase investments can magnify your return. The downside is that you also increase your risk.
- Investment Returns – CCH Financial Planning Toolkit -- There is more to investing than knowing your annual rate of return. Use this calculator to help you see how inflation, taxes and your time horizon can impact your bottom line.
- Compound Interest and Your Savings – CCH Financial Planning Toolkit – This calculator demonstrates how compounding can affect your savings.
- Investor Offering - Bplans.com - Use this calculator to view both sides of the investment table. See what an investor gets, and what a company gives up all in one easy tool.
- Business Valuation – LawInfo.com -- Enter your cash flow information, your cost of capital and your growth rate to determine your business NPV valuation.
- Discounted Cash Flow Calculator - Bplans.com - Analysts use discounted cash flow to explore the "time value of money". Essentially, money today is worth more than the same amount of money tomorrow. This calculator helps you explore this concept.