Excel Online Structured Activity: Amortization schedule The data on alan has been collected in the Microsoft Excel Online below. Open the spreaches and perform the required analysis to answer the questions below a. Complete an amortization schedule for a $33,000 loan to be on to be paid in paid in s taliments at the end of each of the next three years. The interest rate talima t compounded nully Round answers to the nearest tegnung Repayment of Pipa Balance age of the paymen t s where and what percentage represents principal for each of the three c. Why do these percentages change over time? 1. These percentages change over time because even though the total payment is constant the amount of W rest paid each year is declining as the remaining or outstanding balance declines. 1. These percentages change over time because even though the total payment is constant the amount of interest paid each years increasing as the remaining or outstanding balance declines These percentage change over time because even though the total payment is constant the amount of interest and each year declining as the remaining or outstanding balance increases IV. 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 outstanding balance increases V. The percentages de not change over best and calare each a constant percentage of the total payment Amortization schedule Loan amount to be repaid (PV) Interest rate (0) Length of loan (in years) $33,000.00 80096 a Setting up amortization table Calculation of loan payment Formula #N/A Repayment of Principal Year Beginning Balance Payment Interest Remaining Balance NO 15 D. Calculating % of Payment Representing Interest and Principal for Each Your Payment % Payment % Representing Representing Check: Total Principal 100% Year Interest Formulas Beginning Balance ANA #N/A ANIA Payment SN/A N/A EN/A Interest #NIA N/A #N/A Repayment of Principal #N/A #N/A #N/A Remaining Bahnce #N/A #N/A EN/A 27 b. Calculating % of Payment Representing Interest and Principal for Each Year Payment Payment 9 Representing Representing Check: Total Year Interest Principal 100 - ANIA Sheet1