Examples of the calculation of portfolio turnover from the Manager's Report and Financial Statement of unit trusts.
1. Definitions
Total during period:
| a) | purchases, | b) | sales. |
| c) | at start of period, | |
| d) | at end of period. |
Let M be the multiplying factor if the start and end is not exactly a year. If this is six months then M = 2.
T = portfolio turnover % per annum :
100 x M x minimum of a)
and b)
------------------------------
the average of c) and d)
This is a conservative formula for turnover. It is hardly effected by the turnover of units of the trust. If there are substantial purchases of units, then the purchases a) will be larger than the sales b). Therefore b) is used to calculate T. But b) is not effect by the purchases of units, only by the cashing-in of units. But any cashing-in can probably be paid for from the purchases.
It is certainly to be hoped that the turnover of units does not effect portfolio turnover. Otherwise existing unit holders are constantly paying dealing charges resulting from this turnover.
2. Sector turnover
For a sector four definitions of portfolio turnover are helpful.
T1 = average of T for each fund in the sector.
T2 = median of T for each fund in the sector.
We define T3 to take into account fund size.
Suppose S1 = the sum of M times the minimum of a) and b) for each fund and S2 = the sum of the average of c) and d) for each fund.
T3 = 100 x S1/S2
The Office of National Statistics publishes total sales and purchases for various sectors, such as unit trusts and investment trusts, prompting us to look at the sum of the average of a) and b) divided by S2. We need to adjust for M, so that:
T4 = sum over the funds of M times the average of a) and b) divided by S2.
Calculated from the data below
| Sector | number | T1 | T2 | T3 | T4 |
|---|---|---|---|---|---|
| UK | 14 | 75 | 75 | 76 | 85 |
| UK Smaller Companies | 4 | 70 | 75 | 62 | 69 |
| European | 8 | 109 | 65 | 92 | 100 |
| American | 1 | 89 | 89 | 89 | 97 |
| Far East | 6 | 164 | 117 | 155 | 192 |
| International | 1 | 77 | 77 | 77 | 80 |
| Index tracking | 1 | 5 | 5 | 5 | 8 |
We like the T3 measure of turnover best. It takes into account the size of funds, but not the turnover of units. The difference T4-T3 results approximately from the purchase/cashing-in of units.
3. The data
| Type of trust: | Time period | £ millions | ||||||
|---|---|---|---|---|---|---|---|---|
| UK | T % | from:to | M | a) | b) | c) | d) | |
| Aberdeen: | |||||||
| Technology | 122 | 1/12/0:30/10/1 | 1 | 1,279 | 1,082 | 1,028 | 741 |
| Dresdner: | |||||||
| RCM UK Growth | 131 | 1/10/0:30/9/1 | 1 | 296 | 313 | 173 | 280 |
| RCM UK Mid-Cap | 83 | 16/4/1:15/10/1 | 2 | 52 | 76 | 160 | 90 |
| Jupiter: | |||||||
| UK Growth Exempt | 53 | 13/3/00:12/3/1 | 1 | 97 | 66 | 132 | 137 |
| Norwich Union: | |||||||
| UK Equity | 94 | 1/3/1:31/8/1 | 2 | 308 | 295 | 799 | 457 |
| UK Equity Income | 81 | 1/3/1:31/8/1 | 2 | 59 | 62 | 147 | 144 |
| UK Growth | 58 | 1/3/1:31/8/1 | 2 | 186 | 78 | 227 | 313 |
| Merrill Lynch: | |||||||
| UK General | 70 | 1/3/1:31/8/1 | 2 | 19 | 24 | 58 | 51 |
| J. P. Morgan Fleming: | |||||||
| Premier Equity Income | 48 | 16/11/0:15/11/1 | 1 | 149 | 150 | 326 | 290 |
| Premier Equity Growth | 101 | 1/8/0:31/7/1 | 1 | 831 | 685 | 635 | 727 |
| Schroder: | |||||||
| UK Enterprise | 81 | 17/12/0:16/12/1 | 1 | 546 | 812 | 881 | 462 |
| UK Equity | 18 | 21/6/0:20/6/1 | 1 | 213 | 195 | 1,116 | 1,080 |
| St James' Place: | |||||||
| UK and General Progressive | 64 | 1/1/01:31/12/1 | 1 | 266 | 331 | 393 | 444 |
| Solus: | |||||||
| Technology Plus | 51 | 1/1/1:30/6/1 | 2 | 390* | 328* | 1,552* | 999* |
| *£ thousands |
UK smaller companies
| Dresdner: | |||||||
| RCM UK Smaller Companies | 32 | 16/2/0:15/2/1 | 1 | 61 | 87 | 232 | 152 |
| J. P. Morgan Fleming: | |||||||
| UK Smaller Companies | 92 | 1/2/1:31/7/1 | 2 | 106 | 119 | 256 | 203 |
| Jupiter: | |||||||
| UK Smaller Companies | 99 | 1/2/0:31/1/1 | 1 | 103 | 68 | 88 | 120 |
| Norwich Union: | |||||||
| UK Smaller Companies | 58 | 1/2/0:31/1/1 | 1 | 17 | 15 | 53 | 49 |
European
| Aberdeen: | |||||||
| European Growth | 60 | 16/2/0:15/2/1 | 1 | 241 | 153 | 214 | 292 |
| Dresdner: | |||||||
| RCM European | 65 | 1/6/0:31/5/1 | 1 | 61 | 65 | 110 | 77 |
| Merrill Lynch: | |||||||
| European Growth | 25 | 26/7/0:25/7/1 | 1 | 133 | 182 | 652 | 424 |
| New Europe | 29 | 1/2/1:31/7/1 | 2 | 9.0 | 14.2 | 71 | 52 |
| M&G: | |||||||
| European | 155 | 16/6/1:31/10/1 | 2.66 | 145 | 165 | 359 | 281 |
| Norwich Union: | |||||||
| European Equity | 197 | 16/10/0:15/4/1 | 2 | 315 | 375 | 344 | 296 |
| St. James's Place: | |||||||
| Greater European Progressive | 65 | 1/12/0:30/11/1 | 1 | 369 | 301 | 470 | 460 |
| Schroder: | |||||||
| European | 281 | 16/11/0:15/11/1 | 1 | 802 | 776 | 312 | 239 |
North American
| Norwich Union | |||||||
| US Growth | 89 | 16/10/0:15/4/1 | 2 | 34 | 29 | 64 | 66 |
Far East
| Dresdner: | |||||||
| RCM Japan | 103 | 24/4/0:23/4/1 | 1 | 47 | 87 | 74 | 17 |
| RCM Japanese Special | 106 | 8/3/0:13/3/1 | 0.99 | 48 | 92 | 77 | 12 |
| Oriental Assets | 129 | 16/9/0:15/3/1 | 2 | 9 | 9 | 16 | 12 |
| RCM Tiger | 248 | 16/5/1:15/10/1 | 2 | 44 | 51 | 43 | 28 |
| J. P. Morgan Fleming: | |||||||
| China Dragon | 301 | 1/5/1:15/11/1 | 1.83 | 44 | 46 | 28 | 26 |
| Norwich Union: | |||||||
| Japan Growth | 97 | 16/10/0:15/4/1 | 2 | 44 | 19 | 29 | 49 |
International
| St. James's Place: | |||||||
| International | 77 | 1/8/0:31/7/1 | 1 | 194 | 210 | 269 | 235 |
Index tracking
| Norwich Union: | |||||||
| UK Index Tracking | 5 | 16/10/0:15/4/1 | 2 | 31 | 13 | 523 | 527 |
Taking cash balances away from total assets c) and d), slightly increases the above values for portfolio turnover T, by an amount which is generally quite small such as 1-2%.
The above unit trusts are a random collection for which the author has the accounts, for various reasons. Norwich Union Oriental Growth was excluded. The turnover could not be calculated correctly, because of a conversion from the South East Asia Fund. Marks and Spencer High Income was also excluded because most of the investments are bonds rather than shares.