Find the IRR in Excel by employing the IRR function, then use it as the discount rate that causes NPV to equal zero. Use What-If analysis, a built-in calculator in Excel, to solve for the discount ...

Once a company has their customized modern data stack in place, a calculation like IRR starts to look a little different. Calculating an IRR using a modern data stack Where Excel’s IRR calculations ...

MIRR function is available in Excel, so its application is as simple as application of IRR. If you are still not persuaded to stop using IRR, I recommend to think thoroughly about the result.