The discount rate refers to the interest rate used when calculating the net present value (NPV) of an investment. It represents the time value ... of capital. The Excel formula for calculating ...