Goals, Risk and Portfolio Simulator
Start from goals and liabilities, identify free wealth, then compare your current portfolio with the efficient frontier.
Educational tool only. It does not provide investment advice.
1. Assets, goals and liabilitiesDEV
Enter the annual saving you expect to sustain, the year in which saving stops, and the inflation assumption used to translate today’s euros into future euros.
2. Market assumptions
Use the default historical estimates or replace them with your own expected returns, volatilities and correlations. Edit the upper triangle of the correlation matrix: the symmetric entry is updated automatically. Press Apply assumptions when the scenario is complete.
3. Your current portfolio
Enter the first three weights. Euro corporate bonds are calculated automatically so that the portfolio sums to 100%.
4. A. Current portfolio diagnosis
This is the portfolio with the lowest volatility among all long-only risky portfolios. It does not depend on the current portfolio.
5. B. Target portfolio construction
Choose the desired volatility for the overall portfolio. The simulator combines the tangency portfolio with the risk-free asset.
5B. Goal coverage with the target portfolio
These results are calculated only after the target portfolio above has been defined. Future saving is then invested at the target portfolio expected return; the probabilistic analysis also uses its volatility.
5C. Simulated wealth and goals over time
The central line shows median simulated wealth after any goal payment due in each year. The band shows the 10th–90th percentile range; vertical markers identify goal dates. The simulation horizon may extend beyond the last goal, up to 100 years.
5D. Future resources: annuity and invested wealth
Split future wealth between an illustrative simple life annuity and wealth that remains invested. The selected annuity share is converted into lifetime income; the complementary share remains personal invested wealth. Main results are shown in today’s euros.
A. Illustrative simple life annuity
The share not converted remains personal wealth. You can keep the previous target portfolio or choose a different risk level for this residual wealth.
6. Risk capacity and behaviour
Suppose the risky part of the portfolio falls by 15%. Would you be able to maintain the strategy without changing your goals?
7. What we learn
Portfolio choice does not begin with the efficient frontier. It begins with goals, liabilities and the amount of wealth that can actually bear risk. Then distinguish between choosing the efficient risky portfolio and choosing the overall risk level through the combination with cash. Beyond the tangency portfolio, a higher target volatility requires leverage in the theoretical model. Efficiency, risk capacity and behaviour must be considered together.
Illustrative historical estimates based on the uploaded prototype workbook, common sample approximately 1999–2026. Long-only frontier computed on a 1% weight grid. Expected returns, volatilities and correlations can be edited by the user. Estimates are not forecasts.
