Investment-Calc PRO Version 7.3 Excel Spreadsheets

Templates, Benchmarks, Calculators for Net present value and rate of return values of Net Present Values. Investment Pay Back Periods, ROIC, EBITDA, Portfolio returns, option calculators and web imported current investment rates and market data.

*Web data requires Excel 2000 and above.

Investment-Calc 7.3 for NPV/IRR Analysis

Overview

Investment-Calc PRO 7.3 is our latest version (September 2004) of this tried and tested investment analysis tool for Excel. There are over 50 NPV/IRR cash flow templates, lots of help instructions & guides, financial databases and tables available plus financial data from web sites.

Menu of templates and information pages

The program calculates Internal Rates of Return, ROIC, Payback, after tax cash flows, present values, Accounting Rate of Return, Share Valuation & Economic Valuations with variable equity/debt financing ratios, and risk analysis over any forecast period. Investment-Calc incorporates self generating tables that calculate straight line and MACRS depreciation and tax calculations.

Investment-Calc 7.3 provides:

1. Excel calculators for: Present values, cost of capital, rate of return required, discount rates, continuous adjustments, Continuing Value, Share Valuation.
2. Linked spreadsheets for creation of business investment evaluation models using discounted cash flow with quick and easy adjusters to review alternative assumptions and resulting returns.
3. Imported financial data from useful web sites, converted to Excel databases for easy referencing.

Below are a selection of 8 screen graphics out of 65 calculators, spreadsheets, help guides, explanations and templates provided:

Present Value & Compounding calculators for Excel from/to any future date. T-Bill rate values are imported via Web Query.

Imported financial data transposed to easy lookup combo boxes.

Start calculating NPV & IRR using Goal Seek as well as Excel IRR.

Preparing Base Case Investment Appraisal and risk adjustment figures using these instructions and templates.

After tax analysis Base Case forecast adjusted by varying unit volumes and price levels.

After tax analysis Base Case forecast adjusted by varying unit volumes and price levels.

Use Continuing Value calculations to include project value beyond the forecast period.

Quick NPV/IRR forecasting schedules for annual projections (to 60 years) and monthly (to 120 months).

Share Valuation:
Value on earnings or cash flow projections.

Basic accounting returns & EBIT forecasting, and IRR of a profit forecast.