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 ...

The projected cash inflows and outflows for each proposed project are as follows: Image source: The Motley Fool In Excel, you can use the program's XIRR function to solve for "r" -- the IRR -- for ...