How much interest are you paying?
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
How much interest are you paying?
2
by Nest Egg Chick at juliemorgenlender.com
3
4
Instructions:

(2) Enter in the blue cells (overwrite the examples): the interest rate, the balance, and either how much you will pay in addition to the minimum payment OR your total monthly payment amount (if you will only pay the minimum, leave both of these blank) in the proper cells.
(3) All cells will automatically update after a few moments. The total amount you pay will appear in row 410.
(4) Note that if there is a value in cell C408 then you will not have paid off the debt after 33.33 years. Try increasing the monthly payment amount.
5
6
APR:1.00%Balance:\$100Extra monthly payment:\$0Total monthly payment:\$0
7
8
# Years
# MonthsBalanceInterest
Monthly Payment
9
0.081100.000.081.08
10
0.17299.000.081.07
11
0.25398.010.081.06
12
0.33497.030.081.05
13
0.42596.060.081.04
14
0.50695.100.081.03
15
0.58794.150.081.02
16
0.67893.210.081.01
17
0.75992.270.081.00
18
0.831091.350.080.99
19
0.921190.440.080.98
20
1.001289.530.070.97
21
1.081388.640.070.96
22
1.171487.750.070.95
23
1.251586.870.070.94
24
1.331686.010.070.93
25
1.421785.150.070.92
26
1.501884.290.070.91
27
1.581983.450.070.90
28
1.672082.620.070.90
29
1.752181.790.070.89
30
1.832280.970.070.88
31
1.922380.160.070.87
32
2.002479.360.070.86
33
2.082578.570.070.85
34
2.172677.780.060.84
35
2.252777.000.060.83
36
2.332876.230.060.83
37
2.422975.470.060.82
38
2.503074.720.060.81
39
2.583173.970.060.80
40
2.673273.230.060.79
41
2.753372.500.060.79
42
2.833471.770.060.78
43
2.923571.060.060.77
44
3.003670.340.060.76
45
3.083769.640.060.75
46
3.173868.940.060.75
47
3.253968.260.060.74
48
3.334067.570.060.73
49
3.424166.900.060.72
50
3.504266.230.060.72
51
3.584365.570.050.71
52
3.674464.910.050.70
53
3.754564.260.050.70
54
3.834663.620.050.69
55
3.924762.980.050.68
56
4.004862.350.050.68
57
4.084961.730.050.67
58
4.175061.110.050.66
59
4.255160.500.050.66
60
4.335259.900.050.65
61
4.425359.300.050.64
62
4.505458.700.050.64
63
4.585558.120.050.63
64
4.675657.540.050.62
65
4.755756.960.050.62
66
4.835856.390.050.61
67
4.925955.830.050.60
68
5.006055.270.050.60
69
5.086154.720.050.59
70
5.176254.170.050.59
71
5.256353.630.040.58
72
5.336453.090.040.58
73
5.426552.560.040.57
74
5.506652.030.040.56
75
5.586751.510.040.56
76
5.676851.000.040.55
77
5.756950.490.040.55
78
5.837049.980.040.54
79
5.927149.480.040.54
80
6.007248.990.040.53
81
6.087348.500.040.53
82
6.177448.010.040.52
83
6.257547.530.040.51
84
6.337647.060.040.51
85
6.427746.590.040.50
86
6.507846.120.040.50
87
6.587945.660.040.49
88
6.678045.200.040.49
89
6.758144.750.040.48
90
6.838244.300.040.48
91
6.928343.860.040.48
92
7.008443.420.040.47
93
7.088542.990.040.47
94
7.178642.560.040.46
95
7.258742.130.040.46
96
7.338841.710.030.45
97
7.428941.290.030.45
98
7.509040.880.030.44
99
7.589140.470.030.44
100
7.679240.070.030.43