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 ...