In our earlier review of Intel's Income Statement, we compared the actual results to our "look-ahead" estimates.
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.
Intel is the foremost manufacturer of integrated circuits for computers, servers, hand-held devices, and communication products. 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:
- Cash Management: 20 of 25 (up from 17 in December)
- Growth: 24 of 25 (up from 5)
- Profitability: 20 of 25 (up from 12)
- Value: 4 of 25 (up from 1)
- Overall: 55 of 100 (up from 32)
| Cash Management | 27 Mar 2010 | 26 Dec 2009 | 28 Mar 2009 | 5-yr Avg |
| Current Ratio | 2.7 | 2.8 | 2.9 | 2.5 |
| LTD/Equity | 4.8% | 4.9% | 3.0% | 4.5% |
| Debt/CFO (years) | 0.2 | 0.2 | 0.1 | 0.2 |
| Inventory/CGS (days) | 67.5 | 70.4 | 75.4 | 74.4 |
| Finished Goods/Inventory | 35.1% | 35.1% | 40.0% | 37.8% |
| Days of Sales Outstanding (days) | 20.0 | 20.9 | 24.3 | 28.2 |
| Working Capital/Revenue | 32.9% | 34.3% | 34.4% | 32.7% |
| Cash Conversion Cycle Time (days) | 44.3 | 43.9 | 48.1 | 54.5 |
| Gauge Score (0 to 25) | 20 | 17 | 10 | 13 |
The Cash Management metrics for Intel continued to improve, pushing the gauge score into excellent territory.
The continuing progression towards fewer Days of Sales Outstanding is also indicative of improved cash efficiency.
Debt is minimal relative to Equity and Cash Flow. Working Capital is consistent with the company's historical norms.
| Growth | 27 Mar 2010 | 26 Dec 2009 | 28 Mar 2009 | 5-yr Avg |
| Revenue growth | 9.2% | -6.5% | -10.5% | 1.4% |
| Revenue/Assets | 73.5% | 67.8% | 68.8% | 74.7% |
| Operating Profit growth | 52.4% | 22.0% | 2.9% | 30.5% |
| CFO growth | 63.6% | 2.2% | -31.6% | 47.8% |
| Net Income growth | 38.1% | -17.4% | -34.0% | 59.9% |
| Gauge Score (0 to 25) | 24 | 5 | 0 | 8 |
The Operating Profit rate is the annualized rate of growth in Operating Profit after Taxes over the last 16 quarters.
The Growth gauge soared to within a point of a perfect score. Intel's growth metrics -- good by most any standard -- are magnified because recent strong quarters are being compared with weak year-earlier results.
Trailing year Revenue turned positive after five successive quarters in the red. This greatly abetted the gauge's rise. The sharp increase in Revenue as a percentage of Assets also fed the rebound.
Cash Flow from Operations during the March 2010 quarter was $4.1 billion, up from $378 million one year earlier. The latest amount was the best since 2007. Trailing-year Cash Flow was a record.
| Profitability | 27 Mar 2010 | 26 Dec 2009 | 28 Mar 2009 | 5-yr Avg |
| Operating Expenses/Revenue | 70.2% | 75.3% | 77.2% | 75.5% |
| ROIC | 28.2% | 22.5% | 19.8% | 23.4% |
| Free Cash Flow/Invested Capital | 37.3% | 22.6% | 11.2% | 16.6% |
| Accrual Ratio | 4.2% | 2.2% | -0.2% | 6.8% |
| Gauge Score (0 to 25) | 20 | 12 | 8 | 12 |
The Profitability gauge also streaked higher as margins and returns (both earnings and cash flow) improved substantially.
The rising accrual ratio bears watching as potential cautionary sign. Quality of earnings is considered better when the ratio is negative and getting lower.
| Value | 27 Mar 2010 | 26 Dec 2009 | 28 Mar 2009 | 5-yr Avg |
| P/E | 20.4 | 26.3 | 19.4 | 21.0 |
| P/E vs. S&P 500 P/E | 1.1 | 1.3 | 1.0 | 1.2 |
| PEG | 0.4 | 1.2 | 6.8 | 2.3 |
| Price/Sales | 3.3 | 3.3 | 2.5 | 3.3 |
| Enterprise Value/Cash Flow (EV/CFO) | 7.6 | 9.2 | 8.5 | 7.1 |
| Gauge Score (0 to 25) | 4 | 1 | 6 | 8 |
| Share Price ($) | $22.24 | $20.33 | $15.42 | - |
While earnings, sales, and cash flow have all increased mightily, Intel's share price has also moved higher. This kept the Value gauge from rising more.
The ideal case is strong financial metrics not appreciated by the markets.
The Price-to-Revenue ratio avoids complications such as special charges and variable tax rates.
| Overall | 27 Mar 2010 | 26 Dec 2009 | 28 Mar 2009 | 5-yr Avg |
| Gauge Score (0 to 100) | 55 | 32 | 29 | 40 |
After a tough stretch in early 2009, recent excellent quarters have pushed the Overall gauge up into a very attractive area. A dip in the share price would help the Value gauge and provide the last bit of impetus to get the Overall gauge over 60 points.
Full disclosure: Long INTC at time of writing.
Posts
No comments:
Post a Comment