B14 x fx A B D E F G H 1 J L 1 2 3 Car Loan Amortization Complete the loan amortization schedule for a car loan that will be repaid over 60 months and answer the following questions (The details about the loan are shown below): Correct Answers 1. What is your monthly payment? 2. What is the total $ amount of payments made over the life of the loan Enter Answers Here. 4 5 6 Payment Beginning No. Balance Payment Amount Interest Paid Principle Paid Ending Balance 1 2 3 7 8 Loan Input Data 9 Principal Amount 10 Annual Interest Rate 11 Periods Per Year 12 Total Number of Payments 13 Percentage Rate Per Period 14 Amount $16,000.00 5.70% 12 60 0.47500% 4 5 6 7 15 8 9 10 11 16 Grade Car Loan 17 18 19 Car Loan Score 20 Total Score 21 12 0.00 13 22 23 14 15 16 17 18 19 24 25 FEEDBACK 26 27 20 28 21 22 29 30 31 23 24 25 26 32 33 B14 X fx B E F H J 4 5 27 28 6 29 7 8 9 -0 -1 -2 3 -4 30 31 32 33 34 35 36 37 38 39 40 41 42 -5 6 -7 -8 -9 0 43 1 2. 44 45 46 47 3 4 48 5 6 7 8 9 49 50 51 52 53 54 55 56 -0 1 2 3 4 57 58 59 -5 6 -7 8 60