5 More Amazing Apple Charts

Last month, I brought you a decade of Apple visualized using more than 10 years of operating data I had compiled on Cupertino's antics.

It seems that many of you enjoyed those fun-filled charts, so I'm here to bring you more. I've also begun incorporating data from the rest of Apple's (Nasdaq: AAPL  ) financial statements and 10-Q filings while adding in data from the most recent quarter.

I've been Fooling around with the figures to see what other interesting trends I could uncover (and put into a chart). Without further ado, here are five more amazing Apple charts.

Back to the Mac
Let's start with the Mac again, just like last time. We already knew that laptops are driving Mac sales much more than desktops, but here is a visual representation of how that mix has changed over the past 10 years, as a percentage of total Macs sold.

Sources: SEC filings, earnings press releases, Apple investor relations.

Sources: SEC filings, earnings press releases, Apple investor relations.

The prettiest girls at the dance
Speaking of unit sales, Apple reports unit sales only for its major product families: Mac, iPod, iPhone, and iPad. Looking at those product segments also as a percentage of total units sold, we can see what devices are really moving.

Sources: SEC filings, earnings press releases, Apple investor relations.

Sources: SEC filings, earnings press releases, Apple investor relations.

iPods take up the most area in this chart, making it abundantly obvious just how many of these things the company has sold cumulatively over the past 10 years. Including its most recent quarter, that cumulative lifetime figure has now reached 344.2 million. The iPhone is quickly closing the gap, with its own cumulative unit sales currently at 218.1 million in less than five years.

Strictly in unit terms, Macs were just 6.8% of all units sold last quarter. Certainly, the lower prices of the other product families drive more unit sales, but even looking at it in terms of revenue paints a similar picture.

Sources: SEC filings, earnings press releases, Apple investor relations.

Sources: SEC filings, earnings press releases, Apple investor relations.

This revenue breakdown is pretty enlightening; it shows how quickly the iPhone and iPad have come to drive the lion's share of sales in such a short period of time, replacing the iPod and Mac as the belles of the ball.

Show me the money
Apple continues generating cash flow like it's going out of style. The Mac maker now has $110.2 billion in cash and investments sitting on the books. Starting in the fourth fiscal quarter, Apple will begin giving some of those dollars back to shareholders through a $2.65-per-share quarterly dividend and stock-repurchase program, although the repurchase program is primarily geared toward offsetting dilutive equity compensation.

Apple's cash hoard is larger than the entire market cap of rival Amazon.com (Nasdaq: AMZN  ) , which sports a $104 billion capitalization, even after the most recent earnings beat and subsequent rally. Here's a breakdown of Apple's cash balance, split into cash and equivalents, short-term investments, and long-term investments, starting in 2006.

Sources: SEC filings, earnings press releases, Apple investor relations.

Sources: SEC filings, earnings press releases, Apple investor relations.

As Apple generates copious amounts of cash, it promptly sticks what it doesn't need into long-term investments. After all, what would you do if you had generated $99 billion in free cash flow over the past four quarters? I doubt you'd run it down to your local depository for safekeeping.

Most of this money is now being generated overseas, as international sales comprised 64% of last quarter's revenue. At the end of March, $74 billion of that hoard was sitting abroad, held by foreign subsidiaries.

Sources: SEC filings, earnings press releases, Apple investor relations.

Sources: SEC filings, earnings press releases, Apple investor relations.

For the time being, all that cash abroad is stuck and probably isn't coming home anytime soon because of repatriation taxes. Luckily, Apple has plenty of domestic dollars -- $36.2 billion, to be precise -- to use, including for the aforementioned dividends and buybacks. That being said, Apple still needs to keep printing money, since it expects to use $45 billion from its domestic money mountain for those programs in the first three years.

It ain't over yet
Even though Apple is already the largest company in the world, its growth still has plenty of legs. In another 10 years, I'll have even more Apple charts for your viewing pleasure -- and I'll probably still have some more in the meantime.

Apple's international cash stash is helping it dominate the world, but it's not the only one. Here are another 3 American Companies Set to Dominate the World by tapping into emerging market growth. Get the free report now while you still can.

Fool contributor Evan Niu owns shares of Apple and Amazon.com, but he holds no other position in any company mentioned. Check out his holdings and a short bio. The Motley Fool owns shares of Amazon.com and Apple. Motley Fool newsletter services have recommended buying shares of Apple and Amazon.com and creating a bull call spread position in Apple. The Motley Fool has a disclosure policy. We Fools don't all hold the same opinions, but we all believe that considering a diverse range of insights makes us better investors. Try any of our Foolish newsletter services free for 30 days.


Read/Post Comments (5) | Recommend This Article (19)

Comments from our Foolish Readers

Help us keep this a respectfully Foolish area! This is a place for our readers to discuss, debate, and learn more about the Foolish investing topic you read about above. Help us keep it clean and safe. If you believe a comment is abusive or otherwise violates our Fool's Rules, please report it via the Report this Comment Report this Comment icon found on every comment.

  • Report this Comment On May 06, 2012, at 4:44 PM, gslusher wrote:

    "iPods take up the most area in this chart, making it abundantly obvious JUST HOW MANY of these things the company has sold cumulatively over the past 10 years." [emphasis added]

    It shows no such thing. The chart is of percent of sales. To know how many iPods were sold, one would have to know the denominator, the total unit sales. It's also misleading because of the difference in the selling prices and margins.

    According to TIm Cook in the last Apple earnins call, iPhone unit sales grew a lot faster than iPod unit sales and iPad unit sales growth has beaten the iPhone's. That is a very salient fact, but one would be hard-pressed to figure that out from the charts.

    "Even though Apple is already the LARGEST company in the world ..." [emphasis added]

    By what measure? Apple may be the "most valuable" company--highest market cap, but it's nowhere near the "largest" in almost any other measure. Exxon-Mobile's revenue is more than three times Apple's, for example, as is Wal-Mart's. I expect that there are many companies with more employees, more facilities, etc. The statement made by the author is, again, misleading unless it is qualified.

  • Report this Comment On May 07, 2012, at 12:02 AM, ConstableOdo wrote:

    Could someone please explain to me why Amazon has a P/E of close to 180 and no one seems to bat an eye? I'm always hearing that Apple is trading in a bubble with a P/E of 14 and yet no one says Amazon is in a bubble with a P/E of 180. Isn't that a ridiculously high P/E compared to even similar types of companies. I just don't get why some companies get such special treatment if their fundamentals are no better than a similar company. Amazon honestly doesn't seem to abide by any common rules of share value. Amazon's P/E expands every month and Apple's P/E shrinks every month. WTF is with that action.

    On another note, can't Apple do something with that foreign cash reserve like build some factories or data centers, just to get some use out of that money. I'm only talking about a few billion or so. Hardly enough to eat into that cash reserve considering how much cash Apple pulls in every quarter. It does seem a shame for the money to be just sitting in a bank doing nothing.

  • Report this Comment On May 07, 2012, at 2:30 AM, sobani wrote:

    Odo,

    That's because Amazon's earning are distorted. They invest every bit of could-have-been earnings. But the rules say you can't call that money earnings.

  • Report this Comment On May 07, 2012, at 8:48 AM, gslusher wrote:

    @sobani:

    "But the rules say you can't call that money earnings."

    Well, sort of. Capital expenditures are subject to depreciation, which is usually included as part of "cost of sales." If Amazon were to spend $1B on capital in 2012, they couldn't count all $1B as "cost of sales" in 2012, but only a portion of the $1B. The rest would be spread out over the appropriate time. In 2012, Amazon will include in "cost of sales" a portion of 2012 capital expenditures and portions of capital expenditures of previous years.

    In that sense, depreciation (capital expenses) is NOT "could-have-been earnings" anymore than the money Amazon pays to publishers for books is "could-have-been-earnings" or the money they pay for electricity is "could-have-been earnings." One way to think about it is that, without the capital expenses (depreciated), they wouldn't be able to sell stuff.

    Don't confuse "earnings" with "cash flow." They're related, but only indirectly.

    The real reason that Amazon's earnings are so low is that they have very slim margins. That's typical of retail, but Amazon is "worse" (has lower margins) than most retail operations.

    Indeed, some analysts think that one reason that Amazon had higher "earnings" and margins in the most recent quarter compared to the previous quarter is that sales of Kindles dropped dramatically. It is suspected that Amazon loses money on each Kindle (not just the Kindle Fire) sold, so, if they sell fewer Kindles, they lose less on them and their earnings and margins increase.

    IDC estimated that Kindle Fire sales dropped about 85% from the December quarter to the March quarter. They were a much smaller portion of a smaller number of total tablet sales (4% of 17.4M vs 17% of 28.2M, or about 700K vs 4.8M, a drop of 85%).

  • Report this Comment On May 08, 2012, at 10:42 PM, seattle1115 wrote:

    Given that the topic is Apple, shouldn't these be pie charts?

Add your comment.

Sponsored Links

Leaked: Apple's Next Smart Device
(Warning, it may shock you)
The secret is out... experts are predicting 458 million of these types of devices will be sold per year. 1 hyper-growth company stands to rake in maximum profit - and it's NOT Apple. Show me Apple's new smart gizmo!

DocumentId: 1880425, ~/Articles/ArticleHandler.aspx, 10/23/2014 10:34:53 AM

Report This Comment

Use this area to report a comment that you believe is in violation of the community guidelines. Our team will review the entry and take any appropriate action.

Sending report...


Advertisement