Worksheet Below

Q1: Projecting Retirement Income and Investment Needs (50 points) Use the attached worksheet 1 to help Al and Linda Stone, who would like to retire while they are still relatively young - in about 20 years. Both have promising careers, and both make good money. As a result, they are willing to put aside whatever is necessary to achieve a comfortable lifestyle in retirement. Their current level of house-hold expenditures (excluding savings) around $75,000 a year, and they expend to spend even more in retirement; they thing they will need about 125% of that amount. They estimate that their social security benefits will amount to $20,000 a year in today's dollars and they will receive another $35,000 annually from their company pension plans. They feel that future inflation will amount to 3% a year; in addition, they think they will be able to earn about 12% on their investments prior to retirement and 8% afterward. Use the worksheet to find out how big their investment nest egg will have to be and how much they will have to save annually in order to accumulate the needed amount within the next 20 years. Name: Estimated Household Expenditures in Retirement: Approximate number of years to retirement a. b. Current level of annual household expenditures, excluding savings Estimated household expenses in retirement as a percent of current expenses 125% c. d. Estimated annual household expenditures in retirement (b*c) . Estimated Income in Retirement: Social security, annual income. e. f. Company/employer pension plans, annual amounts g. Other sources, annual amounts h. Total annual income (e+ftg) i. Additional required income, or annual shortfall (d-h) .. III Inflation Factor: j. Expected average annual rate of inflation over the period to retirement Inflation factor (Appendix A): Based on 20 years to retirement (A) and an expected k. average annual rate of inflation (J) of 3%. 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 (/m). Expected rate of return on investments prior to retirement 12% o. Compound interest factor (Appendix B): Based on 20 years to retirement (A) and an p. expected rate of return on investments of 12% ... Annual savings required to fund retirement nest egg (n/p). q. Q1: Projecting Retirement Income and Investment Needs (50 points) Use the attached worksheet 1 to help Al and Linda Stone, who would like to retire while they are still relatively young - in about 20 years. Both have promising careers, and both make good money. As a result, they are willing to put aside whatever is necessary to achieve a comfortable lifestyle in retirement. Their current level of house-hold expenditures (excluding savings) around $75,000 a year, and they expend to spend even more in retirement; they thing they will need about 125% of that amount. They estimate that their social security benefits will amount to $20,000 a year in today's dollars and they will receive another $35,000 annually from their company pension plans. They feel that future inflation will amount to 3% a year; in addition, they think they will be able to earn about 12% on their investments prior to retirement and 8% afterward. Use the worksheet to find out how big their investment nest egg will have to be and how much they will have to save annually in order to accumulate the needed amount within the next 20 years. Name: Estimated Household Expenditures in Retirement: Approximate number of years to retirement a. b. Current level of annual household expenditures, excluding savings Estimated household expenses in retirement as a percent of current expenses 125% c. d. Estimated annual household expenditures in retirement (b*c) . Estimated Income in Retirement: Social security, annual income. e. f. Company/employer pension plans, annual amounts g. Other sources, annual amounts h. Total annual income (e+ftg) i. Additional required income, or annual shortfall (d-h) .. III Inflation Factor: j. Expected average annual rate of inflation over the period to retirement Inflation factor (Appendix A): Based on 20 years to retirement (A) and an expected k. average annual rate of inflation (J) of 3%. 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 (/m). Expected rate of return on investments prior to retirement 12% o. Compound interest factor (Appendix B): Based on 20 years to retirement (A) and an p. expected rate of return on investments of 12% ... Annual savings required to fund retirement nest egg (n/p)