The Excel formula for calculating the discount rate is =RATE (nper, pmt, pv, [fv], [type], [guess]). It’s often used to calculate the interest rate for a loan or determine the rate of return ...