Tuesday, February 18, 2025

Home Depot (HD): A Company Analysis and Valuation

(Disclaimer: Excel file attached below the post) 

Home Depot, Inc. is the largest home improvement retailer in the world based on net sales of $152.7BB for FY '23. The stock has returned +18.95% in 1 year while the S&P 500 returned +22.34%, but the story reverses course if we look at the last 5  year's returns; HD's returns increased +95.35% while the S&P 500, in the same timeframe, returned +81.34%. The stock is currently trading at 27.9x its earnings and at 18.8x EBITDA. Additionally, I was amazed by the company's performance over the last quarter in which HD was expected to post EPS of $3.64 but ended up reporting $3.78, easily beating the estimates. So, is this one of the best dividend paying value stocks? I will begin by looking at the company, its business, past and historical performance, compare the company to some of its contemporaries, and finally end the post with what I think is its fair intrinsic value. 

Home Depot

Home Depot is the largest home improvement retailer in the world, and offers customers a wide assortment of building materials, home improvement products, lawn and garden products, decor products, and facilities maintenance, repair and operations products as well as providing a number of related services such as home improvement installation and tool and equipment rental. As of the end of FY '23, HD operates 2,335 stores that are strategically located throughout the U.S., Canada and Mexico. The stores average approximately 104,000 square feet of enclosed space with approximately 24,000 additional square feet of outside garden area. Home Depot also maintains a network of distribution and fulfillment centers along with a number of e-commerce websites in the U.S., Canada and Mexico. Home Depot serves three distinct types of customers: Do It Yourself (DIY), Do It For Me (DIFM), and Professional Customers (Pros). 

Historical Performance


Historically speaking, Home Depot has been one of the best performing companies; the company has put up consistent numbers in terms of revenue and revenue growth rate, COGS as a % of net sales or total revenues, operating income and margins and net income and net margins. If we look at the the last five years, HD's top line grew from $110BB in FYE '20 to $153BB by the end of FYE '24. Cost of goods sold, or COGS in wall street parlance, has consistently been around 66% of net sales, which given the growth and the ebbs and flows of net sales, is an amazing operational achievement. Additionally, over the last 5 years, the company reported gross margins in the range of 33% to 34%. SG&A expense has understandably increased from $19.7BB in FYE '20 to $26.5BB by the end of FYE '24 given the top line growth. I believe where the company truly stands out is in its margins; HD has reported consistent margins (gross, operating and net) over the last five years despite issues such as supply bottlenecks, pandemic, inflation, high interest rates, and geo-politics. 


As you can see from the image above, historical margins over the last five years have been consistent despite the multitude of micro and macro factors impacting the company, its broader industry, and specifically its subsector. Starting with its gross margins over the last five years, the company reported consistent gross margins in the range of 33% to 34% and this consistency in gross margins implies that the company clearly has a competitive advantage and is vividly able to dictate terms with its suppliers and business partners. Operating margins tell a similar tale where the company has been able to notate margins in the range of 14%-15% clearly solidifying the company's competitive advantage and its position in the industry. Lastly, HD reported 10% net margins over the last five years, and as we know, positive net margins directly translate into dividends and share repurchases. With an understanding of the company's business and its performance, here is a peak at its historical income statement:


Home Depot's income statement highlights why the company is trading at the multiples that it is, but income statements are typically ruined by the fact that companies follow accrual accounting and so the numbers the companies put out in their income statements reflect profitability in terms of GAAP rules and regulations, but give no insight as to the company's ability to generate positive cash flows or its ability to meet is obligations; in order to better understand any given company's liquidity and its ability to meet its near and long-term obligations, we have to look at its cash flow statement as that is the one statement where we can tell exactly how much cash has come in and gone out of the business, so here is a look at HD's cash flow statement over the last three years:


As we can see, not surprisingly, HD has had positive operating cash flows over the last three years (the company reported OCF of $21BB for FYE '24), and this positive cash flow is driven by multiple factors; firstly, the company's growth in its NI and that is the first line item in company's operating activities; secondly, it is further accentuated by the additions of non-cash items such as D&A and stock based compensation; and lastly and perhaps most importantly, HD's grip on its current assets and current liabilities. If I were to dissect the company's working capital items I would see a really impressive inventory turnover, its superior ability to turn its AR into cash, and its bargaining power in the shape of AP among other things.
As is also evident from the image above, the company has reported FCF of $14BB, $11.5BB, and $18BB for FYE '22, FYE '23, and FYE '24, respectively, which also explains the company's ability consistently issue dividends and conduct share repurchases along with meeting its debt obligations. Let's now take a look at the company's balance sheet as it highlights the company's long-term position.


To quote every finance and accounting book out there, balance sheet is a snap shot of a company's assets, liabilities and equity at any given point in time, and if we need to assess a company's liquidity, balance sheet probably is as crucial as the cash flow statement. HD has kept a reasonable amount of cash on hand as well as having more current assets than current liabilities which obviously equates to the fact that the company, over the last five years, has been in a comfortable position in terms of liquidity. One off-putting thing that I see here is the amount of debt the company has on its balance sheet; as we can see, for FYE '24, the company has long-term debt in the amount of $43BB, excluding the operating lease liabilities, which explains its high interest expense. I believe that the company has a solid enough credit profile as well as FCFs and liquidity, but raising further debt could impact the company's debt profile and as a result, its margins and profitability. Lastly, we look at the company's financing activities, we can clearly see that the company is using its FCFs to return value to the shareholders in the form of massive buybacks and dividends. With this understanding, I believe we are in a suitable place where we can look at other companies in the sector and compare HD's performance with its peers before we move onto the valuation. 

Comparable Companies Analysis

This is not a full blow comparable companies analysis where I try to value/price the company based on its peers and their performance, but rather this is a nuanced approach where I will compare HD to a select few contemporaries and look at a few data points and try and assess if the company is trading at a premium, discount or par. For the purposes of this exercise, I will compare Home Depot to three of its very close peers: Loew's, Floor & Decor, and Arhaus.

Home Depot:

Home Depot has a market value, as of this post, of $407BB, and given its debt and cash and cash equivalents, an enterprise value of $468.6BB, which means that the company is trading at 18.76x EBITDA. The company based on 14.73 diluted earnings per share, is trading at 27.80x times its earnings. The stock has returned 17.32% over the last year. As of this post, the company reported revenues of $152.6BB, operating expenses of $29.2BB, operating income of $21.7BB, and gross profit of $50.96BB. HD has inventory of approximately $23.9BB and AR turnover of 33.72. As stated before, for the last reported fiscal year, the company reported OCF of $21.17BB and FCF of $18BB. Company reported operating, gross, and profit margins of 14.2%, 33.4, and 9.9%, respectively, for the latest reported year. Additionally, the company reported ROA of 16.91% and ROIC of 26.88%. 

Lowe's

Lowe's has a market cap, as of this post, of $142BB and an enterprise value of $178.6BB, which means that the company is trading at 14.37x its EBITDA. The company is trading at 20.95x times its earnings and has a diluted earnings per share of 12.02. Over the last one year, the company has returned 12.99%, which is lower than HD which, as stated before, returned 17.32% over the same period. According to the latest numbers, Lowe's reported revenues of $83.7BB with operating expenses of $17.5BB, operating income of $10.3BB, and gross profit of $27.8BB. Lowe's has inventory of $17.6BB, OCF of $9.82BB, and FCF of $7.82BB with capex of $2BB. As of this post, the company reported operating, gross, and profit margins of 12.33%, 33.21, and 8.17%, respectively. Lastly, the company has basic EPS of 12.04, ROA of 15.67% and ROIC of 29.57%. 

Floor & Decor

Floor & Decor has a market equity value of $10.47BB and an enterprise value of $11.98BB. The company is trading at 54.22x it earnings and 25.46x its EBITDA, which of course imply that the company is trading at a premium compared to HD or Lowe's. The company, over the last year, has returned -8.01% which is of course lower than both HD and Lowe's. As of this post, the company reported revenues of $4.4BB, operating expenses of $1.6BB, operating income of $288.3MM, and gross profit of $1.89BB. Additionally, the company has approximately $1.05BB and an AR turnover of 43.51 which is higher than that of HD's which has an AR turnover of 33.72, and when it comes to AR turnover, the lower the better, because it means that the company is able to turn its AR over quickly which translates into more cash for the company. Floor & Decor has cash from operations of $606.4MM, capex of $483.3MM, and FCF of $123MM and is trading at 2.40x its sales which is higher than Lowe's but slightly lower than HD's price to sales ratio of 2.63x. Moreover, the company reported operating, gross and profit margins of 6.57%, 42.9% and 4.45%, respectively. The company has basic earnings per share of 1.82, ROA of 4.08% and ROIC of 5.41%. 

Arhaus

As of this post, Arhaus has a market equity value of $1.77BB and an enterprise value of $2.11BB, and the stock is trading at 22.50x its earnings which is significantly lower than Floor & Decor and HD, but higher than Lowe's. The stock has returned 6.70% over the last year which is lower than HD's one year return, which as stated above was 17.32%. According to the latest numbers, the company reported revenues of $1.27BB, operating expenses of $404MM, operating income of $99.4MM, and gross profit of $503.7MM and the company has roughly $294.6MM worth inventory. As of this post, the company reported OCF of $139.8MM, capex of $126.9MM and FCF of 12.92MM. Additionally, the company is trading at 1.40x its sales and has operating, gross and profit margins of 7.84%, 39.72%, and 6.19%, respectively. Lastly, the company has basic earnings per share of 0.57 and ROA of 6.75% along with ROIC of 9.76%. 

Comparable Companies takeaway:
 
I think the next logical question on anyone's mind would be, "What do all the numbers mean?" Before I answer that question, I believe it is paramount to understand what multiples are and what they signify. multiples, broadly speaking, are functions of ROE/ROIC, growth rates, cost of equity/ cost of capital, reinvestment, dividend payout and retention, tax rate, operating margins and D&A, and to try and explain why companies trade at the multiples that they trade at is a futile exercise; the most we can do try and explain it, because it is more an art than science. Having said that, what can we say about HD and where it is currently trading at, is it at premium, discount or par? I believe that the stock is currently trading at par in that the company has higher ROA compared to LOW, FND and ARHS as well as a higher ROIC than FND and ARHS but lower than LOW. Moreover, the company has basic earnings per shares (NI divided by basic shares outstanding) of 14.77 which is higher than other three companies that I looked at. HD's price can be further justified when we look at the company's margins; compared to its contemporaries, the company has higher operating and profit margins while gross margins are amongst the lowest when compared to the other three companies. 
The company is trading at 18.76x its EBTIDA which is the second highest among the four companies. The company also has significantly higher FCF than its competitors as well as revenues and gross profit. Based on the comp analysis, I'd say the company is trading at par, but what about its value based on its own cash flows, expected growth, cost of capital and risk? Next we look at the company's price per share based on its discounted cash flows. 

DCF Valuation

I think I am in a better position now to talk about the company's future, or my version of it. 


Home Depot (HD) has been around for a minute now, and I think it is in a position in its corporate cycle where it is more concerned with returning value to shareholders rather than growth. Logically speaking, I believe what should transpire in the future is the management's intention to continue to return value for its shareholders through dividends and share repurchases, and not spend an obscene amount on its growth. I am not comfortable with the amount of debt the company has, but at the same time, it is not surprising at all because the company has a good credit profile and a storied history of operations which make the company's access to capital easy, but I believe they should now be more focused on repaying debt rather than raising more as they have done in the past; and this is because I believe the company's healthy amount of interest expense is eating away its profitability and value. I also believe that the company's double digit growth days are in the rears now, and going forward, the company should grow at a modest growth rate of 3% to 5%, with this in mind lets look over my base case assumptions. 

Base Case Assumptions

Revenues: Going forward, as I stated above, I do not expect double digit growth for HD, and as such, I expect Home Depot's top line to grow from $152BB in FYE '24 to $221BB by the end FY '34. I expect the revenues to grow at a constant pace due to the company's brand and its solid position as the biggest home improvement retailer in the world among other factors. I believe the company will have to traverse the harsh waters of geo-politics as well as the current administration's efforts to re-shore everything through incentives, tariffs and import taxes. 

Cost of Sales (COGS): As mentioned before elsewhere in this post, the company reported consistent numbers in terms of COGS as a % of total sales; over the last five years, HD's COGS margins (COGS divided by total sales) have hovered around 65% to 66%, and going forward, I have no reason to believe that these costs will reduce thereby improving the company's margins, and so I am estimating cost of sales somewhat in the same range for the next ten years. 

Gross Profit and Margins: Given my assumptions for total revenue growth and cost of sales, I expect the company to continue to post gross profit and gross margins in line with its historical range of 33% to 35%. I believe that, for my base case, this is a conservative enough approach to assume that the numbers will not change that much from historical trends and that the management will continue to perform the way it has been up to this point. 

Operating Income and Margins: As we saw in the comparable companies analysis section, HD has the highest operating margins amongst the four (HD included) companies that I looked at, and I believe this trend will continue into the future. I believe the company's operating income will increase from $21.7BB in FYE '24 to $36.3BB by the end of FY '34, and margins to improve from 14% in FYE '24 to roughly around 16% by the end of the projection period. I believe that the company has a competitive advantage and very clearly has a bargaining and purchasing power, and that coupled with its brand name, investment in technology and sophisticated supply chain should help the company improve its margins in the future.  

Capital Expenditures: HD's capex is the highest in the sector and that is not surprising when we look at its top-line, its global presence, and its margins. The company has historically invested about 2% of its total revenues in capital expenditures and going forward, I believe this trend will continue. I have assumed a decent top-line growth rate and to support that growth, the company will have to continue to invest in capex; going forward, I believe the company's capex should be around 2% of its total sales for the project period. 

Dividends and Share Repurchases: As I mentioned at the beginning of this section, HD is in a stage in its corporate lifecycle where it should be concerned with returning value to its shareholders, and based on that belief and assumption, I believe the company will continue to pay dividends and buy-back its own shares in line with its historical numbers. 

WACC: At the time of this analysis, the company had a beta of 1.02, the market equity risk premium was 4%, and the risk free rate was 4.53% which means that the cost of equity for HD is 8.61%. This DCF is based on FCFF and not FCFE, and so I looked at the company's footnotes to try and finesse my way around its true cost of debt. I came across the company's disclosure for its outstanding debt issuances and their respective yields, and so I decided to take the weighted average of all of its outstanding debt and use that yield as my pre-tax cost of debt, which was 3.64%, giving me a WACC of 8%. 

With my assumptions on the side, let's look at the company's going forward income statement:


As stated in my assumptions above, I expect the company's revenues to be around $221BB by the end of the projection period as well as gross, operating and profit margins that are in line with historical trends with slight improvements as the company moves into the future. I have also made some assumptions about the company's capex and by extension its PP&E along with its share repurchases and dividends, so let's see what the going forward balance sheet looks like.


If we were to believe my version of the future, I believe the company will continue to perform the way it has in the past; I expect a decent amount of cash balance along with current assets that are more than its current liabilities as well as consistent share buybacks and dividends in order to return value to the company's shareholders. Balance sheet is considered by many to show a company's strength as it is long-term compared to income statement which is short-term, and based on my assumptions, I believe the company will be in a solid position over my projection period. Let's now look at the company's pro forma cash flow statement.


As expected, I suspect the company's OCF will increase from $21BB in FYE '24 to $31BB by the end of FY '34, and I expect this increase to come from the company's growth in its NI as well as effective management of its working capital items. I have assumed capex of about 2% for the next 10 years and so I am expecting only modest growth in the company's FCF as shown in the image above. 
With an understanding of the company's statements, I think we can finally move onto DCF. Here is a snapshot of my DCF analysis:


Based on my assumptions about the company's future top-line growth, capex, margins and its WACC, I am getting a price per share of $308.29 through perpetuity growth method and $373.04 if I were to assume an exit EBITDA multiple of 15x. The stock at the time of analysis is trading at $416.36, and based on my analysis of the company and my version of the future, I believe that the company is overvalued. In order to give some credence to my analysis, I will next try and look at the changes in price per share given variations in some of the factors that I believe impact a DCF analysis. 

Sensitivity


Image 1 shows us the changes in the company's implied price per share given the changes in its WACC and long-term growth rate, and as we can see, the market is assuming that the stock is either trading at lower cost of capital and low long-term growth rate or lower cost of capital and a higher long-term growth rate, and looking at the data table, I believe that the price per share of $308.29 seems justified to me. Image 2 looks at the changes in the implied price per share given variations in terminal year EBITDA and WACC, and as we can see, if I were to assume the same WACC, the company is trading at around 17x to 18x its exit EBITDA.  Let's now look at the company's price per share given changes in revenues and margins by the end of the projection period. 


As we can see, given my assumptions around the company's operating margins of 16% and revenues of $221BB by the end of FYE '34, I do not even see the company's current stock price of $416.36 in the data table which means that the markets are attributing either higher revenues in the next ten years, higher margins or both, and I, frankly, am not comfortable with either of those scenarios. Image 4 shows changes in the price per share given variations in the company's WACC and its exit EBITDA. 

Conclusion 

In short, I believe that the company is overvalued and the markets are assigning it growth that I do not see in its future, but I guess only time will tell. As for this analysis, this is purely to satiate my own hunger for this kind of work and not a recommendation for you to buy or sell the stock; that decision I believe should only be done after you have conducted your own analysis, and to that end, I am sharing the excel file for you to play around with, and change the numbers based on what you think about the company and its sector's future, growth and risk. 

Links:



Wednesday, January 22, 2025

Dollar Tree (DLTR): A Company Valuation

(Disclaimer: Excel file attached below the post) 

Dollar Tree is one of the stores that my wife and I frequent, and it is not due to competitive prices but because of the wide variety of assortments that the stores carry, and being that I am a loyal patron, I wanted to delve deeper into the company's financials and see if it meets my criterion for holding it in my portfolio. I will be looking at the company's financials for the past 5 years and, with my understanding of its business and the retail sector overall, I will try to value the company based on its intrinsic characteristics and compare that to its current market price. 

Dollar Tree


DLTR 10-K

DLTR is one of the leading retail discount stores operator in the US and Canada and functions under the Dollar Tree, Family Dollar, and Dollar Tree Canada banners. As of the end of FY '23, the company operates 16,774 stores across 48 states in the US and five Canadian provinces. The company reports revenues and numbers for two segments: Dollar Tree and Family Dollar. 

Dollar Tree Segment

The Dollar Tree segment includes 8,415 stores operating under the Dollar Tree and Dollar Tree Canada banners, and has 15 distribution centers in the United States and two in Canada. Dollar Tree stores generally range anywhere from 8,000-10,000 selling square feet. Company primarily carried $1 items in its locations up until the recent past, and then made the pivot towards an increase where now the lowest end of the range is $1.25 whereas the upper range is in the $5 vicinity; the change was, of course, driven by the unquenchable desire to increase shareholder value as well as other number of factors that we will get into in the sections below. 
The Dollar Tree brand carries approximately 8,000 items and as of the end of FY '23, roughly 27% of the items were automatically replenished while the remaining items were either allocated to the stores or managed by direct store delivery vendors. The merchandise mix in the Dollar Tree stores consists of:
  • Consumable merchandise, which includes everyday consumables such as household paper and chemicals, food, candy, health and personal care products, and in most stores, frozen and refrigerated food. 
  • Discretionary merchandise includes:
    • Variety merchandise, which includes toys, durable housewares, gifts, stationery, party goods, greeting cards, softliners, arts and crafts supplies and other items.
    • Seasonal goods, which include, among others, Christmas, Easter, Halloween and Valentine's Day merchandise. 
Dollar Tree has historically been the largest part of the company's top line; the segment has consistently contributed more 50% of the company's total sales. As for the segment itself, net sales for this segment increased 8.9%, or $1,365MM, and this increase was mainly due to an increase in comparable store net sales of 5.8%. Gross profit margin for the segment decreased to 35.8% from 37.5% on a YOY basis even though the overall revenues increased. This decrease in gross profit margins could be attributed to an increase in merchandise costs, distribution costs, shrink costs (theft, etc.) decrease in markdowns and occupancy costs. 
Operating margin for the Dollar Tree segment also decreased  from 16.5% in FY '22 to 13.6% in FY '23. The reduction in operating margins was due to wage investments, minimum wage increases and other general liability claims. 

Family Dollar Segment

Family Dollar is the second largest part of the company's total revenues and accounted for anywhere from 45% to 48% of total sales over the last 5 years. The Family Dollar segment includes 8,359 stores operating under the Family Dollar brand and has 10 distribution centers as of the FYE '23. Merchandise at Family Dollar locations range from $1 to $10 and locations have historically ranged from 6,000- 8,000 selling square feet. 
Family Dollar stores generally carry around 11,800 items, and as of FYE '23, ~75% of the items were automatically replenished. The merchandise mix in the company's Family Dollar locations includes:
  • Consumable merchandise, which includes food, beverages, tobacco, health and personal care products, household chemicals, paper, and automotive supplies. 
  • Discretionary merchandise, which includes:
    • Home products, which include housewares, home decor, giftware, and domestics, including comforters, sheets and towels;
    • Apparel and accessories merchandise, which includes clothing, fashion accessories and shoes. 
Net sales for Family Dollar segment increased 7% on a YOY basis to $13.8B; the increase was due to an improvement in comparable and noncomparable store net sales. Gross profit margin for the Family Dollar Segment decreased from 24.4% in FY '22 to 23.9% by the end of FY '23; this decrease was due to an increase in shrink costs, increased markdowns, and increase in distribution and decrease in occupancy and merchandise costs. 
Operating margin for this particular segment decreased to (19.3)% resulting from the gross profit margin decrease, and increase in SG&A expense rate which includes the impairment charges reported for FY '23. 

Historicals

With an understanding of the company's segments, lets now look at the company's financials for the last five years starting with the income statement.

Historical Income Statement

As you can see, the company reported total net sales of $30.6BB for FY '23, which was an increase of 8% on a YOY basis and this increase was due to the increase in the Dollar Tree and Family Dollar segments we discussed in the section above. One of the things that stands out is the fact that company's COGS as a % of its total net sales have consistently been hovering around the 70% mark, and it could be due to micro reasons such as higher costs, increased in inventory as well as macro factors such increase in inflation and freight costs, or it could just be because retail industry has historically been a low margin business. Although gross margins decreased on a segment basis, the company reported positive gross margins, around 30%, for the last 5 historical years. 
Company's total operating expense as a % of net sales have also consistently been in the 22%-25% range, with the exception in FY '23 when the company reported the impairment of its Family Dollar brand that the company purchased back in 2015. Dollar Tree has also reported subpar operating margins over the last 5 years, in the 5%-8% range; I am excluding FY '23 when the operating margins were (2.9)% due to the impairment charge the company included in its yearly operating expenses. Lastly, net margins have also been consistently low; around 5% from FY '20 to FY '22, and (3)% for FY '23, again due to the impairment charge of over $1BB. Let's now move onto the company's historical balance sheet. 


The balance-sheet is pretty self-explanatory, but there are a couple of things that I think I would like to bring to your attention: the first one is the company's healthy cash and cash equivalents balance, which as you can see, was $757.2MM as of the end of the FY '23; second would be the reduction in goodwill and its related impairment for FY '23; and lastly, although the company has no short-term debt, it does have a healthy amount of long-term debt and operating lease liabilities which for analytical purposes are treated as debt. 

Industry and Competition


I think that after reviewing the segments, their performance, and the historical numbers, and before we can talk about the company's valuation, it is prudent for me to briefly discuss the retail industry and its future as well as Dollar Tree's competition. 

Retail Industry

My overall outlook of the retail industry is positive, I believe that after navigating the tumultuous COVID times, companies are well positioned to handle future headwinds. I believe that companies have acclimated to the fact that rates will be higher for a little while longer, even given the recent reductions, and are taking appropriate actions such as healthy inventory sizes, price increases, and managing their supply, occupancy, and freight costs. I also believe that companies have begun to seriously consider diversifying their offerings, take DLTR for instance, the company reports revenues in a third segment which primarily comprises of advertising revenue. With solid numbers reported in the latest employment numbers, the economy added more than 250,000 new jobs, I believe that consumers will continue to spend in the future, even going either as high as the pre-pandemic levels or maybe even higher.    
Although my outlook is positive, there are a few underlying issues that I believe will make it hard for the companies in this industry to grow their top line and margins, at least in the near future, and I would like to briefly discuss these issues.  
  • Interest Rates: The Federal Funds Rate, the rate at which financial institutions lend capital to other financial institutions, usually overnight, at the time of this post is 4.25%-4.50%. If you remember, we have had rate cuts but nearly not as much as investors were expecting which is why treasury yields have recently been rising; the yield on a 10-year treasury note was 4.8% a couple of days ago but has since come down to 4.58% as of the timing of this post. The reduction in this rate is not nearly as rapid as investors or consumers were expecting and that is partly because of the strong employment numbers as well as inflation which I believe is still around 3%. Remember, the basic premise behind rate hikes is to reduce inflation and bring employment within the FED's goals and expectations, and since that is not happening, I believe we might end the year with 3.75%-4.00% of Federal Funds Rate, and since high rates impact both the companies and the consumers, I believe Dollar Tree will not only have to earn a higher return on its investments, but will also have to compete aggressively with other players in the market for consumers and their limited budgets which will hinder the company's top line and margins, at least in the near future.  
  • Consumer Expectations: As of the writing of this post, consumer expectations have also risen in terms of what they think will happen with food prices and other everyday necessities. I believe that this increased sentiment will only be propelled by the new government's policies as well as healthy labor market and inflation. I believe that this will lead to consumers further tightening their wallets and limiting their spendings for the near future which will make it harder for companies like Dollar Tree to grow their top-line and improve their margins in the near term. 
  • Political: Dollar Tree has around 25 distribution centers which means that about 90% of Dollar Tree's locations and 70% of Family Dollar locations get their inventory from the company's own distribution centers, with remaining inventory coming from third party vendors and independent distributors. But the issue that I see here is the fact that those 25 distribution centers get their inventory from other countries such as China, and given the US's on-going quarrels with China, it should not only make it hard for the company to restock its shelves, but it might also increase the costs. 
  • Governmental Policies: Donald Trump was inaugurated as the US president on Jan 19th, and I believe his policies in terms of tariffs and trade that he has proclaimed throughout his campaign and also in his inaugural address will make it costly for Dollar Tree to do business in the country. This would mean that not only will the company need to pass the costs through to customers, which could back-fire, but it could also compel the management to spend heavily in the US in order to lessen the company's dependency on foreign distributors and business partners.  
Competition

Dollar Tree operates in not only a low-margin business but also in a industry that is highly saturated with players such Walmart, Target, Costco, Aldi, Lidl and Dollar General; not to mention your corner delicatessens and other local and regional brick and mortar brands. Dollar Tree's competitors, especially the major ones, have an immense buying and purchasing power and some have even gone so far as to create separate sections with highly competitive prices. I believe that the heightened nature of the market and its players should make it difficult for Dollar Tree to not only grow its revenues and expand its business but also make it difficult for the company to improve its margins and profitability. 

Valuation


Before we move onto the valuation, I think it might be beneficial for us to break down my assumptions (base case) for the future.
  • Revenues
    • Dollar Tree: I expect Dollar Tree segment to continue to be a huge part of the company's top-line in the future (staying relatively flat for the next 10 years with slight fluctuations on year over year basis); I believe that this will be due to Dollar Tree's strong brand name and customer loyalty. I expect revenues for this segment to increase from $16.7BB in FY '23 to $21.6BB by the end of FY '34.
    • Family Dollar: I expect family dollar's revenues as a % of the company's net sales to reduce from 45% in FY '23 to about 44% by the end of FY '34. I believe this reduction will be due to Family Dollar's weaker brand as well as the issues I mentioned in the section above. I expect Family Dollar's revenues to increase from $13.8BB in FY '23 to $17.3BB by the end of FY '34.
  • Cost of Sales: I expect cost of sales to continue to be a huge pull-down for the company's margins and profitability. I expect cost of sales to increase for the next 5 years due to the issues that I mentioned and then finally begin to decrease in year 6th and end the projection period on a high note. I expect cost of sales as a % of total sales to increase from 69.5% ($21.2BB) in FY '23 to 70% ($24BB) by the end of FY '29, and then decrease to about 65% or $24.4BB by the end of FY '34.
  • Operating Expenses: Company reported operating expenses of $9.1BB or 29.9% of total net sales, and I do not see a reason for reduction in the near future. On the contrary, I expect operating expenses to continue to rise for the next 5 years to 30% or $10.4BB for FYE '29 due to increase not only in wage and minimum wage but also to stay competitive and retain employees and talent. I expect as the company gets a better hold of its business, operating expenses should decrease to $9BB or 23% by the end of FY '34.
  • Operating Margins: As a result of my expectations surrounding company's revenues, COGS, and SG&A, I expect relatively non-existent operating margins for the next 5 years, and starting FY '30, the margins should begin to improve and end at about 12% by the end of FY '34.
  • Capex: Dollar Tree reported capex margins of 6.9% for FY '23  and given my expectations in revenue growth, I expect the company to continue to invest in capex until the end of the projection period with capex margins of 5% for FYE '34.
  • WACC: The risk free rate as of this analysis was 4.80%, DLTR's beta is 0.92, and the market risk premium is 4.00%, giving us a cost of equity of 8.48%. I could not find the yield on the latest debt the company raised and so I am making an executive decision and using 5% as my pre-tax cost of debt, and assuming a marginal tax rate of 25%, I get an after-tax cost of debt of 3.75%. Why 5%? I looked at the company's debt and the cost of debt that the company disclosed in its footnotes, and they were all a few years old, meaning the cost of debt that the company disclosed is not in line with the current market conditions, and having done these sorts of analyses before, I believe that 5% is in line with the current macro conditions. With the company's 61.08% weight of equity and 38.9% weight of debt, I get a WACC of 6.64%.
  • EBITDA Multiple: As I have said at ad nauseam at this point, I do not believe in EBITDA multiple being a part of an intrinsic valuation, but it seems to be an enticing term that everyone on the street seems to think is of paramount importance, as such, I have only recently started utilizing it in my own work. I do not know the multiple Dollar Tree is trading at due to my limited resources, but I can finesse my way into deriving one with the information I do have; my implied EBITDA multiple given my growth in perpetuity of 0.5% and WACC of 6.64% is 9.10x, and for conservatism's sake, I will assume an exit EBITDA multiple of 8x. 
With my assumptions in place, here is what the future income state looks like:


As you can see, in my base case, I am not expecting much growth in the company's future for the next 10 years and the reasons are an amalgam of what I have hinted at in the sections above. I feel like with the risks and the nature of the market, the revenue growth that I have assumed is pretty solid, of course things change if I switch to best case or deteriorate if we move into the weak case. As mentioned above, I am assuming COGS and operating expenses to slightly reduce over the next years with slight fluctuations throughout the years. Here is a look at the company future balance sheet:


As is evident from the projected balance sheet, I expect the company to raise further debt for the next 8-9 operating years and as a result have a minimum cash balance of $500MM throughout the next 9 years with ending the projection period with $1.67BB in FY '34. Let's now look at the company's cash flow statement to better understand the company's liquidity for the next 10 projected years.


As expected, I am expecting moderate growth in the company's operating cash flows and increase in its capex activities which yields negative free cash flows for the next 5 years, and as the company enters the second phase, I expect the company to turn positive and end the projection period with $3.7BB in free cash flows to the company. With all of the financial statements in our rearview, let's now look at the crux of this whole analysis: DCF derived price per share. 


Based on my base case assumptions, I get a price per share of $115.54, the stock is currently trading at $73.48, giving us an upside potential of ~50%. It goes without saying that one of the inherent flaws with a DCF is that it is based on what I think about factors such as growth, risk and the company's cash flows, and so to offset some of that risk, I have created scenarios around the price; my base case price per share, as mentioned before, is $115.54, and in my best case, I get a price per share of $214.09, and $63.54 in my weak case. I think in order to better manage the risk around my assumptions, it would also be beneficial to look at a few data tables and see how the price changes due to alterations in some of the variables. 

Sensitivity




The tables in the images above are pretty self-explanatory, and without going into too much detail, image 1 shows the changes in price per share given changes in the long-term growth rate and WACC; whereas image 2 shows us the impact on price per share given the changes in our EBITDA multiple and the company's WACC. Let's look at another set of tables that shows us the price per share given changes in revenues, EBITDA multiple, and margins by the end of FY '34.


As you can see, if I assume changes in my final year revenues and operating margins, my price per share could end up being dramatically different than what I have gotten in any of my scenarios; the same impact goes for changes in EBITDA and WACC for the final year of the projection period. 

Conclusion


Every time I do an analysis of this kind, my goal is always to understand all of the micro and macro factors that I possibly can so that my value ends up in a range that makes sense to me, but all of this is based on my inherent thinking of the company, its business, the industry, and the larger economic picture, and I can of course be wrong. So, if you end up disagreeing with my analysis, I have attached the file below for your review, please, feel free to go ahead and make the changes and convert the numbers into what you might think make more sense. Of course, DCF is an intrinsic valuation, and so if you try to compare this to what Dollar Tree's peers are trading at, well, that becomes a pricing game, and that comes with its own pros and cons. But, I have lately been thinking of conducting not only a DCF analysis but also couple it with a comparable analysis; but as can be expected, it becomes an arduous and time consuming journey, and so I'll just roll with the punches and see what I end up doing in the future. 

Links:



 

Friday, October 18, 2024

Intel (INTC): Too Big To Acquire?

(Disclaimer: Excel file attached below the post) 

I recently got done reading "Dethroning the King" by Julie Macintosh and have been grossly contemplating how companies rise to power, are considered the paragons of their industry, and then just as quickly, lose touch with reality, their consumers, and just altogether, loose the will or the appetite to maintain their market share or brand. I initially wanted to talk about the unholy relation between corporate governance and corporate cycle and company valuations, but I opted to shelve that thought and write about something that is directly relevant to what I read: the rise and potential fall of yet another American corporate icon, Intel. 

Up until the recent past, Intel was a part of my investment portfolio, but I decided to severe ties with the company right after its earnings call for FY 2023. It had completely vanished from my thoughts until a couple of weeks ago when news about a potential takeover of the company by Qualcomm (QCOM) started circulating the various news outlets and I rendered it serendipitous that this was all occurring when I was reading a book about the rise and fall of A-B. Given my piqued interest and curiosity, I decided to look at the company's financial statements, its current valuations, and of course, what a deal between Qualcomm and Intel could look like. Without any further ado, lets dive right in. 

Intel

Ghosts of Intel's Past

Intel- 2023 10K

Founded in 1968 by Gordon Moore, Bob Noyce, and Andy Grove, Intel has long been one of the leaders of the technological advancement over the last few decades as well as being the pinnacle of designing and manufacturing chips, processors and various other products and services that were pivotal to the convenience of the end consumers. The company's rise and long standing leadership during the 80s, 90s, and to some extent in the 2000s, is something that should be studied and applied to companies in their early growth stages, but the company seems to have lost its touch over the last decade, especially the last few years, and before we delve deeper into some of the reasons for its decline and potential demise, I think we should take a few minutes to mull over its performance over the last few years and see if we can see the decline in the numbers.


Over the last 10 years, Intel's revenues have gradually been declining for reasons that we will address later in the post, while at the same time, its Capex (as a % of its total net revenues) has risen over the same time period. Company's capex for FY 2014 was $10BB (18% of total net revenues), and in FY 2023, the company reported capex of almost $25BB (46% of total net revenues). Although the company's capex have risen over the last decade, its revenues have actually declined and margins, both gross and operating, have contracted. Speaking of its margins, Intel had fairly consistent and decent operating margins (anywhere from 25%-30%) for most part of the last decade, right up until FY 2021, and after that things have gotten sour to say the least. Intel reported operating margins of 3.7% on total net revenues of $63BB for FY '22, which resoundingly means that the company's competitive edge, its economic moat, and unit economics have worsened; the company had to spend so much on COGS, R&D and MG&A that even revenues of $63BB- a topline number that I might add, companies would kill for- yielded meager operating margins of 3.7% and gross margins of 42%, where the company posted gross margins in excess of 50% for the preceding three fiscal years in '19, '20, and '21. 

In order to get a clear picture of the company's performance and its gradual fall from grace, I think that we should look at its historical financial statements and try and assess if we can spot the usual suspects in the numbers. As such, here is a look at the company's income statement for the last five years from FY '19- FY '23:



Intel reports revenues in various different segments, and as we can see, the company has been witnessing a gradual and perpetual decline in most its segments. In FY '19, the company reported total net revenues of $72BB and that number has plummeted down to $54BB at the end of FY '23. Moving on to the cost of sales, or more colloquially known as COGS, have actually risen; company reported cost of sales of $30BB (41% of total net revenues) for FY '19, and during the next five years, even though its revenues have gone down, its cost of sales have actually grown to $32.5BB (60% of total net revenues), signifying that at sometime over the last five years, Intel has lost its economic moat and, consequently, its unit economics have all but drowned. This decline in revenues and the proportional increase in cost of sales has yielded worsening gross margins over the last five years; company reported gross margins (considered by many to be the proxy for a company's unit economics and economies of scale) of 58.6% for FY '19, and fast forward to FY '23, company reported ailing gross margins of 40%, further highlighting its incremental decline in the markets and the industry.

Moving over to operating expenses (R&D, MG&A, and occasional Restructuring Charges), Intel's operating expenses have skyrocketed similar to its cost of sales. For FY '19, the company reported operating expenses as a percentage of total net revenues of 28%, and in its latest fiscal year FY '23, the company had operating expenses margins of whopping 40%. Lastly, its NI tells a similar story; Intel's net margins have decreased from 29% in FY '19 to mediocre 3% for FY '23. The company's decreasing revenue growth, increasing cost of sales and humongous increase in its operating expenses tell a tale of company that is very much at the end of its proverbial life cycle. Before moving onto the next section of my analysis, I would like to take a few seconds and talk about the company's cash flow statement for the last three years, only because I believe it will give a real inside view of the cash inflows and outflows of the company, and we might even see positive cash flow despite the poor margins and profitability. 


As we can see, company's cash from operations (which starts with NI and adjusts for non-cash expenses and the changes in working capital items) have seen commensurate decline along with its revenues and margins, and that is not a surprise because the starting line in cash from operations is the NI from income statement. Additionally, Intel had positive free cash flows (cash from operations minus capex) in FY '21, but given its massive restructuring and expansion efforts under Pat Gelsinger, the company's free cash flows have been negative for the last two years. Other honorable mentions here would be the fact that Intel repurchased shares back in FY '21 and then suspended their decision to repurchase any shares for the next two years as well as scaling back their dividends; these two could either be perceived as a good thing because it means that the company is reinvesting in order to regain it leadership role in the industry or it could also mean that the company is not profitable enough to generate cash flows that can sustain share repurchases and future dividends.  

Ghosts of Intel's Present

Before we move onto some of the reasons, according to my research and understanding, for Intel's decline in revenues, margins and profitability, I think that in order to set a baseline, it is imperative that we discuss its latest operating year in more detail, as I suspect it will divulge more information that will come in handy for my analysis down the road.

I think that the image above, taken from Intel's 2023 10K best summarizes the company's performance over the last year, and as you can see, it is shouting all sorts of troubles. Over the latest fiscal year, company's revenues have declined due to lower revenues from CCG (Consumer Client Group), DCAI (Data Center and AI), and NEX (Network and Edge) segments; we will discuss the segments in more detail down the road. Company's both GAAP and non-GAAP gross margins declined YOY due to increased unit costs, lower revenues, and higher excess capacity charges, the reduction was somewhat offset by the sale of its existing inventory, lower inventory purchases and lower product ramp costs. Moreover, both GAAP and non-GAAP EPS were down YOY due to lower gross profits driven by lower revenues and higher costs and partially offset by relatively lower operating expenses and a higher tax benefit (tax benefit without which the company would have reported negative NI). Lets now discuss the segments in more a little more detail; the company reports revenues in the following segments: CCG (Client Computing Group), DCAI (Data Center and AI), NEX (Network and Edge), Mobileye, and Intel Foundry Services.

CCG (Client Computing Group)

CCG or Client Computing Group is by far the biggest source of revenues for Intel. For instance, for all of the last five observed years, CCG has constituted for more than 50% of Intel's total net revenues. Intel's CCG group engages in products and developments that are mainly utilized in PCs through companies such as DELL (19% of Intel's total revenues), HP (10% of Intel's total revenues), and Lenovo (11% of Intel's total revenues). Under the auspices of this group, Intel has launched the industry's first AI PC Acceleration Program to help enable AI on more than 100 million PCs through 2025 as well as launching 13th Gen Intel Core mobile and select desktop processors, Intel Core 14th Gen Processors, and Intel Core Ultra Processors. 


Intel's 10K

Revenue within the CCG group is further divided into Notebook, Desktop, and Other categories, and as you can see, overall revenues for the group have declined due to a decrease in demand for notebooks and desktops as well as lower demand for wireless and connectivity products. 

DCAI (Data Center and AI)

Data Center and AI (DCAI) is the second biggest source of revenues for Intel; the company reported DCAI revenues of $26BB (32.7% of total net revenues), $19BB (30% of total net revenues) and $15.5BB (28.6% of total net revenues) for FYs '21, '22, and '23, respectively. This group delivers cutting edge work-load optimized solutions for cloud service providers and enterprises along with silicon devices for communication service providers. The group has sold more than 2 million 4th Generation Intel Xeon Scalable processors as of the end of FY '23, and 5th Gen Intel Xeon processors in the fourth quarter of FY '23. Furthermore, the 4th Gen Intel Xeon processor was recognized by MLCommons which stated that the processor is a compelling invention that competes on performance, price and availability with its competition in the AI markets. 

Intel's 10K

Revenues for the segment decreased YOY by $3.9BB due to a decrease in demand in the CPU data center market; this decrease could be attributed to increased competition from NVidia (through its GPUs that are powering the artificial intelligence services) and AMD (through its encroachment of the PCs and data centers' processors and CPUs). 

NEX (Network and Edge)

NEX is the third largest source of revenue for Intel; the company reported $4BB (5% of total revenues), $9BB (14% of total revenues), and $6BB (11% of total revenues) for FYs '21, '22, and '23, respectively. This group provides and delivers products and services that helps Intel's consumers improve their operations and protect their data on the Edge through AI driven automation. The company launched 4th Gen Intel Xeon processor with Intel vRAN Boost, and announced the Intel Xeon D-1800 series and the Intel Xeon D-2800 series processors that are optimized for cloud, edge, and 5G networks. 

Intel's 10K


Revenues for the segment were down by almost $6BB on YOY basis due to lower demand driven by the macro events of the last year. 

Mobileye

Mobileye is Intel's autonomous vehicle and related technologies division, and develops products and services for autonomous driving and related solutions. The company reported $1.3BB (1.8% of total net revenues), $1.9BB (3% of total net revenues), and $2BB (3.8% of total revenues) for FYs '21, '22, and '23, respectively. Mobileye launched EyeQ based systems into approximately 300 different vehicle models and built significant traction with other products in the company's portfolio. Mobileye SuperVision is continually being delivered on the air in order to improve highway driving and navigate-on-pilot capabilities. 

Intel's 10K

Even though Intel has been working on delivering autonomous driving related products and services for over 20 years now, it only recently started reporting for this segment after it acquired Mobileye back in 2017 and its subsequent IPO in 2022. Revenues for this segment increased by $210MM due to the increased demand for EyeQ products and Mobileye SuperVision. 

Intel Foundry Services

Intel's foundry services works with other companies and firms in order to manufacture chips that are designed by its business partners and are specifically tailored for their needs. One of the things that management realized over the years is TSMC's monumental growth given its manufacturing of products that are designed by its clients, instead of designing and manufacturing chips and other products in house and selling them to clients, and in order to compete, Intel started its own foundry business in the last few years and it is very much still in its nascent years, as evidenced by the revenues and consistently negative operating income below.

Intel's 10K
This segment reported revenues of $952MM, an increase from $895 it reported last year. Due its infancy, this segment has gargantuan future growth potential given what other foundry businesses have been able to do as well as the increasing costs and investments that come with growth.   

The Dog Ate My Homework

With an understanding of the company's financials for the last decade, and the last year in more detail, I think that I am ready to move onto some of the reasons why I think the company has been putting sub-par numbers, to put it mildly, in the recent years.

Complacency Driven by Magnanimity:
 
One of the many reasons why empires (i.e., Roman, Carthage, Persian, Greeks, and Ottoman to name a few) failed is their complacency and it is no different for companies and corporations after they reach a certain point. There is a valid reason as to why corporations are legally treated as citizens because they behave in much the same way, and I believe that Intel suffered from the same ailment. The company was quite literally on top of the technological world and its processors were synonymous with the Windows operating system; I remember when discussing new computers and laptops, the first question that was asked was "what Intel processor does it have?" The version of the processor was how consumers used to determine if it was a newer model or an old relic, and that has since changed, for many reasons, complacency being one of them. When companies reach the pinnacle of their cycle, they tend to enjoy the high instead of looking at the future. 
There have been so many examples in the corporate world that have suffered the fate that many might think seems like an eventuality for Intel; think IBM, Blockbuster, and Toy's 'R' Us, and is there something that the management at Intel could have done to better position themselves? Yes. The company's R&D and capex have inversely ballooned in relation to its revenues and that should make one wonder where all that capital was being deployed. Intel for the most part of its tenure has been a designer and a manufacturer and so the R&D expense, in many ways, fueled the management's lack of foresight. Their myopia, in hindsight, is quite vivid because it seems like the capital they deployed has been for new iterations of their existing repertoire of products and services rather than ground-breaking new technologies. I say this because given its place in the industry, I believe Intel should have been the one at the forefront of artificial intelligence and the mania surrounding it rather than an underdog like NVidia, which at the time of this post, is the second most valuable company with market cap slightly below that of Apple's. 

Lack of Risk Taking

I mentioned at the beginning of the post that one of the reasons why I decided to do this is due to the fact that I just finished reading "Dethroning the King", and the book goes in excruciating elucidation into A-B's lack of risk taking and how that contributed to it being taken over by a company that stemmed from Brazil and that A-B, at one point in time, had the opportunity to acquire. Lack of risk taking would be the second reason why I think Intel is in the place that it is in; management was, I suspect, quite comfortable enjoying the position that the company was in and, I suspect, did not see the point in taking risks and exploring new ways of expansion and relevance. I will mention two examples here: one that of autonomous driving and the second of the foundry business. 
Intel touts in its latest 10K that it has been invested in autonomous driving related products and services for over 20 years, and yet they took the step to acquire Mobileye in 2017. If the management had the appetite for risk and the yearning for future growth, they would have taken the initiative well before 2017 and taken advantage of the situation when the markets were putting a premium on companies within the electric and self-driving categories. The second example of the foundry services pretty much paints the same image; Intel was so insulated in designing and manufacturing its own chips that what other firms like TSMC and Samsung were doing seemed to be of no consequence and as a result, Intel lost valuable market share to those companies due to their ability to not only manufacture chips and processors built by their clients but also improve them through testing. Intel started its own foundry services a few years ago in order to compete with companies like TSMC and Samsung, and it might be too little too late because now they have to engage in competition on two fronts: Intel not only has to compete for its foundry business with well established aforementioned companies but it also has to compete with the likes of NVidia (who gets its manufacturing done primarily by TSMC) in terms of designing and building GPUs and accelerators that are required for AI and related products and services. Will Intel's foundry business see the success that TSMC is enjoying? Only time will tell, because they will have to not only outperform TSMC and Samsung but also incentivize companies to engage their services instead of TSMC and Samsung. This begs an even bigger question, will they be able to compete on such a large scale when they are also being pummeled in the AI field by NVidia? 

The Business

Another reason that I can think of is the industry that the company is in; this particular industry witnesses rapid technological, geopolitical, and market developments and it becomes hard for an individual company to stay abreast with the ever changing needs of companies, the clients, and consumers and their unpredictable and capricious spending behavior and habits. lets look at CCG and DCAI in order to understand how rapidly the industry needs change and how, understandably, hard it is to stay on the top. The Client and Computing Group engages in products and services that are catered for laptops and PCs through the company's partners, and this segment has been gradually declining due to consumers veering towards tablets and mobile phones with ginormous screens. Given the change in consumers' behavior, laptop and desktop manufacturers have scaled back their demands in order to not only sell their current inventory but also take lower reserves for the future; this is one of the major reasons for the decline in this particular group. DCAI or Data Center and AI engages in CPUs and other products that are specifically designed for data centers and we can all guess the tectonic shift in that group: data centers are now in need of GPU accelerators that are designed by NVidia and manufactured by TSMC and their need for CPUs that Intel used to deliver is rapidly deteriorating. The sudden changes are unpredictable, yes, but not at all surprising because that is the business the company is in, if they are unable to predict the future demand then perhaps they should focus on buying instead of trying to achieve the impossible, that for intents and purposes, the company seems incapable of doing. Additionally, Given the fact that CCG and DCAI accounted for 54% and ~ 30%, respectively, of the company's total net revenues for FY '23, Intel will have to figure out an avenue to turn things around in these segments if they wish to stay relevant.

Geopolitics

Intel's 10K
 
Majority- almost 73%- of the company's total net revenues are generated outside of the US, and China, without any consternation, is the company's biggest country in terms of billing and revenues. As we can see, US's policy of preventing advanced technologies being delivered to countries that it considers hostile, namely China, is now showing up in the numbers for companies that engage in international affairs. Intel reported revenues of almost $23BB for FY '21 from China, and that number, two years later, is now down to almost $15BB. Another aspect of geopolitics would be that countries, as a result of supply chain bottlenecks and resulting inflation during Covid, are now focused on onshoring a lot of the manufacturing of chips, processors along with other goods and services. US is one of those countries and the current administration put forward a lofty plan to bring chips and processors' manufacturing back to the States, and Intel has been the primary benefactor of this initiative. There are pros and cons to what transpires in the political sphere but an ideal situation would be that the US and China are again on friendly terms which would, without a doubt, yield better numbers for the company. 

Market and Expectations

Another reason that comes to mind when looking at Intel is the market and its expectations. Equity investors inherently are focused on future growth- as opposed to creditors and lenders that are primarily focused on the past- and if the markets suspect that the company has fallen back, it gets punished for it, regardless of how effective the company has been in the past. To put things in perspective, Intel's revenues declined, for reasons mentioned in this section, by 14% on YOY basis and still reported $54BB, a number that majority of the publicly listed companies would quite literally kill to attain, and yet it is trading, for the first time in decades, below its book value (assets minus liabilities). I believe a large reason for this is that investors are now attributing very little market share of the mammoth AI industry to Intel even though its perfectly suited and positioned to attain a sizable chunk of it. 
Side note: I remember when Apple released its first iPhone and it quite literally decimated other companies such as Blackberry, Nokia and Sony Ericson, but it also resulted in new technology coming into the markets that yielded even bigger players such as Samsung, Xiaomi, and Huawei. So, yes, Intel might not have the first mover advantage in terms of the AI and related products and services, but it definitely stands to benefit from the industry's infancy and massive potential growth in the future.   

Valuation

Base case assumptions
  • Client Computing Group (CCG)
    • The company reported $29BB (54% of total net revenues) for this segment in FY '23, and I expect this segment to remain relatively flat for the next five years where I suspect it would be around $29BB by the end of FY '28 or 52.5% of total net revenues. However, I do see growth in this segment after five years and I expect that the revenues would then increase to around $39BB by the end of FY '33, but as the company grows its other segments, CCG, by the end of FY '33 will reduce to being ~45% of total net revenues. I see the growth in this segment majorly driven by increased demand in the PC industry given that it should rebound in the coming years. PCs are also still majorly prevalent in the corporate world and that stands to increase over the next decade due to a mixture of new orders as well as replacement ones. Furthermore, I believe that AI related activities should also give a boost to PC's demand not just in the USA but also worldwide. I expect the growth in this sector to be offset by competitive products such as the Macs, cell phones, and tablets of the world.  
  • Data Center and AI (DCAI)
    • The company reported a reduction in revenues for this segment of 19% or $15.5BB for FY '23. I expect the revenues for this segment to go through further contraction over the next five years, and by FY '28 should be around $3BB. I see this reduction due to clients focusing their needs on GPUs and products that Intel does not have a competitive edge or the first move advantage in. But, as the company continues to invest in the coming years, I believe that this segment will then again see good days and start to improve by FY '26 (I wouldn't be surprised if it improves before then). I expect revenues for this segment to be around $21BB (25% of total net revenues) by the end of FY '33.
  • Network and Edge (NEX)
    • Intel reported revenues of $5.7BB (10.6% of total net revenues) for this segment by the end of FY '23, a reduction of 35% YOY basis. Given the change in cloud to edge, I expect this segment to again turn positive over the course of next five years. Given the saturation in this segment, I am not seeing monumental growth but only decent where revenues in FY '28 should be around $3BB, and as the company develops its products, services, and relations within the industry, revenues should start to pick up and end the decade on a good note; I expect revenues for this segment to be around $4BB (6% of total net revenues) by the end of FY '33. 
  • Mobileye
    • Intel reported $2BB (3.8% of its total net revenues) in revenues for this segment which was an 11% increase from the previous year's reported number of $1.9BB. Given the demand and interest in autonomous vehicles, I expect revenues for this segment to increase to about 25% by FY '28, or $5BB (9% of total net revenues). As the industry gets more saturated and the company looses its edge and maybe even market share, I expect this segment to be at ~$12BB (14% of total net revenues) by the end of FY '33.
  • Intel Foundry Services
    • Intel reported revenues of $952MM (1.8% of its total net revenues) for this segment for FYE '23. I expect this segment to grow to 20% to ~$2BB over the course of the next five years, and as it solidifies its place in the industry, I expect revenues for this segment to end at around $4BB (5% of total net revenues) by the end of FY '33. I understand that this is one of the hardest segments that Intel has to strive in in order to improve their market share due to leading competitors such as TSMC and Samsung; and with the understanding that the company has been investing heavily in the last few years in order to improve this segment, my assumptions do not seem implausible. In fact, I believe that this segment has the potential to outperform my assumptions by a long margin, it all depends on how sanely the company invests its capital and how effectively they'll be able to implement their strategies. 
  • Cost of Sales
    • One the reasons, along with reduction in total revenues, why Intel's margins have contracted over the last few years has been due to their ginormous cost of sales; for instance, the company reported $35BB (45% of total net revenues), $36BB (57% of total net revenues), and $33B (60% of total net revenues) for FYs '21, '22, and '23, respectively. Given that the company is going through a restructuring of its business model and financial strategies, I expect cost of sales to continue to be a significant part of its total revenues. I expect cost of sales to settle around 55% ($30BB) of total net revenues by the end of FY '28. After FY '28, I suspect that the company should begin to see the fruits of its labor, and as a result, cost of sales should gradually reduce to about 45% ($39BB) by the end of FY '33.
  • Operating Expenses
    • Operating expenses, in conjunction with the reduction in revenues and increase in cost of sales, have also increased at an almost exponential rate over the last 5 years. Intel reported operating expenses margins (operating expenses divided by total net revenues) of 31% ($24BB), 39% ($24.5BB), and 40% ($22BB) for FYs '21, '22, and '23, respectively, and given the condition the company is in, I do not see a reason why they should improve. I suspect, given that the company has all but lost its competitive edge, and is nowhere near its competitors, management will have to continue to invest heavily in R&D and MG&A in order to retain top talent and improve their top line through marketing efforts. I expect operating expenses to increase to about $25BB (45% of total net revenues) by the end of FY '28, and as the company gains its footing again, these costs should begin to come down; I expect operating expenses of $24BB (28% of total net revenues) by the end of FY '33.
  • Operating Margins
    • Given my assumptions about the revenues, cost of sales, and operating expenses, I expect margins to be non-existent for the next five years (a long cry from 30% margins the company reported in FY '19). But, here is the kicker, as Intel gains a foothold, as markets and investors start to favor the company, and as it gains a share of the AI industry, I expect margins to improve sometime after FY '28. In my base case, I expect operating margins to be around 27% by the end of the projection period. 
  • Capex and Reinvestment
    • Capex, no surprise here, has also risen over the last five years, company had capex margins of 47.5% for FY '23, which given its current restructuring and reorganization plan is not that astonishing. I expect capex to gradually decrease over the next 10 years to 25% by the end of FY '33.
  • WACC
    • Given a after-tax cost of debt of 3.90%, risk free rate as of this post of 4.03%, Intel's beta of 1.26, and the market risk premium of 3.96%, I got a WAC of 8.05%.
  • Other Factors
    • Other factors that might impact the company's future are as follows:
      • The company might end up of divesting or carving out some parts of its business which would lead to a different valuation, I have not taken this into account. 
      • If the company continues to pay dividends- my model predicts that the company does not have enough cash flows to support it- it will see negative impact on its cash flows. 
      • The management might be able to effectively implement its new plan and strategies which would result in a turnaround and might yield a higher valuation given the increased potential of future cash flows. 
      • Company might be able to gain a bigger share of the foundry business than what I have assumed. 
With these assumptions in place, here is a look at Intel's three statements, relative projections, and the valuation.


Starting with the income statement, I expect total net revenues to continue to decline for the next five years due to my assumptions above, and after the "investment" period, which is the next 5 years, I expect total net revenues to pick up again and end the projection period, FY '33, with $86BB in total net revenues. I also expect the company's margins to be uninviting for the next five years, but I believe will end the projection period on a good note. 


I have not assumed any capital raises, debt or equity, and so I expect the company to continue operating at its minimum cash balance due to my projections about line items such as capex and working capital. Given the massive reinvestment, I suspect they will need to raise short-term debt over the next 10 years, but they should be able to repay all of it back by the end of FY '33. My model and assumptions also show me promising improvements in company's retained earnings. 


I do expect the company to continue to yield negative free cash flows for the next five years, and as all the variables that I mentioned above improve, the company should generate $22BB in FCFs by the end of FY '33. I think this is as good a time as any to bring the company's valuation in. 

In my base case, I get an implied value per share of $38.84 through perpetuity growth method and $33.13 through EBITDA multiple approach, the stock, at the time of this post, was trading at $22.38. I believe that given the company's storied history, its brand name and other intangible assets as well as its future potential, the markets are undervaluing the company. I believe a huge chuck of this discounting can be attributed to Intel being late at the AI game and therefore the markets not allotting it any benefit of the doubt. Yes, AI gravy train has left the station but there is possibility that Intel might be able to pick up the gravy that fell on the tracks. 

Sensitivity

Of course, I completely understand that I might be incorrect, or I might be to too heavy or low on some of my assumptions, and so given the variables that I know impact a DCF analysis, here is a look at some data tables that show the share price given changes in some of the variables. 

Images 1 and 2 above show the different ranges of share price given modifications in variables such as WACC, implied growth rate, and the terminal year EBITDA multiple. 

Images 3 and 4 look at the impact on price per share given changes in operating margins, EBITDA, and revenues in FY '33, and as you can see, the company only needs to bring in around $60BB and 25% margins (the lowest end of the range) in order to justify its current trading price of $22.38.

Qualcomm and Intel

As mentioned at the start of the post, what prompted this post was the news about Qualcomm making a bid for Intel, how true that is or what the terms are is still a mystery and to see what the deal could look like, I have made a few assumptions.  

Let me preface this accretion/ dilution analysis with the fact that I believe this deal is close to impossible given the sheer size of Intel and its balance sheet. But, since the news is circulating, I wanted to give it a go and see how dilutive the deal could be for Qualcomm. Qualcomm at the time of this analysis is trading at about 22x its earnings on twelve trailing months basis, and Intel is trading at about 95x its earnings on TTM basis, and just by looking at the P/Es you can tell that there is no way this deal would be accretive for Qualcomm, but lets still jump through the hoops and see what we get.  

Qualcomm, at the time of this post, has a market cap based on its fully diluted shares outstanding of about $197BB, and Intel, based on its diluted shares outstanding, has a market cap of just under $100BB. In order to make the deal appealing to the management and the shareholders, Qualcomm will have to make an offer with a premium of about 20%-30% (which is typically the range for control premiums in M&A transactions of this size), and if we assume a premium of 20%, the offer price for Intel would be $27.98, based on its current trading price, and assuming its diluted shares outstanding of 4,382MM, we get an offer value of $123BB, and if we bring in Intel's net debt, we get a transaction value of $145BB. I have assumed that Qualcomm will use 30% stock and 70% cash, and for 70% cash, they will use about 76% of their own cash (~$8.6BB) and raise $77BB in debt, I have assumed that they will refinance Intel's debt, which will increase their borrowings by $49BB. For the sake of argument, I have also assumed asset write-ups for PP&E and Intel's intangible assets, and I got an additional goodwill of $35BB that Qualcomm will have put on its BS. Given my assumptions about the supposed transaction, here is what Qualcomm's balance-sheet could like on closing:


Since I have assumed a massive amount of debt for the deal, the interest expense for Qualcomm going forward could be well around $4BB, and given the amount of cash that I have assumed they will use, Qualcomm will, without a doubt, loose income on that cash. I don't have access to databases such as FactSet and CapIQ and so I have used Intel's NI and shares outstanding using my own standalone model, but for Qualcomm, I had to make a few assumptions in terms of their NI and EPS. I might be off in terms of Qualcomm's NI or future shares outstanding, but I doubt it'll impact the model in any significant way or turn the deal accretive. Here is how dilutive the deal could be for Qualcomm going forward:


As you can, the deal would be about 50% dilutive for Qualcomm for the foreseeable future, and given that it is a publicly listed company and that the management has a fiduciary duty to its shareholders, this deal, under no circumstances, should be entertained. Qualcomm would need to realize total synergies (revenue, capex or cost) in excess of $6BB just to make the deal break-even, a monumental task to say the least. This was assuming a 30% stock and 70% debt, if we assume all cash, the deal would still be massively dilutive given the sheer size of the borrowings and the resulting interest expense. Would making it all stock make any difference you might ask. No, it doesn't, due to the drastic differences in the companies' P/Es.

Conclusion

This analysis was, of course, to satiate my own curiosity, and if you don't agree, the excel file is attached, play with the numbers and see if you can come up with anything different. In conclusion, I would say that Intel is currently being traded far below its true intrinsic value, and there still is plenty of potential for the company in the future, but if you have already made up your mind, then I doubt there is anything about the company or its future that will make you change your thoughts. As for the deal, I do not believe that acquisition of Intel would be a good corporate action for Qualcomm and its investors, but wall street is adept at persuading companies to do stupid shit!


Links:

 Intel Valuation- 10/18/2024