YOU ARE HERE: LAT HomeCollectionsEducation

# College Fund Work Sheet

May 07, 2000

Will you have enough saved?

1. Estimate the amount your child will need for college: ______________.

2. Determine how many years you have to reach that goal. (If your child is 7,

you have about 10 years; if he's 2, you have 15.): ______________.

3. The value of your current college savings: \$______________.

4. Use the multiplier in Chart 1 to determine the future value of your savings. To use the chart, pick the multiplier in the box that is closest to the number of years you have to your goal and the investment return you expect to earn on your money. (The closer the goal, the more conservative you ought to be with your savings--which means you should also expect to earn lower returns on your money.)

\$______________(current savings) x ___________(multiplier) = \$__________________(future value of your college account).

5. Compare the result from line 4 with the amount you figured you would need in line 1. If line 4 is greater than line 1, you are in good shape and likely to meet your savings goal. If it's less, you'll need to save more between now and then to have enough.

*

How much more would you need to save each month?

Subtract the result of line 4 from that of line 1 to get your shortfall.

account: \$________________ = shortfall: \$________________.

6. Use the multiplier in Chart 2 to figure out how much you need to save each month to reach that goal.

Shortfall: \$_____________x multiplier from chart: ____________

= monthly savings needed to reach goal: \$____________.

Will you have enough saved?

1. Enter a rough estimate of your monthly retirement expenses: \$______________.

2. Subtract the amount you expect to receive from Social Security and/or any defined benefit pension that you may have at work. (Defined benefit pensions are the type that promise to pay a set monthly benefit for life. Your company's employee benefit department can give you a formula to determine your retirement income from a defined benefit plan; Social Security

(800) 772-1312) can provide an earnings and benefit statement to estimate

Your estimated monthly expenses (from line 1): \$________________

- the amount you'll have from Social Security and company pensions: \$________________

= retirement Income shortfall: \$_______________.

This is the monthly amount you'll need to generate from your savings, including self-directed plans such as individual retirement accounts and 401(k)s.

3. Adjust for inflation by multiplying the result from line 2 by the appropriate figure in Chart 3.

Retirement Income shortfall: \$________________x multiplier: --------------------

4. Can your current savings generate that amount? Estimate the future value of your savings by multiplying the current value of your retirement savings by the appropriate multiplier in Chart 1.

Current retirement savings: \$______________ x multiplier: ______________

= future value of your savings: \$____________.

Now, just to be safe, let's figure that your savings will earn 6% while you're retired and you won't spend any of the principal. This type of assumption allows you to plan for a long retirement and gives you plenty of wiggle room, in case you find that you need to spend much more than expected for long-term care, medical expenses or other unplanned items.

5. Multiply the result from line 3 by .06 and divide that result by 12.

Future value of your savings: (\$_______________ x annual rate of return 12 (months)

= future monthly income generated from current savings: \$_____________.

Does the result equal or exceed the amount on line 2? If it does, you're in good shape. If not, you need to figure out how much more to save to have enough.

How much more to save each month?

6. Multiply the amount of your monthly shortfall by 207

(the multiplier that corresponds with a 6% return,

assuming you don't spend any principal).

The result is the additional nest egg you need to create

to generate the monthly savings you want.

Shortfall: \$________________x 207 = additional required

nest egg: \$___________________.

7. Take the result and multiply it by the appropriate multiplier in Chart 2 to figure out how much more you need to save each month to generate that nest egg.

Required amount: \$________________ X multiplier: _______________

= additional monthly savings required: \$______________

If you find you can't possibly save enough in the time allotted, you have two options: Either figure you'll live on less or work a few years more.

*

Doing the Math Use these charts to help determine your portfolio's status, as described in the accompanying work sheet: Chart 1: What Your Current Savings Will Be Worth

*--*