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.  | 
|||||||||||