Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to Wasron,jfgw,Rhyd6,eyeball08,Wondergirly, for Donating to support the site

TJH Annual Review

A helpful place to also put any annual reports etc, of your own portfolios
tjh290633
Lemon Half
Posts: 8295
Joined: November 4th, 2016, 11:20 am
Has thanked: 919 times
Been thanked: 4139 times

TJH Annual Review

#581244

Postby tjh290633 » April 6th, 2023, 8:46 pm

I have just done my Annual Review, and the results are as follows:

.            Income Units              Accumulation   Rebased   Rebased   April   Rebased
Year to Unit Value Div/Unit Unit Value FT30 FT100 RPI RPI
21-Apr-87 1.00 0.00 1.00 1.00 1.00 1.018 1.00
05-Apr-88 0.91 2.86 0.94 0.92 0.91 1.058 1.04
05-Apr-89 1.18 2.72 1.28 1.10 1.05 1.143 1.12
05-Apr-90 1.21 4.24 1.40 1.13 1.14 1.251 1.23
05-Apr-91 1.34 5.42 1.69 1.28 1.26 1.331 1.31
05-Apr-92 1.30 7.52 1.75 1.24 1.26 1.388 1.36
05-Apr-93 1.51 6.91 2.13 1.44 1.46 1.406 1.38
05-Apr-94 1.70 6.27 2.50 1.65 1.65 1.442 1.42
05-Apr-95 1.66 7.48 2.55 1.57 1.62 1.490 1.46
05-Apr-96 1.95 7.38 3.13 1.80 1.90 1.526 1.50
05-Apr-97 2.16 8.40 3.62 1.85 2.21 1.563 1.54
05-Apr-98 3.31 10.00 5.72 2.45 3.05 1.626 1.60
05-Apr-99 3.44 8.46 6.12 2.47 3.21 1.652 1.62
05-Apr-00 3.32 11.33 6.13 2.42 3.35 1.701 1.67
05-Apr-01 3.29 12.42 6.32 2.05 2.89 1.731 1.70
05-Apr-02 3.37 13.02 6.76 1.65 2.69 1.757 1.73
05-Apr-03 2.29 12.10 4.85 0.85 1.85 1.812 1.78
05-Apr-04 2.92 13.38 6.56 1.22 2.25 1.857 1.82
05-Apr-05 3.46 13.06 8.10 1.33 2.51 1.916 1.88
05-Apr-06 4.30 17.42 10.57 1.68 3.06 1.965 1.93
05-Apr-07 4.91 19.42 12.63 1.90 3.31 2.054 2.02
05-Apr-08 4.14 24.32 11.21 1.58 2.93 2.140 2.10
05-Apr-09 2.28 21.17 6.46 0.87 2.01 2.115 2.08
05-Apr-10 3.69 11.06 10.86 1.33 2.91 2.228 2.19
05-Apr-11 4.16 16.71 12.76 1.43 3.03 2.344 2.30
05-Apr-12 4.40 17.73 14.19 1.33 2.96 2.408 2.37
05-Apr-13 5.27 21.83 17.01 1.54 3.29 2.476 2.43
05-Apr-14 5.34 23.05 18.88 1.75 3.38 2.557 2.51
05-Apr-15 5.91 24.98 21.84 1.91 3.47 2.580 2.53
05-Apr-16 5.92 22.67 21.72 1.79 3.17 2.614 2.57
05-Apr-17 6.62 26.21 25.47 2.10 3.76 2.706 2.66
05-Apr-18 6.12 33.19 24.66 1.79 3.62 2.797 2.75
05-Apr-19 6.35 31.25 27.04 1.95 3.82 2.856 2.81
05-Apr-20 4.60 31.57 26.64 1.44 2.77 2.926 2.87
05-Apr-21 5.99 22.54 29.07 1.76 3.46 2.960 2.89
05-Apr-22 6.70 26.76 34.29 1.69 3.86 3.346 3.29
05-Apr-23 6.22 40.34 34.18 1.73 3.93 3.645 3.58

The RPI figure for 2023 is that for February 2023, the latest available.

TJH

stacker512
2 Lemon pips
Posts: 173
Joined: July 16th, 2020, 1:34 pm
Has thanked: 181 times
Been thanked: 51 times

Re: TJH Annual Review

#581254

Postby stacker512 » April 6th, 2023, 9:56 pm

How do you organise your spreadsheet so that you have this history each year?

Div/Unit, is that total amount of dividends per year divided by the ending unit value? Or total dividends in year / number of units?

Thanks

1nvest
Lemon Quarter
Posts: 4464
Joined: May 31st, 2019, 7:55 pm
Has thanked: 707 times
Been thanked: 1385 times

Re: TJH Annual Review

#581274

Postby 1nvest » April 7th, 2023, 12:24 am

FTSE250 -7.6% total return (loss) for year to end of March (and that has declined a additional -2.1% to end of April 5th fiscal year end)! So in that sense TJH HYP accumulation -0.3% year loss was "better".

Image

Both are even worse in real terms. At recent FTSE250 price levels you can lump in at a lower price than if you'd averaged in equal amounts over the last decade. Such events are relatively rare and more often reverse relatively quickly, so hopefully 2023/24 might be a better/good year.

TJH HYP has the higher CAGR to date, but the exponential trend line slope (log linear regressions) for that and the FTSE250 are the same

1nvest
Lemon Quarter
Posts: 4464
Joined: May 31st, 2019, 7:55 pm
Has thanked: 707 times
Been thanked: 1385 times

Re: TJH Annual Review

#581278

Postby 1nvest » April 7th, 2023, 12:47 am

Image

Newroad
Lemon Quarter
Posts: 1100
Joined: November 23rd, 2019, 4:59 pm
Has thanked: 17 times
Been thanked: 344 times

Re: TJH Annual Review

#581329

Postby Newroad » April 7th, 2023, 11:36 am

Hi Terry.

Please remind us if you have a benchmark (you need not)? I've done a search but I cannot find the answer easily with the tools available.

The inclusion of the FT30 and FT100 and various inflation metrics suggests you somehow think in those terms, but given your apparent universe of investment, 1nvest's focus on the FT250 as a comparison seems appropriate (the repetitive refocus on other idiosyncratic metrics, typically not germane to the OP, is arguably less helpful).

Regards, Newroad
Last edited by Newroad on April 7th, 2023, 11:44 am, edited 1 time in total.

tjh290633
Lemon Half
Posts: 8295
Joined: November 4th, 2016, 11:20 am
Has thanked: 919 times
Been thanked: 4139 times

Re: TJH Annual Review

#581330

Postby tjh290633 » April 7th, 2023, 11:41 am

stacker512 wrote:How do you organise your spreadsheet so that you have this history each year?

Div/Unit, is that total amount of dividends per year divided by the ending unit value? Or total dividends in year / number of units?

Thanks

The last row is a direct link to the current position.

At the year end I insert a row above and copy the bottom row as values into that row for 5th April.

Div/unit is divs/yr in money divided by the closing number of income units. This has reduced because of a large withdrawal of cash, documented elsewhere. It includes special dividends and other returns of cash, like Aviva's B share issue.

TJH

tjh290633
Lemon Half
Posts: 8295
Joined: November 4th, 2016, 11:20 am
Has thanked: 919 times
Been thanked: 4139 times

Re: TJH Annual Review

#581334

Postby tjh290633 » April 7th, 2023, 11:47 am

Newroad wrote:Hi Terry.

Please remind us if you have a benchmark (you need not)? I've done a search but I can find the answer easily with the tools available.

The inclusion of the FT30 and FT100 and various inflation metrics suggests you somehow think in those terms, but given your apparent universe of investment, 1nvest's focus on the FT250 as a comparison seems appropriate (the repetitive refocus on other idiosyncratic metrics, typically not germane to the OP, is arguably less helpful).

Regards, Newroad

I tend to regard the HIX (FTSE350HY) index as the most appropriate. I record the FT30, FTSE100 and HIX daily. The similarity with the FTSE250 may be coincidental, perhaps because of my nominally equally weight approach. I don't have many shares in the FTSE250, but have many in the lower reaches of the FTSE 100, plus the obvious index leaders but not at market weighting.

TJH

tjh290633
Lemon Half
Posts: 8295
Joined: November 4th, 2016, 11:20 am
Has thanked: 919 times
Been thanked: 4139 times

Re: TJH Annual Review

#581344

Postby tjh290633 » April 7th, 2023, 11:52 am

1nvest wrote:Image

Thanks for an interesting comparison. As stated above, I think that the apparent alignment with the FTSE250 is coincidental, probably because of my nominally equal weighted approach.

TJH

Newroad
Lemon Quarter
Posts: 1100
Joined: November 23rd, 2019, 4:59 pm
Has thanked: 17 times
Been thanked: 344 times

Re: TJH Annual Review

#581347

Postby Newroad » April 7th, 2023, 12:04 pm

Thanks, Terry.

That makes sense and you may have mentioned it before - my apology for forgetting if so. It wouldn't be off the wall to include comparison to the FTSE350 index as a whole (not just the HY "half") as

(1) It dates back to 1983, which covers the investing period you report on, and
(2) Arguably, it would cover the pluses and minuses of your style (a yield bias) within your chosen universe

I don't see much point in citing the FTSE30 or FTSE100, perhaps you do? I can see some point in citing inflation measures, as certain income methods can be expressed as offsets against such.

Regards, Newroad

tjh290633
Lemon Half
Posts: 8295
Joined: November 4th, 2016, 11:20 am
Has thanked: 919 times
Been thanked: 4139 times

Re: TJH Annual Review

#581354

Postby tjh290633 » April 7th, 2023, 12:26 pm

Newroad wrote:Thanks, Terry.

That makes sense and you may have mentioned it before - my apology for forgetting if so. It wouldn't be off the wall to include comparison to the FTSE350 index as a whole (not just the HY "half") as

(1) It dates back to 1983, which covers the investing period you report on, and
(2) Arguably, it would cover the pluses and minuses of your style (a yield bias) within your chosen universe

I don't see much point in citing the FTSE30 or FTSE100, perhaps you do? I can see some point in citing inflation measures, as certain income methods can be expressed as offsets against such.

Regards, Newroad

When I started we only had the FT30. These other indices are Johnny come lately. Once upon a time there was "Beat the Footsie" in the Investor's Chronicle. That used the FT30 and its constituents as the source. A lot fewer companies and many fewer changes. No automatic promotion or deletion, except if the quote vanished, usually through takeover.

I think the FT350 started after me, but I believe that the FTSE All Share has a longer pedigree. I do not propose going back through over 30 years to add it, but if you feel up to it please feel free to add the index of your choice.

TJH

Newroad
Lemon Quarter
Posts: 1100
Joined: November 23rd, 2019, 4:59 pm
Has thanked: 17 times
Been thanked: 344 times

Re: TJH Annual Review

#581359

Postby Newroad » April 7th, 2023, 12:39 pm

Hi Terry.

Just checked again - the FTSE350 has a base date of 1983, but history only from 1992. I have a sense of deja vu in realising this :(

I understand your reluctance to go back and add in historic information - we'll just have to consider your information in the abstract or in light of the efforts of those such as 1nvest. Thank you for providing it in any case.

Regards, Newroad

1nvest
Lemon Quarter
Posts: 4464
Joined: May 31st, 2019, 7:55 pm
Has thanked: 707 times
Been thanked: 1385 times

Re: TJH Annual Review

#581398

Postby 1nvest » April 7th, 2023, 5:13 pm

tjh290633 wrote:
1nvest wrote:Image

Thanks for an interesting comparison. As stated above, I think that the apparent alignment with the FTSE250 is coincidental, probably because of my nominally equal weighted approach.

TJH

The FTSE250 is more equal weight rare for a single stock to rise to being even >1.5% of the total index weighting (in contrast the FTSE100 can at times have 10% in single stocks and sometimes relatively high individual weightings in a bunch of stocks within the same sector (sector concentration/tilting)). Large/rising stocks migrate into the FTSE100, which might be considered a form of 'top-slicing' winners. Faltering/down stocks in the FTSE100 that haven't totally failed drop down into the FTSE250, 'value' plays, might continue to decline, could rebound and return back into the FTSE100; As a alternative to 'value' plays in the way of being measured by dividend yield. At the bottom end faltering smaller caps are ejected, replaced with rising alternatives, potential future 'value' plays that in some cases might see them rise all the way through and out into the FTSE100.

Has many similarities to your 'tweaked HYP' IMO, whilst the historic actual total returns somewhat compare in confirmation of that.

Also include a bunch of Investment Trusts, haven't looked recently, but IIRC something like 40 of the 250 total stocks being IT's, so a 16% type weighting assuming equal value (which they're not, so just a rough guide).

Whilst there were no retail options for FTSE250 exposure back in the late 1980's, as the index wasn't even created until the early 1990's, they did back calculate the FTSE250 index to 1986.

End of Dec 1985 month end total return index values up to end of March 2023

Code: Select all

363.2
373.9
407.5
439.8
456.4
442.4
463.0
443.2
463.6
439.3
463.5
477.1
483.8
531.3
569.0
587.7
597.3
635.9
691.3
734.6
702.7
750.1
536.9
481.4
543.7
581.5
582.5
577.7
602.3
606.8
637.5
646.8
608.6
633.3
657.3
636.2
625.8
710.4
721.5
739.6
736.7
747.7
743.7
795.9
804.9
794.5
725.8
755.4
793.2
775.8
740.5
735.3
692.9
756.1
774.4
759.1
672.5
609.1
640.6
656.3
665.6
658.9
757.4
795.2
795.4
784.9
761.7
804.6
840.5
851.7
833.6
786.0
781.3
821.5
840.4
805.2
910.3
936.0
861.8
781.8
748.0
821.3
867.4
910.7
992.1
1027.6
1059.5
1088.3
1100.6
1116.2
1144.9
1174.0
1251.0
1227.2
1265.3
1254.1
1368.8
1478.9
1438.2
1367.2
1381.7
1306.6
1255.6
1342.8
1411.9
1296.8
1308.9
1305.5
1311.0
1265.7
1274.8
1297.9
1338.2
1389.2
1370.3
1463.7
1501.6
1519.7
1503.4
1533.1
1562.0
1607.1
1647.1
1695.7
1788.9
1777.5
1720.8
1677.5
1756.3
1751.5
1769.4
1777.1
1807.4
1855.1
1884.5
1858.4
1832.6
1837.1
1816.5
1847.3
1899.0
1998.4
1927.2
1938.9
1999.6
2036.5
2184.7
2326.7
2368.3
2496.5
2333.6
2329.9
2039.0
1940.9
2059.8
2103.1
2087.4
2165.0
2266.4
2369.4
2536.6
2450.6
2551.3
2605.5
2632.4
2493.7
2471.5
2729.5
2846.2
2736.1
2862.1
2879.0
2760.5
2781.4
2954.2
3040.0
3170.9
3005.7
2990.0
2901.3
2964.7
3055.7
3022.3
2776.0
2925.2
3005.0
2886.6
2793.4
2815.2
2362.2
2482.1
2712.8
2760.7
2725.3
2724.6
2890.3
2872.3
2843.5
2589.9
2260.1
2301.6
2036.8
2104.8
2177.6
2069.3
1930.2
1946.5
1915.3
2129.5
2342.9
2421.6
2605.2
2743.1
2683.9
2822.4
2824.0
2876.0
2993.6
3123.6
3126.1
3109.7
3038.9
3159.4
3039.4
3079.7
3179.7
3214.6
3352.8
3544.2
3669.9
3723.5
3668.9
3471.3
3679.3
3820.2
3952.4
4037.1
4152.2
4037.1
4370.4
4625.7
4835.4
4991.6
5214.9
5241.0
4944.2
5021.7
4997.3
5140.1
5363.5
5576.7
5750.9
6034.4
6004.4
6006.6
6346.7
6488.3
6598.2
6291.1
6197.9
6192.8
6054.2
6408.9
5914.8
5874.3
5456.5
5569.5
5549.9
5621.5
5592.4
5101.4
4952.4
5258.6
4434.5
3545.3
3452.4
3618.3
3569.7
3468.4
3668.2
4346.4
4384.3
4306.1
4658.7
5147.2
5348.9
5210.7
5241.5
5481.1
5451.6
5526.4
6023.6
6154.4
5733.6
5584.4
5944.0
5882.5
6318.0
6517.6
6388.6
6974.2
6934.6
7038.5
7034.4
7304.4
7347.1
7284.3
7065.9
6453.2
6035.4
6456.8
6371.4
6256.4
6685.3
7123.6
7195.4
7135.9
6614.9
6865.2
7009.8
7198.0
7418.3
7561.4
7640.2
7872.6
8305.9
8751.7
8908.5
8942.8
9217.4
8880.1
9589.8
9448.5
9649.9
10039.0
10049.6
10373.7
10223.8
10930.0
10655.1
10377.2
10525.2
10358.5
10230.5
10510.5
10198.7
10302.6
10559.1
10738.8
10910.1
11582.1
11483.8
11766.3
12248.8
11853.3
11976.9
11615.1
11352.8
11673.7
11906.1
11937.9
11318.6
11423.9
11672.5
11613.3
11905.0
11299.3
12029.3
12370.2
12494.9
12294.4
12323.9
12726.0
12804.8
13273.8
13445.8
13932.0
14215.9
13796.9
14142.6
14190.2
14273.1
14558.8
14393.4
14984.2
14668.4
14298.8
14167.9
14802.4
15246.4
15269.9
15339.4
15236.0
14990.4
14000.8
13713.9
13024.2
13961.5
14349.3
14339.2
14907.8
14303.7
14713.3
14907.0
14739.6
15192.2
15297.1
15942.0
16803.2
16275.2
14919.4
11693.5
12779.4
13273.6
13369.3
13259.2
13964.0
13626.7
13580.5
15286.9
16229.2
16055.0
16627.4
17142.4
17953.1
18133.0
17917.6
18407.0
19362.7
18532.8
18623.7
18180.8
18986.7
17761.0
17108.0
17205.0
16871.9
16669.8
15275.9
16534.0
15673.4
14154.0
14788.7
15882.3
15667.0
16558.5
16627.3
15896.6


See also https://uk.investing.com/indices/ftse-2 ... rical-data

Not perfectly aligned values as my accumulation total return index value dating back to Dec 1985 had monthly % changes applied. Generally that washes out, is close enough (better than nowt).

More than just being a coincidental comparison IMO. A better 'benchmark'.

1nvest
Lemon Quarter
Posts: 4464
Joined: May 31st, 2019, 7:55 pm
Has thanked: 707 times
Been thanked: 1385 times

Re: TJH Annual Review

#581785

Postby 1nvest » April 9th, 2023, 7:11 pm

Shh! The boards are quiet, returns are low, little/no excitement.

Nobody buying, some maybe even contemplating selling.

Yet to me a AIM of FT250/gold ratio is shouting out to dump gold and go all in on FT250 !!!

Low PE, you can buy in at a recent price level that's less than the average share price if you'd averaged in over the last 10 years.

Guess others might return to more activity once prices have rebounded 30%+

Was it Buffett who suggested investors were strange, tended to do the opposite to their grocery shopping, preferring only to buy stocks at higher prices, ignoring bargains in expectation of better bargains to come?

moorfield
Lemon Quarter
Posts: 3554
Joined: November 7th, 2016, 1:56 pm
Has thanked: 1588 times
Been thanked: 1417 times

Re: TJH Annual Review

#581875

Postby moorfield » April 10th, 2023, 10:31 am

1nvest wrote:
Yet to me a AIM of FT250/gold ratio is shouting out to dump gold and go all in on FT250 !!!




How strange. The Dow/Gold ratio is shouting out to dump stocks and go all in on gold!!! But I digress.

1nvest
Lemon Quarter
Posts: 4464
Joined: May 31st, 2019, 7:55 pm
Has thanked: 707 times
Been thanked: 1385 times

Re: TJH Annual Review

#581995

Postby 1nvest » April 10th, 2023, 4:26 pm

moorfield wrote:
1nvest wrote:
Yet to me a AIM of FT250/gold ratio is shouting out to dump gold and go all in on FT250 !!!

How strange. The Dow/Gold ratio is shouting out to dump stocks and go all in on gold!!! But I digress.

FT250 18600 gold 1600/oz = 11.6 FT250/Gold ratio, moderately low(ish). Dow/Gold is moderately high(ish). Cut out the middle man (gold) and directly swap US stock for FT250, or given the similarities ... a HYP

1nvest
Lemon Quarter
Posts: 4464
Joined: May 31st, 2019, 7:55 pm
Has thanked: 707 times
Been thanked: 1385 times

Re: TJH Annual Review

#582239

Postby 1nvest » April 11th, 2023, 5:25 pm

Just out of interest, I compared the yearly average of TJH HYP individual best performing half, and average of the worst half, assuming each stock were initially equal weighted, to that of the yearly best/worst of FT250 and Gold

i.e. rank/sort yearly HYP individual stocks from best yearly change down to worst, and average the top half of that set as the years 'average of best' and average the bottom half as the years 'average of worst'.

Image

Somewhat highlights how stock gains arise out of the better performing stocks outweighing the cost/loss of the worst performing (a stock that loses -50% one year needs to gain +100% the next to get back to break-even (geometric), but that has a +25% arithmetic average).

The more holdings/stocks the less £££ weighting in each individual holding, but where the extreme best (and worse) cases tend to be taller (deeper).

No particular conclusion, just sharing the observation.


Return to “Portfolio Management & Review”

Who is online

Users browsing this forum: No registered users and 40 guests