Loan Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMTUVWXYZAAABAC
1
LOAN CALCULATOR
2
3
Manually Entered ValuesNumberMonthYearBalanceInterest
Total Balance
Paid Monthly Total
Paid Interest Total
Additional Paid
Total Paid
4
Initial Price$14,000.00***Editable***
5
Initial Or Down Payment$5,000.001September2015$9,000.00$179.93$9,179.93$400.00$179.93$5,400.00
6
Interest Rate24.0%2October2015$8,779.93$175.53$8,955.45$800.00$355.45$5,800.00
7
Monthly Payments$400.003November2015$8,555.45$171.04$8,726.49$1,200.00$526.49$6,200.00
8
Purchase or Loan Date08/20154December2015$8,326.49$166.46$8,492.95$1,600.00$692.95$6,600.00
9
Make sure Interest Rate has % sign
5January2016$8,092.95$161.79$8,254.74$2,000.00$854.74$7,000.00
10
*** Do NOT modify below ***6February2016$7,854.74$157.03$8,011.77$2,400.00$1,011.77$7,400.00
11
Automatically Calculated Values7March2016$7,611.77$152.17$7,763.94$2,800.00$1,163.94$7,800.00
12
Payment Start Date09/20158April2016$7,363.94$147.22$7,511.16$3,200.00$1,311.16$8,200.00
13
Payment Ending Date03/20189May2016$7,111.16$142.16$7,253.32$3,600.00$1,453.32$8,600.00
14
Total Loan Amount$9,000.0010June2016$6,853.32$137.01$6,990.33$4,000.00$1,590.33$9,000.00
15
Number of Payments3111July2016$6,590.33$131.75$6,722.08$4,400.00$1,722.08$9,400.00
16
Last Payment Amount$74.6112August2016$6,322.08$126.39$6,448.47$4,800.00$1,848.47$9,800.00
17
Total Monthly and Interest$12,073.1513September2016$6,048.47$120.92$6,169.39$5,200.00$1,969.39$10,200.00
18
Total Additional Payment$0.0014October2016$5,769.39$115.34$5,884.73$5,600.00$2,084.73$10,600.00
19
Total Interest Paid$3,074.6115November2016$5,484.73$109.65$5,594.38$6,000.00$2,194.38$11,000.00
20
Total Combined Cost$17,073.1516December2016$5,194.38$103.84$5,298.22$6,400.00$2,298.22$11,400.00
21
17January2017$4,898.22$97.92$4,996.15$6,800.00$2,396.15$11,800.00
22
* Total Combined Cost * =18February2017$4,596.15$91.88$4,688.03$7,200.00$2,488.03$12,200.00
23
Loan + Downpayment + Interest + Any Additional
19March2017$4,288.03$85.72$4,373.76$7,600.00$2,573.76$12,600.00
24
20April2017$3,973.76$79.44$4,053.20$8,000.00$2,653.20$13,000.00
25
** You can enter extra payments you plan to make
21May2017$3,653.20$73.03$3,726.23$8,400.00$2,726.23$13,400.00
26
in “Additional Payment” column.
22June2017$3,326.23$66.50$3,392.73$8,800.00$2,792.73$13,800.00
27
23July2017$2,992.73$59.83$3,052.56$9,200.00$2,852.56$14,200.00
28
24August2017$2,652.56$53.03$2,705.59$9,600.00$2,905.59$14,600.00
29
25September2017$2,305.59$46.09$2,351.68$10,000.00$2,951.68$15,000.00
30
26October2017$1,951.68$39.02$1,990.70$10,400.00$2,990.70$15,400.00
31
27November2017$1,590.70$31.80$1,622.50$10,800.00$3,022.50$15,800.00
32
28December2017$1,222.50$24.44$1,246.94$11,200.00$3,046.94$16,200.00
33
29January2018$846.94$16.93$863.87$11,600.00$3,063.87$16,600.00
34
30February2018$463.87$9.27$473.15$12,000.00$3,073.15$17,000.00
35
31March2018$73.15$1.46$74.61$12,073.15$3,074.61$17,073.15
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
 
 
Main menu