Course Project $-$ Part $3($LO$2)($LO$3)-75$ points

Create a financial model in Excel that will answer the questions listed in the retirement planning case.

For your course project, you will complete the retirement planning case by creating a spreadsheet model in Excel and using the model to answer the case questions. You will also apply the model to your personal situation and write a $6-$to$-9-$page paper. The project will be completed over five weeks and is worth $43\%$ of your grade. A summary of the assignments and points follows:

Week Four: Project Action Plan $50$ points

Week Five: Create Influence Chart $50$ points

Week Six: Create Model in Excel $75$ points

Week Seven: Answer Case Questions $75$ points

Week Eight: Course Project Paper $125$ points

Essential Activities:

Reviewing the paper "Financial Modeling Guidelines $($LO$2)($pages $3-29$ only$)"$ will assist you in completing this assignment.

Watching the video $"40\%$ of Americans Say THIS is How Much Money You Need to Retire $-$ Are They Wrong? $($LO$2)($LO$3)(12$:$26)"$ will assist you in completing this assignment.

Watching the video "Why I Wold Never Take Social Security at Age $65$ by Medicare $($LO$2)($LO$3)(15$:$04)"$ will assist you in completing this assignment.

Notes:

Following these steps will help as you design and create your retirement model in Excel:

Sketch the spreadsheet.

Organize you model into four modules or sections.

Input Parameters

Decisions $-$ design for use by making it easy to change parameters that can be expected to change.

Outputs

Calculations

$3.$ Start small by isolating one question at a time then design, build, and test your retirement planning model to make sure it answers that question. Then move to the next question. This way you will begin simple and finish complex.

You will complete the retirement planning model in MS Excel and submit the Excel file for grading.

Most of the answers said Bob need to set $7,80,000$ each year. But, there is no calculation or process how we get that value.