Congratulations, you have just purchased your first new car. You secured a loan
ID: 3798755 • Letter: C
Question
Congratulations, you have just purchased your first new car. You secured a loan from First Bank of San Diego for $20,000. You have agreed to pay First Bank at the end of each month for the next three years. Your interest rate is 6.5%. Prepare a 36-month amortization table utilizing Excel. You must use a data section for the Loan Amount, Interest Rate and Loan Period. You must also use the =PMT and =IPMT formulas. Determine the total interest you will pay and then determine the total amount (interest and principal) you paid over the life of the loan.
Explanation / Answer
Excel URL to download : https://drive.google.com/file/d/0Bx-j2pttV5o1SjRJdTJ3QmZJanM/view?usp=sharing