1) I'm trying to look at last 10 quarters of YLO financials on Morningstar, but I am seeing some inconsistency versus the Q12011 press release. Yellow's release indicates that 3/2010 quarter had sales of $339.7M but Morningstar is showing Revenues of $408.1M. Any idea why the difference? This is an important point because on the surface the Q1 2011 report shows a dramatic decline in revenues. If you believe the Morningstar financials, this drop in revenues looks anomalous. If you believe the Yellow press release, the Q1 quarter just looks like a weak quarter for them, and historically they do drop off revenue dramatically in that quarter. Which is it?
2) Where are they showing the dividend on their cash flow? If there were no DRIP, I would expect the dividend at 65 cents per share to take up something like $325M per year, or $81M per quarter. Under "Dividend Paid" I see a similar number for Q1 2011 but all of the prior quarters on Morningstar show dividends in the $5M to $25M range each quarter for prior quarters. Is Morningstar just mangling data, or are they showing the dividend another way?
3) For quarters prior to Q1 2011, Morningstar is showing debt issued far in excess of debt repaid on the cash flow. The balance sheet shows no growth in long term debt, but there is a growth in "Other Long Term Liabilities". What liabilities are these?
Did Yellow increase debt levels during last five quarters each quarter except for Q1 2011? They have plenty of free cash flow with which to pay a dividend. I don't see why they would need to increase debt?
Can someone point me to a web site that would give me 10 quarters of correct data (preferably downloadable to Excel) for Yellow's financials? I get the feeling Morningstar isn't giving a correct view.
There appears to be a serious error on page 3 of the Q1 2011 Financial Statement PDF that Yellow released. Page 3 is the income statement, and it shows Q1 2011 versus Q1 2010. Q1 2010 revenue is being reported as $339.7M.
The problem is if you go back to Yellow's original filing for Q1 2010, in that income statement the revenues are reported as $401.1M. Further, all of the data vendors like Reuters and Morningstar are using the $401.1M number originally reported.
Does someone know what is the basis of the $339.7M number? Does it represent some kind of adjustment to the original report?
This is an important error to catch. If you rely on the incorrect numbers in the Q1 2010 filing you are likely to believe that Yellow's revenues have not fallen much versus a year ago. If you look at the real original reported numbers, the Q1 2010 income statement represents a very substantial shrinkage of revenues.
Should have read: "If you rely on the incorrect numbers in the Q1 2011 filing you are likely to believe that Yellows revenues have not fallen much versus Q1 2010 a year ago. If you look at the real original reported numbers from Q1 2010, the Q1 2011 income statement shows a very substantial shrinkage of revenues."