Offshore
Photo
โ Dimitry Nakhla | Babylon Capitalยฎ
A sober valuation analysis on $HD ๐Ÿง˜๐Ÿฝโ€โ™‚๏ธ

โ€ขNTM P/E Ratio: 22.57x
โ€ข10-Year Mean: 20.72x

โ€ขNTM FCF Yield: 4.74%
โ€ข10-Year Mean: 5.12%

As you can see, $HD appears to be trading slightly above fair value

Going forward, investors can expect to receive ~8% LESS in earnings per share & ~7% LESS in FCF per share๐Ÿง ***

Before we get into valuation, letโ€™s take a look at why $HD is a quality business

BALANCE SHEET๐Ÿ†—
โ€ขCash & Equivalents: $3.76B
โ€ขLong-Term Debt: $40.60B

$HD has an ok balance sheet, an A S&P Credit Rating & 10.90x FFO Interest Coverage Ratio

RETURN ON CAPITALโœ…
โ€ข2019: 56.7%
โ€ข2020: 45.3%
โ€ข2021: 38.2%
โ€ข2022: 50.7%
โ€ข2023: 44.7%
โ€ข2024: 39.4%

RETURN ON EQUITY๐Ÿ†—
โ€ขIn the thousands & negative in some years (due to heavy use of debt)

$HD has decent return metrics, highlighting the financial efficiency of the business

REVENUESโœ…
โ€ข2014: $78.81B
โ€ข2024: $152.67B
โ€ขCAGR: 6.83%

FREE CASH FLOWโœ…
โ€ข2014: $6.24B
โ€ข2024: $17.95B
โ€ขCAGR: 11.14%

LONG TERM DEBT๐Ÿค”
โ€ข2014: $14.69B
โ€ข2024: $40.60B
โ€ขCAGR: 10.70%

NORMALIZED EPSโœ…
โ€ข2014: $3.76
โ€ข2024: $15.11
โ€ขCAGR: 14.92%

SHARE BUYBACKSโœ…
โ€ข2014 Shares Outstanding: 1.43B
โ€ขLTM Shares Outstanding: 1.00B

By reducing its shares outstanding ~30%, $HD increased its EPS by ~43% (assuming 0 growth)

PAID DIVIDENDSโœ…
โ€ข2014: $1.64
โ€ข2024: $8.52
โ€ขCAGR: 17.91%

MARGINS๐Ÿ†—
โ€ขLTM Gross Margins: 33.4%
โ€ขLTM Operating Margins: 14.2%
โ€ขLTM Net Income Margins: 9.9%

***NOW TO VALUATION ๐Ÿง 

As stated above, investors can expect to receive ~8% LESS in EPS & ~7% LESS FCF per share

Using Benjamin Grahamโ€™s 2G rule of thumb, $HD has to grow earnings at an 11.29% CAGR over the next several years to justify its valuation

Today, analysts anticipate 2025 - 2027 EPS growth over the next few years to be less than the (11.29%) required growth rate:

2025E: $15.35 (1.6% YoY) *FY January
2026E: $16.37 (6.6% YoY)
2027E: $17.56 (7.3% YoY)

$HD has an excellent track record of meeting analyst estimates ~2 years out, but letโ€™s assume $HD ends 2027 with $17.56 in EPS & see its CAGR potential assuming different multiples

23x P/E: $403.88๐Ÿ’ต โ€ฆ ~8.7% CAGR

21x P/E: $368.76๐Ÿ’ต โ€ฆ ~5.0% CAGR

20x P/E: $351.20๐Ÿ’ต โ€ฆ ~3.1% CAGR

As you can see, EVEN when we assume 23x earnings โ€” a multiple WELL above $HD mean (20.72x) & near the highest end of its range, $HD has subpar return potential

$HD also has some cyclicality to it & relying on estimates ~3 years from now adds a layer of risk (the further you extrapolate, the greater chance of error)

Given all this, and its hefty rising debt levels, $HD certainly doesnโ€™t appear attractive today at $346.43๐Ÿ’ต

Iโ€™d reconsider $HD closer to $284๐Ÿ’ต or at ~18.50x forward estimates (~18% below todayโ€™s price) where I can possibly expect near double digit return potential assuming a 20x end multiple in 2027

#stocks #investing

$HD reports Q1 2024 Earnings on Tuesday 05/14/2024 Before the Open
___

๐ƒ๐ˆ๐’๐‚๐‹๐Ž๐’๐”๐‘๐„โ€ผ๏ธ: ๐“๐ก๐ข๐ฌ ๐ข๐ฌ ๐๐Ž๐“ ๐ˆ๐ง๐ฏ๐ž๐ฌ๐ญ๐ฆ๐ž๐ง๐ญ ๐€๐๐ฏ๐ข๐œ๐ž. ๐๐š๐›๐ฒ๐ฅ๐จ๐ง ๐‚๐š๐ฉ๐ข๐ญ๐š๐ฅยฎ ๐š๐ง๐ ๐ข๐ญ๐ฌ ๐ซ๐ž๐ฉ๐ซ๐ž๐ฌ๐ž๐ง๐ญ๐š๐ญ๐ข๐ฏ๐ž๐ฌ ๐ฆ๐š๐ฒ ๐ก๐š๐ฏ๐ž ๐ฉ๐จ๐ฌ๐ข๐ญ๐ข๐จ๐ง๐ฌ ๐ข๐ง ๐ญ๐ก๐ž ๐ฌ๐ž๐œ๐ฎ๐ซ๐ข๐ญ๐ข๐ž๐ฌ ๐๐ข๐ฌ๐œ๐ฎ๐ฌ๐ฌ๐ž๐ ๐ข๐ง ๐ญ๐ก๐ข๐ฌ ๐ญ๐ฐ๐ž๐ž๐ญ.

๐“๐ก๐ž ๐ข๐ง๐Ÿ๐จ๐ซ๐ฆ๐š๐ญ๐ข๐จ๐ง ๐œ๐จ๐ง๐ญ๐š๐ข๐ง๐ž๐ ๐ข๐ง ๐ญ๐ก๐ข๐ฌ ๐ญ๐ฐ๐ž๐ž๐ญ ๐ข๐ฌ ๐ข๐ง๐ญ๐ž๐ง๐๐ž๐ ๐Ÿ๐จ๐ซ ๐ข๐ง๐Ÿ๐จ๐ซ๐ฆ๐š๐ญ๐ข๐จ๐ง๐š๐ฅ ๐ฉ๐ฎ๐ซ๐ฉ๐จ๐ฌ๐ž๐ฌ ๐จ๐ง๐ฅ๐ฒ ๐š๐ง๐ ๐ฌ๐ก๐จ๐ฎ๐ฅ๐ ๐ง๐จ๐ญ ๐›๐ž ๐œ๐จ๐ง๐ฌ๐ญ๐ซ๐ฎ๐ž๐ ๐š๐ฌ ๐ข๐ง๐ฏ๐ž๐ฌ๐ญ๐ฆ๐ž๐ง๐ญ ๐š๐๐ฏ๐ข๐œ๐ž ๐ญ๐จ ๐ฆ๐ž๐ž๐ญ ๐ญ๐ก๐ž ๐ฌ๐ฉ๐ž๐œ๐ข๐Ÿ๐ข๐œ ๐ง๐ž๐ž๐๐ฌ ๐จ๐Ÿ ๐š๐ง๐ฒ ๐ข๐ง๐๐ข๐ฏ๐ข๐๐ฎ๐š๐ฅ ๐จ๐ซ ๐ฌ๐ข๐ญ๐ฎ๐š๐ญ๐ข๐จ๐ง. ๐๐š๐ฌ๐ญ ๐ฉ๐ž๐ซ๐Ÿ๐จ๐ซ๐ฆ๐š๐ง๐œ๐ž ๐ข๐ฌ ๐ง๐จ ๐ ๐ฎ๐š๐ซ๐š๐ง๐ญ๐ž๐ž ๐จ๐Ÿ ๐Ÿ๐ฎ๐ญ๐ฎ๐ซ๐ž ๐ซ๐ž๐ฌ๐ฎ๐ฅ๐ญ๐ฌ.

๐ˆ๐ง๐Ÿ๐จ๐ซ๐ฆ๐š๐ญ๐ข๐จ๐ง ๐œ๐จ๐ง๐ญ๐š๐ข๐ง๐ž๐ ๐ข๐ง ๐ญ๐ก๐ข๐ฌ ๐ญ๐ฐ๐ž๐ž๐ญ ๐ก๐š๐ฌ ๐›๐ž๐ž๐ง ๐จ๐›๐ญ๐š๐ข๐ง๐ž๐ ๐Ÿ๐ซ๐จ๐ฆ ๐ฌ๐จ๐ฎ๐ซ๐œ๐ž๐ฌ ๐›๐ž๐ฅ๐ข๐ž๐ฏ๐ž๐ ๐ญ๐จ ๐›๐ž ๐ซ๐ž๐ฅ๐ข๐š๐›๐ฅ๐ž, ๐›๐ฎ๐ญ ๐ข๐ฌ ๐ง๐จ๐ญ ๐ ๐ฎ๐š๐ซ๐š๐ง๐ญ๐ž๐ž๐ ๐š๐ฌ ๐ญ๐จ ๐œ๐จ๐ฆ๐ฉ๐ฅ๐ž๐ญ๐ž๐ง๐ž๐ฌ๐ฌ ๐จ๐ซ ๐š๐œ๐œ๐ฎ๐ซ๐š๐œ๐ฒ.
tweet
โ The Long Investor
$DAL HSBC PT of $72.80

DELTA AIRLINES $DAL initiated at 'Buy' with $72.80 price-target at HSBC:

"We initiate on Delta Air Lines with a Buy rating and a target price of USD72.80. This is our preferred play among the US airlines under our coverage. We like its strong network mix and competitive positioning at all of its key hubs, which offers a rich mix of traffic, evident from management commentary, but also from the rising revenue from premium cabins, which has risen to 43% in 2023, from only 18% in 2015.

The company maintains a focus on the premium segment, which should result in healthy operating margins for the company. Moreover, Delta is the only player with non-unionized labor. Yet, Delta pays its employees very well and shares profit, which helps management to maintain good employee relationships and significantly lowers the risk of strikes. On the financial KPIs, the company has a strong balance sheet, with net debt/EBITDA of only 2.7x, a strong FCF yield (we forecast a post capex FCF yield of 11.4% per annum over the next four years) and healthy profit margins."
- Stock Talk
tweet
โ The Long Investor
There are people selling Mega Caps to buy $GME and $AMC

lol
tweet
โ The Long Investor
Donโ€™t be an idiot and chase $GME here
tweet
โ The Institutional Limited Partner
I got kicked out of a secondary process on a relatively old European direct lending fund.

11 Bids, ranging from 40% to 95% of Q4 2023 NAV ๐Ÿค”

Extreme spread; I donโ€™t understand both bounds
tweet
โ Giuliano
Reads for my break:

Cicero, Selected Works
Surely You're Joking Mr. Feynman
The Pleasure of Finding Things Out
Guns, Germs, and Steel
tweet
โ Antonio Linares
I think the market has totally missed the point with the $PLTR Q1 earnings.
tweet
Offshore
Photo
โ Brandon Beylo
Tin is benefiting from three major demand tailwinds:

โ€ข Solar

โ€ข AI/data centers

โ€ข EVs and Electrification

Yet these drivers only account for ~30% of total demand.

What happens to demand/price when they reach 50%?

New mine supply can't come online fast enough.

#Tin
tweet
Offshore
Photo
โ Brandon Beylo
RT @minenergybiz: The case for #tin - major demand tailwinds. The tin theme is absolutely undervalued in the commodity complex and gets little media attention. Good overview from Brandon @marketplunger1

Tin is benefiting from three major demand tailwinds:

โ€ข Solar

โ€ข AI/data centers

โ€ข EVs and Electrification

Yet these drivers only account for ~30% of total demand.

What happens to demand/price when they reach 50%?

New mine supply can't come online fast enough.

#Tin
- Brandon Beylo
tweet
Offshore
Photo
โ Brandon Beylo
RT @Rory_Johnston: Treatment Charges (TC) are the most compelling datapoint re: copper bull market (to counteract weird copper contango)

If refiners weren't themselves concerned about future cathode why would they be voluntarily losing money by continuing to fight for & refine concentrates?

Looks like copper TC rates just went negative ๐Ÿ‘€

Absolutely wild.

#copper

H/t @GoldForecast https://t.co/3dFx52QFhH
- Brandon Beylo
tweet
โ The Long Investor
I wonder what Powell thinks of the nonsense in that market today, too much liquidity around.
tweet
Offshore
Photo
โ ๎จ€ Q-Cap ๎จ€
๐ŸŽฏ๐ŸŽฏ https://t.co/pgtzgmF7Jk
tweet