I have been researching WHSmith as a potential holding to add (we don't hold it currently) and decided to run six years worth of WHSmiths' AR financial statements data into my analysis spreadsheet. I thought I'd share some of the results on TLF. First off here some of the key ratios and figures. Note where a value is assumed e.g. sales, EBIT, market cap, then the unit is £million, except EPS, DPS, FCFps which are in £. Other datas are % or straight ratios. Sorry the spreadsheet isn't that exotic....as my time isn't that plentiful!
I got the dividends from either dividendmax and for the share prices I used the approximate value at the month when the annual report figures were done for the year.
Code: Select all
| PRICE | DIV
2019 | |
2018 | 2000 | 54.1
2017 | 1822 | 48.2
2016 | 1550 | 43.9
2015 | 1500 | 39.4
2014 | 1155 | 35
2013 | 830 | 30.7
and here's some growth figures, including PEG. You can ignore the columns, "earliest, ..., workings", they are just there to aid calcuation.
in a little while I'll try to upload some attempts at running some Share Price valuation models over the data.
Matt