sheet like this one will help you define your income requirements in retirement, the size of 9. and the amount that you must save annually to achieve your retirement goals. PROJECTING RETIREMENT INCOME AND INVESTMENT NEEDS Name(s)_Leo Frances Pendelton Date /31/201 I. Estimated Household Expenditures in Retirement (Note 1): 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 30 $ 5,000 of current expenses D. Estimated annual household expenditures in retirement (B C) S-33200. Il. Estimated Income in Retirement $ 24.ooo $ 9.o00 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) $ 33,000 $6,200 IlI. Inflation Factor: J. Expected average annual rate of inflation over the period to retirement5% K. Inflation factor (in Appendix A): Based on 30 years to retirement (A) and an expected average annual rate of inflation (J) of L. Size of inflation-adjusted annual shortfall (lx K) 4.322 $ 2696 IV. Funding the Shortfall: M. Anticipated return on assets held after retirement N. Amount of retirement funds required-size of nest egg (L M) $ 334,950 O. Expected rate of return on investments prior to retirement P.Compound interest factor (in Appendix B) Based on 30 years to retirement (A) and an expected rate of return on investments of 6% 72.053 Q. Annual savings required to fund retirement nest egg (N + P) s 423 Note: Parts I and Il are prepared in terms of current (today's) dollars