Includes:

Calculator 1: Present values and internal rate of return of cash flows in the future.

Calculator 2: Late payment charge between two dates to maintain present value.

Calculator 3: Future value from todays date.

Calculator 4: Future value compounded between any two dates.

Calculator 5: Present value of a recurring amount.

Calculator 6 & 7: Present value of regular investments.

Shows you how to prepare your own NPV & IRR spreadsheets with charts and Goal Seek.

Project NPV & IRR tables: (2 linked spreadsheets). 120 months cash flow inputs and outflows, net present values plus internal rate of return.

Project Investment Analysis: (6 linked spreadsheets). Inputs unit volume and unit price plus adjustments for sensitivity, cost of sale, company expenses, investment amount, debt/equity, tax rate, depreciation rule. Calculates EBITDA, operating and after tax profits, average annual income and ROIC, net present value & IRR. Calculates continuing value of the project after the forecast horizon has ended.

Annual NPV/IRR cash flow calculations to 60 years. Table.

Monthly NPV/IRR cash flow calculations to 120 months. Table.

Company share valuation: Discounts future earnings, or cash flows.

PLUS >>> Our very own Quick Guide to Investment Calculations (Word document) contains 30 pages packed with equations, explanations and worked examples that form the basis of the Time Value of Money calculations applying Net Present Value and Rate of Return formula. Comparison between straightforward return on capital and break even points in constant dollar terms, and the Net Present Value investment rule based on the discounted cash flow formula. Corrections to Excel NPV and IRR functions fully explained plus applications to company valuations and real estate investments.

Our Guide to Investment Calculations is supplied as a free accompaniment with Investment-Calc 7.3

Topics, formula, explanations include:

Rate of Return formula and payback in constant dollar terms.
Net Present Value rules and calculations incorporating the time value of money.
Explaining discounted cash flow equations.
NPV worked examples.
Internal Rate of Return (IRR) explained.
Impact of accelerated depreciation on capital investment appraisals.
Financial modelling tips.
Adjusting Excel for NPV and IRR calculations.
Applying Goal Seek to determining IRR values.
Share valuation guide.
Applying NPV and IRR to real estate investing.
Plus Quick Guide How to use and apply Investment-Calc 7.3 for Investment return calculations.

CURRENCY > You can set the currency to any symbol by opening the Format menu in Excel and selecting Cells from the drop down list, which produces the Format Cells table. Click Currency and then choose the currency you want to work with from the Symbol panel.