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)

1. what is your monthly payment?

2. what is the total dollar amount of payments made over the life of the loan

principal amount: $17000

annual interest rate: 5.20 %

periods per year: 12

total number of payments : 60

percentage rate per period:

car load score:

total score:

F4 J Car Loan Amortization Complete the loan amortuation 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 5 amount of payments made over the life of the lean Enter Answers Here. Payment Beginning No. Payment Amount Interest Paid Principle Paid Ending Balance Balance Lean Input Data Principal Amount Amount $17,000.00 5,201 2 10 Annual Interest Rate 31 11 Periods Per Yer 12 4 12 Total Number of Payments 60 5 13 Percentage Rate Per Period 0.43333% 6 14 7 15 SE 16 17 18 19 Car Loan Score 20 Total Score 0.00 21 22 23 24 25 FEEDBACK Grade Car Loan 9 10 11 17 13 141 15 16 17 18 19 20 CINDO COmer L ment Start Assly ven data and answer the questions done. LO 4.13 of Chapter & of the 1 instructions given in the excel shee