IC-Google-Spreadsheet-Retirement-Savings-Calculator-Template

	B	C	D	E	F	G	H	I
1
2	RETIREMENT SAVINGS CALCULATOR						https://goo.gl/1c9dsQ
3
4	INITIAL AGE			INITIAL INVESTMENT $		YEARLY PRE-RETIREMENT INVESTMENT $		YEARLY PRE-RETIREMENT RETURN %
5	28			$ 30,000.00		$ 9,500.00		6.50%
6	RETIREMENT AGE			YEARLY RETIREMENT WITHDRAWAL $ ( negative # )		YEARLY RETIREMENT RETURN %		YEARLY RETIREMENT INFLATION %
7	63			$ (30,000.00)		6.00%		2.50%
8
9		YEAR	AGE	ACCOUNT VALUE	% OF RETURN	INVESTMENT	% OF RTRMNT INFLATION	RETIREMENT WITHDRAWAL
10
11		1	28	$ 30,000.00	6.50%	$ 9,500.00	0.00%	$ -
12		2	29	$ 41,450.00	6.50%	$ 9,500.00	0.00%	$ -
13		3	30	$ 53,644.25	6.50%	$ 9,500.00	0.00%	$ -
14		4	31	$ 66,631.13	6.50%	$ 9,500.00	0.00%	$ -
15		5	32	$ 80,462.15	6.50%	$ 9,500.00	0.00%	$ -
16		6	33	$ 95,192.19	6.50%	$ 9,500.00	0.00%	$ -
17		7	34	$ 110,879.68	6.50%	$ 9,500.00	0.00%	$ -
18		8	35	$ 127,586.86	6.50%	$ 9,500.00	0.00%	$ -
19		9	36	$ 145,380.01	6.50%	$ 9,500.00	0.00%	$ -
20		10	37	$ 164,329.71	6.50%	$ 9,500.00	0.00%	$ -
21		11	38	$ 184,511.14	6.50%	$ 9,500.00	0.00%	$ -
22		12	39	$ 206,004.36	6.50%	$ 9,500.00	0.00%	$ -
23		13	40	$ 228,894.65	6.50%	$ 9,500.00	0.00%	$ -
24		14	41	$ 253,272.80	6.50%	$ 9,500.00	0.00%	$ -
25		15	42	$ 279,235.53	6.50%	$ 9,500.00	0.00%	$ -
26		16	43	$ 306,885.84	6.50%	$ 9,500.00	0.00%	$ -
27		17	44	$ 336,333.42	6.50%	$ 9,500.00	0.00%	$ -
28		18	45	$ 367,695.09	6.50%	$ 9,500.00	0.00%	$ -
29		19	46	$ 401,095.27	6.50%	$ 9,500.00	0.00%	$ -
30		20	47	$ 436,666.46	6.50%	$ 9,500.00	0.00%	$ -
31		21	48	$ 474,549.78	6.50%	$ 9,500.00	0.00%	$ -
32		22	49	$ 514,895.52	6.50%	$ 9,500.00	0.00%	$ -
33		23	50	$ 557,863.73	6.50%	$ 9,500.00	0.00%	$ -
34		24	51	$ 603,624.87	6.50%	$ 9,500.00	0.00%	$ -
35		25	52	$ 652,360.49	6.50%	$ 9,500.00	0.00%	$ -
36		26	53	$ 704,263.92	6.50%	$ 9,500.00	0.00%	$ -
37		27	54	$ 759,541.07	6.50%	$ 9,500.00	0.00%	$ -
38		28	55	$ 818,411.24	6.50%	$ 9,500.00	0.00%	$ -
39		29	56	$ 881,107.98	6.50%	$ 9,500.00	0.00%	$ -
40		30	57	$ 947,879.99	6.50%	$ 9,500.00	0.00%	$ -
41		31	58	$ 1,018,992.19	6.50%	$ 9,500.00	0.00%	$ -
42		32	59	$ 1,094,726.69	6.50%	$ 9,500.00	0.00%	$ -
43		33	60	$ 1,175,383.92	6.50%	$ 9,500.00	0.00%	$ -
44		34	61	$ 1,261,283.88	6.50%	$ 9,500.00	0.00%	$ -
45		35	62	$ 1,352,767.33	6.50%	$ 9,500.00	0.00%	$ -
46		36	63	$ 1,403,933.37	6.00%	$ -	2.50%	$ (30,000.00)
47		37	64	$ 1,457,419.37	6.00%	$ -	2.50%	$ (30,750.00)
48		38	65	$ 1,513,345.78	6.00%	$ -	2.50%	$ (31,518.75)
49		39	66	$ 1,571,839.81	6.00%	$ -	2.50%	$ (32,306.72)
50		40	67	$ 1,633,035.81	6.00%	$ -	2.50%	$ (33,114.39)
51		41	68	$ 1,697,075.71	6.00%	$ -	2.50%	$ (33,942.25)
52		42	69	$ 1,764,109.45	6.00%	$ -	2.50%	$ (34,790.80)
53		43	70	$ 1,834,295.45	6.00%	$ -	2.50%	$ (35,660.57)
54		44	71	$ 1,907,801.09	6.00%	$ -	2.50%	$ (36,552.09)
55		45	72	$ 1,984,803.26	6.00%	$ -	2.50%	$ (37,465.89)
56		46	73	$ 2,065,488.92	6.00%	$ -	2.50%	$ (38,402.54)
57		47	74	$ 2,150,055.66	6.00%	$ -	2.50%	$ (39,362.60)
58		48	75	$ 2,238,712.33	6.00%	$ -	2.50%	$ (40,346.66)
59		49	76	$ 2,331,679.74	6.00%	$ -	2.50%	$ (41,355.33)
60		50	77	$ 2,429,191.31	6.00%	$ -	2.50%	$ (42,389.21)
61		51	78	$ 2,531,493.85	6.00%	$ -	2.50%	$ (43,448.94)
62		52	79	$ 2,638,848.31	6.00%	$ -	2.50%	$ (44,535.17)
63		53	80	$ 2,751,530.66	6.00%	$ -	2.50%	$ (45,648.55)
64		54	81	$ 2,869,832.74	6.00%	$ -	2.50%	$ (46,789.76)
65		55	82	$ 2,994,063.20	6.00%	$ -	2.50%	$ (47,959.51)
66		56	83	$ 3,124,548.49	6.00%	$ -	2.50%	$ (49,158.49)
67		57	84	$ 3,261,633.95	6.00%	$ -	2.50%	$ (50,387.46)
68		58	85	$ 3,405,684.84	6.00%	$ -	2.50%	$ (51,647.14)
69		59	86	$ 3,557,087.61	6.00%	$ -	2.50%	$ (52,938.32)
70		60	87	$ 3,716,251.09	6.00%	$ -	2.50%	$ (54,261.78)
71
72
73	CLICK HERE TO CREATE RETIREMENT SAVINGS CALCULATOR BUDGET TEMPLATES IN SMARTSHEET