02 August 2010

INTC: Financial Gauge Analysis for the June 2010 Quarter

Intel Corporation (NASDAQ: INTC) earned $0.51 per diluted share in fiscal 2010's second quarter

In our earlier review of Intel's Income Statement, we compared the actual results to our "look-ahead" estimates.  Reported earnings were $0.09 better than the $0.42 per share we had forecast for the second quarter.

We have now updated the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.  This post reports on the metrics for Intel and the associated financial gauge scores.  The metrics were calculated using data from Intel's current and historical financial statements, including the latest 10-Q.

Before getting into the details, we will take one step back to introduce the subject of today's analysis.

Intel is the foremost manufacturer of integrated circuits for computers, servers, hand-held devices, and communication products.  The company has nine product groups, with PC Client and Data Center being the two largest.  Additional background information about Intel and the business environment in which it is currently operating can be found in the look-ahead.

In summary, Intel's latest quarterly results produced the following changes to the gauge scores:

The current and historical values for the financial metrics that determine the gauge scores are listed below, with some brief commentary.  Readers are encouraged to verify these figures and calculate others as they see fit using the filings available at the SEC's web site and elsewhere.

Cash Management26 Jun 201027 Mar 201027 Jun 20095-yr Avg
Current Ratio3.
LTD to Equity4.5%4.8%3.0%4.7%
Debt/CFO (years)
Inventory/CGS (days)70.867.574.674.6
Finished Goods/Inventory38.9%35.1%43.2%38.1%
Days of Sales Outstanding (days)19.320.023.627.6
Working Capital/Revenue34.0%32.9%34.7%32.4%
Cash Conversion Cycle Time (days)45.344.347.854.1
Gauge Score (0 to 25)1320713

The Cash Management score reacted negatively to Inventory growth, which reversed a trend towards leaner inventories.  The inventory level relative to the Cost of Goods Sold expanded by more than 3 days during the second quarter.  Although a significant jump, the Inventory level remains comfortably below historic highs (see chart).

The ratio of Finished Goods in the Inventory also shot up in the latest quarter, which can sometime signal slower sales.

In the 10-Q, Intel indicates that the inventory buildup is associated with new products and in anticipation of stronger sales during the second half of the year.  The company frankly states:  "We are comfortable with inventory levels across the supply chain."

Debt is minimal relative to Equity and Cash Flow.  Working Capital is consistent with the company's historical norms. 

The continuing progression towards fewer Days of Sales Outstanding is indicative of improved cash efficiency.

Growth26 Jun 201027 Mar 201027 Jun 20095-yr Avg
Revenue Growth22.0%9.2%-15.9%4.4%
Operating Profit Growth64.5%52.4%4.8%46.5%
CFO Growth55.2%63.6%-29.4%72.3%
Net Income Growth281.9%38.1%-65.1%69.7%
Gauge Score (0 to 25)242409
Revenue, CFO, and Net Income growth rates compare the last four quarters to the four previous quarters.
The Operating Profit rate is the annualized rate of growth in
Operating Profit after Taxes over the last 16 quarters.

The Growth gauge remained within a point of a perfect score.  The growth rates listed above are stellar, even if they have been amplified by weakness in late 2008 and early 2009.

Trailing-year Revenue hit a record high, and the Revenue growth rate, which turned positive only one quarter earlier, is now over 20 percent.  Revenue as a percentage of Assets is also encouragingly back over its long-term average after a weak spell.

The Cash Flow and Net Income growth rates are certainly not sustainable, but the trends are encouraging.  Intel achieved $3.5 billion in Cash Flow from Operations during the last three months.

Profitability26 Jun 201027 Mar 201027 Jun 20095-yr Avg
Operating Expense/Revenue66.2%70.2%78.7%75.1%
Free Cash Flow/Invested Capital37.6%37.3%13.6%17.6%
Accrual Ratio9.2%4.2%-4.1%7.1%
Gauge Score (0 to 25)22201013

The Profitability gauge continued to move higher as margins and returns (both earnings and cash flow) improved substantially.

The Return on Invested Capital is not quite at a high for the last decade or so, but it is getting close.

The rising accrual ratio is something we need to watch.  Quality of earnings is generally considered better when the ratio is negative and getting lower.

Value26 Jun 201027 Mar 201027 Jun 20095-yr Avg
P/E vs. S&P 500 P/E
Enterprise Value/Cash Flow (EV/CFO)
Gauge Score (0 to 25)16438
Share Price ($)$20.03$22.24$16.29-

The Value gauge soared because Intel's share price fell, while revenue, earnings, and cash flow from operations all increased substantially.  When the quarter ended, the shares were selling at a significant discount to their historical multiples.

The Price-to-Sales ratio, which avoids complications such as special charges and variable tax rates, is near a historic low.

Overall26 Jun 201027 Mar 201027 Jun 20095-yr Avg
Gauge Score (0 to 100)72552341

After a tough stretch in 2009, a string of excellent quarters have now pushed the Overall gauge up into a very attractive area. 

Full disclosure: Long INTC at time of writing.

No comments:

Post a Comment