some eps estimates seem to be wrong

Hi,

please look at my screen “ACC” and view the saved report “ACC”.
At least the first four stocks (without PBR) seem to have wrong estimate data.

For example
Symbol KB
EPS t-3 0.23
EPS t-2 5.56
EPS t-1 4.15
CurrYEst 3726.31
NextYEst 4695.27

for example KB in Reuters
2011 5.80
2012 3.90
2013 2.98
2014e 4.41
2015e -

or
Symbol BRK.B
EPS t-3 4.14
EPS t-2 5.98
EPS t-1 7.90
CurrYEst 9607.75
NextYEst 10329.59

Symbol RDY
EPS t-3 1.46
EPS t-2 1.65
EPS t-1 1.81
CurrYEst 126.86
NextYEst 142.07

Symbol NVO
EPS t-3 1.05
EPS t-2 1.37
EPS t-1 1.73
CurrYEst 10.31
NextYEst 11.63

Thanks for pointing this out, obviously of concern.

The common theme is that you are reporting ADRs except for BRK.B. In the latter case the EPS looks correct for the trailing quaters, but the forward estimates look like they relate to the class A shares, BRK.A

I also expect that there may be a currency problem with the ADRs, some figures are in USD and others may be in the company’s home currency.

Hi olikea,

yes youre right it could be a currency problem for NVO and KB. RDY shouldnt be an ADR or am i wrong here. And BRK.B seems to have the estimates of BRK.A.

We’ve know about Berkshire A&B problem and which share class is deemed “primary”. This is not usually a big problem, but with Berkshire the magnitude of the price difference is extreme, and the “primary” connotation has changed from A to B a few years ago (it also depends on the data provider). I’ll take a look at the others, but ADR shares per listing is probably the cause.

With the Canada project we’re trying to clean up some of these outstanding problems which are pretty rare in the big picture.

Thanks

We’ll be able to take care of these problems when Canada is launched (any day now). Definitely a problem with ADRs & Berkshire.

Do not release Canada:

  1. without fixing the 0 values when you download the excel spreadsheet
  2. without providing an extended XIU.TO in the hedge section.