Structured Activity: Amortization schedule The data o n has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required to the questions below Open spreadsheet Complete an amortization schedule for a $45.000 to the nearest cent. be repaid equal instant at the end of each of the next three years. The interest rate is 19 compounded an Beginning d we Ending b. what percentage of the payment repe Interest and what percentage represents principal for each of the three years found alas towo decalco Why do these percentage change over time? These percentages change over time because even though the total payment is constant the amount of interest paid each year is dedining as the remaining or outstanding balance de ces II. These percentages change over time because even though the total payment is constant the amount of interest paid each year is increasing as the remaining or cutstanding balance d es These percentages change over time because even though the total payments constant the amount of interest and each year is declining as the rea r outstanding balance increase The percentage change over time because even though the total payment is constant the amount of interest paid each year is increasing as the remai n ing balance increases These percentages do not change over time. Interest and principal are each a constant percentage of the total payment. lenovo