jagomart
digital resources
picture1_Spreadsheet Calculator 46316 | Compound Interest Calculator Uk The Humble Penny 2019


 217x       Filetype XLSX       File size 0.21 MB       Source: thehumblepenny.com


File: Spreadsheet Calculator 46316 | Compound Interest Calculator Uk The Humble Penny 2019
sheet 1 guidance notes the humble penny financial joy academy hey hope you enjoy using this custom built compound interest calculator the cells to change ie inputs are the yellow ...

icon picture XLSX Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Guidance notes
The Humble Penny











Financial Joy Academy

































Hey!




















Hope you enjoy using this custom built Compound Interest Calculator.




















The cells to change (i.e. inputs) are the yellow ones on Column E ONLY!




















You can then see the results (i.e. outputs) from Row 17 onwards.




















I have also included some Scenario Analysis and graphs from Column I onwards.




















Enjoy!




















Ken Okoroafor









The Humble Penny










Sheet 2: Compound Interest Example
The Humble Penny



































Financial Joy Academy






























































































Choose Currency: £
Inputs

SCENARIO ANALYSIS & GRAPHS







Age to start investing: 25














£



Investment period (years): 20




Compounded annual growth rate (%)




$



Monthly investment (£): 1000



432,229.80 Ken Okoroafor: You can also change these percentages manually simply by typing in the figures you want. 2% 5% 7% 10% 15% 20%






Assumed annual return (%): 5%


Time in Years Ken Okoroafor: You can also change these percentages manually simply by typing in the figures you want. 5



X



Total pot of money after 20 years IF compounding: 432,229.80


10







Total pot of money after 20 years IF NOT compounding by holding in CASH: 250,000.00


15







Total possible wealth not gained over 20 years by NOT investing: -182,229.80


20












25




Age Year Month Compounding(£) Starting pot/Lump sum(£) No Compounding(£)

30




25.1 0.1 1 11,000.00 Ken Okoroafor: Add a figure here if you're starting investing with a lump sum. 10,000.00 11,000.00














25.2 0.2 2 12,044.82
12,000.00














25.3 0.3 3 13,093.89
13,000.00














25.3 0.3 4 14,147.23
14,000.00














25.4 0.4 5 15,204.87
15,000.00



Compounded annual growth rate (%)





25.5 0.5 6 16,266.82
16,000.00


250,000.00 Ken Okoroafor: You can also change these percentages manually simply by typing in the figures you want. 2% 5% 7% 10% 15%





25.6 0.6 7 17,333.09
17,000.00

Time in Years Ken Okoroafor: You can also change these percentages manually simply by typing in the figures you want. 5





25.7 0.7 8 18,403.71
18,000.00

10





25.8 0.8 9 19,478.69
19,000.00

15





25.8 0.8 10 20,558.05
20,000.00

20





25.9 0.9 11 21,641.80
21,000.00

25





26.0 1.0 12 22,729.97
22,000.00

30





26.1 1.1 13 23,822.58
23,000.00














26.2 1.2 14 24,919.63
24,000.00














26.3 1.3 15 26,021.16
25,000.00




26.3 1.3 16 27,127.17
26,000.00



26.4 1.4 17 28,237.69
27,000.00



26.5 1.5 18 29,352.74
28,000.00



26.6 1.6 19 30,472.32
29,000.00



26.7 1.7 20 31,596.47
30,000.00



26.8 1.8 21 32,725.20
31,000.00



26.8 1.8 22 33,858.53
32,000.00



26.9 1.9 23 34,996.47
33,000.00



27.0 2.0 24 36,139.05
34,000.00



27.1 2.1 25 37,286.28
35,000.00



27.2 2.2 26 38,438.19
36,000.00



27.3 2.3 27 39,594.79
37,000.00



27.3 2.3 28 40,756.11
38,000.00



27.4 2.4 29 41,922.15
39,000.00



27.5 2.5 30 43,092.95
40,000.00



27.6 2.6 31 44,268.52
41,000.00



27.7 2.7 32 45,448.87
42,000.00



27.8 2.8 33 46,634.04
43,000.00



27.8 2.8 34 47,824.03
44,000.00



27.9 2.9 35 49,018.87
45,000.00



28.0 3.0 36 50,218.58
46,000.00



28.1 3.1 37 51,423.18
47,000.00



28.2 3.2 38 52,632.68
48,000.00



28.3 3.3 39 53,847.11
49,000.00



28.3 3.3 40 55,066.49
50,000.00














28.4 3.4 41 56,290.84
51,000.00














28.5 3.5 42 57,520.18
52,000.00














28.6 3.6 43 58,754.52
53,000.00














28.7 3.7 44 59,993.89
54,000.00














28.8 3.8 45 61,238.32
55,000.00














28.8 3.8 46 62,487.81
56,000.00














28.9 3.9 47 63,742.39
57,000.00














29.0 4.0 48 65,002.09
58,000.00














29.1 4.1 49 66,266.91
59,000.00














29.2 4.2 50 67,536.89
60,000.00














29.3 4.3 51 68,812.05
61,000.00














29.3 4.3 52 70,092.39
62,000.00














29.4 4.4 53 71,377.96
63,000.00














29.5 4.5 54 72,668.76
64,000.00














29.6 4.6 55 73,964.82
65,000.00














29.7 4.7 56 75,266.17
66,000.00














29.8 4.8 57 76,572.81
67,000.00














29.8 4.8 58 77,884.78
68,000.00














29.9 4.9 59 79,202.09
69,000.00














30.0 5.0 60 80,524.77
70,000.00














30.1 5.1 61 81,852.84
71,000.00














30.2 5.2 62 83,186.31
72,000.00














30.3 5.3 63 84,525.23
73,000.00














30.3 5.3 64 85,869.59
74,000.00














30.4 5.4 65 87,219.43
75,000.00














30.5 5.5 66 88,574.78
76,000.00














30.6 5.6 67 89,935.64
77,000.00














30.7 5.7 68 91,302.05
78,000.00














30.8 5.8 69 92,674.03
79,000.00














30.8 5.8 70 94,051.59
80,000.00














30.9 5.9 71 95,434.77
81,000.00














31.0 6.0 72 96,823.58
82,000.00














31.1 6.1 73 98,218.05
83,000.00














31.2 6.2 74 99,618.21
84,000.00














31.3 6.3 75 101,024.06
85,000.00














31.3 6.3 76 102,435.65
86,000.00














31.4 6.4 77 103,852.98
87,000.00














31.5 6.5 78 105,276.09
88,000.00














31.6 6.6 79 106,705.00
89,000.00














31.7 6.7 80 108,139.73
90,000.00














31.8 6.8 81 109,580.31
91,000.00














31.8 6.8 82 111,026.75
92,000.00














31.9 6.9 83 112,479.09
93,000.00














32.0 7.0 84 113,937.34
94,000.00














32.1 7.1 85 115,401.53
95,000.00














32.2 7.2 86 116,871.69
96,000.00














32.3 7.3 87 118,347.84
97,000.00














32.3 7.3 88 119,830.01
98,000.00














32.4 7.4 89 121,318.21
99,000.00














32.5 7.5 90 122,812.48
100,000.00














32.6 7.6 91 124,312.83
101,000.00














32.7 7.7 92 125,819.30
102,000.00














32.8 7.8 93 127,331.90
103,000.00














32.8 7.8 94 128,850.66
104,000.00














32.9 7.9 95 130,375.62
105,000.00














33.0 8.0 96 131,906.78
106,000.00














33.1 8.1 97 133,444.19
107,000.00














33.2 8.2 98 134,987.86
108,000.00














33.3 8.3 99 136,537.81
109,000.00














33.3 8.3 100 138,094.09
110,000.00














33.4 8.4 101 139,656.70
111,000.00














33.5 8.5 102 141,225.68
112,000.00














33.6 8.6 103 142,801.05
113,000.00














33.7 8.7 104 144,382.84
114,000.00














33.8 8.8 105 145,971.07
115,000.00














33.8 8.8 106 147,565.78
116,000.00














33.9 8.9 107 149,166.98
117,000.00














34.0 9.0 108 150,774.70
118,000.00














34.1 9.1 109 152,388.98
119,000.00














34.2 9.2 110 154,009.83
120,000.00














34.3 9.3 111 155,637.28
121,000.00














34.3 9.3 112 157,271.37
122,000.00














34.4 9.4 113 158,912.11
123,000.00














34.5 9.5 114 160,559.54
124,000.00














34.6 9.6 115 162,213.68
125,000.00














34.7 9.7 116 163,874.56
126,000.00














34.8 9.8 117 165,542.20
127,000.00














34.8 9.8 118 167,216.64
128,000.00














34.9 9.9 119 168,897.90
129,000.00














35.0 10.0 120 170,586.01
130,000.00














35.1 10.1 121 172,281.00
131,000.00














35.2 10.2 122 173,982.90
132,000.00














35.3 10.3 123 175,691.72
133,000.00














35.3 10.3 124 177,407.51
134,000.00














35.4 10.4 125 179,130.29
135,000.00














35.5 10.5 126 180,860.09
136,000.00














35.6 10.6 127 182,596.94
137,000.00














35.7 10.7 128 184,340.86
138,000.00














35.8 10.8 129 186,091.89
139,000.00














35.8 10.8 130 187,850.05
140,000.00














35.9 10.9 131 189,615.38
141,000.00














36.0 11.0 132 191,387.89
142,000.00














36.1 11.1 133 193,167.63
143,000.00














36.2 11.2 134 194,954.62
144,000.00














36.3 11.3 135 196,748.89
145,000.00














36.3 11.3 136 198,550.47
146,000.00














36.4 11.4 137 200,359.39
147,000.00














36.5 11.5 138 202,175.68
148,000.00














36.6 11.6 139 203,999.36
149,000.00














36.7 11.7 140 205,830.48
150,000.00














36.8 11.8 141 207,669.06
151,000.00














36.8 11.8 142 209,515.13
152,000.00














36.9 11.9 143 211,368.72
153,000.00














37.0 12.0 144 213,229.86
154,000.00














37.1 12.1 145 215,098.59
155,000.00














37.2 12.2 146 216,974.93
156,000.00














37.3 12.3 147 218,858.91
157,000.00














37.3 12.3 148 220,750.57
158,000.00














37.4 12.4 149 222,649.93
159,000.00














37.5 12.5 150 224,557.04
160,000.00














37.6 12.6 151 226,471.91
161,000.00














37.7 12.7 152 228,394.58
162,000.00














37.8 12.8 153 230,325.09
163,000.00














37.8 12.8 154 232,263.47
164,000.00














37.9 12.9 155 234,209.74
165,000.00














38.0 13.0 156 236,163.93
166,000.00














38.1 13.1 157 238,126.10
167,000.00














38.2 13.2 158 240,096.25
168,000.00














38.3 13.3 159 242,074.43
169,000.00














38.3 13.3 160 244,060.67
170,000.00














38.4 13.4 161 246,055.01
171,000.00














38.5 13.5 162 248,057.47
172,000.00














38.6 13.6 163 250,068.08
173,000.00














38.7 13.7 164 252,086.89
174,000.00














38.8 13.8 165 254,113.92
175,000.00














38.8 13.8 166 256,149.22
176,000.00














38.9 13.9 167 258,192.80
177,000.00














39.0 14.0 168 260,244.71
178,000.00














39.1 14.1 169 262,304.98
179,000.00














39.2 14.2 170 264,373.64
180,000.00














39.3 14.3 171 266,450.73
181,000.00














39.3 14.3 172 268,536.29
182,000.00














39.4 14.4 173 270,630.34
183,000.00














39.5 14.5 174 272,732.92
184,000.00














39.6 14.6 175 274,844.06
185,000.00














39.7 14.7 176 276,963.81
186,000.00














39.8 14.8 177 279,092.20
187,000.00














39.8 14.8 178 281,229.25
188,000.00














39.9 14.9 179 283,375.02
189,000.00














40.0 15.0 180 285,529.52
190,000.00














40.1 15.1 181 287,692.80
191,000.00














40.2 15.2 182 289,864.90
192,000.00














40.3 15.3 183 292,045.85
193,000.00














40.3 15.3 184 294,235.68
194,000.00














40.4 15.4 185 296,434.43
195,000.00














40.5 15.5 186 298,642.14
196,000.00














40.6 15.6 187 300,858.85
197,000.00














40.7 15.7 188 303,084.58
198,000.00














40.8 15.8 189 305,319.39
199,000.00














40.8 15.8 190 307,563.29
200,000.00














40.9 15.9 191 309,816.35
201,000.00














41.0 16.0 192 312,078.58
202,000.00














41.1 16.1 193 314,350.02
203,000.00














41.2 16.2 194 316,630.72
204,000.00














41.3 16.3 195 318,920.72
205,000.00














41.3 16.3 196 321,220.04
206,000.00














41.4 16.4 197 323,528.73
207,000.00














41.5 16.5 198 325,846.82
208,000.00














41.6 16.6 199 328,174.37
209,000.00














41.7 16.7 200 330,511.39
210,000.00














41.8 16.8 201 332,857.93
211,000.00














41.8 16.8 202 335,214.04
212,000.00














41.9 16.9 203 337,579.74
213,000.00














42.0 17.0 204 339,955.08
214,000.00














42.1 17.1 205 342,340.10
215,000.00














42.2 17.2 206 344,734.84
216,000.00














42.3 17.3 207 347,139.33
217,000.00














42.3 17.3 208 349,553.62
218,000.00














42.4 17.4 209 351,977.74
219,000.00














42.5 17.5 210 354,411.74
220,000.00














42.6 17.6 211 356,855.66
221,000.00














42.7 17.7 212 359,309.53
222,000.00














42.8 17.8 213 361,773.41
223,000.00














42.8 17.8 214 364,247.32
224,000.00














42.9 17.9 215 366,731.30
225,000.00














43.0 18.0 216 369,225.41
226,000.00














43.1 18.1 217 371,729.68
227,000.00














43.2 18.2 218 374,244.16
228,000.00














43.3 18.3 219 376,768.87
229,000.00














43.3 18.3 220 379,303.88
230,000.00














43.4 18.4 221 381,849.21
231,000.00














43.5 18.5 222 384,404.91
232,000.00














43.6 18.6 223 386,971.02
233,000.00














43.7 18.7 224 389,547.59
234,000.00














43.8 18.8 225 392,134.65
235,000.00














43.8 18.8 226 394,732.26
236,000.00














43.9 18.9 227 397,340.45
237,000.00














44.0 19.0 228 399,959.26
238,000.00














44.1 19.1 229 402,588.75
239,000.00














44.2 19.2 230 405,228.94
240,000.00














44.3 19.3 231 407,879.89
241,000.00














44.3 19.3 232 410,541.65
242,000.00














44.4 19.4 233 413,214.25
243,000.00














44.5 19.5 234 415,897.73
244,000.00














44.6 19.6 235 418,592.15
245,000.00














44.7 19.7 236 421,297.55
246,000.00














44.8 19.8 237 424,013.96
247,000.00














44.8 19.8 238 426,741.45
248,000.00














44.9 19.9 239 429,480.05
249,000.00














45.0 20.0 240 432,229.80
250,000.00














45.1 20.1 241 434,990.76
251,000.00














45.2 20.2 242 437,762.97
252,000.00














45.3 20.3 243 440,546.47
253,000.00














45.3 20.3 244 443,341.31
254,000.00














45.4 20.4 245 446,147.53
255,000.00














45.5 20.5 246 448,965.20
256,000.00














45.6 20.6 247 451,794.34
257,000.00














45.7 20.7 248 454,635.00
258,000.00














45.8 20.8 249 457,487.24
259,000.00














45.8 20.8 250 460,351.10
260,000.00














45.9 20.9 251 463,226.63
261,000.00














46.0 21.0 252 466,113.87
262,000.00














46.1 21.1 253 469,012.88
263,000.00














46.2 21.2 254 471,923.69
264,000.00














46.3 21.3 255 474,846.37
265,000.00














46.3 21.3 256 477,780.95
266,000.00














46.4 21.4 257 480,727.49
267,000.00














46.5 21.5 258 483,686.03
268,000.00














46.6 21.6 259 486,656.63
269,000.00














46.7 21.7 260 489,639.33
270,000.00














46.8 21.8 261 492,634.18
271,000.00














46.8 21.8 262 495,641.23
272,000.00














46.9 21.9 263 498,660.54
273,000.00














47.0 22.0 264 501,692.14
274,000.00














47.1 22.1 265 504,736.10
275,000.00














47.2 22.2 266 507,792.45
276,000.00














47.3 22.3 267 510,861.26
277,000.00














47.3 22.3 268 513,942.58
278,000.00














47.4 22.4 269 517,036.44
279,000.00














47.5 22.5 270 520,142.91
280,000.00














47.6 22.6 271 523,262.04
281,000.00














47.7 22.7 272 526,393.87
282,000.00














47.8 22.8 273 529,538.47
283,000.00














47.8 22.8 274 532,695.87
284,000.00














47.9 22.9 275 535,866.14
285,000.00














48.0 23.0 276 539,049.33
286,000.00














48.1 23.1 277 542,245.48
287,000.00














48.2 23.2 278 545,454.65
288,000.00














48.3 23.3 279 548,676.90
289,000.00














48.3 23.3 280 551,912.28
290,000.00














48.4 23.4 281 555,160.84
291,000.00














48.5 23.5 282 558,422.63
292,000.00














48.6 23.6 283 561,697.72
293,000.00














48.7 23.7 284 564,986.14
294,000.00














48.8 23.8 285 568,287.97
295,000.00














48.8 23.8 286 571,603.24
296,000.00














48.9 23.9 287 574,932.03
297,000.00














49.0 24.0 288 578,274.37
298,000.00














49.1 24.1 289 581,630.33
299,000.00














49.2 24.2 290 584,999.96
300,000.00














49.3 24.3 291 588,383.33
301,000.00














49.3 24.3 292 591,780.47
302,000.00














49.4 24.4 293 595,191.46
303,000.00














49.5 24.5 294 598,616.34
304,000.00














49.6 24.6 295 602,055.18
305,000.00














49.7 24.7 296 605,508.03
306,000.00














49.8 24.8 297 608,974.94
307,000.00














49.8 24.8 298 612,455.98
308,000.00














49.9 24.9 299 615,951.20
309,000.00














50.0 25.0 300 619,460.67
310,000.00














50.1 25.1 301 622,984.42
311,000.00














50.2 25.2 302 626,522.54
312,000.00














50.3 25.3 303 630,075.07
313,000.00














50.3 25.3 304 633,642.07
314,000.00














50.4 25.4 305 637,223.61
315,000.00














50.5 25.5 306 640,819.74
316,000.00














50.6 25.6 307 644,430.52
317,000.00














50.7 25.7 308 648,056.01
318,000.00














50.8 25.8 309 651,696.27
319,000.00














50.8 25.8 310 655,351.36
320,000.00














50.9 25.9 311 659,021.34
321,000.00














51.0 26.0 312 662,706.28
322,000.00














51.1 26.1 313 666,406.22
323,000.00














51.2 26.2 314 670,121.25
324,000.00














51.3 26.3 315 673,851.40
325,000.00














51.3 26.3 316 677,596.76
326,000.00














51.4 26.4 317 681,357.37
327,000.00














51.5 26.5 318 685,133.30
328,000.00














51.6 26.6 319 688,924.62
329,000.00














51.7 26.7 320 692,731.39
330,000.00














51.8 26.8 321 696,553.66
331,000.00














51.8 26.8 322 700,391.50
332,000.00














51.9 26.9 323 704,244.99
333,000.00














52.0 27.0 324 708,114.17
334,000.00














52.1 27.1 325 711,999.11
335,000.00














52.2 27.2 326 715,899.88
336,000.00














52.3 27.3 327 719,816.55
337,000.00














52.3 27.3 328 723,749.17
338,000.00














52.4 27.4 329 727,697.82
339,000.00














52.5 27.5 330 731,662.55
340,000.00














52.6 27.6 331 735,643.43
341,000.00














52.7 27.7 332 739,640.53
342,000.00














52.8 27.8 333 743,653.92
343,000.00














52.8 27.8 334 747,683.66
344,000.00














52.9 27.9 335 751,729.81
345,000.00














53.0 28.0 336 755,792.45
346,000.00














53.1 28.1 337 759,871.65
347,000.00














53.2 28.2 338 763,967.46
348,000.00














53.3 28.3 339 768,079.95
349,000.00














53.3 28.3 340 772,209.21
350,000.00














53.4 28.4 341 776,355.28
351,000.00














53.5 28.5 342 780,518.25
352,000.00














53.6 28.6 343 784,698.18
353,000.00














53.7 28.7 344 788,895.14
354,000.00














53.8 28.8 345 793,109.19
355,000.00














53.8 28.8 346 797,340.42
356,000.00














53.9 28.9 347 801,588.88
357,000.00














54.0 29.0 348 805,854.65
358,000.00














54.1 29.1 349 810,137.81
359,000.00














54.2 29.2 350 814,438.41
360,000.00














54.3 29.3 351 818,756.53
361,000.00














54.3 29.3 352 823,092.25
362,000.00














54.4 29.4 353 827,445.63
363,000.00














54.5 29.5 354 831,816.74
364,000.00














54.6 29.6 355 836,205.67
365,000.00














54.7 29.7 356 840,612.47
366,000.00














54.8 29.8 357 845,037.23
367,000.00














54.8 29.8 358 849,480.02
368,000.00














54.9 29.9 359 853,940.90
369,000.00














55.0 30.0 360 858,419.96
370,000.00














55.1 30.1 361 862,917.27
371,000.00














55.2 30.2 362 867,432.90
372,000.00














55.3 30.3 363 871,966.93
373,000.00














55.3 30.3 364 876,519.44
374,000.00














55.4 30.4 365 881,090.48
375,000.00














55.5 30.5 366 885,680.16
376,000.00














55.6 30.6 367 890,288.53
377,000.00














55.7 30.7 368 894,915.67
378,000.00














55.8 30.8 369 899,561.67
379,000.00














55.8 30.8 370 904,226.59
380,000.00














55.9 30.9 371 908,910.53
381,000.00














56.0 31.0 372 913,613.54
382,000.00














56.1 31.1 373 918,335.71
383,000.00














56.2 31.2 374 923,077.13
384,000.00














56.3 31.3 375 927,837.86
385,000.00














56.3 31.3 376 932,617.98
386,000.00














56.4 31.4 377 937,417.59
387,000.00














56.5 31.5 378 942,236.74
388,000.00














56.6 31.6 379 947,075.53
389,000.00














56.7 31.7 380 951,934.03
390,000.00














56.8 31.8 381 956,812.33
391,000.00














56.8 31.8 382 961,710.50
392,000.00














56.9 31.9 383 966,628.63
393,000.00














57.0 32.0 384 971,566.79
394,000.00














57.1 32.1 385 976,525.08
395,000.00














57.2 32.2 386 981,503.56
396,000.00














57.3 32.3 387 986,502.33
397,000.00














57.3 32.3 388 991,521.46
398,000.00














57.4 32.4 389 996,561.04
399,000.00














57.5 32.5 390 1,001,621.16
400,000.00














57.6 32.6 391 1,006,701.88
401,000.00














57.7 32.7 392 1,011,803.31
402,000.00














57.8 32.8 393 1,016,925.52
403,000.00














57.8 32.8 394 1,022,068.60
404,000.00














57.9 32.9 395 1,027,232.64
405,000.00














58.0 33.0 396 1,032,417.71
406,000.00














58.1 33.1 397 1,037,623.91
407,000.00














58.2 33.2 398 1,042,851.32
408,000.00














58.3 33.3 399 1,048,100.02
409,000.00














58.3 33.3 400 1,053,370.11
410,000.00














58.4 33.4 401 1,058,661.67
411,000.00














58.5 33.5 402 1,063,974.79
412,000.00














58.6 33.6 403 1,069,309.56
413,000.00














58.7 33.7 404 1,074,666.06
414,000.00














58.8 33.8 405 1,080,044.38
415,000.00














58.8 33.8 406 1,085,444.61
416,000.00














58.9 33.9 407 1,090,866.85
417,000.00














59.0 34.0 408 1,096,311.17
418,000.00














59.1 34.1 409 1,101,777.68
419,000.00














59.2 34.2 410 1,107,266.46
420,000.00














59.3 34.3 411 1,112,777.60
421,000.00














59.3 34.3 412 1,118,311.19
422,000.00














59.4 34.4 413 1,123,867.33
423,000.00














59.5 34.5 414 1,129,446.11
424,000.00














59.6 34.6 415 1,135,047.61
425,000.00














59.7 34.7 416 1,140,671.94
426,000.00














59.8 34.8 417 1,146,319.17
427,000.00














59.8 34.8 418 1,151,989.42
428,000.00














59.9 34.9 419 1,157,682.77
429,000.00














60.0 35.0 420 1,163,399.31
430,000.00














60.1 35.1 421 1,169,139.14
431,000.00














60.2 35.2 422 1,174,902.36
432,000.00














60.3 35.3 423 1,180,689.06
433,000.00














60.3 35.3 424 1,186,499.33
434,000.00














60.4 35.4 425 1,192,333.28
435,000.00














60.5 35.5 426 1,198,190.99
436,000.00














60.6 35.6 427 1,204,072.57
437,000.00














60.7 35.7 428 1,209,978.11
438,000.00














60.8 35.8 429 1,215,907.71
439,000.00














60.8 35.8 430 1,221,861.47
440,000.00














60.9 35.9 431 1,227,839.48
441,000.00














61.0 36.0 432 1,233,841.85
442,000.00














61.1 36.1 433 1,239,868.68
443,000.00














61.2 36.2 434 1,245,920.06
444,000.00














61.3 36.3 435 1,251,996.09
445,000.00














61.3 36.3 436 1,258,096.88
446,000.00














61.4 36.4 437 1,264,222.52
447,000.00














61.5 36.5 438 1,270,373.12
448,000.00














61.6 36.6 439 1,276,548.78
449,000.00














61.7 36.7 440 1,282,749.59
450,000.00














61.8 36.8 441 1,288,975.67
451,000.00














61.8 36.8 442 1,295,227.12
452,000.00














61.9 36.9 443 1,301,504.04
453,000.00














62.0 37.0 444 1,307,806.52
454,000.00














62.1 37.1 445 1,314,134.69
455,000.00














62.2 37.2 446 1,320,488.64
456,000.00














62.3 37.3 447 1,326,868.47
457,000.00














62.3 37.3 448 1,333,274.30
458,000.00














62.4 37.4 449 1,339,706.22
459,000.00














62.5 37.5 450 1,346,164.35
460,000.00














62.6 37.6 451 1,352,648.79
461,000.00














62.7 37.7 452 1,359,159.65
462,000.00














62.8 37.8 453 1,365,697.03
463,000.00














62.8 37.8 454 1,372,261.05
464,000.00














62.9 37.9 455 1,378,851.81
465,000.00














63.0 38.0 456 1,385,469.43
466,000.00














63.1 38.1 457 1,392,114.00
467,000.00














63.2 38.2 458 1,398,785.65
468,000.00














63.3 38.3 459 1,405,484.47
469,000.00














63.3 38.3 460 1,412,210.59
470,000.00














63.4 38.4 461 1,418,964.11
471,000.00














63.5 38.5 462 1,425,745.15
472,000.00














63.6 38.6 463 1,432,553.81
473,000.00














63.7 38.7 464 1,439,390.21
474,000.00














63.8 38.8 465 1,446,254.46
475,000.00














63.8 38.8 466 1,453,146.68
476,000.00














63.9 38.9 467 1,460,066.98
477,000.00














64.0 39.0 468 1,467,015.48
478,000.00














64.1 39.1 469 1,473,992.28
479,000.00














64.2 39.2 470 1,480,997.51
480,000.00














64.3 39.3 471 1,488,031.27
481,000.00














64.3 39.3 472 1,495,093.70
482,000.00














64.4 39.4 473 1,502,184.89
483,000.00














64.5 39.5 474 1,509,304.98
484,000.00














64.6 39.6 475 1,516,454.08
485,000.00














64.7 39.7 476 1,523,632.30
486,000.00














64.8 39.8 477 1,530,839.76
487,000.00














64.8 39.8 478 1,538,076.60
488,000.00














64.9 39.9 479 1,545,342.91
489,000.00














65.0 40.0 480 1,552,638.83
490,000.00














65.1 40.1 481 1,559,964.47
491,000.00














65.2 40.2 482 1,567,319.96
492,000.00














65.3 40.3 483 1,574,705.41
493,000.00














65.3 40.3 484 1,582,120.96
494,000.00














65.4 40.4 485 1,589,566.72
495,000.00














65.5 40.5 486 1,597,042.81
496,000.00














65.6 40.6 487 1,604,549.36
497,000.00














65.7 40.7 488 1,612,086.49
498,000.00














65.8 40.8 489 1,619,654.33
499,000.00














65.8 40.8 490 1,627,253.00
500,000.00














65.9 40.9 491 1,634,882.63
501,000.00














66.0 41.0 492 1,642,543.35
502,000.00














66.1 41.1 493 1,650,235.27
503,000.00














66.2 41.2 494 1,657,958.53
504,000.00














66.3 41.3 495 1,665,713.26
505,000.00














66.3 41.3 496 1,673,499.58
506,000.00














66.4 41.4 497 1,681,317.63
507,000.00














66.5 41.5 498 1,689,167.53
508,000.00














66.6 41.6 499 1,697,049.40
509,000.00














66.7 41.7 500 1,704,963.39
510,000.00














66.8 41.8 501 1,712,909.62
511,000.00














66.8 41.8 502 1,720,888.23
512,000.00














66.9 41.9 503 1,728,899.34
513,000.00














67.0 42.0 504 1,736,943.09
514,000.00














67.1 42.1 505 1,745,019.61
515,000.00














67.2 42.2 506 1,753,129.04
516,000.00














67.3 42.3 507 1,761,271.50
517,000.00














67.3 42.3 508 1,769,447.14
518,000.00














67.4 42.4 509 1,777,656.09
519,000.00














67.5 42.5 510 1,785,898.48
520,000.00














67.6 42.6 511 1,794,174.45
521,000.00














67.7 42.7 512 1,802,484.14
522,000.00














67.8 42.8 513 1,810,827.68
523,000.00














67.8 42.8 514 1,819,205.22
524,000.00














67.9 42.9 515 1,827,616.89
525,000.00














68.0 43.0 516 1,836,062.82
526,000.00














68.1 43.1 517 1,844,543.17
527,000.00














68.2 43.2 518 1,853,058.07
528,000.00














68.3 43.3 519 1,861,607.66
529,000.00














68.3 43.3 520 1,870,192.08
530,000.00














68.4 43.4 521 1,878,811.47
531,000.00














68.5 43.5 522 1,887,465.98
532,000.00














68.6 43.6 523 1,896,155.75
533,000.00














68.7 43.7 524 1,904,880.92
534,000.00














68.8 43.8 525 1,913,641.64
535,000.00














68.8 43.8 526 1,922,438.06
536,000.00














68.9 43.9 527 1,931,270.31
537,000.00














69.0 44.0 528 1,940,138.54
538,000.00














69.1 44.1 529 1,949,042.91
539,000.00














69.2 44.2 530 1,957,983.55
540,000.00














69.3 44.3 531 1,966,960.62
541,000.00














69.3 44.3 532 1,975,974.26
542,000.00














69.4 44.4 533 1,985,024.62
543,000.00














69.5 44.5 534 1,994,111.86
544,000.00














69.6 44.6 535 2,003,236.12
545,000.00














69.7 44.7 536 2,012,397.55
546,000.00














69.8 44.8 537 2,021,596.30
547,000.00














69.8 44.8 538 2,030,832.54
548,000.00














69.9 44.9 539 2,040,106.40
549,000.00














70.0 45.0 540 2,049,418.05
550,000.00














70.1 45.1 541 2,058,767.63
551,000.00














70.2 45.2 542 2,068,155.30
552,000.00














70.3 45.3 543 2,077,581.23
553,000.00














70.3 45.3 544 2,087,045.55
554,000.00














70.4 45.4 545 2,096,548.43
555,000.00














70.5 45.5 546 2,106,090.03
556,000.00














70.6 45.6 547 2,115,670.50
557,000.00














70.7 45.7 548 2,125,290.00
558,000.00














70.8 45.8 549 2,134,948.70
559,000.00














70.8 45.8 550 2,144,646.74
560,000.00














70.9 45.9 551 2,154,384.30
561,000.00














71.0 46.0 552 2,164,161.53
562,000.00














71.1 46.1 553 2,173,978.59
563,000.00














71.2 46.2 554 2,183,835.65
564,000.00














71.3 46.3 555 2,193,732.86
565,000.00














71.3 46.3 556 2,203,670.40
566,000.00














71.4 46.4 557 2,213,648.43
567,000.00














71.5 46.5 558 2,223,667.11
568,000.00














71.6 46.6 559 2,233,726.60
569,000.00














71.7 46.7 560 2,243,827.08
570,000.00














71.8 46.8 561 2,253,968.71
571,000.00














71.8 46.8 562 2,264,151.66
572,000.00














71.9 46.9 563 2,274,376.09
573,000.00














72.0 47.0 564 2,284,642.18
574,000.00














72.1 47.1 565 2,294,950.10
575,000.00














72.2 47.2 566 2,305,300.01
576,000.00














72.3 47.3 567 2,315,692.08
577,000.00














72.3 47.3 568 2,326,126.50
578,000.00














72.4 47.4 569 2,336,603.43
579,000.00














72.5 47.5 570 2,347,123.04
580,000.00














72.6 47.6 571 2,357,685.51
581,000.00














72.7 47.7 572 2,368,291.01
582,000.00














72.8 47.8 573 2,378,939.72
583,000.00














72.8 47.8 574 2,389,631.82
584,000.00














72.9 47.9 575 2,400,367.47
585,000.00














73.0 48.0 576 2,411,146.87
586,000.00














73.1 48.1 577 2,421,970.18
587,000.00














73.2 48.2 578 2,432,837.58
588,000.00














73.3 48.3 579 2,443,749.27
589,000.00














73.3 48.3 580 2,454,705.40
590,000.00














73.4 48.4 581 2,465,706.18
591,000.00














73.5 48.5 582 2,476,751.77
592,000.00














73.6 48.6 583 2,487,842.36
593,000.00














73.7 48.7 584 2,498,978.14
594,000.00














73.8 48.8 585 2,510,159.29
595,000.00














73.8 48.8 586 2,521,385.99
596,000.00














73.9 48.9 587 2,532,658.42
597,000.00














74.0 49.0 588 2,543,976.79
598,000.00














74.1 49.1 589 2,555,341.26
599,000.00














74.2 49.2 590 2,566,752.04
600,000.00














74.3 49.3 591 2,578,209.31
601,000.00














74.3 49.3 592 2,589,713.25
602,000.00














74.4 49.4 593 2,601,264.06
603,000.00














74.5 49.5 594 2,612,861.94
604,000.00














74.6 49.6 595 2,624,507.06
605,000.00














74.7 49.7 596 2,636,199.62
606,000.00














74.8 49.8 597 2,647,939.83
607,000.00














74.8 49.8 598 2,659,727.86
608,000.00














74.9 49.9 599 2,671,563.92
609,000.00














75.0 50.0 600 2,683,448.21
610,000.00














75.1 50.1 601 2,695,380.91
611,000.00














75.2 50.2 602 2,707,362.22
612,000.00














75.3 50.3 603 2,719,392.35
613,000.00














75.3 50.3 604 2,731,471.49
614,000.00














75.4 50.4 605 2,743,599.84
615,000.00














75.5 50.5 606 2,755,777.61
616,000.00














75.6 50.6 607 2,768,004.99
617,000.00














75.7 50.7 608 2,780,282.18
618,000.00














75.8 50.8 609 2,792,609.40
619,000.00














75.8 50.8 610 2,804,986.83
620,000.00














75.9 50.9 611 2,817,414.70
621,000.00














76.0 51.0 612 2,829,893.19
622,000.00














76.1 51.1 613 2,842,422.53
623,000.00














76.2 51.2 614 2,855,002.91
624,000.00














76.3 51.3 615 2,867,634.55
625,000.00














76.3 51.3 616 2,880,317.64
626,000.00














76.4 51.4 617 2,893,052.41
627,000.00














76.5 51.5 618 2,905,839.07
628,000.00














76.6 51.6 619 2,918,677.82
629,000.00














76.7 51.7 620 2,931,568.87
630,000.00














76.8 51.8 621 2,944,512.44
631,000.00














76.8 51.8 622 2,957,508.75
632,000.00














76.9 51.9 623 2,970,558.01
633,000.00














77.0 52.0 624 2,983,660.43
634,000.00














77.1 52.1 625 2,996,816.23
635,000.00














77.2 52.2 626 3,010,025.63
636,000.00














77.3 52.3 627 3,023,288.85
637,000.00














77.3 52.3 628 3,036,606.10
638,000.00














77.4 52.4 629 3,049,977.61
639,000.00














77.5 52.5 630 3,063,403.60
640,000.00














77.6 52.6 631 3,076,884.28
641,000.00














77.7 52.7 632 3,090,419.89
642,000.00














77.8 52.8 633 3,104,010.64
643,000.00














77.8 52.8 634 3,117,656.77
644,000.00














77.9 52.9 635 3,131,358.49
645,000.00














78.0 53.0 636 3,145,116.03
646,000.00














78.1 53.1 637 3,158,929.62
647,000.00














78.2 53.2 638 3,172,799.49
648,000.00














78.3 53.3 639 3,186,725.87
649,000.00














78.3 53.3 640 3,200,708.99
650,000.00














78.4 53.4 641 3,214,749.07
651,000.00














78.5 53.5 642 3,228,846.36
652,000.00














78.6 53.6 643 3,243,001.08
653,000.00














78.7 53.7 644 3,257,213.46
654,000.00














78.8 53.8 645 3,271,483.75
655,000.00














78.8 53.8 646 3,285,812.18
656,000.00














78.9 53.9 647 3,300,198.99
657,000.00














79.0 54.0 648 3,314,644.41
658,000.00














79.1 54.1 649 3,329,148.68
659,000.00














79.2 54.2 650 3,343,712.04
660,000.00














79.3 54.3 651 3,358,334.74
661,000.00














79.3 54.3 652 3,373,017.01
662,000.00














79.4 54.4 653 3,387,759.10
663,000.00














79.5 54.5 654 3,402,561.25
664,000.00














79.6 54.6 655 3,417,423.71
665,000.00














79.7 54.7 656 3,432,346.71
666,000.00














79.8 54.8 657 3,447,330.52
667,000.00














79.8 54.8 658 3,462,375.37
668,000.00














79.9 54.9 659 3,477,481.52
669,000.00














80.0 55.0 660 3,492,649.21
670,000.00














80.1 55.1 661 3,507,878.69
671,000.00














80.2 55.2 662 3,523,170.22
672,000.00














80.3 55.3 663 3,538,524.06
673,000.00














80.3 55.3 664 3,553,940.44
674,000.00














80.4 55.4 665 3,569,419.63
675,000.00














80.5 55.5 666 3,584,961.89
676,000.00














80.6 55.6 667 3,600,567.47
677,000.00














80.7 55.7 668 3,616,236.63
678,000.00














80.8 55.8 669 3,631,969.62
679,000.00














80.8 55.8 670 3,647,766.72
680,000.00














80.9 55.9 671 3,663,628.17
681,000.00














81.0 56.0 672 3,679,554.24
682,000.00














81.1 56.1 673 3,695,545.20
683,000.00














81.2 56.2 674 3,711,601.31
684,000.00














81.3 56.3 675 3,727,722.84
685,000.00














81.3 56.3 676 3,743,910.04
686,000.00














81.4 56.4 677 3,760,163.19
687,000.00














81.5 56.5 678 3,776,482.56
688,000.00














81.6 56.6 679 3,792,868.42
689,000.00














81.7 56.7 680 3,809,321.04
690,000.00














81.8 56.8 681 3,825,840.68
691,000.00














81.8 56.8 682 3,842,427.63
692,000.00














81.9 56.9 683 3,859,082.16
693,000.00














82.0 57.0 684 3,875,804.53
694,000.00














82.1 57.1 685 3,892,595.04
695,000.00














82.2 57.2 686 3,909,453.96
696,000.00














82.3 57.3 687 3,926,381.56
697,000.00














82.3 57.3 688 3,943,378.12
698,000.00














82.4 57.4 689 3,960,443.93
699,000.00














82.5 57.5 690 3,977,579.27
700,000.00














82.6 57.6 691 3,994,784.42
701,000.00














82.7 57.7 692 4,012,059.67
702,000.00














82.8 57.8 693 4,029,405.29
703,000.00














82.8 57.8 694 4,046,821.59
704,000.00














82.9 57.9 695 4,064,308.84
705,000.00














83.0 58.0 696 4,081,867.34
706,000.00














83.1 58.1 697 4,099,497.37
707,000.00














83.2 58.2 698 4,117,199.23
708,000.00














83.3 58.3 699 4,134,973.21
709,000.00














83.3 58.3 700 4,152,819.60
710,000.00














83.4 58.4 701 4,170,738.70
711,000.00














83.5 58.5 702 4,188,730.81
712,000.00














83.6 58.6 703 4,206,796.22
713,000.00














83.7 58.7 704 4,224,935.23
714,000.00














83.8 58.8 705 4,243,148.14
715,000.00














83.8 58.8 706 4,261,435.25
716,000.00














83.9 58.9 707 4,279,796.86
717,000.00














84.0 59.0 708 4,298,233.28
718,000.00














84.1 59.1 709 4,316,744.82
719,000.00














84.2 59.2 710 4,335,331.77
720,000.00














84.3 59.3 711 4,353,994.45
721,000.00














84.3 59.3 712 4,372,733.16
722,000.00














84.4 59.4 713 4,391,548.22
723,000.00














84.5 59.5 714 4,410,439.93
724,000.00














84.6 59.6 715 4,429,408.61
725,000.00














84.7 59.7 716 4,448,454.57
726,000.00














84.8 59.8 717 4,467,578.12
727,000.00














84.8 59.8 718 4,486,779.59
728,000.00














84.9 59.9 719 4,506,059.28
729,000.00














85.0 60.0 720 4,525,417.52
730,000.00















The words contained in this file might help you see if this file matches what you are looking for:

...Sheet guidance notes the humble penny financial joy academy hey hope you enjoy using this custom built compound interest calculator cells to change ie inputs are yellow ones on column e only can then see results outputs from row onwards i have also included some scenario analysis and graphs ken okoroafor example choose currency pound amp age start investing investment period years compounded annual growth rate monthly these percentages manually simply by typing in figures want euro assumed return time x total pot of money after if compounding not holding cash possible wealth gained over year month starting potlump sum no add a figure here re with lump...

no reviews yet
Please Login to review.