The sum of all these discounted cash flows, representing the total ... Excel formula for calculating the discount rate is ...