Restricted access

This tool has restricted access. Enter the password provided by SAGORA.

Incorrect password.

Accessible, useful and human finance · sagora.eu
Portfolio management · Case workshop

The case step by step: from the 33 portfolios to the mix that suits you.

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.

Workshop guide Objectives, the 11 steps, the case questions and the data tables. Open the guide
  1. 1Read the case question at the top of the step.
  2. 2Explore the chart and experiment with the settings.
  3. 3Read the boxes: they give you what you need to answer.
  4. 4Write your answer under each question, then save it.
  5. 5Compare with the solutions in step I, which explain each answer.
Step A · The founding principle
A portfolio's risk is not the average of the risks.

In Markowitz's mean-variance framework, each portfolio is described by two numbers:

  • its expected return: the annual average of its past returns, used as an estimate;
  • its risk, measured by volatility: the standard deviation of returns, the square root of the variance.

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.

··

Step B · Question 1
Aim for an 8% 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.

Case question 1

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?

Move along the line from the risk-free rate

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.

Target an expected return
%
Target a risk
%

The 33 portfolios of the case

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.

Step C · Question 1, continued
The best portfolio and the line from the risk-free rate
Did you choose No. 9 or No. 10?They show an expected return of exactly 8%. Yet there is a better way to obtain 8%: start from the portfolio with the best Sharpe ratio and combine it with the risk-free rate, along its line.

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.

Case question 1, continued

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?

Move along the line from the risk-free rate

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.

Target an expected return
%
Target a risk
%

The Sharpe ratio
Sharpe ratio = (E[r] − risk-free rate) / risk (volatility)

E[r]: the expected return of the portfolio.

What Markowitz, Tobin and Sharpe say

Work out your answer to question 1d first, then open the explanation to check your reasoning.

See the Markowitz, Tobin and Sharpe explanation
A single risky portfolio for everyoneMarkowitz (1952): by combining assets whose returns do not move perfectly together, you obtain the efficient frontier, the portfolios that offer the best expected return for each level of risk. Without a risk-free asset, each investor picks a point on it according to their profile.
Tobin (1958): with a risk-free asset, any investor can combine a risky portfolio with this investment or borrow at this rate. All these combinations lie on the line that starts from the risk-free rate. The steepest line dominates all the others: for the same risk, it always offers a higher expected return. Everyone therefore holds the same risky portfolio. Your profile only changes the mix with the risk-free rate (step D): this is the separation theorem.
Sharpe (1964, 1966): the slope of this line is the Sharpe ratio, the expected return earned above the risk-free rate for each point of risk. The risky portfolio to hold is the one with the highest Sharpe ratio.
Aiming for an 8% expected return therefore does not require a portfolio that shows 8%: you combine the one with the best Sharpe ratio with the risk-free rate in the right proportion.
The 33 portfolios and their Sharpe ratio

Click a row to draw its line on the chart. Sort by “Sharpe ratio” to check your answer to question 1b.

Step D · Questions 2 and 3
Sizing: mixing the risky portfolio with the risk-free rate

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.

Case question 2

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?

Case question 3

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)?

Step by step: answering questions 2 and 3
  1. Choose the portfolio from question 1b in the “Risky portfolio” list on the “Your mix” card below.
  2. Question 2: enter 8 in the “Risk of the mix” box, then click “Apply”. The “Result” card gives the share invested in the risky portfolio, the share at the risk-free rate and the expected return of the mix.
  3. Question 3: take the risk aversion test and note your score, from 1 to 7, then convert it into an annual risk with the “From score to risk” table: this is your answer to question 3a.
    Take the risk aversion test (in French) ↗
  4. Enter your risk in the “Risk of the mix” box, then click “Apply”.
  5. Read the resulting share on the “Result” card: this is your answer to question 3b. The calculation: share invested = accepted risk / risk of the risky portfolio. For No. , this risk is : its annual volatility over 2006-2026, shown in the list and on the chart. The rest is invested at the risk-free rate; above 100%, you borrow the difference.

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 scoreProfileIndicative annual risk
1Very defensive3%
2Defensive6%
3Cautious9%
4Balanced12%
5Moderately dynamic16%
6Dynamic20%
7Very dynamic25%

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.

Your mix
100%

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.

Risk of the mix
%
Expected return of the mix
%

Result
Your mix on the line
Step E · Questions 4 and 5
Investment horizon: 5 years or 20 years

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.

Case questions

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?

Your investment

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.

Initial investment
€
How certain do you want to be of having this amount?

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

How is it calculated?

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

In 5 years
Amount you will absolutely need
€

For example, an expense planned in 5 years.

In 20 years
Amount you will absolutely need
€

For example, supplementary retirement income.

Your two mixes on the line

Compare the two cards, then answer questions 4 and 5. The solutions are in step I.

Step F · Question 6
Aim for : a riskier portfolio or borrowing

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.

Case question 6

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?

Your target
Target expected return
%
Optimal portfolio of the case (question 1b)

The two options on the chart

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

The 33 portfolios of the case

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.

Step G · Question 7
Expected returns depend on the measurement period

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): .

Case questions

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.

Expected return of the assets by period
What to look for

Correlations are measured over each period, like the expected returns and the risks.

Step H · Question 8
Testing your investments in real crises

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.

Case question

8. Beyond expected returns, which real-world factors could affect the performance of your portfolios? Identify at least three key points and justify them.

1Your investment
2The replayed dates
3Add reality

Each asset alone over the same period: its worst drop
How the replay is calculated
  • The replay follows the daily prices of the six assets of the case: S&P 500 with dividends reinvested, STOXX Europe 600 with net dividends (converted into dollars at the day’s EUR/USD rate), MSCI Emerging Markets, spot gold, the iShares 7-10 Year Treasury Bond fund and the FTSE Nareit All Equity REITs. On a day without a quote, an asset keeps its last known price.
  • “Buy and hold” replay, without rebalancing: the starting weights are never reset and drift with the markets. Unlike step E, the starting share is not maintained.
  • The value is tracked trading day after trading day, using closing prices: intraday drops do not appear.
  • Borrowing: the loan is granted with the portfolio held as collateral (Lombard loan), at the case’s risk-free rate ( a year). The bank lends only a share of the value of each asset (): if the debt exceeds this amount, it requires a top-up (margin call).
  • Fees: assumed to be 1% a year, deducted daily pro rata from the net value of the investment.
  • In euros: conversion at the day’s EUR/USD rate, top-ups included.
  • Inflation: assumed to be 2% a year, the target of both the European Central Bank and the US Federal Reserve.
  • Tax: a simplified example of 10% deducted on exit, not the exact tax rules.
Step I · Case solution
The 8 questions, solved with the case figures

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.

Your answers stay in this browser, on this device.
Step J · Simulator
Build your portfolio with the case assets

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.

Case universe

Untick an asset to exclude it: the optimal portfolio, the efficient frontier and your allocation then use only the ticked assets.

Case portfolios

Risk and expected return
Correlations

Your allocation

Step K · Weathering the crises
How would your portfolio have come through the crises?

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

Portfolio tested

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

Key takeaways · The lessons of the workshop
Correlation matters as much as selection

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

The risk-free rate changes everything

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.

Leverage is not free

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

What you take away

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?”