In: Finance
Eugene and Karen want to retire in 20 years. Both make good money, and want to put aside enough funds for a comfortable retirement. Their current household expenditures (excluding savings) are about $75,000 a year, and they expect to spend about 125% of that in retirement (125% equals a multiplier factor of 1.25.) They estimate their combined Social Security benefits will equal $20,000 a year in today’s dollars and that they’ll receive another combined $35,000 yearly from their company pension plans. They believe future inflation will be about 3% a year, that they’ll be able to earn about 12% on their investments before retirement, and about 8% afterward. Determine how big their investment nest egg will have to be and how much they’ll have to save yearly to accumulate the needed amount within the next 20 years.
|
PROJECTING RETIREMENT INCOME AND INVESTMENT NEEDS |
|||||||||||
|
Name(s) |
Eugene & Karen |
Date |
|||||||||
|
I. |
Estimated Household Expenditures in Retirement: |
||||||||||
|
A. |
Approximate number of years to retirement |
||||||||||
|
B. |
Current level of annual household expenditures, excluding savings |
$ |
|||||||||
|
C. |
Estimated household expenses in retirement as a percent of current |
||||||||||
|
expenses |
% |
||||||||||
|
D. |
Estimated annual household expenditures in retirement (B × C) |
$ - |
|||||||||
|
II. |
Estimated Income in Retirement: |
||||||||||
|
E. |
Social security, annual income |
$ |
|||||||||
|
F. |
Company/employer pension plans, annual amounts |
$ |
|||||||||
|
G. |
Other sources, annual amounts |
$ |
|||||||||
|
H. |
Total annual income (E + F + G) |
$ - |
|||||||||
|
I. |
Additional required income, or annual shortfall (D - H) |
$ - |
|||||||||
|
III. |
Inflation Factor: |
||||||||||
|
J. |
Expected average annual rate of inflation over the period to retirement |
% |
|||||||||
|
K. |
Inflation factor (in Appendix A): |
Based on |
years to |
||||||||
|
retirement (A) and an expected average |
|||||||||||
|
annual rate of inflation (J) of |
|||||||||||
|
L. |
Size of inflation-adjusted annual shortfall (I × K) |
$ - |
|||||||||
|
IV. |
Funding the Shortfall: |
||||||||||
|
M. |
Anticipated return on assets held after retirement |
% |
|||||||||
|
N. |
Amount of retirement funds required—size of nest egg (L ÷ M) |
$ - |
|||||||||
|
O. |
Expected rate of return on investments prior to retirement |
% |
|||||||||
|
P. |
Compound interest factor (in Appendix B): |
||||||||||
|
Based on |
years to retirement (A) and an expected rate of return |
||||||||||
|
on investments of |
|||||||||||
|
Q. |
Annual savings required to fund retirement nest egg (N ÷ P) |
$ - |
|||||||||
|
Note: Parts I and II are prepared in terms of current (today’s) dollars. |
|||||||||||