Loans & savings
Auto Loan Calculator
Dealers quote a monthly figure, but the amount you finance depends on the trade-in, sales tax and fees. Put them all in here to see the real payment and what the car costs you in total.
Your result will appear here.
How it's calculated
Sales tax is charged on the price minus the trade-in, which is how most US states do it. The amount financed is the price plus tax and fees, minus the down payment and trade-in. The monthly payment then uses the same formula as any fixed-rate loan.
Financed = Price + Tax + Fees − Down payment − Trade-in
How to do it in Excel
=PMT(7%/12, 60, -(35000*1.07 + 800 - 5000))- Monthly payment for the default example.