Time to Discount Intel?
Matthew is a member of The Motley Fool Blog Network -- entries represent the personal opinion of the blogger and are not formally edited.
Last week I wrote a post in which I provided a basic analysis and comparison of Intel (NASDAQ: INTC) and some of its major competitors. Based on the P/E and P/FCF ratios, I suggested that perhaps Intel wasn't priced perfectly for a safe, high-yield investment.
When comparing Intel’s P/E of roughly $11.10 to the 18.33 of Texas Instruments (NASDAQ:TXN), the 16.50 of Qualcomm (NASDAQ: QCOM), and the 16 of NVIDIA (NASDAQ: NVDA), it appears that Intel is underpriced. However, with Intel’s P/FCF of roughly 32.60 compared to the 31.10 of Advanced Micro Devices (NYSE: AMD), the 33.50 of NVIDIA, and the 106.50 of Qualcomm, conclusions become fuzzy. It appears from a comparison of Intel’s P/FCF to its competitors, that it is priced somewhat fairly (and much better than that of Qualcomm). However, as I stated in my previous post, regardless of competitor comparisons, a P/FCF in the 30s is two times more than the P/FCF I’d like to see. But still, the P/FCF cannot tell me for sure if Intel is under or overpriced.
As previously stated, the best way to determine if a company's stock is priced well (and by well, I mean below its intrinsic/fair value) is to use a discounted cash flow analysis. In that vein, I wanted to prepare a very basic discounted cash flow analysis to see if my original conclusion was justified.
Let me start by saying the discounted cash flow analysis is built primarily of assumptions and is therefore only as good as the accuracy of those assumptions. Therefore, I prepared the analysis under two different scenarios, using both conservative and aggressive assumptions for revenue growth. All other assumptions were held constant. Keep in mind that the other assumptions can have a significant impact on the end value as well. However, for simplicity and comparison sake, I have kept them constant. The purpose of this analysis is just to provide a basic range of potential fair values based on revenue growth (again, I'm no expert and simply want to know if my previous conclusion based on P/E and P/FCF ratios was at least directionally correct).
Time to Discount Cash Flows
To begin with, we'll look at Intel's pricing based on 5-year conservative growth rates. Subsequently, we’ll look at Intel’s pricing based on 5-year aggressive growth rates.
Conservative Growth
In millions, except for intrinsic value
|
|
Year 0 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Terminal |
|
Revenue Growth |
|
20% |
20% |
10% |
10% |
10% |
3% |
|
Revenue |
53,999 |
64,799 |
77,759 |
85,534 |
94,088 |
103,497 |
|
|
OPEX/Revenue |
68% |
68% |
68% |
76% |
76% |
76% |
|
|
OPEX |
(36,522) |
(44,063) |
(52,876) |
(65,006) |
(71,507) |
(78,657) |
|
|
Tax/Operating Income |
28% |
28% |
28% |
28% |
28% |
28% |
|
|
Tax |
(4,839) |
(5,806) |
(6,967) |
(5,748) |
(6,323) |
(6,955) |
|
|
Net CAPEX/Revenue |
10% |
10% |
10% |
3% |
3% |
3% |
|
|
Net CAPEX |
(5,623) |
(6,480) |
(7,776) |
(2,566) |
(2,823) |
(3,105) |
|
|
Change in Working Capital |
331 |
(500) |
(500) |
(250) |
(250) |
(250) |
|
|
Free Cash Flow |
7,346 |
7,950 |
9,640 |
11,964 |
13,186 |
14,529 |
166,280 |
|
Discount Rate |
|
12% |
12% |
12% |
12% |
12% |
12% |
|
Discounted Cash Flow |
|
7,098 |
7,685 |
8,516 |
8,380 |
8,244 |
94,352 |
|
|
|
|
|
|
|
|
|
|
Sum of Discounted Cash Flows |
|
|
|
|
|
|
134,275 |
|
Long-Term Debt |
|
|
|
|
|
|
13,180 |
|
Equity Value |
|
|
|
|
|
|
121,095 |
|
Shares Outstanding |
|
|
|
|
|
|
5,031 |
|
Estimated Intrinsic Value |
|
|
|
|
|
|
$24.07 |
Aggressive Growth
In millions, except for intrinsic value
|
|
Year 0 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Terminal |
|
Revenue Growth |
|
25% |
25% |
20% |
15% |
10% |
3% |
|
Revenue |
53,999 |
67,499 |
84,373 |
101,248 |
116,435 |
128,079 |
|
|
OPEX/Revenue |
68% |
68% |
68% |
76% |
76% |
76% |
|
|
OPEX |
(36,522) |
(45,899) |
(57,374) |
(76,949) |
(88,491) |
(97,340) |
|
|
Tax/Operating Income |
28% |
28% |
28% |
28% |
28% |
28% |
|
|
Tax |
(4,839) |
(6,048) |
(7,560) |
(6,804) |
(7,824) |
(8,607) |
|
|
Net CAPEX/Revenue |
10% |
10% |
10% |
3% |
3% |
3% |
|
|
Net CAPEX |
(5,623) |
(6,750) |
(8,437) |
(3,037) |
(3,493) |
(3,842) |
|
|
Change in Working Capital |
331 |
(500) |
(500) |
(250) |
(250) |
(250) |
|
|
Free Cash Flow |
7,346 |
9,302 |
11,502 |
14,708 |
16,877 |
18,540 |
212,176 |
|
Discount Rate |
|
12% |
12% |
12% |
12% |
12% |
12% |
|
Discounted Cash Flow |
|
8,305 |
9,170 |
10,469 |
10,726 |
10,520 |
120,394 |
|
|
|
|
|
|
|
|
|
|
Sum of Discounted Cash Flows |
|
|
|
|
|
|
169,584 |
|
Long-Term Debt |
|
|
|
|
|
|
13,180 |
|
Equity Value |
|
|
|
|
|
|
156,404 |
|
Shares Outstanding |
|
|
|
|
|
|
5,031 |
|
Estimated Intrinsic Value |
|
|
|
|
|
|
$31.09 |
As you look over the tables above, it’s imperative that you remember a slight change in any of the assumptions could have a significant impact on the intrinsic value. As such, you should adjust the analyses based on your own estimates and assumptions (as mine are just that – assumptions). Don’t believe Intel will achieve the growth rates used above? Fine, adjust accordingly. Think Intel will achieve better operating margins? Again, adjust accordingly. You can take from the basic framework I’ve used above and adjust it for your own assumptions and therefore calculate your own estimate of Intel’s true, fair value. The whole point is to make a more informed investing decision, not one built purely of speculation.
Time to Discount Intel
As you can see from the analyses, Intel’s pricing under conservative and aggressive growth scenarios, and based on the underlying assumptions above, is anywhere from $24.07 to $31.09. So, what does all this mean? Considering Intel’s pricing today at roughly $26.17 per share, I would say Intel is priced very close to its intrinsic value. Therefore, consistent with my previous conclusion based on the P/FCF analysis, I would not recommend investing in Intel.
This is not to say that Intel isn’t a great company and won’t ultimately achieve high returns for investors. It’s simply to say that based on my own analysis, I don’t believe Intel is underpriced enough to warrant a safe investment for value investors. If Intel drops below $24.07 anytime soon, then I might be more tempted to buy, as the price would then be below my conservative threshold. Until then, I’ll keep a watchful eye on the price and continue looking for other companies that might be undervalued.
mattmcmichen has no positions in the stocks mentioned above. The Motley Fool owns shares of Intel and Qualcomm. Motley Fool newsletter services recommend Intel and NVIDIA. Try any of our Foolish newsletter services free for 30 days. We Fools may not all hold the same opinions, but we all believe that considering a diverse range of insights makes us better investors. The Motley Fool has a disclosure policy.If you have questions about this post or the Fool’s blog network, click here for information.