Cabeza Howe's  Instablog

Cabeza Howe
Send Message
Cabeza Howe holds two M.S. degrees in engineering. He has extensive career background in science, engineering and software development. He is a self-made financial analyst and manages his own investment as a business. Focused value investing is his passion. He coined the term... More
My blog:
  • 11 Charts That Reveal Apple's Retail Store Trend 2 comments
    Oct 8, 2012 8:38 PM | about stocks: AAPL

    Since last month's iPhone 5 release, a lot of skepticism and pessimism have fallen on Apple (NASDAQ:AAPL). The skepticism and pessimism have not spared Apple's iconic, strategic and yet smallest business segment: its retail store operation. To address some of the concerns, I have pored over Apple's regulatory filings since fiscal year (FY) 2001, when Apple opened its first retail store, and compiled 11 charts that I hope should reveal the trend in this business segment.

    Retail Store Openings

    Chart 1 indicates the number of retail stores Apple has opened (cumulatively) as of the end of each fiscal year since FY 2001. The final FY 2012 store number will remain unavailable until later this month when Apple releases its Q4 and FY12 earnings. So, the number for FY 2012 in the chart is an estimate based on the company's store target released in its previous filings.

    (Chart 1)

    As you can see, Apple is still expanding its retail footprint steadily. But it has slowed down its pace in the U.S. while maintaining rapid international expansion. That makes a lot of sense if you think about it. In mainland China, for example, with a population of 1.3 billion Apple has just opened its fifth retail store last month. And customers started to queue for the store opening at 10 p.m. the previous night!

    Retail Sales and Operating Income Per Square Foot

    These are shown in Chart 2 below. For each fiscal year, I have used average square footage to calculate the net retail store sales (revenue) and operating income per square foot. For FY12 the per-square-foot data were for the past four quarters (NYSE:TTM) ending 3Q12. As you can see, net sales per square foot almost reached the $6,000 mark for the past twelve months (ending 3Q12) at $5,936. Net operating income per square foot came in at $1,510. Net sales will likely break the $6,000 per square foot mark for FY12 and continue to climb in the next quarter (1Q13).

    (Chart 2)

    Retail Operating Margin

    Chart 3 shows the retail operating margin for the past twelve years. Again since FY12 is incomplete, so I have used past four quarters (ending 3Q12) in its place. Retail operating margin remained negative until FY04. Thereafter, it has generally kept improving.

    (Chart 3)

    Chart 4 below is the same as Chart 3 except it started with FY03 to make recent trend easier to be discerned. Retail operating margin hit an intermediate peak at FY09. But it improved again in the past four quarters, which registered an all-time high of 25.4%. For the first nine months of FY12, the retail operating margin fared even better, reaching 26.5% (not shown).

    (Chart 4)

    However, retail operating margin for 3Q12 (not shown) came in at only 21.3% mostly because consumers worldwide postponed iPhone purchases in anticipation of the new iPhone 5 model released last month. You can count on the retail operating margin to improve in 4Q12, but particularly in 1Q13 ending this December.

    Retail Revenue and Operating Income Compared to Total

    Chart 5 compares net retail revenue to total net revenue for the past twelve years. As you can see, even though net retail revenue has increased over the years, Apple's total net revenue has grown at an even faster pace. Again, I have used the past four quarters' data (ending 3Q12) in place of FY12.

    (Chart 5)

    The same can be said for retail operating income, shown in Chart 6.

    (Chart 6)

    Chart 7 plots net retail revenue as a percentage of total net revenue, and retail operating income as a percentage of total operating income. It can be seen that, in the first few years, retail stores contributed an increasing percentage to total revenue and operating income. However, as Apple's total revenue and operating income grew at a faster pace than retail revenue and operating income, respectively, the latter's percentage has been in constant decline in more recent years.

    (Chart 7)

    The comparison above might have proved the success of Apple's retail strategy. Retail stores are not just points of sales. Through superior customer service, education, and image/brand building, they are helping drive the company's overall sales in other channels which grow even faster than the direct sales in retail stores.

    Retail Store Capital Expenditures

    Chart 8 plots Apple's CapEx in retail stores, total CapEx, and operating cash flow for the past twelve years. Note that for FY12, the data are for the first nine months only.

    As can be clearly seen, Apple's operating cash flow has been growing at a faster pace than its retail CapEx for the past few years. Therefore, Apple's current retail CapEx looks like a drop in a bucket when compared to its monstrous operating cash flow. OK, it is not quite a "drop in a bucket." But the current retail CapEx is surely a pocket change compared to the operating cash flow.

    (Chart 8)

    Chart 9 plots retail store CapEx as a percentage of the operating cash flow, and the same as a percentage of the total CapEx. It should be clear that the retail store CapEx has been on a constant decline as a percentage of both the total CapEx and the operating cash flow. For the first nine months of FY12, retail CapEx represented only 1.2% of operating cash flow. Do you see my "pocket change" analogy now?

    (Chart 9)

    When you plot the cumulative retail store CapEx since inception (2001) versus the cumulative operating cash flow in the same period, you get Chart 10. As of June 2012 (end of Q3), Apple has invested a total of $3.3B in retail stores. Note that this represents only 7.9% of the most recent three quarters of operating cash flow. And it is only 2.6% of the cumulative operating cash flow so far since 2001.

    (Chart 10)

    Chart 11 plots the cumulative retail CapEx as a percentage of the cumulative operating cash flow since 2001. Again note the declining trend.

    (Chart 11)

    The retail store CapEx charts above along with the huge international potential mentioned previously should serve to quell concern among some investors that Apple has over-expanded its retail store operation.


    Since 2001, Apple has opened nearly 400 iconic retail stores both in the U.S. and internationally. Both sales and operating profit have grown in these retail stores over the years. However, these retail stores have also helped driven the company's overall sales (that are growing even faster) through superior customer service, education, and brand building. There is a lot of room for the retail operation to grow particularly internationally. And with its monstrous capability in generating operating cash flows, Apple can now expand its retail store operation with comparatively minimal capital expenditures.

    Disclosure: I am long AAPL.

    Stocks: AAPL
Back To Cabeza Howe's Instablog HomePage »

Instablogs are blogs which are instantly set up and networked within the Seeking Alpha community. Instablog posts are not selected, edited or screened by Seeking Alpha editors, in contrast to contributors' articles.

Comments (2)
Track new comments
  • pocohonta
    , contributor
    Comments (662) | Send Message
    Nice charts and excellent research!


    Looking at chart #6, we can discern that Apple is not about being a chain of retail stores, but being a marketer/distributor of iGadgets. Their biggest customers are not individual buyers, but the wireless and large retail vendors (T, VZ, S, and retail chains like BBY) who then resells to individual buyers. Therefore, the focus (if we are searching for trends to predict future earnings) should not be Apple stores, but the trends among the top 10 highest-volume customers.
    9 Oct 2012, 02:32 AM Reply Like
  • Cabeza Howe
    , contributor
    Comments (502) | Send Message
    Author’s reply » Thanks, pocohonta. I agree with you. Apple stores are marketing centers, educating/training centers, customer service centers, and retailers all combined in one. Many fans simply couldn't imagine an Apple without the stores.


    Furthermore, the stores are clearly profitable to me with operating profit per square foot at $1,510 and improving!


    For iPhone sales by channels, here is a nice link:
    9 Oct 2012, 11:27 AM Reply Like
Full index of posts »
Latest Followers


  • Two stocks that might have bottomed: $FIVE, $AA
    4 days ago
  • More downside for $CATO. Same-store sales trend: 0% in 1Q, -6% in 2Q, -9% in September. Fourth consecutive month SSS at/below -8%.
    Oct 6, 2016
  • Hold your breath on $KR. Bottom might be near. Reasonable expectation $28-29 range (based on 200 wk EMA and SMA).
    Oct 6, 2016
More »

Latest Comments

Instablogs are Seeking Alpha's free blogging platform customized for finance, with instant set up and exposure to millions of readers interested in the financial markets. Publish your own instablog in minutes.