Auto Loan Calculator
Loan
Sales Price =
Sales Tax = 0
Down Payment = 0
Loan Amount =
Interest/Year =
Term = 60
Payment =
Amortization
Begin Period = 1
End Period = 1
Interest Paid =
Principal Paid =
Payment Paid =
End Balance =
Amortization Table =
Help
Calculates auto loan payments and loan amortizations.
See the [https://.../t/768df4c64fdc9ca7be70 | advanced auto loan] template to perform advanced what if analysis, include more detailed inputs like fees, rebates, and other costs, calculate with both taxable and nontaxable taxes, calculate balloon payments, and review loan analyses.
Rows
Loan
- Sales Price: Price of the automobile.
- Sales Tax: Percent of sales price paid for sales tax.
- Down Payment: Amount paid for a down payment.
- Loan Amount: Total amount of loan.
- Interest/Year: Interest per year expressed as a percentage.
- Term: Number of years or months for the loan.
- Payment: Total payment for the loan.
Amortization
- Begin Period: Starting period to calculate the amortization information.
- End Period: Ending period to calculate the amortization information.
- Interest Paid: Total interest paid over the amortization period.
- Principal Paid: Total principal paid over the amortization period.
- Payment Paid: Total payments made over the amortization period.
- End Balance: Balance at the end of the amortization period.
- Amortization Table: Select to display a table of amortization results. Pinch to zoom and see larger numbers. In addition, the amortization table is attached to any emails sent. (Available on iOS devices only.)
- Amortization Plot: plots ending balance, cumulative interest paid and interest paid for the period. Pan by dragging, zoom by pinching, or touch and hold to see data at that Interest Rate. Alternatively, select 'Eval' to evaluate at a specific period. (Available on iOS devices only.)
Examples
The local dealer has a $15,000 car for sale. If you could put down $1,500 and offer a $3,000 trade-in vehicle, what would be the payment on a 60 month loan? The company is offering 6% interest rate.
Sales Price: $15,000
Down Payment: $4,500 [$1,500 + $3,000]
Interest/Year: 6.0%
Term: 60 months
Your monthly auto payment would be $202.99.
Keywords
Sales Price
Sales Tax
Down Payment
Loan Amount
Interest/Year
Term
Payment
Begin Period
End Period
Interest Paid
Principal Paid
Payment Paid
End Balance
Amortization Table
-------------
Trade In
Balloon Payment
Rebates
Amortization
