RE402 Retirement Account Growth.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Retirement Savings Calculation
2
3
INPUTSINSTRUCTIONS
4
Current Value of Investments
0.00 Enter data in yellow highlighted cells only.
This spreadsheet assumes end of year contributions.
First, enter contributions until the expected retirement age. Then add in distributions starting at retirement age (based on the previous class calculation RE401). Retirement distributions should increase with inflation.
5
Expected Annual Return
7.00%
6
Current Age
30
7
Expected Retirement Age
65
8
Today's Date
1/1/2017
9
10
AgeYearBeginning
Balance
Annual ContributionAnnual Withdrawal
Annual Rate
Gain/LossEnding
Balance
Cumulative ContributionsCumulative
Gain/Loss
11
30 2017 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
12
31 2018 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
13
32 2019 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
14
33 2020 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
15
34 2020 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
16
35 2021 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
17
36 2022 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
18
37 2023 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
19
38 2024 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
20
39 2025 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
21
40 2026 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
22
41 2027 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
23
42 2028 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
24
43 2029 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
25
44 2030 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
26
45 2031 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
27
46 2032 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
28
47 2033 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
29
48 2034 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
30
49 2035 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
31
50 2036 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
32
51 2037 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
33
52 2038 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
34
53 2039 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
35
54 2040 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
36
55 2041 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
37
56 2042 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
38
57 2043 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
39
58 2044 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
40
59 2045 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
41
60 2046 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
42
61 2047 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
43
62 2048 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
44
63 2049 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
45
64 2050 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
46
65 2051 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
47
66 2052 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
48
67 2053 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
49
68 2054 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
50
69 2055 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
51
70 2056 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
52
71 2057 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
53
72 2058 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
54
73 2059 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
55
74 2060 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
56
75 2061 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
57
76 2062 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
58
77 2063 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
59
78 2064 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
60
79 2065 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
61
80 2066 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
62
81 2067 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
63
82 2068 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
64
83 2069 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
65
84 2070 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
66
85 2071 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
67
86 2072 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
68
87 2073 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
69
88 2074 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
70
89 2075 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
71
90 2076 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
72
91 2077 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
73
92 2078 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
74
93 2079 0.00 0.00 0.00 7.00% 0.00 0.00 0.00 0.00
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
Loading...