The Mac Observer

 
   
2 of 2
2
Poll
Will people in Q1 tend to go online more or less than in Q4?
More, of course (ask Amazon) 8
Less (can’t buy iPhone online this year) 5
It’s a wash... 8
Total Votes: 21
You must be a logged-in member to vote
Q1 sequential change in share of online sales?
Posted: 16 November 2008 09:17 AM [ Ignore ] [ # 16 ]
stars_big_1
Avatar
Total Posts:  2667
Joined  2005-10-04

[quote author=“deagol”]So here’s how I’m looking at the Y/Y web order growth rates:

US    EU   Combined
October            
-30%  -10%    -24%
First half of Nov  -30%  -33%    -32%
November (est)     -28%  -24%    -27%
December (est)     -11%  + 5%    - 7%
All Q1 (est)       -21%  -10%    -18

This results in about 3.7M orders (US and EU combined) for the quarter. Using the same ratio as Q4 (as you have voted for), it suggests revenue of around $11.1B.

Not clear on why you expect a YoY growth in revenues to 11.1B (GAAP, I’m assuming) if you are seeing a decline in web-order numbers.

 Signature 

Tightwad.

Profile
 
 
Posted: 16 November 2008 11:00 AM [ Ignore ] [ # 17 ]
stars_4
Avatar
Total Posts:  697
Joined  2006-04-18

[quote author=“awcabot”]
Not clear on why you expect a YoY growth in revenues to 11.1B (GAAP, I’m assuming) if you are seeing a decline in web-order numbers.

I mention some factors in my first post (look under “Factors contributing to a relative decrease in online orders”) which although I was thinking in terms of a sequential effect, those reasons are also valid for a YoY comparison.

I’ll take another shot at explaining those three, but shifting the perspective to the YoY changes. Of course, there may be other factors at work.

1. iPhone: last year iPhone was available online, this year it is not. Thus, any growth in recognized revenue from iPhone (big big growth there) can’t have a corresponding growth in web orders.

2. new customers: every year Apple keeps reaching new-to-Apple customers, and I believe these customers are much more comfortable going to a retail store where they can look and touch and test the products. Sure, eventually some [edit: ok probably all] of these new customers “graduate” to the online store experience, the question is whether there is a net gain or decline in such “noobs” who stick to retail store for some time. Again, this whole factor is my own common sense, not much data to back it up (perhaps the continuing 50% of Macs sold to new-to-Mac customers in the Apple stores).

3. retail expansion: This is not just the Apple Retail Stores, but also big chains like BBY and WMT (and their European counterparts) as well as smaller specialized chains. You could check the conference call transcripts and research the increase in the number of retail point-of-sales (Apple and third-party, for Mac and for iPod and now for iPhone), but I think I already know the trend. This retail expansion trend has been reflected in the web order data. For years it used to be that web orders would grow by some moderate amount and revenue would grow by some big amount. Thus, declines in web orders should not immediately suggest a decline in revenue, as there is a historical offset (and a slower longer-term trend for it to get bigger) between both growth rates, and depending on how big this offset is you might still have positive revenue growth.

These effects can already be seen at work in last quarter’s YoY web order growth (-10%) vs. revenue growth (+27%). I’m projecting a declining trend for both due to the economy, and the disconnect should not be so big this quarter due to seasonality. So sequentially, YoY web order growth goes from -10% to -18% (difference of -8%) and YoY revenue growth goes from +27% to +15% (difference of -12%).

Hope this helps you to see how and why I’m projecting things as I stated above. Of course, I can change my mind about things along the way, and if the real web orders coming through differ significantly from my projections, I’ll most likely have to change some of the assumptions.

 Signature 

Deagol’s AAPL Model

Profile
 
 
Posted: 16 November 2008 11:43 AM [ Ignore ] [ # 18 ]
stars_4
Avatar
Total Posts:  697
Joined  2006-04-18

Perhaps I’m explaining myself too much. It boils down to this:
[quote author=“deagol”]
These effects can already be seen at work in last quarter’s YoY web order growth (-10%) vs. revenue growth (+27%).

This is why I made a poll in the first place. I had the same concerns that you point out after seeing this disconnect last quarter. So I asked you guys if this pattern would change this quarter, and you guys voted no, that it would be a wash, no change from last quarter. So, as I promised, I’m going with the vote and modeled for a similar disconnect between web order growth and revenue growth. Why? my reasons for and against it are explained in the first post, and some voters have stated their reasoning in the thread. I assume your vote was for there to be a sequential increase in the relative share of sales coming from the Apple Online Store. I can see that it’s a close call between that and the “it’s a wash” votes, so maybe for the mid-December poll things will be different.

 Signature 

Deagol’s AAPL Model

Profile
 
 
Posted: 17 November 2008 12:15 AM [ Ignore ] [ # 19 ]
stars_big_1
Avatar
Total Posts:  2667
Joined  2005-10-04

Thanks for the thorough reply. Now it all makes sense.

 Signature 

Tightwad.

Profile
 
 
Posted: 18 November 2008 11:50 PM [ Ignore ] [ # 20 ]
stars_big_1
Avatar
Total Posts:  2667
Joined  2005-10-04

Re: Q1 sequential change in share of online sales?

[quote author=“deagol”]I need a little help with my Q1 estimates (my crystal ball has caught the October haziness bug). The question is quite simple: whether people this year will more likely buy online in Q1 than in Q4, as it’s happened historically, or instead the iPhone availability will force them to go to retail stores even more than in Q4.

Online retail spending slows in October
Not Apple spcific, but it still may help you in making up your mind. Apple buyers are people too!

 Signature 

Tightwad.

Profile
 
 
Posted: 29 November 2008 07:26 AM [ Ignore ] [ # 21 ]
stars_4
Avatar
Total Posts:  697
Joined  2006-04-18

Fresh data right out of the oven!  wink

2008 Black Friday Analysis:

Web Order        Daily Rate
             
-----------  --------------------
 
Date PST     US    EU      US     EU    Comb   YoY US*
----- -----  ----- -----  ------ ------ ------  ------
10/29 17:50  41306 87288
11
/13 16:02  41599 87449   19.6   10.8   30.4   -32.0%
11/28 01:00  41929 87630   23.0   12.6   35.6   -32.8%
11/28 22:39  42146 87716  240.6   95.3  335.9   -12.3%
                          ------ ------ ------  ------
Pre-Thanksgiving boost%    16.9%  16.7%  16.9%   -7.2%
Black Friday Factor        10.5    7.6    9.4   +30.5

*YoY growth for US based on these 2007 datapoints:

2007 US      Web #  Daily
-----------  -----  -----
10/31 09:58  32478
11
/17 18:15  32979   28.9
11
/23 06:20  33167   34.2  (18.3boost)
11/23 15:05  33267  274.3  (8x factor)
11/30 05:38  33597   50.0
12
/17 07:40  34546   55.6
01
/01 16:03  35010   30.2 

YoY growth for EU and combined not computed due to non-comparable periods:

2007 EU      Web #  Daily
-----------  -----  -----
10/17 14:44  83672
11
/06 00:00  83959   14.8
12
/06 02:22  84411   15.0
01
/09 06:04  84829   12.2 
 Signature 

Deagol’s AAPL Model

Profile
 
 
Posted: 05 December 2008 01:43 PM [ Ignore ] [ # 22 ]
stars_4
Avatar
Total Posts:  697
Joined  2006-04-18

Here’s an update a week later:

Average daily web order rates on all comparable time frames:

                      
2007   2008  YoY Change
             US only 
-----  -----  ----------
3-4 weeks up to TG    30.2   21.3        -29%
Black Friday peak    274.3  240.6        -12%
6 days after BF       50.0   40.4        -19%
7 days after TG       61.7   65.4          6%

NoteSampled peak BF periods are significantly
different in length 
(8 hours in 2007 vs21 hours
in 2008
), somewhat distorting the comparison.


Whole period from Nov through the week after TG:

                      
2007   2008  YoY Change
                     
-----  -----  ----------
                  
US  37.5   30.0        -20%
                  
EU  14.9   14.8         -1%
                
Comb  52.5   44.8        -15


So, I’m feeling much more comfortable with only a 13-16% YoY decline in web orders for the whole quarter, despite the declines in October (-24%) and early-November (-32%). IMO, that would support an estimate for total revenue of $11.1b to $11.7b. I’ll do the whole spreadsheet update after next week.


Here’s the raw order data so you can run your own rates:

2008    PST   US W#  EU W#
-----  -----  -----  -----
10/29  17:50  41306  87288
11
/28  01:00  41929  87630
11
/28  22:39  42146  87716
12
/05  06:20  42401  87828

2007    PST   US W
#
-----  -----  -----
10/31  09:58  32478
11
/23  06:20  33167
11
/23  15:05  33267
11
/30  05:38  33597

              EU W
#
              
-----
10/17  14:44  83672
12
/06  02:22  84411 
[ Edited: 05 December 2008 02:29 PM by deagol ]
 Signature 

Deagol’s AAPL Model

Profile
 
 
   
2 of 2
2
 

Apple Stock Quote (AAPL)

Loading...

Hot Topics

TMO Express

Join the TMO Express Daily Newsletter to get the latest Mac headlines in your e-mail every weekday. Find out more!

Top Deals From DealBrothers.com

Recent Features

Support The Mac Observer

We noticed you may be running AdBlock on your computer. It takes real money to run this site and to deliver the news, tips, and opinions you love to read.

If you wish to block the ads that pay for the creation of our content, we ask that you instead support TMO Directly, either with a $5 monthly recurring contribution, or a one-time donation of any amount of your choice. Thanks!

Subscribe with Paypal Donate with Paypal