Seeking Alpha
Full index of posts »
Posts by Ticker
Latest Comments
-
sleepy on Running The Numbers - why Microsoft ($MSFT) is a BUY Valuations like this are based on the idea that...
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.














Running The Numbers - The Roller Coaster Apple ($AAPL) Share Price
It has been a crazy 15 months for the Apple ($AAPL) share price. On the 22 August 2008 $AAPL was trading at $176.79. By 16 January 2009 $AAPL had dropped to $82.33 - down over half (53% down) in under five months. Today $AAPL closed at $190.01 - up over 130% in under nine months. The graph below shows the closing prices over the period. So what do we think about $AAPL?
Valuecruncher Interactive Analysts Report For Apple ($AAPL)
We have the comparator group set as Microsoft ($MSFT), IBM ($IBM), Google ($GOOG) and Hewlett-Packard($HPQ). You can change these peer companies on the site. For example you could add:
So what do we think?
Discounted Cash Flow Valuation
We have completed a discounted cash flow valuation using our interactive tools (there is a “discounted cash flow analysis” link just under the company name on the company page). We have populated our model with a mixture of consensus analyst estimates and Valuecruncher estimates. Our analysis produces a valuation of US$176.16 for $AAPL - 7.3% below the current share price. We see $AAPL overvalued at the moment. But how about compared to a peer group?
Comparison Analysis
I changed the peer group companies to $IBM, $RIM, $PALM and $QCOM. I am going to look at two of the metrics we use at Valuecruncher - Enterprise Value (EV)/Revenue and EV/EBITDA. Enterprise Value (EV) is simply market capitalization plus net debt [long-term borrowings less cash]. We use EV to capture the impact of debt and cash on a company’s balance sheet - market capitalization doesn’t capture different capital structures when comparing companies.
EV/Revenue shows how a dollar or revenues is being valued by the market against the comparator set. On an EV/Revenue basis $AAPL is trading at 4.5x ($AAPL is being valued at 4.5x last year’s revenues). This compares to $IBM at 1.7x, $RIM at 3.5x, $PALM at 3.4x and $QCOM at 5.8x. $AAPL’s profit margins (at the EBITDA line) are 20.9% of revenues. A dollar of $AAPL revenues is being valued more than a dollar of $RIM revenues - despite that dollar of revenues producing less profit (on an EBITDA basis) than the $RIM revenues. A dollar of $AAPL revenues is being valued less than a dollar of $QCOM revenues - but $QCOM produces nearly twice the profit (on an EBITDA basis) as $AAPL. We would expect the difference between the multiples for $QCOM and $AAPL to be larger - in $QCOM’s favour. There are some big growth expectations for $AAPL - on an EV/Revenue basis there appears to be a premium being paid for $AAPL against the peer group.
If we lower the $AAPL EV/Revenue multiple to 3.75x (a slight premium to $RIM) then this gives a share price of $163.30 - 14% below the current share price.
EV/EBITDA shows how a dollar of profit (measured in as Earnings Before Interest Taxes Depreciation and Amortization) is being valued by the market against the comparator set. On an EV/EBITDA basis $AAPLT is trading at 21.51x ($AAPL is being valued at 21.5x last year’s profit at the EBITDA line). A dollar of $AAPL EBITDA is worth more than double a dollar of $IBM, $RIM or $QCOM EBITDA ($PALM is losing money at the EBITDA line).
If we lower the $AAPL EV/EBITDA multiple to 17.5x (a slight premium to $QCOM) then this gives a share price of $160.06 - 16% below the current share price.
Summary
Based on our DCF valuation - $AAPL looks overvalued. Looking at some comparators - the market is valuing $AAPL highly compared to some peers. We believe if you are investing in $AAPL at the current price - you are paying a full price and there are cheaper options available. We do recognize that there are a lot of $AAPL fans out there however.
Disclosure: no positions.
A Future Of On-Line Finance - From Brokers To Blogs To Yahoo
We have been participants and observers of the on-line finance space for a period of time now. As part of that we regularly examine our view of the competitive landscape. We have decided to share some of our views on where the very broad industry may be headed. This isn’t company specific – very much the high-level perspective.
Where We Are Today
We view the on-line finance space in three broad areas: Information, Analysis and Execution.
Pre-1995 this whole area was dominated by brokerage firms with full-service offerings. They had the information, did the analysis and the executed the trades. Since 1995 that has changed pretty significantly.
Information – background operational and financial information. The main players in this space are now the large finance portals (Yahoo, AOL, MSN, Google, etc). They built and extended these offerings in the Web 1.0 and 2.0 days. The business model is primarily advertising – free to consumers. It should also be noted that there is still a paid market for detailed and timely financial information (Reuters, Bloomberg, Capital IQ, etc).
Analysis – what does the information mean? Should I buy a particular stock? What is this stock worth? Full-service brokers still compile research notes and reports for clients – but this space has begun to be disrupted. This disruption is coming from a number of areas:
Qualitative – primarily finance blogs. These take two main forms: user-generated content aggregators (i.e. SeekingAlpha) and traditional journalism on the web (i.e. The Business Insider).
Community Sites – where retail investors look to communities of investors for advice on where to invest. Examples: The Motley Fool, Wikinvest, Covestor, KaChing, etc.
Niche Tool Providers – primarily quantitative-based tools. For example Valuecruncher.
Execution – the actual buying and selling of stocks. The discount brokers have come to dominate this space (i.e. Charles Schwab, ETrade, etc). They disrupted full-service brokers with simple flat-rate commission structures starting in the Web 1.0 days.
That is a high-level view of where we are today. What might happen next?
We completed a scenario planning exercise based on the frameworks developed by people like Peter Schwartz.
We started with an analysis of trends and uncertainties. A trend is something that we feel certain is occurring. An uncertainty is something that could still go either way.
Trends
Uncertainties
We then construct a basic scenario matrix. These scenarios are not meant to reflect concrete versions of possible future states but rather to illustrate the potential impact of the identified trends and uncertainties. There will be components of all of the scenarios in the future – this analysis is intended to emphasize trends and uncertainties. We look at the winners in each scenario and where the portals come out.
Scenarios
Implications
This is one view of the potential future. Tell us what you think.
Valuecruncher Future Of On-Line Finance Summary (Four-page PDF summary).
Disclosure: No Positions
Running The Numbers - Starbucks ($SBUX) Looks Frothy
Starbucks ($SBUX) is in an interesting position. You would expect premium coffee purchases to be down in the current economic climate. The company has also just raised prices on some beverages. Yet $SBUX is currently trading toward the top of their 52-week range at US$19.35. Time to have a bit of a look.
Valuecruncher Interactive Analysts Report For Starbucks ($SBUX)
The key comparators are Tim Hortons ($THI), a direct competitor, and McDonalds ($MCD), a low-cost substitute. You can change the generated peer companies on the site.
So what do we think?
Discounted Cash Flow Valuation
We have completed a discounted cash flow valuation using our interactive tools (there is a “discounted cash flow analysis” link just under the company name on the company page). We have populated our model with a mixture of consensus analyst estimates and Valuecruncher estimates. Our analysis produces a valuation of US$11.95 for $SBUX - 38.7% below the current share price. We see $SBUX well overvalued using a discounted cash flow model. But how about compared to a peer group?
Comparison Analysis
I am going to look at two of the metrics we use at Valuecruncher - Enterprise Value (EV)/Revenue and EV/EBITDA. Enterprise Value (EV) is simply market capitalization plus net debt [long-term borrowings less cash]. We use EV to capture the impact of debt and cash on a company’s balance sheet - market capitalization doesn’t capture different capital structures when comparing companies.
EV/Revenue shows how a dollar of revenues is being valued by the market against the comparator set. On an EV/Revenue basis $SBUX is trading at 1.5x ($SBUX is being valued at 1.5x last year’s revenues). This compares to $THI at 3.0x and $MCD also at 3.0x. $SBUX’s profit margins (at the EBITDA line) were 11.6% of revenues last year - against 25.4% at $THI and 31.5% at $MCD. A dollar of $SBUX revenues is being valued at half that of a dollar of $THI and $MCD revenues - this is broadly in-line with the difference in profit margins in the businesses last year. This is what we would expect.
EV/EBITDA shows how a dollar of profit (measured in as Earnings Before Interest Taxes Depreciation and Amortization) is being valued by the market against the comparator set. On an EV/EBITDA basis $SBUX is trading at 12.7x ($SBUX is being valued at 12.7x last year’s profit at the EBITDA line). $THI is trading at 11.8x and $MCD is trading at 9.3x. This difference will represent the different expected profit margins and growth prospects between the businesses - as being valued by the market. We are surprised that $SBUX profits are being more highly valued than their competitors. This suggests that the market currently believes that $SBUX’s fortunes are about to improve significantly and some of the gains are already being priced into the stock.
Summary
Based on our DCF valuation - $SBUX looks significantly overvalued. Looking at some comparators we are surprised that $SBUX is being so highly valued (especially on an EV/EBITDA basis) agaist key comparators $THI and $MCD. $SBUX looks a sell at these prices.
Disclosure: no positions.