It represents the time ... calculate the interest rate for a loan or determine the rate of return required to meet a particular investment objective. You can solve for the discount rate in Excel ...