Contains our complete collection of 40 spreadsheets, calculators, tables and databases for calculating investments returns and present values of future payments/receipts .

Includes a 30 page Guide that explains all the calculations and equations required for time based value of money:

“I downloaded your Investment Calculations guide and it was exactly what I was looking for. Thank you for your help”. Steve.

Investment-Calc 7.3 provides

Present values and internal rate of return of cash flows in the future, Late payment charge between two dates to maintain present value, Future value of money from todays date, Present value compounded between any two dates, Present value of a recurring dollar amount, Present value of regular investments.

Project NPV & IRR calculation spreadsheets: 120 months cash flow inputs and outflows, net present values plus internal rate of return.

Project Investment Analysis 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.

Portfolio rate of return spreadsheets

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

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

Company valuation: Discounts future earnings, and cash flow basis.

EBITDA analysis and forecasting spreadsheets.

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.

Zip file download:

The download file contains: Investment-Calc 7.3 plus the demo (tutorial) version with help notes and instructions plus the Guide to Investment Calculations. Locate the download file in your C: drive and unzip first of all before you try to run in Excel. There are three separate files contained within the download zip file.