While IRR is popular for assessing the profitability of potential investments, it has several limitations. Excel has three functions to calculate the IRR: IRR, the modified IRR (MIRR), and IRR ...

You can solve for the discount rate in Excel in two ways: 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 ...