Work out both your account's return and your fund's return, and explain why the two differ.
You open your fund's factsheet and see one return. You add up what you put in and what the account is worth now, and you get a different figure, often a worse one. Both numbers can be correct at the same time, because they answer different questions. Anyone analysing an investment needs both, and needs to know which is which.
A fund manager controls what the fund holds. The manager does not control when investors add money or take it out. If a fund's reported return included the effect of those deposits and withdrawals, managers would look good or bad because of their clients' timing. So the reported return has to strip that effect out.
A time-weighted return does this. You split the period at every cash flow, work out the return for each sub-period, then chain the sub-period returns by multiplying them. The size of a deposit does not change the result, because the time-weighted return measures what one dollar left in the portfolio for the whole period would have done. Funds report time-weighted returns as a rule. The Global Investment Performance Standards (GIPS), a code many managers follow, are built around them. It is the right number for judging the manager, or for judging the investments you chose.
A money-weighted return answers a different question: what rate your actual money earned, given when you added it. It is the single yearly rate that turns all your deposits and withdrawals into the ending value. This rate is the internal rate of return (IRR) of your cash flows.
Marcus's account is mostly a world equity ETF. His figures are made up, and they are the same made-up figures used for Marcus's account throughout the course.
Two years ago he put in S$70,000. In year one the portfolio rose 14%. During that year he received a bonus plus some money from his late father's estate, and on the first working day of year two he added another S$70,000. In year two the portfolio fell 18%.
His ETF factsheet shows a loss of about 3.3% a year over the two years. His own sum feels much worse: he has put in S$140,000 and the account is now worth S$122,836.
To get the time-weighted return, split the two years at the second deposit and chain the two yearly returns: 1.14 x 0.82 = 0.935. That is about -6.5% over two years, or about -3.3% a year, which matches the factsheet. If he had added S$7 million at the start of year two instead of S$70,000, the time-weighted return would be the same.
His money-weighted return is about -8.4% a year, five points a year worse than the fund. Most of his money arrived just before the bad year, so most of his money went through the bad year.
The order of the two years affects one measure and not the other. Swap them so the 18% fall comes first and the 14% rise second, and the time-weighted return stays identical, because multiplication does not care about order. The money-weighted return does change. Marcus's large second deposit would have arrived after the fall and caught the recovery, and his money-weighted return would have been well above the fund's.
You don't solve for IRR by hand. Excel and Google Sheets both have an XIRR function. It takes a column of dated cash flows and returns the yearly rate. Investing in US and global markets from Singapore, lesson 7.2, "Track your real return in Singapore dollars", set up the basic method. Money going in is negative and money coming out is positive. Your current value goes in as a final positive row dated today, as if you sold. For Marcus the rows are -S$70,000 on the first day of year one, -S$70,000 on the first day of year two, and +S$122,836 on the last day of year two.
Three refinements make the figure reliable for a real account:
Withdrawals count, and that includes dividends taken as cash. A payout that went to your bank account and was spent has left the portfolio, so it is a positive row dated on its pay date. Dividends that stayed in the account and were reinvested need no row. Use account-level flows, not trades. Buying an ETF with cash already in the account is not a cash flow. Only money crossing the border of the account counts: transfers in, transfers out and payouts taken. Keep a time-weighted series beside the XIRR. Record the account value just before each deposit so you can work out each sub-period's return and chain them by multiplying (1 + return) for each one. Without those values you cannot tell how much of your result came from your picks and how much came from your timing.
If you can't get the value on the exact day of a deposit, use the closest month-end value and note that you did so. A small dating error matters much less than a missing deposit.
The gap between the two returns is information in itself. If your money-weighted return trails your own portfolio's time-weighted return year after year, your timing of deposits and withdrawals is costing you. Part of any gap is luck, such as a bonus that happens to arrive before a fall. Part of it is behaviour, such as adding money after good years and holding back after bad years. Behavioural Finance: why you make the money mistakes you make, lesson 1.3, "The behaviour gap between fund returns and investor returns", covers those behavioural causes.
For every account, carry two numbers. The time-weighted return tells you how good your choices were, and lesson 1.6 is where you compare it with a benchmark. The money-weighted return tells you what you earned. The gap between them tells you what your timing cost or added.
Start with the second one: gather every deposit and withdrawal for one account, with dates, from your bank and broker statements.
For one account, list every deposit and withdrawal with its date. Then work out the account's money-weighted return with XIRR.
Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).