Returns in Singapore dollars when the asset is priced in US dollars

Convert a foreign-currency return into SGD and split it into the asset's return and the currency's return.

When you hold a share or fund priced in another currency, your broker's app shows its return in that currency. If you earn, save and will one day spend in Singapore dollars, the number that matters is what the holding did in SGD. Finding that number is the third of the four questions from lesson 1.1. If you work it out slightly wrong, the error grows over the years.

The two parts of an SGD return

An SGD return has two parts. The first is what the asset did in its own currency. The second is what that currency did against the Singapore dollar, which is called the currency return. The currency return is the end exchange rate divided by the start exchange rate, minus 1. You combine the two parts by multiplying them:

SGD return = (1 + asset return) x (1 + currency return) - 1

Marcus (an invented example) lives in Singapore and earns, saves and will one day spend in SGD. A year ago he bought US$10,000 of a US chip designer, paying S$13,200 at S$1.32 per US dollar. The shares are up 20% in US dollars, and his app shows US$12,000 with a big green gain. When he switches the display to SGD, the green number gets smaller. At lunch a colleague asks whether the stock went up 20% or not. It did, but for Marcus the SGD result is the one that counts.

Over the year the US dollar fell from S$1.32 to S$1.25. Marcus works it through in four steps:

Asset return in its own currency: 20%, or 1.20 in the formula. Currency return: 1.25 / 1.32 - 1 = about -5.3%, or 0.947 in the formula. Multiply and subtract 1: 1.20 x 0.947 - 1 = about 13.6%. Check in dollars: US$12,000 at S$1.25 is S$15,000, against the S$13,200 he paid, and S$15,000 / S$13,200 - 1 = 13.6%.

The dollar check gives the same answer as the formula, so you know the formula is set up correctly.

Why adding the two returns drifts from your statements

If Marcus had added 20% and -5.3%, he would have got 14.7%. The gap of about 1.1 points is the cross term: the currency move applied to the gain as well as to the original sum. Adding the two percentages leaves it out. Lesson 2.3 of Investing in US and global markets from Singapore, "Currency risk is not the same as conversion cost", introduced the formula and said adding is close enough when both moves are small. At analyst depth you never add. The cross term gets bigger as the moves get bigger and as time passes, so a workbook that adds will drift further from your statements every year.

The currency can also turn a gain into a loss. Suppose a US stock rises 3% in US dollars while the US dollar falls 6% against the SGD. The SGD return is 1.03 x 0.94 - 1, about -3.2%, so the SGD investor loses money on a stock that went up. A rising US dollar works the other way: it adds to your SGD return on everything priced in USD, even holdings whose price did not move. Module 3, lesson 3.5, "The dollar cycle and what a strong dollar does to Asian assets", returns to this. The currency part of your return shows up in your statements, and in any single year it can be bigger than the asset part.

Comparing USD factsheets with SGD options

Most index factsheets and many fund factsheets quote returns in USD. Singapore alternatives such as an SGD bond fund or an STI ETF quote returns in SGD. If you put the two figures side by side without adjusting them, you are comparing two different things. Take the USD annual return and the US dollar's annual move against the SGD over the same period. Apply the multiply formula to get the SGD annual figure, and compare it with the SGD options only after that.

Take a world index fund that returned 9% a year over five years in USD, while the US dollar fell 1.5% a year against the SGD over the same five years (invented figures). In SGD that is 1.09 x 0.985 - 1, about 7.4% a year. Over the five years, the gain is 54% in USD and 43% in SGD.

To build a history in a spreadsheet, convert levels, not percentages. Take the index or fund value in USD at each date, multiply it by the exchange rate on that date, and calculate returns from the SGD series you get. Those returns already include the currency effect and the cross term.

Using one exchange rate consistently

Exchange rates move all day, and different sources quote slightly different rates for the same date. Say you use your bank's rate one month, a news site's the next and your broker's after that. The small differences build up and your history stops matching your statements. Pick one rate source and keep to it. MAS (Monetary Authority of Singapore) publishes exchange rate data on its website, so it is a reasonable default. Use the same type of rate every time, such as the daily closing rate. Use the same date convention every time too, such as the last business day of the month. Write the rate source and the date convention in a note at the top of your workbook.

There are two exceptions. For your own purchases and sales, use the rate you actually got, because that is the money that left your account. Lesson 7.2 of Investing in US and global markets from Singapore, "Track your real return in Singapore dollars", explains why. For valuing holdings and benchmarks at month ends and year ends, use your chosen reference rate. The actual rate records what happened to your cash, and the reference rate keeps your comparisons consistent.

Marcus's result splits into 20% from the company and about -5.3% from the currency, which multiply to give about 13.6%. Now take Marcus's split for your own holding. You need the price a year ago and today, in US dollars, and the MAS rate on both dates, so you can show how much of your SGD result came from the company and how much came from the currency.

Take a US-listed holding and restate its last year in SGD using MAS exchange rate data. Then split the result into the asset part and the currency part.

Course

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