Use the spreadsheet at the beginning to calculate payments



Do a screenshot of your spreadsheet. Create a pie chart that illustrates your yearly transportation expenses. I have included a sample screenshot. Yours should look like this except with YOUR name and numbers.


Interest paid yearly.
Total cost of loan over 5 years
What is the monthly payment?
Monthly payment?
Total amount paid over 5 years
Which term affects payment the most?
Which term affects payment the most?
Monthly Payment?
Total amount paid over course of the loan
Total Cost after sale of the car at end of 6 years
Monthly Payment?
Total amount paid over course of the loan
Total Cost after sale of the car at end of 6 years. Round up to nearest dollar
Monthly Payment?
Total amount paid over course of the loan
Total Cost after sale of the car at end of 6 years.
What is the best option?