How to Mathematically Calculate a Car Loan's Amortization Schedule

How to Mathematically Calculate a Car Loan's Amortization Schedule
Written By
Tim Plaehn
Tim Plaehn
Published: Jul 27, 2017
Updated: Aug 30, 2022
2 minute read

A typical car loan has a term of 48 to 60 monthly payments. The amortization of a level payment loan, like an auto loan, will have higher interest charges associated with the early payments and in the later payments more of the payment is principal to pay down the loan. A car loan will amortize at a set pace with each monthly payment. The math can be handled with a calculator and piece of paper.

Divide the annual interest rate for the car loan by 12 to obtain a monthly interest rate. For example, if the annual rate is 9 percent, dividing by 12 gives a monthly rate of 0.75 percent.

Multiply the monthly interest rate times the original loan amount to calculate the interest portion of the first monthly payment. For the example, the car loan was for $20,000. Multiply $20,000 time 0.75 percent for an interest amount of $150.

Subtract the interest for the first monthly payment from the payment amount to get the principal amount of the first payment. The example loan has a payment of $415.17, so the principal amount is $265.17.

Subtract the principal amount for the payment from the loan balance. After the first payment, the loan balance on the example loan would be $20,000 minus $265.17 equals $19,734.83.

Write the first line of the amortization table, making columns for interest, principal and loan balance. Use the calculated figures under each column.

Calculate the interest, then principal for the second payment using the new loan balance to calculate the interest for the payment. Repeat this step for each payment of the car loan.

Tips

A spreadsheet in a program like Microsoft Excel or OpenOffice Calc can be set up to do the calculations and automatically fill in the columns.

Tim Plaehn

Tim Plaehn has been writing financial, investment and trading articles and blogs since 2007. His work has appeared online at Seeking Alpha, Marketwatch.com and various other websites. Plaehn has a bachelor's degree in mathematics from the…

Sponsored
PocketSense Logo

PocketSense is the ultimate guide to managing your money, with expert information on how to decode your taxes, keep track of spending and stay financially responsible.

Property of TechnologyAdvice. © 2026 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.