Excel Templates For Net Present Value and IRR

Investment-Calc provides all the "financial models" you need to calculate the NPV/ROIC and IRR of business investments, and provides calculators to work out the present value of future receivables or payables, and the PV of future cash flows.

Plus Bond amortization and rate of return spreadsheets.

Investment-Calc 7.3 for NPV & IRR Excel Spreadsheets & Calculators

Provides over 40 spreadsheets, calculators, tables and business databases that help you apply the time base value of calculating investments returns and present values of future payments/receipts:

Includes:

Calculator 1: Present value of cash to be received in the future.

(Adjusts cash receipts for any time delay between due date and receipt).

Calculator 2: Late payment charge between any two dates at any rate.

Calculator 3: Future value of a cash amount compounded from todays date.

Calculator 4: Future value of a cash amount compounded between any two dates.

Calculator 5: Present value of a recurring amount.

Calculator 6 & 7: Present value of an amount any period in the future for any monthly and annual discount rate.

Calculator 8. Continuously compounding discount rates.

Web updates for the following investment data:

Monthly inflation rates, US Treasury bond rates, US Treasury Constant Maturity rates, Libor rates, average cost of capital and cost of equity from 101 US industry sectors.

Project NPV & IRR tables: (2 combined spreadsheets) to 120 months. Cash flow inputs and outflows calculate a cash flow forecast grid and net present values plus internal rate of return.

Project Investment Analysis Modelling (6 combined spreadsheets) provides volume and unit price entry plus quick adjustments to volume & price for sensitivity evaluation, 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. Spreadsheet can be used for any evaluation period up to 15 years.

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

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

Company share valuation calculator: based on discounting future earnings, or cash flows: Switch to a preferred valuation base.

Additional spreadsheet provides alternative ways to evaluate capital investments and prepare EBITDA & ROIC financial models.

Additional download file:

Constant Yield Rate Bond Amortization В# including OID (taxable interest schedules) В# FREE BONUS DOWNLOAD.
These three spreadsheet download are supplied as a free bonus with Investment-Calc 7.3. They provide useful bond amortization schedules (1) incorporating Original Issue Discount schedules (taxable interest) over any repayment period, calculate the constant (level) yield rate per period and per annum and the full interest yield. You can alternatively (3) enter the bond coupon rate and by variation, find the issue price that achieves a target yield to maturity for the bond issue. Incorporates US Government bond yield calculations as well.

Ten database of business prices, indexes and rates. Databases auto refresh when you open the workbook each time using Excels web import command.

Zip file download:

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