complete the schedule
Excel Online Activity: Amortization schedule muestion 1 10 Video 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. Open spreadsheet a. Complete an amortization schedule for a $37.000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate in 8% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Balance Payment Interest of Prinoval Balance Year 1 $ $ $ $ $ 2 $ $ $ 5 $ 3 $ $ b. What percentage of the payment represents interest and what percentage represents prinopal for each of the three years? Round le Horse X. Excel template Saved Re Data Review View Help Tell me what you want to do 10 A A Home Insert Formulas Xon Anal Da Copy Paste Format Painter Clipboard Cuency $. % 13 -A- Insert Delete Format Conditional Format Cell Formatting Table Styles bles Font Alignment Numbe C Undo B8 0 E F G H 1 Amortization schedule 2 3 Loan amount to be repaid (PV) Interest rate (0) 5 Length of loan in your $37,000.00 8.00% 3 NO Formula a Setting up amortization table Calculation of loan payment Repayment of Principal 10 Beginning Balance Payment Interest Remaining Balance Yeni 1 2 3 13 15 b. Calculating % of Payment Representing Interest and Principal for Each Your Payment Payment Representing Representing Check out Yea Principal 100% & Shooti Car Mode Automatic WorkbookStatis + Undo > Clipboard Font Alignment Number Tables Cells B9 D E F G H Representing Interest Representing Principal Check Total 100% - TE 17 18 19 20 21 Formulas Year 1 2 3 Repayment of Primcipal NA WWA MUA Remaining Balance NA NA WNIA 22 Year Beginning Balance Payment Interest 23 1 WNA WNIA NA 24 2 WINIA MNIA WNA 3 DNA WNIA NA 26 27 b. Calculating % of Payment Representing Interest and Principal for Each You Payment Payment Representing Representing Check Total Year Interest Principal 100% 1 WNIA WIWA MIVA 2 NA NA WNIA 3 UNIA NA WNA