Sector Undervalued?25 Aug 2016 17:47
Where Per = Price / Eps
& Justifiable Price = 11.0 / Per * Price
Assuming a reasonable Per of 11.0 for Builders (well below Ftse100 and around Historic average).
Then table1 assuming no increase in Eps
Desc, bdev, bwy, rdw, psn, tw
Price, 494, 2354, 372, 1871, 163
Neps, 44.8, 231, 44.4, 167, 14.9
Per, 11.0, 10.2 8.4, 11.2, 10.9
JP, 493, 2541, 488, 1837, 164
UVal 0, 8, 31, -2, 1
So Prices reflect the assumption of no increase in earnings! (Except rdw.)
Table2 Brokers forecasts of Eps
Desc, bdev, bwy, rdw, psn, tw
Price, 494, 2354 372, 1871, 163
Neps, 53.9, 294, 50.4, 191, 17.3
Per, 9.2, 8.0, 7.4, 9.8, 9.4
JP, 593, 3234, 554, 2101, 190
UVal, 20, 37, 49, 12, 17
Brokers forecasts increase as results approach,
so my computer calcs its own Eps.
Table3 My projected Eps
Desc, bdev, bwy, rdw, psn, tw
Price, 494, 2354, 372, 1871, 163
Neps, 65.5, 333, 69.3, 226, 19.2
Per, 7.5, 7.1, 5.4, 8.3, 8.5
JP, 721, 3663, 762, 2486, 211
UVal, 46, 56, 105, 33, 30
Makes rdw look much the best value, but they have the most debt and smallest divi.
These tables look spot on as I see them now but will probably get mangled again when I post it.
You can download the tables into notebook then to excel using "," as delimiter.
Hi JP
Your system depends on volatility and timing, which is great if you get the timing right.
Btw in order to get rid of (arm) Cgt liabilty, I sold all Shares I was losing money on including Nanoco.
Just found out I cannot buy them back for 30 days, during which time the price could take off.
Timing is not my best attribute!
Despite psn excellent results the sp is still behind the other Builders.
Bol