ETSY Stock Study (4-30-24)
Posted by Mark on May 8, 2024 at 06:33 | Last modified: May 1, 2024 14:28I recently did a stock study on Etsy Inc. (ETSY, $68.88). Previous studies are here and here.
M* writes:
> Etsy operates a top-10 e-commerce marketplace operator in the
> U.S. and the U.K., with sizable operations in Germany, France,
> Australia, and Canada. The firm dominates an interesting niche,
> connecting buyers and sellers through its online market to
> exchange vintage and craft goods. With $13.2 billion in 2023
> consolidated gross merchandise volume, Etsy has cemented itself
> as one of the largest players in a quickly growing space,
> generating revenue from listing fees, commissions on sold items,
> advertising services, payment processing, and shipping labels.
> As of the end of 2023, the firm connected more than 96 million
> buyers and 9 million sellers on its marketplace properties:
> Etsy, Reverb (musical equipment), and Depop (clothing resale).
This medium-size company has grown sales at an annualized rate of 38.0% over the past decade.
EPS is complex. I am excluding negative/fractional EPS in 2013-2016 [otherwise resulting in an inflated growth rate] to start with $0.68/share in ’17. The company takes a goodwill impairment charge of $1.0 billion in ’22 due to Depop and Elo7 acquisitions that slashes EPS to -$5.48 thereby precluding future growth rate projections. If this is overwritten with CFRA’s “normalized” EPS of $4.61 value, then the result is a 38.5% EPS growth rate since 2017.
For ’17-’22, [sales and EPS] lines are mostly up and narrowing despite an EPS dip in ’18. ’23 will be discussed below.
PTPM is above peer and industry averages while increasing from 7.3% in ’17 to 10.7% in ’23 with a last-5-year mean (excluding ’22) of 15.5%. ROE is above peer and industry averages while decreasing from 23.8% in ’17 to -43.1% in ’23 with a last-5-year mean (excluding ’22) of 27.9%.
Debt-to-Capital has risen above peer and industry averages by climbing from 15.0% in ’17 to 129.5% in ’23. Despite being remarkably high, Value Line gives a “B” rating for Financial Strength and writes in a previous report:
> Although debt represented over 100% of capital at the end of 2022,
> cash and short-term investments totaled $1.2 billion and the
> company has only modest debt due over the next five years.
> Additional funds can be sourced from the company’s $200 million
> undrawn revolver and $29.1 million in long-term investments that
> can be liquidated on short notice.
M* rates the company “Wide” for Economic Moat, gives a “Standard” rating for Capital Allocation and, in a previous report, is also not concerned about debt:
> With our forecast for just 0.8 times average net leverage over the next
> five years (net debt/adjusted EBITDA), a paucity of near-term debt
> maturities, and a highly cash generative mode… balance sheet risk
> appears minimal for the marketplace operator. We believe that Etsy
> should encounter no difficulties in funding its investments in headcount
> and platform development with internally generated funds, while
> retaining substantial flexibility to invest in brand marketing and
> strategic acquisitions. With no principal maturities until 2026, we
> view Etsy’s balance sheet health as strong, despite the firm carrying
> $2.3 billion in gross debt as of the end of the first quarter of 2023.
Quick Ratio is 2.0 and Interest Coverage is 21.8.
With regard to sales:
- YF projects YOY 3.3% and 7.6% for ’24 and ’25, respectively (based on 29 analysts).
- Zacks projects YOY 3.5% and 7.6% for ’24 and ’25, respectively (10 analysts).
- Value Line projects 7.0% annualized growth from ’23-’28.
- CFRA projects 2.8% YOY and 4.6% per year for ’24 and ’23-’25, respectively.
- M* provides a 2-year ACE of 6.8% per year.
>
I am forecasting near the bottom of the range at 3.0% per year.
With regard to EPS:
- MarketWatch projects 12.0% and 14.5% per year for ’23-’25 and ’23-’26, respectively (based on 34 analysts).
- Nasdaq.com projects 17.5% and 24.3% per year for ’24-’26 and ’24-’27 [9, 6, and 2 analyst(s) for ’24, ’26, and ’27].
- Seeking Alpha projects 4-year annualized growth of 9.1%.
- YF projects YOY 16.5% and 16.9% for ’24 and ’25, respectively (24), along with 5-year annualized growth of 22.6%.
- Zacks projects YOY 6.6% and 17.4% for ’24 and ’25, respectively (9), along with 5-year annualized growth of 5.6%.
- Value Line projects 9.3% annualized growth from ’23-’28.
- CFRA projects 12.2% YOY and 11.9% per year for ’24 and ’23-’25, respectively, along with a 3-year CAGR of 10.0%.
- M* projects long-term annualized growth of 17.8%.
>
My 5.0% forecast is below the long-term-estimate range (mean of five: 12.9%).
Initial value—pivotal for any stock study—depends on EPS that is very hard to decipher for this company. From the M* website, I get diluted earnings for ’20-’23, respectively: $2.69, $3.40, -$5.48, and $2.24/share. M* website also gives normalized EPS of $3.31, $4.03, $4.21, and $4.28/share for ’20-’23: three years of consecutive growth with the ’22 goodwill impairment charge excluded. CFRA reports normalized EPS of $3.19, $4.32, $4.61, and $4.99/share: three years of consecutive growth. Value Line reports $2.69, $3.40, $2.46, and $2.24/share. Despite a footnote indicating the $1B goodwill impairment charge excluded for ’22 ($2.46/share), it still reports YOY EPS declines for ’22 and ’23. BI website gives something altogether different with $2.69, $3.40, $4.61, and $2.24: YOY decline only for ’23. Since BI gets data from M*, why is this different from the other two sets of data from the M* website?
Excluding a negative as a nonrecurring expense to smooth out data and enable future projection makes logical sense to me.
In this case, excluding the negative results in consistently growing profits (i.e. M* and CFRA normalized EPS), EPS contraction (Value Line), or delayed EPS contraction (BI website). The waters are muddy.
The BI website pairs a low ’23 EPS with a 17.8% growth rate. This seems too low given my 5.0% growth rate.
In contrast, I feel the ’23 normalized EPS numbers are too high.
As a compromise, I will use M* 2020 normalized EPS of $3.31/share as ’23 initial value. $3.31 * (1.05 ^ 5) = $4.22/share high EPS. Since the BI website uses $2.24 initial value, I need to enter a 13.5% growth rate to get $4.22.
My Forecast High P/E is 30.0. Since 2017, high P/E ranges from 32.1 in ’17 to 96.5 in ’19 with a last-5-year mean of 75.2. The last-5-year-mean average P/E is 52.5. I am forecasting below the range.
My Forecast Low P/E is 14.0. Since 2017, low P/E ranges from 11.1 in ’20 to 52.3 in ’19 with a last-5-year mean of 29.8. I am forecasting toward the bottom of the range [’20 and ’17 (13.8) are lower].
My Low Stock Price Forecast (LSPF) of $46.30 is default based on $3.31/share initial value. This is 32.8% less than the previous close and ~20% less than the 52-week low.
These inputs land ETSY in the HOLD zone with a U/D ratio of 2.6. Total Annualized Return (TAR) is 12.9%.
PAR (using Forecast Average—not High—P/E) is less than I seek for a large-size company at 6.1%. If a healthy margin of safety (MOS) anchors the study, then I can proceed based on the 12.9% Total Annualized Return (TAR) instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on a tiny sample of 13 studies (my study and 7 outliers excluded), averages (lower of mean/median) for projected sales growth, EPS growth, Forecast High P/E, and Forecast Low P/E are 6.8%, 5.0%, 48.7, and 29.3, respectively. I am equal to or lower for all. Value Line projects an average annual P/E of 35.0, which is less than MS (39.0) and much higher than mine (22.0).
MS high / low EPS are $2.86/ $2.24 versus my $4.22/ $3.31 (per share). My higher EPS range is due to a higher initial value. I think the analyst earnings data confuses most people just like it has me. Value Line’s high EPS is in the middle at $3.50/share.
MS Low Stock Price Forecast (LSPF) of $57.10 implies a Forecast Low P/E of 25.5: less than the above-stated 29.3. MS LSPF is 13.0% less than the default $2.24/share * 29.3 = $65.63 resulting in more conservative zoning. MS LSPF is 23.3% greater than mine, however.
TAR (over 15.0% preferred) is less than MS 15.0%. I don’t want to conclude too much because of the small MS sample, but I believe MOS is at least moderate in the current study if not healthy.
With regard to valuation, PEG is 4.8 and 5.9 per Zacks and my projected P/E, respectively: both extremely high and probably not immune to the EPS confusion. Relative Value [(current P/E) / 5-year-mean average P/E] is cheap at 0.6.
ETSY makes for an extremely challenging stock study. It’s close to or in the BUY zone if recent, normalized EPS is used. PAR is less than T-bills if $2.24/share is used with a conservative growth rate. The stock is probably best left at the foot of the barbed wire fence or at least limited to a speculative position size because the case for “up, straight, and parallel” may be weak depending on what EPS data is used.
I have ETSY a BUY under $66/share. A further [10% perhaps] discount may be warranted because of all the uncertainty.
Categories: BetterInvesting® | Comments (0) | Permalink