The Excel formula for calculating the discount rate ... to solve for the discount rate that equals zero. Take our NPV/IRR example. We’ve calculated an NPV of $472,169 with an IRR of 57% using ...

IRR is a discount rate that makes the net present value (NPV ... to calculate IRR (e.g., using Excel). How to Calculate IRR in Excel Using the IRR function in Excel makes calculating the IRR ...