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 Amortization Schedule | ||||||
| Loan Amount: | $20,000.00 | |||||
Total Monthly Payment: | $350.56 | |||||
| Total # Of Payments: | 60 | |||||
| Start Date: | Sep, 2024 | |||||
| Payoff Date: | Aug, 2029 | |||||
| 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 | |
|---|---|---|---|---|---|---|
| Sep, 2024 | 1 | $33.33 | $317.22 | $350.56 | $19,682.78 | |
| Oct, 2024 | 2 | $32.80 | $317.75 | $350.56 | $19,365.03 | |
| Nov, 2024 | 3 | $32.28 | $318.28 | $350.56 | $19,046.75 | |
| Dec, 2024 | 4 | $31.74 | $318.81 | $350.56 | $18,727.94 | |
| Jan, 2025 | 5 | $31.21 | $319.34 | $350.56 | $18,408.59 | |
| Feb, 2025 | 6 | $30.68 | $319.87 | $350.56 | $18,088.72 | |
| Mar, 2025 | 7 | $30.15 | $320.41 | $350.56 | $17,768.31 | |
| Apr, 2025 | 8 | $29.61 | $320.94 | $350.56 | $17,447.37 | |
| May, 2025 | 9 | $29.08 | $321.48 | $350.56 | $17,125.90 | |
| Jun, 2025 | 10 | $28.54 | $322.01 | $350.56 | $16,803.88 | |
| Jul, 2025 | 11 | $28.01 | $322.55 | $350.56 | $16,481.33 | |
| Aug, 2025 | 12 | $27.47 | $323.09 | $350.56 | $16,158.25 | |
| Sep, 2025 | 13 | $26.93 | $323.62 | $350.56 | $15,834.62 | |
| Oct, 2025 | 14 | $26.39 | $324.16 | $350.56 | $15,510.46 | |
| Nov, 2025 | 15 | $25.85 | $324.70 | $350.56 | $15,185.76 | |
| Dec, 2025 | 16 | $25.31 | $325.25 | $350.56 | $14,860.51 | |
| Jan, 2026 | 17 | $24.77 | $325.79 | $350.56 | $14,534.72 | |
| Feb, 2026 | 18 | $24.22 | $326.33 | $350.56 | $14,208.39 | |
| Mar, 2026 | 19 | $23.68 | $326.87 | $350.56 | $13,881.52 | |
| Apr, 2026 | 20 | $23.14 | $327.42 | $350.56 | $13,554.10 | |
| May, 2026 | 21 | $22.59 | $327.97 | $350.56 | $13,226.13 | |
| Jun, 2026 | 22 | $22.04 | $328.51 | $350.56 | $12,897.62 | |
| Jul, 2026 | 23 | $21.50 | $329.06 | $350.56 | $12,568.56 | |
| Aug, 2026 | 24 | $20.95 | $329.61 | $350.56 | $12,238.95 | |
| Sep, 2026 | 25 | $20.40 | $330.16 | $350.56 | $11,908.80 | |
| Oct, 2026 | 26 | $19.85 | $330.71 | $350.56 | $11,578.09 | |
| Nov, 2026 | 27 | $19.30 | $331.26 | $350.56 | $11,246.83 | |
| Dec, 2026 | 28 | $18.74 | $331.81 | $350.56 | $10,915.02 | |
| Jan, 2027 | 29 | $18.19 | $332.36 | $350.56 | $10,582.66 | |
| Feb, 2027 | 30 | $17.64 | $332.92 | $350.56 | $10,249.74 | |
| Mar, 2027 | 31 | $17.08 | $333.47 | $350.56 | $9,916.27 | |
| Apr, 2027 | 32 | $16.53 | $334.03 | $350.56 | $9,582.24 | |
| May, 2027 | 33 | $15.97 | $334.58 | $350.56 | $9,247.65 | |
| Jun, 2027 | 34 | $15.41 | $335.14 | $350.56 | $8,912.51 | |
| Jul, 2027 | 35 | $14.85 | $335.70 | $350.56 | $8,576.81 | |
| Aug, 2027 | 36 | $14.29 | $336.26 | $350.56 | $8,240.55 | |
| Sep, 2027 | 37 | $13.73 | $336.82 | $350.56 | $7,903.73 | |
| Oct, 2027 | 38 | $13.17 | $337.38 | $350.56 | $7,566.35 | |
| Nov, 2027 | 39 | $12.61 | $337.94 | $350.56 | $7,228.40 | |
| Dec, 2027 | 40 | $12.05 | $338.51 | $350.56 | $6,889.90 | |
| Jan, 2028 | 41 | $11.48 | $339.07 | $350.56 | $6,550.82 | |
| Feb, 2028 | 42 | $10.92 | $339.64 | $350.56 | $6,211.19 | |
| Mar, 2028 | 43 | $10.35 | $340.20 | $350.56 | $5,870.98 | |
| Apr, 2028 | 44 | $9.78 | $340.77 | $350.56 | $5,530.21 | |
| May, 2028 | 45 | $9.22 | $341.34 | $350.56 | $5,188.87 | |
| Jun, 2028 | 46 | $8.65 | $341.91 | $350.56 | $4,846.97 | |
| Jul, 2028 | 47 | $8.08 | $342.48 | $350.56 | $4,504.49 | |
| Aug, 2028 | 48 | $7.51 | $343.05 | $350.56 | $4,161.44 | |
| Sep, 2028 | 49 | $6.94 | $343.62 | $350.56 | $3,817.82 | |
| Oct, 2028 | 50 | $6.36 | $344.19 | $350.56 | $3,473.63 | |
| Nov, 2028 | 51 | $5.79 | $344.77 | $350.56 | $3,128.87 | |
| Dec, 2028 | 52 | $5.21 | $345.34 | $350.56 | $2,783.52 | |
| Jan, 2029 | 53 | $4.64 | $345.92 | $350.56 | $2,437.61 | |
| Feb, 2029 | 54 | $4.06 | $346.49 | $350.56 | $2,091.12 | |
| Mar, 2029 | 55 | $3.49 | $347.07 | $350.56 | $1,744.05 | |
| Apr, 2029 | 56 | $2.91 | $347.65 | $350.56 | $1,396.40 | |
| May, 2029 | 57 | $2.33 | $348.23 | $350.56 | $1,048.17 | |
| Jun, 2029 | 58 | $1.75 | $348.81 | $350.56 | $699.36 | |
| Jul, 2029 | 59 | $1.17 | $349.39 | $350.56 | $349.97 | |
| Aug, 2029 | 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 | Aug, 2029 | Apr, 2029 | ||||
Auto Loan Amortization Calculator
The auto loan calculator is able to calculate any type of auto loan and generate an auto 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 loanInterest rate - the interest payment is based on the interest rate you get gettingTerm - the number of years that it takes the borrower to repay the loanThese 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), whereP = car loan amounti = monthly interest rate in decimaln = 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.2206Monthly Payment = $283.07Hence, $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/interestrate) x loanbalanceMonthly 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.
Motorcycle Loan Calculator
How Much Car Can I Afford
$1000 Car Payment
