 |
| FREE Excel STUFF |
Search |
| Excel Help. Popular |
| NEW! Multiple Excel Search & Links |
| Excel Formulas |
| Excel Macros |
| Excel Newsletter |
| PRODUCTS |
| Up to $139.00 FREE! |
|
Categories & Search |
| Excel Templates |
| Excel Add-ins |
| Excel Training |
| More.... |
| OTHER |
| Excel Development |
|
|
BUY NPV & IRR Excel Template for Periodic Cash Flows <See also: Net Present Value and IRR & Financial & Graphing Calculator>
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.
Platform:
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
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $66.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
NPV & IRR Excel template for periodic cash flows
$67.00
Payment Options/Problems
NPV & IRR Excel template
$68.00
Payment Options/Problems
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
See Also: Net Present Value and IRR & Financial & Graphing Calculator or Excel Templates
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
FREE Excel Help
FREE Download!