How much do I need to save (2)

	A	B	C	D
1	To use this you need to make copy or download it: File > Make a copy or File > Download Make sure to use the additional tabs for reference
2
3
4	Current Value	Target Value	Yrs to Retirement	Real Return
5	£0	£322,000	35	4%
6
7		Required Monthly Investment
8	Target Value	Target - 5 years	Target Date	Target + 5 years
9	£257,600	£383	£291	£226
10	£289,800	£431	£328	£254
11	£322,000	£478	£364	£282
12	£354,200	£526	£401	£311
13	£386,400	£574	£437	£339
14
15		Required Yearly Investment
16	Target Value	Target - 5 years	Target Date	Target + 5 years
17	£257,600	£4,593	£3,498	£2,711
18	£289,800	£5,167	£3,935	£3,050
19	£322,000	£5,741	£4,372	£3,389
20	£354,200	£6,315	£4,809	£3,727
21	£386,400	£6,890	£5,246	£4,066
22
23			Total Contributions
24		Target - 5 years	Target Date	Target + 5 years
25	£257,600	£137,791	£122,413	£108,434
26	£289,800	£155,015	£137,715	£121,988
27	£322,000	£172,239	£153,016	£135,543
28	£354,200	£189,463	£168,318	£149,097
29	£386,400	£206,687	£183,620	£162,651
30
31			Total Real Investment Growth
32	Target Value	Target - 5 years	Target Date	Target + 5 years
33	£257,600	£119,809	£135,187	£149,166
34	£289,800	£134,785	£152,085	£167,812
35	£322,000	£149,761	£168,984	£186,457
36	£354,200	£164,737	£185,882	£205,103
37	£386,400	£179,713	£202,780	£223,749
38
39			Investment Growth as % of final value
40	Target Value	Target - 5 years	Target Date	Target + 5 years
41	£257,600	37.21%	41.98%	46.32%
42	£289,800	41.86%	47.23%	52.12%
43	£322,000	46.51%	52.48%	57.91%
44	£354,200	51.16%	57.73%	63.70%
45	£386,400	55.81%	62.98%	69.49%
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