This spreadsheet allows to calculate the NPV & IRR values for a schedule with periodic cash flows (for example annual). If you need an Excel template for a schedule that is not necessarily periodic, please see below.
Please note that you can enter the values for up to 65533 cash flow periods.
When you enter "Calculate" button, you will see the screen below.
You can find the results in G3 and H3 cells.
Please note that is this case the template has the column "Date". When you enter your data and click on "Calculate" button, you will see the screen below.
You can find the results in H3 and I3 cells.
Windows XP / 2000 / 2003 or later. Or NT4 Server, Windows 9x, Me, NT or Mac.
Requires Excel 97 or later.
The NPV (net present value) of an investment is the current value of a future series of payments and receipts.
The IRR (internal rate of return) is the interest rate received for an investment consisting of payments and receipts that occur at regular intervals.
ROI - Return Of Investment.
ROR - Return Of Relationship.
EVA - Economical Value Added.
ROA - Return of Assets (Net Income / Total Assets).
DCF - Discounted Cash Flow.
EBIT - Earnings Before Interest & Tax Forecasts.
ROIC - Return of Investment Capital Forecasts.
EOQ - Economic Order Quantity
NPV & IRR Excel template for periodic cash flows $52.00 Secure Payment Options
NPV & IRR Excel template $52.00 Secure Payment Options This price includes two Excel templates: 1. NPV & IRR Excel template for periodic cash flows. 2. NPV & IRR Excel Template for a schedule that is not necessarily periodic
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $68.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Try out; Invoice Template | Investment and Business Valuation Templates | Multiple Regression Analysis & Forecasting Template | Portfolio Optimization Template | Portfolio Tracking & Monitoring Templates | Project Planning & Management Template | Real Option Valuation Template | XLS Converter | AnalyzerXL | DownloaderXL | SmartVBA | TraderXL Pro (best Value)| Excel PivotTable Gear | Pivot4U | Workbook Splitter | Merge Excel Files | XL Fusion | Find Replace Excel | ConsolidateXL | MORE>>
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft