The formula is: NPV = ∑ {After-Tax Cash ... The Excel formula for calculating the discount rate is =RATE (nper, pmt, pv, [fv], [type], [guess]). It’s often used to calculate the interest ...