Amortization Schedule


Car Loan Calculator


Car loan calculator with amortization schedule and extra payments to calculate the monthly payment and generates a car loan amortization schedule excel. Whether you are buying a used car or financing a new car, you will find this auto loan amortization calculator comes in handy. This auto loan calculator has everything that you may need to calculate your payment with options for a down payment, trade-in, sales tax, fees, extra payments, bi-weekly payments, and a detailed auto amortization schedule for each payment.

Auto Loan Calculator

Vehicle Price
$
Down Payment
$
Loan Amount
$
Loan Terms
Interest Rate
Payment Frequency
Trade In Value
$
Sales Tax
%
Other Fees
$
First Payment Date

Amortization schedule
Include all fees into loan
Extra Payments
One Time
$ On Date
Monthly or Biweekly
$ Starting Date
Quarterly
$ Starting Date
Yearly
$ Starting Date


Auto Loan Calculator Results

Loan Amount: $20,000.00
Total Monthly Payment:
$350.56
Total # Of Payments: 60
Start Date: Nov, 2022
Payoff Date: Oct, 2027
Down Payment: $0.00
Trade In Value: $0.00
Sales Tax: $0.00
Other Fee: $0.00
Total Interest Paid: $1,033.31
Total of All Costs:
$21,033.31

Car Loan Amortization Schedule

Payment Date Payment # Interest Principal Total Payment Balance
Nov, 2022 1 $33.33 $317.22 $350.56 $19,682.78
Dec, 2022 2 $32.80 $317.75 $350.56 $19,365.03
Jan, 2023 3 $32.28 $318.28 $350.56 $19,046.75
Feb, 2023 4 $31.74 $318.81 $350.56 $18,727.94
Mar, 2023 5 $31.21 $319.34 $350.56 $18,408.59
Apr, 2023 6 $30.68 $319.87 $350.56 $18,088.72
May, 2023 7 $30.15 $320.41 $350.56 $17,768.31
Jun, 2023 8 $29.61 $320.94 $350.56 $17,447.37
Jul, 2023 9 $29.08 $321.48 $350.56 $17,125.90
Aug, 2023 10 $28.54 $322.01 $350.56 $16,803.88
Sep, 2023 11 $28.01 $322.55 $350.56 $16,481.33
Oct, 2023 12 $27.47 $323.09 $350.56 $16,158.25
Nov, 2023 13 $26.93 $323.62 $350.56 $15,834.62
Dec, 2023 14 $26.39 $324.16 $350.56 $15,510.46
Jan, 2024 15 $25.85 $324.70 $350.56 $15,185.76
Feb, 2024 16 $25.31 $325.25 $350.56 $14,860.51
Mar, 2024 17 $24.77 $325.79 $350.56 $14,534.72
Apr, 2024 18 $24.22 $326.33 $350.56 $14,208.39
May, 2024 19 $23.68 $326.87 $350.56 $13,881.52
Jun, 2024 20 $23.14 $327.42 $350.56 $13,554.10
Jul, 2024 21 $22.59 $327.97 $350.56 $13,226.13
Aug, 2024 22 $22.04 $328.51 $350.56 $12,897.62
Sep, 2024 23 $21.50 $329.06 $350.56 $12,568.56
Oct, 2024 24 $20.95 $329.61 $350.56 $12,238.95
Nov, 2024 25 $20.40 $330.16 $350.56 $11,908.80
Dec, 2024 26 $19.85 $330.71 $350.56 $11,578.09
Jan, 2025 27 $19.30 $331.26 $350.56 $11,246.83
Feb, 2025 28 $18.74 $331.81 $350.56 $10,915.02
Mar, 2025 29 $18.19 $332.36 $350.56 $10,582.66
Apr, 2025 30 $17.64 $332.92 $350.56 $10,249.74
May, 2025 31 $17.08 $333.47 $350.56 $9,916.27
Jun, 2025 32 $16.53 $334.03 $350.56 $9,582.24
Jul, 2025 33 $15.97 $334.58 $350.56 $9,247.65
Aug, 2025 34 $15.41 $335.14 $350.56 $8,912.51
Sep, 2025 35 $14.85 $335.70 $350.56 $8,576.81
Oct, 2025 36 $14.29 $336.26 $350.56 $8,240.55
Nov, 2025 37 $13.73 $336.82 $350.56 $7,903.73
Dec, 2025 38 $13.17 $337.38 $350.56 $7,566.35
Jan, 2026 39 $12.61 $337.94 $350.56 $7,228.40
Feb, 2026 40 $12.05 $338.51 $350.56 $6,889.90
Mar, 2026 41 $11.48 $339.07 $350.56 $6,550.82
Apr, 2026 42 $10.92 $339.64 $350.56 $6,211.19
May, 2026 43 $10.35 $340.20 $350.56 $5,870.98
Jun, 2026 44 $9.78 $340.77 $350.56 $5,530.21
Jul, 2026 45 $9.22 $341.34 $350.56 $5,188.87
Aug, 2026 46 $8.65 $341.91 $350.56 $4,846.97
Sep, 2026 47 $8.08 $342.48 $350.56 $4,504.49
Oct, 2026 48 $7.51 $343.05 $350.56 $4,161.44
Nov, 2026 49 $6.94 $343.62 $350.56 $3,817.82
Dec, 2026 50 $6.36 $344.19 $350.56 $3,473.63
Jan, 2027 51 $5.79 $344.77 $350.56 $3,128.87
Feb, 2027 52 $5.21 $345.34 $350.56 $2,783.52
Mar, 2027 53 $4.64 $345.92 $350.56 $2,437.61
Apr, 2027 54 $4.06 $346.49 $350.56 $2,091.12
May, 2027 55 $3.49 $347.07 $350.56 $1,744.05
Jun, 2027 56 $2.91 $347.65 $350.56 $1,396.40
Jul, 2027 57 $2.33 $348.23 $350.56 $1,048.17
Aug, 2027 58 $1.75 $348.81 $350.56 $699.36
Sep, 2027 59 $1.17 $349.39 $350.56 $349.97
Oct, 2027 60 $0.58 $349.97 $350.56 $0.00

Compare Monthly vs. Bi-weekly

Payment Frequency Monthly Bi-weekly
Payments / Year 12 26
Each Payment $350.56 $175.28
Total Interest $1,033.31 $940.79
Total Payment $21,033.31 $20,940.79
Total Savings $0 $92.52
Payoff Date Oct, 2027 Jun, 2027



Auto Loan Amortization Calculator

The auto loan calculator is able to calculate any type of auto loan and generate a car loan amortization schedule with principal, interest, and balance for each payment.


Car Loan Amortization Schedule With Extra Payments

The car loan amortization schedule with extra payments gives borrowers the options to see how much they can save by making extra payments toward the principal of their car loan, and how much faster they can pay off the auto loan compared to the default payment schedule.


How do car loans work?

A car loan is a loan that is used to finance the purchase of a car. When a borrower takes out a loan, he gets a lump sum payment from the lender and he needs to pay it back over time with interest. Most car loans are secured using the car as collateral meaning if a borrower defaults on the loan, the lender would take his car. There are three variables that every borrower should be aware of before applying for an auto loan, the loan amount, interest rate, and the term. Borrowers with good credit scores will get the most competitive rates from lenders. Loan amount - the size of the car loan Interest rate - the interest payment is based on the interest rate you get getting Term - the number of years that it takes the borrower to repay the loan These 3 variables determine the monthly payment and the total interest payment over the course of the loan. A lower monthly payment doesn't mean a borrower would save money if their term is longer. For example, the following chart shows two loans of $20,000, one with an interest rate of 4.5% and a 5-year term (Loan 1), the other with an interest rate of 5.15% and a 7-year term (Loan 2). Although the monthly payment is lower for Loan 2 ($284.09 per month), the overall costs are much higher with a total interest of $3,863.56 which is $1,491.94 more than Loan 1.


Compare Auto Loans

Loan 1 Loan 2
Loan Amount $20,000 $20,000
Interest Rate 4.5% 5.15%
Term 5 7
Monthly Payments $372.86 $284.09
Total Interest $2,371.62 $3,863.56
Total Payment $22,371.62 $23,863.56

How to calculate car payments?

To calculate monthly car payments, we need to use the formula below. Monthly Payment = (P x i) / (1 - 1 / (1 + i)^ n), where P = car loan amount i = monthly interest rate in decimal n = number of months to pay off the loan



Car Payment Example

Let's calculate the monthly payment for a car loan of $15,000 with a 5% interest rate and a 5-year term. Monthly Payment = (15000*5/12/100)/ (1 - 1/(1+5/12/100)^60) Monthly Payment = (15000*0.004167)/ (1 - 1/(1+0.004167)^60) Monthly Payment = 62.505/(1 - 1/(1.004167)^60) Monthly Payment = 62.505 / ( 1 - 1/ 1.283) Monthly Payment = 62.505 / (1 - 0.7794) Monthly Payment = 62.505 / 0.2206 Monthly Payment = $283.07 Hence, $283.07 is the amount that borrowers pay each month until the car loan is paid off in 5 years.


How to calculate car loan interest?

The car loan interest rate is calculated based on the interest rate and the remaining balance. The formula for calculating interest payment is given below. Monthly interest = (12/interest rate​) x loan balance Monthly payments are divided into two portions, one for principal and the other for interest payments. The monthly payments stay the same over the course of the loan, but the interest and principal are recalculated each month. If we look at the car amortization schedule for our previous example, the auto loan of $15,000 with a 5% interest rate and a 5-year term, we can see the interest payment declines every month because the loan balance decreases as more principal is paid. Since monthly payment is made up of principal and interest, when interest payment decreases, principal increases.


Amortization Schedule

Payment Date Payment # Interest Paid Principal Paid Total Payment Remaining Balance
Sep, 2022 1 $62.50 $220.57 $283.07 $14,779.43
Oct, 2022 2 $61.58 $221.49 $283.07 $14,557.94
Nov, 2022 3 $60.66 $222.41 $283.07 $14,335.53
..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... .....
..... ..... ..... ..... ..... .....
Jun, 2027 58 $3.51 $279.56 $283.07 $562.62
Jul, 2027 59 $2.34 $280.72 $283.07 $281.89
Aug, 2027 60 $1.17 $281.89 $283.07 $0.00

What is APR on a car?

A car loan's annual percentage rate or APR is the borrowing costs expressed in percentage. The interest rate determines how much the borrower pays in interest payments. There may be other costs involved in getting a loan, such as application fees and closing costs. The APR includes all the costs plus interest costs. Therefore, the APR is usually higher than the interest rate.




How to get an auto loan?

1. Check Credit Report

Credit score and income determine how much you can borrow and at what interest rate. The higher your credit score, the better. Therefore, before applying for an auto loan, you should check your credit report to see if there are any errors or unusual activities that lower your credit score. If you see any error, you should contact the 3 credit bureaus, Equifax, Experian, and TransUnion, and try to resolve the issues before applying for an auto loan.


2. Compare Rates & Costs From Multiple Lenders

You can get an auto loan from any bank, credit union, online auto lender, or dealership financing. You want to get and compare auto quotes from multiple lenders and see which one offers you the best interest rate and the least fees. Dealership financing is the most convenient, but it may not offer the best APR as dealerships often markup their rates. Banks usually offer competitive rates for auto loans. You might want to check with your own bank before you reach out to other lenders. Your bank might even give you a lower rate when you set up auto payment with your checking account. You can also get auto quotes from online lenders and ask around the banks to see if they can beat this rate. Lenders may be willing to lower their interest rates to get your business if you have good credit scores.


3. Get Preapproved For a Car Loan

After you've done your research and decided to get your car loan from a bank or credit union, you should get pre-approved for a car loan from the bank. Getting preapproved for a car loan has many advantages. It will help you find the bank that will give you the best interest rate as the banks will need to pull your credit score and review your financial information. Depending on your employment history, income, and credit score, they will let you know the size of your loan and the interest rate that you will be getting. Preapproved for a car loan will also have more bargaining power at the dealership, and protects you from markup rates from dealerships. The only downside to a preapproved loan is that lenders will need a hard pull for your credit score meaning it will lower your credit score temporarily. Usually, your credit score will rise again in 1-3 months.


4. Find Your Car

After you get preapproved for a car loan, you know exactly how much money you can borrow. You can now set your budget and look for cars that are within your budget. Shop around the different dealerships and see what kind of car you like. Once you decide the exact car you want to buy, call multiple dealerships that sell this brand and model, ask them how much they are selling, and ask for their best price. Make sure you ask for their best price on the car, not the lowest monthly payments. Many car salespeople will try to convince you to buy their car because they give you the lowest monthly payments. As we learned earlier, the lower monthly payment doesn't translate into the lowest costs of buying a car.


5. Applying For The Car Loan

Now, it is time to finalize your car loan or actually apply for the car loan. Since you are already pre approved, the process is much faster. The banks have already checked your financial background and credit score. They have everything that they need to know other than the vehicle you are buying. Follow the lender's instructions on completing the auto loan and the purchase of your vehicle. Read the terms of your car loan and make sure that there are no hidden fees or prepayment penalties in case you want to pay off your loan earlier.



Amortization Schedule | Terms | Privacy | Disclaimer | Contact

©2022 Amortization Schedule