It represents the time value of money ... of zero if the cost of capital equals the return of capital. The Excel formula for calculating the discount rate is =RATE (nper, pmt, pv, [fv], [type ...

There are literally hundreds of Excel functions to choose from, with some estimates ranging at around 500. These functions cut short computing or calculating time, and aggregate data for a ...