It’s often used to 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 in two ...