The IRR is the rate of growth that an investment must generate ... cost of capital equals the return of capital. The Excel formula for calculating the discount rate is =RATE (nper, pmt, pv ...

The internal rate of return (IRR) is a metric used in capital budgeting to estimate the return of potential investments. MS Excel and Google Sheets have three functions for calculating the IRR.