IT 10: Amortization Schedule

Update: Complete scenario 3 under Follow-Up Tasks and share the spreadsheet with the teacher by Thursday, April 11. Make sure three questions are explicitly answered.

Scenario: For your upcoming birthday, you wish to purchase a previously owned car for $18,000 (after tax). However, you do not have enough money but the car dealership allows you to finance the car at 5% APR. You are required to pay a $3600 down payment and pay $300 per month until the car and interest are paid off.

Questions:

  1. How long does it take to finance the car?
  2. How much interest do you pay in total?
  3. How much interest do you pay a month on average? a year on average?

Task (Guided Example): To analyze how long you need to finance and how much interest you need to pay, you decide to create an amortization schedule similar to the one below.

amort

Follow-Up Tasks:

  1. Assume that you missed the sixth payment. Make a copy of the amortization schedule and answer the previous questions.
  2. Assume that the interest rate is 6% APR instead. Make a copy of the amortization schedule and answer the previous questions.
  3. Assume that you wish to purchase a $500 laptop computer with your CIBC credit card that charges you 20% APR. No down payment is required. You decide to pay the $10, the minimum amount as stated on the credit bill. Make a copy of the amortization schedule and answer the previous questions.
Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedInEmail this to someone
This entry was posted in Info Tech 10. Bookmark the permalink.