By Tom Jacobs, The Motley Fool
Filed under: Investing
Google without a doubt is an astounding company that has changed all of our lives. Research that was impossible, or at least incredibly costly in time and money, is now possible, and at fractions of both. Outsiders probably know only a handful of things that Google is going to dazzle us with. From Google Fiber today, to self-driven cars and cyborg glasses ahead, Google brainiacs will unleash innovation after innovation, without a doubt.
But, as with any public company, it’s a stock, too. Any choice to buy, sell, or hold requires scrutinizing earnings quality indicators that, if low quality, are good predictors of poor stock performance ahead. Days sales outstanding, or DSOs, which is the time it takes revenues to turn into cash in the bank, are job one in earnings quality analysis. And Google’s year-over-year quarterly increase in its DSO for seven of the last eight quarters raises eyebrows.
(Disclosure: My co-author John Del Vecchio and I were Authors@Google, and I intend no ungratefulness here to our most generous hosts. But I know that my Google friends expect no less than callin’ ’em as I see ’em.)
How long to get paid?
Days sales outstanding is calculated for our quarterly analysis as (accounts receivables/revenues) * days in the quarter.
Examine DSOs in two ways. First, look at DSOs year over year to correct for seasonal variations in a business. And then, to smooth it out to capture trends more accurately, take the LTM (last 12 months) average per quarter. If the latter increases consistently each quarter, there could be trouble for the stock, regardless of the overall market‘s broad race to the sky that we’ve seen for the past four years. Look at eight quarters of LTM to perceive the trend over more time. And quarterly year-over-year comparisons can show poor trends that may show up in LTM numbers.
The following table examines year-over-year quarterly DSOs, and then the more important sequential change in LTM DSOs at four companies competing with each other fiercely in many areas: Google , Apple , Microsoft , and Yahoo! . There’s clearly a big fifth in Facebook, but we lack enough data for anything meaningful on DSOs so far.
|
Company and Calendar Quarter |
Q4 2012 |
Q3 2012 |
Q2 2012 |
Q1 2012 |
|---|---|---|---|---|
|
Google: Quarterly DSOs |
48 |
46 |
45 |
45 |
|
Year-Over-Year |
+4 |
+3 |
+1 |
+1 |
|
LTM DSO Avg |
46 |
45 |
44 |
44 |
|
Seq. LTM Change |
+1 |
+1 |
0 |
0 |
|
Yahoo ! Quarterly DSOs |
67 |
76 |
74 |
74 |
|
Year-Over-Year |
+1 |
+7 |
+4 |
+1 |
|
LTM DSO Avg |
73 |
73 |
71 |
70 |
|
Seq. TLM Change |
0 |
+2 |
+1 |
0 |
|
Microsoft : Quarterly DSOs |
52 |
74 |
67 |
64 |
|
Year-Over-Year |
0 |


