Problem 5-26 You have an outstanding student loan with required payments of $500 per month for the next four years. The interest rate on the loan is 9% APR (monthly). You realize your best investment is to prepay your student loan, so you decide to prepay as much as you can each month. Looking at your budget, you can afford to pay an extra S250 per month in addition to your required monthly payments of S500, or $750 in total each month. How long will it take you to pay off the loan? Original payment Years remaining 500 9% 750 New payment Periods per year Monthly Rate Periods remaining Loan balance Periods to payoff 12 14 17 18 Requirements 19 1 In cell D12, by using cell references, calculate the monthly rate (discount rate) (1 pt.). 2 In cell D13, by using cell references, calculate the number of periods remaining on the loan (1 pt.) In cell D14, by using cell references, calculate the amount that you owe on the loan. Note: The output of the expression or function you typed in this cell is expected as a positive number. (1 pt.). In cell D15, by using cell references, calculate the number of periods that it will take you to pay off your student loan (1 pt.). 3 21 4