The IRR is the rate of growth that ... The Excel formula for calculating the discount rate is =RATE (nper, pmt, pv, [fv], ...