Ans: 1. To calculate IRR using the formula, one would set NPV equal to zero and solve for the discount rate, which is the IRR.
2. Using the IRR function in Excel makes calculating the IRR easy.
3. Excel also offers two other functions that can be used in IRR calculations, the XIRR and the MIRR.