brol Online Structured Activity: Amortization schedule The data on a toan has been collected in the Microsoft Excel Online file below, Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet .. Complete an amortisation schedule for a $37,000 toan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12 compounded annually. Round all answers to the neare cent Beginning Balance Repayment of Principal Ending Balance Payment Interest 1 5 $ 5 $ $ $ 2 S 5 $ 5 3 $ $ $ $ 5 b. what percentage of the payment represents interest and what percentage represents principal for each of the three years? Round an answers to two decimal places Principal Interest Year 11 Year 2 Year 31 Home Insert Formulas Data Review View Help Editing Arial V10 B . 2b Currency B8 A D E F G H Amortization schedule 2 3 Loan amount to be repaid (PV) 4 Interest rate 5 Length of loan (in years) 6 7 2. Setting up amortization table 3 Calculation of loan payment 9 $37,000.00 12.00% 3 Formula #NA Repayment of Principal Remaining Balance 10 Year Beginning Balance Payment Interest 11 1 12 2 13 3 14 15 b. Calculating % of Payment Representing Interest and Principal for Each Year Payment % Payment % Representing Representing Check. Total 16 Year Interest Principal 100% 17 1 18 2 19 3 20 21 Formulas Year R Repayment of Principal WNA ANA PNA Remaining Balance #NA ANA NA ON 22 Beginning Balance Payment Interest 23 1 UNA #NIA WNA 24 2 NA #N/A #N/A 25 NA WNIA #N/A 26 29 b. Calculating % of Payment Representing interest and Principal for Each Year Payment % Payment % Representing Representing Check: Total 28 Year Interest Principal 100% Sheet1 + Calea Mode: Automatic Workbook Statistics