Is DELL Cooking the Books?
As accounting geeks, we are always on the lookout for examples of misleading company financial reports. In particular, it is a neat find when a company has beaten earnings by a penny or two for several consecutive quarters due to accounting items over which management has discretion. Examples of such discretionary items include the allowance for doubtful accounts and warranty reserves.
Accounting rules require companies to recognize sales and the related expenses in the same period. However, if a product is warrantied for three years after the sale (as DELL products often are) this can be difficult. In such cases, management is required to estimate the future warranty expense and charge the estimated amount when the sale is made. The charge is accounted for as a warranty reserve, and future actual warranty costs act as a reduction to the reserve rather than showing up on the income statement directly. If management’s estimate turns out to be incorrect (intentionally or unintentionally) the amount reserved will be adjusted in the future periods when necessary.
Because management has a good deal of discretion when estimating the costs (especially during quarterly reports - which are not audited as are the annual ones) skeptical investors call reserve accounts “piggy banks.” If management has a good quarter and beats earnings by several cents they could estimate higher than normal warranty expenses, and smooth out the earnings by reporting less in the good time. Then, in a bad quarter they could estimate a lower warranty expense to take some of it back. Which leads us to the following article we found regarding DELL.
Research Firm: Dell Warranty Accounting ‘Troubling’ - Warranty Accruals - CRN
New questions are being raised about the way Dell accounts for its warranty accruals.Friedman, Billings, Ramsey Research (FBR), an Arlington, Va.-based research firm, on Friday said its study of Dell’s books “points to at least three troubling conclusions” in the way that the computer hardware giant has handled warranty accruals in its financial reports.
FBR said in its report that Dell’s accounting for warranty accruals “has caused [earnings per share] overstatement of 2 cents to 8 cents in five of the last 12 quarters for which data is available.” The study comes as Dell faces investigations by the U.S. Securities and Exchange Commission, the U.S. Attorney for the Southern District of New York and the audit committee of its board of directors.
“First, it appears that Dell regularly uses warranty accruals to materially manage margins and earnings, rendering the reported results less useful for gauging actual margin trends,” FBR said in the study. “Second, as of the last quarter for which a 10-Q [report with the SEC] is available, the cost of actual claims as a percentage of products sales was rising steadily — up 30 percent [year over year in Dell’s 2006 fiscal year] and costs may be heading higher.
“FBR also said Dell’s way of disclosing how it manages the money it collects from product warranties, the money it sets aside in reserve for warranty expenses and how much it accrues in warranty funds, is unusual, making it difficult to identify the Round Rock, Texas-based company’s warranty accruals based on public financial reports alone. The research firm said Dell could be headed for a restatement of earnings if the SEC probe includes a focus on warranties.
Since that would be pretty serious manipulation, we decided to check things out for ourselves. We come away unconvinced.
We’ll take the last point first. In its reports DELL discloses its warranty costs and reserves using a table very similar to this one:

“Revenue deferred and costs accrued for new warranties” is the line management estimates. The obligations honored represent actual warranty expenses while the amortization of deferred revenue represents amounts DELL has collected for service agreements that it recognizes over the term of the agreement.
As FBR notes, by lumping deferred revenue and warranty estimates into a single line it is difficult to tell which is which. This can be important, as the warranty reserves are recognized as a product-related expense while the deferred revenues are recognized as service revenue. So we looked at several quarters of management estimates as a percentage of both total revenue and service revenue, which we condensed to the following chart:

Other than the big spike up in Q306 (the quarter that ended in October 2005) there isn’t too much of a trend in either ratio. As a percentage of total revenue the accruals are rising over time, which actually means that the company is reporting lower profits than they would if the accruals were held constant. As a percentage of service revenue there may be a very mild case that the company is being more aggressive.
Still, there doesn’t have to be a trend in order for the quarterly fluctuations to affect earnings. So we took the average ratio of our nine quarters reported as a “normal” percentage of sales that should be accrued. We see that the fluctuations in accruals were indeed enough to affect EPS. Further, there were more quarters in which the adjustment would have reduced EPS than those in which it would have increased EPS. If the company beat estimates in those quarters by a smaller amount than the warranty accrual, there would be some cause for concern. For example, in the April 06 quarter (Q107) the company reported earnings that met consensus estimates, but normalizing warranty accruals to service revenue they would have missed by $0.02.

However, Friedman’s second point (about the rising actual warranty expenses) seems somewhat frivolous. We noted that the reserve spiked in the October 2005 quarter. Looking at that filing, we learn that:
During the quarter, Dell recognized a product charge of $307 million for estimated warranty costs of servicing or replacing certain OptiPlextm systems that include a vendor part that failed to perform to Dell’s specifications. At October 28, 2005, $274 million of the accrued warranty obligation remains outstanding for servicing or replacing additional OptiPlextm systems.
Having a $307 million expected warranty expense is certainly unfortunate. However, as per the accounting requirements DELL recognized the charge as soon as the problem was discovered, and the higher current expenses at least partly relate to the remaining expenses associated with servicing and replacing those systems as needed. It is hard to argue that this is anything more than the accounting system functioning as it was intended to (matching the expenses to the associated revenues as much as possible.) The charge was taken in October 2005 and disclosed at the time as a way of covering the future expenses. Now, as the expenses are recognized they come out of the reserve rather than the income statement (since they were already charged to the income statement in October.) No big deal. In fact it seems to confirm that management is using the process appropriately. (It would be inappropriate for them to put a big deposit in the piggy bank if they weren’t going to have higher actual expenses.)
Furthermore, since the most recent cases of adjusted earnings falling below reported earnings are due to the timing of recognizing this specific issue, we are less concerned about the adjusted-earnings miss in the April quarter.

I think in reviewing an article on whether or not Dell is “cooking the books”, one should consider the source that published it. I no longer subscribe to any of the CRN publications based on the fact that most of the articles in their publications are very slanted to the companies that advertise in the magazines, and biased against those who do not, or those who do not have a channel partner program that CRN approves of. Dell is a constant target of theirs, and therefore it is no surprise that they would publish a piece of work with those sorts of allegations. I commend you on doing a fair and unbiased analysis of the article and setting the record straight.
Mark W. Porter
Chief Executive Officer
High Wire Networks, Inc.
Interesting… Seeking Alpha picks up this story and headlines it “Dell’s Accounting Practices: No Cause For Concern” while TheStreet.com says “Stock Market Beat believes Dell is cooking the books.”
Guess you’d better read it carefully to see which is closest!
(BTW: We appreciate both mentions as well as the associated traffic!)
Mark,
Thanks for the kind words. We also found parts of the CRN article somewhat slanted. However, the initial analysis by FBR was picked up by multiple publications. See also, for example, Barron’s Tech Trader Daily.
PS - If anyone can forward a copy of the FBR report we would be interested to learn how their analysis differs.
A CEO once told me that his company could control the price of it’s stock. One of the ways he mentioned was over or under stating inventory. The auditors had no way of checking. This was back in the ’70’s. That is why I have little faith in corp. numbers.
Bob,
While we agree it is worthwhile to be skeptical of the numbers, it is probably more important to understand which areas management has discretion to adjust their estimates when needed and focus on those. After Andersen went under auditors are probably a bit more vigilant, and with the SEC under Sarbox, outright lying about the numbers is a good way to go to jail.
As far as having faith in anything, the numbers seem a little more trustworthy to us than other potential sources such as management’s comments, brokerage reports, the media and - yes - even pundits like ourselves. (We hope that the wheat will be separated from the chaff as some of us manage to earn some trust, but we also expect we will make mistakes from time to time.)
[…] Stock Market Beat asks Is Dell Cooking the Books?. It’s interesting to note that author declares he is short Dell with some put options. […]
[…] We also submitted a post to the Carnival of Investing at Lazymanandmoney and another to the Carnival of Personal Finance at A Penny Saved. The author may hold a position in the securities discussed. The author’s current holdings are as follows: Long: Union Pacific (UNP) put options; Air Products (APD) put options; Nasdaq 100 (QQQQ) put options; FedEx (FDX - Annual Report) put options; Intuit (INTU) put options; Bookham (BKHM; Ballard Power (BLDP); Syntax Brillian (BRLC); CMGI (CMGI); Genentech (DNA - Annual Report; Ion Media Networks (ION); Three Five Systems (TFS); IShares Japan (EWJ); StreetTracks Gold (GLD); Starbucks (SBUX); U.S. Oil Fund (USO); Plantronics (PLT) call options; Short: Landstar (LSTR - Annual Report) put options; Ceradyne (CRDN) put options; Dell (DELL) put options; Plantronics (PLT) put options; […]
[…] Trent presents Is DELL Cooking the Books? - Stock Market Beat - Our beat is the stock market. Our job is to beat it. posted at Stock Market Beat. […]
[…] Well, at least we won’t be fighting in the streets with our children at our feet. But the change, it had to come. We knew it all along. Everything from the market share losses to the accounting issues told the world that a former management consultant was not the right person for the job. […]