Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Use Worksheet 14.1 to help Georgia and Jude Sullivan determine how much they need to retire early in about 20 years. Both have promising careers,

image text in transcribed
image text in transcribed
Use Worksheet 14.1 to help Georgia and Jude Sullivan determine how much they need to retire early in about 20 years. Both have promising careers, and both make good money. As a result, they're willing to put aside whatever is necessary to achieve a comfortable lifestyle in retirement. Their current level of household expenditures (excluding savings) is around $75,000 a year, and they expect to spend even more in retirement; they think they'll neec about 125% of that amount. (Note: 125% equals a multiplier factor of 1.25). They estimate that their Social Security benefits will amount to $25,000 a year in today's dollars and they'll receive another $30,000 annually from their company pension plans. Georgia and Jude feel that future inflation will amount to about 3% a year, and they think they'll be able to earn about 6% on their investments before retirement and about 4% afterward. See Appendix A and Appendix B. . Use Worksheet 14.1 to find out how big Sullivans' investment nest egg will have to be. Round your answer to the nearest dollar. $ . How much they'll have to save annually to accumulate the needed amount within the next 20 years. Round your answer to the nearest dollar. $ K24 AB D E G H 1 PROJECTING RETIREMENT INCOME AND INVESTMENT NEEDS 9 11 13 14 16 $ $ 1.000 Name(s) Date 1. 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 (BC) 18 11. Estimated Income in Retirement: 20 E Social security, annual income 22 F. Company/employer pension plans, annual amounts 24 G. Other sources, annual amounts 26 H. Total annual income (E+F+G) 28 1. Additional required income, or annual shortfall (D-H) 30 II, Inflation Factor 32 3. Expected average annual rate of inflation over the period to retirement K Inflation factor in Appendix A): Based on 0 years to 35 retirement (A) and an expected average 36 annual rate of inflation () of 0% 38 L Size of Inflation-adjusted annual shortfall (1xK) 40 V. 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). 49 Based on O years to retirement (A) and an expected rate of return 50 on investments of 0% 52 Q. Annual savings required to fund retirement nest egg (N+P) 54 Note: Parts and il are prepared in terms of current (today's) dollars. 55 56 57 58 59 60 61 62 63 64 65 66 ws 14.1 01 ] 0.000 + Use Worksheet 14.1 to help Georgia and Jude Sullivan determine how much they need to retire early in about 20 years. Both have promising careers, and both make good money. As a result, they're willing to put aside whatever is necessary to achieve a comfortable lifestyle in retirement. Their current level of household expenditures (excluding savings) is around $75,000 a year, and they expect to spend even more in retirement; they think they'll neec about 125% of that amount. (Note: 125% equals a multiplier factor of 1.25). They estimate that their Social Security benefits will amount to $25,000 a year in today's dollars and they'll receive another $30,000 annually from their company pension plans. Georgia and Jude feel that future inflation will amount to about 3% a year, and they think they'll be able to earn about 6% on their investments before retirement and about 4% afterward. See Appendix A and Appendix B. . Use Worksheet 14.1 to find out how big Sullivans' investment nest egg will have to be. Round your answer to the nearest dollar. $ . How much they'll have to save annually to accumulate the needed amount within the next 20 years. Round your answer to the nearest dollar. $ K24 AB D E G H 1 PROJECTING RETIREMENT INCOME AND INVESTMENT NEEDS 9 11 13 14 16 $ $ 1.000 Name(s) Date 1. 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 (BC) 18 11. Estimated Income in Retirement: 20 E Social security, annual income 22 F. Company/employer pension plans, annual amounts 24 G. Other sources, annual amounts 26 H. Total annual income (E+F+G) 28 1. Additional required income, or annual shortfall (D-H) 30 II, Inflation Factor 32 3. Expected average annual rate of inflation over the period to retirement K Inflation factor in Appendix A): Based on 0 years to 35 retirement (A) and an expected average 36 annual rate of inflation () of 0% 38 L Size of Inflation-adjusted annual shortfall (1xK) 40 V. 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). 49 Based on O years to retirement (A) and an expected rate of return 50 on investments of 0% 52 Q. Annual savings required to fund retirement nest egg (N+P) 54 Note: Parts and il are prepared in terms of current (today's) dollars. 55 56 57 58 59 60 61 62 63 64 65 66 ws 14.1 01 ] 0.000 +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using QuickBooks Accountant 2018 For Accounting

Authors: Glenn Owen

16th Edition

9780357042083

Students also viewed these Finance questions