Saturday, November 28, 2009

Huge Black Friday boost in web orders


(click to enlarge)

Excellent contributions everyone. Keep them coming!

Here’s a preliminary analysis on a very hefty Black Friday boost this year (remember it’s only 1 day out of 91 for the whole quarter, so this growth needs to be maintained in order to significantly affect the quarter):


. Order Rate (K/day) Y/Y change
. ------------------- --------------
. 2007 2008 2009 2008 2009
. Americas ----- ----- ----- ------ ------
Month up to TG 30.2 21.3 22.6 -29.5% + 6.4%
Black Friday 274.3 240.6 317.0 -12.3% +31.8%
BF Multiplier 9.1 11.3 14.0 +24.4% +23.8%

. Europe ----- ----- ------
Month up to TG 11.7 12.6 + 7.8%
Black Friday 95.3 189.5 +98.8%
BF Multiplier 8.2 15.1 +84.4%

US+EU Combined ----- ----- ------
Month up to TG 32.9 35.2 + 6.9%
Black Friday 335.9 506.5 +50.8%
BF Multiplier 10.2 14.4 +41.0%

Asia/Pacific -----
Month up to TG 5.9
Black Friday 17.4
BF Multiplier 2.9

US+EU+AP Combined -----
Month up to TG 41.1
Black Friday 523.9
BF Multiplier 12.7


Although chosen as consitently as possible given available data points,
some time periods and windows are slightly different. This may result
in somewhat distorted yearly and regional comparisons.

. 2007 2008 2009
. ----- ----- -----
Month up to Thanksgiving window (days)
Americas 23 29 31
Europe 29 33
Asia/Pacific 63

Black Friday window (hours:minutes)
Americas 8:45 21:39 3:09
Europe 21:39 8:04
Asia/Pacific 9:40


I'll try to have an update on this around the end of next week.

Friday, November 27, 2009

May I take your order, please? Q1 redux



This can be a great way to gauge Black Friday (and Cyber Monday) online sales. Remember I once again rely on crowdsourcing for this aspect of my model. Oh and don’t forget those European Online Store orders are very welcome too.

Just go here and note the date/time and W# of as many orders you wish to share (you can cross out the last 2 or 3 digits).

For those who’d like to run their own analysis, here's the raw data on the last few orders I've received:

Date PST Web # Region Contributor
----- ----- ----- -------- ------------
08/25 04:42 90442 Europe ITalian Pro
09/24 N/A 57279 Asia/Pac benoir
10/24 15:35 91380 Europe JML
11/11 11:38 65748 Americas macross
11/16 N/A 65837 Americas BillH
11/26 18:30 57652 Asia/Pac benoir
11/26 23:10 91799 Europe ITalian Pro
11/27 04:10 57659 Asia/Pac benoir
11/27 07:14 91863 Europe JML
11/27 10:54 66186 Americas justforkix66
11/27 12:20 66207 Americas BillH
11/27 14:09 66232 Americas Pete_y_48
11/27 15:29 66249 Americas daveynb
11/27 19:37 66297 Americas justforkix66
12/02 01:00 66480 Americas fhatta

(keep checking here, as I'm updating these as I get them)

The historical record provides great context for this unique metric. Here’s the whole history of web orders volume per quarter. And here’s last year’s analysis of the daily order rate around Black Friday.

Thanks!

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 1.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

Wow...

Wow...