CalculationTime finance worksheet
Auto Loan Calculator
The vehicle loan amount is $30,450.00 after down payment, trade-in and tax; the payment is $587.27.
Current inputs
| Vehicle price | 35000 |
|---|---|
| Down payment | 5000 |
| Trade-in | 2000 |
| Sales tax | 7% |
| Interest rate | 5.9% |
| Term | 60 months |
Reference
Payment = principal x monthly rate / (1 - (1 + monthly rate)^-months).
month,payment,principal,interest,balance 1,587.27,437.56,149.71,30012.44 2,587.27,439.71,147.56,29572.73 3,587.27,441.87,145.4,29130.86 4,587.27,444.04,143.23,28686.82 5,587.27,446.23,141.04,28240.59 6,587.27,448.42,138.85,27792.17 7,587.27,450.63,136.64,27341.54 8,587.27,452.84,134.43,26888.7 9,587.27,455.07,132.2,26433.63 10,587.27,457.3,129.97,25976.33 11,587.27,459.55,127.72,25516.78 12,587.27,461.81,125.46,25054.97
Checklist
Compare this worksheet with dated lender, payroll or account documents. Circle any rate, fee, tax or deduction that is estimated rather than confirmed.