You need a good preowned car following college. For the car you want, you need a loan of \($12\),000. With your limited credit record and the best rate available to you being 10 percent, you have decided to get creative. You know your grandparents are financially comfortable and are invested rather conservatively. You guess their average return is 7 percent or less. You propose, and they accept, the win-win proposition that they loan you the \($12\),000 at 8.5 percent, splitting the difference between their 7 percent and your best alternative, 10 percent. End-of-year payments will be made. Your grandparents want to see some different repayment schedules over 5 years. Develop an Excel®

table to illustrate to show your grandparents various cash flow profiles, assuming payback follows

a. Plan 1: Pay the accumulated interest at the end of each interest period and repay the principal at the end of the loan period.

b. Plan 2: Make equal principal payments, plus interest on the unpaid balance at the end of the period.

c. Plan 3: Make equal end-of-period payments.

d. Plan 4: Make a single payment of principal and interest at the end of the loan period.

e. A different plan: Pay an amount of principal at the end of the first year, then increase it each year thereafter by 20 percent, just paying off the loan principal at the end of the fifth year. In addition, pay the accumulated interest at the end of each interest period.