The Excel formula for calculating the discount rate is =RATE (nper ... It facilitates audits of a discounted cash-flow model. It illustrates the effect of compounding. It’s an alternative ...