Car Loan Calculator Excel


You could save on auto insurance

Car Loan Calculator Excel to calculate the monthly payment for car loans and export the auto amortization schedule to excel.

Auto Loan Calculator Excel
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

Compare Auto Insurance Quotes in Minutes

Rates have changed. If you haven't compared carriers recently, you could be overpaying. This tool makes it fast and easy to shop multiple options.

⚑ 2 minutes or less
πŸ”’ Secure
🀝 No obligation, just compare

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

Compare Auto Insurance Quotes in Minutes

Rates have changed. If you haven't compared carriers recently, you could be overpaying. This tool makes it fast and easy to shop multiple options.

⚑ 2 minutes or less
πŸ”’ Secure
🀝 No obligation, just compare
Car Loan Calculator


Auto Loan Calculator | Terms | Privacy | Disclaimer | Contact

©2026 Auto Loan Calculator