64 64 60 58 70 70 70 70 74
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Interest ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On any line input the principle (Col B), daily interest rate (Col C) and plan duration (Col D). DO NOT alter cells E,F,G,H &
Principle % Int Period Daily ~ Non Compounded ~ ~ 100% Compounded ~
Interest - Principle +Principle - Principle
78.00 2.60 12 2.028000 24.34 102.34 28.14
100.00 1.50 60 1.500000 90.00 190.00 144.32
100.00 1.50 150 1.500000 225.00 325.00 833.05
100.00 1.50 180 1.500000 270.00 370.00 1358.44
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Interest ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On any line input the daily interest rate. DO NOT alter cells G & H21 to G & H25.
With A For A
Daily Daily Deposit
% Int of Profit Of Required
1.50 1.00000 66.67
1.50 2.00000 133.33
1.50 3.00000 200.00
1.50 4.00000 266.67
1.50 5.00000 333.33
74 64 64 64 30 74 64 64 74
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~ Compounding Day By Day ~~~~~~
duration (Col D). DO NOT alter cells E,F,G,H & I DO NOT alter the blue cells.
Just input the starting principle and daily interest rate
~ 100% Compounded ~ Variable Interest New
+Principle Principle %Int Amount Principle
106.14 1 100.000000 6.19 6.19000 106.190000
244.32 2 106.190000 12.18 12.93394 119.123942
933.05 3 119.123942 4.96 5.90855 125.032490
1458.44 4 125.032490 2.87 3.58843 128.620922
5 128.620922 2.91 3.74287 132.363791
~~~~~~~~~~~~~~~~~~~~~ 6 132.363791 1.10 1.45600 133.819793
7 133.819793 2.79 3.73357 137.553365
er cells G & H21 to G & H25. 8 137.553365 1.42 1.95326 139.506622
9 139.506622 4.36 6.08249 145.589111
10 145.589111 2.12 3.08649 148.675600
11 148.675600 7.85 11.67103 160.346635
12 160.346635 1.91 3.06262 163.409256
13 163.409256 -20.00 -32.68185 130.727405
14 130.727405 3.14 4.10484 134.832245
15 134.832245 6.11 8.23825 143.070495
16 143.070495 1.48 2.11744 145.187939
17 145.187939 5.02 7.28843 152.476373
18 152.476373 12.19 18.58687 171.063243
19 171.063243 3.33 5.69641 176.759649
20 176.759649 3.59 6.34567 183.105320
21 183.105320 4.35 7.96508 191.070402
22 191.070402 2.59 4.94872 196.019125
23 196.019125 3.83 7.50753 203.526658
24 203.526658 0.95 1.93350 205.460161
25 205.460161 1.24 2.54771 208.007867
26 208.007867 -20.00 -41.60157 166.406294
27 166.406294 1.53 2.54602 168.952310
28 168.952310 9.80 16.55733 185.509636
29 185.509636 9.39 17.41935 202.928991
30 202.928991 0.82 1.66402 204.593009
31 204.593009 8.80 18.00418 222.597194
32 222.597194 1.47 3.27218 225.869372
33 225.869372 1.54 3.47839 229.347761
34 229.347761 -20.00 -45.86955 183.478209
35 183.478209 -20.00 -36.69564 146.782567
36 146.782567 1.09 1.59993 148.382497
37 148.382497 7.04 10.44613 158.828625
38 158.828625 2.77 4.39955 163.228177
39 163.228177 3.82 6.23532 169.463494
40 169.463494 1.30 2.20303 171.666519
41 171.666519 0.72 1.23600 172.902518
42 172.902518 5.63 9.73441 182.636930
43 182.636930 1.12 2.04553 184.682464
44 184.682464 10.37 19.15157 203.834035
45 203.834035 0.63 1.28415 205.118190
46 205.118190 1.83 3.75366 208.871852
47 208.871852 1.86 3.88502 212.756869
48 212.756869 0.75 1.59568 214.352545
49 214.352545 5.10 10.93198 225.284525
50 225.284525 3.14 7.07393 232.358459
51 232.358459 0.61 1.41739 233.775846
52 233.775846 0.91 2.12736 235.903206
53 235.903206 -20.00 -47.18064 188.722565
54 188.722565 1.72 3.24603 191.968593
56 191.968593 2.67 5.12556 197.094154
57 197.094154 3.09 6.09021 203.184364
58 203.184364 0.82 1.66611 204.850476
59 204.850476 2.48 5.08029 209.930767
60 209.930767 -20.00 -41.98615 167.944614
61 167.944614 -20.00 -33.58892 134.355691
62 134.355691 -20.00 -26.87114 107.484553
63 107.484553 0.00000 107.484553
64 107.484553 0.00000 107.484553
65 107.484553 0.00000 107.484553
66 107.484553 0.00000 107.484553
64 64 64 64 64
~~~~~ Compounding Day By Day ~~~~~
Fixed Interest New
Principle %Int Amount Principle
78.00 2.60 2.03 80.03
80.03 2.60 2.08 82.11
82.11 2.60 2.13 84.24
84.24 2.60 2.19 86.43
86.43 2.60 2.25 88.68
88.68 2.60 2.31 90.99
90.99 2.60 2.37 93.35
93.35 2.60 2.43 95.78
95.78 2.60 2.49 98.27
98.27 2.60 2.56 100.82
100.82 2.60 2.62 103.45
103.45 2.60 2.69 106.14
106.14 2.60 2.76 108.90
108.90 2.60 2.83 111.73
111.73 2.60 2.90 114.63
114.63 2.60 2.98 117.61
117.61 2.60 3.06 120.67
120.67 2.60 3.14 123.81
123.81 2.60 3.22 127.03
127.03 2.60 3.30 130.33
130.33 2.60 3.39 133.72
133.72 2.60 3.48 137.19
137.19 2.60 3.57 140.76
140.76 2.60 3.66 144.42
144.42 2.60 3.75 148.18
148.18 2.60 3.85 152.03
152.03 2.60 3.95 155.98
155.98 2.60 4.06 160.04
160.04 2.60 4.16 164.20
164.20 2.60 4.27 168.47
168.47 2.60 4.38 172.85
172.85 2.60 4.49 177.34
177.34 2.60 4.61 181.95
181.95 2.60 4.73 186.68
186.68 2.60 4.85 191.54
191.54 2.60 4.98 196.52
196.52 2.60 5.11 201.63
201.63 2.60 5.24 206.87
206.87 2.60 5.38 212.25
212.25 2.60 5.52 217.77