Investment-Calc 7.3 provides ready made NPV/ROIC and IRR spreadsheet calculators for Excel.
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.
New optional spreadsheet provides Real Estate IRR solutions. For any real estate investment project calculates the internal rate of return for any variation of payment receipts dates and disposal month end. Please ask us to add this new workbook (free with purchase of Investment-Calc) if you would like to use Real Estate IRR solutions.
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.
