Loan Amortization Problem - Taylor Ford You have found the car that you've been looking for. You finally come to a purchase price with the dealership. Now comes the financing. After lengthy discussions, there are several options you can choose. The total price of the car is (car, taxes, title, registration) is $45,000. Financing Options: 1. You can afford to put down $2,500 and have your monthly payments to be $850/month, starting next month. Your bank is offering financing for 6%, per year. How long will it take you to pay-off your car? 2. From the dealership, you can get a lower interest rate (4%) but the term of the loan is 5 years; no down payment required; no trade-in. 3. Your local bank has a "New Graduate" deal which includes an interest rate of 2% with a no down payment, no trade-in. Payments are only $600/month. First payment isn't until 6 months, from now. In Excel, create an amortization schedule for each of the scenarios so that you can compare your results. Your amortization schedule should show the monthly payments, interest and running loan balance until the maturity of the loan. Additionally, show totals of payments and interests over the term of the loan. Now...... 4. After 6 months, you sold your old vehicle and received $1,200, cash and have decided to pay it towards the financing YOU CHOSE. Additionally, you found out that the company usually awards a Christmas bonus each year of $500. You believe that you can apply that $500, every year, to your car note, at the end of December of each year (12th month). Based on the option that you selected above, update your amortization schedule and provide a narrative on how the amortization changes. 5. What if you are able to pay an extra $25 per month against the loan? Describes how your loan changes.

Loan Amortization Problem - Taylor Ford You have found the car that you've been looking for. You finally come to a purchase price with the dealership. Now comes the financing. After lengthy discussions, there are several options you can choose. The total price of the car is (car, taxes, title, registration) is $45,000. Financing Options: 1. You can afford to put down $2,500 and have your monthly payments to be $850/ month, starting next month. Your bank is offering financing for 6%, per year. How long will it take you to pay-off your car? 2. From the dealership, you can get a lower interest rate (4%) but the term of the loan is 5 years; no down payment required; no trade-in. 3. Your local bank has a "New Graduate" deal which includes an interest rate of 2% with a no down payment, no trade-in. Payments are only $600/ month. First payment isn't until 6 months, from now. In Excel, create an amortization schedule for each of the scenarios so that you can compare your results. Your amortization schedule should show the monthly payments, interest and running loan balance until the maturity of the loan. Additionally, show totals of payments and interests over the term of the loan. Now..... 4. After 6 months, you sold your old vehicle and received $1,200, cash and have decided pay it towards the financing YOU CHOSE. Additionally, you found out that the compan usually awards a Christmas bonus each year of $500. You believe that you can apply that $500, every year, to your car note, at the end of December of each year (12th month). Based on the option that you selected above, update your amortization schedule and provide a narrative on how the amortization changes. 5. What if you are able to pay an extra $25 per month against the loan? Describes ho vour loan changes