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 HHH Open spreadsheet a. Complete an amortization schedule for a $35,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 8% compounded annually. Round all answers to the nearest cent. A-Z Year Beginning Balance 35000 $ 1 Payment 8765.98 8765.98 Interest 2800 $ Repayment of Principal 5965.98 6443.25 X Ending Balance 29034,023 2 $ $ 2322.22 $ 22590.77 8765.98 $ 180726 X 6958.71 $ 0 6. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all answers to two decimal places % Interest Year 1: Principal 4 Year 2: Year 3 96 % c. Why do these percentages change over time