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

Used to translate amounts stated in today’s euros into future euros.
Present value of goals—
Free wealth before future saving—
Free wealth / assets—
Future saving assumptions

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.

ECB data are temporarily unavailable: this development version is using a provisional fallback curve. Do not use the displayed discount rates as current market data.

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

Expected return—
Volatility—
Sharpe ratio—

4. A. Current portfolio diagnosis

Efficient frontier Current portfolio GMV Efficient comparison point
Efficient return at the same risk—
Return efficiency gap—
Minimum risk at the same expected return—
Frontier portfolio at no higher risk
Tangency portfolio
Global minimum-variance portfolio (GMV)

This is the portfolio with the lowest volatility among all long-only risky portfolios. It does not depend on the current portfolio.

Expected return—
Volatility—

5. B. Target portfolio construction

Choose the desired volatility for the overall portfolio. The simulator combines the tangency portfolio with the risk-free asset.

Efficient frontier Tangency portfolio Target portfolio GMV CAL = Capital Allocation Line
Tangency volatility—
Risky portfolio share—
Cash / risk-free share—
Expected return—
Overall portfolio weights

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.

Expected goal coverage—
Expected shortfall—
Probability of covering all goals—
Probability of a shortfall—
Average shortfall when it occurs—

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.

Median wealth at final horizon—
10th percentile at final horizon—
90th percentile at final horizon—
Median wealth in today’s euros—
10th percentile in today’s euros—
90th percentile in today’s euros—
The chart is an illustrative simulation, not a forecast. The band excludes the most extreme 10% of paths on each side. Beyond the last goal, wealth continues to evolve using the same portfolio assumptions; annual saving is added only through the selected saving-end year.

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

Life-annuity estimate — today’s euros
Median annual life annuity—
Median monthly equivalent—
10th percentile annual annuity—
90th percentile annual annuity—
Median wealth converted—
Median wealth not converted—
Wealth not converted into the 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.

Median residual wealth at horizon—
10th percentile residual wealth—
90th percentile residual wealth—
Indicative future income — today’s euros
Life annuity from the converted share—
Maximum sustainable annual withdrawal from residual wealth (90%)—
Indicative total annual income—
—

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?

Risk capacity, risk tolerance and portfolio efficiency are different concepts.

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.

Model inputs

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.