Retirement Planning
Contents
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.
Model
Inflation Inflation is assumed to be normally distributed. For the simulation, both a mean value and the standard deviation must be determined. Then the discount factors for each simulation are calculated. The result of the two investment options is in the end adjusted by a selection from these discount factors. The worst case scenario, the mean, the median and the 5%, 10%, 15%, 20% percentile (5% percentile is the value that is not exceeded with 95% certainty) were chosen. Inflation is simulated 1000 times.
