FIN $5823$

Using the Retirement Planning Model that you created in Excel, write $6-$to$-9-$page paper answering the questions stated in the retirement case study.

Section $1$: Introduction & Describe Process to Create the Model

$12$ pages

Section $2$: Answer the case questions

$12$ pages

Section $3$: Answer the case questions for yourself

$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 $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.