Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet a. Complete an amortization schedule for a $48,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 10% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest Balance 1 $ 19301 03 $ 4800 22 of Principal 33499 s 15951 (3 $ 175483 $ 48000 s 33499 $ 17548 $ $ 19301 * $ 19301 3$ 3350 (3 s 1753 s 334993 17548