Seeking Alpha
Tech, carmakers, alternative energy, dividend investing
Profile| Send Message|
( followers)  

Among the wildly varied numbers (the last link is a good analysis) from professionals and independents for Apple (NASDAQ:AAPL), I see all kinds of analysis ranging from sales numbers, margin projections, technical analysis all presented with pretty charts.

That got me thinking of one more number which is not often charted. Apple's guidance vs. actuals. I have provided a table of that for the last few quarters below. (Rev in billions, EPS in $).

QuarterGuidance RevGuidance EPSActual RevActual EPSRevenue Beat %EPS Beat %
Q2 201232.58.538.4*12.1*18.2*42.7*
Q1 2012379.346.313.925.1351449.46237
Q4 2011255.528.3713.227.27273
Q3 201123528.67.824.3478356
Q2 2011224.924.76.412.2727330.61224
Q1 2011234.826.76.416.0869633.33333
Q4 2010183.4420.34.612.7777833.72093
Q3 201013.22.315.73.5118.9393952.6087
Q2 2010112.113.53.3322.7272758.57143

*The numbers in italics represent estimates based on the average % that Apple beat estimates by in the last 8 quarters.

Here is a chart showing the percentage beat for revenue and EPS: (click to enlarge)Apple Guidance vs Reality

If we follow the EPS trendline down to 35%, it would be an estimate of $11.50 for Q2 2012. In my opinion the Q3 2011 beat was so big because of general underestimation of iPad2 sales. In a similar vein Apple might have been underestimating the launch of the new iPad as far as guidance goes. This time Apple had so much supply that everyone who wanted an iPad got an iPad. There was enough stock to go around and no shortages.

Even if Apple were to beat by the lowest of all quarters (13% revenue, 27% EPS beats), revenue and EPS would be about $36.4B and $10.80, respectively, with the EPS expectations being a lot higher than average analyst estimates of $9.90 and revenue being about on par.

Let's say we go the other way and take the top numbers (24% revenue and 58% EPS) - we get $41.6B in revenues and $13.4 EPS.

Let's look at it another way, using actual revenue and EPS numbers:(click to enlarge)

From that chart trendline we have revenues of $44.3B and EPS of $12.50. So going by either historical trend, we can expect another "blowout" quarter handily beating average analyst estimates.

As for the current correction, take that as a golden opportunity to buy Apple stock.

Source: Q2 2012 Predictions Based On Apple Guidance History And Actual Growth