| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Retirement Secrets - Future Value Estimator | |||||||||||||||
2 | ||||||||||||||||
3 | ||||||||||||||||
4 | Example 1 | Your Example | ||||||||||||||
5 | An individual spends about $50k per year currently, and they'd like to replace this amount in retirement. How much will they need to save to do that? | Fill in your own details below to estimate what you'll need to save for retirement. | ||||||||||||||
6 | ||||||||||||||||
7 | Summary Data | Summary Data | ||||||||||||||
8 | Desired Retirement Spending | $60,000 | This is how much you want to spend. | Desired Retirement Spending | $120,000 | This is how much you want to spend annually. | ||||||||||
9 | ||||||||||||||||
10 | Low | Medium | High | Low | Medium | High | ||||||||||
11 | Retirement Range | 80% | 100% | 120% | This is a range of certainty around the above number. | Retirement Range | 80% | 100% | 120% | This is a range of certainty around the above number. | ||||||
12 | Retirement Need | $48,000 | $60,000 | $72,000 | Retirement Need | $96,000 | $120,000 | $144,000 | ||||||||
13 | ||||||||||||||||
14 | Sources of Funding | Sources of Funding | ||||||||||||||
15 | Low | Medium | High | Low | Medium | High | ||||||||||
16 | Social Security Estimate | $6,000 | $8,000 | $10,000 | This is what you think your Social Security distribution will be. Not sure? Check out mySSA.gov. | Social Security Estimate | $30,000 | $42,000 | $30,000 | This is what you think your Social Security distribution will be annually. Not sure? Check out mySSA.gov. | ||||||
17 | Annual Earnings | $0 | $0 | $0 | This is what you might earn from your creativity in retirement (net of expenses). | Annual Earnings | $0 | $0 | $0 | This is what you might earn from your creativity in retirement (net of expenses) annually. | ||||||
18 | Other Earnings | $0 | $0 | $0 | Any other income you may have (e.g., pension) | Other Earnings | $66,000 | $66,000 | $66,000 | This is for any other income you may have (e.g., pension) annually. | ||||||
19 | Retirement Distribution | $54,000 | $67,000 | $80,000 | This is the gap your retirement account will need to fill. | Retirement Distribution | $32,000 | $52,000 | $96,000 | This is the gap your retirement account will need to fill. | ||||||
20 | Total Funding | $60,000 | $75,000 | $90,000 | Total Funding | $128,000 | $160,000 | $192,000 | ||||||||
21 | Less: Tax Estimate | -20.0% | -20.0% | -20.0% | Less: Tax Estimate | -25.0% | -25.0% | -25.0% | ||||||||
22 | Total Net Funding | $48,000 | $60,000 | $72,000 | This is what you'll end up with (after a rough tax estimate). | Total Net Funding | $96,000 | $120,000 | $144,000 | This is what you'll end up with (after a rough tax estimate). | ||||||
23 | ||||||||||||||||
24 | Distribution Rate | 4.0% | 4.0% | 4.0% | This is how much you'll spend from your retirement account each year. | Distribution Rate | 4.0% | 4.0% | 4.0% | This is how much you'll spend from your retirement account each year. | ||||||
25 | ||||||||||||||||
26 | Retirement Balance Needed | $1,350,000 | $1,675,000 | $2,000,000 | This is what you'll need your retirement account balance to be (ish). | Retirement Balance Needed | $800,000 | $1,300,000 | $2,400,000 | This is what you'll need your retirement account balance to be (ish). | ||||||
27 | ||||||||||||||||
28 | ||||||||||||||||
29 | ||||||||||||||||
30 | ||||||||||||||||
31 | ||||||||||||||||
32 | ||||||||||||||||
33 | ||||||||||||||||
34 | ||||||||||||||||
35 | ||||||||||||||||
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 | ||||||||||||||||