This tool has restricted access. Enter the password provided by SAGORA.
Incorrect password.
Work through the steps in order, from the 33 portfolios of the case to real crises. Steps B to H prepare the 8 case questions and step I gives the solutions. Annualised data 2006-2026.
In Markowitz's mean-variance framework, each portfolio is described by two numbers:
Take US equities (S&P 500) and US Treasuries 7-10 years: their daily movements had a correlation of over 2006-2026. They therefore tended to move in opposite directions. Once mixed, their risk becomes lower than the average of their risks. This is not magic; it is correlation: ranging from −1 to +1, it tells you whether two assets rise and fall together (+1: always together; 0: no linear relationship; −1: in opposite directions). The lower it is, the more diversification reduces risk.
Then add other assets. The curve that bounds all possible mixes at the top left is the efficient frontier: for each level of risk, the best attainable expected return. One more asset never pushes it back. For it to rise clearly, that asset must meet two conditions: a sufficient expected return for its risk and a low correlation with what you already hold.
“Diversification is the only free lunch in finance.” Quote attributed to Harry Markowitz, 1990 Nobel laureate in Economics
This is what the case is all about: achieving the best expected return for a given risk or the lowest risk for a given expected return.
Each dot is a portfolio from the case. Its position gives its risk (annual volatility, on the horizontal axis) and its expected return (on the vertical axis), estimated over 2006-2026. The mauve dots contain only one asset. You can also invest part of your money at the risk-free rate ( a year, the green diamond). Hover over a dot to read its figures; click it to see its composition.
Which portfolio should you choose if you want an expected return of exactly 8%?
1a. Using the chart and the table, which portfolio do you choose? Why?
Choose a portfolio (on the chart, in the table or in the list), then the share of your money you invest in it: the rest is invested at the risk-free rate. Above 100%, you borrow at this rate. Your mix moves along the line connecting the risk-free rate to this portfolio.
Each asset column gives the share of the portfolio invested in that asset: the darker the cell, the larger the share. Click a header to sort (for example “Gold” to see the portfolios most invested in gold), or a row to select it. Expected returns and risks are measured in dollars, except those of the STOXX Europe 600, which are measured in euros.
Start from the risk-free rate ( a year, the rate used in the case, the green diamond): this is what an investment assumed to be risk-free in the case earns. Connect it to a portfolio: all the mixes of this portfolio with the risk-free rate lie on this line. Its slope is the Sharpe ratio of the portfolio, the expected return earned above the risk-free rate for each point of risk. The steeper the line, the better the risk is rewarded. Click on a portfolio: the tool calculates the mix that targets exactly 8% on its line.
Which portfolio should you choose if you want an expected return of exactly 8%?
1b. Which portfolio has the best Sharpe ratio? Compare it with the portfolios with an 8% expected return.
1c. By investing part of your money at the risk-free rate, how can you obtain an 8% expected return with this portfolio? What risk do you take, compared with the portfolios with an 8% expected return?
1d. Why is it the only risky portfolio you should hold, whatever your profile?
Choose a portfolio (on the chart, in the table or in the list), then the share of your money you invest in it: the rest is invested at the risk-free rate. Above 100%, you borrow at this rate. Your mix moves along the line connecting the risk-free rate to this portfolio.
E[r]: the expected return of the portfolio.
Work out your answer to question 1d first, then open the explanation to check your reasoning.
Click a row to draw its line on the chart. Sort by “Sharpe ratio” to check your answer to question 1b.
Choose a risky portfolio, then the share of your money you invest in it. The rest is invested at the risk-free rate. Above 100%, you borrow at this rate to invest more. All these mixes lie on the line connecting the risk-free rate to the portfolio: the larger the share, the higher the risk and the expected return.
Which portfolio should you choose if you want a risk of exactly 8%?
2a. Which portfolio should you choose if you want a risk of exactly 8%?
2b. What expected return do you obtain this way? Why is it the best choice for exactly 8% risk?
What is your risk aversion based on the test?
3a. Take the risk aversion test. What annual risk do you accept?
3b. What share do you invest in the portfolio from question 1b and what share at the risk-free rate (or borrowed)?
From score to risk. Risk is the standard deviation of annual returns around their average. If returns roughly follow a normal distribution, then with 10% risk the return in a given year stays within 10 percentage points of its average in about two years out of three.
| Test score | Profile | Indicative annual risk |
|---|---|---|
| 1 | Very defensive | 3% |
| 2 | Defensive | 6% |
| 3 | Cautious | 9% |
| 4 | Balanced | 12% |
| 5 | Moderately dynamic | 16% |
| 6 | Dynamic | 20% |
| 7 | Very dynamic | 25% |
These reference points are illustrative: they build on the test question about the acceptable annual variation (±3, ±8, ±15 or ±25%). They are not regulatory thresholds.
If the risk you accept is higher than that of the chosen portfolio, you have to borrow to reach it, with a Lombard loan. The "Result" card then explains what this means.
Risk and expected return are linked by the line: set either one, then click “Apply” or press Enter: the share and the other value update.
Two separate situations: the same initial investment, which you would need either in 5 years or in 20 years. The expected returns and risks shown are those of the case over 2006-2026, in the currency of each asset: currency risk is not counted here (see step H). Note: the investment horizon is not the data period. The case figures measured over 5, 10 and 20 years of data are used for question 7. The amounts obtained are estimates derived from the expected return and the risk, not actual history (replayed in step H). For each horizon, start from the amount you will need, then choose the risky portfolio and the share you invest in it: the rest is invested at the risk-free rate.
4. Which portfolio would you choose with a 5-year investment horizon, taking your risk aversion into account? Why?
5. Which portfolio would you choose with a 20-year investment horizon, taking your risk aversion into account? Why?
For each horizon, enter the amount you will absolutely need, then choose the share invested in the risky portfolio. On the slider, the green zone shows the shares that, according to the model, cover this amount with the chosen level of certainty.
“95 times out of 100”: if the future played out 100 times, you would have at least your amount in 95 of them. “99 times out of 100” is stricter: the green zone narrows.
We start from the expected return and risk of your mix. The share invested in the risky portfolio stays the same: you regularly bring it back to its starting level (rebalancing). No simulation: a statistical formula (lognormal distribution) directly gives two amounts: the one you reach at least 95 times out of 100 (or 99) and the one you exceed half the time. The amounts are calculated as if the return were reinvested every trading day. For the risk-free rate, this gives slightly more than interest paid once a year (€ 1,151 instead of € 1,148 over 5 years for € 1,000). This is a model: real crashes can be more severe (step H).
For example, an expense planned in 5 years.
For example, supplementary retirement income.
Compare the two cards, then answer questions 4 and 5. The solutions are in step I.
To aim for a higher expected return, there are two options: take a riskier portfolio among the 33 or keep the optimal portfolio from question 1 and borrow to buy more of it. Enter the target expected return, compare the risk of the two options and see under what condition borrowing is possible.
Which portfolio should you choose if you want an expected return of ?
6a. Among the 33 portfolios, which one reaches this expected return? With what risk?
6b. How can you reach it with the portfolio from question 1b? Under what condition and with what risks?
Borrowing at the risk-free rate is a textbook assumption: a Lombard loan costs more and the bank requires a top-up if the portfolio falls too far (margin call, step H).
Each asset column gives the share of the portfolio invested in that asset: the darker the cell, the larger the share. Click a header to sort (for example “Gold” to see the portfolios most invested in gold), or a row to select it. Expected returns and risks are measured in dollars, except those of the STOXX Europe 600, which are measured in euros.
An expected return is not observed: it is estimated from the past. Change the measurement period (the last 5, 10 or 20 years) and see what moves: the expected returns of the assets, the position of the 33 portfolios and the portfolio with the best Sharpe ratio, the one whose line from the risk-free rate is the steepest. Note: this is not your investment horizon, it is the data window used for the estimates. The risk-free rate is also measured over each period (average US 10-year yield): .
7a. Estimate the expected returns and risks over the last 5, 10 and 20 years. How do they vary?
7b. Does the best Sharpe ratio always go to the same portfolio?
7c. What does this difference tell you?
The green star is the tangency portfolio calculated for the period: the best Sharpe ratio you would get by freely mixing the six assets. The exercise is limited to the 33 portfolios of the case. With all mixes allowed, the star would be the one to choose, based on these estimates.
Correlations are measured over each period, like the expected returns and the risks.
The figures in the previous steps are the case estimates. Now replay the real history of 2006-2026 with the daily prices of the six assets of the case, then take on the challenges: each one reveals a key point for question 8. You can also try everything freely.
8. Beyond expected returns, which real-world factors could affect the performance of your portfolios? Identify at least three key points and justify them.
Choose a question, try to find your answer first, then reveal the solution. Each sub-question has its own solution, next to the answer you saved in steps B to H. The main questions are taken from the case. The button under the solution takes you back to the corresponding step.
Start from the tangency portfolio or one of the 33 case portfolios, change its allocation, then adjust its mix with the risk-free rate using leverage. Change the data period or the risk-free rate: the frontier, the Sharpe ratio and the correlations update accordingly. Click or drag on the chart to move along the line of your portfolio.
Untick an asset to exclude it: the optimal portfolio, the efficient frontier and your allocation then use only the ticked assets.
The portfolio built in the simulator (step J), with its share at the risk-free rate or its borrowing, is replayed over the real history of 2006-2026, using the daily prices of the six assets of the case. Choose a period and compare it with an investment of 100% in US equities (S&P 500).
Same replay as in step H: $100 invested at the start of the period, bought and held without rebalancing, closing prices, amounts in dollars with no fees or tax. Borrowing goes through a Lombard loan with the indicative loan-to-value ratios of step H: if the debt exceeds what the bank lends, it requires a top-up (margin call).
What you hold matters. The way your assets move together matters just as much. An asset with a low correlation to the others and a sufficient expected return for its risk can shift the efficient frontier upwards and to the left (step A).
As soon as a risk-free investment exists, the model's strategy comes down to two decisions: choose the portfolio with the best Sharpe ratio, then mix it with the risk-free rate according to your profile (steps C and D). This is Tobin's separation theorem.
A Lombard loan amplifies gains when all goes well and losses when all goes badly. The Sharpe ratio, for its part, does not change as long as you borrow at the risk-free rate: you buy expected return with risk, not efficiency. In a crisis, the bank can require a top-up at the worst moment (steps D and H).
Three questions to ask your banker: “Is my portfolio on the line of the best Sharpe ratio or am I taking risk that earns me nothing?” “If I am offered borrowing, does my Sharpe ratio improve or am I simply being sold more risk?” “Does my allocation take into account my horizon and the drop I can bear without selling?”