AAP Stock Study (10-26-23)
Posted by Mark on January 6, 2024 at 06:22 | Last modified: October 26, 2023 14:06I recently did a stock study on Advance Auto Parts Inc. (AAP) with a closing price of $49.84.
Value Line writes:
> Advance Auto Parts, Inc. is a leading retailer of aftermarket auto
> parts and accessories. Serves both the DIY and professional markets.
> As of 12/31/22, operated 4,770 stores and 316 branch locations in
> the U.S., Canada, Puerto Rico, and the Virgin Islands, primarily
> under the Advance Auto Parts, Autopart International, Carquest, and
> Worldpac banners. In addition to the 330 Carquest locations that
> the company owns, serves approx. 1,310 independently owned stores
> that operate under the Carquest name. Has about 40,000 full-time
> employees and 27,000 part timers.
Over the past decade, this large-size company has grown sales and EPS at annualized rates of 3.6% and 4.4%, respectively. Lines are somewhat up and parallel but certainly not straight with sales declines in ’15, ’16, and ’17 along with EPS declines in ’15, ’16, ’18, and ’22. For me, visual inspection does not clear the barbed wire fence. I will continue the study for purposes of interest and the possibility of a speculative [not core] position.
Over the past decade, PTPM trails peer and industry averages while declining from 9.6% (’13) to 5.8% (’22) with a last-5-year mean of 6.4%. ROE leads industry averages while tracking evenly with peers in declining from 26.4% (’13) to 18.0% (’22) with a last-5-year mean of 13.6%. Debt-to-Capital is lower than peer and industry averages despite increasing from 41.0% (’13) to 57.7% (’22) with a last-5-year mean of 44.5%.
Quick Ratio per M* is a worrisome 0.21, but Interest Coverage per Value Line is 21.3. Value Line gives a “B+” rating for Financial Strength.
With regard to sales growth:
- CNN Business projects flat growth YOY and 1.3% per year for ’23 and ’22-’24, respectively (based on 19 analysts).
- YF projects YOY 1.0% and 1.9% for ’23 and ’24, respectively (22 analysts).
- Zacks projects YOY 1.0% and 2.0% for ’23 and ’24, respectively (8).
- Value Line projects 2.4% annualized growth from ’22-’27.
- CFRA gives ACE of 1.0% YOY and 1.8% per year for ’23 and ’22-’24, respectively.
- M* provides a 2-year ACE of 1.4% annualized growth.
>
I am forecasting toward the lower end of the range at 1.0% per year.
With regard to EPS growth:
- CNN Business projects contraction of 53.5% YOY and 28.9% per year for ’23 and ’22-’24, respectively (based on 19 analysts), along with 5-year annualized contraction of 14.8%.
- MarketWatch projects growth of 17.7% YOY and 18.5% per year for ’24 and ’23-’25, respectively (27 analysts).
- Nasdaq.com projects growth of 18.2% YOY and 16.9% per year for ’24 and ’23-’25 (12/12/6 analysts for ’23/’24/’25).
- Seeking Alpha projects 4-year annualized contraction of 11.3%.
- YF projects YOY 64.3% contraction and 18.5% growth for ’23 and ’24, respectively (24), along with 5-year annualized contraction of 14.7%.
- Zacks projects YOY 64.2% contraction and 18.2% growth for ’23 and ’24, respectively (12), along with 5-year annualized growth of 11.4%.
- Value Line projects 5.2% annualized contraction from ’22-’27.
- CFRA projects contraction of 62.8% YOY and 29.1% per year for ’23 and ’22-’24 along with a 3-year CAGR of -18.0%.
>
My -9.0% per year forecast is toward the lower end of the long-term-estimate range (mean of five: -6.9%). For low EPS, I will use a growth rate of -15.0%, which is rounding down the bottom of that range. These result in high and low EPS values of $5.16 and $3.67/share, respectively.
My Forecast High P/E is 21.0. Over the past decade, high P/E increases from 21.0 (’13) to 29.6 (’22) with a last-5-year mean of 27.6 and a last-5-year-mean average P/E of 21.6. I am forecasting at the bottom of the range.
My Forecast Low P/E is 10.0. Over the past decade, low P/E ranges from 10.0 in ’20 to 22.3 in ’15 with a last-5-year mean of 15.6. I am forecasting at the bottom of the range.
My Low Stock Price Forecast (LSPF) of $36.70 is default based on $3.67/share initial value. This is 30.4% less than the previous closing price and 23.1% less than the 52-week low.
Payout Ratio ranges from 3.5% in ’19 to 4.5% in ’13 before blasting off to 14.0%, 34.0%, and 72.6% in ’20, ’21, and ’22, respectively. I am forecasting below the range at 3.0%.
These inputs land AAP in the BUY zone with a U/D ratio of 4.5. Total Annualized Return (TAR) is 17.0%.
PAR (using Forecast Average—not High—P/E) of 10.1% is decent for a large-size company. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on TAR instead.
To assess MOS, I start by comparing my inputs with those of Member Sentiment (MS). Based on only 28 studies (my study and 6 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 3.0%, 8.5%, 24.1, 14.8, and 9.5%, respectively. I am lower across the board. Value Line’s projected average annual P/E of 13.0 is less than MS (19.5) and less than mine (15.5).
MS high / low EPS are $11.28 / $5.83: much higher than my EPS range given above. With MS having the low sample size, I am not surprised to see big differences. Value Line’s high EPS is $10.00. I am lowest of the three by a substantial amount.
MS LSPF of $63.60 (invalid on today’s date) implies a Forecast Low P/E of 10.9: less than the above-stated 14.8. MS LSPF is 26.3% less than the default $5.83/share * 14.8 = $86.28 (also invalid on today’s date), which results in more conservative zoning. MS LSPF is still 83.3% greater than mine. Again, with MS having the low sample size, I am not surprised to see big differences (along with invalid ranges).
My TAR (over 15.0% preferred) is much less than the 38.8% from MS. Even discounting MOS relative to MS due to the low sample size, MS seems robust in the current study looking at my inputs relative to analyst estimates and historical ranges.
I track a few different valuation metrics. PEG is 0.94 per Zacks: slighly undervalued (something I very rarely see). Relative Value [(current P/E) / 5-year-mean average P/E] per M* is tremendously undervalued at 0.3. Kim Butcher’s “quick and dirty DCF” prices the stock at 11.0 * [$14.65 – ($4.00 + $5.65)] = $55.00: undervalued by 10.4%. Although I usually see these metrics conflict, they all agree here.
AAP is clearly not a high-quality growth stock right now. It does seem to be dirt cheap and a potential “value play.” This conservative analysis has it a BUY under $54/share. Do realize, though, that per Value Line the stock is down just over 60% over the last year, 3 years, and 5 years. Any investment should probably be done small in the speculative portion of the portfolio (if there is one) in case the doldrums—or worse—are to continue.
Categories: BetterInvesting® | Comments (0) | PermalinkNICE Stock Study (10-11-23)
Posted by Mark on January 5, 2024 at 06:16 | Last modified: October 11, 2023 10:45I recently did a stock study on Nice Ltd. ADR (NICE) with a closing price of $163.40. The original study is here.
M* writes:
> Nice is an enterprise software company that serves the customer
> engagement and financial crime and compliance markets. The company
> provides data analytics-based solutions through both a cloud
> platform and on-premises infrastructure. Within customer
> engagement, Nice’s CXone platform delivers solutions focused on
> contact center software and workforce engagement management,
> or WEM. Contact center offerings include solutions for digital
> self-service, customer journey and experience optimization, and
> compliance. WEM products optimize call center efficiency,
> leveraging data and AI analytics for call volume forecasting and
> agent scheduling. Within financial crime and compliance, Nice
> offers risk and investigation management, fraud prevention,
> anti-money laundering, and compliance solutions.
Over the past decade, this medium-size company has grown sales and EPS at 10.3% and 12.9% per year, respectively. Lines are mostly up, straight, and parallel except for a sales dip in ’15 and EPS dip in ’16. PTPM leads peer and industry averages while trending up from 8.8% (’13) to 15.8% (’22) with a last-5-year mean of 14.1%.
Also over the past decade, ROE leads peer and industry averages while trending up from 4.4% (’13) to 8.7% (’22) with a last-5-year mean of 7.9%. Debt-to-Capital is much lower than peer and industry averages with a last-5-year mean of 21.6%.
Quick Ratio is 2.0 and Interest Coverage is 21.8. Value Line assigns an A rating for Financial Strength while M* rates the company “Exemplary” for Capital Allocation.
With regard to sales growth:
- CNN Business projects 9.1% YOY and 8.7% per year for ’23 and ’22-’24, respectively (based on 12 analysts).
- YF projects YOY 8.5% and 11.1% for ’23 and ’24, respectively (14 analysts).
- Zacks projects YOY 8.3% and 11.7% for ’23 and ’24, respectively (6).
- Value Line projects 10.5% annualized growth from ’22-’27.
- CFRA projects 9.1% and 11.1% per year for ’22-’24 and ’22-’25, respectively.
- M* gives a 2-year ACE of 10.5% per year and projects 5-year annualized growth of 15.0% in its analyst note.
>
I am forecasting conservatively below the range at 8.0% per year.
With regard to EPS growth:
- CNN Business projects 11.0% YOY and 12.0% per year for ’23 and ’22-’24, respectively (based on 12 analysts), along with 5-year annualized growth of 12.0%.
- MarketWatch projects 12.7% and 13.7% per year for ’22-’24 and ’22-’25, respectively (15 analysts).
- Nasdaq.com projects 14.8% YOY and 15.7% per year for ’24 and ’23-’25 (7, 7, and 4 analysts for ’23, ’24, and ’25).
- Seeking Alpha projects 4-year annualized growth of 12.5%.
- YF projects YOY 18.0% and 11.9% for ’23 and ’24, respectively (13), along with 5-year annualized growth of 11.8%.
- Zacks projects YOY 11.8% and 12.0% for ’23 and ’24, respectively (8), along with 5-year annualized growth of 12.7%.
- Value Line projects 14.9% annualized growth from ’22-’27.
- CFRA projects 13.6% YOY for ’24 and a 3-year CAGR of 16.0%.
- M* projects long-term annualized growth of 13.4%.
>
I am forecasting conservatively below the long-term-estimate range (mean of six: 12.9%) at 11.0% per year and using ’22 EPS of $4.00/share as the initial value rather than 2023 Q2 $4.60 (annualized).
My Forecast High P/E is 40.0. Over the past decade, high P/E ranges from 29.9 in ’15 to 107.3 in ’21 with a last-5-year mean of 76.8 (last-10-year median is 47.5). The last-5-year-mean average P/E is 60.3. The most recent three years all seem extreme (96.9, 107.3, 76.5). The last-10-year mean excluding these is 40.8. I am forecasting just below the latter.
My Forecast Low P/E is 32.0. Over the past decade, low P/E ranges from 20.9 in ’15 to 41.2 in ’22 (excluding 70.9 in ’21). The last-5-year mean (outlier excluded) is 36.9 and the last-10-year median is 34.6. I am forecasting below the latter.
My Low Stock Price Forecast (LSPF) of $128.00 is default based on $4.00/share initial value. This is 21.7% less than the previous close and 20.1% less than the 52-week low.
Payout Ratio decreases from 53.9% in ’13 to zero in ’18 where it has remained ever since. I will not forecast a dividend until reason is given to do otherwise [interesting that while MS (see below) has a median value of zero, the mean is 7.2% as 16 studies have values of 6.9% or greater].
These inputs land NICE in the BUY zone with a U/D ratio of 3.0. Total Annualized Return (TAR) is 10.5%.
PAR (using Forecast Average—not High—P/E) of 8.2% 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 only 41 studies (my study and 20 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.0%, 12.2%, 44.3, and 32.0, respectively. I am lower on the first three and equal on the latter. Value Line’s projected average annual P/E of 30.5 is lower than MS (38.2) and lower than mine (36.0).
MS high / low EPS are $7.80 / $4.15 versus my $6.74 / $4.00 (per share). My high EPS is lower due to a lower growth rate. Value Line’s high EPS is $15.25. I am lowest of the three.
MS LSPF of $136.40 implies a Forecast Low P/E of 32.9: greater than the above-stated 32.0. MS LSPF is 2.6% less than the default $4.15/share * 32.0 = $132.80, which results in more conservative zoning. MS LSPF is still 6.6% greater than mine.
My TAR (over 15.0% preferred) is less than the 14.8% from MS. Although the MS sample size is somewhat small, MOS seems robust in the current study.
I track a few different [usually conflicting] valuation metrics. PEG is 1.5 and 2.9 per Zacks and my projected P/E, respectively: the latter significantly 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 22.0 * [$18.55 – ($0.00 + $0.95)] = $387.20 thus suggesting the stock to be 57.8% undervalued.
NICE is a BUY under $225. With a forecast high price of $270, TAR should meet my 15% criterion around $135/share.
Categories: BetterInvesting® | Comments (0) | PermalinkRHI Stock Study (10-5-23)
Posted by Mark on January 3, 2024 at 06:42 | Last modified: October 5, 2023 12:32I recently studied Robert Half Inc. (RHI) with a closing price of $73.59.
M* writes:
> Founded in 1948, Robert Half provides temporary, permanent,
> and outcome-based staffing for both in-person and remote
> positions in the finance and accounting, technology, legal,
> marketing, and administrative fields. Its subsidiary consulting
> arm, Protiviti, specializes in technology, risk, auditing, and
> compliance matters. The firm generates most of its sales inside
> the U.S. and stands as one of the largest specialized firms in
> the highly fragmented U.S. staffing industry. The firm
> generates annual revenue of around $7 billion.
Over the past decade, this medium-size company has grown sales and EPS at annualized rates of 4.7% and 11.8%. Lines are mostly up, straight, and parallel with a sales decline in ’20 along with EPS declines in ’16, ’17, and ’20. PTPM leads peer and most industry averages while ranging from 8.3% in ’20 to 12.4% in ’21 (and ’22) with a last-5-year mean of 10.7%.
Also over the past decade, ROE trails peer averages and is about even with the industry despite increasing from 28.0% (’13) to 43.6% (’22) with a last-5-year mean of 38.5%. Debt-to-Capital is lower than peer and industry averages as the company has no debt; the last-5-year mean is 13.8% (e.g. uncapitalized leases, rentals).
Quick Ratio is 1.3. Value Line gives an A+ rating for Financial Strength and M* rates “Exemplary” for Capital Allocation.
With regard to sales growth:
- CNN Business projects contraction of 6.9% YOY and 2.1% per year for ’23 and ’22-’24 (based on 12 analysts).
- YF projects YOY contraction of 11.3% and 0.3% for ’23 and ’24, respectively (14 analysts).
- Zacks projects YOY contraction of 11.9% and 0.6% for ’23 and ’24, respectively (5).
- Value Line projects 3.3% annualized growth from ’22-’27.
- CFRA ACE project contraction of 11.9% YOY and 2.9% per year for ’23 and ’22-’24, respectively.
- M* offers a 2-year ACE of 5.2% contraction per year and an analyst note projecting 5-year annualized growth of 3.2%.
>
I am discounting the long-term estimate to zero due to all the negative short-term projections.
With regard to EPS growth:
- CNN Business projects contraction of 25.2% YOY and 7.9% per year for ’23 and ’22-’24, respectively (based on 12 analysts), along with 5-year annualized growth of 0.8%.
- MarketWatch projects annualized contraction of 17.3% and 3.4% for ’22-’24 and ’22-’25, respectively (16 analysts).
- Nasdaq.com projects annualized growth of 8.3% and 25.1% for ’23-’25 and ’23-’26 (7/7/3 analysts for ’23/’25/’26).
- Seeking Alpha projects 4-year annualized growth of 0.8%.
- YF projects YOY contraction of 37.5% and 12.2% for ’23 and ’24, respectively (13), along with 5-year annualized contraction of 1.3%.
- Zacks projects YOY 38.3% contraction and 8.3% growth for ’23 and ’24, respectively (7).
- Value Line projects 4.5% annualized growth from ’22-’27.
- CFRA projects contraction of 38.1% YOY and 12.9% per year for ’23 and ’22-’24 along with a 3-year CAGR of +1.0%.
- M* projects long-term growth of 4.2% per year.
>
The data duplication concern is in play as two of the five long-term estimates are identical to the two decimal places given. These are CNN Business (FactSet) and Seeking Alpha (S&P Global), which are both at 0.78%. I will ignore because if duplicates, then the study is biased conservatively as I would like.
The mean of five long-term estimates is 1.8%. I will discount this to zero as my forecast. I will use ’22 EPS of $6.03/share [arbitrary] as high EPS and 2023 Q2 EPS of $5.04 (annualized) as [an arbitrary] low EPS in an effort to be conservative.
My Forecast High P/E is 17.0. Over the past decade, high P/E ranges from 17.7 in ’19 to 26.3 in ’14 with a last-5-year mean of 21.7. The last-5-year-mean average P/E of 17.0 is also my forecast and below the entire high P/E range.
My Forecast Low P/E is 11.0. Over the past decade, low P/E has decreased from 16.7 (’13) to 10.8 (’22) with a last-5-year mean of 12.4. I am forecasting near the bottom of the range (only ’22 is lower).
My Low Stock Price Forecast (LSPF) of $55.40 is default based on $6.03/share EPS. This is 24.7% less than the previous closing price and 14.4% less than the 52-week low.
Over the past decade, Payout Ratio ranges from 28.4% in ’21 to 50.4% in ’20 with a last-5-year mean of 34.1%. I am forecasting just below the range at 28.0%.
These inputs land RHI in the HOLD zone with a U/D ratio of 1.6. Total Annualized Return (TAR) is 8.6%.
PAR (using Forecast Average—not High—P/E) of 4.8% is less than the current yield on T-bills. If a healthy margin of safety (MOS) anchors this study, then I can proceed based TAR instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on only 43 studies (my study and 9 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.2%, 4.9%, 20.9, 13.9, and 34.1%, respectively. I am lower across the board. Value Line’s projected average annual P/E of 18.5 is higher than MS (17.4) and higher than mine (14.0).
Even though my intent is 0%, the website interprets my EPS growth forecast to be 3.7%. Since the initial value ($6.03) is greater than the last quarter ($5.04 annualized), positive growth is calculated. I would affirm the above analysis to still be correct, however, because analyst growth estimates are understood to be projected from the last completed FY.
MS high / low EPS are $6.43 / $3.87 versus my $6.04 / $5.04 (per share). My high EPS is lower due to a lower growth rate and much lower than Value Line’s $7.50. With regard to low EPS, I am puzzled because the largest grouping of MS studies [13, which amounts to 29.5% of the total] uses a low EPS of $2.67 – $2.77 with nine at $2.69. I might argue this to be unreasonably low. 2020 EPS is a downside excursion to $2.70/share (30.8% YOY contraction presumably due to COVID-19). Before that, I have to go back to ’17 to find a lower EPS number ($2.33) and ’15 EPS is exactly $2.69. Why these studies think the company could regress so far is an unanswered question.
MS LSPF of $49.70 implies a Forecast Low P/E of 12.8: less than the above-stated 13.9. MS LSPF is 7.6% less than the default $3.87/share * 13.9 = $53.79, which results in more conservative zoning. MS LSPF is also 10.3% less than mine.
My TAR (>15.0% preferred) is much less than the 14.8% from MS. Despite a small MS sample size, MOS seems robust in the current study.
I track a few different [usually conflicting] valuation metrics. PEG of 3.8 per my projected P/E is “significantly overvalued.” Relative Value [(current P/E) / 5-year-mean average P/E] per M* is slightly undervalued at 0.86. Kim Butcher’s “quick and dirty DCF” prices the stock at 17.0 * [$8.25 – ($2.72 + $0.70)] = $82.11, which suggests the stock to be 10.4% undervalued.
RHI is a BUY under $67. With a forecast high price of $102.70, TAR should meet my 15% criterion around $51/share.
Categories: BetterInvesting® | Comments (0) | PermalinkTTC Stock Study (10-3-23)
Posted by Mark on December 30, 2023 at 06:29 | Last modified: October 3, 2023 11:09I recently did a stock study on the Toro Co. (TTC) with a closing price of $82.85. The original study is here.
M* writes:
> The Toro Co manufactures turf maintenance and landscaping equipment.
> The company produces reel and rotary riding products, trim cutting and
> walking mowers, greens rollers, turf sprayer equipment, underground
> irrigation systems, heavy-duty walk-behind mowers, and sprinkler systems
> used for professional turf and landscape maintenance and construction.
> Its products are marketed through a network of distributors and dealers
> to primarily professional users maintaining turfs and sports fields such
> as golf courses. Its operating segments are Professional and
> Residential. The company also produces snow plowers and ice
> management products. Its largest end market is the United States.
Over the past decade, this medium-size company has grown sales and earnings at annualized rates of 8.8% and 13.0%, respectively. Lines are mostly up, straight, and parallel without a single YOY decline. PTPM lags peers and leads industry averages while ranging from 10.3% in ’19 to 14.2% in ’18 with a last-5-year mean of 12.3%.
Also over the past decade, ROE leads peer and industry averages despite falling from 39.3% (’13) to 33.9% (’22) with a last-5-year mean of 33.9%. Debt-to-Capital is higher than peer and industry averages with a last-5-year average of 40.9%.
Interest Coverage is 9.3 and Quick Ratio is 0.59. Value Line rates the company B++ for Financial Strength.
With regard to sales growth:
- CNN Business projects 6.7% YOY and 6.5% per year for ’23 and ’22-’24, respectively (based on 5 analysts).
- YF projects YOY 1.1% and 5.3% for ’23 and ’24, respectively (6 analysts).
- Zacks projects YOY 1.7% and 3.7% for ’23 and ’24, respectively (3).
- Value Line projects 6.9% annualized growth from ’22-’27.
- CFRA projects 1.1% YOY and 1.7% per year for ’23 and ’22-’24, respectively.
>
I am forecasting below the long-term estimates at 5.0% per year.
With regard to EPS growth:
- CNN Business projects 13.8% YOY and 12.3% per year for ’23 and ’22-’24, respectively (based on 5 analysts), along with 5-year annualized growth of 10.2%.
- MarketWatch projects 4.5% and 4.9% per year for ’22-’24 and ’22-’25, respectively (7 analysts).
- Nasdaq.com projects 16.2% and 11.7% per year for ’23-’25 and ’23-’26 (4, 4, and 2 analysts for ’23, ’25, and ’26).
- YF projects YOY 2.9% contraction and 11.5% growth for ’23 and ’24, respectively (7), along with 5-year annualized growth of 10.2%.
- Zacks projects YOY 2.9% contraction and 13.7% growth for ’23 and ’24, respectively (4).
- Value Line projects annualized growth of 10.8% from ’22-’27.
- CFRA projects 0.7% YOY contraction and 3.0% growth/year for ’23 and ’22-’24 along with a 3-year CAGR of 7.0%.
>
I am forecasting below the long-term estimate range (mean of three: 10.2%) at 8.0% per year. I will use 2023 Q3 EPS of $3.58/share (annualized) as the initial value rather than ’22 EPS of $4.20.
My Forecast High P/E is 24.0. Over the past decade, high P/E ranges from 21.4 in ’15 to 31.3 in ’21 with a last-5-year mean of 28.8. The last-5-year-mean average P/E is 24.2. I am forecasting just under the latter.
My Forecast Low P/E is 18.0. Over the past decade, low P/E ranges from 15.4 in ’13 to 21.7 in ’21 with a last-5-year mean of 19.7. I am forecasting below the latter.
My Low Stock Price Forecast (LSPF) of $64.40 is default based on $3.58/share initial value. This is 22.3% less than the previous closing price and 17.8% less than the 52-week low. While this is substantially lower than the latter, I stick to the 20.0% guideline; a small denominator is an easy way to bias U/D in favor of BUY.
Over the past decade, the lowest Payout Ratio is 21.4% in ’13 and the last-5-year mean is 31.4%. I am forecasting below the range at 21.0%.
These inputs land TTC in the HOLD zone with a U/D ratio of 2.0. Total Annualized Return (TAR) is 8.7%.
PAR (using Forecast Average—not High—P/E) of 5.9% 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 instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 74 studies (my study and 19 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 7.7%, 9.1%, 27.1, 18.7, and 31.3%, respectively. I am lower across the board. Value Line’s projected average annual P/E of 18.0 is less than MS (22.9) and less than mine (21.0).
MS high / low EPS are $6.80 / $4.48 versus my $5.02 / $3.58 (per share). My high EPS is lower due to a lower growth rate. Value Line’s high EPS is greater than both at $7.00.
MS LSPF of $73.70 implies a Forecast Low P/E of 16.5: less than the above-stated 17.8. MS LSPF is 12.0% less than the default $4.48/share * 18.7 = $83.78 [invalid on today’s date]. This results in more conservative zoning. MS LSPF is still 14.4% greater than mine.
My TAR (over 15.0% preferred) is much less than the 15.4% from MS. MOS seems robust in the current study.
I track a few different [usually conflicting] valuation metrics. PEG is 3.1 per my projected P/E: significantly overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is neutral at 0.95. Kim Butcher’s “quick and dirty DCF” prices the stock at 16.0 * [$7.95 – ($1.56 + $1.00)] = $86.24, which suggests it to be 3.9% undervalued.
TTC is a BUY under $78. With a forecast high price of $120.50, TAR should meet my 15% criterion closer to $60/share.
Categories: BetterInvesting® | Comments (0) | PermalinkLFUS Stock Study (9-28-23)
Posted by Mark on December 28, 2023 at 06:19 | Last modified: September 28, 2023 11:05I recently did a stock study on Littelfuse Inc. (LFUS) with a closing price of $243.51. Previous studies are here and here.
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.
Over the past decade, this medium-size company has grown sales and EPS at annualized rates of 13.6% and 13.8%, respectively. Lines are generally up and parallel with sales declines in ’19 and ’20 along with EPS declines in ’15, ’19, and ’20. PTPM leads peer and industry averages while appearing cyclical with a last-5-year mean of 13.6%.
Also over the past decade, ROE leads peer averages and is roughly even with the industry by decreasing from 13.4% (’13) to 8.5% (’20) and recovering to 17.7% (’22) for a last-5-year mean of 12.3%. Debt-to-Capital is lower than industry averages while exceeding peers by increasing from 24.2% (’13) to 32.4% (’22) for a last-5-year mean of 30.6%.
Interest Coverage is 11.6 and Quick Ratio is 1.7. Value Line rates the company B++ for Financial Strength and M* gives a “Standard” rating for Capital Allocation, writing that the company has a sound balance sheet and low net debt.
With regard to sales growth:
- CNN Business projects flat YOY and 2.0% growth per year for ’23 and ’22-’24, respectively (based on 4 analysts).
- YF projects YOY 5.3% contraction and 5.8% growth for ’23 and ’24, respectively (6 analysts).
- Zacks projects YOY 5.5% contraction and 5.3% growth for ’23 and ’24, respectively (3).
- Value Line projects 3.6% annualized growth from ’22-’27.
- CFRA gives ACE of 5.3% YOY contraction and flat growth per year for ’23 and ’22-’24, respectively (7).
- M* offers a 2-year ACE of 1.3% annualized growth.
>
I am discounting the long-term estimate by nearly half to 2.0% per year due to the negative short-term projections.
With regard to EPS growth:
- CNN Business projects contraction of 19.2% YOY and 6.4% per year for ’23 and ’22-’24, respectively (based on 4 analysts), along with 5-year annualized growth of 12.0%.
- MarketWatch projects contraction of 27.2% YOY and 10.0% per year for ’23 and ’22-’24, respectively (7 analysts).
- Nasdaq.com projects 13.1% YOY growth for ’24 (3).
- Seeking Alpha projects 4-year annualized growth of 12.0%.
- YF projects YOY 28.4% contraction and 14.4% growth for ’23 and ’24, respectively (6), along with 5-year annualized growth of 10.3%.
- Zacks projects YOY 29.1% contraction and 13.1% growth for ’23 and ’24, respectively (3), along with 5-year annualized growth of 12.0%.
- Value Line projects 2.7% annualized growth from ’22-’27.
- CFRA projects contraction of 19.3% YOY and 4.6% per year for ’23 and ’22-’24, respectively (7).
- M* provides long-term ACE of 8.1% 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 the statistical array projects as stated above.
I wonder about data duplication with companies covered by few analysts. Three of the six long-term estimates here are exactly 12.0% (not 11.8%, 12.1%, etc.) despite coming from three different data sources; could those be the same analysts?
The mean of 6 long-term estimates is 9.5%. If I count the duplicate estimates just once, then the mean (4 estimates) is 8.3%. I am cutting this by ~40% to get my 5.0% per year forecast. I will use 2023 Q2 EPS of $13.09/share (annualized) as the initial value rather than ’22 EPS of $14.94 to be conservative.
My Forecast High P/E is 21.0. Over the past decade, high P/E goes from 24.1 in ’13 to 48.5 in ’20 then back to 21.9 in ’22. The last-5-year mean high P/E is 34.6 and the last-5-year-mean average P/E is 27.7. I am forecasting below the entire range.
My Forecast Low P/E is 14.0. Over the past decade, low P/E goes from 15.3 in ’13 to 28.2 in ’17 before retreating to 12.9 in ’22. The last-5-year mean is 20.7. I am forecasting near the bottom of the range (only ’22 is lower).
My Low Stock Price Forecast (LSPF) of $183.30 is default based on $13.78/share EPS. This is 24.7% less than the previous closing price and 4.6% less than the 52-week low.
Over the past decade, Payout Ratio ranges 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.0%.
These inputs land LFUS in the HOLD zone with a U/D ratio of 1.8. Total Annualized Return (TAR) is 8.3%.
PAR (using Forecast Average—not High—P/E) of 4.6% 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 instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 114 studies (my study and 43 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 7.8%, 8.3%, 26.0, 17.8, and 26.5%, respectively. I am lower across the board. Value Line’s projected average annual P/E of 22.0 is just higher than MS (21.9) and much higher than mine (17.5).
MS high / low EPS are $19.68 / $13.28 versus my $16.71 / $13.09 (per share). My high EPS is lower due to a lower growth rate. Value Line’s high EPS is $19.25. I am lowest of the three.
MS LSPF of $189.30 implies a Forecast Low P/E of 14.3: less than the above-stated 17.8. MS LSPF is 19.9% less than the default $13.28/share * 17.8 = $236.38, which results in more conservative zoning. MS LSPF is still 3.3% greater than mine.
My TAR (over 15.0% preferred) is much less than the 16.1% from MS. MOS seems robust in the current study.
I track a few different [usually conflicting] valuation metrics. PEG is 1.7 and 3.5 per Zacks and my projected P/E, respectively: the latter significantly overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is cheap at 0.7. Kim Butcher’s “quick and dirty DCF” prices the stock at 16.0 * [$24.20 – ($3.00 + $4.20)] = $272.00, which suggests the stock to be 10.5% undervalued.
LFUS is a BUY under $225. With a forecast high price at $350.80, TAR should meet my 15% criterion around $175/share.
Categories: BetterInvesting® | Comments (0) | PermalinkAL Stock Study (10-16-23)
Posted by Mark on December 27, 2023 at 06:41 | Last modified: October 16, 2023 13:35I recently did a stock study on Air Lease Corp. (AL) with a closing price of $35.74. Previous studies are here and here.
M* writes:
> Air Lease Corp is an aircraft leasing company based in the
> United States. However, it derives its revenue from the Asia
> region. Its business involves purchasing aircraft from
> renowned manufacturers such as The Boeing Company
> (Boeing) and Airbus S.A.S and leasing them to airline
> companies across the world. Its suite of aircraft entails
> single-aisle narrow-bodied jets and twin-aisle wide-bodied
> aircraft. The company’s primary source of revenue
> originates from the leasing of aircraft and to a
> certain extent from the provision of fleet management
> services to investors and owners of aircraft portfolios.
Over the past decade, this medium-size company has grown sales 11.1% per year. Earnings have grown 11.3% per year from ’13-’21. I am excluding the 2022 GAAP loss of $1.24/share 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.
Excluding ’22, sales are up and mostly straight while earnings peak in ’19 (excluding ’17 when EPS spikes ~100% due to TCJA). PTPM is higher than peer and industry averages by increasing from 34.2% in ’13 to 40.9% in ’16 before heading down to 25.9% in ’21 for a last-5-year mean (excluding ’22) of 33.2%.
ROE is slightly better than peer averages and mostly lower than the industry in going 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 mean (excluding ’22) of 9.1%. This is slightly better than peer averages and mostly less than than the industry.
Debt-to-Capital averages 71.8% over the last five years, which is less than than peer and industry averages but still uncomfortably high. M* lists Interest Coverage as 13.0 and Quick Ratio as 0.37. FCF has been negative since at least ’20.
Despite the red flags, M Ramirez writes in this 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.
With regard to sales growth:
- CNN Business projects 17.4% YOY and 16.1% per year for ’23 and ’22-’24, respectively (based on 7 analysts).
- YF projects YOY 16.0% and 12.0% for ’23 and ’24, respectively (7 analysts).
- Zacks projects YOY 15.4% and 11.2% for ’23 and ’24, respectively (3).
- CFRA provides ACE of 16.1% growth YOY and 14.0% per year for ’23 and ’22-’24, respectively (7).
- M* gives an ACE of 16.7% per year for the next two years.
>
I am forecasting below the range at 11.0% per year.
With regard to EPS growth:
- CNN Business projects 19.0% YOY for ’24 (based on 7 analysts) along with 5-year annualized growth of 9.8%.
- MarketWatch projects 24.1% YOY and 21.3% per year for ’24 and ’23-’25, respectively (7 analysts).
- Nasdaq.com projects 21.6% YOY and 27.6% per year for ’24 and ’23-’25 [5, 5, and 1 analyst(s) for ’23, ’24, and ’25].
- Seeking Alpha projects 4-year annualized growth of 9.8%.
- YF projects 30.4% YOY growth for ’24 (7) along with 5-year annualized growth of 26.2%.
- Zacks projects 21.6% YOY for ’24 (5) along with 5-year annualized growth of 9.8%.
- Value Line projects 13.9% from ’23 to ’24/’25 and provides an ACE (5) of 9.8% per year for the next five years.
- CFRA projects growth of 21.4% YOY for ’24 (2).
>
Three of four long-term estimates are 9.8% with the fourth extremely high. I am disregarding the latter in case it was calculated off a negative base and forecasting below the former at 7.0%. Sans write-off (discussed above), I calculate ’22 earnings at $5.67/share rather than -$1.24. This results in high EPS of $7.95/share.
My Forecast High P/E is 9.0. From ’13-’21, high P/E ranges from 7.2 in ’17 to 18.6 in ’13 with a last-5-year mean of 11.7. The last-5-year-mean average P/E is 9.5. I am forecasting near the bottom of the range (only ’17 is lower).
My Forecast Low P/E is 5.5. From ’13-’21, low P/E ranges from 5.0 in ’17 (1.9 in ’20 excluded due to COVID-19) to 14.6 in ’14 with a last-5-year mean of 7.4 . I am forecasting near the bottom of the range (only ’17 is lower).
My Low Stock Price Forecast (LSPF) of $24.80 is default based on $4.50/share initial value. This is 30.6% less than the previous close and 18.2% less than the 52-week low.
Over the past decade, Payout Ratio has ranged from 4.8% in ’17 to 18.6% in ’21 with a last-5-year mean of 13.1% (2022 NMF excluded). I am forecasting conservatively at 5.0%.
These inputs land AL in the BUY zone with a U/D ratio of 3.3. Total Annualized Return (TAR) is 15.4%.
PAR (using Forecast Average—not High—P/E) of 10.7% 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 185 studies over the past 90 days (my study and 72 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 11.6%, 11.9%, 11.0, 6.0, and 9.0%, respectively. I am lower across the board.
MS high/low EPS is $7.53/$4.20 vs. my $7.93/$5.67 (per share). My high EPS is higher due to the higher initial value. As evidenced by MS mean EPS growth of 39.0%,others have also dealt with significant confusion in figuring out how to deal with negative EPS in ’22. This somewhat obscures my ability to determine MOS because MS data are highly scattered.
MS LSPF of $27.70 implies a Forecast Low P/E of 6.6 vs. the above-stated 6.0. MS LSPF is 9.9% greater than the default value of $4.20/share * 6.0 = $25.20, which results in more aggressive zoning. MS LSPF is also 11.7% greater than mine.
My TAR (over 15.0% preferred) is less than MS 17.5%. Despite a higher EPS range, MOS seems robust in the current study.
I track a few different valuation metrics. PEG is 0.8 and 1.4 per Zacks and my projected P/E, respectively: both quite reasonable. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is also reasonable at 0.9. For once, these metrics are in relative agreement with each other.
AL is a BUY under $36. With a forecast high price at $71.30, TAR should meet my 15% criterion right about now.
Categories: BetterInvesting® | Comments (0) | PermalinkDORM Stock Study (9-27-23)
Posted by Mark on December 26, 2023 at 06:43 | Last modified: September 27, 2023 11:37I recently did a stock study on Dorman Products Inc. (DORM) with a closing price of $73.66.
M* writes:
> Dorman Products Inc is a supplier of original equipment parts
> for automobiles. The company produces automotive and heavy-
> duty replacement parts, automotive hardware, brake parts, and
> fasteners for the automotive and heavy-duty aftermarket. The
> products are sold under the Dorman brand and its sub-brands
> OE Solutions, Help!, Conduct-Tite, and HD Solutions through
> aftermarket retailers, regional and local warehouse
> distributors, specialty markets, and salvage yards. It
> operates as a single reportable operating segment, namely,
> the sale of replacement and upgrades parts in the motor
> vehicle aftermarket industry, serving passenger cars, light-,
> medium-,and heavy-duty trucks as well as specialty vehicles.
> The company operates primarily in the United States.
Over the past decade, this medium-size company has grown sales and EPS at annualized rates of 9.4% and 5.8%, respectively. Lines are up, somewhat straight, and [I stretch to say] parallel. Admittedly, visual inspection is not great due to EPS declines in ’19 (big) and ’22 making growth look inconsistent [’23 looks to be challenging as well: see below]. PTPM leads peer and industry averages despite falling from 19.2% (’13) to 9.0% (’22) with a last-5-year mean of 12.5%.
Also over the past decade, ROE is roughly even with the industry and higher than peer averages while falling from 20.8% (’13) to 11.9% (’22) with a last-5-year mean of 13.7%. Debt-to-Capital is less than peer and industry averages despite increasing from 0% (through ’18) to 44.4% in ’22 with a last-5-year mean of 15.2%.
Interest Coverage is 4.0 and Quick Ratio is 0.9. Value Line gives a B++ rating for Financial Strength.
With regard to sales growth:
- CNN Business projects 17.6% YOY and 11.1% per year for ’23 and ’22-’24 (based on 4 analysts).
- YF projects YOY 14.3% and 6.0% for ’23 and ’24, respectively (3 analysts).
- Zacks projects YOY 14.2% and 6.9% for ’23 and ’24, respectively (3).
- Value Line projects 8.0% annualized growth from ’22-’27.
- CFRA projects 13.8% YOY and 10.2% per year for ’23 and ’22-’24, respectively (3).
- M* gives a 2-year ACE of 10.3% per year.
>
I am forecasting below the long-term estimate at 6.0% per year.
With regard to EPS growth:
- CNN Business projects 8.0% YOY and 11.7% per year for ’23 and ’22-’24, respectively (based on 4 analysts), along with 5-year annualized growth of 14.0%.
- MarketWatch projects 12.4% and 10.4% annualized for ’22-’24 and ’22-’25, respectively (4 analysts).
- Nasdaq.com projects 17.4% YOY and 11.8% per year for ’24 and ’23-’25 [4, 4, and 1 analyst(s) for ’23, ’24, and ’25].
- YF projects YOY 8.2% and 17.7% for ’23 and ’24, respectively (4), along with 5-year annualized growth of 15.0%.
- Zacks projects YOY 8.4% and 17.4% for ’23 and ’24, respectively (3).
- Value Line projects 13.2% annualized growth from ’22-’27.
- CFRA projects 34.3% YOY and 24.5% per year for ’23 and ’22-’24, respectively (3).
>
I am forecasting below the long-term-estimate range (mean of three: 14.1%) at 10.0% per year.
Determining the initial value is a bit more complex. 2023 EPS are tracking much lower than ’22 for the first six months. According to the 10-Q:
> The increase in SG&A as a percentage of net sales was
> primarily due to the impact of higher interest rates on
> our customer accounts receivable factoring programs and
> the addition of SuperATV, which has higher SG&A expenses
> as a percentage of net sales than the Company average.
> SG&A expenses as a percentage of net sales also increased
> in the three months ended April 1, 2023 as a result of a
> charge recorded related to a customer bankruptcy filing.
The bankruptcy filing is a nonrecurring event. SuperATV (recent takeover target) seems recurring. I don’t know if “factoring programs” are ongoing or nonrecurring and I don’t know how much of each contributes to the total difference.
Given the uncertainty, I feel the need to use the depressed EPS for initial value in an effort to be conservative. I do find it odd that no short- or long-term EPS projections are negative when 2023 Q1 and Q2 are tracking significantly below ’22 values. Nevertheless, I will use 2023 Q2 EPS of $2.76/share (annualized) as the initial value rather than ’22 EPS of $3.85.
My Forecast High P/E is 24.0. Over the past decade, high P/E ranges from 20.7 in ’15 to 38.0 in ’19 with a last-5-year mean of 30.4. The last-5-year-mean average P/E is 24.7. I am forecasting below the latter [only ’15 (20.7) and ’18 (22.7) are lower].
My Forecast Low P/E is 13.0. Over the past decade, low P/E ranges from 13.1 in ’16 to 26.3 in ’19 with a last-5-year mean of 19.0. I am forecasting below the entire range.
My Low Stock Price Forecast (LSPF) is $58.00. The default LSPF of $35.90 is 51.3% less than the previous close and 51.0% less than the 52-week low. I find this unreasonable. With the stock currently at the 52-week low, I am discounting 21.3% to get my LSPF. This implies a Forecast Low P/E of 58 / 2.76 = 21.0.
These inputs land DORM in the HOLD zone with a U/D ratio of 2.1. Total Annualized Return (TAR) is 7.7%.
PAR (using Forecast Average—not High—P/E) of 2.2% 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 instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on only 32 studies (my study and 8 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 8.7%, 10.6%, 25.8, and 16.6, respectively. I am lower across the board [except perhaps for my implied Forecast Low P/E that has been effectively raised by overriding LSPF; I’ll see below whether MS has done the same]. Value Line’s projected average annual P/E of 20.0 is lower than MS (21.2) and mine (18.5).
MS high / low EPS are $5.50 / $2.78 vs. my $4.44 / $2.76 (per share). My EPS range is lower and my low EPS is lower. Value Line has high EPS at $8.85/share: much higher than both.
MS LSPF of $53.60 implies a Forecast Low P/E of 19.3, which is greater than the above-stated 16.6 [not nearly as big a difference as my implied Forecast Low P/E]. MS LSPF is 16.2% greater than the default $2.78/share * 16.6 = $46.15, which results in more aggressive zoning. MS LSPF is more conservative than mine, however, being 7.6% less.
My TAR (over 15.0% preferred) is much less than the 12.1% from MS.
Despite raising LSPF to something that seems reasonable at the moment, MOS seems robust in this study. My final buy/sell decisions are based more on TAR/PAR than they are upside/downside ratio. While the latter will qualify a potential BUY, I use the former to finalize it.
I track a few different [usually conflicting] valuation metrics. PEG of 2.4 based on my projected P/E suggests the stock to be overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* agrees at 1.1. Kim Butcher’s “quick and dirty DCF” prices the stock at 16.0 * [$11.40 – ($0.00 + $1.30)] = $161.60, which suggests the stock to be 54.4% undervalued [this strikes me as NMF as I continue to evaluate the utility of this metric].
DORM is a BUY under $70. With a forecast high price at $106.60, TAR should meet my 15% criterion around $53/share.
Categories: BetterInvesting® | Comments (0) | PermalinkNAPA Stock Study (10-10-23)
Posted by Mark on December 23, 2023 at 06:14 | Last modified: October 10, 2023 10:53I recently did a stock study on Duckhorn Portfolio Inc. (NAPA) with a closing price of $9.87. The original study is here.
Value Line writes:
> The Duckhorn Portfolio, Inc. produces and sells wines in North America.
> It offers wines under a portfolio of brands, including Duckhorn
> Vineyards, Decoy, Goldeneye, Paraduxx, Migration, Canvasback, Calera,
> Kosta Browne, Greenwing, and Postmark. The company sells wines to
> distributors, and directly to retail accounts and consumers. The
> company was formerly known as Mallard Intermediate, Inc. and changed
> its name to The Duckhorn Portfolio, Inc. in February 2021. The Duckhorn
> Portfolio, Inc. was founded in 1976 and is headquartered in Saint
> Helena, California. The Duckhorn Portfolio, Inc. operates as a
> subsidiary of Mallard Holding Company, Llc.
This small-size company went public in 2021 and has financials available since 2019. Over that time, Duckhorn has grown sales and EPS at 14.4% and 33.4% per year, respectively. Lines are mostly up, straight, and parallel.
Over the past five years, PTPM leads (trails) peer (industry) averages while increasing from 12.4% (’19) to 23.4% (’23) with a last-5-year mean of 19.3%. Debt-to-Capital is down from 40.1% (’19) to 21.2% (’23) with a last-5-year mean of 28.8%.
ROE is lower than industry averages and about even with peers with a last-3-year mean of 7.3%.
Current Ratio is 5.2, Quick Ratio is 0.7, and Interest Coverage is 9.1. Value Line assigns a B+ rating for Financial Strength.
With regard to sales growth:
- CNN Business projects 8.2% YOY and 7.5% per year for ’24 and ’23-’25 (based on 8 analysts; FY ends Jul 31).
- YF projects YOY 5.4% and 7.4% for ’24 and ’25, respectively (8 analysts).
- Zacks projects YOY 5.5% and 7.2% for ’24 and ’25, respectively (2).
- Value Line projects 5.5% annualized growth from ’23-’27.
- CFRA projects 5.5% YOY and 6.5% per year for ’24 and ’23-’25, respectively (6).
- M* gives a 2-year ACE of 7.2% annualized growth.
>
I am forecasting conservatively below the range at 4.0% per year.
With regard to EPS growth:
- CNN Business projects 6.0% YOY and 7.2% per year for ’24 and ’23-’25, respectively (based on 8 analysts), along with 5-year annualized growth of 7.8%.
- MarketWatch projects 7.4% and 6.7% per year for ’23-’25 and ’23-’26, respectively (8 analysts).
- Nasdaq.com projects 10.9% YOY and 11.1% per year for ’25 and ’24-’26 [2, 2, and 1 analyst(s) for ’24, ’25, and ’26].
- Seeking Alpha projects 4-year annualized growth of 7.6%.
- YF projects YOY 1.5% and 10.3% for ’24 and ’25, respectively (8), along with 5-year annualized growth of 7.5%.
- Zacks projects YOY 3.0% and 8.7% for ’24 and ’25, respectively (2), along with 5-year annualized growth of 7.4%.
- Value Line projects 6.1% annualized growth from ’23-’27.
- CFRA projects 13.3% YOY and 11.8% per year for ’23 and ’22-’24, respectively (7).
>
I am forecasting conservatively below the long-term-estimate range (mean of five: 7.3%) at 5.0% per year and using 2023 EPS of $0.60/share as the initial value.
My Forecast High P/E is 30.0. High P/E over the last three years (only data available) is 47.2, 48.6, and 32.3 (mean 42.7). The last-3-year-mean average P/E is 35.5. I am forecasting below the range.
My Forecast Low P/E is 12.0. Low P/E over the last three years (only data available) is 31.1, 33.1, and 20.7 (mean 28.3). I am forecasting well below the range.
My Low Stock Price Forecast (LSPF) of $7.20 is default based on $0.60/share initial value. This is 27.1% less than the previous close and 22.6% less than the 52-week low.
These inputs land NAPA in the BUY zone with a U/D ratio of 4.9. Total Annualized Return (TAR) is 18.5%.
PAR (using Forecast Average—not High—P/E) of 10.4% is less than I seek for a small-size company. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on TAR instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on only three studies (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 8.0%, 7.0%, 41.7, and 23.0, respectively. I am lower across the board. Value Line’s projected average annual P/E of 25.0 is lower than MS (32.4) and higher than mine (21.0).
MS high / low EPS are $0.76 / $0.50 versus my $0.77 / $0.60 (per share). My range is probably higher due to a higher initial value (the recently-released 2023 EPS). Value Line’s high EPS is $0.85: highest of the three.
MS LSPF of $11.70 (invalid on today’s date) implies a Forecast Low P/E of 23.4: greater than the above-stated 23.0. MS LSPF is 1.7% greater than the default $0.50/share * 23.0 = $11.50, which is also invalid on today’s date. MS LSPF is 62.5% greater than mine. The small sample size is not helping MS here as one study with questionable judgment (e.g. about one week ago) can substantially affect the average.
My TAR (over 15.0% preferred) is less than the 19.7% from MS. While I cannot use MS as a valid comparison due to the tiny sample size, I think MOS seems robust in the current study. My growth rates are less than analyst estimates and my P/E range is lower than brief history.
I track a few different [usually conflicting] valuation metrics. PEG is 2.0 and 3.1 per Zacks and my projected P/E, respectively: both overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is very low at 0.5.
NAPA is a BUY under $11 and TAR meets my 15% criterion right now. The stock is down nearly 25% since July (also explains MS LSPF), but fundamentals don’t seem affected. The biggest knock against this company may be its short data history.
Categories: BetterInvesting® | Comments (0) | PermalinkMYRG Stock Study (9-26-23)
Posted by Mark on December 22, 2023 at 06:32 | Last modified: September 26, 2023 11:07I recently did a stock study on MYR Group, Inc. (MYRG) with a closing price of $136.97.
M* writes:
> MYR Group Inc is a U.S.-based holding company that provides
> specialty electrical construction services through its
> subsidiaries. The company operates through two segments.
> The transmission and distribution segment provides designing,
> engineering, procurement, construction, upgrade, maintenance,
> and repair services on transmission and distribution network
> and substation facilities. The commercial and industrial
> segment provides services such as the design, installation,
> maintenance, and repair of commercial and industrial wiring,
> installation of traffic networks, and the installation of
> bridges. MYR Group generates the majority of its sales from
> the United States and Canada.
Over the past decade, this medium-size company has grown sales and EPS at annualized rates of 15.1% and 16.1%, respectively. Lines are mostly up, straight, and parallel except for EPS declines in ’15, ’16, and ’22. PTPM roughly matches industry averages but trails peers as it declines from 6.1% (’13) to 3.8% (’22) with a last-5-year mean of 3.5%.
Also over the past decade, ROE leads peer and industry averages by increasing from 12.0% (’13) to 15.2% (’22) with a last-5-year mean of 13.4%. Debt-to-Capital is far below peer and industry averages, ranging from 0% (through ’15) to 34.3% in ’19 with a last-5-year mean of 16.7%.
Interest Coverage is 29.7 and Quick Ratio is 1.3. Value Line gives a B+ rating for Financial Strength and M* assigns the company a “Narrow” economic moat.
With regard to sales growth:
- CNN Business projects 10.0% and 8.0% per year for ’23 and ’22-’24, respectively (based on 2 analysts).
- YF projects YOY 16.0% and 6.0% for ’23 and ’24, respectively (2 analysts).
- Zacks projects YOY 12.0% and 8.1% for ’23 and ’24, respectively (1).
- Value Line projects 13.6% annualized growth from ’22-’27.
- CFRA projects 15.5% YOY and 10.9% per year for ’23 and ’22-’24, respectively (3).
>
I am discounting the long-term estimate to 9.0% per year based on lower short-term growth projections.
With regard to EPS growth:
- CNN Business projects 17.7% YOY and 18.3% per year for ’23 and ’22-’24, respectively (based on 2 analysts), along with 5-year annualized growth of 20.0%.
- MarketWatch projects 24.2% and 24.6% per year for ’22-’24 and ’22-’25, respectively (3 analysts).
- Nasdaq.com projects 19.8% YOY for ’24 (1).
- Seeking Alpha projects 4-year annualized growth of 15.0%.
- YF projects YOY 17.3% and 18.9% for ’23 and ’24, respectively (2), along with 5-year annualized growth of 20.0%.
- Zacks projects YOY 19.4% and 19.8% for ’23 and ’24, respectively (1).
- Value Line projects 21.1% annualized growth from ’22-’27.
- CFRA projects 17.3% YOY and 19.1% per year for ’23 and ’22-’24, respectively (3).
>
I am forecasting below the long-term-estimate range (mean of four: 19.0%) at 14.0%. I will use ’22 EPS of $4.91 rather than 2023 Q2 EPS of $5.26/share (annualized).
My Forecast High P/E is 20.0. Over the past decade, high P/E ranges from 16.8 in ’14 to 34.2 in ’17 with a last-5-year mean of 20.7 and last-10-year median of 22.3. My forecast is below these averages. The last-5-year-mean average P/E is 16.1.
My Forecast Low P/E is 13.0. Over the past decade, low P/E ranges from 4.7 (downside outlier in ’20) to 18.0 in ’17 with a last-5-year mean of 13.1 (excluding the outlier). I am forecasting just below the latter.
My Low Stock Price Forecast (LSPF) is $77.00. The default based on $4.91/share initial value is $63.80, which is 53.4% less than the previous close. I am overriding this to the 52-week low price that is still 43.8% less than the previous close and implies a Forecast Low P/E of 15.7.
These inputs land MYRG in the HOLD zone with a U/D ratio of 0.9. Total Annualized Return (TAR) is 6.7%.
PAR (using Forecast Average—not High—P/E) of 4.3% 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 instead.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on only 72 studies (my study and 22 other 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 11.7%, 12.1%, 21.5, and 12.5, respectively. My EPS growth rate and Forecast Low P/E are both higher. Value Line’s projected average annual P/E of 18.0 is higher than MS (17.0) and mine (17.5).
MS high / low EPS are $9.23 / $4.74 versus my $9.45 / $4.91 (per share). These are roughly equal and far below Value Line’s $12.80 high EPS.
MS LSPF of $69.50 implies a Forecast Low P/E of 14.7: greater than the above-stated 12.5. MS LSPF is 17.3% greater than than the default $4.74/share * 12.5 = $59.25, which results in more aggressive zoning. MS LSPF is still 9.7% less than mine.
My TAR (over 15.0% preferred) is slightly less than the 7.0% from MS. MOS seems weak in the current study. While selecting inputs, I noticed this when choosing Forecast High P/E, Forecast Low P/E, and LSPF.
I track a few different valuation metrics. PEG is 1.6 per my projected P/E (based on what may be a relatively high EPS growth rate): slightly overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is about as expensive as I have ever seen at 1.6. Kim Butcher’s “quick and dirty DCF” prices the stock at 13.0 * [$16.85 – ($0.00 + $6.25)] = $137.80, which suggests the stock to be 0.6% undervalued.
MYRG is a BUY under $105. With a forecast high price of $189.10, TAR should meet my 15% criterion around $95/share.
Categories: BetterInvesting® | Comments (0) | PermalinkARW Stock Study (9-21-23)
Posted by Mark on December 20, 2023 at 07:00 | Last modified: September 21, 2023 14:46I recently did a stock study on Arrow Electronics, Inc. (ARW) with a closing price of $127.90.
Value Line writes:
> Arrow Electronics, Inc. is a global distributor of electronic
> components and computer products to industrial and commercial
> customers. Has over 220 selling locations and 43 distribution
> centers in more than 90 countries and territories. Semiconductor
> and computer products in ’22 accounted for 78% and 22%, resp.,
> of sales. Geographic sales: Americas, 39%; Europe, 30%;
> Asia/Pacific, 31%. Acquired: Circle IT, ’21; eInfochips, ’18;
> EE times, ’16; immixGroup, ’15; Nu Horizons, ’11.
Over the past decade, this large-size company has grown sales and EPS at annualized rates of 6.0% and 18.0%, respectively (I am excluding ’19 EPS of -$2.44 from my analysis as Value Line and CFRA both normalize as a nonrecurring event). Lines are up, straight, and narrowing except for sales dips in ’19 and ’20 and EPS declines in ’17 and ’20. PTPM is greater than peer and industry averages and recently trending higher, increasing from 2.7% (’13) to 5.1% (’22) with a last-5-year mean of 3.8%.
Also over the past decade, ROE leads peer and industry averages while trending up from 9.6% (’13) to 24.6% (’22) with a last-5-year mean of 17.3%. Debt-to-Capital is higher than peer and industry averages, however, ranging from 30.7% in ’20 to 40.5% in ’22 with a last-5-year mean of 36.4%.
Interest Coverage is 6.7 and Quick Ratio is 2.1. Value Line gives an A rating for Financial Strength.
With regard to sales growth:
- CNN Business projects contraction of 7.3% YOY and 5.3% per year for ’23 and ’22-’24 (based on 7 analysts).
- YF projects YOY contraction of 9.8% and 4.7% for ’23 and ’24, respectively (7 analysts).
- Zacks projects YOY contraction of 10.0% and 5.5% for ’23 and ’24, respectively (4).
- Value Line projects 2.5% annualized growth from ’22-’27.
- CFRA projects contraction of 9.8% YOY and 7.6% per year for ’23 and ’22-’24, respectively.
>
I am discounting the long-term estimate to 0% due to unanimous projection of short-term contraction.
With regard to EPS growth:
- CNN Business projects contraction of 26.2% YOY and 16.5% per year for ’23 and ’22-’24, respectively (based on 7 analysts), along with 5-year annualized contraction of 5.1%.
- MarketWatch projects annualized contraction of 18.0% and 2.6% for ’22-’24 and ’22-’25, respectively (8 analysts).
- Nasdaq.com projects contraction of 8.1% YOY and 17.7% growth per year for ’24 and ’23-’25, respectively [5, 5, and 1 analyst(s) for ’23, ’24, and ’25].
- Seeking Alpha projects 4-year annualized contraction of 5.1%.
- YF projects YOY contraction of 27.5% and 7.5% for ’23 and ’24, respectively (7), along with 5-year annualized contraction of 8.1%.
- Zacks projects YOY contraction of 28.2% and 8.1% for ’23 and ’24, respectively (5), along with 5-year annualized growth of 4.0%.
- Value Line projects 5.0% annualized growth from ’22-’27.
- CFRA projects contraction of 27.7% YOY and 18.1% per year for ’23 and ’22-’24.
>
Three of five long-term estimates are negative (mean: -1.9%). I am forecasting below at -3.0% per year. I will use 2023 Q2 EPS of $19.65/share (annualized) as the initial value for high EPS rather than ’22 EPS of $21.80. For low EPS, I will use ’21 EPS of $15.10 (arbitrary).
My Forecast High P/E is 9.0. Over the past decade, high P/E ranges from 6.3 in ’22 to 18.9 in ’17 with a last-10-year median of 12.7 and a last-5-year-mean average P/E of 7.9. The last-5-year mean is 9.9. I am forecasting below the latter (not particularly conservative).
My Forecast Low P/E is 6.0. Over the past decade, low P/E ranges from 4.1 in ’22 to 15.3 in ’17 with a last-5-year mean of 5.9. I am forecasting just above the latter (not conservative).
My Low Stock Price Forecast (LSPF) of $90.60 is default based on $15.10/share initial value. This is 29.2% less than the previous closing price but 1.3% above the 52-week low.
These inputs land ARW in the HOLD zone with a U/D ratio of 0.7. Total Annualized Return (TAR) is 3.6%.
PAR (using Forecast Average—not High—P/E) is negative, which is likely a SELL anytime I see it. If a healthy margin of safety (MOS) anchors this study, then I can proceed based on TAR instead but even that is less than the current yield on T-bills.
To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on only 4 studies (my study and 2 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 5.0%, 5.1%, 9.6, and 7.7, respectively. I am lower across the board. Value Line’s projected average annual P/E of 8.0 is lower than MS (8.7) but higher than mine (7.5).
MS high/low EPS are $28.25/$19.66 vs. my $16.87/$15.10 (per share). Value Line’s high EPS is $28.50. I am far below either.
MS LSPF of $68.50 implies a Forecast Low P/E of 3.5, which is substantially less than the above-stated 7.7. MS LSPF is 54.8% less than the default $19.66/share * 7.7 = $151.38 (invalid on today’s date), which results in more conservative zoning. MS LSPF is also 32.3% less than mine. This does not give me confidence in MS estimates given the tiny sample size (4).
My TAR (I prefer >15.0%) is much less than the 14.9% from MS. Again, this shouldn’t factor much into my MOS assessment due to the tiny sample size.
I categorize MOS as moderate. My inputs are at or below the averages. My initial values seem adequately discounted.
I track a few different valuation metrics. PEG is 2.0 and 2.2 per Zacks and my projected P/E, respectively: both overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is undervalued at 0.82. Kim Butcher’s “quick and dirty DCF” prices the stock at 6.5 * [$33.30 – ($0.00 + $2.50)] = $200.20, which suggests the stock to be 36.1% undervalued. These last two metrics are encouraging [if I could believe in them; the three metrics rarely align].
Based on this study, ARW is a BUY under $105/share. To meet my personal TAR criterion, I need closer to $76. As I said the other day with regard to MKSI, for me to feel good about investing in this stock I need to see a more convincing outlook for EPS growth, which I don’t currently have.
I think an argument can be made to terminate the analysis upon seeing a negative mean long-term-EPS-growth projection. Just like we require passing of visual inspection for a core position, we should expect to see a positive EPS outlook. If that is not available, then it’s certainly not a “high-quality growth stock” and maybe it’s just not the right time to invest. For cyclical industries, I would think every negative quarter that passes is one quarter closer to growth.
Categories: BetterInvesting® | Comments (0) | Permalink