Auto Loan Calculator with Extra Payments

Loan Calculator with Extra Payments
Enter Values Instructions
Loan Amount $2,500.00
Annual Interest Rate 5.500%
Loan Period in Years 5 Must be between 1 and 30 years.
Start Date of Loan 2/10/2045
Optional Extra Payments If your extra payments vary, enter them in the table below.
Scheduled Monthly Payment $ 47.75
Scheduled Number of Payments 60
Actual Number of Payments 60
Total Early Payments $ -
Total Interest $ 365.17
No. Interest
1 3/10/2045 $ 2,500.00 $ 47.75 $ - $ 47.75 $ 36.29 $ 11.46 $ 2,463.71
2 4/10/2045 2,463.71 47.75 - 47.75 36.46 11.29 2,427.24
3 5/10/2045 2,427.24 47.75 - 47.75 36.63 11.12 2,390.62
4 6/10/2045 2,390.62 47.75 - 47.75 36.80 10.96 2,353.82
5 7/10/2045 2,353.82 47.75 - 47.75 36.96 10.79 2,316.86
6 8/10/2045 2,316.86 47.75 - 47.75 37.13 10.62 2,279.72
7 9/10/2045 2,279.72 47.75 - 47.75 37.30 10.45 2,242.42
8 10/10/2045 2,242.42 47.75 - 47.75 37.48 10.28 2,204.94
9 11/10/2045 2,204.94 47.75 - 47.75 37.65 10.11 2,167.30
10 12/10/2045 2,167.30 47.75 - 47.75 37.82 9.93 2,129.48
11 1/10/2046 2,129.48 47.75 - 47.75 37.99 9.76 2,091.48
12 2/10/2046 2,091.48 47.75 - 47.75 38.17 9.59 2,053.32
13 3/10/2046 2,053.32 47.75 - 47.75 38.34 9.41 2,014.97
14 4/10/2046 2,014.97 47.75 - 47.75 38.52 9.24 1,976.46
15 5/10/2046 1,976.46 47.75 - 47.75 38.69 9.06 1,937.76
16 6/10/2046 1,937.76 47.75 - 47.75 38.87 8.88 1,898.89
17 7/10/2046 1,898.89 47.75 - 47.75 39.05 8.70 1,859.84
18 8/10/2046 1,859.84 47.75 - 47.75 39.23 8.52 1,820.61
19 9/10/2046 1,820.61 47.75 - 47.75 39.41 8.34 1,781.20
20 10/10/2046 1,781.20 47.75 - 47.75 39.59 8.16 1,741.62
21 11/10/2046 1,741.62 47.75 - 47.75 39.77 7.98 1,701.85
22 12/10/2046 1,701.85 47.75 - 47.75 39.95 7.80 1,661.89
23 1/10/2047 1,661.89 47.75 - 47.75 40.14 7.62 1,621.76
24 2/10/2047 1,621.76 47.75 - 47.75 40.32 7.43 1,581.44
25 3/10/2047 1,581.44 47.75 - 47.75 40.50 7.25 1,540.93
26 4/10/2047 1,540.93 47.75 - 47.75 40.69 7.06 1,500.24
27 5/10/2047 1,500.24 47.75 - 47.75 40.88 6.88 1,459.36
28 6/10/2047 1,459.36 47.75 - 47.75 41.06 6.69 1,418.30
29 7/10/2047 1,418.30 47.75 - 47.75 41.25 6.50 1,377.05
30 8/10/2047 1,377.05 47.75 - 47.75 41.44 6.31 1,335.61
31 9/10/2047 1,335.61 47.75 - 47.75 41.63 6.12 1,293.98
32 10/10/2047 1,293.98 47.75 - 47.75 41.82 5.93 1,252.15
33 11/10/2047 1,252.15 47.75 - 47.75 42.01 5.74 1,210.14
34 12/10/2047 1,210.14 47.75 - 47.75 42.21 5.55 1,167.93
35 1/10/2048 1,167.93 47.75 - 47.75 42.40 5.35 1,125.53
36 2/10/2048 1,125.53 47.75 - 47.75 42.59 5.16 1,082.94
37 3/10/2048 1,082.94 47.75 - 47.75 42.79 4.96 1,040.15
38 4/10/2048 1,040.15 47.75 - 47.75 42.99 4.77 997.16
39 5/10/2048 997.16 47.75 - 47.75 43.18 4.57 953.98
40 6/10/2048 953.98 47.75 - 47.75 43.38 4.37 910.60
41 7/10/2048 910.60 47.75 - 47.75 43.58 4.17 867.02
42 8/10/2048 867.02 47.75 - 47.75 43.78 3.97 823.24
43 9/10/2048 823.24 47.75 - 47.75 43.98 3.77 779.26
44 10/10/2048 779.26 47.75 - 47.75 44.18 3.57 735.08
45 11/10/2048 735.08 47.75 - 47.75 44.38 3.37 690.70
46 12/10/2048 690.70 47.75 - 47.75 44.59 3.17 646.11
Paymen
t Date
Beginning
Balance
Schedule
d
Payment
Extra
Paymen
t
Total
Payment
Principa
l
Ending
Balance
Page 1/7
Free Download

Auto Loan Calculator with Extra Payments XLS

Favor this template? Just fancy it by voting!
  •  
  •  
  •  
  •  
  •  
(0 Votes)
0.0
Related Forms
  •  
  •  
  •  
  •  
  •  
3 Page(s) | 849 Views | 6 Downloads
  •  
  •  
  •  
  •  
  •  
16 Page(s) | 2943 Views | 4 Downloads
  •  
  •  
  •  
  •  
  •  
1 Page(s) | 450 Views | 6 Downloads
  •  
  •  
  •  
  •  
  •  
1 Page(s) | 472 Views | 6 Downloads
  •  
  •  
  •  
  •  
  •  
6 Page(s) | 1682 Views | 6 Downloads