Vehicle Amortization Table: Payments and Balance

A vehicle amortization table shows how each scheduled loan payment is divided between interest and principal, and how the balance declines over time. Enter the amount financed, APR, and term to estimate the monthly payment, total interest, and total of payments; the table itself can be generated from those same figures.

Formula

The calculator uses the standard fixed-payment amortization formula. First find the monthly rate, then calculate the payment that would repay the amount financed over the full number of monthly periods:

• Monthly rate: r = APR / 1,200, where APR is entered as a percentage per year.
• Number of payments: n = years × 12.
• Monthly payment: M = round(P × r / [1 − (1 + r)⁻ⁿ], 2).
• Total of payments: T = M × n.
• Total interest: I = T − P.

Here, P is the amount financed in dollars, r is the monthly interest rate as a decimal, n is the number of monthly payments, M is the monthly payment in dollars rounded to cents, T is the total paid in dollars, and I is the estimated interest in dollars. The results use the rounded monthly payment, so totals are based on paying that same amount for every scheduled month.

Worked Example

Using the calculator’s defaults—$20,000 financed, 8% APR, and a five-year term:

1. Convert the APR to a monthly rate: 8 / 1,200 = 0.0066667.
2. Convert the term to payments: 5 × 12 = 60 months.
3. Apply the payment formula: $20,000 × 0.0066667 / [1 − (1.0066667)⁻⁶⁰] = $405.53 per month, rounded to cents.
4. Calculate total payments using the rounded payment: $405.53 × 60 = $24,331.80.
5. Subtract the amount financed: $24,331.80 − $20,000 = $4,331.80 in estimated interest.

Assumptions

• The interest rate stays fixed for the entire term.
• Payments are equal, made monthly, and applied at the end of each monthly period.
• Interest is modelled monthly at APR divided by 12.
• The calculation excludes fees, taxes, insurance, optional products, and other charges unless they are included in the amount financed.

How to Read a Vehicle Amortization Table

A full table usually has one row per payment and columns for the payment number or date, starting balance, payment, interest, principal, and ending balance. The payment is split into interest and principal: interest is calculated on the outstanding balance, and the remainder reduces what is owed. In the early part of a level-payment loan, the balance is larger, so the interest portion is generally larger. As principal is paid down, the interest portion generally falls and the principal portion rises.

For a monthly schedule, a useful estimate for a row is:

• Interest for the month: starting balance × monthly rate.
• Principal repaid: payment − interest for the month.
• Ending balance: starting balance − principal repaid.

For example, at the beginning of the default example, one month’s interest is about $20,000 × 0.0066667 = $133.33. From a $405.53 payment, about $272.20 reduces principal, leaving an estimated balance of $19,727.80. Actual statements can differ because lenders may calculate interest by daily balances, use specific payment dates, or adjust the final payment for rounding.

What Amount Should You Enter?

Enter the amount being financed, not automatically the vehicle’s advertised or negotiated price. The financed amount may reflect a down payment, trade-in value, taxes or other charges, and any balance rolled into the new loan. These items vary by transaction, so use the amount shown in the lender’s financing documents when available. If you only know the vehicle price, the calculator can estimate a loan using that price, but the result will not account for adjustments unless you incorporate them into the amount financed.

Use the APR and term from the same loan offer or disclosure. APR is entered as a percentage, so enter 8 for 8%, not 0.08. The term is in years in this calculator; a 60-month term is five years. If the lender provides a rate but not an APR, the estimate may not match a disclosure that includes finance charges or other cost components.

Limits, Rounding, and Common Misconceptions

This is a mathematical estimate for a fixed-rate loan with regular monthly payments. It is not a lender’s payoff quote or a complete account statement. A payment may include items outside principal and interest, and extra payments can change the balance and interest schedule. The calculator does not model irregular payment dates, variable rates, skipped or late payments, payment processing rules, or a final payment adjusted to clear a small residual balance.

A frequent misunderstanding is that the monthly payment multiplied by the term always equals the vehicle’s price. It equals the estimated total of scheduled payments under the entered assumptions. That total includes interest and is based on the amount financed, which may not equal the purchase price. Another common source of mismatch is rounding: this calculator rounds the monthly payment to cents first, then multiplies that rounded amount by the number of months. A lender’s ledger may accrue interest daily and round each transaction differently, producing a slightly different schedule or final amount.

Frequently Asked Questions

What is a vehicle amortization table?
A schedule showing each loan payment’s interest and principal portions, along with the remaining balance after each payment.

How do I make an amortization table for a car loan?
Use the amount financed, APR, and term to find the monthly payment. For each month, calculate interest on the starting balance, subtract that interest from the payment to find principal repaid, and subtract principal from the starting balance.

Why does the interest portion change each month?
With a fixed payment and declining balance, monthly interest is generally lower over time. Consequently, more of each later payment goes toward principal.

Does the calculator include a down payment?
Not as a separate input. A down payment normally reduces the amount financed, so enter the resulting financed amount rather than adding the down payment to it.

Why might my lender’s payment or balance differ?
The lender may use different rounding, payment dates, daily interest accrual, fees, or financed charges. Use the lender’s disclosed figures and account statements for actual obligations and balances.

This result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• Real Estate Amortization Table: Payments and Balance
• Loan Amortization Factors Table: Formula and Calculator
• Loan Amortization Table for 240 Months

in p | Amount financed | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2
out tot | Total of payments | $ | pmt * yrs * 12 | 2