MNST Stock Study (4-11-23)
Posted by Mark on April 15, 2023 at 06:46 | Last modified: May 5, 2023 10:17I recently did a stock study on Monster Beverage Corp. (MNST) with a closing price of $52.35.
M* writes:
> Monster Beverage is a leader in the energy drink subsegment
> of the beverage industry. The Monster trademark anchors the
> portfolio, and notable offerings include Monster Energy and
> Monster Ultra. The firm has also started to incubate new
> trademarks for emerging enclaves of the energy space, like
> Reign in performance energy. It is primarily a brand owner,
> outsourcing most of its manufacturing to third-party
> copackers. It primarily uses the Coca-Cola bottling system
> for distribution after a strategic agreement through which
> Coke became Monster’s largest shareholder (nearly 20%).
> Most of Monster’s revenue is generated in the United States.
Over the last 10 years, this medium-size company has grown sales and EPS at annualized rates of 12.0% and 16.5%, respectively. Lines are mostly up, straight, and parallel except for EPS declines in ’21 and ’22, which is worthy of further investigation. Although higher than peer and industry averages, PTPM traces an “inverse-U” pattern over the last 10 years going from 25.1% in ’13 up to 35.7% in ’17 and back down to 24.9% in ’22 with a last-5-year average of 32.1%.
ROE has generally been less than industry averages while about even with peers over the last decade, decreasing from 33.9% in ’13 to 17.1% in ’22 with a last-5-year average of 24.0%.
The company has zero long-term debt, which makes its Debt-to-Capital (0%) much lower than peer and industry averages. M* gives the company a Standard rating for Capital Allocation while Value Line awards an A+ grade for Financial Strength. Quick Ratio is an impressive 3.68.
I forecast long-term annualized sales growth of 7% based on the following:
- CNN Business projects 12.7% YOY and 12.0% per year for ’23 and ’22-’24 (based on 19 analysts).
- YF projects YOY 12.8% and 10.5% for ’23 and ’24, respectively (18 analysts).
- Zacks projects YOY 12.2% and 10.6% for ’23 and ’24, respectively (8).
- Value Line projects 5.5% annualized growth from ’22-’27.
- CFRA projects 12.7% YOY and 11.5% per year for ’23 and ’22-’24, respectively.
- M* gives a 2-year ACE of 12.3% annualized growth while projecting 10% for the next five years in its analyst note.
>
I am forecasting in between the two longer-term estimates.
I forecast long-term annualized EPS growth of 12% based on the following:
- CNN Business projects 35.1% YOY and 25.9% per year for ’23 and ’22-’24, respectively (based on 19 analysts), along with 5-year annualized growth of 15.1%.
- MarketWatch projects annualized growth of 23.7% and 20.5% for ’22-’24 and ’22-’25 (23 analysts).
- Nasdaq.com projects 19.9% per year for both ’23-’25 and ’23-’26 [10, 4, and 1 analyst(s) for ’23, ’25, and ’26].
- Seeking Alpha projects 4-year annualized growth of 18.3%.
- YF projects YOY 34.2% and 17.4% for ’23 and ’24, respectively (21), along with 5-year annualized growth of 24.9%.
- Zacks projects YOY 26.8% and 17.6% for ’23 and ’24, respectively (10), along with 5-year annualized growth of 22.1%.
- Value Line projects 14.2% annualized growth from ’22-’27.
- CFRA projects 27.8% YOY, 22.6%, and 9% per year for ’23, ’22-’24, and 3-year estimated CAGR, respectively.
- M* projects long-term annualized growth of 12.5%.
>
I am forecasting below the entire range of long-term estimates (mean of six: 17.9%).
My Forecast High P/E is 33. Over the last 10 years, high P/E has been up, down, and up with a range of 32.7 (’19) to 56.6 (’15) and a last-5-year average of 38.7. I am forecasting near the bottom of the range (only ’19 is lower).
My Forecast Low P/E is 23. Over the last 10 years, low P/E has been up, down, and up with a range of 19.0 (’20) to 37.6 (’15) and a last-5-year average of 26.7. I am forecasting near the bottom of the range [only ’20 and ’14 (22.7) are lower].
My Low Stock Price Forecast (LSPF) is the default value of $25.50. This is 51.3% less than the previous closing price and 36.4% less than the 52-week low. The 2020 low is around $26.00, which almost makes my forecast look unreasonably extreme but from a valuation perspective (historical P/E ranges) it is not.
These inputs land MNST in the HOLD zone with an U/D ratio of 0.5. The Total Annualized Return (TAR) is 4.6%.
PAR (using Forecast Average—not High—P/E) is far less than T-bills at 1.2%. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on total annualized return (4.6%) but even that right now is much lower than I seek.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 379 studies done in the past 90 days (my study along with 63 outliers excluded), averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, and Forecast Low P/E, are 10.0%, 11.0%, 35.0, and 25.8. I am higher on EPS growth and lower on the other three inputs. Value Line projects a future average annual P/E of 30.0, which is lower than MS (30.4) and higher than mine (28). Overall, some MOS appears to back this study.
With regard to other data, MS high and low EPS are $3.11/share and $2.09/share compared to my $1.97 and $1.11. The $2.09, which is almost double TTM value, seems to be the result of a 2:1 stock split executed on 3/28/23. From MS raw data (outliers not removed), 260 studies are dated before 3/28/23 with a mean high EPS of $3.92/share while 182 studies are dated after 3/27/23 with a mean high EPS of $1.97/share. Also suspect is the MS Low Stock Price Forecast (LSPF) of $52.70, which is about double my LSPF and near the previous close. The same two groups of studies just defined with dates before and after the stock split have mean LSPFs of $58.67 and $44.99, respectively: a statistically significant difference [Student’s t(297) ~ 9.3, p < 0.001] albeit far less than 2x apart. >
I would look to re-evaluate MNST under $35/share.
Categories: BetterInvesting® | Comments (0) | PermalinkMMM Stock Study (4-4-23)
Posted by Mark on April 14, 2023 at 07:13 | Last modified: April 4, 2023 12:22I recently did a stock study on 3M Co. (MMM) with a closing price of $104.57.
Value Line writes:
> 3M Company is a diversified manufacturer and technology
> company with operations in more than 70 countries. It is
> among the leading manufacturers in many of the markets it
> serves. The conglomerate currently operates four business
> segments: Safety and Industrial (33.9% of ’22 sales);
> Transportation and Electronics (26.0%); Health Care
> (24.6%); Consumer (15.5%). Research & Development:
> $1.9 billion or 5.4% of ’22 sales.
Over the last decade, this large-sized company has grown sales and EPS at annualized rates of 1.3% and 4.2%, respectively. Lines are somewhat up, but hardly straight or parallel (sales declines in ’15, ’16, ’19, and ’22; EPS declines in ’17 and ’19). Stock price is at a 10-year low. Per visual inspection, this is not a high-quality growth stock.
PTPM is greater than peer and industry averages. It increased from 21.3% in ’13 to 23.8% in ’17 before reversing to 18.7% in ’22. The last-5-year average is 19.8%.
ROE is greater than peer and industry averages. It increased from 25.1% in ’13 to 40% in ’22 with a last-5-year average of 43.4%. Unfortunately, Debt-to-Capital is also greater than peer and industry averages. This has trended higher over the last 10 years and has a last-5-year average of 59.4%. Interest Coverage is 14 and Quick Ratio is 0.9. M* gives a Standard rating for Capital Allocation and Value Line gives an A rating for Financial Strength.
MMM faces risk due to PFAS (environmental) and Combat Arms (military earplugs) litigation. M* assumes total liability of $18B. Value Line estimates liability at $1.00/share but wonders whether this is enough.
Although M* assigns a wide/stable economic moat to the company, CFRA seems to disagree:
> …most 3M products are commodity-like, such as roofing granules
> or adhesives. Commodity-like products with intense competition
> have little pricing power, making it difficult to improve
> margins over the long term. 3M does enjoy brand power on
> certain products, but not enough to drive overall pricing
> growth that can keep up with inflation.”
I forecast long-term annualized sales growth of 1% based on the following:
- CNN Business projects contraction of 7% YOY and 2.1% per year for ’23 and ’22-’24 (based on 17 analysts).
- YF projects YOY 6.8% contraction and 3.3% growth for ’23 and ’24, respectively (19 analysts).
- Zacks projects YOY 6.9% contraction and 1.8% growth for ’23 and ’24, respectively (4).
- Value Line projects 3.2% annualized growth from ’22-’27.
- CFRA projects 2.9% YOY contraction and zero growth per year for ’23 and ’22-’24, respectively.
- M* gives a 2-year ACE of 1.8% contraction per year along with its own analyst forecast of 2% annualized growth over the next 5 years.
>
I am forecasting below both long-term estimates.
I forecast long-term annualized EPS growth of 0% based on the following:
- CNN Business projects contraction of 14.4% YOY and 2.7% per year for ’23 and ’22-’24, respectively (based on 17 analysts), along with 5-year annualized contraction of 0.5%.
- MarketWatch projects annualized contraction of 3% and 0% for ’22-’24 and ’22-’25, respectively (21 analysts).
- Nasdaq.com projects 6.7% YOY growth and 6.3% annualized growth for ’24 and ’23-’25 (6, 5, and 3 analysts for ’23, ’24, and ’25, respectively).
- Seeking Alpha projects 4-year annualized contraction of 1.3%.
- YF projects YOY 14.5% contraction and 10.1% growth for ’23 and ’24, respectively (20), along with 5-year annualized growth of 0.1%.
- Zacks projects YOY 14.4% contraction and 6.7% growth for ’23 and ’24, respectively (5), along with 5-year annualized growth of 9.5%.
- Value Line projects 4.2% annualized growth from ’22-’27.
- CFRA projects contraction of 17.3% YOY and 4.6% per year for ’23 and ’22-’24.
- M* projects long-term annualized growth of 3%.
>
The mean of six long-term estimates is 2.5% growth per year. I am forecasting toward the bottom of the range.
My Forecast High P/E is 18. Over the last 10 years, high P/E has ranged from 17.9 (’22) to 30.8 (’17) with a last-5-year average of 23.1. I am forecasting near the bottom of the range (only ’22 is lower).
My Forecast Low P/E is 9. Over the last 10 years, low P/E has ranged from 10.5 (’17) to 21.9 (’22) with a last-5-year average of 15.6. I am forecasting below the entire range.
My Low Stock Price Forecast (LSPF) is $83.30. Given a 0% EPS growth rate, I am using ’20 EPS of $9.25/share (rather than $10.18 from ’22). This is 20.3% less than the previous closing price and 16.9% less than the 52-week low.
Over the last 10 years, Payout Ratio has increased from 37.8% in ’13 to 58.5% in ’22 with a last-5-year average of 63.1%. I am forecasting below the entire range at 37%.
These inputs land MMM in the BUY zone with an U/D ratio of 3.7. The Total Annualized Return (TAR) is 13.9%.
PAR (using Forecast Average—not High—P/E) is less than I seek for a large-sized company at 8.4%. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on total annualized return (13.9%) instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 158 studies done in the past 90 days (67 outlier studies and my own 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 2.6%, 4.0%, 20.0, 15.3, and 60%. I am significantly lower across the board. Value Line projects a future average annual P/E of 16.0: lower than MS 18.1 and higher than my 13.5.
With regard to other data, MS high and low EPS are $12.37 and $9.71 compared to my $10.18 and $9.25. MS has a LSPF of $107.10, which is higher than the last closing price. MMM is down ~15% over the last 2-3 months, which hopefully explains this. Per usual, this does not align with the default LSPF of 15.3 * $9.71 = $148.56.
The litigation risk offsets what I perceive to be a robust MOS in this study. While MMM is a BUY under $108/share, maybe I knock another 5-10% off and look to buy under $102 or $97 in case the legal tab ends up higher than anticipated.
Categories: BetterInvesting® | Comments (0) | PermalinkAVT Stock Study (4-3-23)
Posted by Mark on April 12, 2023 at 07:09 | Last modified: April 3, 2023 14:20I recently did a stock study on Avnet Inc. (AVT) with a closing price of $45.20.
Value Line writes:
> Avnet, Inc. is a technology solutions company that markets,
> sells, and distributes electronic components. The company
> has two segments: Electronic Components (93% of ’22 sales),
> which sells electr. components, semiconductors,
> interconnect, passive and electromechanical components to
> the world’s leading electronic component manufacturers;
> Farnell (7%) sells kits, tools, test measurement, and
> electronic components to customers that are developing and
> testing their products. Acquired Premier Farnell, ’16.
Excluding ’18 and ’20, this large-sized company has posted annualized sales and EPS declines of 2.9% and 1% over the last 10 years. The company recorded goodwill impairment of ~$181M in ’18. COVID-19 shocked the world economy in ’20, which led to widespread losses. Even without these two years, lines are nowhere close to up, straight, and parallel.
For me, the analysis would end now as the company does not clear the barbed wire fence. However, I was introduced to Avnet by the recent Manifest Investing Roundtable in what was a rather attractive presentation. I will press on to see if “there’s gold in them thar hills” in the form of a potential non-core position.
PTPM decreased from 2.2% in ’13 to 0.9% in ’21 before rebounding to 3.4% in ’22. This trails peer and industry averages.
ROE fell below 10% in ’17 and remained there until ’22 when it spiked to 15.9%. The last-5-year average is 4.2% (including negative numbers for ’18 and ’20). This is disappointingly low and trails peer/industry averages.
As some potential bright spots, Debt-to-Capital has been lower than peer and industry averages with a last-5-year mean of 29%. Interest Coverage is 7.5, Quick Ratio is 1.26, and Value Line gives an A rating for Financial Strength.
I forecast long-term annualized sales growth of 2% based on the following:
- CNN Business projects 6.2% YOY growth and 2.3% contraction per year for ’23 and ’22-’24 (based on 7 analysts).
- YF projects YOY 5.9% growth and 10% contraction for ’23 and ’24, respectively (7 analysts).
- Zacks projects YOY 5.2% growth and 9.8% contraction for ’23 and ’24, respectively (5).
- Value Line projects 5.3% annualized growth from ’22-’27.
- CFRA projects 5.5% YOY growth and 2.2% contraction per year for ’23 and ’22-’24, respectively.
>
I am discounting the one long-term estimate to get my forecast.
I forecast long-term annualized EPS growth of 1% based on the following:
- CNN Business projects 4.8% YOY and 11.2% per year contraction for ’23 and ’22-’24, respectively (based on 7 analysts), along with 5-year annualized contraction of 1%.
- MarketWatch projects annualized contraction of 10.7% and 1.9% per year for ’22-’24 and ’22-’25 (8 analysts).
- Nasdaq.com projects 21.4% YOY contraction and 2.7% annualized growth for ’24 and ’23-’25 (6, 6, and 2 analysts for ’23, ’24, and ’25, respectively).
- Seeking Alpha projects 4-year annualized contraction of 1%.
- YF projects YOY 4.8% growth and 24.7% contraction for ’23 and ’24, respectively (7), along with 5-year annualized growth of 10.4%.
- Zacks projects YOY 3.9% growth and 21.4% contraction for ’23 and ’24, respectively (6).
- Value Line projects 9.3% annualized growth from ’22-’27.
- CFRA projects contraction of 4.3% YOY and 7% per year for ’23 and ’22-’24, along with a 3-year projected CAGR of 2%.
>
Of four long-term estimates, two are negative. I am forecasting toward the lower end of the range (mean 4.4%)
My Forecast High P/E is 8. Over the last 10 years, high P/E has ranged from 7.2 (’22) to 30.3 (’19) with a last-5-year average (excluding NMF in ’18 and ’20) of 20.4. I am forecasting near the bottom of the range (only ’22 is lower).
My Forecast Low P/E is 4. Over the last 10 years, low P/E has ranged from 5.1 (’22) to 20.6 (’19) with a last-5-year average (excluding NMF in ’18 and ’20) of 12.8. I am forecasting below the entire range.
My Low Stock Price Forecast is the default value of $35.60. This is 21.2% less than the previous closing price and right near the 52-week low of $35.50.
Since 2014 (and excluding NMF in ’18 and ’20), Payout Ratio has ranged from 14.4% (’22) to 49.1% (’19) with a last-5-year average of 35.8%. I am forecasting below the entire range at 14%.
These inputs land AVT in the BUY zone with an U/D ratio of 3.1. The Total Annualized Return (TAR) is 12.4%.
PAR (using Forecast Average–not High–P/E) is less than I seek at 6.8%. 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 42 studies done in the past 90 days (seven outlier studies and my own excluded), averages for projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 6.1%, 5.8%, 13.4, 9.2, and 33.7%. I am lower across the board. Value Line projects a future average annual P/E of 11 compared to MS 11.3. I am much lower at 6.
With regard to other data, MS high and low EPS are $13.40 and $7.62 compared to my $9.36 and $8.91. My low EPS may be greater than MS due the latest quarter(s) of growth and my high EPS is less due to a lower forecast growth rate. MS has a Low Stock Price Forecast of $30.10, which is 15.4% less than than mine. This does not align with the default value of 9.2 * $7.62 = $70.62 [which would be invalid]. I would argue that willingness to entertain a particular low price entails acceptance of the corresponding P/E as the lower end of the P/E range. This suggests certain studies should lower their Forecast Low P/E.
A robust MOS underlies this study, and indeed there may be “gold in them thar hills!” Given the historically inconsistent track record of sales and earnings, I would either demand a higher projected return or establish a smaller position size. I will look to buy under $41/share.
Categories: BetterInvesting® | Comments (0) | PermalinkTD Stock Study (3-30-23)
Posted by Mark on April 10, 2023 at 06:29 | Last modified: March 30, 2023 15:16I recently did a stock study on Toronto-Dominion Bank (TD) with a closing price of $59.22 (NYSE).
Value Line writes:
> Toronto-Dominion Bank, one of Canada’s biggest by assets, has
> branches in Canada, the U.S., and other countries. It serves
> over 27 million customers worldwide in four key units: Canadian
> Personal and Commercial Banking including TD Canada Trust and
> TD Auto Finance Canada; U.S. Retail including TD Bank and TD
> Wealth (U.S.); Wealth Management and Insurance including TD
> Wealth (Canada) and TD Direct Investing; and Wholesale Banking.
This large-sized company has grown sales and EPS at annualized rates of 6% and 14.8%, respectively, over the last decade. Lines are generally up, straight, and parallel except for a sales dip in ’21. PTPM has closely tracked peer and industry averages generally trending higher from 28% in ’13 to 44.6% in ’22 with a last-5-year average of 36.2%.
Over the last 10 years, ROE has been higher than peer and industry averages going from 7.2% in ’13 to 24.6% in ’22 with a last-5-year average of 20%. Debt-to-Capital over the decade has been greater than peer and industry averages with a last-5-year average of 75.1%. While uncomfortably high, perhaps, Value Line gives an A rating for Financial Strength while M* gives an Exemplary rating for Capital Allocation (along with a Wide economic moat rating).
Return on Average Assets has a last-5-year average of 0.84%. An outstanding number to look for is 1.5% or more over several years. If I remember correctly from a Ross Meredith presentation, though, ROAA isn’t as relevant for large banks (versus smaller regional/community banks) because business segments are diversified rather than dominated by loans.
I forecast long-term annualized sales growth of 5% based on the following:
- CNN Business projects 9.3% YOY and 10.4% per year for ’23 and ’22-’24, respectively (based on 2 analysts).
- YF projects YOY 10.2% and 12% for ’23 and ’24, respectively (4 analysts).
- Zacks projects YOY 7.5% contraction and 12.3% growth for ’23 and ’24, respectively (3).
- Value Line projects 4.3% annualized growth [total assets] from ’22-’26.
- CFRA projects 6.4% YOY growth and 7.5% growth per year for ’23 and ’22-’24, respectively.
- M* offers a 2-year ACE of 10.9% annualized growth.
>
Without any long-term estimates (Value Line separates loans from total assets but not report “sales” or “revenue”), I am forecasting to the low side.
I forecast long-term annualized EPS growth of 6% based on the following:
- CNN Business projects 4.2% YOY and 9% per year for ’23 and ’22-’24, respectively (based on 2 analysts), along with 5-year annualized growth of 9.1%.
- MarketWatch projects 14.3% YOY and 18% per year for ’23 and ’22-’24, respectively (6 analysts).
- Nasdaq.com projects 8.9% YOY growth for ’24 (5).
- Seeking Alpha projects 4-year annualized growth of 9.1%.
- YF projects YOY 3.8% and 8% for ’23 and ’24, respectively (13), along with 5-year annualized growth of 6.7%.
- Zacks projects YOY 2.2% and 8.9% for ’23 and ’24, respectively (5), along with 5-year annualized growth of 8%.
- Value Line projects 8.8% annualized growth from ’22-’26.
- CFRA projects 7.9% YOY and 6.3% per year for ’23 and ’22-’24, respectively, along with a 3-year projected CAGR of 6%.
>
I am forecasting below the range [mean of five long-term estimates: 8.3%].
My Forecast High P/E is 9. Over the last 10 years, high P/E has declined from 26.8 in ’13 to 9.1 in ’22 with a last-5-year average of 10. I am forecasting below the range.
My Forecast Low P/E is 5.5. Over the last 10 years, low P/E has ranged from 22.1 in ’13 to 5.2 in ’20 with a last-5-year average of 6.7. I am forecasting near the bottom of the range (only ’20 is lower).
My Low Stock Price Forecast is the default value of $45.40. This is 23.3% less than the previous closing price, 18.1% less than the 52-week low, and 2.9% greater than the ’21 low.
Excluding 93.8% in ’13 (upside outlier), Payout Ratio has ranged from 37.6% in ’22 to 48.4% in ’20 over the last 10 years. The last-5-year average is 43.3%. I am forecasting just below the range at 37%.
These inputs land TD in the HOLD zone with an U/D ratio of 2.9. The Total Annualized Return (TAR) is 15%.
PAR (using Forecast Average—not High—P/E) is 11.3%, which is less than I seek for a medium-size company. If a healthy margin of safety (MOS) anchors this study, then I will use TAR instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 32 studies done in the past 90 days (16 studies with outliers and my own study excluded), averages for projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 6.9%, 6.2%, 10.2, 7.2, and 43.9%. I am lower across the board. MS high and low EPS are $12.15 and $7.66 compared to my $11.05 and $8.26. My low EPS may be greater than MS due the latest quarterly earnings release, and my high EPS may be less due to a [marginally] lower forecast growth rate. MS has a Low Stock Price Forecast of $48.60, which is 7% higher than mine (not surprising since the stock has fallen recently). Once again, this does not align with the default value of 7.2 * $7.66 = $55.15. I think some studies manually override the Low Stock Price Forecast rather than lowering the Forecast Low P/E when the latter would allow for a clearer translation inside the numbers. Value Line forecasts an average annual P/E of 10.5 compared to MS 8.7 and my 7.3.
A robust MOS underlies this study, and I would be a buyer under $58/share.
Categories: BetterInvesting® | Comments (0) | PermalinkRBA Stock Study (3-30-23)
Posted by Mark on April 6, 2023 at 07:22 | Last modified: March 30, 2023 14:47I recently did a stock study on Ritchie Bros Auctioneers Inc. (RBA) with a closing price of $55.42.
M* writes:
> Ritchie Bros. operates the world’s largest marketplace for
> heavy equipment. The company started as a live auctioneer
> of industrial equipment, since then it has greatly expanded
> its operations to include the sale of construction,
> agricultural, oilfield, and transportation equipment. Ritchie
> Bros. operates over 40 live auction sites in more than 12
> countries, along with online marketplaces, including
> IronPlanet, Marketplace-E, and GovPlanet. Its agricultural
> auctions are frequently much smaller venues and can include
> liquidations of single farms. The company holds over 300
> auctions yearly and sells $6 billion worth of equipment.
This medium-sized company has grown sales and EPS at annualized rates of 18.1% and 10.7% over the last decade. Lines are generally up and parallel except for EPS declines in ’14, ’16, ’17, and ’21. PTPM has remained above peer and industry averages declining from 28.8% in ’13 to 12.7% in ’17 and rebounding to 23.4% in ’22. Last-5-year average is 16.5%.
Over the last 10 years, ROE has been relatively stable except for a spike in ’22 to 25.6%. ROE has remained mostly above peer and industry averages with a last-5-year average of 18%. Debt-to-Capital over the decade has generally been lower than the industry but higher than peer averages with a last-5-year average of 47.5%. Quick Ratio is 0.86, and Interest Coverage is 8. Value Line rates the company B++ for Financial Strength. M* gives a Standard rating for Capital Allocation, writing “the company’s low balance sheet risk is largely due to its manageable debt levels and access to credit lines.”
I forecast long-term annualized sales growth of 10% based on the following:
- CNN Business projects 94.1% YOY and 55.3% per year for ’23 and ’22-’24, respectively (based on 8 analysts).
- YF projects YOY 97.9% and 20.3% for ’23 and ’24, respectively (7 analysts).
- Zacks projects YOY 80.3% and 30.3% for ’23 and ’24, respectively (2).
- Value Line projects 11.1% annualized growth from ’21-’26.
- CFRA gives an ACE of 98% YOY and 54.3% per year for ’23 and ’22-’24, respectively (6).
- M* offers a 2-year ACE of 80.8% annualized growth.
>
The lofty growth rates over the next two years are probably due to acquisition of U.S. auto retailer IAA Inc., which completed on March 20 (see here).
I forecast long-term annualized EPS growth of 6% based on the following:
- CNN Business projects contraction of 1.7% YOY for ’23, 8.4% growth per year for ’22-’24 (based on 8 analysts), and 5-year annualized growth of 7%.
- MarketWatch projects growth of 3% YOY and 10.9% per year for ’23 and ’22-’24, respectively (8 analysts).
- Nasdaq.com projects 11.1% YOY growth for ’24 [2 and 1 analyst(s) for ’23 and ’24].
- Seeking Alpha projects 4-year annualized growth of 7%.
- YF projects YOY growth of 3.7% and 13.6% for ’23 and ’24, respectively (8), along with 7% annualized growth for the next five years.
- Zacks projects YOY growth of 4.6% and 15.1% for ’23 and ’24, respectively (3), along with 7% annualized growth for the next five years.
- Value Line projects 14.1% annualized growth from ’21-’26.
- CFRA projects contraction of 18.5% YOY and 0.9% per year for ’23 and ’22-’24, respectively (3).
>
I am not seeing any bump in estimated EPS for ’23-’24 like I did with sales.
I find it odd that four of five long-term estimates are identical. CNN Business and Seeking Alpha get data from Factset and S&P Global, respectively. YF gets data from Refinitiv, and Zacks is its own data source. Given all different sources, I would not expect duplication unless multiple sources are getting estimates from the same analysts. Even at that, this isn’t a case like others I’ve seen where the number of analysts is next to none: CNN Business, YF, and Zacks are citing 8, 8, and 3.
I am forecasting EPS growth just below the long-term range (mean of 5 estimates: 8.4%).
My Forecast High P/E is 24. Over the last 10 years, high P/E has ranged from 24.3 in ’15 to 56 in ’21 with a last-5-year average of 40. I am forecasting below the range.
My Forecast Low P/E is 15. Over the last 10 years, low P/E has ranged from 16.8 in ’20 to 37.2 in ’21 with a last-5-year average of 24.2. I could forecast below the range with 16, but the resultant Low Stock Price Forecast would only be 17.4% below the previous close [rule of thumb is 20%]. I am forecasting even lower.
My Low Stock Price Forecast is the default value of $42.90. This is 22.6% less than the previous closing price and 11.9% less than the 52-week low.
Over the last 10 years, Payout Ratio has ranged from 36.4% in ’22 to 98.6% in ’17 (possibly an upside outlier) with a last-5-year average of 55.8%. I am forecasting just below the range at 36%.
These inputs land RBA in the HOLD zone with an U/D ratio of 2.9. The Total Annualized Return (TAR) is 13%.
PAR (using Forecast Average—not High—P/E) is 9%, which is less than I seek for a medium-size company. If a healthy margin of safety (MOS) anchors this study, then I will use TAR instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on only 14 studies done (7 studies with outliers excluded) in the past 90 days, mean averages for projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 9.2%, 9.9%, 35, 23, and 61.2%. I am lower on everything except sales growth. MS high and low EPS are $3.92 and $2.09 compared to my $3.83 and $2.86. My low EPS may be greater than MS because EPS jumped 110% in ’22 and some studies use the ’21 number (with ’22 not yet completed). My high EPS is less due to a lower forecast growth rate (I’m surprised the difference isn’t larger). MS has a Low Stock Price Forecast of $36.10. This is 15.9% lower than mine although the default MS low price would be higher: 23 * $2.09 = $48.07. Value Line projects an average annual P/E of 25 compared to MS 29 and my 19.5.
A robust MOS underlies this study, and I would be a buyer under $55/share.
Categories: BetterInvesting® | Comments (0) | PermalinkLFUS Stock Study (3-29-23)
Posted by Mark on April 4, 2023 at 06:45 | Last modified: March 29, 2023 10:33I recently did a stock study on Littelfuse Inc. (LFUS) with a closing price of $257.96.
M* writes:
> Littelfuse is a primary provider of circuit protection products
> (such as fuses and relays) into the transportation, industrial,
> telecommunications, and consumer electronics end markets. The
> firm is also increasing its power semiconductor business, where
> it predominantly serves industrial end markets and is breaking
> into electric vehicle charging infrastructure.
This medium-sized company has grown sales and EPS at annualized rates of 13.6% and 13.8%, respectively, over the last decade. Lines are generally up and parallel with sales declines in ’19 and ’20 along with EPS declines in ’15, ’19, and ’20. PTPM has been cyclical over the last decade above peer and industry averages with a last-5-year average of 13.6%.
Over the last 10 years, ROE has been cyclical and above peer and industry averages with a last-5-year average of 12.3%. Debt-to-capital over the decade has generally been lower (higher) than industry (peer) averages with a last-5-year average of 30.6%. Value Line rates the company B++ for Financial Strength. M* gives a Standard rating for Capital Allocation, writing that the company has “a sound balance sheet, based on low net debt.” Quick Ratio is 1.5, and Interest Coverage is 17.9.
I forecast long-term annualized sales growth of 4% based on the following:
- CNN Business projects a 4% YOY contraction and 2% growth per year for ’23 and ’22-’24 (based on 8 analysts).
- YF projects YOY 2.5% contraction and 6.4% growth for ’23 and ’24, respectively (6 analysts).
- Zacks projects YOY 3.4% contraction and 5.9% growth for ’23 and ’24, respectively (3).
- Value Line projects 4.1% annualized growth from ’22-’27.
- CFRA gives an ACE of 2.4% YOY contraction and 2.1% growth per year for ’23 and ’22-’24, respectively (7).
- M* offers a 2-year ACE of 3.3% annualized growth along with 5.6% growth for the next five years in its analyst note.
>
I forecast long-term annualized EPS growth of 4% based on the following:
- CNN Business projects contraction of 24.7% YOY and 7.4% per year for ’23 and ’22-’24, respectively (based on 8 analysts), along with 5-year annualized growth of 12%.
- MarketWatch projects contraction of 24.4% YOY and 7.2% per year for ’23 and ’22-’24, respectively (8 analysts).
- Nasdaq.com projects 14.6% YOY growth for ’24 (4).
- Seeking Alpha projects 4-year annualized growth of 8.5%.
- YF projects YOY contraction of 24.3% and 15.7% growth for ’23 and ’24, respectively (7), along with 10.3% annualized growth for the next five years.
- Zacks projects YOY 25.6% contraction and 14.6% growth for ’23 and ’24, respectively (4), along with 12% annualized growth for the next five years.
- Value Line projects 0.6% annualized growth from ’22-’27.
- CFRA projects contraction of 14.5% YOY and 0.5% per year for ’23 and ’22-’24, respectively (7).
- M* provides long-term ACE of 9% annualized growth.
>
Value Line is a downside outlier of six long-term EPS projections. Its left-margin table says 14.5% annualized from ’20-’22 to ’26-’28, but I can’t get this from numbers in the statistical array. Per the latter, 4.7% annualized growth is projected from 2021 through 2027 (my interpretation of ’26-’28). I will use the 4.7% in place of 0.6% and forecast conservatively toward the lower end of the range (mean of long-term estimates using the 0.6% for Value Line is 9.1%).
To counter the argument that my forecast is unreasonably low, I would also point out that earnings have spiked 68.1% per year over the last two years. Whenever this happens, my gut tells me [for one reason or another] time will be needed in order to digest the hefty gains.
My Forecast High P/E is 21. High P/E went from 24.1 in ’13 to 48.5 in ’20 before heading down to 21.9 in ’22. The last-5-year average is 34.6. I am forecasting below the range.
My Forecast Low P/E is 13. Low P/E went from 15.3 in ’13 to 28.2 in ’17 before heading down to 12.9 in ’22. The last-5-year average is 20.7. I am forecasting near the bottom of the range (only ’22 is lower).
My Low Stock Price Forecast is the default value of $194.20. This is 24.7% below the previous closing price and 1% above the 52-week low.
Over the last 10 years, Payout Ratio has ranged from 15.1% in ’22 to 36.3% in ’20 with a last-5-year average of 25.2%. I am forecasting just below the range at 15%.
These inputs land LFUS in the HOLD zone with an U/D ratio of 1.9. The Total Annualized Return (TAR) is 8.9%.
PAR (using future average—not high—P/E) is 4.6%, which is less than I seek for a medium-size company. If a healthy margin of safety (MOS) anchors this study, however, then I will focus on the TAR rather than PAR.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 205 studies done in the past 90 days, averages for projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 9.3%, 9.0%, 27.0, 19.4, and 26.1%. I am much lower across the board. MS high and low EPS are $22.12 and $13.40 compared to my $18.18 and $14.94. My low EPS may be greater than MS due the latest quarterly earnings release, and my high EPS is less due to a lower forecast growth rate. MS has a Low Stock Price Forecast of $186.22, which is 4.1% lower than mine (not surprising since the stock has rallied 15% over the last three months). Value Line forecasts average annual P/E of 24 compared to MS 23.2 and my 17.
A robust MOS underlies this study, and I would be a buyer under $240/share.
Categories: BetterInvesting® | Comments (0) | PermalinkMEDP Stock Study (3-28-23)
Posted by Mark on March 31, 2023 at 07:02 | Last modified: March 28, 2023 15:15I recently did a stock study on Medpace Holdings Inc. (MEDP) with a closing price of $183.26.
CFRA writes:
> Medpace Holdings, Inc. provides clinical research-based drug and
> medical device development services in North America, Europe, and
> Asia. It offers a suite of services supporting the clinical development
> process from Phase I to Phase IV in various therapeutic areas. The
> company also provides clinical development services to the
> pharmaceutical, biotechnology, and medical device industries; and
> development plan design, coordinated central laboratory, project
> management, regulatory affairs, clinical monitoring, data management
> and analysis, pharmacovigilance new drug application submissions, and
> post-marketing clinical support services. In addition, it offers bio-
> analytical laboratory services, clinical human pharmacology, imaging
> services, and electrocardiography reading support for clinical trials.
This medium-sized company has grown sales and earnings at annualized rates of 21.3% and 30.1% (excluding NMF, $0.11, $0.37, and $0.98/share in ’14-’17, respectively, which if included would boost this number higher) for the last 10 years. Lines are up, straight, and parallel since ’15. PTPM was 14.3% in ’13 before dipping negative and recovering over the following three years. Since ’17, PTPM has increased from 13.1% to 19.4% with a last-5-year average of 16.6%. For the last 10 years, PTPM is about equal with the industry while trailing its peers as neither of the latter two suffered the ’14-’17 dip.
ROE increased from 2.5% in ’16 (initial ROE value on record) to 19.3% in ’21 before catapulting to 64.7% in ’22 (upside outlier). The last-5-year average (excluding ’22) is 15.7%, and as a whole this leads peer and industry averages—both of which cratered in ’17 (possibly due to TCJA). Debt-to-Capital declined from 47.8% in ’15 to 5.9% in ’19 before reversing higher to 32.8% in ’22. Overall, this is much lower than peer and industry averages. The last-5-year average is 15%. M* reports a Quick Ratio of 0.35, which [deserves a bit more digging and] on its own would be somewhat concerning. Value Line assigns a Financial Strength rating of B++ despite the company having no long-term debt.
I forecast long-term annualized sales growth of 11% based on the following:
- CNN Business projects 13.3% YOY and 12.5% per year for ’23 and ’22-’24, respectively (based on 3 analysts).
- YF projects YOY 17.3% and 13% for ’23 and ’24, respectively (5 analysts).
- Zacks projects YOY 16.7% and 14.1% for ’23 and ’24, respectively (2).
- Value Line projects 12% annualized growth from ’22-’27.
- CFRA projects 17.3% YOY and 15.1% per year for ’23 and ’22-’24, respectively (5).
- M* offers a 2-year ACE of 15% per year.
>
I am forecasting below the range.
I forecast long-term annualized EPS growth of 10% based on the following:
- CNN Business reports ACE of 6.6% YOY and 11.5% per year for ’23 and ’22-’24, respectively (based on 3 analysts), along with 5-year annualized growth of 12%.
- MarketWatch projects annualized growth of 13.9% and 15.1% for ’22-’24 and ’22-’25, respectively (5 analysts).
- Nasdaq.com projects 17.1% YOY for ’24 (2).
- YF projects YOY 6.6% and 16.6% for ’23 and ’24, respectively (5), along with 5-year annualized growth of 14.2%.
- Zacks projects YOY 5.4% and 17% for ’23 and ’24, respectively (2).
- Value Line projects 10.4% annualized growth from ’22-’27.
- CFRA projects 11.5% YOY and 14.7% per year for ’23 and ’22-’24, respectively (2).
>
I am forecasting below the three-long-term-estimate range (mean 12.2%).
My Forecast High P/E is 32. Excluding the upside outlier in ’16 (105.2), over the last six years high P/E has ranged from 32.4 in ’22 to 48 in ’21 with a last-5-year average of 37. I am forecasting below the range.
My Forecast Low P/E is 16. Excluding the upside outlier in ’16 (71.7), over the last six years low P/E has ranged from 15.3 in ’20 to 27.2 in ’21 with a last-5-year average of 18.8. I am forecasting near the bottom of the range (only ’20 is lower).
My Low Stock Price Forecast is the default value of $117.10. This is 36.1% less than the previous closing price and 7.7% less than the ’22 low.
These inputs land MEDP in the HOLD zone with an U/D ratio of 2.9. The Total Annualized Return (TAR) is 15.4%.
PAR (using Forecast Average, not High, P/E) is 9%. This is less than I want to see from a medium-sized company. If the margin of safety (MOS) is strong enough, then I can ignore PAR in favor of TAR.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 170 studies over the past 90 days (mine excluded), averages for projected sales growth, projected EPS growth, Forecast High P/E, and Forecast Low P/E are 15.9%, 15.6%, 31.8 and 18.9, respectively. I am significantly lower on growth rates and also lower on P/E range. MS high and low EPS are $14.75 and $6.69 compared to my $11.72 and $7.32. My low EPS may be greater than MS due the latest quarterly earnings release, and my high EPS is less due to a lower forecast growth rate. MS has a Low Stock Price Forecast of $125.38, which is 7.1% higher than mine.
As just suggested, my forecast average annual P/E (24) is just below MS (25.4) even though my Forecast High P/E is higher. Value Line projects much lower at 20. This is where I question the Value Line numbers. Going back in the statistical array, average annual P/E for ’19-’22 are 25.5, 27, 37.3, and 22.9. Looking back to the M* data I used, these same values are 25.3 (difference of -0.2), 27.3 (+0.3), 37.6 (+0.3), and 24.9 (+2.0). Unlike a few other companies on which I have run this analysis, Value Line here only understates by a mean of 0.6, which is not significant. My higher P/E range therefore offsets MOS created by my lower forecast growth rates.
I was uncharacteristically stretching with the P/E forecasts. Given my initial Forecast Low P/E, the Low Stock Price Forecast came up extremely far below the previous close. I therefore increased as high as I could while still maintaining justification to call it conservative.
Although MEDP is a BUY under $181, I may look for an even lower entry price to compensate for the lack of MOS. An additional reason to demand MOS in this study is uncertainty due to the lower number of analysts contributing to the above-cited projections and the lower number of long-term projections themselves.
Categories: BetterInvesting® | Comments (0) | PermalinkCBRE Stock Study (3-27-23)
Posted by Mark on March 29, 2023 at 06:45 | Last modified: March 28, 2023 08:48I recently did a stock study on CBRE Group, Inc. (CBRE) with a closing price of $68.86.
Value Line writes:
> CBRE Group, Inc. is a worldwide commercial real estate firm,
> offering services to occupiers, owners, lenders, and investors
> in the office, retail, industrial, and multi-family segments
> of the market. Provides facilities management, leasing,
> property, sales, mortgage origination, investment management,
> and valuation services.
This large-sized company has grown sales and earnings at annualized rates of 17.8% and 18%, respectively, for the last 10 years. Lines are mostly up, straight, and parallel except for sales in ’20 and EPS in both ’20 and ’22. PTPM has trended slightly lower over the last 10 years while slightly edging out peer and industry averages. Its last-5-year average is 6.1%.
Aside from a downside outlier in ’20 (11.4%), ROE has remained between 17-23% over the last 10 years while beating peer and industry averages; last-5-year average is 19.2%. Debt-to-Capital has generally trended lower over the last decade from 56.8% in ’13 to 30.8% in ’22 while tracking higher than peer and industry averages; last-5-year average is 35.6%. Per Value Line, Interest Coverage is 25 and Financial Strength gets a rating of A. M* assigns a Standard rating for Capital Allocation.
I forecast long-term annualized sales growth of 3% based on the following:
- CNN Business projects 4.2% YOY and 5.7% per year for ’23 and ’22-’24, respectively (based on 8 analysts).
- YF projects YOY 4.1% and 7.1% for ’23 and ’24, respectively (7 analysts).
- Zacks projects YOY growth of 4% and 7.7% for ’23 and ’24, respectively (3).
- Value Line projects 3.9% annualized growth from ’21-’27.
- CFRA projects 2.3% YOY and 4.9% for ’23 and ’22-’24, respectively.
- M* offers a 2-year ACE of 4.2% per year along with its own analyst estimate of 4.9% annualized for the next 10 years.
>
I am forecasting below the range.
I forecast long-term annualized EPS growth of 4% based on the following:
- CNN Business reports ACE of a 10.2% contraction and 2.9% growth per year for ’23 and ’22-’24, respectively (based on 8 analysts), along with 5-year annualized growth of 11%.
- MarketWatch projects annualized growth of 4.6% and 7% for ’22-’24 and ’22-’25, respectively (11 analysts).
- Nasdaq.com projects annualized growth of 18.4% and 17.7% for ’23-’25 and ’23-’26, respectively [4, 3, and 1 analyst(s) for ’23, ’25, and ’26].
- YF projects YOY 12.1% contraction and 16.6% growth for ’23 and ’24, respectively (9), along with 11% annualized growth for the next five years.
- Zacks projects YOY 12.1% contraction and 20.6% growth for ’23 and ’24, respectively (4).
- Value Line projects 3.2% annualized growth from ’22-’27.
- CFRA projects 11.3% YOY contraction and 0.1% growth per year for ’23 and ’22-’24, respectively, along with 3-year projected CAGR of 1%.
- Morningstar offers a long-term growth estimate of 12% per year.
>
I am forecasting near the bottom of the four-long-term-estimate range (mean 9.3%).
My Forecast High P/E is 18. Excluding the upside outlier in ’20 (30.5), high P/E has gone from 28.3 in ’13 to 16.3 in ’18 and ’19 before rebounding to 25.9 in ’22 with a last-5-year average (excluding ’20) of 19.7. I am forecasting near the low end of the range (only ’18 and ’19 are lower).
My Forecast Low P/E is 12. Low P/E has gone from 21 in ’13 to 10 in ’19 before rebounding to 15.5 in ’22. The last-5-year average is 12.3. My forecast is lower than all but ’19 and ’21 (10.9).
My Low Stock Price Forecast is the default value of $51.20. This is 25.6% less than the previous closing price and 12.8% less than the ’21 low.
These inputs land CBRE in the HOLD zone with an U/D ratio of 1.4. The Total Annualized Return (TAR) is 6.4%.
PAR (using Forecast Average, not High, P/E) is 2.6%. This is too low for me to invest.
To assess margin of safety (MOS) in this study, I like to compare inputs with those of Member Sentiment (MS). Based on 73 studies over the past 90 days (mine excluded), averages for projected sales growth, projected EPS growth, Forecast High P/E, and Forecast Low P/E are 8.2%, 9.2%, 20.7 and 13.4, respectively. I am lower across the board—especially on growth rates. MS high and low EPS are $7.45 and $3.91, respectively, compared to my $5.22 and $4.27. My low EPS may be greater due to a the latest quarterly earnings release, but my high EPS is less than MS due to a lower forecast growth rate. MS has a Low Stock Price Forecast of $50.38, which is close to mine. Overall, I think the MOS in this study is robust.
When I last studied this stock on 1/22/23, I called for a 10% discount to $76 as a buy point. My inputs went from 5%, 5%, 16, and 10 in January to 3%, 4%, 18, and 12 now. Despite getting that 10% selloff, I am still looking for another 10% discount to reach my BUY zone under $61.90/share.
While this may seem puzzling, I want to spend today’s extra time discussing study pliability. As an example consider the Value Line long-term estimate in the left-margin table [I don’t use this because I feel it’s watered down with too much actual data]: 8.5% growth between ’19-’21 and ’26-’28. The statistical array says ’20 and ’26-’28 correspond to $3.27 EPS/share and $6.50, respectively: 10.3% annualized growth. If I use the mean of ’19, ’20, and ’21 ($4.26 EPS/share) for ’20, then I get 6.2% annualized growth. That 8.5% is in the middle of 6.2% and 10.3%, yet I can’t pinpoint exactly where it comes from.
In generating my growth forecasts, I like to estimate conservatively near the lower end or just below the range altogether. I just illustrated how two legitimate approaches to calculation result in estimates ~4% apart. Were that the lower threshold, my forecast could vary by that amount.
In calculating growth rates from analyst estimates, I like to anchor the range with an actual result to reduce uncertainty. I therefore start with the column to the left of Value Line’s bold font. For the current CBRE report, this is [inexplicably] ’21 [CBRE has an estimate earnings date (per Nasdaq.com) of 5/2/23, which suggests the final 2022 earnings announcement was around 2/2/23 or two weeks before the report date. That should be enough time to be included here!]. I think of the ’26-’28 column as ’27 [technically it could be ’26 or ’28, which adds more potential variance to the mix]. My preferred forecast is therefore $5.80 to $6.50 over six years for a 1.9% annualized growth rate.
Again, moving the starting point forward demonstrates the aforementioned pliability. Given a completed ’22, the calculation is $5.55 to $6.50 over five years for a 3.2% growth rate. Going from ’23 to ’26-’28 would be $5.05 (projected) to $6.50 over four years or a 6.5% growth rate. None of these are that left-margin-table 8.5% and once again, we see how changing the starting year can result in variation over 4%.
Despite the pliability, my conservative approach brings me comfort. Basing my forecast on the mean (in the middle rather than at the low end of the range) estimate would increase stability if I were willing to sacrifice MOS. I prefer the latter.
Categories: BetterInvesting® | Comments (0) | PermalinkMRK Stock Study (3-14-23)
Posted by Mark on March 27, 2023 at 07:25 | Last modified: March 24, 2023 15:44I recently did a stock study on Merck & Co., Inc. (MRK) with a closing price of $105.00.
Value Line writes:
> Merck & Co., Inc. is a global health care company that delivers
> innovative health solutions through its prescription medicines,
> vaccines, biologic therapies, and animal health products.
> Operations comprised of two segments: Pharmaceutical (88% of
> total sales) and Animal Health (12%). Top-grossing franchises
> in 2021 included Keytruda (oncology), Januvia (diabetes),
> Gardasil (vaccine), ProQuad (vaccine), and Bridion (hospital
> acute care). Acquired Acceleron Pharma (11/21).
This mega-sized (annual revenue > $50B) company has grown sales and earnings at rates of 3.2% and 13.1% per year, respectively, over the last 10 years. I hesitate to call MRK a “high-quality growth stock” because lines are not particularly up, straight, and parallel. YOY sales were down in ’14 and ’15. YOY EPS were down in ’15, ’16, ’17 (perhaps due to TCJA), and ’20.
Excluding an upside outlier in ’14 (40.9%), PTPM has increased over the last decade from 12.6% (’13) to 27.7% (’22) with a last-5-year average of 23.9%. This trails peer and industry averages.
Over the last decade, ROE has increased from 9.1% to 32.6% with a last-5-year average of 29.1%. This is lower than peer and industry averages. Debt-to-Capital has increased from 33.5% (’13) to 55.7% (’20) before declining to 40% (’22) with a last-5-year average of 48.2%: slightly less than peer and industry averages. Interest Coverage is 18 and Quick Ratio is 0.93. Value Line rates the company A for Financial Strength and M* describes the balance sheet as “sound” while assigning a Standard rating for Capital Allocation.
I forecast long-term annualized sales growth of 3% based on the following:
- CNN Business projects a 2% YOY contraction and 1.9% growth per year for ’23 and ’22-’24, respectively (based on 23 analysts).
- YF projects YOY 1.8% contraction and 6.2% growth for ’23 and ’24, respectively (19 analysts).
- Zacks projects YOY 1.3% contraction and 6.8% growth for ’23 and ’24, respectively (6).
- Value Line projects 4.6% annualized growth from ’21-’26.
- CFRA projects a 1.2% YOY contraction and 5% growth per year for ’23 and ’22-’24, respectively (6).
- M* gives a 2-year ACE of 1.9% growth per year while also projecting 6% per year x5 years in its analyst report.
>
I am forecasting below the two longer-term estimates.
I forecast long-term annualized EPS growth of 7% based on the following:
- CNN Business projects a 7.8% YOY contraction and 7% growth per year for ’23 and ’22-’24, respectively (based on 23 analysts) along with a 5-year annualized growth rate of 11.5%.
- MarketWatch projects annualized growth of 7.7% and 8.8% for ’22-’24 and ’22-’25, respectively (23 analysts).
- Nasdaq.com projects annualized growth of 18.6% and 14.9% for ’23-’25 and ’23-’26, respectively (10, 5, and 3 analysts for ’23, ’25, and ’26).
- Seeking Alpha projects 4-year annualized growth of 9.8%.
- YF projects YOY 8% contraction and 25% growth for ’23 and ’24, respectively (19), along with 5-year annualized growth of 10.5%.
- Zacks projects YOY 8% contraction and 25% growth for ’23 and ’24, respectively (8), along with 5-year annualized growth of 8%.
- Value Line projects annualized growth of 8.4% from ’21-’26.
- CFRA projects a 7.4% YOY contraction and 9.3% growth per year for ’23 and ’22-’24, respectively, along with a 3-year CAGR of 9%.
- M* projects an annualized long-term growth rate of 7.3%.
>
I am projecting just below the entire range (mean of six long-term estimates: 9.3%).
My Forecast High P/E is 18. Excluding the upside outlier in ’17 (73.2), high P/E has ranged from 14.6 (’14) to 44.3 (’16) with a last-5-year average of 25.3. I am forecasting toward the bottom of the range (only the ’14 value is lower).
My Forecast Low P/E is 13. Excluding the upside outlier in ’17 (58.8), low P/E has ranged from 11.6 (’14) to 32.4 (’16) with a last-5-year average of 17.8. I am forecasting toward the bottom of the range (only the ’14 value is lower).
My Low Stock Price Forecast is the default value of $74.20. This is 29.3% less than the previous closing price, 4% less than the 52-week low of $77.3, and 1.8% higher than the ’22 low.
Payout Ratio in the last 10 years has ranged from 42.5% in ’14 to 131.2% in ’16 (excluding upside outlier of 217.2% in ’17) with a last-5-year average of 67.5%. I am estimating conservatively at 40%.
These inputs land MRK in the HOLD zone with an U/D ratio of 1.2. The Total Annualized Return (TAR) is 8.6%.
TAR is decent for a large-sized company, but PAR (using Forecast Average, not High, P/E) is only 5.8%. A good margin of safety (MOS) will give me more confidence in the former as a reasonable target.
For this assessment, I compare my forecasts with those of Member Sentiment (MS). Out of 399 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 5.7%, 8.4%, 25.7, 22.1, and 96.3%, respectively. I am lower across the board [I think something is seriously awry with the 96.3% but that would be a whole other discussion] thereby suggesting a robust MOS in this study.
Value Line projects an average annual P/E of 14, which is much lower than MS (23.9) and even lower than mine (15.5). Upon closer look, though, some discrepancy exists between M* and Value Line’s P/E ratios. Looking at M*’s mean high/low P/E versus Value Line’s average annual P/E (statistical array), for ’18-’22 reveals the following: 27.4 vs. 14.8, 20.6 vs. 15.9, 27 vs. 13.6, and 17.0 vs. 12.9. In other words, the mean difference over these four years is 8.7 points in favor of M*. Since I used M* data to determine my forecasts, maybe I should compare my 15.5 with 14 + 8.7 = 22.7 for Value Line as an apples-to-apples comparison. Not only does this preserve my MOS, it would seem to exaggerate it!
In either case, MRK seems to be fully-valued right now. I would look to re-evaluate below $91/share.
Categories: BetterInvesting® | Comments (0) | PermalinkAL Stock Study (3-13-23)
Posted by Mark on March 23, 2023 at 06:32 | Last modified: March 23, 2023 15:21I recently did a stock study on Air Lease Corp. (AL) with a closing price of $39.25.
Value Line writes:
> Air Lease Corp. engages in the purchase and leasing of
> commercial jet transport aircraft to airlines worldwide.
> It sells aircraft from its operating lease portfolio to
> third parties, including other leasing companies,
> financial services companies, and airlines.
Over the last 10 years, this medium-sized company has grown sales 11.1% per year. Earnings have grown 11.3% per year from ’13-’21. The company posted a loss of $1.24/share in ’22 due to aircraft in Russia. From the 2022 10-K:
> In response to the sanctions, in March 2022 we terminated
> all of our leasing activities in Russia, consisting of 24
> aircraft in our owned fleet, eight aircraft in our managed
> fleet and the leasing activity relating to 29 aircraft that
> that had not yet delivered from our orderbook, all of which
> have been subsequently placed. In the first quarter of
> 2022, we also canceled five aircraft in our orderbook that
> were slated for delivery in Russia.
>
> While we or the respective managed platform maintain title
> to the aircraft, we determined that it is unlikely we or
> they will regain possession of the aircraft that are
> detained in Russia. As a result, we recorded a write-off of
> our interests in our owned and managed aircraft that are
> detained in Russia, totaling approximately $802.4 million
> for the three months ended March 31, 2022. The 21 aircraft
> that remained in Russia were removed from our fleet as of
> March 31, 2022.
Sans write-off, I calculate ’22 earnings at $5.67/share rather than -$1.24. For purposes of 5-year projections below, I will lean conservatively and discount by just over 20% to get $4.50/share as my initial value.
Excluding ’22, sales are up and mostly straight while earnings peaked in ’19 (excluding ’17 when EPS was up ~100% YOY due to TCJA) and have been falling slightly ever since. PTPM went from 34.2% in ’13 to 40.9% in ’16 and has fallen every year since to 25.9% in ’21 for a last-5-year average (excluding ’22) of 33.2%, which is higher than peer and industry averages.
ROE went from 7.5% in ’13 to 11.4% in ’18 (’17 excluded due to TCJA) before falling to 6.2% in ’21 for a last-5-year average (excluding ’22) of 9.1%. This is slightly better than peer averages and mostly lower than the industry.
Debt-to-Capital has averaged 71.8% over the last five years, which is lower than peer and industry averages but still uncomfortably high. M* lists Interest Coverage as an ominous -1.61: first time I have seen a negative number on this metric. Current and Quick Ratio are ~0.9 and FCF has been negative since at least ’20.
Despite these red flags, M Ramirez writes in a SA article:
> The main negative point for the market is that Air Lease is
> a finance company and as such needs a lot of debt to operate
> on a large scale with the assets it holds. Leverage is
> currently high (about 2.5 debt/equity), although in no case
> is the amount of debt greater than the total value of the
> company’s assets… although a priori the debt seems exorbitant,
> the company finances more than 95% of the debt at a fixed rate
> (…close to 3%), which, together with the high predictability
> of its cash flows, makes it practically impossible for the
> company to go bankrupt. The company could stop aircraft
> purchases for 5 years and with the cash flows repay half of
> the debt without increasing rents to the lessees.
I forecast long-term annualized sales growth of 11% based on the following:
- CNN Business projects 13% YOY and 16.1% per year for ’23 and ’22-’24, respectively (based on 8 analysts).
- YF projects YOY 14.4% and 16.8% for ’23 and ’24, respectively (5 analysts).
- Zacks projects YOY 13.8% and 17.3% for ’23 and ’24, respectively (3).
- CFRA projects growth of 15.2% YOY and 16% per year for ’23 and ’22-’24, respectively (5).
- M* gives an ACE of 16.8% per year for the next two years.
>
I am extrapolating out to five years with a forecast lower than all estimates except ’22-’24 CNN Business.
I forecast long-term annualized EPS growth of 96.4% based on the following:
- CNN Business projects 14% YOY and 19.7% per year for ’23 and ’22-’24, respectively (based on 8 analysts), along with 5-year annualized growth of 22.7%.
- MarketWatch projects 19.7% and 17% per year for ’22-’24 and ’22-’25, respectively (8 analysts).
- Nasdaq.com projects 13.1% YOY and 20.1% per year for ’23 and ’22-’24, respectively (4 and 3 analysts for ’23 and ’24).
- Seeking Alpha projects 4-year annualized growth of 24.4%.
- YF projects 24.1% YOY growth for ’23 (5) along with 5-year annualized growth of 26.2%.
- Zacks projects 27.5% YOY for ’23 (3) along with 5-year annualized growth of 22.7%.
- Value Line projects 16.5% annualized from ’21 to ’23/’24 and offers a 5-year-annualized ACE of 16.9%.
- CFRA projects growth of 18% YOY and 26.8% per year for ’23 and ’22-’24, respectively (1).
>
I am forecasting 15% growth—below the entire range of five long-term estimates (mean 22.5%)—and using $4.50/share in ’22 (see above) as my base. This results in future EPS of $9.04/share.
In order to project from ’22 on the website, I need to recalculate based on the trendline at $0.30 and enter a 96.4% growth rate to end up at $8.72/share (98% growth rate overshoots to $9.08/share; we’ll just say “user error” as the reason this didn’t end up as 97%, but it’s even more conservative this way).
My Forecast High P/E is 8. From ’13-’21, high P/E ranged from 7.2 (’17) to 18.6 (’13) with a last-5-year average of 11.7. I am forecasting near the bottom of the range (only the ’17 value is lower).
My Forecast Low P/E is 6. Excluding the downside outlier in ’20 (1.9), from ’15-’21 low P/E ranged from 5.0 (’17) to 14.6 (’14) with a last-5-year average of 7.4. I am forecasting near the bottom (using the aforementioned $4.50/share rather than TTM).
My Low Stock Price Forecast is $27. This is 6 * $4.50: 31.2% below the previous close and 9.4% less than the 52-week low.
Over the last 10 years, Payout Ratio has ranged from 4.8% (’17) to 18.6% (’21) with a last-5-year average of 13.1% (2022’s NMF excluded). I am forecasting conservatively at 5%.
These inputs land AL in the HOLD zone with an U/D ratio of 2.5. The Total Annualized Return (TAR) is 12.8%.
Total annualized return (TAR) of 12.8% is acceptable for a medium-sized company, but PAR (using Forecast Average, not High, P/E) is lower at 9.9%. Can I believe in the former?
To answer this, I compare my inputs with Member Sentiment (MS). Out of 226 studies over the past 90 days [my own and 20 other studies with high EPS > $40/share excluded (18 of these were 4 digits or more)], projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio average 11.7%, 31.9%, 11.6, 7.7, and 8.2%, respectively. I’m lower on P/E range and Payout Ratio. My sales growth forecast is the same. The 31.9% projected EPS growth along with the MS [average] high EPS of $4.65 suggest most people are not acknowledging ’22 as a one-time loss since it alone is less than ’22 EPS sans write-off. Low EPS is another head-scratcher as many studies have negative values. From my perspective, recording a loss on the Russian airplane fleet is the epitome of an extraordinary item; how can that possibly be used to represent zero growth five years hence short of the write-off being repeated each and every year?
Based on these observations, I perceive a robust margin of safety in this study and would be a buyer under $37/share.
Categories: BetterInvesting® | Comments (0) | Permalink