Project: Retirement Planning Case by creating a spreadsheet model in Excel and using the model to answer the case questions
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(current Age 31, Working as Engineer) and write a 6-to-9-page paper.
The outline of the paper follows:
Section 1: Introduction & Describe Process to Create the Model
1 2 pages
1 2 pages
2 -3 pages
Describe the process you used to analyze your personal situation.
How many scenarios did you run; how long did it take you to feel comfortable with the numbers?
Is the amount you are currently accumulating at your current savings rate adequate?
How much should you be setting aside each year?
How much will you have to live on when you retire?
How long after retirement will you be able to live comfortably (like you are living now)?
What risks do you face and how should your retirement planning take these risks into account?
Section 2: Answer the case questions
Section 3: Answer the case questions for yourself
Section 4: Reflection
2 to 3 pages
Thinking back to Week One and the experience with spreadsheet discussion, do you feel more confident today in your ability to analyze data and build financial models using MS Excel? Why?
After your experience in this class, do you see MS Excel as an essential workplace skill? Why?
What surprises did you experience while using the Retirement Planning Model to analyze your personal situation?
What changes do you plan to make to your retirement planning strategy as a result of this project? Please explain?
Discuss three things you learned while completing this project. Be specific.
Section 5: Presentation
Prepare a presentation using PowerPoint, to present and explain the results of your retirement planning (current Age 31, Working as Engineer) model and case questions. In your presentation you will show screenshots of your model and explain how and why you designed it as you did. You will also explain your answers to the case questions based on Bob, not your information.
Your presentation must include:
