The IRR_NPV.xlsx Model

The relationship between IRR() and NPV()

View the model
Download the model

The IRR of a stream of cash flows is an interest rate at which the NPV = 0.								
 If the stream of cash flows as > 1 sign reversal, then there may be multiple IRR's.								
What'sBest! does not support IRR,   however, it does support NPV.

Keywords:

Excel | WhatsBest | What'sBest | What'sBest! | What's Best | Internal rate of return | IRR | Net present value | NPV |