Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

NPV & IRR Excel Template for Periodic Cash Flows

 

EXCEL TRAINING / EXCEL DASHBOARD REPORTS

NPV & IRR Excel Template for Periodic Cash Flows <See also: Net Present Value and IRR & Financial & Graphing Calculator>

NPV & IRR Excel Template for Periodic Cash Flows

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.

1.gif (11076 bytes)

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.

3.gif (1588 bytes)

2.gif (10513 bytes)

You can find the results in G3 and H3 cells.

NPV & IRR Excel Template for a schedule that is not necessarily periodic

1x.gif (13012 bytes)

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.

3x.gif (12820 bytes)

You can find the results in H3 and I3 cells.

System Requirements

Platform:

Windows XP / 2000 / 2003 or later. Or NT4 Server,  Windows 9x, Me, NT or Mac.

Requires Excel 97 or later.

Glossary of terms

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 You will be able to download your software immediantley after purchase $52.00 Secure Payment Options

NPV & IRR Excel template  You will be able to download your software immediantley after purchase $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

Developers Site

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 TRAINING / EXCEL DASHBOARD REPORTS

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