Hello All,

I have made a spreadsheet that will calculate/estimate loan payments and interest. You can see the amount of interest and principal you pay with each monthly payment. Just enter a few parameters and the loan schedule with automatically generate, along with your monthly payment itself, your total interest, and the total cost of your purchase. This works for any car, not just the Fit. Please see the simple instructions to download or copy the spreadsheet instead of editing this public one.

Auto Purchase Calculator

Let me know what you think!

 

That was pretty cool of you to do. I'm sure many will find this spreadsheet to be a valuable tool.

 

Thank you so much!

It was really just a simple mod of another spreadsheet I had already done, so it took hardly any work on my part. I had seen a few people do a payment calculator on their own beforehand, but I hadn't see anyone do the full amortization schedule.

 

Awesome, thanks for posting.

Downloaded. Now to go punch in numbers for my dream cars and crush the dreams!

Seriously though, i'll be using this for my next car purchase, so thank you.

 

You are welcome!