Investment scenario

	A	B	C	D	E	F	G
1	Year	Income	% saved	Investment contributions	Years available to compound	Average investment return	Total earnings over life of account (inc principal)
2	1950	$10,400.00	30%	$3,120.00	67	7%	$290,313.81
3	1951	$10,400.00	30%	$3,120.00	66	7%	$271,321.32
4	1952	$10,400.00	30%	$3,120.00	65	7%	$253,571.33
5	1953	$10,400.00	30%	$3,120.00	64	7%	$236,982.55
6	1954	$10,400.00	30%	$3,120.00	63	7%	$221,479.02
7	1955	$10,400.00	30%	$3,120.00	62	7%	$206,989.74
8	1956	$10,400.00	30%	$3,120.00	61	7%	$193,448.35
9	1957	$10,400.00	30%	$3,120.00	60	7%	$180,792.85
10	1958	$10,400.00	30%	$3,120.00	59	7%	$168,965.28
11	1959	$10,400.00	30%	$3,120.00	58	7%	$157,911.48
12	1960	$10,400.00	30%	$3,120.00	57	7%	$147,580.82
13	1961	$10,400.00	30%	$3,120.00	56	7%	$137,926.00
14	1962	$10,400.00	30%	$3,120.00	55	7%	$128,902.80
15	1963	$10,400.00	30%	$3,120.00	54	7%	$120,469.91
16	1964	$10,400.00	30%	$3,120.00	53	7%	$112,588.70
17	1965	$10,400.00	30%	$3,120.00	52	7%	$105,223.09
18	1966	$10,400.00	30%	$3,120.00	51	7%	$98,339.33
19	1967	$10,400.00	30%	$3,120.00	50	7%	$91,905.92
20	1968	$10,400.00	30%	$3,120.00	49	7%	$85,893.38
21	1969	$10,400.00	30%	$3,120.00	48	7%	$80,274.19
22	1970	$10,816.00	30%	$3,244.80	47	7%	$78,023.51
23	1971	$11,248.64	30%	$3,374.59	46	7%	$75,835.94
24	1972	$11,698.59	30%	$3,509.58	45	7%	$73,709.69
25	1973	$12,166.53	30%	$3,649.96	44	7%	$71,643.07
26	1974	$12,653.19	30%	$3,795.96	43	7%	$69,634.38
27	1975	$13,159.32	30%	$3,947.80	42	7%	$67,682.02
28	1976	$13,685.69	30%	$4,105.71	41	7%	$65,784.39
29	1977	$14,233.12	30%	$4,269.94	40	7%	$63,939.97
30	1978	$14,802.44	30%	$4,440.73	39	7%	$62,147.26
31	1979	$15,394.54	30%	$4,618.36	38	7%	$60,404.81
32	1980	$16,010.32	30%	$4,803.10	37	7%	$58,711.22
33	1981	$16,650.74	30%	$4,995.22	36	7%	$57,065.11
34	1982	$17,316.76	30%	$5,195.03	35	7%	$55,465.15
35	1983	$18,009.44	30%	$5,402.83	34	7%	$53,910.06
36	1984	$18,729.81	30%	$5,618.94	33	7%	$52,398.56
37	1985	$19,479.00	30%	$5,843.70	32	7%	$50,929.44
38	1986	$20,258.17	30%	$6,077.45	31	7%	$49,501.51
39	1987	$21,068.49	30%	$6,320.55	30	7%	$48,113.62
40	1988	$21,911.23	30%	$6,573.37	29	7%	$46,764.64
41	1989	$22,787.68	30%	$6,836.30	28	7%	$45,453.48
42	1990	$23,699.19	30%	$7,109.76	27	7%	$44,179.08
43	1991	$24,647.16	30%	$7,394.15	26	7%	$42,940.42
44	1992	$25,633.04	30%	$7,689.91	25	7%	$41,736.48
45	1993	$26,658.36	30%	$7,997.51	24	7%	$40,566.30
46	1994	$27,724.70	30%	$8,317.41	23	7%	$39,428.93
47	1995	$28,833.69	30%	$8,650.11	22	7%	$38,323.44
48	1996	$29,987.03	30%	$8,996.11	21	7%	$37,248.95
49	1997	$31,186.51	30%	$9,355.95	20	7%	$36,204.59
50	1998	$32,433.98	30%	$9,730.19	19	7%	$35,189.51
51	1999	$33,731.33	30%	$10,119.40	18	7%	$34,202.89
52	2000	$35,080.59	30%	$10,524.18	17	7%	$33,243.93
53	2001	$36,483.81	30%	$10,945.14	16	7%	$32,311.86
54	2002	$37,943.16	30%	$11,382.95	15	7%	$31,405.92
55	2003	$39,460.89	30%	$11,838.27	14	7%	$30,525.38
56	2004	$41,039.33	30%	$12,311.80	13	7%	$29,669.52
57	2005	$42,680.90	30%	$12,804.27	12	7%	$28,837.67
58	2006	$44,388.13	30%	$13,316.44	11	7%	$28,029.14
59	2007	$46,163.66	30%	$13,849.10	10	7%	$27,243.27
60	2008	$48,010.21	30%	$14,403.06	9	7%	$26,479.44
61	2009	$49,930.61	30%	$14,979.18	8	7%	$25,737.03
62	2010	$51,927.84	30%	$15,578.35	7	7%	$25,015.43
63	2011	$54,004.95	30%	$16,201.49	6	7%	$24,314.06
64	2012	$56,165.15	30%	$16,849.55	5	7%	$23,632.36
65	2013	$58,411.76	30%	$17,523.53	4	7%	$22,969.77
66	2014	$60,748.23	30%	$18,224.47	3	7%	$22,325.76
67	2015	$63,178.16	30%	$18,953.45	2	7%	$21,699.80
68	2016	$65,705.28	30%	$19,711.58	1	7%	$21,091.40
69	2017	$68,333.49	30%	$20,500.05	0	7%	$20,500.05
70
71
72	Total contributed			$514,281.25
73	Investment balance at end of account			$5,363,050.06
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