DTAP Search this : Amortization schedule 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 THUHT Open spreadsheet a. Complete an amortization schedule for a $31,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 11% compounded annually. Round all answers to the nearest cent. Beginning Balance 31000 Repayment of Principal Ending Balance Year Payment Interest $ $ 1 $ 3410 5 $ $ $ $ 3034.9 2 $ $ $ o $ 3 $ $ $ b. 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 % Principal % Interest Year 1: 96 9 Year 2: Year 3 Prisen & 6 8 P. T . DTAP Search this : Amortization schedule 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 THUHT Open spreadsheet a. Complete an amortization schedule for a $31,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 11% compounded annually. Round all answers to the nearest cent. Beginning Balance 31000 Repayment of Principal Ending Balance Year Payment Interest $ $ 1 $ 3410 5 $ $ $ $ 3034.9 2 $ $ $ o $ 3 $ $ $ b. 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 % Principal % Interest Year 1: 96 9 Year 2: Year 3 Prisen & 6 8 P. T