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.

MS Excel and Google Sheets have three functions for calculating the IRR. When using different borrowing rates of reinvestment, a modified MIRR is the formula to use. The XIRR function accounts for ...