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 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


Auto Loan Calculator Results

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


Car Loan Calculator


Apply Auto Loan Before You Buy



Auto Loan Calculator | Terms | Privacy | Disclaimer | Contact

©2023 Auto Loan Calculator