Car Loan Calculator Excel
Car Loan Calculator Excel to calculate the monthly payment for car loans and export the auto amortization schedule to excel.
Auto Loan Calculator Results |
||||||
| Loan Amount: | $35,000.00 | |||||
Total Monthly Payment: |
$667.73 |
|||||
| Total # Of Payments: | 60 | |||||
| Start Date: | Jun, 2023 | |||||
| Payoff Date: | May, 2028 | |||||
| Down Payment: | $25,000.00 | |||||
| Trade In Value: | $0.00 | |||||
| Sales Tax: | $0.00 | |||||
| Other Fee: | $0.00 | |||||
| Total Interest Paid: | $5,063.99 | |||||
Total of All Costs: |
$65,063.99 |
|||||
Auto Loan Amortization Schedule |
||||||
| Payment Date | Payment # | Interest | Principal | Total Payment | Balance | |
|---|---|---|---|---|---|---|
| Jun, 2023 | 1 | $158.96 | $508.77 | $667.73 | $34,491.23 | |
| Jul, 2023 | 2 | $156.65 | $511.09 | $667.73 | $33,980.14 | |
| Aug, 2023 | 3 | $154.33 | $513.41 | $667.73 | $33,466.73 | |
| Sep, 2023 | 4 | $151.99 | $515.74 | $667.73 | $32,950.99 | |
| Oct, 2023 | 5 | $149.65 | $518.08 | $667.73 | $32,432.91 | |
| Nov, 2023 | 6 | $147.30 | $520.43 | $667.73 | $31,912.48 | |
| Dec, 2023 | 7 | $144.94 | $522.80 | $667.73 | $31,389.68 | |
| Jan, 2024 | 8 | $142.56 | $525.17 | $667.73 | $30,864.51 | |
| Feb, 2024 | 9 | $140.18 | $527.56 | $667.73 | $30,336.95 | |
| Mar, 2024 | 10 | $137.78 | $529.95 | $667.73 | $29,807.00 | |
| Apr, 2024 | 11 | $135.37 | $532.36 | $667.73 | $29,274.64 | |
| May, 2024 | 12 | $132.96 | $534.78 | $667.73 | $28,739.86 | |
| Jun, 2024 | 13 | $130.53 | $537.21 | $667.73 | $28,202.66 | |
| Jul, 2024 | 14 | $128.09 | $539.65 | $667.73 | $27,663.01 | |
| Aug, 2024 | 15 | $125.64 | $542.10 | $667.73 | $27,120.91 | |
| Sep, 2024 | 16 | $123.17 | $544.56 | $667.73 | $26,576.35 | |
| Oct, 2024 | 17 | $120.70 | $547.03 | $667.73 | $26,029.32 | |
| Nov, 2024 | 18 | $118.22 | $549.52 | $667.73 | $25,479.81 | |
| Dec, 2024 | 19 | $115.72 | $552.01 | $667.73 | $24,927.79 | |
| Jan, 2025 | 20 | $113.21 | $554.52 | $667.73 | $24,373.27 | |
| Feb, 2025 | 21 | $110.70 | $557.04 | $667.73 | $23,816.24 | |
| Mar, 2025 | 22 | $108.17 | $559.57 | $667.73 | $23,256.67 | |
| Apr, 2025 | 23 | $105.62 | $562.11 | $667.73 | $22,694.56 | |
| May, 2025 | 24 | $103.07 | $564.66 | $667.73 | $22,129.90 | |
| Jun, 2025 | 25 | $100.51 | $567.23 | $667.73 | $21,562.67 | |
| Jul, 2025 | 26 | $97.93 | $569.80 | $667.73 | $20,992.87 | |
| Aug, 2025 | 27 | $95.34 | $572.39 | $667.73 | $20,420.48 | |
| Sep, 2025 | 28 | $92.74 | $574.99 | $667.73 | $19,845.49 | |
| Oct, 2025 | 29 | $90.13 | $577.60 | $667.73 | $19,267.88 | |
| Nov, 2025 | 30 | $87.51 | $580.22 | $667.73 | $18,687.66 | |
| Dec, 2025 | 31 | $84.87 | $582.86 | $667.73 | $18,104.80 | |
| Jan, 2026 | 32 | $82.23 | $585.51 | $667.73 | $17,519.29 | |
| Feb, 2026 | 33 | $79.57 | $588.17 | $667.73 | $16,931.13 | |
| Mar, 2026 | 34 | $76.90 | $590.84 | $667.73 | $16,340.29 | |
| Apr, 2026 | 35 | $74.21 | $593.52 | $667.73 | $15,746.77 | |
| May, 2026 | 36 | $71.52 | $596.22 | $667.73 | $15,150.55 | |
| Jun, 2026 | 37 | $68.81 | $598.92 | $667.73 | $14,551.63 | |
| Jul, 2026 | 38 | $66.09 | $601.64 | $667.73 | $13,949.98 | |
| Aug, 2026 | 39 | $63.36 | $604.38 | $667.73 | $13,345.60 | |
| Sep, 2026 | 40 | $60.61 | $607.12 | $667.73 | $12,738.48 | |
| Oct, 2026 | 41 | $57.85 | $609.88 | $667.73 | $12,128.60 | |
| Nov, 2026 | 42 | $55.08 | $612.65 | $667.73 | $11,515.95 | |
| Dec, 2026 | 43 | $52.30 | $615.43 | $667.73 | $10,900.52 | |
| Jan, 2027 | 44 | $49.51 | $618.23 | $667.73 | $10,282.30 | |
| Feb, 2027 | 45 | $46.70 | $621.03 | $667.73 | $9,661.26 | |
| Mar, 2027 | 46 | $43.88 | $623.86 | $667.73 | $9,037.41 | |
| Apr, 2027 | 47 | $41.04 | $626.69 | $667.73 | $8,410.72 | |
| May, 2027 | 48 | $38.20 | $629.53 | $667.73 | $7,781.18 | |
| Jun, 2027 | 49 | $35.34 | $632.39 | $667.73 | $7,148.79 | |
| Jul, 2027 | 50 | $32.47 | $635.27 | $667.73 | $6,513.52 | |
| Aug, 2027 | 51 | $29.58 | $638.15 | $667.73 | $5,875.37 | |
| Sep, 2027 | 52 | $26.68 | $641.05 | $667.73 | $5,234.32 | |
| Oct, 2027 | 53 | $23.77 | $643.96 | $667.73 | $4,590.36 | |
| Nov, 2027 | 54 | $20.85 | $646.89 | $667.73 | $3,943.48 | |
| Dec, 2027 | 55 | $17.91 | $649.82 | $667.73 | $3,293.65 | |
| Jan, 2028 | 56 | $14.96 | $652.77 | $667.73 | $2,640.88 | |
| Feb, 2028 | 57 | $11.99 | $655.74 | $667.73 | $1,985.14 | |
| Mar, 2028 | 58 | $9.02 | $658.72 | $667.73 | $1,326.42 | |
| Apr, 2028 | 59 | $6.02 | $661.71 | $667.73 | $664.71 | |
| May, 2028 | 60 | $3.02 | $664.71 | $667.73 | $0.00 | |
Compare Monthly vs. Bi-weekly |
||||||
| Payment Frequency | Monthly | Bi-weekly | ||||
| Payments / Year | 12 | 26 | ||||
| Each Payment | $667.73 | $333.87 | ||||
| Total Interest | $5,063.99 | $4,563.24 | ||||
| Total Payment | $65,063.99 | $64,563.24 | Total Savings | $0 | $500.76 | |
| Payoff Date | May, 2028 | Dec, 2027 | ||||
Car Loan Calculator
