PKG Stock Study (9-12-23)
Posted by Mark on November 30, 2023 at 06:46 | Last modified: September 12, 2023 13:53I recently did a stock study on Packaging Corp. of America (PKG $146.26). My other studies are here and here.
M* writes:
> Packaging Corp of America is the third-largest containerboard
> and corrugated packaging manufacturer in the United States.
> It produces over 4 million tons of containerboard annually.
> The company’s share of the domestic containerboard market
> is about 10%. The firm differentiates itself from larger
> competitors by focusing on smaller customers and operating
> with a high degree of flexibility.
Over the past decade, this medium-size company has grown sales and earnings at annualized rates of 6.8% and 9.8%. Lines are mostly up and parallel except for a sales decline in ’15 and sales + EPS declines in ’14, ’19, and ’20. PTPM is higher than peer and industry averages, trending up from 11.3% in ’13 to 16.1% in ’22 with a last-5-year mean of 13.4%.
Also over the past decade, ROE is roughly even with industry averages, trending lower from 39.9% in ’13 to 24.9% in ’22 with a last-5-year mean of 22.8%. Debt-to-Capital is lower than peer and industry averages, trending down from 66.2% in ’13 to 43.2% in ’22 with a last-5-year mean of 45.5%.
Quick Ratio and Interest Coverage are 2.0 and 19.6, respectively. M* gives a “Standard” rating for Capital Allocation while Value Line rates the company A for Financial Strength.
With regard to sales growth:
- CNN Business projects contraction of 7.1% YOY and 3.6% per year for ’23 and ’22-’24 (based on 6 analysts).
- YF projects YOY 8.0% contraction and 1.1% growth for ’23 and ’24, respectively (7 analysts).
- Zacks projects YOY contraction of 8.5% and 1.0% growth for ’23 and ’24, respectively (4).
- Value Line projects 3.4% growth per year from ’22-’27.
- CFRA projects contraction of 7.9% YOY and 2.7% per year for ’23 and ’22-’24, respectively.
- M* provides a 2-year ACE of 0.5% along with a 10-year annualized growth projection of 1.9% in its analyst note.
>
I am forecasting conservatively below the long-term range at 1.0%.
With regard to EPS growth:
- CNN Business projects contraction of 28.8% YOY and 17.4% per year for ’23 and ’22-’24, respectively (based on 6 analysts), along with 5-year annualized growth of 3.0%.
- MarketWatch projects annualized contraction of 14.9% and 6.1% for ’22-’24 and ’22-’25, respectively (9 analysts).
- Nasdaq.com projects 7.0% YOY contraction and 1.5% per year growth for ’24 and ’23-’25 (5, 5, and 2 analysts for ’23, ’24, and ’25).
- Seeking Alpha projects 4-year annualized growth of 1.0%.
- YF projects YOY contraction of 26.7% and 2.6% for ’23 and ’24, respectively (8), along with 5-year annualized contraction of 14.3%.
- Zacks projects YOY contraction of 26.8% and 7.0% for ’23 and ’24, respectively (5), along with 5-year annualized growth of 5.0%.
- Value Line projects annualized growth of 5.5% from ’22-’27.
- CFRA projects contraction of 26.2% YOY and 16.0% per year for ’23 and ’22-’24 along with a 3-year CAGR of +2.0%.
>
My first attempt is to forecast -1.0% per year. This is below the 5-long-term-estimate mean (0%).
Things get tricky with a negative growth rate [which arguably should never happen for a high-quality stock] because I need to ensure high EPS exceeds low EPS. For high EPS, I will use ’21 EPS of $8.83/share: more than a 1% annualized discount for five years off 2023 Q2 EPS of $9.46/share (annualized). Low EPS will be ’19 EPS of $7.34/share.
While this sounds good, it results in a forecast high price lower than the previous close (invalid study).
For my second attempt, I will exclude the highest and lowest estimates. I’m really perplexed by the YF number anyway as its absolute value seems extreme compared to the others. This results in a 3-estimate mean and my forecast of 3.0%. As an initial value, I will use 2023 Q2 $9.46/share (annualized) rather than ’22 EPS of $11.03.
My Forecast High P/E is 14.0. Over the past decade, high P/E ranges from 14.4 (’13) to 28.7 (upside outlier in ’20) with a last-5-year mean (outlier excluded) of 16.4. The last-5-year-mean average P/E is 14.2. I am forecasting below the entire range.
My Forecast Low P/E is 10.0. Over the past decade, low P/E ranges from 8.5 (’13) to 14.7 (’20) with a last-5-year average of 12.0. I am forecasting toward the bottom of the range (10-year median is 11.6).
My Low Stock Price Forecast (LSPF) is $110.60. The default value is $94.60, which is 35.3% less than the previous close and 14.5% less than the 52-week low. Because the analyst reports see headwinds easing by the end of ’23, I don’t see occasion for that much of a haircut. I will therefore use the 52-week low, which is 24.4% less than the previous close.
Over the past decade, Payout Ratio has ranged from 33.8% (’13) to 69.6% (upside outlier in ’20) with a last-5-year mean (excluding the outlier) of 42.5%. I am forecasting toward the lower end of the range at 34.0%.
These inputs land PKG in the SELL zone with a U/D ratio of 0.2. Total Annualized Return (TAR) is 3.6%.
PAR (using Forecast Average—not High—P/E) is 0.7%, which is less than the current yield on T-bills. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on the 3.4% instead—still much lower than I seek.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on only 48 studies over the past 90 days (my study along with 16 other outliers excluded), averages (lower of mean/median) for projected sales growth, EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 5.3%, 6.6%, 16.8, 11.6, and 45.5%. I am lower across the board. Value Line projects a future average annual P/E of 19.0. This is [much] higher than MS (14.2) and mine (12.0).
MS high / low EPS are $14.00 / $9.83 vs. my $10.97 / $9.46 (per share). My high EPS is lower due to a lower growth rate.
MS LSPF of $109.90 implies a Forecast Low P/E of 11.2, which is lower than the above-stated 11.6. MS LSPF is 3.6% less than the default $9.83/share * 11.6 = $114.03, which results in more conservative zoning. MS LSPF is only 0.6% less than mine.
My TAR (over 15.0% preferred) is much less than the 13.0% from MS.
MOS backing the current study seems robust.
I track a few different valuation metrics. PEG is 3.6 and 5.0 per Zacks and my projected P/E, respectively: both significantly overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is fair at 0.95. Kim Butcher’s “quick and dirty DCF” prices the stock at 22.0 * [$20.65 – ($6.50 + $7.85)] = $75.60, which suggests the stock to be 48.3% overvalued.
I would look to re-evaluate PKG under $121/share. With a forecast high price of $153.50, I would estimate TAR to qualify at or below $76.75/share. Hopefully as the quarters go by, we can get some resolution to the Value Line vs. YF long-term estimates.
Categories: BetterInvesting® | Comments (0) | PermalinkGNRC Stock Study (9-11-23)
Posted by Mark on November 28, 2023 at 07:09 | Last modified: September 11, 2023 12:53I recently did a stock study on Generac Holdings Inc. (GNRC at $117.66/share). Previous studies are here and here.
Value Line writes:
> Generac Holdings Inc. designs and manufactures a wide range
> of generators and other engine-powered products for the
> residential, light commercial, industrial, and construction
> markets. Its products are fueled by natural gas, liquid
> propane, diesel, and Bi-Fuel. Acquired Ottomotores, 12/12;
> Tower Light, 8/13; Country Home Prod., 8/15; and Pramac
> Group, 3/16. Generac’s products are sold through indep.
> dealers, retailers, wholesalers, and equipment rental cos.
Over the past decade, this medium-size company has grown sales and earnings at annualized rates of 13.8% and 17.5%, respectively. Lines are mostly up, straight, and parallel except for sales/EPS declines in ’14 and ’15 and an EPS decline in ’22. PTPM leads peer and industry averages despite going from 18.8% in ’13, down, up, and back down to 11.1% in ’22 with a last-5-year mean of 15.5%.
Also over the past decade, ROE leads peer and industry averages despite trending down from 66.9% in ’13 to 14.4% in ’22 with a last-5-year mean of 26.1%. Debt-to-Capital is above peers and roughly even with the industry while trending down from 79.1% in ’13 to 43.6% in ’22 with a last-5-year mean of 45.4%.
Interest Coverage is 3.9 and Quick Ratio is 0.8. M* rates the company “Standard” for Capital Allocation and describes its balance sheet as “sound.” Value Line gives a B++ rating for Financial Strength.
With regard to sales growth:
- CNN Business projects contraction of 10.9% YOY and 1.1% per year for ’23 and ’22-’24 (based on 21 analysts).
- YF projects YOY 11.3% contraction and 8.3% growth for ’23 and ’24, respectively (23 analysts).
- Zacks projects YOY 11.2% contraction and 7.6% growth for ’23 and ’24, respectively (12).
- Value Line projects 11.9% annualized growth from ’22-’27.
- CFRA projects contraction of 11.8% YOY and 2.7% per year for ’23 and ’22-’24, respectively.
- M* gives a 2-year ACE of 0.7% annualized growth.
>
With sources projecting near-term contraction, I am halving the long-term estimate to 6.0% per year.
With regard to EPS growth:
- CNN Business projects contraction of 27.1% YOY and 1.6% per year for ’23 and ’22-’24, respectively (based on 21 analysts), along with 5-year annualized growth of 8.0%.
- MarketWatch projects contraction of 6.1% per year and growth of 0.8% per year for ’22-’24 and ’22-’25 (26 analysts).
- Nasdaq.com projects annualized growth of 35.9% YOY and 25.3% for ’24 and ’23-’25, respectively (15, 15, and 5 analysts for ’23, ’24, and ’25).
- Seeking Alpha projects 4-year annualized growth of 7.0%.
- YF projects YOY 35.5% contraction and 37.4% growth for ’23 and ’24, respectively (22), along with 5-year annualized contraction of 1.4%.
- Zacks projects YOY 35.1% contraction and 35.9% growth for ’23 and ’24, respectively (15), along with 5-year annualized growth of 10.0%.
- Value Line projects 24.2% annualized growth from ’22-’27.
- CFRA projects contraction of 36.4% YOY and 2.5% per year for ’23 and ’22-’24 along with a 3-year CAGR of 10.0%.
- M* projects long-term annualized growth of 7.3%.
>
The mean of six long-term estimates is 9.2%, and I am as perplexed by the lowest as I am the highest. Excluding both, the 4-estimate mean is 8.0% with the least at 7.0%. I am forecasting 6.0%—just below the latter—and using ’22 EPS of $5.42/share as an initial value rather than Q1 ’23 $3.92 (annualized) since the former is already 35.0% lower YOY.
My Forecast High P/E is 25.0. Over the past decade, high P/E has ranged from 17.1 in ’18 to 65.3 in ’22 with a last-5-year mean of 43.0. The last-5-year-mean average P/E is 29.6. I am forecasting below the latter.
My Forecast Low P/E is 15.0. Over the past decade, low P/E has ranged from 12.0 in ’19 to 26.8 in ’21 with a last-5-year mean of 16.1. I am forecasting below the 10-year median of 15.5.
My Low Stock Price Forecast (LSPF) of $81.30 is default based on ’22 EPS. This is 29.4% less than the previous closing price and 5.8% less than the 52-week low.
These inputs land GNRC in the HOLD zone with a U/D ratio of 2.0. Total Annualized Return (TAR) is 9.5%.
PAR (using Forecast Average—not High—P/E) is 4.7%, which is less than the current yield on T-bills. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on the total annualized return (TAR) of 9.5% instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 248 studies (my study and 102 outliers excluded) over the past 90 days, averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, and Forecast Low P/E are 10.1%, 14.0%, 30.0, and 14.9. I am lower on everything but the latter (15.0). Value Line’s projected average annual P/E of 26.0 is higher than MS (22.5) and mine (20.0).
MS high / low EPS are $7.68 / $3.62 vs. my $7.25 / $5.42 (per share). My overall EPS range is higher. Value Line projects $16.00/share for high EPS, which soars above everything else.
MS LSPF of $61.30 implies a Forecast Low P/E of 16.9, which is higher than the above-stated 14.9. MS LSPF is 13.7% greater than the default $3.62/share * 14.9 = $53.94, which results in more aggressive zoning. MS LSPF is 24.6% less than mine, though, which does not bode well for MOS.
My TAR (over 15.0% preferred) is less than the 12.6% from MS. This argues for some MOS, but I would call it slim.
I track a few different valuation metrics. PEG is 2.1 and 4.6 per Zacks and my projected P/E, respectively: both overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is fair at 1.0. Kim Butcher’s “quick and dirty DCF” prices the stock at 24.0 * [$19.40 – ($6.00 + $2.25)] = $267.60, which suggests the stock to be 57.0% undervalued (perhaps not surprising since the Value Line long-term EPS estimate is so much higher than all the others).
GNRC is a BUY under $106/share. My forecast high price is $181.30. Especially with limited MOS, I would look to re-evaluate closer to the meeting of my TAR criterion around $181.30 / 2 = $90.65/share.
Categories: BetterInvesting® | Comments (0) | PermalinkMMM Stock Study (10-2-23)
Posted by Mark on November 25, 2023 at 07:04 | Last modified: October 2, 2023 14:09I recently did a stock study on 3M Co. (MMM) with a closing price of $93.62. Previous studies are here, here, and here.
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.
This large-size company has grown sales and EPS at annualized rates of 1.3% and 4.2%, respectively, over the last 10 years. Lines are somewhat up, straight and parallel with sales declines in ’15, ’16, ’19, and ’22 along with EPS declines in ’17 and ’19. Stock price is near a 10-year low. Per visual inspection, this is not a high-quality growth stock.
Over the past decade, PTPM is greater than peer and industry averages despite trending lower from 21.3% (’13) to 18.7% (’22) with a last-5-year mean of 19.8%. ROE is greater than peer and industry averages while increasing from 25.1% (’13) to 39.7% (’22) with a last-5-year mean of 43.3%. Debt-to-Capital is also greater than peer and industry averages while trending higher from 25.7% (’13) to 53.4% (’22) with a last-5-year mean of 59.4%.
Interest Coverage is currently NMF as a result of negative TTM EPS. Quick Ratio is 0.85. M* gives a Standard rating for Capital Allocation and Value Line gives an A rating for Financial Strength.
With regard to ongoing litigation risk, M* writes:
> Nothing in the settlement or the proposed payment schedule
> materially alters our prior view, as we were only off our most
> recent estimate by about $400 million (and time value of money
> more than made up the difference). After truing up its latest
> liabilities, we come away more confident in 3M’s liquidity
> position to fund the dividend, though we expect it will have
> to take about $2.5 billion in additional debt over the next
> couple of years. Apart from the $10 billion-plus liability
> booked related to PFAS and municipal drinking water and the
> more recent Combat Arms [military] earplug settlement, we
> think 3M will be on the hook for approximately $9 billion
> more in PFAS-related legal liabilities.
M* assigns a wide/stable economic moat to the company, but 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.
With regard to sales growth:
- CNN Business projects contraction of 7.0% YOY and 1.9% per year for ’23 and ’22-’24 (based on 16 analysts).
- Zacks projects YOY 7.4% contraction and 2.6% growth for ’23 and ’24, respectively (4 analysts).
- Value Line projects 2.5% annualized growth from ’22-’27.
- CFRA projects contraction of 2.8% YOY and flat for ’23 and ’22-’24, respectively.
- M* gives a 2-year ACE of 1.5% contraction per year and projects 2.5% annualized growth x10 years in its analyst note.
>
I am forecasting below the long-term estimates at 1.0% per year.
With regard to EPS growth:
- CNN Business projects contraction of 14.8% YOY and 2.4% per year for ’23 and ’22-’24, respectively (based on 16 analysts), along with 5-year annualized growth of 6.3%.
- MarketWatch projects contraction of 2.1% and 1.0% growth per year for ’22-’24 and ’22-’25, respectively (20 analysts).
- Nasdaq.com projects growth of 8.8% YOY and 8.7% per year for ’24 and ’23-’25 (6/6/3 analysts for ’23/’24/’25).
- Seeking Alpha projects 4-year annualized growth of 4.0%.
- Zacks projects YOY 11.4% contraction and 8.8% growth for ’23 and ’24, respectively (6), along with 5-year annualized growth of 7.2%.
- Value Line projects 4.2% annualized growth from ’22-’27.
- CFRA projects contraction of 14.3% YOY and 4.3% per year for ’23 and ’22-’24.
- M* projects long-term annualized growth of 2.7%.
>
The mean of five long-term estimates is 4.9% per year. I am forecasting below the range at 1.0% per year. I could forecast 2.0% and still be below the range, but due to uncertainty over how the 2023 Q2 [litigation] loss will affect the annual number, I remain ultra-conservative. I will use trendline EPS of $10.05/share as the initial value (slightly less than ’22 EPS of $10.18).
My Forecast High P/E is 18.0. Over the past decade, high P/E ranges from 17.9 in ’22 to 30.8 in ’17 with a last-5-year mean of 23.1. The last-5-year-mean average P/E is 19.4. I am forecasting near the bottom of the range (only ’22 is lower).
My Forecast Low P/E is 7.0. Over the past decade, low P/E ranges from 10.5 in ’22 to 21.9 in ’17 with a last-5-year mean of 15.6. I am forecasting well below the entire range.
My Low Stock Price Forecast (LSPF) of $70.40 is default based on $10.05/share initial value. This is 24.8% less than the previous closing price and 23.8% less than the 52-week (and 10-year) low.
Over the past decade, Payout Ratio has increased from 37.8% (’13) to 58.5% (’22) with a last-5-year average of 63.1%. I am forecasting below the entire range at 37.0%.
These inputs land MMM in the BUY zone with a U/D ratio of 4.1. Total Annualized Return (TAR) is 17.3%.
PAR (using Forecast Average—not High—P/E) is decent for a large-sized company at 10.1%. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on TAR, which is much better.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 93 studies over the past 90 days (52 outliers including my study excluded), averages (lower of mean/median) for projected sales growth, EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 2.4%, 3.8%, 20.9, 14.6, and 60.0%, respectively. I am lower across the board. Value Line projects an average annual P/E of 14.0, which is lower than MS (17.8) and higher than mine (12.5).
MS high / low EPS are $11.78 / $7.04 versus my $10.56 / $10.05 (per share). With regard to low EPS, MS would be a 9-year low for the company. This almost seems unreasonable but as mentioned above, we don’t know how the Q2 loss will affect the full year. I also see a slew of studies using -$2.84/share for low EPS. That number is nowhere in the 2023 Q2 10-Q, and it doesn’t make sense to me to use a negative number anyway [I would exclude as a nonrecurring event to get +$2.17/share ($8.68 annualized) per Value Line]. I did not lowball the low EPS but I did lower forecast growth rate by 1.0%. With regard to high EPS, Value Line projects $12.50/share. I am lowest of the three.
MS LSPF of $96.50 implies a Forecast Low P/E of 13.7: less than the above-stated 14.6. MS LSPF is invalid on today’s date, however. My LSPF is 27.1% lower, which is much more conservative. Interesting to see MS low EPS so much less than mine given a LSPF so much greater.
My TAR (over 15.0% preferred) is less than the 21.5% from MS. MOS seems robust in the current study.
I track a few different [usually conflicting] valuation metrics. PEG is 1.5 per Zacks, which is fairly valued. Relative Value [(current P/E) / 5-year-mean average P/E] cannot be calculated due to negative quarterly EPS. Kim Butcher’s “quick and dirty DCF” prices the stock at 12.0 * [$16.10 – ($6.75 + $3.00)] = $76.20, which suggests the stock to be 18.6% overvalued.
Based on what I consider to be a very conservative stock study, MMM is a BUY under $100/share.
This is my fifth First Cut done on MMM as I remain fascinated despite massive shortcomings: this is not a [high] quality company, growth is anemic, and litigation risk is very high.
Despite all this and a rating of HOLD, CFRA has a 12-month price target of $120: 13x projected 2024 EPS, which is down from the last-5-year-mean forward P/E of 16.7. This represents annual price appreciation of 28.2% and does not include the dividend yield of roughly 6%.
Maybe that’s reason to find some appeal to this stock?
Categories: BetterInvesting® | Comments (0) | PermalinkVZ Stock Study (9-6-23)
Posted by Mark on November 24, 2023 at 06:22 | Last modified: September 6, 2023 14:14I recently did a stock study on Verizon Communications Inc. (VZ) with a closing price of $34.30. The original study is here.
M* writes:
> Verizon Communications is primarily a wireless business (it
> provides about 70% of service revenue and nearly all
> operating income). It serves about 92 million postpaid and
> 22 million prepaid phone customers (following the acquisition
> of Tracfone) via its nationwide network, making it the
> largest U.S. wireless carrier. Fixed-line telecom operations
> include local networks in the Northeast, which reach about
> 25 million homes and businesses and serve about 8 million
> broadband customers. Verizon also provides telecom services
> nationwide to enterprise customers, often using a mixture
> of its own and other carriers’ networks.
Over the past decade, this mega-size (> $50B revenue per year) company has grown sales and EPS at annualized rates of 0.9% and 5.0%, respectively. YOY sales declines in ’16 and ’20. EPS is up and down every other year since ’14. For me, this does not actually clear the barbed wire fence (visual inspection not “up, straight, and parallel”).
Nevertheless [in the spirit of MMM], I will proceed to see how the study pans out.
Over the past decade, PTPM leads peer and industry averages while ranging from 12.0% in ’14 to 24.3% in ’15 with a last-5-year mean of 18.7%. ROE also leads peer and industry averages with a last-5-year mean of 28.4% (four values from 60%-136% precede that). Debt-to-Capital is higher than peer and industry averages despite trending lower from 70.7% in ’13 to 65.9% in ’22 with a last-5-year mean of 67.9%.
Quick Ratio is 0.54, and Interest Coverage is 7.2. Value Line gives an A+ rating for Financial Strength. M* gives a “Standard” rating for Capital Allocation.
With regard to sales growth:
- CNN Business projects 1.2% YOY contraction and flat growth for ’23 and ’22-’24 (based on 22 analysts).
- YF projects YOY 2.2% contraction and 1.5% growth for ’23 and ’24, respectively (21 analysts).
- Zacks projects YOY 2.4% contraction and 1.6% growth for ’23 and ’24, respectively (7).
- Value Line projects 1.0% annualized growth from ’22-’27.
- CFRA projects contraction of 1.5% YOY and 0.1% per year for ’23 and ’22-’24, respectively.
- M* gives a 2-year ACE of 0.3% contraction per year.
>
I am forecasting flat sales growth: just below the long-term estimate.
With regard to EPS growth:
- CNN Business projects contraction of 9.8% YOY and 5.3% per year for ’23 and ’22-’24, respectively (based on 22 analysts), along with 5-year annualized growth of 1.3%.
- MarketWatch projects annualized contraction of 5.2% and 3.3% for ’22-’24 and ’22-’25 (27 analysts).
- Nasdaq.com projects growth of 2.0% and 3.4% per year for ’23-’25 and ’23-’26 (9, 5, and 2 analysts for ’23, ’25, ’26).
- Seeking Alpha projects 4-year annualized growth of 0.5%.
- YF projects YOY 8.9% contraction and 0.4% growth for ’23 and ’24, respectively (18), along with 5-year annualized contraction of 0.5%.
- Zacks projects YOY 8.7% contraction and 0.9% growth for ’23 and ’24, respectively (9), along with 5-year annualized growth of 3.5%.
- Value Line projects 1.8% annualized growth from ’22-’27.
- CFRA projects contraction of 10.2% YOY and 4.9% per year for ’23 and ’22-’24 along with a 3-year CAGR of -2.0%.
- M* projects long-term annualized growth of 1.1%.
>
I am forecasting flat EPS growth—toward the bottom of the long-term-estimate range (mean of six: 1.3%). As high EPS, I will use 2023 Q2 EPS of $5.00/share (annualized) rather than ’22 EPS of $5.06. As low EPS, I will use ’20 EPS [arbitrary] of $4.30.
My Forecast High P/E is 11.0. Over the past decade, high P/E has trended down, ranging from 7.4 in ’17 to 22.2 in ’14 with a last-5-year mean of 13.3. The last-5-year-mean average P/E is 11.7. I am forecasting below the latter and toward the bottom of the range (only ’17 is lower).
My Forecast Low P/E is 6.0. Over the past decade, low P/E has trended down, ranging from 5.8 in ’17 to 18.6 in ’14 with a last-5-year mean of 10.2. I am forecasting toward the bottom of the range (only ’17 is lower).
My Low Stock Price Forecast (LSPF) of $25.80 is default based on low EPS (see above). This is 24.8% less than the previous closing price and 17.6% less than the 52-week low.
Over the past decade, Payout Ratio has ranged from 31.7% in ’17 to 89.3% in ’14 with a last-5-year mean of 54.5%. I am forecasting below the entire range at 31.0%.
These inputs land VZ in the HOLD zone with a U/D ratio of 2.4. Total Annualized Return (TAR) is 12.7%.
PAR (using Forecast Average—not High—P/E) is 8.0%, which is decent for a mega-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 210 studies (my study and 44 outliers excluded) over the past 90 days, 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%, 12.7, 9.1, and 54.3%. I am lower across the board. Value Line’s projected average annual P/E of 13.0 is higher than MS (10.9) and mine (8.5).
MS high / low EPS are $5.58 / $4.95 vs. my $5.00 / $4.30 (per share). My EPS range is clearly lower. Value Line projects future (high) EPS of $5.65/share, which is higher than both.
MS LSPF of $32.80 implies a Forecast Low P/E of 6.6: lower than the above-stated 9.1. MS LSPF is 27.2% less than the default $4.95/share * 9.1 = $45.05 [invalid on today’s date], which results in more conservative zoning. MS LSPF remains 27.1% greater than mine [suggesting current study could be a BUY with a greater (yet still sufficiently low) LSPF].
My TAR (over 15.0% preferred) is much less than the 19.6% from MS.
MOS seems robust in the current study.
I track a couple different valuation metrics. PEG is 2.1 per Zacks [cannot be calculated based on projected P/E since my growth rate (denominator) is 0%]: slightly overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is very cheap at 0.6.
VZ is a BUY under $33/share. With a forecast high price of $55.00, I estimate TAR would meet my criterion at or below $27.50/share [if I wanted to hold out that long].
Not sure exactly why I am so fascinated by such companies with lackluster and inconsistent growth. Maybe it’s when they come close to meeting stringent BUY criteria anyway. Some would call this “value investing.”
Categories: BetterInvesting® | Comments (0) | PermalinkCMCSA Stock Study (9-5-23)
Posted by Mark on November 22, 2023 at 06:48 | Last modified: September 5, 2023 14:41I recently did a stock study on Comcast Corp. (CMCSA) with a closing price of $45.73. The original study is here.
Value Line writes:
> Comcast Corp. is a global media and telecommunications company.
> Its Cable Communications segment (54% of adjusted ’21 revenues)
> provides high-speed Internet, pay-TV, and voice services across
> major U.S. markets under the Xfinity brand. NBCUniversal
> includes: broadcast, cable, and streaming networks (NBC, Bravo,
> USA, Peacock); TV/film studios (Universal Pictures,
> DreamWorks); and theme parks (Universal Studios). Acquired
> European pay-TV provider SKY plc (14%) 12/18.
Over the past decade, this mega-size (greater than $50B annual revenue) company has grown sales and earnings 7.6% and 10.5% per year (excluding ’22 EPS for reasons discussed in the original study). Sales are up and straight. EPS is generally up and straight with an upward spike in ’17 (possibly related to TCJA) and YOY declines in ’18, ’20, and ’22. PTPM leads peer and industry averages, ranging from 13.6% in ’20 to 18.1% in ’14 and ’17 with a last-5-year mean (excluding ’22) of 15.4%.
Also over the past decade, ROE trails peer and industry averages by going from 12.2% in ’13 to 17.0% in ’16 then falling to 14.4% in ’21 with a last-5-year mean of 14.8% (’22 excluded along with upside outlier of 39.8% in ’17). Debt-to-Capital is less than peer and industry averages, ranging from 47.8% in ’14 to 60.9% in ’18 with a last-5-year mean of 54.7%.
Although Interest Coverage and Quick Ratio are only 5.1 (mean of M* and Value Line) and 0.6 (M*), respectively, Value Line gives an A+ rating for Financial Strength. M* gives a “Standard” rating for Capital Allocation and writes:
> We give Comcast a Standard Capital Allocation Rating. We believe
> the firm’s balance sheet is sound and shareholder returns are
> generally appropriate. The firm instituted a dividend in 2008 as
> the business started to generate strong cash flows and has
> increased its payout ninefold, or 16% annually on average.
M* also tags the company with a “Wide” economic moat.
With regard to sales growth:
- CNN Business projects 1.0% YOY contraction and 0.8% growth per year for ’23 and ’22-’24 (based on 27 analysts).
- YF projects YOY 1.0% contraction and 2.6% growth for ’23 and ’24, respectively (25 analysts).
- Zacks projects YOY 0.9% contraction and 2.8% growth for ’23 and ’24, respectively (7).
- Value Line projects 1.7% annualized growth from ’22-’27.
- CFRA projects growth of 1.3% YOY and 2.0% per year for ’23 and ’22-’24, respectively.
- M* offers a 2-year ACE of 0.9% growth per year.
>
I am forecasting just under the long-term estimate at 1.0% per year.
With regard to EPS growth:
- CNN Business projects 0.3% contraction YOY and 6.0% growth per year for ’23 and ’22-’24, respectively (based on 27 analysts), along with 5-year annualized growth of 10.0%.
- MarketWatch projects 8.5% and 8.2% growth per year for ’22-’24 and ’22-’25, respectively (31 analysts).
- Nasdaq.com projects 8.4% and 12.8% growth per year for ’23-’25 and ’23-’26 [8/9/1 analyst(s) for ’23/’25/’26].
- Seeking Alpha projects 4-year annualized growth of 10.2%.
- YF projects YOY growth of 4.4% and 10.8% for ’23 and ’24 (23) along with 5-year annualized growth of 7.4%.
- Zacks projects YOY growth of 4.7% and 10.5% for ’23 and ’24 (8) along with 5-year annualized growth of 9.5%.
- Value Line projects 8.0% annualized growth from ’22-’27.
- CFRA projects growth of 3.0% YOY and 6.9% per year for ’23 and ’22-’24, along with a 3-year CAGR of 8.0%.
- M* gives a long-term ACE of 13.9% annualized growth.
>
I am forecasting just below the long-term estimate range (mean of six: 9.8%). I will use ’21 EPS of $3.04/share as the initial value thereby discounting any growth occurring in ’22 (sans write-down for Sky). This is the same as projecting from the ’22 trendline ($3.35/share) with a 4.9% growth rate.
My Forecast High P/E is 16.0. Over the past decade, high P/E ranges from 16.7 in ’19 to 23.0 in ’20 (’17 and ’22 excluded as downside and upside outliers of 8.9 and 43.1, respectively) with a last-5-year mean of 19.4. The last-5-year-mean average P/E is 16.3. I am forecasting below the range (sans outliers).
My Forecast Low P/E is 10.0. Over the past decade, low P/E ranges from 11.8 in ’19 to 15.4 in ’15 (’17 and ’22 excluded as downside and upside outliers of 7.2 and 23.5) with a last-5-year mean of 13.2 . I am forecasting below the range.
My Low Stock Price Forecast (LSPF) of $30.40 is default given initial value of $3.04/share. This is 33.5% less than the previous closing price and 7.0% greater than the 52-week low.
Over the past decade, Payout Ratio ranges from 28.1% in ’14 to 40.4% in ’20 (excluding outliers of 13.3% in ’17 and 89.3% in ’22) with a last-5-year mean of 33.2%. I am forecasting conservatively at 28.0% (only the downside outlier is less).
These inputs land CMCSA in the HOLD zone with a U/D ratio of 1.5. Total Annualized Return (TAR) is 10.0%.
PAR (using Forecast Average—not High—P/E) is 6.0%, which is less than I seek for a mega-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 166 studies (my study and 61 outliers excluded) over the past 90 days, averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 4.7%, 11.0%, 19.0, 13.2, and 29.2%. I am lower across the board. Value Line’s projected average annual P/E of 16.0 is lower than MS (16.1) and higher than mine (13.0).
MS high / low EPS are $2.99 / $1.58 vs. my $3.64 / $2.78 (per share). My forecast EPS range is higher because many MS studies use 2023 Q1 and Q2 EPS of $1.32/share and $1.58, respectively. I am excluding these low values. Value Line projects high EPS of $5.35, which makes mine look conservative.
MS LSPF of $26.40 implies a Forecast Low P/E of 16.7, which is higher than the above-stated 13.2. MS LSPF is 26.6% greater than default $1.58/share * 13.2 = $20.86, which supports MS low EPS as excessive. MS LSPF is also 13.2% less than mine.
For the first time ever, my TAR (over 15.0% preferred) is greater than [the 7.8% from] MS.
If I’m right about ’22 EPS being a nonrecurrent aberration, then rebound to the trendline should take place soon. Until/if that happens, I can’t claim any MOS as MS may be correct.
I track a few different valuation metrics. PEG is 1.3 per Zacks: fairly valued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is expensive at 1.8 [using what I think is that ’22 lowball EPS number]. Kim Butcher’s “quick and dirty DCF” prices the stock at 9.5 * [$9.60 – ($1.60 + $3.50)] = $42.75, which suggests the stock to be about 6.5% overvalued.
I would look to re-evaluate the stock under $39. With a forecast high price of $68.10, I would estimate TAR to meet my personal criterion at or below $34/share.
Categories: BetterInvesting® | Comments (0) | PermalinkVEEV Stock Study (8-31-23)
Posted by Mark on November 20, 2023 at 07:09 | Last modified: August 31, 2023 13:44I recently did a stock study on Veeva Systems, Inc. (VEEV) with a closing price of $192.59.
M* writes:
> Veeva is the global leading supplier of cloud-based software
> solutions for the life sciences industry. The company’s best-of-
> breed offerings address operating and regulatory requirements
> for customers ranging from small, emerging biotechnology
> companies to departments of global pharmaceutical manufacturers.
> The company leverages its domain expertise to improve the
> efficiency and compliance of the underserved life sciences
> industry, displacing large, highly customized and dated
> enterprise resource planning systems that have limited
> flexibility. Its two main products are Veeva CRM, a customer
> relationship management platform for companies with a salesforce,
> and Veeva Vault, a content management platform that tackles
> various functions within any life sciences company.
Over the past decade, this medium-size company has grown sales at an annualized rate of 29.1%. EPS has grown 25.2% per year since ’17 (previous years excluded due to fractional EPS values that would otherwise inflate rate to 40.8%). Lines are up, straight, and parallel. PTPM is above peer and industry averages, increasing from 18.3% in ’13 to 23.6% in ’22 with a last-5-year mean of 26.9%.
Also over the past decade, ROE leads peer and industry averages by increasing from 6.9% in ’13 to 13.9% in ’22 with a last-5-year mean of 16.5%. To complete the trifecta, the company has no long-term debt; Debt-to-Capital is lower than peer and industry averages with a last-5-year mean of 1.9%.
Quick Ratio is 4.0. M* rates the company “Exemplary” for Capital Allocation and categorizes them as “Wide” for Economic Moat. Value Line gives an A+ rating for Financial Strength. From what I’ve seen, it really doesn’t get much better than this!
With regard to sales growth:
- CNN Business projects 9.1% YOY and 12.8% per year for ’23 and ’22-’24, respectively (based on 25 analysts).
- YF projects YOY 10.1% and 19.0% for ’23 and ’24, respectively (28 analysts).
- Zacks projects YOY 9.7% and 19.3% for ’23 and ’24, respectively (11).
- Value Line projects 14.3% annualized growth from ’22-’27.
- CFRA projects 9.8% YOY and 14.4% per year for ’24 [FY actually ends Jan 31] and ’23-’25, respectively.
- M* offers a 2-year ACE of 14.1%.
>
I am forecasting just below the range at 9.0% per year.
With regard to EPS growth:
- CNN Business projects 6.8% YOY and 13.2% per year for ’23 and ’22-’24, respectively (based on 25 analysts), along with 5-year annualized growth of 14.0%.
- MarketWatch projects 14.5% and 14.0% per year for ’23-’25 and ’23-’26, respectively (29 analysts).
- Nasdaq.com projects 19.7% YOY and 20.0% per year for ’24-’26 and ’24-’27 [12/11/1 analyst(s) for ’24/’26/’27].
- Seeking Alpha projects 4-year annualized growth of 19.0%.
- YF projects YOY 5.8% and 18.5% for ’23 and ’24, respectively (27), along with 5-year annualized growth of 13.4%.
- Zacks projects YOY 6.8% and 17.9% for ’23 and ’24, respectively (12), along with 5-year annualized growth of 20.3%.
- Value Line projects 14.0% annualized growth from ’22-’27.
- CFRA projects 7.2% YOY and 12.2% per year for ’24 and ’23-’25, respectively, along with a 3-year CAGR of 15.0%.
- M* projects long-term growth at 22.8% per year.
>
I am forecasting below the long-term-estimate range (mean of six: 17.3%) at 13.0% per year. I will use ’22 EPS of $3.00/share as the initial value rather than 2023 Q1 EPS of $3.20 (annualized).
My Forecast High P/E is 50.0. Over the past decade, high P/E trends down from 327 in ’13 to 79.9 in ’22 with a last-5-year mean of 102. The last-5-year-mean average P/E is 78.6. I am forecasting well below the range as I expect these values to moderate as the company matures.
My Forecast Low P/E is 45.0. Over the past decade, low P/E ranges from 35.5 in ’18 to 191 in ’13 with a last-5-year mean of 54.9. I am forecasting near the bottom of the range [only ’18 and ’16 (42.5) are lower].
My Low Stock Price Forecast (LSPF) of $135.00 is default based on $3.00/share initial value. This is 29.9% less than the previous close and 10.6% less than the 52-week low.
These inputs land VEEV in the HOLD zone with a U/D ratio of 1.6. Total Annualized Return (TAR) is 7.9%.
PAR (using Forecast Average—not High—P/E) of 6.8% is less than I seek 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 197 studies (68 outliers along with my study excluded) over the past 90 days, averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, and Forecast Low P/E are 15.0%, 15.8%, 72.0, and 47.4, respectively. I am lower across the board. Value Line’s projected average annual P/E of 42.0 is lower than MS (59.7) [unlike HEI, which I studied earlier this week, MS believes the P/E hype for this stock] and mine (47.5).
MS high / low EPS are $6.66 / $2.91 vs. my $5.53 / $3.00 (per share). My high EPS is lower due to a lower EPS growth rate. Value Line projects a future [high] EPS of $8.25, which is greater than both. M* is similar at $8.38/share [although this number may come from the website itself rather than MS; I have emailed Suzi to find out more].
MS LSPF of $143.60 implies a Forecast Low P/E of 49.3: greater than the above-stated 47.4. MS LSPF is 4.1% greater than the default $2.91/share * 47.4 = $137.93, which results in more aggressive zoning. MS LSPF is also 6.4% greater than mine.
My TAR (over 15.0% preferred) is much less than MS 19.4%.
MOS backing the current study seems robust.
I track a few different valuation metrics. PEG is 2.1 and 4.0 per Zacks and my projected P/E, respectively: both overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is cheap at 0.8. Kim Butcher’s “quick and dirty DCF” prices the stock at 35.0 * [$8.50 – ($0.00 + $0.20)] = $290.50: undervalued by 33.7%.
VEEV is a BUY under $170/share. For TAR to meet my personal 15% target, I need a stock price around $138.
Categories: BetterInvesting® | Comments (0) | PermalinkSON Stock Study (9-14-23)
Posted by Mark on November 17, 2023 at 06:57 | Last modified: September 15, 2023 14:53I recently did a stock study on Sonoco Products Co. (SON) with a closing price of $54.34.
M* writes:
> Over its 100-year-plus history, Sonoco Products has steadily assembled
> a diverse portfolio of industrial and consumer packaging product
> offerings such as flexible and rigid plastics, reels and spools,
> pallets, and composite cans. The company serves a variety of
> consumer and industrial end markets throughout North America. Sonoco
> has raised its dividend each year for more than 30 years.
Over the past decade, this medium-size company has grown sales and earnings at annualized rates of 3.1% and 5.8%, respectively. I have excluded ’21 EPS because, from the company’s 2021 10-K:
> The full-year 2021 GAAP loss per diluted share was $(0.86)… The
> full-year 2021 GAAP loss was driven by $410.4 million after-tax
> pension settlement charges mostly related to the Company’s
> settlement of its U.S. Inactive Plan in the second quarter.
Lines are up, jagged, and somewhat parallel. Sales [EPS] declines in ’15, ’16, and ’19 [’17, ’19, and ’20]. PTPM trails peer averages and the industry despite increasing from 6.3% in ’13 to 7.9% in ’22 with a last-5-year mean of 6.7% (’21 excluded).
Also over the past decade, ROE trails peer and industry averages despite increasing from 13.7% (’13) to 27.9% (’22) with a last-5-year mean of 16.9% (’21 excluded). Debt-to-Capital is less than peer and industry averages despite trending up from 36.5% (’13) to 62.7% (’22) with a last-5-year mean of 51.9%.
Interest Coverage is 5.7 and Quick Ratio is 0.9. M* rates the company “Standard” for Capital Allocation and describes its balance sheet as “sound.” Value Line gives an A rating for Financial Strength.
And remember: Sonoco is a Dividend Champion!
With regard to sales growth:
- CNN Business projects flat YOY and 2.0% growth per year for ’23 and ’22-’24 (based on 5 analysts).
- YF projects YOY 5.3% contraction and 4.0% growth for ’23 and ’24, respectively (6 analysts).
- Zacks projects YOY 6.0% contraction and 3.9% growth for ’23 and ’24, respectively (2).
- Value Line projects 3.8% annualized growth from ’22-’27.
- CFRA projects contraction of 4.8% YOY and 4.7% growth per year for ’23 and ’22-’24, respectively.
- M* provides a 2-year ACE of 1.0% annualized growth and projects 1.9%/year for the next five years (analyst note).
>
I am forecasting near the lower of two long-term estimates at 2.0% per year.
With regard to EPS growth:
- CNN Business projects contraction of 12.2% YOY and 4.6% per year for ’23 and ’22-’24, respectively (based on 5 analysts), along with 5-year annualized growth of 4.0%.
- MarketWatch projects annualized contraction of 7.0% and 2.8% for ’22-’24 and ’22-’25 (8 analysts).
- Nasdaq.com projects growth of 6.2% YOY and 5.2% per year for ’24 and ’23-’25 [3/3/1 analyst(s) for ’23/’24/’25].
- Seeking Alpha projects 4-year annualized growth of 4.0%.
- YF projects YOY 19.1% contraction and 4.6% growth for ’23 and ’24, respectively (6), along with 5-year annualized contraction of 1.4%.
- Zacks projects YOY 19.8% contraction and 6.2% growth for ’23 and ’24, respectively (3), along with 5-year annualized growth of 5.0%.
- Value Line projects 9.4% annualized growth from ’22-’27.
- CFRA projects contraction of 18.8% YOY and 5.9% per year for ’23 and ’22-’24 along with a 3-year CAGR of 4.0%.
- M* projects long-term annualized contraction of 0.7%.
>
My 2.0% per year forecast is below the 5-long-term-estimate mean (3.4%) due to two negative projections. I will use ’22 EPS of $4.72/share as the initial value rather than 2023 Q2 $4.88 (annualized).
My Forecast High P/E is 18.0. Over the past decade, high P/E ranges from 14.2 in ’22 to 32.1 in ’17 with a last-5-year mean of 21.7. The last-5-year-mean average P/E is 18.6. I am forecasting below the latter and every year but ’22.
My Forecast Low P/E is 9.0. Over the past decade, low P/E ranges from 10.9 in ’22 to 27.1 in ’17 with a last-5-year mean of 15.5. I am forecasting below the entire range.
My Low Stock Price Forecast (LSPF) of $42.50 is default based on ’22 EPS. This is 21.8% less than the previous closing price and 17.5% less than the 2021-22 low.
Over the past decade, Payout Ratio ranges from 40.7% in ’22 to 88.5% in ’17 with a last-5-year mean of 59.0%. I am forecasting conservatively below the range at 40.0%.
These inputs land SON in the BUY zone with a U/D ratio of 3.3. Total Annualized Return (TAR) is 13.8%.
PAR (using Forecast Average—not High—P/E) is 8.3%, which is less than I seek in a medium-size company. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on TAR 13.8% instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on only 8 studies (my study and one other outlier excluded) over the past 90 days, averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 4.7%, 8.1%, 18.9, 15.3, and 56.7%, respectively. I am lower across the board. Value Line’s projected average annual P/E of 16.0 is lower than MS (17.1) and higher than mine (13.5).
MS high / low EPS are $7.15 / $4.79 vs. my $5.21 / $4.72 (per share). My high EPS is lower due to a lower growth estimate. Value Line projects $7.40/share for high EPS, which is above the others.
MS LSPF of $48.90 implies a Forecast Low P/E of 10.2: less than the above-stated 15.3 and 33.3% less than the default $4.79/share * 15.3 = $73.29, which results in more conservative zoning. MS LSPF still remains 15.1% greater than mine.
My TAR (over 15.0% preferred) is less than MS 20.4%. While the MS sample size is too small for a valid comparison, I consider MOS to be at least moderate in this study because all inputs are conservative [i.e. at the bottom (or below) respective ranges, below the mean, etc.].
I track a few different valuation metrics. PEG is 2.1 and 5.5 per Zacks and my projected P/E, respectively: both overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is cheap at 0.6. Kim Butcher’s “quick and dirty DCF” prices the stock at 10.0 * [$10.65 – ($2.24 + $3.15)] = $52.60, which suggests the stock to be 3.2% overvalued.
One thought worthy of further consideration is that longer-term averages will mean less if the ’22 acquisition of Ball Metalpack shocks parameters into completely new ranges.
SON is a BUY under $55/share. I would personally wait for price to drop a bit lower to meet my TAR criterion of 15.0%.
Categories: BetterInvesting® | Comments (0) | PermalinkCNC Stock Study (8-30-23)
Posted by Mark on November 16, 2023 at 06:53 | Last modified: August 31, 2023 11:04I recently did a stock study on Centene Corp. (CNC) with a closing price of $64.44.
M* writes:
> Centene is a managed-care organization focused on government-
> sponsored healthcare plans, including Medicaid, Medicare, and
> the individual exchanges. Centene served 23 million medical
> members as of September 2022, mostly in Medicaid (70% of
> membership), the individual exchanges (9%), Medicare Advantage
> (7%), and the balance in Tricare (West region), correctional
> facility, and commercial plans. The company also serves 4
> million users through… Medicare Part D pharmaceutical program.
Over the past decade, this mega-size (over $50B annual revenue) company has grown sales and earnings at annualized rates of 33.3% and 13.0%, respectively. Lines are mostly up and widening with EPS declines in ’18, ’20, ’21, and ’22. PTPM trails peer and industry averages while decreasing from 2.5% in ’13 to 1.4% in ’22 with a last-5-year mean of 2.0%.
Also over the past decade, ROE trails peer and industry averages while decreasing from 13.5% in ’12 to 4.5% in ’22 with a last-5-year mean of 7.2%. Debt-to-Capital is roughly equal to peer and industry averages while increasing from 35.1% in ’12 to 47.0% in ’22 with a last-5-year mean of 44.0%.
Interest Coverage is 6.5 and Quick Ratio is 1.1. Value Line gives a B++ rating for Financial Strength. M* gives a “Standard” rating for Capital Allocation and writes:
> Overall, while the balance sheet appears weak to us, it is
> improving and could reach sound territory in the near future if the
> firm refrains from significant, leverage-increasing acquisitions.
Admittedly, I am not overly impressed to this point with CNC. While I believe it passes visual inspection (despite sales growing faster than EPS, which is not often seen), it’s not a leader and fundamental trends are negative.
With regard to sales growth:
- CNN Business projects 1.2% YOY growth and 2.7% per year contraction for ’23 and ’22-’24 (based on 18 analysts).
- YF projects YOY 2.5% growth and 6.4% contraction for ’23 and ’24, respectively (16 analysts).
- Zacks projects YOY 2.4% growth and 7.3% contraction for ’23 and ’24, respectively (7).
- Value Line projects annualized growth of 1.1% for ’22-’27.
- CFRA projects 2.8% YOY growth and 2.3% per year contraction for ’23 and ’22-’24, respectively.
- M* gives 2-year ACE of 1.7%/year contraction and projects “low single-digit growth” through 2026 in its analyst report.
>
My forecast is flat [below the range] over the next five years. This is also consistent with the widening visual inspection.
With regard to EPS growth:
- CNN Business projects 11.4% YOY and 7.2% per year for ’23 and ’22-’24, respectively (based on 18 analysts), along with 5-year annualized growth of 9.3%.
- MarketWatch projects 7.9% and 10.3% per year for ’22-’24 and ’22-’25, respectively (21 analysts).
- Nasdaq.com projects 2.5% YOY and 7.0% per year for ’24 and ’23-’25 (7, 10, and 4 analysts for ’23, ’24, and ’25).
- Seeking Alpha projects 4-year annualized growth of 8.2%.
- YF projects YOY 12.5% and 2.9% for ’23 and ’24, respectively (18), along with 5-year annualized growth of 10.6%.
- Zacks projects YOY 11.8% and 2.5% for ’23 and ’24, respectively (9), along with 5-year annualized growth of 11.2%.
- Value Line projects 10.0% per year from ’22-’27.
- CFRA projects 13.0% YOY and 7.9% per year for ’23 and ’22-’24, respectively, along with a 3-year CAGR of 9.0%.
- M* provides an annualized long-term ACE of 17.8% and projects 13.4% long-term growth in its analyst report.
>
I am forecasting below the long-term-estimate range (mean of six: 10.5%) at 8.0% per year. I will use ’22 EPS of $2.07/share as the initial value rather than 2023 Q2 EPS of $4.85 (annualized).
The latter is a pivotal judgment worthy of further discussion. $2.07/share continues the nascent downtrend from ’20 to ’21. The first two quarters of ’23, however, show sudden reversal and growth. Value Line reports consistent annual earnings growth over the past decade by excluding substantial “nonrecurrent” losses in ’16, ’18, ’19, ’20, ’21, and ’22. I question whether six out of seven years is “nonrecurrent” [CFRA seems to agree as “Normalized EPS”—often seen for other companies—is absent from this statistical matrix]. I should probably look at the 10-K’s to assess the “nonrecurrence” [if due to regular acquisitions, then M* suggestion to cut back on leverage-increasing purchases would require breaking an established pattern].
My Forecast High P/E is 27.0. Over the past decade, high P/E increases from 23.6 in ’14 to 47.6 in ’22 with a last-5-year mean of 32.8. The last-5-year-mean average P/E is 27.4. I am forecasting just below the latter.
My Forecast Low P/E is 21.0. Over the past decade, low P/E ranges from 11.9 in ’17 to 35.4 in ’22 with a last-5-year mean of 21.9. I am forecasting below the latter [aggressive since declining EPS over the last two years corresponds to inflated P/E].
My Low Stock Price Forecast (LSPF) of $43.50 is default based on $2.07/share initial value. This is 32.5% less than the previous close and 29.0% less than the 52-week low.
These inputs land CNC in the HOLD zone with a U/D ratio of 0.9. Total Annualized Return (TAR) is 5.3%.
PAR (using Forecast Average—not High—P/E) is 2.8%, which is less than the current yield on T-bills. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on TAR although even that is less than the risk-free rate.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 121 studies (25 outliers and my study excluded) over the past 90 days, averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, and Forecast Low P/E are 6.0%, 13.4%, 23.8, and 15.5. My P/E range is higher but my growth rates are not. Value Line’s projected average annual P/E of 14.0 is lower than MS (19.7) and mine (24.0).
MS high / low EPS are $6.25 / $3.04 vs. my $3.04 / $2.07 (per share). My high EPS is lower partially due to a lower EPS growth rate. My high EPS is also lower than M* and Value Line at $3.88 and $9.30/share, respectively [a wide disparity also worthy of discussion].
MS LSPF of $52.70 implies a Forecast Low P/E of 17.3: greater than the above-stated 15.5. MS LSPF is 11.8% greater than the default $3.04/share * 15.5 = $47.12, which results in more aggressive zoning. MS LSPF remains 21.1% greater than mine.
My TAR (over 15.0% preferred) is far less than the 15.2% from MS. The latter is a direct result of MS high EPS and has nothing to do with LSPF.
MOS backing the current study seems almost excessive for two reasons [neither of which are P/E range]. First, my LSPF is much less than the 52-week low. For a stock trading near a 52-week low, maybe I need to reconsider the legitimacy of [overriding default and] discounting the previous closing price by 20-30%. An argument can be made to dissociate LSPF from a Forecast Low P/E, and I can always readjust later if needed. Second, I am using ’22 EPS rather than ’23 Q2 EPS as the initial value. That represents a significant haircut.
I track a few different valuation metrics. PEG is 0.9 and 1.5 per Zacks and my projected P/E, respectively: fairly valued, on average. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is significantly low at 0.5. Kim Butcher’s “quick and dirty DCF” prices the stock at 11.0 * [$12.70 – ($0.00 + $2.80)] = $108.90: undervalued by 40.8%.
CNC is a BUY under $53/share. For TAR to meet my 15% criterion, I need closer to $41. My conservative approach sometimes represents a very high bar for stock picking.
Categories: BetterInvesting® | Comments (0) | PermalinkHEI Stock Study (8-29-23)
Posted by Mark on November 14, 2023 at 07:05 | Last modified: August 29, 2023 14:54I recently did a stock study on HEICO Corp. (HEI) with a closing price of $167.85. Previous studies are here and here.
Value Line writes:
> HEICO Corp. engages in the design, manufacture, and sale of aerospace,
> defense, and electronics-related products and services. It operates in
> two segments: The Flight Support Group (57% of 2022 sales) designs and
> manufactures jet engine and aircraft component replacement parts. The
> Electronic Technologies Group (43%) manufactures various electronic,
> microwave, and electro-optical products. Sales by industry: commercial
> aviation, 43%; defense/space, 39%; medical, electronics, and other, 18%.
Over the past decade, this medium-size company has grown sales and EPS at annualized rates of 8.8% and 15.0%, respectively. Lines are mostly up, straight, and parallel with a slight pullback in ’20 [and ’21 for EPS]. PTPM leads industry and peer averages while increasing from 17.9% in ’13 to 22.2% in ’22 with a last-5-year mean of 20.9%.
Also over the past decade, ROE leads peers and lags the industry while declining from 17.6% in ’13 to 14.2% in ’22 with a last-5-year mean of 16.6%. Debt-to-Capital is less than peer and industry averages while falling from 38.4% in ’13 to 10.5% in ’22 with a last-5-year mean of 20.2%.
Interest Coverage is 25.5 and Quick Ratio is 1.3. Value Line gives a B++ rating for Financial Strength, and M* gives a “Standard” rating for Capital Allocation.
With regard to sales growth:
- CNN Business projects growth of 22.7% YOY and 18.7% per year for ’23 and ’22-’24 (based on 16 analysts).
- YF projects YOY 26.2% and 18.0% for ’23 and ’24, respectively (15 analysts).
- Zacks projects YOY 26.1% and 21.4% for ’23 and ’24, respectively (4).
- Value Line projects 12.3% annualized growth from ’22-’27.
- CFRA projects 24.0% YOY and 17.5% per year for ’23 YOY and ’22-’24, respectively.
- M* offers a 2-year ACE estimate of 24.5% per year.
>
I am forecasting below the long-term estimate at 11.0% per year.
With regard to EPS growth:
- CNN Business reports ACE of 15.3% YOY and 15.6% per year for ’23 and ’22-’24, respectively (based on 16 analysts), along with 5-year annualized growth of 15.0%.
- MarketWatch projects 15.4% and 14.8% per year for ’22-’24 and ’22-’25, respectively (16 analysts).
- Nasdaq.com projects 13.4% and 9.3% per year for ’23-’25 and ’23-’26 [6, 4, and 1 analyst(s) for ’23, ’25, and ’26].
- Seeking Alpha projects 4-year annualized growth of 14.0%.
- YF projects YOY 14.9% and 17.1% for ’23 and ’24, respectively (15), along with 5-year annualized growth of 13.0%.
- Zacks projects YOY 14.5% and 13.7% for ’23 and ’24, respectively (6), along with 5-year annualized growth of 13.0%.
- Value Line projects annualized growth of 14.9% per year from ’22-’27.
- CFRA projects 18.0% YOY and 16.5% per year for ’23 and ’22-’24, respectively, along with a 3-year CAGR of 25.0%.
>
I am forecasting below the long-term-estimate range (mean of five: 14.0%) at 12.0% per year. My initial value is ’22 EPS of $2.55/share rather than 2023 Q2 EPS of $2.73 (annualized).
My Forecast High P/E is 48.0. Over the last decade, high P/E ranges from 32.3 in ’15 to 67.4 in ’21 with a last-5-year mean of 60.5. The trend is higher, but I don’t expect this to continue forever. The last-5-year-mean average P/E is 48.3. My forecast is just below the latter.
My Forecast Low P/E is 36.0. Over the past decade, low P/E trends higher with a range from 19.5 in ’13 to 49.8 in ’22 and a last-5-year mean of 36.1. My forecast is just below the latter.
My Low Stock Price Forecast (LSPF) of $91.80 is default based on $2.55/share initial value: 45.3% less than the previous closing price, 33.9% less than the 52-week low, and 13.7% less than the 2021 low. This may seem extreme. However, the Forecast Low P/E seems completely reasonable to me as is. Using my approach, it would have to be raised.
Over the past decade, Payout Ratio ranges from 5.7% to 7.7% with a last-5-year mean of 6.7%. I am forecasting conservatively at 5.0%.
These inputs land HEI in the HOLD zone with a U/D ratio of 0.6. Total Annualized Return (TAR) is 5.2%.
PAR (using Forecast Average—not High—P/E) is 2.5%, which is less than the current yield on T-bills. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on the total annualized return (TAR) of 5.2% instead, which is still lower than the risk-free rate.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 108 studies (my study and 21 other outliers excluded) over the past 90 days, 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.0%, 12.0%, 46.2, 25.5, and 6.6%. I am only lower on Payout Ratio [very unusual for me!]. Value Line’s projected average annual P/E of 49.5 is higher than MS (35.9) and mine (42.0).
MS high / low EPS are $4.62 / $2.40 vs. my $4.49 / $2.55 (per share). These EPS ranges are practically identical.
MS LSPF of $67.10 implies a Forecast Low P/E of 30.2: higher than the above-stated 25.5. MS LSPF is 18.3% greater than the default $2.40/share * 25.5 = $61.20, which results in more aggressive zoning. MS LSPF does remain 21.1% less than mine.
My TAR (over 15.0% preferred) is greater than the 4.6% from MS. This is a first.
I would not claim any MOS backing the current study.
I track a few different valuation metrics. PEG is 4.4 and 4.6 per Zacks and my projected P/E: both significantly overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is overvalued at 1.3. Kim Butcher’s “quick and dirty DCF” prices the stock at 40.0 * [$6.50 – ($0.36 + $0.50)] = $225.60, which would be 35.6% undervalued.
I will look to re-evaluate the stock under $122. With a forecast high price of $215.70, I estimate TAR will meet my criterion at or below $107.85/share.
Categories: BetterInvesting® | Comments (0) | PermalinkAEM Stock Study (9-25-23)
Posted by Mark on November 11, 2023 at 06:30 | Last modified: September 25, 2023 13:07I recently did a stock study on Agnico Eagle Mines Ltd. (AEM) with a closing price of $49.05. The original study is here.
M* writes:
> Agnico Eagle is a gold miner with mines in Canada, Mexico, Finland,
> and Australia. Agnico operated just one mine, LaRonde, as recently
> as 2008 before bringing its other mines online in rapid succession
> in the following years. It merged with Kirkland Lake Gold in 2022,
> acquiring the Detour Lake and Macassa mines in Canada along with
> the high-grade, low-cost Fosterville mine in Australia. It produced
> more than 3.1 million gold ounces in 2022 and had about 15 years
> of gold reserves at end 2022. Agnico Eagle is focused on increasing
> gold production in lower-risk jurisdictions and bought the
> remaining 50% of its Canadian Malartic mine along with the
> Wasamac project and other assets from Yamana Gold in 2023.
Over the past decade, this medium-size company has grown sales at an annualized rate of 12.2%. EPS has grown at an annualized rate of 16.9% since 2016 (’14 and ’15 excluded due to low fractional EPS that would artificially inflate growth rate; ’13 and ’18 excluded due to negative EPS resulting from nonrecurrent events). PTPM lags industry averages despite trending up in recent years with a last-5-year mean of 17.1%.
Also over the past decade, ROE is roughly equal to industry averages despite trending down in recent years with a last-5-year mean of 5.2%. Debt-to-Capital is lower than industry averages and recently trending down with a last-5-year mean of 21.5%.
Interest Coverage is over 38 and Quick Ratio is 0.61. M* gives a “Standard” rating for Capital Allocation and Value Line gives a B+ rating for Financial Strength.
With regard to sales growth:
- CNN Business projects 14.0% YOY and 8.4% per year for ’23 and ’22-’24 (based on 16 analysts).
- YF projects YOY 15.1% and 3.5% for ’23 and ’24, respectively (16 analysts).
- Zacks projects YOY 14.0% growth and 0.1% contraction for ’23 and ’24, respectively (4).
- Value Line projects 11.6% annualized growth from ’22-’27.
- CFRA projects growth of 15.4% YOY and 8.3% per year for ’23 and ’22-’24, respectively.
- M* gives a 2-year ACE of 27.0% annualized growth.
>
I am forecasting toward the lower end of the range at 6.0% per year.
With regard to EPS growth:
- CNN Business projects contraction of 8.9% YOY and 1.7% per year for ’23 and ’22-’24, respectively (based on 16 analysts), along with 5-year annualized contraction of 3.5%.
- MarketWatch projects 3.3% annualized growth and 2.8% annualized contraction for ’22-’24 and ’22-’25 (19 analysts).
- Nasdaq.com projects 3.7% annualized growth and 4.9% annualized contraction for ’23-’25 and ’23-’26 [6, 3, and 1 analyst(s) for ’23, ’25, and ’26].
- YF projects YOY 4.8% contraction and 7.3% growth for ’23 and ’24, respectively (16), along with 5-year annualized contraction of 0.7%.
- Zacks projects YOY 3.0% contraction and 9.4% growth for ’23 and ’24, respectively (6), along with 5-year annualized growth of 1.0%.
- Value Line projects 18.1% annualized growth from ’22-’27.
- CFRA projects contraction of 7.0% YOY and 4.2% per year for ’23 and ’22-’24 along with a 3-year CAGR of 1.0%.
>
I am forecasting flat growth—toward the bottom of the long-term-estimate range (mean of four: 3.7%). For high EPS, I will use 2023 Q1 EPS of $5.14 (annualized). For low EPS, I am choosing to bypass ’22 EPS of $1.53/share because it seems curiously low [Value Line and CFRA’s normalized EPS reflect less than a 10% YOY decrease for ’22 versus M*’s GAAP reporting of a 31% YOY decrease]. Instead, I will use ’21 EPS of $2.22/share (arbitrary).
My Forecast High P/E is 24.0. Over the past decade, high P/E ranges from 32.6 in ’19 to 317 in ’15. The last-5-year mean high P/E is 38.4 and the last-5-year-mean average P/E is 29.1. I am forecasting below the range.
My Forecast Low P/E is 14.0. Over the past decade, low P/E ranges from 14.8 in ’20 to 191 in ’15 with a last-5-year mean of 19.8. I am forecasting below the range.
My Low Stock Price Forecast (LSPF) of $31.10 is default based on $2.22/share. This is 36.6% less than the previous closing price and 15.3% less than the 52-week low.
These inputs land AEM in the BUY zone with a U/D ratio of 4.1. Total Annualized Return (TAR) is 21.4%.
Over the past decade, Payout Ratio has ranged from 27.6% in ’19 to 291% in ’15 with a last-5-year mean of 60.1% (’22 is 105%). I am forecasting below the entire range at 27.0%.
PAR (using Forecast Average—not High—P/E) is 16.2%, which is among the highest ever seen in one of my stock studies.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on only 68 studies over the past 90 days (29 outliers and my study excluded), averages (lower of mean/median) for projected sales growth, EPS growth, Forecast High P/E, Forecast Low P/E, and Payout Ratio are 11.5%, 10.0%, 29.7, 16.9, and 43.7%, respectively. I am lower across the board. Value Line projects an average annual P/E of 20.0, which is lower than MS (23.5) and higher than mine (19.0).
MS high / low EPS are $6.13 / $2.24 versus my $5.14 / $2.22 (per share). Value Line’s high EPS is $5.20. Mine is lowest of the three due to a lower growth rate.
MS LSPF of $36.90 implies a Forecast Low P/E of 16.5, which is less than the above-stated 16.9. MS LSPF is 2.5% less than the default $2.24/share * 16.9 = $37.86, which results in more conservative zoning. MS LSPF is still 18.7% greater than mine.
My TAR (over 15.0% preferred) is much less than the 30.2% from MS. MOS seems robust in the current study.
I track a few different valuation metrics. With long-term growth rates of 1.0% and 0% from Zacks and me, PEG doesn’t make much sense (22.0 and indeterminate, respectively). Relative Value [(current P/E) / 5-year-mean average P/E] per M* seems excessively cheap at 0.33 (perhaps so low because 2023 EPS is up 200% YOY for Q1 and Q2 causing current P/E to nosedive). Kim Butcher’s “quick and dirty DCF” prices the stock at 11.0 * [$8.70 – ($2.40 + $3.10)] = $35.20, which suggests the stock to be 28.2% overvalued. These are conflicting (and confusing as to why that is).
AEM is a BUY at the current price. If I want to be even more cautious, then maybe I knock 5-10% off the max buy price to account for uncertainty related to my selection of high and low EPS.
Categories: BetterInvesting® | Comments (0) | Permalink