It represents the time value of ... The formula for calculating the discount rate in Excel is =RATE (nper, pmt, pv, [fv], [type], [guess]). NPV is the difference between the PV of cash flows ...