![]() |
Home | Mortgage Calculator | Car Loan Calculator | Recast Calculator | HELOC Calculator | Refinance Calculator | Excel |
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 an used car or finance for a new car, you will find this auto loan amortization calculator come in handy. This auto loan calculator has everything that you may need to calculate your payment with options for down payment, trade in, sales tax, fees, extra payments, bi-weekly payments and a detailed auto amortization schedule about each payment.
Auto Loan Calculator Results |
||||||
Loan Amount: | $20,000.00 | |||||
Total Monthly Payment: |
$350.56 |
|||||
Total # Of Payments: | 60 | |||||
Start Date: | Aug, 2022 | |||||
Payoff Date: | Jul, 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 | |
---|---|---|---|---|---|---|
Aug, 2022 | 1 | $33.33 | $317.22 | $350.56 | $19,682.78 | |
Sep, 2022 | 2 | $32.80 | $317.75 | $350.56 | $19,365.03 | |
Oct, 2022 | 3 | $32.28 | $318.28 | $350.56 | $19,046.75 | |
Nov, 2022 | 4 | $31.74 | $318.81 | $350.56 | $18,727.94 | |
Dec, 2022 | 5 | $31.21 | $319.34 | $350.56 | $18,408.59 | |
Jan, 2023 | 6 | $30.68 | $319.87 | $350.56 | $18,088.72 | |
Feb, 2023 | 7 | $30.15 | $320.41 | $350.56 | $17,768.31 | |
Mar, 2023 | 8 | $29.61 | $320.94 | $350.56 | $17,447.37 | |
Apr, 2023 | 9 | $29.08 | $321.48 | $350.56 | $17,125.90 | |
May, 2023 | 10 | $28.54 | $322.01 | $350.56 | $16,803.88 | |
Jun, 2023 | 11 | $28.01 | $322.55 | $350.56 | $16,481.33 | |
Jul, 2023 | 12 | $27.47 | $323.09 | $350.56 | $16,158.25 | |
Aug, 2023 | 13 | $26.93 | $323.62 | $350.56 | $15,834.62 | |
Sep, 2023 | 14 | $26.39 | $324.16 | $350.56 | $15,510.46 | |
Oct, 2023 | 15 | $25.85 | $324.70 | $350.56 | $15,185.76 | |
Nov, 2023 | 16 | $25.31 | $325.25 | $350.56 | $14,860.51 | |
Dec, 2023 | 17 | $24.77 | $325.79 | $350.56 | $14,534.72 | |
Jan, 2024 | 18 | $24.22 | $326.33 | $350.56 | $14,208.39 | |
Feb, 2024 | 19 | $23.68 | $326.87 | $350.56 | $13,881.52 | |
Mar, 2024 | 20 | $23.14 | $327.42 | $350.56 | $13,554.10 | |
Apr, 2024 | 21 | $22.59 | $327.97 | $350.56 | $13,226.13 | |
May, 2024 | 22 | $22.04 | $328.51 | $350.56 | $12,897.62 | |
Jun, 2024 | 23 | $21.50 | $329.06 | $350.56 | $12,568.56 | |
Jul, 2024 | 24 | $20.95 | $329.61 | $350.56 | $12,238.95 | |
Aug, 2024 | 25 | $20.40 | $330.16 | $350.56 | $11,908.80 | |
Sep, 2024 | 26 | $19.85 | $330.71 | $350.56 | $11,578.09 | |
Oct, 2024 | 27 | $19.30 | $331.26 | $350.56 | $11,246.83 | |
Nov, 2024 | 28 | $18.74 | $331.81 | $350.56 | $10,915.02 | |
Dec, 2024 | 29 | $18.19 | $332.36 | $350.56 | $10,582.66 | |
Jan, 2025 | 30 | $17.64 | $332.92 | $350.56 | $10,249.74 | |
Feb, 2025 | 31 | $17.08 | $333.47 | $350.56 | $9,916.27 | |
Mar, 2025 | 32 | $16.53 | $334.03 | $350.56 | $9,582.24 | |
Apr, 2025 | 33 | $15.97 | $334.58 | $350.56 | $9,247.65 | |
May, 2025 | 34 | $15.41 | $335.14 | $350.56 | $8,912.51 | |
Jun, 2025 | 35 | $14.85 | $335.70 | $350.56 | $8,576.81 | |
Jul, 2025 | 36 | $14.29 | $336.26 | $350.56 | $8,240.55 | |
Aug, 2025 | 37 | $13.73 | $336.82 | $350.56 | $7,903.73 | |
Sep, 2025 | 38 | $13.17 | $337.38 | $350.56 | $7,566.35 | |
Oct, 2025 | 39 | $12.61 | $337.94 | $350.56 | $7,228.40 | |
Nov, 2025 | 40 | $12.05 | $338.51 | $350.56 | $6,889.90 | |
Dec, 2025 | 41 | $11.48 | $339.07 | $350.56 | $6,550.82 | |
Jan, 2026 | 42 | $10.92 | $339.64 | $350.56 | $6,211.19 | |
Feb, 2026 | 43 | $10.35 | $340.20 | $350.56 | $5,870.98 | |
Mar, 2026 | 44 | $9.78 | $340.77 | $350.56 | $5,530.21 | |
Apr, 2026 | 45 | $9.22 | $341.34 | $350.56 | $5,188.87 | |
May, 2026 | 46 | $8.65 | $341.91 | $350.56 | $4,846.97 | |
Jun, 2026 | 47 | $8.08 | $342.48 | $350.56 | $4,504.49 | |
Jul, 2026 | 48 | $7.51 | $343.05 | $350.56 | $4,161.44 | |
Aug, 2026 | 49 | $6.94 | $343.62 | $350.56 | $3,817.82 | |
Sep, 2026 | 50 | $6.36 | $344.19 | $350.56 | $3,473.63 | |
Oct, 2026 | 51 | $5.79 | $344.77 | $350.56 | $3,128.87 | |
Nov, 2026 | 52 | $5.21 | $345.34 | $350.56 | $2,783.52 | |
Dec, 2026 | 53 | $4.64 | $345.92 | $350.56 | $2,437.61 | |
Jan, 2027 | 54 | $4.06 | $346.49 | $350.56 | $2,091.12 | |
Feb, 2027 | 55 | $3.49 | $347.07 | $350.56 | $1,744.05 | |
Mar, 2027 | 56 | $2.91 | $347.65 | $350.56 | $1,396.40 | |
Apr, 2027 | 57 | $2.33 | $348.23 | $350.56 | $1,048.17 | |
May, 2027 | 58 | $1.75 | $348.81 | $350.56 | $699.36 | |
Jun, 2027 | 59 | $1.17 | $349.39 | $350.56 | $349.97 | |
Jul, 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 | Jul, 2027 | Mar, 2027 |
The auto loan calculator is able to calculate any type of auto loans and generate a car loan amortization schedule with principal, interest, and balance for each payment.
The car loan amortization schedule with extra payments give borrowers the options to see how much they can save by making extra payments toward the principal of ther car loan, and how much faster they can pay off the auto loan compared to the default payment schedule.
Amortization Schedule | Terms | Privacy | Disclaimer | Contact
©2022 Amortization Schedule