Run a geopolitical scenario through your holdings

You will be able to build a scenario sheet that runs one geopolitical shock through each of your holdings.

Marcus, an investor in Singapore, holds eight investments worth roughly S$202,000 (an example figure, like every amount and percentage that follows) and wants to know what a sudden oil spike would cost them in Singapore dollars. You can already trace a shock through its channels and name which of your holdings sit in its path. The next step is to put a number on that exposure, in SGD.

The number will not be precise, and that is acceptable. The value is in thinking the shock through on a calm day with your rules beside you, so you are not doing it for the first time during the headlines. Allow about thirty-five minutes. Before you start, have your holdings and their values in SGD, and the risk dashboard from lesson 2.8.

Choosing a shock and writing it down

Choose a shock that moves prices through one main channel, so you can trace its effects. An oil price spike, new export controls on chips, a sharp rise in the US dollar or a jump in tariffs between the US and China all work. The shock can be based on a past event or made up. Either way, write it down precisely. "Oil rises 40% over two months after a supply disruption in the Gulf" is usable. "Trouble in the Middle East" is too vague to trace through anything.

Marcus chose a made-up oil shock: crude up 40% in two months, inflation expectations rising, and central banks holding rates rather than cutting.

Setting up the Scenario tab and estimating each holding

Add a tab called Scenario to your spreadsheet. Give it one row per holding and seven columns: holding, value in SGD, main channel, likely direction, estimated effect in percent, estimated effect in SGD, and a note on why. A channel is how the shock reaches a holding. The channels to use are energy costs, inflation and rates, the US dollar, supply chains and regional growth. Fill the first three columns from this module's material. If a holding sits in more than one channel, put the strongest in the column and mention the other in the note.

Then estimate the effect on each holding. This is judgment rather than calculation, so keep the estimates rough and round. Use each holding's beta from lesson 2.4, which is how much it tends to move when the stock market moves. Use its duration from lesson 2.5, which is how far a bond's price moves when interest rates change, and its sensitivity to oil from lesson 4.2. Then convert each percentage into SGD.

Marcus's eight rows came out like this:

World ETF, S$91,000: minus 6%, or minus S$5,460. Higher oil and stickier rates weigh on shares broadly, partly offset by energy producers and any rise in the US dollar.

SGD bond fund, S$30,000, duration 6.5: minus 2%, or minus S$600. Inflation worries push bond yields up, and the size of the fall relates to the fund's duration.

STI ETF, S$20,000: minus 4%, or minus S$800. Slowing regional growth hurts a regional index ETF.

Bank shares, S$16,000: minus 5%, or minus S$800. Credit worries on energy-linked loans and a weaker region.

S-REIT (a Singapore real estate investment trust), S$12,000: minus 7%, or minus S$840. Higher rates hit REIT valuations.

SGX chip supplier, S$8,000: minus 8%, or minus S$640. Chip equipment suppliers suffer when equipment orders slow.

US chip designer, S$15,000: minus 10%, or minus S$1,500. Its value rests on distant profits, and a company like that is hurt when rates rise.

T-bills, S$10,000: treated as unaffected, so zero.

Reading the total against your risk dashboard

Add up the SGD column and express it as a percent of the portfolio. Marcus's total is minus S$10,640, about minus 5.3% of roughly S$202,000.

Compare that total with your risk dashboard to see whether the scenario looks like a bad month or a rare extreme event. Marcus's one-month 95% Value at Risk is about S$12,900, the loss they should exceed in only about one month in twenty. Their expected shortfall, the average loss in those worse months, is about S$17,300. Both were worked out in lesson 2.6, "Value at Risk, expected shortfall and fat tails". The scenario loss sits below both, so it is roughly a bad month in their history and not a once-in-a-decade event. That matches intuition: an oil spike on its own is painful for a diversified portfolio but not catastrophic.

Next, read down the rows for shared exposures and holdings that move together. After the world ETF, Marcus's largest losses were the US chip designer and the S-REIT, and both came from the same exposure: higher rates applied to long-duration valuations, meaning prices that rest on profits or income far in the future. The bank and STI ETF lines moved together, which confirmed what Marcus's correlation matrix, the table showing how pairs of holdings have moved together, had already warned.

Writing the decision before a shock arrives

The final step is the one that matters. Write three or four sentences on whether the result calls for any change to your rules. Include the total, the comparison with your own risk measures, the decision, and anything you learned for later. Deciding in advance stops a real shock from turning into an improvised trade, because the answer is already written down.

Marcus wrote that the shock costs about S$10,600, which is within a bad month according to the dashboard, so no rule changes. They would rebalance only if the equity weight fell outside its band, as their investment policy says. They also noted that the bank, STI ETF and REIT holdings move together on rates and regional growth, and planned to set a combined limit for them when writing a risk rulebook in module 11. Marcus did not decide to sell anything.

A finished sheet has every holding on its own row with a channel, a direction, a rough size and a reason, a total in SGD and in percent, and three or four sentences of decision. Now build yours for one shock and write the decision before you close the file.

Build the scenario tab for one shock, add up its estimated effect on your portfolio in SGD and write whether you would change anything.

Course

Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).