Upon entering college, you purchase the car of your dreams for $$29000.$ You pay $$5800$ down and finance the balance for $4$ years at $6\mathrm{.}5\%$ compounded monthly $.$ Your monthly payments are $$550\mathrm{.}19.$ Set up the spreadsheet to display the outstanding balance for each month for $4$ years. As a checkpoint, you should get $$18849\mathrm{.}78$ just after your $10$th payment

How much is still owed on the loan just after $29$ payments.$outstanding balance for each month for $4$ years. As a checkpoint, you should get $$18849\mathrm{.}78$ just after your $10$ th payment.

How much is still owed on the loan just after $29$ payments. $

Find the size of the last payment. $$

How much interest in total did you spend on the car? $