How to Calculate IRR in Excel Using the IRR function in Excel makes calculating the IRR easy. Excel does all the necessary work for you, arriving at the discount rate you are seeking to find.

NPV is essential to corporate budgeting. Excel can find the internal rate of return (IRR) and use that as the discount rate for an NPV of zero. Let’s begin by examining each step of NPV in order.