Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Instructions Make some assumptions in completing this assignment. If you have not thought about planning for retirement, now is a good time to start. Calculate

Instructions Make some assumptions in completing this assignment. If you have not thought about planning for retirement, now is a good time to start. Calculate how much is needed to save for future retirement based on estimates. Read Instructions to Build a Retirement Plan. Part 1: Design your retirement plan using the attached excel spreadsheet. Part 2: Write a summary of the highlights from your retirement plan.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Instructions Make some assumptions in completing this assignment. If you have not thought about planning for retirement, now is a good time to start. Calculate how much is needed to save for future retirement based on estimates. Read Instructions to Build a Retirement Plan. Part 1: Design your retirement plan using the attached excel spreadsheet. Part 2: Write a summary of the highlights from your retirement plan. kases as ol January culu Some Assumption: Withrawal Rate from Portfolio in Retirement, Net of Infation (\%) tructions: INPUTS - Enter your data in the yellow highlighted cells below. Results will appear in the purple cells. Age Parameters and Your Retirement Income Goals 27 Current Age. 64 Retirement Age Your Target Gross Annual Income at Retirement - in today's dollars, betore tax One Time Expenses at Retirement, such as bridge to social security, in today's dollars, before tax Retirement Income From Other Sources Estimated Social Secunty Annual Payments (in today's dollars) Annual income From Other inflation-indexed Pensions (such as mulitary pensions), in today's dollars, before tax Annual income From Real Estate of Other Imvestments That Wil Likely Adjust With Inflation, in today's dollars, before tax Annual income From Pensions That Are NOT indexed to Infation, in today's dollars, before tax. The spreadsheet will adjust this figute to an equivalent inflation adjusted payment amount, using the assumpton in cell K45. Your Contributions to Your Retirement Accounts Traditional Accounts (Traditional 401k8403b accounts, and IRAs with before-tax contributions) Cument Balance Annual Contribution - in today's dollars Roth Accounts (Roth IRAs, Roth 401k, Roth 403b accounts) Current Balance Annual Contribution - in today's doltars \% - Estimated Averape tncome Tax Rate in Retirement (This spreadsheet is set up to work with taxable income in retirement Since Roth Balances are not taxable they must be adjustod to an equivalent taxable amount. A lower rate is more conservative than a higher rate) Instructions Make some assumptions in completing this assignment. If you have not thought about planning for retirement, now is a good time to start. Calculate how much is needed to save for future retirement based on estimates. Read Instructions to Build a Retirement Plan. Part 1: Design your retirement plan using the attached excel spreadsheet. Part 2: Write a summary of the highlights from your retirement plan. kases as ol January culu Some Assumption: Withrawal Rate from Portfolio in Retirement, Net of Infation (\%) tructions: INPUTS - Enter your data in the yellow highlighted cells below. Results will appear in the purple cells. Age Parameters and Your Retirement Income Goals 27 Current Age. 64 Retirement Age Your Target Gross Annual Income at Retirement - in today's dollars, betore tax One Time Expenses at Retirement, such as bridge to social security, in today's dollars, before tax Retirement Income From Other Sources Estimated Social Secunty Annual Payments (in today's dollars) Annual income From Other inflation-indexed Pensions (such as mulitary pensions), in today's dollars, before tax Annual income From Real Estate of Other Imvestments That Wil Likely Adjust With Inflation, in today's dollars, before tax Annual income From Pensions That Are NOT indexed to Infation, in today's dollars, before tax. The spreadsheet will adjust this figute to an equivalent inflation adjusted payment amount, using the assumpton in cell K45. Your Contributions to Your Retirement Accounts Traditional Accounts (Traditional 401k8403b accounts, and IRAs with before-tax contributions) Cument Balance Annual Contribution - in today's dollars Roth Accounts (Roth IRAs, Roth 401k, Roth 403b accounts) Current Balance Annual Contribution - in today's doltars \% - Estimated Averape tncome Tax Rate in Retirement (This spreadsheet is set up to work with taxable income in retirement Since Roth Balances are not taxable they must be adjustod to an equivalent taxable amount. A lower rate is more conservative than a higher rate)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

More Books

Students also viewed these Accounting questions

Question

Be familiar with distributed objects computing.

Answered: 1 week ago

Question

Describe strategic succession planning in todays environment.

Answered: 1 week ago

Question

Explain the various elements of a diverse workforce.

Answered: 1 week ago

Question

Describe the strategic planning process.

Answered: 1 week ago