Car Loan Calculator Excel

Car Loan Calculator Excel is a calculator to calculate the monthly payments of your car loan and export the car 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: $39,000.00
Total Monthly Payment:
$749.45
Total # Of Payments: 60
Start Date: Jan, 2023
Payoff Date: Dec, 2027
Down Payment: $10,000.00
Trade In Value: $0.00
Sales Tax: $0.00
Other Fee: $0.00
Total Interest Paid: $5,967.24
Total of All Costs:
$54,967.24

Auto Loan Amortization Schedule

Payment Date Payment # Interest Principal Total Payment Balance
Jan, 2023 1 $186.88 $562.58 $749.45 $38,437.42
Feb, 2023 2 $184.18 $565.27 $749.45 $37,872.15
Mar, 2023 3 $181.47 $567.98 $749.45 $37,304.16
Apr, 2023 4 $178.75 $570.70 $749.45 $36,733.46
May, 2023 5 $176.01 $573.44 $749.45 $36,160.02
Jun, 2023 6 $173.27 $576.19 $749.45 $35,583.83
Jul, 2023 7 $170.51 $578.95 $749.45 $35,004.88
Aug, 2023 8 $167.73 $581.72 $749.45 $34,423.16
Sep, 2023 9 $164.94 $584.51 $749.45 $33,838.65
Oct, 2023 10 $162.14 $587.31 $749.45 $33,251.34
Nov, 2023 11 $159.33 $590.12 $749.45 $32,661.22
Dec, 2023 12 $156.50 $592.95 $749.45 $32,068.26
Jan, 2024 13 $153.66 $595.79 $749.45 $31,472.47
Feb, 2024 14 $150.81 $598.65 $749.45 $30,873.82
Mar, 2024 15 $147.94 $601.52 $749.45 $30,272.31
Apr, 2024 16 $145.05 $604.40 $749.45 $29,667.91
May, 2024 17 $142.16 $607.30 $749.45 $29,060.61
Jun, 2024 18 $139.25 $610.21 $749.45 $28,450.41
Jul, 2024 19 $136.32 $613.13 $749.45 $27,837.28
Aug, 2024 20 $133.39 $616.07 $749.45 $27,221.21
Sep, 2024 21 $130.43 $619.02 $749.45 $26,602.19
Oct, 2024 22 $127.47 $621.99 $749.45 $25,980.21
Nov, 2024 23 $124.49 $624.97 $749.45 $25,355.24
Dec, 2024 24 $121.49 $627.96 $749.45 $24,727.28
Jan, 2025 25 $118.48 $630.97 $749.45 $24,096.31
Feb, 2025 26 $115.46 $633.99 $749.45 $23,462.32
Mar, 2025 27 $112.42 $637.03 $749.45 $22,825.29
Apr, 2025 28 $109.37 $640.08 $749.45 $22,185.21
May, 2025 29 $106.30 $643.15 $749.45 $21,542.06
Jun, 2025 30 $103.22 $646.23 $749.45 $20,895.82
Jul, 2025 31 $100.13 $649.33 $749.45 $20,246.50
Aug, 2025 32 $97.01 $652.44 $749.45 $19,594.06
Sep, 2025 33 $93.89 $655.57 $749.45 $18,938.49
Oct, 2025 34 $90.75 $658.71 $749.45 $18,279.78
Nov, 2025 35 $87.59 $661.86 $749.45 $17,617.92
Dec, 2025 36 $84.42 $665.03 $749.45 $16,952.89
Jan, 2026 37 $81.23 $668.22 $749.45 $16,284.66
Feb, 2026 38 $78.03 $671.42 $749.45 $15,613.24
Mar, 2026 39 $74.81 $674.64 $749.45 $14,938.60
Apr, 2026 40 $71.58 $677.87 $749.45 $14,260.73
May, 2026 41 $68.33 $681.12 $749.45 $13,579.61
Jun, 2026 42 $65.07 $684.39 $749.45 $12,895.22
Jul, 2026 43 $61.79 $687.66 $749.45 $12,207.56
Aug, 2026 44 $58.49 $690.96 $749.45 $11,516.60
Sep, 2026 45 $55.18 $694.27 $749.45 $10,822.33
Oct, 2026 46 $51.86 $697.60 $749.45 $10,124.73
Nov, 2026 47 $48.51 $700.94 $749.45 $9,423.79
Dec, 2026 48 $45.16 $704.30 $749.45 $8,719.49
Jan, 2027 49 $41.78 $707.67 $749.45 $8,011.82
Feb, 2027 50 $38.39 $711.06 $749.45 $7,300.75
Mar, 2027 51 $34.98 $714.47 $749.45 $6,586.28
Apr, 2027 52 $31.56 $717.89 $749.45 $5,868.39
May, 2027 53 $28.12 $721.33 $749.45 $5,147.05
Jun, 2027 54 $24.66 $724.79 $749.45 $4,422.26
Jul, 2027 55 $21.19 $728.26 $749.45 $3,694.00
Aug, 2027 56 $17.70 $731.75 $749.45 $2,962.25
Sep, 2027 57 $14.19 $735.26 $749.45 $2,226.99
Oct, 2027 58 $10.67 $738.78 $749.45 $1,488.20
Nov, 2027 59 $7.13 $742.32 $749.45 $745.88
Dec, 2027 60 $3.57 $745.88 $749.45 $0.00

Compare Monthly vs. Bi-weekly

Payment Frequency Monthly Bi-weekly
Payments / Year 12 26
Each Payment $749.45 $374.73
Total Interest $5,967.24 $5,372.08
Total Payment $54,967.24 $54,372.08
Total Savings $0 $595.16
Payoff Date Dec, 2027 Aug, 2027


Car Loan Calculator | Terms | Privacy | Disclaimer | Contact

©2023 Car Loan Calculator