Retirement Planning

Problem Definition

In retirement planning, there are different investment options that are associated with different risks. Therefore, this simulation is intended to help compare different investment options and evaluate their risk. For this purpose, it is assumed that a fixed amount is already invested in one of the options and that a fixed amount will be invested over the next 30 years. Two different options are compared, an investment in a chosen stock portfolio or an investment in bonds. To make the model more realistic, it is assumed that the stock markets are repeatedly shaken by black swan events. Black swan events are, for example, financial crises that occur irregularly and without warning. In addition, inflation is simulated over the next 30 years and the result is adjusted for it.

Method

The chosen simulation method is a Monte Carlo simulation in Excel.