Apple 2.0

Covering the business that Steve Jobs built

Is Apple undervalued at $260?

July 26, 2010: 11:21 AM ET

Yes, says a Romanian mathematician. But not as much as Microsoft.

Click to enlarge: Source: Nicolae Mihalache Ciurdea

Having run-up an even $100 (62%) over the past year, it's hard to think of Apple  as a bargain at $259.10 a share. But that's how you should look at the stock, according to a historical analysis of Apple's share price sent to us over the weekend by Nicolae Mihalache Ciurdea, a Romanian mathematician who teaches at the University of Paris and was one of the blogger-analysts who participated in last week's earnings smackdown.

He charts Apple's (AAPL) performance over the past 12 quarters using a series of criteria, the most familiar being its trailing price-to-earnings ratio, which fell during the financial crisis from a high of 51.5 in Q4 2007 to a low of 12.8 in Q1 2009 before recovering to just under 19.6 today.

But he quickly moves beyond P/E to more sophisticated measures, namely

  • P - $/E = The ratio of share price minus cash holdings to earnings
  • PEG = Price over earnings divided by annual growth rate
  • P - $EG = PEG after Apple's cash holdings are taken out of the share price

The last two criteria, he argues, are the best way to measure the value of a stock, because a company that is growing rapidly and has a huge cash hoard should be more valuable to investors than one that isn't growing and carries a lot of debt. Historically, a PEG (or P - $EG) less than 1 is considered undervalued.

That sounded reasonable to us. So we took Ciurdea's analysis one step further and applied it not just to Apple, but also to Google (GOOG), Amazon (AMZN), Hewlett-Packard (HPQ) and Microsoft (MSFT). We used Friday's closing price and the most recent quarterly earnings to measure growth year over year.

Can you guess which of the five stocks, by this measure, is the most valuable, and which the least? Answers below the fold.

All five stocks have PEGs below 1, so can be considered undervalued.

But measured by P - $EG, Microsoft at $25.81 is the best bargain and Google at $490.06 is the worst.

Apple is close behind Microsoft -- twice as valuable at $259.94 as HP at $46.5 and three times as valuable as Google.

UPDATE: At the request of several readers, I've taken another crack at the spreadsheet, this time using forward-looking EPS and P/E ratios, cash and marketable securities (not just cash) and long-term growth estimates from Thomson Financial. Here's what that looks like:

In this version -- which uses different data than Ciurdea's model --  things have tightened up considerably. Google has zoomed ahead of both Apple and Microsoft, and Amazon has moved into overvalued territory.

In the end, Daniel ("deagol") Tello, who helped me work through several iterations of the spreadsheet -- each with very different results -- had this to say:

"I'm sure by now you realize how futile this exercise is. The conclusion of who ends at the top or the bottom in the PEG column is only as good as analysts consensus for next year's EPS and the LT growth. AMZN and GOOG used to beat analysts handsomely, except for the last couple of times when they've come soft or even missed. HPQ and MSFT tend to beat only by a small margin.
AAPL is almost always a huge blowout. Consecutively for the last 27 quarters. That's almost 7 years."

See also:

[Follow Philip Elmer-DeWitt on Twitter @philiped]

Join the Conversation
About This Author
Philip Elmer-Dewitt
Philip Elmer-Dewitt
Editor, Apple 2.0, Fortune

Philip Elmer-DeWitt has been covering Apple since 1982, first for Time Magazine, and now on the Web for Fortune.com.

Email | @philiped | RSS
Featured Newsletters

Every morning, discover the companies, deals and trends in tech that are moving markets and making headlines.

Receive Fortune's newsletter on all the deals that matter, from Wall Street to Sand Hill Road. SUBSCRIBE

Covering the digital giants of Silicon Valley and beyond, an in-depth look at enterprise companies, and the startups disrupting them. Emailed twice weekly.

Anne Fisher answers career-related questions and offers helpful advice for business professionals.

Company Price Change % Change
Bank of America Corp... 6.99 -0.03 -0.43%
JPMorgan Chase and C... 33.13 -0.36 -1.07%
Yahoo! Inc 15.53 0.11 0.71%
Lowe's Companies Inc... 25.80 -2.68 -9.39%
Motorola Mobility Ho... 39.96 0.76 1.94%
Data as of 10:14am ET
Index Last Change % Change
Dow 12,444.50 75.12 0.61%
Nasdaq 2,804.51 25.72 0.93%
S&P 500 1,305.50 10.28 0.79%
Treasuries 1.74 0.03 1.94%
Data as of 10:29am ET
Most Popular
Facebook stock falls below IPO price
 
Fiscal cliff: Market sting may come sooner
 
Stocks set to rebound
 
Facebook employees have millions. Now what?
 
JPMorgan Chase loss only going to get worse
 
Powered by WordPress.com VIP.