For questions 7-8, use Excel to construct an amortization schedule that will display information for only a chosen year of the amortization term (along with totals). You will need to include a method to have someone select a year, and your amortization schedule should update automatically when the chosen year changes. 7. Catherine received a student loan of $30,000 at 3.73% compounded monthly. She makes semi-monthly (twice a month) end-of-period payments for eight years to settle the loan. 8. John Stubbs wants to expand his prosthetics company and borrows $400,000 at 5.63% compounded daily. The loan is amortized over 20 years with payments made at the end of every month