Quantcast

Retirement Planning Worksheet: How Much Do You Need to Save for Retirement?

Advertisement

Survey Says

Advertisement

If we had a nickel for every person over the last 30 years who asked us “How much do I need to save for retirement?” we could finance the next government bailout program ourselves!

Knowing the right answer to this question is the basis for all of your retirement planning. Knowing the right answer can mean the difference between a retirement spent fretting about money while you just get by versus a worry-free retirement that lets you enjoy your golden years.

Yet, a whopping 44% of Baby Boomers born between 1955 and 1964 don’t know how much they need to save in order to maintain their standard of living in retirement. And only 42% of workers have even tried to figure out how much they need to save for retirement, according to the Retirement Confidence Survey!

So, today we want to help you figure out the answer to this critical question with our Retirement Planning Worksheet. It will walk you step by step through figuring out how much you need to save!

Click here to download Retirement Worksheet as pdf so you can print it out.

Step One: Total Income You'll Require in Retirement
a. $______ Income needed annually in retirement (current income)
b. _______ Growth Multiplier (where number of years until retirement intersects with 4% in Table 1)
c. $______ Inflation-adjusted income (1a x 1b)
d. _______ Future Value Multiplier (where life expectancy in retirement intersects with 4% in Table 2)
e. $______ Total amount of income needed in retirement (1c x 1d)
   
Step Two: Total Amount You Expect to Collect From Social Security
a. $______ Amount expected from S.S. from form SSA-7004
b. $______ Inflation-adjusted S.S. benefits (2a x 1b)
c. $______ Future value of S.S. benefits, adjusted for inflation,
during retirement (2b x 1d)
   
Step Three: Total Amount You Expect to Collect From Pension
a. $______ Amount expected from pension (current salary ÷ 3)
b. $______ Inflation-adjusted value of pension (3a x 1b)
c. $______ Total value of pension benefits, adjusted for inflation,
during retirement (3b x 1d)
   
Step Four: Income You Need to Generate
a. $______ Total future value of S.S. and pension benefits (2c + 3c)
b. $______ Total income needed during retirement in addition to S.S. and pension benefits (1e - 4a = income shortfall)
c. _______ Savings Factor (where life expectancy in retirement
intersects with savings factor in Table 3)
d. $______ Money needed to meet shortfall (4b x 4c)
   
Step Five: Savings Portfolio vs. Income
a. $______ Current Savings
b. _______ Portfolio Multiplier(where number of years until retirement intersects with 8% in Table 1)
c. $______ Expected value of portfolio at retirement (5a x 5b)
d. $______ Additional savings needed before retirement (4d - 5c)
   
Step Six: Amount You Need to Save each Year for Retirement
a. _______ Future Value Multiplier (where number of years until retirement intersects with 8% in Table 2)
b. $______ Amount you need to save each year before retirement (5d ÷ 6a)
   
Click here to download Retirement Worksheet as pdf so you can print it out.
 
Table 1
Growth Table

What $1 will grow to, at various interest (or inflation) rates


Year
4%
8%
1
1.04
1.08
2
1.08
1.17
3
1.12
1.26
4
1.17
1.36
5
1.22
1.47
10
1.48
2.16
15
1.80
3.17
20
2.19
4.66
25
2.66
6.85
30
3.24
10.05
35
3.94
14.76
Table 2
Future Value Table

What $1 received or invested at the end of the year will gro to, at various interest (or inflation) rates

Year
4%
8%
1
1.00
1.00
2
2.04
2.08
3
3.12
3.25
4
4.25
4.51
5
5.42
5.87
10
12.01
14.49
15
20.02
27.15
20
29.78
45.76
25
41.64
73.10
30
56.04
113.15
35
73.44
171.20
Table 3
Savings Factor Table

For each $1 you'll need in retirement, here's the amount you should raise before you retire

Life expectancy
at retirement
Savings
Factor
25
.43
20
.49
15
.57
10
.67
5
.80

Discussion:    Add a Comment | Comments 1-7 of 7 | Latest Comment

December 30, 2009 12:03 PM

Just wondering why in Step 2a above that you parenthetically add that the maximum Social Security benefit for couples is currently $20,304. I personally am receiving my full SS benefit of $27,156 (age 66) and my wife will receive another $19,000 when she retires next year.

View unverified member's comment - posted by Mr Brant

December 30, 2009 1:30 PM

Thank you for the advice.

January 2, 2010 10:17 AM

what is the assumption regarding assets remaining at the
end of whatever

January 3, 2010 12:14 PM

Shouldn't you use net income ? That is what you actually live on. When retired you no longer pay into SS, retirement plans etc. My wife and I make $125,000. Take home for the year is $67K. We put alot into retirement savings and health care accts. SS and other Fed taxes also come out. So wouldn't we need $67K - $54K based on new information ? It seems like all planners go off of gross pay. Does this pad their pockets with commissions ?

January 3, 2010 5:46 PM

My wife and I retired at the end of 1997. Our last gross earnings in 1997 were approx. $125,000. At that time we were paying $15,000/yr home mortgage; approximately $21,000/yr 401K and taxable mutual fund purchases; $12,500/yr.(10%)charitable contributions; $3000/yr medical insurance; $4000/yr real estate taxes, plus social security and medicare taxes. On retirement, we paid off our mortgage; no longer make regular 401K and mutual fund purchases; reduced real estate taxes to $1200/yr with age 65 yr tax exemptions; rely on medicare advantage plans for our health insurance; and corresponding reduction in charitable contributions. Instead of contributing to our retirement funds,we are now withdrawing from our retirement funds.

12 years later we live at the same level we experienced in 1997 on a before-tax income of approximately $65,000 vs. then $125,000. We supplement our social security and pension income with IRA mutual fund withdrawals based on approximately 7% of our liquid assets values (mutual fund and bank accounts). We have no debt. We travel to Europe almost every year. (Our mutual fund investments for 2009 returned almost 42% since lows of mid-March) We just bought a new 2010 Equinox, financing $12,000 for 3 years at 4.3%.

Have we missed something? We certainly do not need 70-80% of before retirement income to support our current life style.

View unverified member's comment - posted by mik

Discussion:    Add a Comment | Back to Top | Comments 1-7 of 7 | Latest Comment

Add Your Reply

(will not be displayed)

Email me when comments are added to this thread

 
 

Please log in or register to participate in this community!

Log In

Remember

Not a member? Sign up!

Did you forget your password?

close this window
close this window