The data on a loan has been collected in the Microsoft Hxcel Online file below. Open the spreadsheet and perform the required analyza to answer the question below. Open spreadsheet a. Complete an amortization schedule for a $32,000 toan to be repaid in equal installments at the end of each of the next three years. The interest rate is compounded annually Round all answers to the nearest cent. Repayment Ending Beginning Mac Payment Interest 1 2 $ 5 $ $ $ $ $ $ $ b. What percentage of the payment representa interest and what percentage represents principal for each of the three years? Round all answers to be decimal places. Interest Principal Year 11 Year 2 Year 21 c. Why do those percentager change over time? 1. Thuse percentages change over time because even though the total payment is constant the amount of interest puid each year declining the remaining w outstanding balance declines II. These percentages change over time because even though the total payment is constant the amount of interest paid each year is increasing the remaining or outstanding handari