ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
***INSTRUCTIONS****
2
3
This file is read-only. Go up to the File Menu and select "Make A Copy". You will then save a version to your own Google Drive where you can edit for your own use.
4
5
There are eight columns in this calculator, hopefully they're pretty self-explantory:
6
Year:Once you enter the current year in the variables section, the rest will fill out automatically for you.
7
Projected Balance:This will take your current balance at the start of the year, and take into account contributions and rate of return
8
Contribution Amount:This will autopopulate to your current amount, from the variables below. You can override the forumlas, if you anticipate different amounts in the future. For example, if you're contirbuting the max to your 401(k) now, but plan on making additional make up contributions when you're 50+, simply make that adjustment.
9
Year End Balance:Enter your balance at the end of each year. This will recalculate the projected balance as you go along. You'll have realtime info on your pace based on under or over-performance in the past year.
10
YoY Change:The realized percentage increase from the prior year.
11
% To Goal:Track your point along the path to your desired goal.
12
13
Optional:
14
Original Projections:Once you've entered the variables, you can copy the values from the Projected Balance column into this column. This will allow you to track your progress over the years against your original estimations. These will change and fluctuate from year to year, so you might find this of interest.
15
To do this, hightlight all the cells, right click, select "Copy". Highlight cell H2, right click, select "Paste -> Paste Special -> Paste Values Only
16
 +/- OriginalA comparison between where you are and where you originally projjected you'd be.
17
18
19
***VARIABLES****
20
21
Enter in these amounts based on your real numbers. You can play with the rate of return based on your own portfolio allocation. You can also change this to see how a bull or bear market might affect your numbers
22
23
Current Year:2018
24
Portfolios Balance at start this year:$0.00
25
Current Contribution Amount:$18,500.00
26
Estimated Rate of Return6.00%
27
28
Savings Goal:$1,000,000.00
29
30
31
***TIDBITS****
32
33
There are plenty of retirement calculators out there, but I wanted something that where I could both see the future and chart my real progress. I want to see where I'm going and where I've been.
34
35
Should you find this useful and want to share it with others, I would appreciate you sharing the tools page on the web site, to ensure someone is getting the most up to date version
36
37
38
39
40
41
42
43
44
45
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