AMZN Stock Study (5-2-23)
Posted by Mark on May 7, 2023 at 07:46 | Last modified: May 2, 2023 17:02I recently did a stock study on Amazon.com, Inc. (AMZN) with a closing price of $102.05.
Value Line writes:
> Amazon.com is the largest online retailer. The company
> opened its virtual doors in 1995. Sales breakdown (2021):
> North America; 59% of sales. International sales, 27% of
> total. Amazon Web Services (AWS), 14%. Third-party sellers
> (Marketplace) account for about 20% of sales. Seasonality:
> Q4 accounted for 29% of ’21 revenue. Acquired Audible.com,
> ’08, Zappos, ’09, Whole Foods Market, ’17.
This mega-size (> $50B) company has grown sales at an annualized rate of 25.8% over the last 10 years and EPS at an annualized rate of 50.7% from ’18-’21 excluding fractional EPS from ’13-’17 that skew the rate even higher. Also excluded is ’22 when the company lost $0.27/share due to its equity investment in Rivian (RIVN). According to the Seattle Times:
> During the fourth quarter, Amazon said it faced a pretax
> valuation loss of $2.3 billion from its investment in
> RIVN… For the full year [2022], Amazon said it saw a
> valuation loss of $12.7 billion from its investment in RIVN.
> That’s compared with a gain of $11.8 billion in 2021.
With negative EPS for ’22, the earnings projections going forward are No Meaningful Figure (NMF) in some cases (e.g. over 100%) and something to screen closely for relevance.
Lines are mostly up and parallel except for EPS decline in ’22. PTPM has trended higher from 0.7% in ’13 to 8.1% in ’21 with a last-5-year average (excluding ’22) of 6.1%. This is slightly lower than the industry and roughly equal to peer averages.
ROE has trended up from 3.0% in ’13 to 27.4% in ’21 with a last-5-year average (excluding ’22) of 24.6%. Debt-to-Capital is slightly lower than peer and industry averages despite increasing from 34.7% in ’13 to 49.0% in ’22 with a last-5-year average of 48.1%. Although Interest Coverage is only 2.3 and the Current Ratio only 0.92, M* and Value Line give Exemplary and A++ ratings for Capital Allocation and Financial Strength, respectively. M* writes:
> The balance sheet is sound with a net cash position and only modest
> gross debt. We expect the balance sheet to remain sound as the
> company has typically maintained a conservative balance sheet
> and generates more than enough FCF from [Amazon Web Services]
> and advertising to fund growth throughout the business.
I forecast long-term annualized sales growth of 8% based on the following:
- CNN Business projects 8.8% YOY and 10.4% growth per year for ’23 and ’22-’24, respectively (based on 44 analysts).
- YF projects YOY 9.0% and 11.8% for ’23 and ’24, respectively (45 analysts).
- Zacks projects YOY 8.9% and 12.6% for ’22 and ’23, respectively (14).
- Value Line projects 13.1% growth per year from ’22-’27.
- CFRA projects 8.5% YOY and 9.2% per year for ’23 and ’22-’24, respectively.
- M* provides a 2-year annualized ACE of 9.7% while projecting 10.0% for the next five years in its analyst note.
>
I am forecasting conservatively below the long-term estimates.
I forecast long-term annualized EPS growth of 61% based on the following:
- CNN Business projects 5-year annualized growth of 22.0% (based on 44 analysts).
- MarketWatch projects growth of 43.2% YOY and 53.6% per year for ’24 and ’23-’25, respectively (53 analysts; I avoided the negative ’22 but could not avoid a still-depressed ’23).
- Nasdaq.com projects 51.5% per year and 48.5% YOY for ’24 and ’23-’25 (14, 13, and 9 analysts for ’23, ’24, and ’25).
- Seeking Alpha projects 4-year annualized growth of 36.7%, which I have to regard as NMF (probably due to the negative ’22 value).
- YF projects YOY growth of 674% and 65.8% for ’23 and ’24, respectively (45), which I regard as NMF.
- Zacks projects YOY growth of 114% and 54.3% for ’23 and ’24, respectively (both NMF), along with a 5-year annualized estimate of 18.4% (13).
- Value Line projects annualized growth of 15.2% from ’21-’27 (and 38.5% from ’22-’27, which I regard as NMF).
- CFRA reports EPS of $3.24/share and d$0.27 for ’21 and ’22, respectively—neither of which equals the sum of the four quarters shown in its earnings table. I regard its ’23 YOY and ’22-’24 projections as NMF, accordingly.
- M* gives a long-term estimate of 27.7% to get a final value of $0.92/share in five years. As a complete disconnect relative to other projections, I regard this as NMF.
>
When the smoke clears and the dust settles, I have three long-term estimates averaging 18.5%. I am forecasting conservatively below the range at 12%.
I also must decide what initial value to use for the EPS projection. Rather than $3.24 in ’21 (or negative ’22, which is NMF), I will use the ’20 EPS of $2.09. $2.09/share * (1.12 ^ 7) = $4.62/share. The closest I can do is project from the last quarterly point ($0.42/share) to get $4.54/share using a 61% growth rate.
My Forecast High P/E is 35. Since 2016, high P/E has eased from 173 to 58.2 (2021) with a last-5-year average of 83.3. At some point, I expect P/E to fall into a “normal” range, but exactly when is unknown.
My Forecast Low P/E is 25. Since 2016, low P/E has eased from 96.7 to 44.4 (2021) with a last 5-year average of 51.2. Again, exactly when this will fall into a “normal” range is unknown.
To determine Low Stock Price Forecast (LSPF), I will assume zero growth from the initial value determined above. That would be the $2.09/share followed by 12% growth for ’21 and ’22 resulting in a low EPS of $2.62/share and LSPF of $65.50. This is 35.8% less than the previous closing price and 19.5% less than the 52-week low.
These inputs land AMZN in the HOLD zone with an U/D ratio of 1.6. The Total Annualized Return (TAR) is 9.3%.
PAR (using Forecast Average—not High—P/E) is lower than desired at 6.0%. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on TAR instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 857 studies done in the past 90 days (266 outliers and my study excluded), averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, and Forecast Low P/E are 12.0%, 18.0%, 63.3, and 51.2. I am lower across the board. Value Line projects a future average annual P/E of 39.5, which is lower than MS (57.3) and higher than mine (30.0).
It’s quite apparent the MS community is confused about how to approach this company [I have struggled as well!]. Mean projected annualized EPS growth is 88.6%. 96 studies have EPS growth rates between 300-821% and the standard deviation is over 175%, which overwhelms the new outlier screening functionality. Thankfully mean and median are both reported thereby allowing me to choose the lesser value for a more conservative comparison.
With regard to other data, MS high and low EPS are $2.51/share (mean $4.51 with SD $5,238) and $1.09/share (mean $2.88 with SD $7.62) compared to my $4.54 and $2.62. I would argue both MS high and MS low EPS values to be unreasonably low [and at least partially offset by the high MS P/E range]. My high EPS is in the ballpark with the Value Line estimate (~10% lower). The MS LSPF of $78.90 is 20.5% greater than mine. I won’t try to calculate a default or implied Forecast Low P/E due to the widespread distribution.
I come away feeling MOS to be robust in the current study. I would look to re-evaluate the stock under $88/share.
Categories: BetterInvesting® | Comments (0) | PermalinkPOOL Stock Study (5-2-23)
Posted by Mark on May 6, 2023 at 07:25 | Last modified: May 2, 2023 14:18I recently did a stock study on Pool Corp. (POOL) with a closing price of $346.78.
CFRA writes:
> Pool Corp. is one of the world’s largest wholesale distributors of
> swimming pool and related backyard products. It is also one of the
> top three distributors of irrigation and related products in the U.S.
> POOL offers a comprehensive selection of services and products
> including: 1) pool maintenance, which includes supplies, repair
> parts and chemicals; 2) pool construction and renovation, which
> includes pool tile, control systems, lighting, pool pumps, filters,
> heaters, cleaners, among others; 3) commercial and residential
> irrigation and landscape equipment and maintenance; 4) outdoor
> living, which includes grills, lighting, and hardscape products.
> Customers primarily include swimming pool remodelers and builders;
> specialty retailers that sell swimming pool supplies; swimming pool
> repair and service businesses; irrigation construction and landscape
> maintenance contractors; and commercial customers who service
> large commercial installations such as hotels, universities, and
> community recreational facilities.
Over the last 10 years, this medium-size company has grown sales and earnings at annualized rates of 12.3% and 28.0% per year, respectively. Lines are up, mostly straight, and narrowing. PTPM increased from 7.6% in ’13 to 15.9% in ’22 with a last-5-year average of 12.5%. This is about even with peer averages and slightly higher than the industry.
ROE increased from 27.7% in ’13 to 61.3% in ’22 with a last-5-year average of 62.1%. This is an eye-popping number and well above peer and industry averages. Debt-to-Capital increased from 46.3% in ’13 to 74.9% in ’19 before cooling to 57.3% in ’22 for a last-5-year average of 60.3%. In case debt is a concern, Interest Coverage is 25 with Current Ratio a solid 2.4 per M*. Value Line says the former is 104 and gives the company an A rating for Financial Strength.
I forecast long-term annualized sales growth of 3% based on the following:
- CNN Business projects contraction of 18.1% YOY and 4.4% per year for ’23 and ’22-’24 (based on 10 analysts).
- YF projects YOY 5.5% contraction and 4.9% growth for ’23 and ’24, respectively (11 analysts).
- Zacks projects YOY 6.7% contraction and 5.5% growth for ’23 and ’24, respectively (6).
- Value Line projects 6.6% annualized growth from ’22-’27.
- CFRA projects 0.3% YOY growth and 2.6% growth per year for ’23 and ’22-’24, respectively.
- M* provides a 2-year ACE of 1.6% contraction per year.
>
I am forecasting conservatively by cutting the one available long-term estimate in half.
I forecast long-term annualized EPS growth of 1% based on the following:
- CNN Business projects 6.5% YOY contraction and 0.8% contraction per year for ’23 and ’22-’24, respectively (based on 10 analysts), along with 5-year annualized growth of 1.6%.
- MarketWatch projects 5.1% contraction per year and 0.4% growth per year for ’22-’24 and ’22-’25 (12 analysts).
- Nasdaq.com projects 11.1% YOY growth and 11.7% growth per year for ’24 and ’23-’25, respectively (7, 8, and 3 analysts for ’23, ’24, and ’25).
- Seeking Alpha projects 4-year annualized growth of 1.6%.
- YF projects YOY 19.5% contraction and 13.5% growth for ’23 and ’24, respectively (9), along with 5-year annualized growth of 4.2%.
- Zacks projects YOY 16.9% contraction and 9.7% growth for ’23 and ’24, respectively (8), along with 5-year annualized growth of 5.9%.
- Value Line projects annualized growth of 5.1% from ’22-’27.
- CFRA projects contraction of 18.3% YOY and 6.7% per year for ’23 and ’22-’24, respectively, in addition to 3-year projected CAGR of 6% [that I cannot reconcile with the EPS table].
>
I am forecasting below the entire long-term-estimate range (mean of five: 3.7%). Furthermore, I am projecting from the 2023 Q1 $16.81/share EPS rather than the 2022 EPS of $18.70.
My Forecast High P/E is 28. Over the last 10 years, high P/E has ranged from 26.5 in ’14 to 31.3 in ’18. This excludes ’19-’21 when high P/E made excursions to 35.7, 43.6, and 36.5, respectively. With a slowdown expected ahead, my forecast is lower than all values but ’14.
My Forecast Low P/E is 14. Over the last 10 years, low P/E went from 20.9 in ’14 to 22.2 in ’19 before heading lower to 14.9 in ’22. The last-5-year average is 19.2. I am forecasting below the entire range.
My Low Stock Price Forecast (LSPF) is the default value of $235.30, which assumes zero growth from the 2023 Q1 EPS of $16.81/share. This is 32.1% less than the previous close and 15.4% less than the 52-week low.
Over the last 10 years, Payout Ratio has ranged from 18.7% in ’21 to 35.6% in ’13 with a last-5-year average of 25.6%. I am forecasting conservatively at 19%.
These inputs land POOL in the HOLD zone with an U/D ratio of 1.2. The Total Annualized Return (TAR) is 7.8%.
PAR (using Forecast Average—not High—P/E) is 2.0%. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on TAR instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on only 71 studies done in the past 90 days (25 outliers and my study excluded), averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 9.6%, 9.5%, 30.0, 18.8, and 27.6%. I am lower across the board. Value Line projects a future average annual P/E of 24.0, which is lower than MS (24.4) and higher than mine (21.0).
With regard to other data, MS high and low EPS are $28.76/share and $18.80/share compared to my $17.67 and $16.81. My high EPS is lower due to a lower forecast growth rate and my low EPS uses the most recent quarter of [lower] growth. The MS LSPF of $265.70 implies a Forecast Low P/E of 14.1, is much less than the $18.80 * 18.8 = $353.44 default value, and is 12.9% higher than mine. MOS seems robust in the current study.
I would look to re-evaluate the stock under $300/share.
Categories: BetterInvesting® | Comments (0) | PermalinkINMD Stock Study (3-23-23)
Posted by Mark on May 4, 2023 at 07:18 | Last modified: April 13, 2023 14:04I recently did a stock study on InMode Ltd. (INMD) with a closing price of $30.48.
M* writes:
> InMode Ltd provides minimally and non-invasive surgical
> aesthetic and medical treatment solutions in the United
> States. Its products and solutions address three energy-
> based treatment categories that include face & body
> contouring, medical aesthetics, and women’s health.
> InMode has developed products using its technology for
> plastic surgery, dermatology, gynecology, and ophthalmology.
Since 2018, this small-size company has grown sales and EPS at annualized rates of 47.0% and 52.9% (including ’17—a low base—raises these rates to 52.6% and 68.7%, respectively). Lines are mostly up, straight, and parallel except for EPS dip in ’22. PTPM leads peer/industry averages, increasing from 18.3% in ’17 to 44.3% in ’22 with a last-5-year average of 38.3%.
ROE averages 33.7% over the last four years. This leads the industry and is roughly equal to peer averages. The company has minimal uncapitalized, annual rentals but no long-term debt. As a result, Debt-to-Capital averages 0.5% over the last five years. Quick Ratio is over 7.
I forecast 12% long-term annualized sales growth based on the following:
- CNN Business projects 16.7% YOY and 16% per year for ’23 and ’22-’24, respectively (based on 4 analysts).
- YF projects YOY 16.7% and 15.2% for ’23 and ’24, respectively (5 analysts).
- Zacks projects YOY 16.7% and 16.1% growth for ’23 and ’24, respectively (1).
- CFRA projects 16.7% YOY and 16% per year for ’23 and ’22-’24, respectively (4).
- M* projects 15.9% per year for the next two years.
>
Consensus for the next two years is at least 15% per year. I am conservatively discounting that by 30% for the longer term.
I forecast 12% long-term annualized EPS growth based on the following:
- CNN Business projects 7.4% YOY and 10.8% per year for ’23 and ’22-’24, respectively (based on 4 analysts).
- MarketWatch (also FactSet) projects 13.4% and 14.2% per year for ’22-’24 and ’22-’25, respectively (5 analysts).
- Nasdaq.com projects 17.7% YOY and 16.8% per year for ’24 and ’23-’25, respectively (1).
- YF projects YOY 7.4% and 14.2% for ’23 and ’24, respectively (5), along with 5-year annualized growth of 12.5%.
- Zacks projects YOY 7% and 15.4% for ’23 and ’24, respectively (1).
- Value Line projects annualized growth of 20% from ’22-’24.
- CFRA projects 37.6% YOY and 25.4% per year for ’23 and ’22-’24, respectively (3).
>
I am forecasting just under the one available long-term estimate.
My Forecast High P/E is 25. High P/E over the last four years has ranged from 29.9 (’20) to 51.7 (’21) with an average of 39. I am forecasting below the range.
My Forecast Low P/E is 9. Low P/E over the last four years has ranged from 7.4 (’20) to 11.8 (’21). I am forecasting just below the mean (9.6) and median (9.5).
My Low Stock Price Forecast (LSPF) is the default value of $18.10. This is 40.6% less than the previous close and 12.1% less than the 52-week low.
These inputs land INMD in the BUY zone with an U/D ratio of 3.8. Total Annualized Return (TAR) is 21.4%.
PAR (using Forecast Average, not High, P/E) is decent at 12.4%. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on TAR instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Out of 324 studies (mine excluded) done in the last 90 days, projected sales growth, projected EPS growth, Forecast High P/E, and Forecast Low P/E, average 16.9%, 13.2%, 27.9, and 9.4, respectively. My inputs are slightly lower.
Value Line projects an average annual P/E of 12.9.in ’24, which is significantly lower than MS (18.7) and mine (17). Value Line states average annual P/E from ’19 to ’22 as: 20.5, 19.3, 28, and 18.1. In looking at the high/low P/E by year from M*, I see 36.7/8.2 (mean 22.5), 29.9/7.4 (mean 18.7), 51.7/11.8 (mean 31.8), and 37.6/10.9 (mean 24.3). The difference between Value Line and M* is therefore -2.0, +0.6, -3.8, and -6.2. On average, Value Line seems to understate M* by 11.4 / 4 ~ 2.8. Even adding this to the projected 12.9 in ’24 gets 15.7, which is still less than mine. Even though I am using a 12% EPS growth rate compared to Value Line’s 20%, I don’t see much MOS behind this study [overlooking the detail that Value Line’s projections are through ’24 rather than five years hence].
MS average high and low EPS are $3.68/share and $1.96/share compared to my $3.33 and $2.01. MS Low Stock Price Forecast is 6.4% above mine at $19.26.
Due to MOS concerns, I would look to buy under $31/share (an arbitrary 10% lowering of the upper purchase limit).
Categories: BetterInvesting® | Comments (0) | PermalinkCME Stock Study (4-10-23)
Posted by Mark on May 2, 2023 at 07:02 | Last modified: April 13, 2023 10:58I recently did a stock study on CME Group Inc. (CME) with a closing price of $195.10.
Value Line writes:
> CME Group Inc. is the world’s largest and most diversified
> derivatives marketplace. It enables clients to trade
> futures, options, cash, and over-the-counter (OTC) markets,
> optimize portfolios, and analyze date. It offers a range of
> global benchmark products across major asset classes, incl.
> interest rates, equity indexes, foreign exchange (FX),
> agricultural commodities, energy, and metals.
> Clearing/transaction fees (83% of ’22 rev.), Market
> data/information services (12%), Other (5%). Acq. CBOT
> Holdings, 7/07; NYMEX, 8/08.
Over the last 10 years, this medium-size company has grown sales and EPS at annualized rates of 6.7% and 10.3%, respectively. Lines are mostly up, straight, and parallel except for EPS spike in ’17 (probably due to TCJA), sales dip in ’21, and EPS dip in ’22. PTPM has been much better than peer and industry averages, going from 54.5% in ’13 to 69.5% in ’22 with a last-5-year average of 63.4%.
Over the last decade, ROE has been lower than peer and industry averages increasing from 4.4% in ’13 to 9.4% in ’22 while posting a last-5-year average of 8.7%. Debt-to-Capital has been much lower than peer and industry averages. This has ranged from 9.1% in ’17 to 14.5% in ’18 with a last-5-year average of 12.2%.
M* rates the company Exemplary for Capital Allocation while Value Line assigns an A rating for Financial Strength. Interest Coverage is 22.
Given all this, I am perplexed to see M* report a Quick Ratio of 0.02. In responding to another inquiry I had recently, M* wrote: QR = (Receivables + Cash and cash equivalent) / Current Liabilities . Applying that to the Value Line data shown in the left margin, this is (483.2 + 138065.3) / 137687.5 = 1.0. I have no qualm with that.
I forecast 3% long-term annualized sales growth based on the following:
- CNN Business projects 6.0% YOY and 4.9% per year for ’23 and ’22-’24 (based on 21 analysts).
- YF projects YOY 5.1% and 3.8% for ’23 and ’24, respectively (17 analysts).
- Zacks projects YOY 3.8% and 4.4% for ’23 and ’24, respectively (7).
- Value Line projects 4.3% annualized growth from ’22-’27.
- CFRA projects 2.4% YOY and 2.3% per year for ’23 and ’22-’24, respectively.
- M* gives a 2-year ACE of 4.8% annualized growth while projecting 3.9% in its analyst note.
>
I forecast 3% long-term annualized EPS growth based on the following:
- CNN Business projects 6.4% YOY and 5.0% per year for ’23 and ’22-’24, respectively (based on 21 analysts), along with 5-year annualized at 4.1%.
- MarketWatch projects 5.2% and 5.6% per year for ’22-’24 and ’22-’25 (20 analysts).
- Nasdaq.com projects 3.4% and 6.8% per year for ’23-’25 and ’23-’26, respectively [9, 4, and 1 analyst(s) for ’23, ’25, and ’26].
- Seeking Alpha projects 4-year annualized growth of 4.1%.
- YF projects YOY 6.3% and 3.0% growth for ’23 and ’24, respectively (17), along with 5-year annualized at 3.9%.
- Zacks projects YOY 6.2% and 2.7% growth for ’23 and ’24 (9) along with 5-year annualized at 3.7%.
- Value Line projects 7.2% annualized growth from ’22-’27.
- CFRA projects 2.0% YOY, 2.4% per year, and 3% per year for ’23, ’22-’24, and 3-year estimated CAGR, respectively.
- M* projects long-term annualized growth of 5.4%.
>
I am forecasting below the entire long-term-estimate range (mean of six: 4.7%).
My Forecast High P/E is 27. Excluding 13.0 in ’17, high P/E over the last 10 years has ranged from 27.3 (’15) to 38.4 (’20) with a last-5-year average of 35.5. With growth projected to slow, I am forecasting below the range.
My Forecast Low P/E is 19. Excluding 9.5 in ’17, low P/E over the last 10 years has ranged from 17.5 (’13) to 27.3 (’19) with a last-5-year average of 24.3. I am forecasting near the bottom of the range [’13 and ’16 (18.1), are lower].
My Low Stock Price Forecast (LSPF) is the default value of $140.40. This is 28.0% less than the previous close and 15.7% less than the 52-week low.
Excluding 51.4% in ’17, Payout Ratio over the last 10 years has ranged from 79.7% in ’18 to 150.7% in ’13 with a last-5-year average of 96.4%. Most of these numbers seem unsustainably high [I actually wonder if this portion of the data stream is corrupt]. I am forecasting below the range at 50.0%.
These inputs land CME in the HOLD zone with an U/D ratio of 0.7. Total Annualized Return (TAR) is 5.3%.
PAR (using Forecast Average, not High, P/E) is 2.4%, which is too low for a medium-size company. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on TAR instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on only 20 studies done in the past 90 days (my study along with 7 outliers excluded), averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 5.1%, 5.5%, 28.4, 19.9, and 45.9%. I am lower on everything but Payout Ratio. Value Line projects a future average annual P/E of 22.5, which is lower than MS (24.2) and just lower than me (23.0). Overall, this study seems to have a small MOS.
With regard to other data, MS high and low EPS are $9.44/share and $6.63/share compared to my $8.58 and $7.39. My low EPS may be higher due to recent quarterly growth while my high EPS is lower due to a lower forecast growth rate. MS LSPF is $134.80 (4.2% less than mine). This is slightly higher than the default $6.63 * 19.9 = $131.94, which seems reasonable (MS LSPF is typically much lower than default).
I would look to re-evaluate this stock under $163/share.
Categories: BetterInvesting® | Comments (0) | PermalinkNFLX Stock Study (4-27-23)
Posted by Mark on April 29, 2023 at 06:52 | Last modified: April 27, 2023 10:36I recently did a stock study on Netflix Inc. (NFLX) with a closing price of $321.15.
M* writes:
> Netflix’s primary business is a streaming video on demand
> service now available in almost every country worldwide
> except China. The firm primarily generates revenue from
> subscriptions to its eponymous service. Netflix delivers
> original and third-party digital video content to PCs,
> internet-connected TVs, and consumer electronic devices,
> including tablets, video game consoles, Apple TV, Roku,
> and Chromecast. Netflix is the largest SVOD platform in
> the world with over 220 million subscribers globally
This large-size company has grown sales and earnings at annualized rates of 26.6% and 58.4%, respectively, over the last 10 years. Lines are mostly up and parallel except for EPS declines in ’15 and ’22. PTPM has trended higher from 3.9% in ’13 to 16.6% in ’22 with a last-5-year average of 13.4%. This trails peer and industry averages.
ROE, which slightly lags peers and the industry, has trended up from 9.2% to 21.6% over the last 10 years with a last-5-year average of 26.0%. Debt-to-Capital, which overall is higher than peers but lower than the industry, increased from 27.3% in ’13 to 66.4% in ’18 before declining to 40.9% in ’22. The last-5-year average is 56.5%, which is a bit higher than I would like to see. Interest Coverage and Quick Ratio were most recently 7.2 and 1.1, respectively. As of Q2 2022, the M* analyst says the company is in a “decent position” with $14.2B long-term debt and $7.8B cash. M* gives the company a Standard rating for Capital Allocation while Value Line gives an A for Financial Strength.
I forecast long-term annualized sales growth of 7% based on the following:
- CNN Business projects 7.3% YOY and 9.8% per year for ’23 and ’22-’24, respectively (based on 36 analysts).
- YF projects YOY 7.3% and 12.2% for ’23 and ’24, respectively (33 analysts).
- Zacks projects YOY 6.8% and 11.9% for ’23 and ’24, respectively (13).
- Value Line projects 9.9% growth per year from ’22-’27.
- CFRA projects 7.5% YOY and 10.2% per year for ’23 and ’22-’24, respectively.
- M* provides a 2-year ACE of 9.9% while projecting 9.0% in its analyst note.
>
I am forecasting toward the low end of the range.
I forecast long-term annualized EPS growth of 13% based on the following:
- CNN Business projects 12.5% YOY and 20.0% per year for ’23 and ’22-’24, respectively (based on 36 analysts), along with 5-year annualized growth of 29.0%.
- MarketWatch projects annualized ACE of 18.1% and 21.0% for ’22-’24 and ’22-’25, respectively (45 analysts).
- Nasdaq.com projects 25.8% and 23.8% per year for ’23-’25 and ’23-’26 (14, 9, and 4 analysts for ’23, ’25, and ’26).
- Seeking Alpha projects 4-year annualized growth of 25.7%.
- YF projects YOY 11.4% and 28.6% for ’23 and ’24, respectively (32), along with 5-year annualized growth of 21.7%.
- Zacks projects YOY 11.8% and 29.7% for ’23 and ’24, respectively (14), along with 5-year annualized growth of 22.5%.
- Value Line projects annualized growth of 13.6% from ’22-’27.
- CFRA projects 14.6% YOY and 21.5% per year for ’23 and ’22-’24, along with a 3-year projected CAGR of 18%.
- M* gives a long-term annualized growth estimate of 17.4%.
>
I am forecasting just under the long-term-estimate range (mean of six: 21.7%).
My Forecast High P/E is 35. High P/E has decreased from 210 in ’13 to 61.3 in ’22 with a last-5-year average trending lower at 93.9. At some point, I expect P/E to fall back to earth. For now, I am forecasting at the upper end of my comfort zone.
My Forecast Low P/E is 23. Low P/E has decreased from 49.1 in ’13 to 16.4 in ’22 with a last-5-year average trending lower at 48.1. Again, at some point I expect P/E to fall back to earth and we may already be starting to see this. I am forecasting toward the bottom of the 10-year range (only ’22 is lower).
My Low Stock Price Forecast (LSPF) is the default value of $213.90. This is 33.4% less than the previous close but 31.5% greater than the 52-week low.
These inputs land NFLX in the HOLD zone with an U/D ratio of 2.6. The Total Annualized Return (TAR) is 13.3%.
PAR (using Forecast Average—not High—P/E) is 9.1%. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on the 13.3% instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 275 studies done in the past 90 days (71 outliers and my study excluded), averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, and Forecast Low P/E are 10.1%, 12.3%, 36.5, and 35.6 [interesting to see high and low P/E so close together]. I am lower on everything but EPS growth. Value Line projects a future average annual P/E of 33.0, which is lower than MS (36.1) and higher than me (29.0). I seem to have a decent MOS behind this study.
With regard to other data, MS high and low EPS are $17.69/share and $9.49/share compared to my $17.13 and $9.30. MS LSPF is $170.10 (20.5% higher than mine). This is less than half the default $9.49 * 35.6 = $340.69 and implies a Forecast Low P/E of 17.9. While this is quite the disconnect, it errs to the conservative side by decreasing the future stock price range thereby requiring a lower basis to invest. I find no fault with that.
I would look to invest under $310/share.
Categories: BetterInvesting® | Comments (0) | PermalinkWAL Stock Study (4-12-23)
Posted by Mark on April 28, 2023 at 06:33 | Last modified: July 3, 2023 10:16I recently did a stock study on Western Alliance Bancorp (WAL) with a closing price of $31.84.
M* writes:
> Western Alliance Bancorporation is a Las Vegas-based holding
> company with regional banks operating in Nevada, Arizona, and
> California. The bank offers retail banking services and focuses
> on mortgages for retail customers and commercial loans, mainly
> for real estate. The bank also has an investment advisory
> business that manages investment portfolios for Western clients
> and clients of other banks.
I initially studied this stock on 3/15/23. I decided to do the 4/12/23 update with a new Value Line report just published.
Over the last 10 years, this medium-sized bank has grown assets and EPS 24.1% and 24.5% per year, respectively. Lines are mostly up, straight, and parallel (including total assets and sales). PTPM has trended up from 41.2% in ’13 to 57.3% in ’22 with a last-5-year average of 56.3%. This leads peer and industry averages.
ROE has trended up from 16.8% in ’13 to 21.0% in ’22 with a last-5-year average of 18.4%. This also leads peer and industry averages. Debt-to-Capital went from 30.9% in ’13 to 15.7% in ’20 before increasing to 55.7% in ’22. This was lower than peer and industry averages until two years ago. The last-5-year average is 26.2%. Value Line gives a B++ Financial Strength rating.
ROAA has increased from 1.34% in ’13 to 1.69% in ’22 with a last-5-year average of 1.85%. This is outstanding and has been above 1.50% every year since ’15.
The historical picture is completely unchanged since the 3/15/23 stock study. Looking forward is where things get murky.
In the first study, I went with a conservative 10% long-term sales growth forecast based on the following:
- CNN Business projects 15.4% YOY and 12.7% per year for ’23 and ’22-’24, respectively (based on 13 analysts).
- YF projects YOY 17% and 8.4% for ’23 and ’24, respectively (10 analysts).
- Zacks projects YOY 14.8% and 8.6% for ’23 and ’24, respectively (6).
- CFRA projects growth of 17.6% YOY and 12.8% per year for ’23 and ’22-’24, respectively (7).
- M* gives an ACE of 19.6% per year for the next two years.
>
On 4/12/23, we have:
- CNN Business projects 3.8% YOY and 5.6% per year for ’23 and ’22-’24, respectively (based on 15 analysts).
- YF projects YOY 8.2% and 6.0% for ’23 and ’24, respectively (12 analysts).
- Zacks projects YOY 5.3% and 6.8% for ’23 and ’24, respectively (6).
- CFRA projects growth of 10.5% YOY and 8.1% per year for ’23 and ’22-’24, respectively (7).
- M* gives an ACE of 18.7% per year for the next two years.
>
That’s some kind of haircut. I am now forecasting 5%—near the bottom of the range especially without a good explanation for why the analysts’ estimates have changed so drastically. I suspect a higher level of analyst uncertainty, and the more uncertain the estimates the more conservative my forecast should probably be.
One estimate that did not change much is M*. This confuses me because they’re all ACE as opposed to single-analyst projections. I would not think anything should be substantially different between M*’s batch of surveyed analysts and batches from other sources. The numbers indicate otherwise.
With regard to long-term EPS growth, I went with a 10% forecast in the original 3/15/23 study based on the following:
- CNN Business projects 6.9% YOY and 8.7% per year for ’23 and ’22-’24, respectively (based on 13 analysts), along with a 5-year annualized growth of 11.1%.
- MarketWatch projects 5% and 5.7% per year for ’22-’24 and ’22-’25, respectively (13 analysts).
- Nasdaq.com projects 10.7% YOY for ’24 (9).
- Seeking Alpha projects 4-year annualized growth of 11.1%.
- YF projects YOY 6.3% and 10.6% for ’23 and ’24, respectively (8), along with 5-year annualized growth of 12%.
- Zacks projects YOY 6.6% and 10.7% for ’23 and ’24, respectively (9) along with 5-year annualized growth of 10.1%.
- Value Line projects 9.5% annualized from ’21 to ’23/’24 and offers a 5-year-annualized ACE of 10.8% (9).
- CFRA projects growth of 6.1% YOY and 8.3% per year for ’23 and ’22-’24, respectively (11).
>
10% was less than the narrow range of five long-term estimates (mean 11%).
Here’s what we have today:
- CNN Business projects contraction of 15.4% YOY and 4.5% per year for ’23 and ’22-’24, respectively (based on 15 analysts), along with 5-year annualized contraction of 0.7%.
- MarketWatch projects 4.5% contraction per year and 0.7% growth per year for ’22-’24 and ’22-’25, respectively (15 analysts).
- Nasdaq.com projects 14.9% YOY growth for ’24 (9).
- Seeking Alpha projects 4-year annualized contraction of 0.7%.
- YF projects YOY 16.4% contraction and 7.5% growth for ’23 and ’24, respectively (14), along with 5-year annualized contraction of 13.3%.
- Zacks projects YOY 15.2% contraction and 15.0% growth for ’23 and ’24, respectively (9) along with 5-year annualized growth of 10.1%.
- Value Line projects 4.1% annualized growth from ’22-’24 and offers a 5-year-annualized ACE of 10.2% (9).
- CFRA projects contraction of 13.5% YOY and 3.9% per year for ’23 and ’22-’24, respectively (12).
>
It literally feels like someone swung a sledgehammer as hard as they could and decimated the bank vault. Silicon Valley Bank (Santa Clara, CA) failed on 3/10/23 and Signature Bank (New York, NY) failed on 3/12/23. That’s it since 2020 per fdic.gov. Perhaps this is how analysts adjust for more perceived risk in the industry even though I am aware of nothing drastic changing recently on a macroeconomic level (e.g. big changes in inflation, GDP growth, jobs, wages, housing, interest rates, etc.).
The mean of five long-term estimates (not including Value Line’s 4.1%) is now 1.1% with a range -13.3% to +10.2%. I have done stock studies where the high and low estimates both seem equally unreasonable and therefore discarded both. Here, 10.2% seems like one of the most reasonable estimates because it is little changed from a month ago. The Zacks estimate is entirely unchanged. On the flipside, YF (Refinitiv) went from +12.0% to -13.3%: a mindboggling reversal. They also added ~6 analysts/ratings [when this differs by 1-2 in consecutive years, I report the lower].
Rather than excluding the YF estimate altogether (resulting in a modified mean estimate of 4.7%), I will change it to -0.7% (matches long-term estimates from Factset and S&P Global) to get a modified mean estimate of 3.6%. My forecast is just below the mean at 3%, which is aggressive by my standards as I usually try to target lower in the range if not below it.
My Forecast High P/E is 11. In the original study, I wrote:
> From ’13-’22, high P/E has gone from 18.7 to 12.9 with a
> last-5-year average of 13.4. I am just below the entire
> range (lowest was 11.9 in ’19).
I see no reason to change this. What is different is the current P/E of 3.3, but I expect a return closer to the historical range over the next five years.
My Forecast Low P/E is 1. Again, I see no reason to change the original analysis:
> From ’13-’22, low P/E has gone from 8.2 to 5.7 with a last-
> 5-year average of 6.7 (lowest was 4.1 in ’20). These are
> very uncertain times for banks, however, with two banks
> failing in the past week. I am forecasting lower than
> usual in order to extend to the bottom of this range.
My Low Stock Price Forecast (LSPF) is the default value of $9.70. This is 69.5% below the previous close and 29.3% above the 52-week low of $7.50 seen the week before my original study.
Short of failing and having to shudder its doors, it seems like the 52-week low price will not be revisited anytime soon.
Western Alliance started paying a dividend in ’19 with an average Payout Ratio of 14.7% since. I am forecasting below the range (10.3% – 19.8%) at 9%.
These inputs land WAL in the BUY zone with an U/D ratio of 4.1. Total annualized return is 32.0%.
One month ago, U/D was 6.7 and total annualized return 41.4%. These numbers have fallen due to the lower forecasts.
In the original SSG, I continued:
> I assess the study margin of safety (MOS) by comparing
> my inputs with Member Sentiment (MS). Out of 453 studies
> over the past 90 days (my own excluded), projected sales
> growth, projected EPS growth, Forecast High P/E, Forecast
> Low P/E, and Payout Ratio average 15.4%, 12.8%, 12.9,
> 7.3, and 12.6%, respectively. I’m lower across the board.
> I can certainly give a pass to MS for Forecast Low P/E,
> which I certainly would not have decreased as much had
> it not been for events in the past week.
>
> As it stands, I believe the MOS here to be robust. While
> the 41.4% seems quite achievable, even PAR (based on
> Forecast Average, not High, P/E) at 26.1% would be more
> than acceptable.
Flashing forward to today, we have the following [thanks to Suzi (et. al?) for the updated MS functionality! It truly makes the process so much easier]:
Based on 377 studies done in the past 90 days (my study along with 133 outliers excluded), averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 15.0%, 12.4%, 11.7, 6.5, and 14.2% [it should be interesting to see if these come down over time]. I am much lower across the board. A robust MOS appears to back this study.
With regard to other data, MS high and low EPS are $17.25/share and $9.41/share compared to my $11.24 and $9.70. My low EPS may be lower due to recent quarterly growth while my high EPS is lower due to a lower forecast EPS growth rate. MS has a LSPF of $42.70: invalid at the present time. Just for my interest, the default LSPF of $9.41 * 6.5 = $61.17, which is 43% higher than that actually used.
Again, while 32.0% seems totally achievable from this beaten down stock price, even PAR of 17.7% would be outstanding.
This has been quite the interesting stock study, to be sure!
Categories: BetterInvesting® | Comments (0) | PermalinkOLED Stock Study (3-21-23)
Posted by Mark on April 26, 2023 at 06:31 | Last modified: April 11, 2023 15:24I recently did a stock study on Universal Display Corp. (OLED) with a closing price of $144.88.
M* writes:
> Universal Display Corp researches, develops and manufactures
> organic light-emitting diode, or OLED, technologies for use
> in displays for mobile phones, tablets, televisions, wearables,
> personal computers, automotive interiors, and the solid-state
> lighting market. OLED technologies are an alternative to a
> light-emitting diode, or LED, technologies, in the solid-state
> lighting market, and liquid crystal displays in the flat-panel-
> display market. A large majority of the firm’s revenue is
> generated in South Korea, with the rest coming from Japan,
> China, the United States, and other countries across the world.
This small-sized company has grown sales at an annualized rate of 17.2% over the last decade. EPS has grown 15.1% per year over the last decade excluding ’14 and ’15 (inclusion of these years of fractional EPS results in 22.1% annualized rate). Lines are mostly up and parallel with sales declines in ’18 and EPS declines in ’18 and ’20 (accompanying the two years mentioned previously). Over the last 10 years, PTPM has generally trended higher from 26.6% to 43.5% with a last-5-year average of 38.1%. This leads peer and industry averages.
ROE has generally rallied since ’15 with a last-5-year average of 15.3%. This leads peer averages and slightly leads the industry. Debt-to-Capital has averaged 0.9% over the last five years as the company has zero long-term debt: much lower than peer and industry averages. Quick Ratio is 4.94, and Value Line rates the company A for Financial Strength.
I forecast 6% long-term annualized sales growth based on the following:
- CNN Business projects 5.5% YOY contraction and 7.3% growth per year for ’23 and ’22-’24, respectively (based on 12 analysts).
- YF projects YOY 6.4% contraction and 21.5% growth for ’23 and ’24, respectively (11 analysts).
- Zacks projects YOY 6.7% contraction and 16.9% growth for ’23 and ’24, respectively (4).
- Value Line projects 13.3% annualized growth from ’22-’27.
- CFRA projects 5% YOY contraction and 9.2% growth per year for ’23 and ’22-’24, respectively.
- M* projects 5.9% growth per year for the next two years.
>
Given the projected contraction in ’23, I am forecasting to the low side.
I forecast 8% long-term annualized EPS growth based on the following:
- CNN Business projects 15.9% YOY contraction and 6.7% growth per year for ’23 and ’22-’24 (based on 12 analysts) along with 5-year annualized growth of 13.3%.
- MarketWatch projects annualized growth of 12.2% and 13.2% for ’22-’24 and ’22-’25, respectively (13 analysts).
- Nasdaq.com projects growth of 24.7% YOY and 30.5% per year for ’24 and ’23-’25, respectively [4, 4, and 1 analyst(s) for ’23, ’24, and ’25].
- Seeking Alpha projects 4-year annualized growth of 14.8%.
- YF projects YOY 16.6% contraction and 35.1% growth for ’23 and ’24, respectively (11), along with 5-year annualized growth of 12.2%.
- Zacks projects YOY 14.6% contraction and 24.7% growth for ’23 and ’24, respectively (4), along with 5-year annualized growth of 15.6%.
- Value Line projects annualized growth of 8.1% from ’22-’27.
- CFRA projects 14.8% YOY contraction and 8.7% growth per year for ’23 and ’22-’24, respectively, along with a 3-year CAGR of 17%.
- M* projects 30% long-term annualized growth.
>
I am forecasting just below the range of six long-term estimates (mean: 15.7%).
My Forecast High P/E is 35. Excluding triple-digit outliers in ’15 and ’18, high P/E over the last 10 years has ranged from 25.0 (’13) to 88.4 (’17) with a last-5-year average of 68.9. I am forecasting toward the bottom of the range (only ’13 is lower).
My Forecast Low P/E is 20. Excluding two upside outliers (82.6 in ’15 and 63.5 in ’18), low P/E over the last 10 years has ranged from 15.6 (’13) to 39.6 (’16) with a last-5-year average of 30.2. I am forecasting toward the bottom of the range (only the ’13 value is lower).
My Low Stock Price Forecast (LSPF) is the default value of $88.00. This is 39.3% less than the previous close and 1.6% less than the 52-week low.
The stock has paid a dividend since ’17. Payout Ratio has increased from 5.5% that year to 27.3% in ’22 with a last-5-year average of 20.5%. I am forecasting low at 10%.
These inputs land OLED in the HOLD zone with an U/D ratio of 1.6. Total Annualized Return is 10.0%.
PAR (using Forecast Average, not High, P/E) is 5%, which is too low for a small company.
I look to Member Sentiment (MS) to assess margin of safety (MOS). Out of 323 studies (mine excluded) done in the last 90 days, projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio average 13.9%, 15.1%, 47.2, 30.0, and 14.6%, respectively. My inputs are all substantially lower. Value Line projects an average annual P/E of 30, which is lower than MS (38.6) and higher than mine (27.5). All this is suggestive of a healthy MOS.
MS high and low EPS are $8.71/share and $3.73/share compared to my $6.47 and $4.40, respectively. Assuming most studies leave low EPS as TTM default, my $4.40 may be higher due to recent quarterly growth while my $6.47 is proportional to projected growth rate.
Given the robust MOS, I would look to establish an initial position under $122/share.
Categories: BetterInvesting® | Comments (0) | PermalinkIBP Stock Study (3-20-23)
Posted by Mark on April 24, 2023 at 07:05 | Last modified: April 10, 2023 12:13I recently did a stock study on Installed Building Products, Inc. (IBP) with a closing price of $103.72.
CFRA writes:
> Installed Building Products, Inc., together with its subsidiaries,
> engages in the installation of insulation, waterproofing, fire-
> stopping, fireproofing, garage doors, rain gutters, window blinds,
> shower doors, closet shelving and mirrors, and other products in
> the continental United States. The company offers a range of
> insulation materials, such as fiberglass and cellulose, and spray
> foam insulation materials. It is also involved in the installation
> of insulation and sealant materials in various areas of a structure,
> which includes basement and crawl space, building envelope, attic,
> and acoustical applications. In addition, the company installs a
> range of caulk and sealant products that control air infiltration
> in residential and commercial buildings; and waterproofing options,
> including sheet and hot applied waterproofing membranes, as well
> as deck coating, bentonite, and air and vapor systems. It serves
> homebuilders, multi-family and commercial construction firms,
> individual homeowners, and repair and remodeling contractors.
This medium-sized company has grown sales and earnings at annualized rates of 21.5% and 35.0% since 2012 and 2016 (earlier years with fractional EPS excluded to avoid artificial inflation of the the growth rate), respectively. Lines are mostly up, straight, and parallel except for the accelerated EPS growth in ’22. Over the last 10 years, PTPM has increased from 2.5% (’13) to 11.4% (’22) with a last-5-year average of 7.7%. This trails peer and industry averages.
Since ’15, ROE has led peer and industry averages, ranging from 21% (’17) to 48.4% (’22) with a last-5-year average of 33%. Debt-to-Capital has averaged 68.8% over the last five years, which is much higher than peer and industry averages. Interest Coverage is 8 and Quick Ratio is 1.91. Value Line gives IBP a B+ for Financial Strength.
I forecast 3% long-term annualized sales growth based on the following:
- CNN Business projects contraction of 3.7% YOY and 1.9% for ’23 and ’22-’24, respectively (based on 10 analysts).
- YF projects YOY 14.4% growth and 0.5% contraction for ’23 and ’24, respectively (10 analysts).
- Zacks projects YOY 0.8% contraction and 1.2% growth for ’23 and ’24, respectively (4).
- Value Line projects 3.6% annualized growth from ’21-’27.
- CFRA projects 3.6% YOY contraction and 1.6% contraction per year for ’23 and ’22-’24, respectively (10).
- M* projects 6% contraction per year for the next two years.
>
With contraction projected for ’23[-’24], I am forecasting below the one long-term estimate available.
I forecast 6% long-term annualized EPS growth based on the following:
- CNN Business projects contraction of 10.9% YOY and 5.3% per year for ’23 and ’22-’24, respectively (based on 10 analysts) along with 5-year annualized growth of 22.1%.
- MarketWatch projects annualized 3.8% contraction and 3.5% growth for ’22-’24 and ’22-’25, respectively (10 analysts).
- Nasdaq.com projects 5.2% YOY contraction for ’24 (4).
- YF projects YOY 8.9% contraction and 0.5% growth for ’23 and ’24, respectively (9), along with 5-year annualized growth of 13.5%.
- Zacks projects YOY contraction of 5.7% and 5.1% growth for ’23 and ’24, respectively (4).
- Value Line projects annualized growth of 6% from ’21-’27.
- CFRA projects 3.5% YOY growth and 1.8% growth per year for ’23 and ’22-’24, respectively (11).
>
I am forecasting at the bottom of the long-term-estimate range (mean of three: 13.9%).
However, because EPS spiked 93% to $7.74/share in ’22, I do not feel comfortable projecting from the accelerated value. Projecting out six years from the ’21 EPS of $4.01/share results in $5.68/share, which is effectively -6% per year from the ’22 value projected out five years. This seems more reasonable to me.
Given that High (Low) Stock Price Forecast is a best- (worst-) case scenario, what to do with my conservatively-determined 6% forecast? One usually assumes growth and the other no growth.
As a conservative compromise, I will use EPS of $5.68 and $7.74 to determine the Low and High Stock Price Forecast. Compared to ’22, the former is effectively using negative growth while the latter is using zero growth. I am open to feedback from others regarding this approach.
My Forecast High P/E is 33. Since ’15, high P/E has ranged from 33.5 (’19) to 44.7 (’18) excluding the upside outlier of 61.1 in ’17. The last-5-year average is 42.4. I am forecasting below the range.
My Forecast Low P/E is 10. Since ’15, low P/E has ranged from 8.9 (’20) to 30.7 (’17) with a last-5-year average of 19.1. The former may be a downside outlier as the next-lowest value is 14.4 (’16 and ’19). I am forecasting toward the bottom of the range (only the ’20 value is lower).
My Low Stock Price Forecast (LSPF) is $56.80, which is 10 * $5.68/share. This is 45.2% less than the previous close and 18.3% less than the 52-week low: a print not seen since ’20.
The stock has paid a dividend since ’21. In two years, Payout Ratio has been 29.9% and 16.3%. I am forecasting low at 10%.
These inputs land IBP in the BUY zone with an U/D ratio of 3.2. Total Annualized Return is 20.1%.
PAR (using Forecast Average, not High, P/E) is 10.4%, which is a bit lower than I prefer. I feel like I have built a substantial margin of safety (MOS) into this study, though.
In an attempt to verify that, I look to Member Sentiment (MS) averages of 146 studies (mine excluded) done in the last 90 days. Forecast High P/E and Forecast Low P/E are 28.7 and 15.5, respectively. Value Line projects an average annual P/E of 17.5, which is much lower than MS (22.1) and me (21.5). No consensus MOS there.
For projected sales and EPS growth, MS averages 11.6% and 12.5%, respectively. This is much higher than my forecasts, but I don’t regard this as meaningful because I project from different starting points. MS average high EPS and low EPS are $13.03 and $5.77, respectively. The former is much higher than my $7.74 along with Value Line’s projected EPS of $10.95. The latter is very close to my $5.68. I do see substantial MOS here.
Overall, perhaps I have some MOS backing this study albeit not as much as I thought.
MS also projects a higher Payout Ratio (17.7%) than me along with a much higher Low Stock Price Forecast ($79.83). Using the latter would easily put the stock in the BUY zone. As is, it’s just near the threshold.
Nonlinear historical EPS growth along with sparse long-term analyst estimates make for a very challenging stock study!
Categories: BetterInvesting® | Comments (0) | PermalinkVZ Stock Study (4-6-23)
Posted by Mark on April 20, 2023 at 06:49 | Last modified: April 6, 2023 10:42I recently did a stock study on Verizon Communications Inc. (VZ) with a closing price of $39.46.
CFRA writes:
> VZ provides communication, information, and entertainment
> products and services to consumers, businesses, and
> government entities. VZ has two reportable segments that
> it operates and manages as strategic business units;
> Verizon Consumer Group (71% of consolidated revenue in
> 2021) and Verizon Business Group (23%).
Despite the popularity and brand recognition, where’s the love for Verizon?
For starters, this mega-sized (> $50B revenue per year) company has grown sales and EPS at annualized rates of 0.9% and 5.0%, respectively, over the last 10 years. Sales is flat with dips in ’16, ’17, and ’20. EPS is up and down every other year since ’14. I really don’t think this company gets past the barbed wire fence (visual inspection).
Nevertheless [in the spirit of MMM], I will proceed to see how this pans out.
PTPM is better than peer and industry averages ranging from 18%-22% since ’15 with a last-5-year average of 18.7%.
ROE—over 24% for the last decade with a last-5-year average of 28.4%—is also better than peer and industry averages.
Debt-to-Capital is uncomfortably high and worse than peer and industry averages. The last-5-year average is 67.9% and although the 0.54 Quick Ratio may raise a red flag, Interest Coverage is 8.8. Value Line gives an A++ rating for Financial Strength. M* gives a Standard rating for Capital Allocation and writes, “VZ’s balance sheet is… reasonably solid… with net debt at 2.8 times EBITDA… roughly comparable to its major wireless rivals and major fixed-line competitor CMCSA.”
I forecast flat long-term annualized sales growth based on the following:
- CNN Business projects 0.4% YOY and 0.8% per year for ’23 and ’22-’24 (based on 21 analysts).
- YF projects YOY 0.4% and 1.1% for ’23 and ’24, respectively (23 analysts).
- Zacks projects YOY 0.6% and 1.2% for ’23 and ’24, respectively (8).
- Value Line projects 1.4% annualized growth from ’22-’27.
- CFRA projects 0.5% YOY and 1% per year for ’23 and ’22-’24, respectively.
- M* gives a 2-year ACE of 0.7% annualized growth.
>
I am forecasting just below the entire range.
I forecast flat long-term annualized EPS growth based on the following:
- CNN Business projects contraction of 9.3% YOY and 4.5% per year for ’23 and ’22-’24, respectively (based on 21 analysts), along with 5-year annualized growth of 1%.
- MarketWatch projects annualized contraction of 4.5% and 2.4% for ’22-’24 and ’22-’25 (27 analysts).
- Nasdaq.com projects growth of 4.9% YOY and 4.1% per year for ’24 and ’23-’25, respectively (10, 4, and 2 analysts for ’23, ’24, and ’25).
- Seeking Alpha projects 4-year annualized contraction of 0.2%.
- YF projects YOY 9.3% contraction and 0.4% growth for ’23 and ’24, respectively (21), along with 5-year annualized growth of 0.1%.
- Zacks projects YOY 9.5% contraction and 2.1% growth for ’23 and ’24, respectively (10), along with 5-year annualized growth of 4.2%.
- Value Line projects 2.5% annualized growth from ’22-’27.
- CFRA projects contraction of 9.5% YOY and 3.8% per year for ’23 and ’22-’24.
- M* projects long-term annualized growth of 1.2%.
>
I am forecasting toward the bottom of the long-term-estimate range (mean of six: 1.5%).
My Forecast High P/E is 10. Over the last 10 years, high P/E has generally trended down with a range from 7.4 in ’17 to 22.2 in ’14 and a last-5-year average of 13.3. I am forecasting toward the bottom of the range (only ’17 is lower).
My Forecast Low P/E is 6. Over the last 10 years, low P/E has generally trended down with a range from 5.8 in ’17 to 18.6 in ’14 and a last-5-year average of 10.2. I am forecasting toward the bottom of the range (only ’17 is lower).
My Low Stock Price Forecast (LSPF) is the default value of $30.40. This is 23% less than the previous closing price and 7.3% less than the 52-week low.
Over the last 10 years, Payout Ratio has ranged from 31.7% in ’17 to 89.3% in ’14 and a last-5-year average of 54.5%. I am forecasting below the entire range at 31%.
These inputs land VZ in the HOLD zone with an U/D ratio of 1.1. The Total Annualized Return (TAR) is 7.9%.
PAR (using Forecast Average—not High—P/E) is less than I seek for a large-sized company at 4.1%. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on TAR instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 217 studies done in the past 90 days (my study along with 81 outliers excluded), averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 1.6%, 2.0%, 13.0, 9.7, and 54.5%. I am lower across the board. Value Line projects a future average annual P/E of 17.5, which is much higher than MS (11.4) and me (8.0). I usually forecast P/E compression, but as a mature company that may not happen. The result is a higher MOS.
With regard to other data, MS high and low EPS are $5.59 and $4.85 compared to my $5.06. MS has a LSPF of $34.50, which is 13.5% above mine. Per usual, this is lower than MS default $4.85 * 9.7 = $47.04 [curiously, this would be INVALID].
The Current Yield of 6.4% is a boon for dividend investors and would be even higher with the stock under $35/share. This is where I would look to enter given the MOS behind the study.
Categories: BetterInvesting® | Comments (0) | PermalinkTSM Stock Study (4-5-23)
Posted by Mark on April 18, 2023 at 06:36 | Last modified: April 5, 2023 10:43I recently did a stock study on Taiwan Semiconductor Manufacturing Co. Ltd. ADR (TSM) with a closing price of $92.17.
M* writes:
> Taiwan Semiconductor Manufacturing Co. is the world’s largest
> dedicated chip foundry, with over 57% market share in 2021 per
> Gartner. TSMC was founded in 1987 as a joint venture of Philips,
> the government of Taiwan, and private investors. It went public
> as an ADR in the U.S. in 1997. TSMC’s scale and high-quality
> technology allow the firm to generate solid operating margins,
> even in the highly competitive foundry business. Furthermore,
> the shift to the fabless business model has created tailwinds
> for TSMC. The foundry leader has an illustrious customer base,
> including Apple, AMD, and Nvidia, that looks to apply
> cutting-edge process technologies to its semiconductor designs.
Over the last decade, this mega-sized (> $50B revenue per year) company has grown sales and EPS at annualized rates of 13.5% and 16.5%, respectively. Lines are up, straight, and parallel except for an EPS dip in ’19. PTPM is greater than peer and industry averages. It increased from 36.2% in ’13 to 50.5% in ’22 with a last-5-year average of 42.2%.
ROE was greater than peer and industry averages from ’13-’17 before falling behind in ’18 and beyond. A spike in ’22 to 38.3% boosts the last-5-year average to 27.7%. The lowest ROE in the last 10 years was 21.6% in ’19. Debt-to-Capital has been lower than peer and industry averages. This trended down from 21.4% in ’13 to 9.4% before reversing higher to 23.2% in ’22. The last-5-year average is 17.3%. Interest Coverage is over 90 and Quick Ratio is 2.2. M* gives an Exemplary rating for Capital Allocation and Value Line gives an A++ rating for Financial Strength.
M* also assigns a Wide [stable] economic moat to TSM.
I forecast long-term annualized sales growth of 6% based on the following:
- CNN Business projects 1.5% YOY and 10.4% per year for ’23 and ’22-’24 (based on 6 analysts).
- YF projects YOY 1.2% contraction and 22% growth for ’23 and ’24, respectively (8 analysts).
- Zacks projects YOY growth of 3.4% and 14.2% growth for ’23 and ’24, respectively (1).
- Value Line projects 6.7% annualized growth from ’22-’27.
- CFRA projects growth of zero YOY and 10.9% per year for ’23 and ’22-’24, respectively.
- M* gives 2-year ACE of 7.1% annualized growth along with its analyst forecast of 9.7% annualized for the next 5 years.
>
I am forecasting below both long-term estimates.
I forecast long-term annualized EPS growth of 8% based on the following:
- CNN Business projects contraction of 14.6% YOY and 2.3% growth per year for ’23 and ’22-’24, respectively (based on 6 analysts), along with 5-year annualized growth of 10.9%.
- MarketWatch projects annualized growth of 3.2% and 7.3% for ’22-’24 and ’22-’25, respectively (38 analysts).
- Nasdaq.com projects 17.4% YOY growth for ’24 (2).
- Seeking Alpha projects 4-year annualized growth of 20.6%.
- YF projects YOY 16.2% contraction and 25.3% growth for ’23 and ’24, respectively (5), along with 5-year annualized growth of 21.5%.
- Zacks projects YOY 15.2% contraction and 17.4% growth for ’23 and ’24, respectively (2), along with 5-year annualized growth of 20.5%.
- Value Line projects 8.8% annualized growth from ’22-’27.
- CFRA projects 15.4% YOY contraction and 4.7% growth per year for ’23 and ’22-’24 along with a 3-year CAGR of 7%.
- M* projects long-term annualized growth of 5%.
>
Actual EPS spiked over 60% YOY in ’22.
I am forecasting toward the bottom of the long-term-estimate range (mean of six: 14.6%).
My Forecast High P/E is 14. Over the last 10 years, high P/E has ranged from 14.1 (’15) to 34.8 (’21) with a last-5-year average of 27.3. I am forecasting below the entire range.
My Forecast Low P/E is 9. Excluding the upside outlier in ’21 (26.3), over the last 10 years low P/E has ranged from 9.0 (’22) to 15.5 (19) with a last-5-year average of 13.1. I am forecasting at the bottom of the range.
My Low Stock Price Forecast (LSPF) is the default value of $59.90. This is 36% less than the previous closing price and just a hair under the 52-week low ($59.40).
Over the last 10 years, Payout Ratio has ranged from 27.9% (’22) to 58.8% (’18) with outliers from ’15 (0%) and ’19 (90.6%) excluded. The last-5-year average (excluding ’19) is 45.9%. I am forecasting below the entire range at 27%.
These inputs land TSM in the HOLD zone with an U/D ratio of 1.3. The Total Annualized Return (TAR) is 9.9%.
PAR (using Forecast Average—not High—P/E) is less than I seek for a large-sized company at 6.2%. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on total annualized return (9.9%) instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 424 studies done in the past 90 days (my outlier study along with 127 others excluded), averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 10.6%, 9.8%, 23.0, 14.1, and 54.8%. I am lower across the board especially with regard to P/E. Value Line projects a future average annual P/E of 18.0: lower than MS 18.6 and much higher than my 11.5.
With regard to other data, MS high and low EPS are $9.52 and $5.86 compared to my $9.67 and $6.56. My numbers may be higher due to growth in the recent quarter, but I’m surprised my high EPS is not lower due to a lower forecast growth rate. MS has a LSPF of $64.50, which is 9.3% higher than mine. This doesn’t align with the MS default $5.86 * 14.1 = $82.63, but is still quite reasonable being 30% less than the previous close.
The robust MOS backing this study may actually be too much. My forecast P/E range is over 6 points lower than Value Line or MS. Raising Forecast High and/or Low P/E up to 12 points total could put TSM in the BUY zone. In looking at the 10-year P/E ranges, however, nothing jumps out at me to say “this forecast is unreasonably low.”
For now, I remain steadfast and will look to buy under $78/share.
Categories: BetterInvesting® | Comments (0) | Permalink