Apps f Facebook () Microsoft Office H... Twitter M Gmail 3 Blackboard X Excel template - Saved File Home Insert Formulas Data Review View Help Tell me what you want to do Editing v Arial B Yay Av ... Currency 00 B8 fx A B C D E F G H Amortization schedule WNE Loan amount to be repaid (PV) $13,000.00 Interest rate (r) 10.00% Length of loan (in years) 3 a. Setting up amortization table Formula 8 Calculation of loan payment #N/A Repayment of 10 Year Beginning Balance Payment Interest Principal Remaining Balance 11 12 2 13 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 18 19 20 Sheet1 Calculation Mode: Automatic Workbook Statistics Cayla Seder Re....pdf IMG_2949.jpg IMG_2950.jpg"Apps f Facebook () Microsoft Office H... w Twitter w| Gmail ) Blackboard X HHH Excel template Saved File Home Insert Formulas Data Review View Help Tell me what you want to do Editing v Arial 10 B A Currency B8 fx A B C D E F G ZU 21 Formulas Repayment of Year Interest Principal Remaining Balance 22 Beginning Balance Payment 23 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 24 W N 25 #N/A #N/A #N/A #N/A #N/A 26 27 b. Calculating % of Payment Representing Interest and Principal for Each Year Payment % Payment % Representing Representing Check: Total = Year Interest Principal 100% 28 29 #N/A #N/A #N/A 30 #NIA #N/A #N/A 31 #N/A #N/A #N/A 32 33 34 35 37 38 39 40 41 Sheet1 Calculation Mode: Automatic Workbook Statistic IMG_2950.jpg Cayla Seder Re....pdf IMG_2949.jpg 4History Bookmarks People Tab Window Help G G Bb 28% ) Thu 2:47 PM G a D G M G com staticb/ui/evo/index.html?deploymentld=5933148003746943695388600&cISBN=9781337911009&id=1042712885&snapshotid=2168973& icrosoft Office H... w Twitter 1wl Gmail Blackboard CENGAGE | MINDTAP Q Search this course Excel Online Activity: Amortization schedule X Question 1 0/100 Open spreadsheet a. Complete an amortization schedule for a $13,000 loan to be repaid in equal installments at the end of each of the next three years. The interest A-Z rate is 10% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 2 3 b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all answers to N two decimal places. % Interest % Principal % Year 1: Year 2: % Year 3: c. Why do these percentages change over time? Next Back Show All IMG_2950.jpg IMG_2949.jpg Cayla Seder Re.pdf IMG_2990.jpg WE P