The IRR_NPV01.xlsx Model

The Relationship between IRR() and NPV() of Excel.

View the model
Download the model

The IRR (Internal Rate of Return) of a stream of cash flows over time is an interest rate at which the NPV (Net Present Value) = 0.					
 If the stream of cash flows has > 1 sign reversal, then there may be multiple IRR's.					
What'sBest! does not support IRR,   however, it does support NPV.					
This can be used to compute IRR, by adding a constraint that NPV = 0.

Keywords:

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