Build a risk tab that compares your portfolio with two benchmarks on the measures from this module.
Open your workbook and add a tab called Risk, placed second, next to the returns tab you built in lesson 1.8. Allow about forty minutes if your returns data is already in the workbook, and longer if you still have to gather benchmark data.
A risk desk does not send a portfolio manager a pile of separate reports. It sends one page with the main numbers side by side, so anyone can see in about a minute what kind of risk the portfolio carries and how it compares with the alternatives. Your Risk tab is that page for your own account. Finished, it fits on one screen: three columns and seven rows.
The three columns are your portfolio, a world equity index, and the blended benchmark from lesson 1.6, "Choose a benchmark that matches what you actually hold". The benchmark should match what you actually hold, so use the blend you built there.
The seven rows are the measures from this module, in this order: annualised volatility, maximum drawdown, longest time under water, Sharpe ratio, Sortino ratio, beta to the world index, and one-month 95% Value at Risk.
All three columns must be in SGD, on a total return basis, and over the same window. Use monthly data if you have it, and take the longest common window available, ideally ten years.
At the top of the tab, add a notes cell recording four things: the window, the data frequency, the risk-free rate you used, and the source of that rate. Without those four notes nobody can tell what the numbers mean, and that includes you a year from now.
Each row uses a method from earlier in this module. Annualised volatility is the standard deviation of monthly returns multiplied by the square root of 12, as in lesson 2.1. Maximum drawdown and longest time under water come from a running peak column, as in lesson 2.2. For the Sharpe and Sortino ratios, follow lesson 2.3 and use the T-bill yield you look up on the MAS website as the risk-free rate. Beta to the world index is the spreadsheet SLOPE function run against the world index, as in lesson 2.4, "Beta, correlation and why diversification shrinks in a crisis". The world index's own beta is 1 by definition. Value at Risk uses the historical method from lesson 2.6.
Keep all the formulas on a separate calculation tab and pull only the results onto the Risk tab, so the Risk tab stays readable at a glance.
Marcus is an invented investor. The dashboard below is built on the made-up ten years of yearly returns from lesson 2.3, so you can check your formulas on a small data set. Figures run in the order portfolio, world index, blended benchmark:
Volatility: 11.3%, 12.5%, 10.0% Maximum drawdown: minus 18%, minus 16%, minus 13.4% Longest time under water: two years, one year, two years Sharpe ratio: 0.37, 0.48, 0.41 Sortino ratio: 0.57, 0.84, 0.68 Beta to the world index: 0.88, 1.00, 0.80 One-month 95% Value at Risk, from monthly data: 6.4% for the portfolio, with made-up figures of 7.0% for the world index and 5.5% for the blended benchmark
As lesson 2.2 warned, yearly data understates drawdowns, so your monthly figures will look worse than Marcus's yearly-based ones.
Beside the summary, paste the correlation matrix of your largest holdings that you built for lesson 2.4, with every pair above 0.8 marked. The summary shows how much risk you carry, and the matrix shows where that risk comes from.
The conclusions matter more than the numbers. Read across each row and ask where your portfolio sits between the two benchmarks.
Marcus notices three things. First, volatility of 11.3% is above the blended benchmark's 10.0%, yet the Sharpe and Sortino ratios are both lower. Higher volatility than your blended benchmark together with lower Sharpe and Sortino ratios means you took more risk than your own target allocation and were not paid for it. Second, a beta of 0.88 and a correlation of 0.98 with world shares mean the account is in practice one large bet on global equities. Third, the correlation matrix shows where the extra risk came from: bank shares that duplicated the STI ETF in the account, and a chip stock that amplified the biggest holdings of the world ETF it also held.
Finish the tab with three sentences that meet the three-sentence standard. Sentence one names your biggest risk. Sentence two says what the numbers show about it. Sentence three says whether it was a choice.
Marcus's three sentences are the standard to meet. The largest risk is a deep fall in global shares, chosen when setting an 80% equity target. On top of that there is extra risk from the bank and chip holdings, which raised volatility above the benchmark without raising risk-adjusted return. That extra part was not chosen deliberately, and Marcus will return to it when writing position limits in module 11.
Your three sentences should not say what to buy or sell. That decision comes later in the course, with sizing rules, in lesson 11.3, "Position and sector limits, and concentration risk".
If any of your ratios look far better than both benchmarks, check the window first: a short history that misses a fall can make almost any portfolio look safe. Then build yours from your own data and write your three sentences.
Build the risk tab in your workbook. Then write three sentences on the biggest risk it shows and whether you meant to take it on.
Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).