Monday, October 19, 2009

Fiscal 4Q '09 actual results vs. estimates

Two bottles of a Cabernet-Sauvignon from Mendoza, Argentina may not be enough celebration for this new all time high, not just because it's a new ATH, but rather for what we've been through over the last couple of years, and survived... and most impressively, for the short time it took to get us back on track. But I think I have some soul-searching pending, and so, that third bottle can wait for tomorrow's confirmation of an official close above $199.83. I just need to get this out of me now, and more wine might not help with that.

So here we go... well, that was quite embarrassing! Apple swept all across my estimates (and everyone else's). I feel the need to apologize to my readers for such a clueless prediction. I was off in almost every category that's meaningful, and missing the bottom line by 16% is more than 7 times worse than my average performance over the previous 8 quarters. I really hope this is a one-time thing.

I feel somewhat responsible if anyone decided to make serious bets or hedges out of my misguided conservatism. If you did, I owe you one, and I hope to make it good next time. I normally try to focus on the long term (and that's what my targets up in the high 200's are for), but I know this time I've expressed more concern about a short-term correction than at other times, due to the modest numbers I was seeing for last quarter.

In my defense, the second most significant reason for my huge EPS miss was such a forgiving effective tax rate reported. Apple guided for 30% and I estimated 29.1% tax, based on historical trends. The report showed an effective tax rate of 25.6%, which would explain away about 30% (or about 8.5¢) of the 29¢ miss.

The rest, the most significant reason for the miss, of course comes from underestimating revenue by more than half a billion, and then gross margins came 40 bps higher than I expected (Apple guided for 34%, I was at 36.2%, and the report came at 36.6%). Only a couple of cents were due to the slightly lower OpEx and slightly higher interest income than I was modeling for. So the real organic upside (for me and most everyone else) mostly came from the revenue side of the equation.

Of the roughly 20¢ remaining due to the revenue miss, more than 2/3 (or half of the whole 29¢ miss) are due to the Mac's incredible performance. The rest is about 3 cents due to a surprisingly rising iPod ASP's, a couple of cents from iTunes upside, and another 2¢ from peripherals (most likely stemming from high attachment rates to Mac sales). Usually, I get all these revenue sources to fall on both sides of the fence so that they cancel each other out and thus allows me to get pretty close to the overall numbers, but this time I only had SW on the plus side, which barely took care of my relatively accurate but slightly lower iPhone revenue.

So, let me focus on the Mac. First, more than 3 million Macs, baby! 17% unit growth with the industry flat, and portables growing a scorching 35%. That's 300k more units than already lofty expectations (considering the economy) of 2.75M. But that's not what impressed me the most. What I couldn't believe and I'm still not sure how to explain is the sequential increase in Mac ASP's.

Didn't we just see Apple lowering prices, most steeply for laptops (the star of the quarter in terms of units) by hundreds of dollars? Isn't this the back-to-school quarter when many college students are getting their first self-purchased computer, and are extremely price conscious and tech savvy on all the cheap alternatives, netbooks, or aware of the "benefits" of a true gaming rig, a perennial "weakness" for the Mac? Wasn't this the quarter in which Microsoft supposedly got serious about conveying, through supposedly quite strong advert messages, the value advantage of going with a PC? Wasn't this supposed to be a quarter where the consumer would be spend-thrifty, and only buy absolutely necessary products?

So, how on earth did ASP's go up sequentially (although minimally)? I guess it's gotta be those $1700-$2500 15" and 17" MBP's that must be getting crazy popular among college students, perhaps precisely thanks to their reduced prices, but also obviously due to the unmatched features, quality, and experience. Could the secret to this success be as simple as just providing a satisfying, fun, high-quality, highly-valued experience for customers? Wait, that actually sounds like an obvious tautology. Well, not that obvious to some, perhaps.

Let this be my mea-culpa. I was wrong about the Mac! Not the iPhone, not the iPod, but the Mac, the segment that I'm always willing and eager to get bullish about. And I was afraid my 2.85M current and future unit estimates were at risk. Silly me.


Here's the detailed comparison:

.          Est    Act    Err%
. ---- ---- -----

Income statement ($M):
Revenue 9322 9870 - 5.5%
COGS 5948 6256 - 4.9%
GM 3375 3614 - 6.6%
OpEx 1440 1421 + 1.3%
OpInc 1935 2193 -11.8%
OI&E 33 45 -26.0%
Pre-tax 1968 2238 -12.1%
Tax 573 573 - 0.1%
NetInc 1395 1665 -16.2%
Shrs. 913 914 - 0.2%
EPS ($) 1.53 1.82 -16.0%

Ratios:
GM% 36.2% 36.6% - 1.1%
OpInc% 20.8% 22.2% - 6.6%
Tax% 29.1% 25.6% +13.7%
NetInc% 15.0% 16.9% -11.3%

Revenue breakdown ($M):
Mac 3581 3952 - 9.4%
iPod 1502 1563 - 3.9%
iPhone 2265 2297 - 1.4%
iTunes 961 1018 - 5.6%
Periph 338 393 -13.9%
Software 676 647 + 4.5%

Units (M):
Mac 2854 3053 - 6.5%
iPod 10300 10177 + 1.2%
iPhone 7300 7367 - 0.9%

ASP ($):
Mac 1255 1294 - 3.1%
iPod 146 154 - 5.1%
iPhone 545 612 -10.9%

What did I get relatively close? A few inconsequential things: the OpEx number, the absolute tax provision (whatever), the shares outstanding (easy), the GM% (thankfully I read Turley's articles and dismissed PO's lame guidance), the iPhone revenue (not the ASP's, again those are out-of-this-world high, but it only gets reflected on the non-GAAP numbers), the iPod units, and the Mac ASP's (again, those are incredibly holding up but thankfully I didn't expect them to fall too much and thus avoided an even worse miss).

Oh, and I definitely got the subscription accounting change non-event right, first from my intuition of a bait-and-switch setup and later exclusively confirmed two weeks ago here through Joan Hoover's email.

Well, I should've known this big surprise was a sure thing when I heard Cramer do his 180° just as a huge amount of October options had expired worthless (both 190 calls and 185 puts):
"Investors who have waited and waited for a great time to buy Apple (AAPL Quote) will get their chance next week,"

Yea right, at a $10-$15 higher price! He was already working up the option volatility play for the benefit of his option-writing, market-maker puppet masters, IMO. Oh well, I guess that's what makes him a professional, and makes me an amateur.

One last thing, I seriously, truly nailed that guidance estimate, didn't I.

3mo ending Dec-2009   Revenue($B)       EPS($)
. ------------- ------------
F1Q10 GAAP n-GAAP GAAP n-GAAP
------------------ ----- ------ ---- ------
Analysts consensus 11.44 ? 1.91 ?
Deagol's estimates 12.07 13.71 2.20 3.02
Apple guidance (e) 11.45 13.00 1.75 2.60

Apple guided for GAAP in a range of $11.3b to $11.6b revs (midpoint is $11.45b!) and $1.70 to $1.78 EPS (midpoint is $1.74!). That's the one thing I'm really proud of this time.

Congrats to all longs, and see ya soon at $300!

:d

4 comments:

Anonymous said...

Deagol

You kicked ass. Your estimate was higher then most professionals. Don't beat yourself up too much.

Keep up the good work.

The Sponge

Anonymous said...

Deagol, I really appreciate your work. I've been keeping my own model for 2 years and I like to make my calls early.

Here is what I ran for next quarter:

I'm going with EPS 2.14 next Q on sales of $12 billion. Trailing PE (GAAP) 30x multiple would imply $241/share in Feb. Apple guided in a range of $11.3b to $11.6b revs (midpoint is $11.45b) and $1.70 to $1.78 EPS (midpoint is $1.74). This forecast suggests a 26% higher EPS than the low end of guidance. During FQ409 the actual EPS was 55% higher than guidance. Apple beat by 50% or more twice in 2007 and the stock was highly volatile (high beta--volatility independent of the market). I would guess we'll see more of this next year.

Assumptions:

Units:
iPhones: 10 million (+129%) (1)
Macs: 2.9 million (+15% y/y, down sequentially)
iPods: 21.6 million (-5%)
Music: $1008 million (down slightly sequentially from 1018) (2)
Peripherals: $435 million (tracking Mac growth)
Software: $697 million (tracking Mac)

ASP:
iPhone: $600 (down sequentially from 612)
Mac: $1250 (down sequentially from 1294)
iPod: $155 (flat sequentially)

Margins (all unchanged q/q):
iPhone: 60% (3)
Mac: 28%
iPod: 28%
Music/apps: 10%
Peripherals: 45%
Software: 80%
Overall: 37%

Operating Costs: (4)
SG&A: $1.2 billion (up from 1.01 q/q and 0.89 y/y)
R&D: $445 million (up from 411 q/q and 215 y/y)

Notes:
(1) Last year there was a large channel build-out which won't be there this year. Assuming Apple will succeed in meeting demand.
(2) Still waiting for the app store to make itself felt here though a cursory look implies income is increasing faster than music sales.
(3) Ignoring major air freight charges from Tim "Drama Queen" Cook.
(4) y/y Apple appears to be spending like a drunken sailor but as a % of sales, it's a miser at 3.7% R&D and 10% SG&A--well below industry averages.

-Asymmetric

Michel C said...

You are still the best in my book. Could the change in the way Apple handle the web order numbers, have impact on your previsions?

I prefer your "off previsions" with your model then the so call professionals, prevision.

Michel C

Doug Williams said...

It was back-to-school season and Mac has a following from customers that are largely insulated from the economic downturn (i.e. rich kids). Given that Windows 7 arrived after back-to-school, it makes sense that Apple would accelerate their share gain this quarter. Next year, with Windows 7 fully in the market place, I would expect Mac performance to be less dominant.