Option FanaticOptions, stock, futures, and system trading, backtesting, money management, and much more!

LULU Stock Study (4-18-24)

Posted by on April 10, 2024 at 07:45 | Last modified: April 18, 2024 08:31

I recently did a stock study on Lululemon Athletica Inc. (LULU, $344.86). Previous studies are here and here.

M* writes:

     > Lululemon Athletica Inc. designs, distributes, and markets
     > athletic apparel, footwear, and accessories for women, men,
     > and girls. Lululemon offers pants, shorts, tops, and jackets
     > for both leisure and athletic activities such as yoga and
     > running. The company also sells fitness accessories, such
     > as bags, yoga mats, and equipment. Lululemon sells its
     > products through more than 680 company-owned stores in
     > 19 countries, e-commerce, outlets, and wholesale accounts.

This medium-size [not for much longer] company has grown sales and EPS at rates of 20.9% and 24.2% per year since 2015 (FY ends 1/31). Lines are mostly up (EPS dips in ’18, ’21, and ’23), straight, and parallel. PTPM over the last 10 years leads peer and industry averages while ranging from 16.4% in ’23 to 22.6% in ’24 with a last-5-year mean of 20.3%.

ROE over the last 10 years is roughly equal to industry averages while outpacing peers, ranging from 16.8% in ’18 to 43.7% in ’24 with a last-5-year mean of 34.8%. Debt-to-Capital is zero through 2018. This remains much lower than peer and industry averages as the company maintains no long-term debt. The last-5-year mean is 25.2% (leases).

Current Ratio is 2.49 and Quick Ratio is 1.68. Value Line rates the company “A+” for Financial Strength and M* gives an “Exemplary” rating for Capital Allocation. M* also assigns Lululemon a “Narrow” economic moat.

With regard to sales growth:

I am forecasting below the range at 9.0%/year.

With regard to earnings growth:

I am forecasting below the long-term-estimate range (mean of five: 16.4%) at 12.0% per year. My initial value will be the trendline $10.11/share because ’24 EPS ($12.20) is an 82.6% YOY spike and above historical trend.

My Forecast High P/E is 30. High P/E ranges from 37 (’16 and ’17) to 88.9 (upside outlier in ’21) over the last 10 years. The last 5-year mean (excluding ’21) is 54.7 and the last 5-year-mean average P/E is 42.8. I am forecasting well below the range.

My Forecast Low P/E is 25. Low P/E ranges from 20.7 (’19) to 37.7 (’23) over the last 10 years with a last-5-year mean of 30.9. I am forecasting just above the 10-year median low P/E of 24.7.

My Low Stock Price Forecast (LSPF) is the default of $252.80 based on $10.11/share initial value. This is 26.7% less than the previous close, 22.7% less than the 52-week low, and about equal to the 2022 low.

These inputs land LULU in the HOLD zone with an U/D ratio of 2.4. The Total Annualized Return (TAR) is 9.8%.

PAR (using Forecast Average—not High—P/E) is less than I seek for a medium-size company at 7.9%. 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 173 studies done in the past 90 days (51 outliers and my study excluded), averages (lower of mean/median) for projected sales growth, projected EPS growth, Forecast High P/E, and Forecast Low P/E are 13.9%, 15.8%, 42.0, and 27.5. I am lower across the board. Value Line projects a future average annual P/E of 25.0, which is much lower than MS (34.8) and lower than mine (27.5).

MS high / low EPS are $21.24 / $10.27 versus my $17.82 / $10.11 (per share). My high EPS is lower due to a lower growth rate. Value Line’s high EPS is $21.00/share. I am lowest of the three.

MS LSPF of $268.00 implies a Forecast Low P/E of 26.1: less than the above-stated 27.5. MS LSPF is 5.1% less than the default $10.27/share * 27.5 = $282.43 resulting in more conservative zoning. MS LSPF is still 6.0% greater than mine.

My TAR (over 15.0% preferred) is less than MS 18.6%. I believe MOS to be robust in the current study.

Regarding valuation metrics, Relative Value [(current P/E) / 5-year-mean average P/E] per M* is low at 0.64. PEG is fairly valued per Zacks (an infrequent occurrence at 1.2) and 2.0 per my projected P/E.

I consider LULU to be “hitting it out of the park” relative to its industry and overall fundamentals. Analysts disagree about its valuation (e.g. overvalued per M* despite plenty of remaining growth potential versus Strong Buy per CFRA), but per relative P/E the stock has rarely been on sale like it is right now.

With some handicapping (i.e. low growth forecasts, trendline initial value, and very low Forecast High P/E), I have LULU a BUY under $323. With a forecast high price around $535, TAR should meet my 15% criterion around $267/share.

Categories: BetterInvesting | Comments (0) | Permalink

DEO Stock Study (4-17-24)

Posted by on April 8, 2024 at 15:01 | Last modified: April 17, 2024 17:23

I recently did a stock study on Diageo PLC ADR. (DEO) with a closing price of $136.03. My previous study is here.

M* writes:

     > The product of a merger between Grand Metropolitan and Guinness
     > in 1997, Diageo is one of the world’s leading producers of branded
     > premium spirits, approximately level with Kweichow Moutai in
     > revenue terms. It also produces and markets beer and wine. Brands
     > include Johnnie Walker blended scotch, Smirnoff vodka, Crown Royal
     > Canadian whiskey, Captain Morgan rum, Casamigos tequila, Tanqueray
     > gin, Baileys Irish Cream, and Guinness stout. Diageo also owns 34%
     > of premium champagne and cognac maker Moet Hennessy, a
     > subsidiary of French luxury-goods maker LVMH Moet Hennessy-Louis
     > Vuitton, and a near-56% stake in India’s United Spirits.

Over the past decade excluding 2020 (COVID-19), this large-size company has grown sales and EPS at annualized rates of 2.5% and 3.3%, respectively (2.2% and 1.8% including ’20). Lines are somewhat up, straight, and parallel with sales declining in ’15 and ’16 along with EPS declines in ’15, ’16, and ’21. A debate may ensue about whether this is high-quality growth. I listed several YOY declines. 2014 sales (EPS) is not eclipsed until ’21 (’18). In addition, some would say a large company with a sub-5.0% historical/projected growth rate is suspect.

Over the past decade, PTPM trails industry averages (peer data not available) while ranging from 26.4% in ’14 (excluding 17.4% in ’20) to 32.9% in ’19 with a last-5-year mean of 29.5%. ROE trails industry averages despite trending higher from 34.2% (’14) to 47.2% (’23) with a last-5-year mean of 39.3% (34.9% including ’20). Debt-to-Capital is lower than industry averages despite increasing from 58.2% (’14) to 68.4% (’23) with a last-5-year mean of 67.4%.

Interest Coverage is 5.8 and Quick Ratio is 0.6. Value Line rates the company “A” for Financial Strength and M* gives a “Standard” rating for Capital Allocation. M* also assigns Diageo a “Wide” economic moat.

With regard to sales growth:

I am forecasting below the range at 3.0% per year.

With regard to EPS growth:

My 3.0% forecast is below the range of five long-term estimates (mean 5.5%). The initial value is ’23 EPS of $8.29/share [much of the data from the website (automatically populated from M*) differs slightly from my previous First Cut (FC) on 10/13/23; for example, this read $7.91/share. I will point out other differences below].

My Forecast High P/E is 21.0. Over the past decade, high P/E ranges from 21.3 in ’14 [previous FC had 22.0 in ’15] to 32.9 in ’22 [previous FC had 32.4 in ’21] (2020’s 59.8—58.4 in previous FC—excluded) with a last-5-year mean of 28.5 and last-5-year-mean average P/E of 24.7. I am forecasting below the range.

My Forecast Low P/E is 13.0. Over the past decade, low P/E ranges from 17.7 in ’17 [previous FC had 18.0 in ’15] to 24.5 in ’22 [previous FC had 22.4 in ’22] (2020’s 34.1—33.3 in previous FC—excluded) for a last-5-year mean of 21.0. I am forecasting well below the range.

My Low Stock Price Forecast (LSPF) of $107.80 is default based on $8.29/share EPS. This is 20.8% less than the previous closing price and 20.5% less than the 52-week low.

Over the past decade, Payout Ratio ranges from 43.9% in ’23 [previous FC had 46.8%] to 71.6% [64.6%] in ’16 (2020’s 115.9% [117.0%] excluded) with a last-5-year mean of 53.6% [52.5%]. My 43.0% [46.0%} forecast is below the range.

These inputs land DEO in the HOLD zone with a U/D ratio of 2.2. Total Annualized Return (TAR) is 10.1%.

PAR (using Forecast Average—not High—P/E) of 6.1% is less than I seek 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 22 studies (eight outliers including my own 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.8%, 6.0%, 25.3, 19.0, and 63.6%. I am lower across the board. Value Line’s projected average annual P/E of 19.8 is lower than MS (22.2) and higher than mine (17.0).

MS high / low EPS are $10.76 / $5.94 versus my $9.62 / $8.29 (per share). MS low EPS seems unreasonably extreme. $5.72/share would be the lowest since $5.61 [was $5.46 in previous FC] in 2017. Looking closer at MS, six studies (27.3% of the sample) use $0.00 as low EPS (definitely unreasonable). Excluding these raises the mean to $8.16, which is close to mine. My high EPS is lower due to a lower growth rate. Value Line’s high EPS is $10.00/share. I am lowest of the three.

MS LSPF of $131.70 implies a Forecast Low P/E of 22.2: greater than the above-stated 19.0. MS LSPF is 16.7% greater than the default $5.94/share * 19.0 = $112.86 resulting in more aggressive zoning [the large discrepancy is another suggestion that MS low EPS may be extreme]. MS LSPF is also 22.2% greater than mine.

My TAR (over 15.0% preferred) is less than the 15.8% from MS. MS sample size is too small to allow for a valid comparison alone. Based on input selection below or near the bottom of analyst and historical P/E ranges including LSPF less than multi-year lows, I believe MOS to be at least decent in the current study.

Regarding valuation metrics, Relative Value [(current P/E) / 5-year-mean average P/E] per M* is low at 0.67. PEG exceeds 3.2 (overvalued) per Zacks and my projected P/E. PEG is high enough to make me question whether it even applies here (gut feeling that I can’t logically explain).

Generally speaking, I have doubts about DEO partially due to data inconsistency. I don’t see anything historical or projected close to the 11.8% sales growth listed at Manifest Investing (“Bull Sessions” on Apr 2, 2024). Numbers don’t add up from CFRA. YF has mostly missing data. MS is wonky and while this is largely due to the low sample size resulting in a failure to exclude studies that would usually be outliers, having any studies with $0.00 EPS estimates is something I rarely notice.

Some would try to set me straight, but for me DEO’s frail EPS projections also don’t jive with a wide economic moat.

Maybe currency conversion from sterling to USD is injecting some fuzzy math into the mix. This should not be the case as indicated here: “[As of Jul 1, 2023, Diageo] decided to change its presentation currency to US dollars… applied retrospectively, as it believes that this change will provide better alignment of the reporting of performance with its business exposures.” This would be post hoc rationale in a post hoc press release that is mysteriously dated > 6 months (Jan 30, 2024) after the change. As an ADR trading on the NYSE, I don’t have 10-K’s for clarification.

I lowballed Forecast Low P/E to get LSPF more than 20% below the current price (a minimum I try to uphold). The highest dividend yield over the last 10 years is 3.4% in ’16. With the current annual dividend of $4.01/share, any stock price below $116.90 would push the dividend yield > 3.4%. This is an argument to use a higher LSPF thereby raising U/D to 3.1.

As I have it, though, DEO is a BUY under $131. With a forecast high price around $202, TAR should meet my 15% criterion around $101/share.

Categories: BetterInvesting | Comments (0) | Permalink

NAPA Stock Study (4-16-24)

Posted by on April 4, 2024 at 09:05 | Last modified: April 17, 2024 15:09

I recently did a stock study on Duckhorn Portfolio Inc. (NAPA) with $8.23 closing price. Previous studies are here and here.

Value Line writes:

     > Duckhorn Portfolio, Inc. is an American producer and purveyor of wines
     > from California and Washington state. The company operates approx.
     > 900 vineyards, produces 900,000 cases per year. Major brands include
     > Duckhorn, Decoy, Goldeneye, Paraduxx, Migration, Canvasback,
     > Calera, Kosta Browne, Greenwing and Postmark. In the U.S., sells
     > wines through wholesale distributors or directly to consumers in
     > wineries and through a wine club membership.

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 6.8, Quick Ratio is 0.9, and Interest Coverage is 6.9. Value Line assigns a B+ rating for Financial Strength.

With regard to sales growth:

I am forecasting toward the lower end of the range at 3.0% per year.

With regard to EPS growth:

I am forecasting conservatively below the long-term-estimate range (mean of four: 4.1%) at 2.0% and using 2023 EPS of $0.60/share as the initial value.

My Forecast High P/E is 25.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 11.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 $6.30 is default based on $0.60/share initial value. This is 23.4% less than the previous close and 22.2% less than the 52-week low.

These inputs land NAPA in the BUY zone with a U/D ratio of 4.3. Total Annualized Return (TAR) is 15.0%.

PAR (using Forecast Average—not High—P/E) of 7.7% 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 would normally look to Member Sentiment except only two studies besides my own have been done over the past 90 days. Mine does have the lowest projected sales and EPS growth along with the lowest Forecast High and Low P/E. Mine also has the lowest TAR. My Forecast High P/E is equal to Value Line’s.

My forecast high EPS is $0.77/share versus Value Line’s $0.88/share.

My study appears to have a solid MOS except for a questionable Forecast High P/E. At 25, I’ve gone below the [brief 3-year historical] range and matched Value Line’s projection. This is a 73% increase from current, though: with what catalyst? As the Value Line analyst writes, “the stock lacks a reliable nexus for its valuation at this juncture.”

Relative Value [(current P/E) / 5-year-mean average P/E] per M* is very low at 0.41.

The stock is trading near its 52-week low and has been in a downtrend since the start of 2022. Value Line’s prospects on stock price [turnaround] are bright and its low projection of $17/share is just above my $16.60. These prospects don’t seem to align with anemic growth projections. ROE seems stuck around 9%, which doesn’t impress me either.

Despite the lackluster growth forecast, NAPA is a BUY under $9.50 and meets my 15% TAR criterion right now.

Categories: BetterInvesting | Comments (0) | Permalink

FIVE Stock Study (4-15-24)

Posted by on April 2, 2024 at 14:49 | Last modified: April 15, 2024 16:31

I recently did a stock study on Five Below, Inc. (FIVE) $157.48. Previous studies are here and here.

M* writes:

     > Five Below Inc is a specialty value retailer offering merchandise targeted
     > at the tween and teen demographic. The Company’s edited assortment of
     > products includes select brands and licensed merchandise.

Over the past decade, this medium-size company has grown sales and earnings at annualized rates of 20.5% and 23.0%, respectively. Lines are mostly up, straight, and parallel except for EPS declines in ’21 (inclusive dates 2/1/2020 – 1/31/2021 as FY ends 1/31) and ’23. PTPM leads peer and industry averages while ranging from 7.8% (COVID in ’21) to 12.9% (’22) with a last-5-year mean of 11.1%.

Also over the past decade, ROE leads peer and industry averages despite falling from 34.5% (’15) to 21.7% (’24) with a last-5-year mean of 22.7%. Debt-to-capital is lower than peer and industry averages with a last-5-year mean of 53.9%.

FIVE has no long-term debt (leases and uncapitalized rentals, only), a Current Ratio of 1.7, and a Quick Ratio of 0.6. Value Line gives a B++ rating for Financial Strength (“A” six months ago), and M* assigns a “Narrow” (“Wide” six months ago) Economic Moat

With regard to sales growth:

I am forecasting below the range.

With regard to EPS growth:

I am forecasting below the long-term-estimate range (mean of five: 20.0%). My initial value will be ’24 EPS of $5.41/share.

My Forecast High P/E is 32.0. Excluding ’21, high P/E over the past decade ranges from 39.5 in ’16 to 54.4 in ’15 with a last-5-year mean of 53.6 and a last-5-year-mean average P/E of 40.1. I am forecasting below the range (close to current P/E).

My Forecast Low P/E is 20.0. Over the past decade, low P/E ranges from 20.2 in ’18 to 36.4 in ’15 with a last-5-year mean of 26.6. I am forecasting below the range.

My Low Stock Price Forecast (LSPF) of $119.00 is default based on $5.41/share initial value. This is 24.4% less than the previous close and 17.7% less than the 52-week low.

These inputs land FIVE in the BUY zone with a U/D ratio of 5.0. Total Annualized Return (TAR) is 17.2%.

PAR (using Forecast Average—not High—P/E) of 13.3% is solid 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 195 studies (my study and 83 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 14.9%, 16.3%, 37.4, and 25.3, respectively. I am lower across the board. Value Line’s projected average annual P/E of 30.0 is lower than MS (36.4) and mine (32.0).

MS high / low EPS are $10.89 / $4.84 versus my $10.88 / $5.41 (per share). My high EPS is in agreement while MS appears to be using low EPS from ’23 rather than ’24 released about one month ago. Value Line’s high EPS is $11.00: in agreement with the two others.

MS Low Stock Price Forecast (LSPF) of $126.60 implies a Forecast Low P/E of 26.2: more than the above-stated 25.3. MS LSPF is 3.4% greater than the default $4.84/share * 24.4 = $122.45, which results in more aggressive zoning. MS LSPF is also 6.4% greater than mine.

My TAR (over 15.0% preferred) is in good agreement with the 17.3% from MS. MOS seems robust in the current study since it agrees nicely with MS data seemingly based on ’23 annual EPS.

Regarding valuation metrics, PEG is 1.3 and 1.7 per Zacks and my projected P/E, respectively: the latter being overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is slightly undervalued at 0.73.

FIVE is a BUY under $176 and with a forecast high price around $348, TAR meets my 15% criterion right now.

Categories: BetterInvesting | Comments (0) | Permalink

YETI Stock Study (10-26-23)

Posted by on February 2, 2024 at 06:45 | Last modified: March 13, 2024 12:09

I recently did a stock study on YETI Holdings (YETI) with a closing price of $41.50. Previous studies are here and here.

M* writes:

     > YETI Holdings Inc is a designer, marketer, and distributor of premium
     > products for the outdoor and recreation market sold under the YETI
     > brand. The company offers products including coolers and equipment,
     > drinkware, and other accessories. Its trademark products include YETI,
     > Tundra, Hopper, YETI TANK, Rambler, Colster, Rambler Colster, Roadie,
     > and Wildly Stronger! Keep Ice Longer!, SideKick, FatWall, PermaFrost,
     > T-Rex, ColdLock, NeverFail, AnchorPoint, InterLock, BearFoot, Vortex,
     > DoubleHaul, LipGrip, Vortex, DryHide, ColdCell, HydroLock, Over-the-
     > Nose, and LOAD-AND-LOCK. The company distributes products through
     > wholesale channels and through direct-to-consumer, or DTC, channels.

This medium-size company has grown sales and earnings at annualized rates of 32.5% and 19.3% over the last 9 and 7 years, respectively [’13-’14 EPS excluded due to small fractional values that artificially inflate the growth rate]. The visual inspection is mediocre. Sales are up and straight except for spike in ’15 and decline in ’17. YOY EPS are down in ’16, ’17, ’19, and ’22 [I am excluding the latter 57.1% decline due to operational snafus including recall of defective items and inflation-induced demand destruction per Value Line]. PTPM leads peer and industry averages despite generally trending lower from 12.3% (’13) to 7.3% (’22) with a last-5-year mean of 12.3%.

Over the last four years (too brief a history to compare with peer and industry averages), ROE averages 47.6% and is trending lower. Debt-to-Capital is declining since ’16 and falls below peer/industry averages in ’20 with a last-5-year mean of 50.9% [23.8% in ’22].

Interest Coverage is 22.3 and Quick Ratio is 1.0. Value Line gives a “B+” rating for Financial Strength.

With regard to sales growth:

I am forecasting conservatively toward the bottom of the range at 6.0% per year.

With regard to EPS growth:

I am forecasting below the long-term-estimate range (mean of five: 10.2%) at 8.0% per year. I will not use ’22 EPS of $1.03/share or 2023 Q2 $0.76/share (annualized) as the initial value since those numbers are affected by [temporary] product recall and production issues. Instead, I will start with ’20 EPS ($1.77) and extrapolate to $1.77 * (1.08 ^ 7) = $3.03/share. I can almost ($3.02/share) get to this as a [website] workaround with a 24.0% growth rate projected from ’22 EPS.

My Forecast High P/E is 31.0. With the stock trading publicly since 2018, high P/E has increased from 31.1 to 80.6 in ’22 for a last-5-year mean of 53.0. The last-5-year-mean average P/E is 36.9. I am forecasting below the range.

My Forecast Low P/E is 16.0. Over the past five years, low P/E ranges from 8.6 (perhaps a downside outlier) in ’20 to 27.0 in ’22 with a last-5-year mean of 20.8. I am forecasting below the latter (18.0 in 2018 being the second-lowest value).

My Low Stock Price Forecast (LSPF) of $28.30 is default based on initial value of $1.77/share. This is 32.7% less than the previous close and 3.7% less than the 52-week low.

These inputs land YETI in the BUY zone with a U/D ratio of 3.5. Total Annualized Return (TAR) is 16.9%.

PAR (using Forecast Average—not High—P/E) of 10.6% 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 start by comparing my inputs with those of Member Sentiment (MS). Based on only 43 studies (my study and 17 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%, 13.0%, 35.0, and 17.7, respectively. I am lower across the board. Value Line’s projected average annual P/E of 20.0 is lower than MS (26.4) and lower than mine (23.5).

MS high / low EPS are $1.66 / $0.76 versus my $3.02 / $1.77 (per share). My EPS range is higher, which is quite rare. I think selection of 2023 Q2 as low EPS is unreasonable since results are still being affected by the recall [per Value Line]. I also don’t understand MS high EPS being less than 2020 EPS (7 years earlier). Value Line’s high EPS is $4.20: higher than mine and ~2.5x MS. What doesn’t surprise me is seeing big differences (and questionable ranges) given such a small MS sample size.

MS LSPF of $15.80 implies a Forecast Low P/E of 20.8: greater than the above-stated 17.7. MS LSPF is 17.5% greater than the default $13.28/share * 17.8 = $13.45, which results in more aggressive zoning. MS LSPF is a whopping 44.2% less than mine. I think MS LSPF is unreasonably low: consistent with skepticism expressed in the last paragraph.

My TAR (over 15.0% preferred) is dramatically higher than the 8.4% from MS. I can’t put much faith in MS given the limited sample size of 43. Comparing my inputs with the analyst estimates and P/E ranges as discussed above, I believe MOS to be moderate or better in the current study.

I track a few different [usually conflicting] valuation metrics. PEG is 2.0 and 1.9 per Zacks and my projected P/E, respectively: slightly overvalued. Relative Value [(current P/E) / 5-year-mean average P/E] of 1.5 (M*) is very high, but I believe it to be skewed by a low ’22 EPS caused by nonrecurring events. Kim Butcher’s “quick and dirty DCF” has the stock 40.4% undervalued: 17.0 * [$4.85 – ($0.00 + $0.70)] = $70.55. I’m skeptical of this as well (big discrepancy).

YETI is a BUY under $44. My main source of reluctance is the rocky visual inspection. As additional MOS, I would look to invest at $44 – 10% (arbitrary) = $39.60/share or less.

Categories: BetterInvesting | Comments (0) | Permalink

POOL Stock Study (10-25-23)

Posted by on January 31, 2024 at 06:52 | Last modified: October 25, 2023 11:34

I recently did a stock study on Pool Corp. (POOL) with a closing price of $346.78. The original study is here.

CFRA writes:

     > Pool Corp. is one of the world’s largest wholesale distributors of
     > swimming pool and related backyard products. It is also one of the
     > top three distributors of irrigation and related products in the U.S.
     > POOL offers a comprehensive selection of services and products
     > including: 1) pool maintenance, which includes supplies, repair
     > parts and chemicals; 2) pool construction and renovation, which
     > includes pool tile, control systems, lighting, pool pumps, filters,
     > heaters, cleaners, among others; 3) commercial and residential
     > irrigation and landscape equipment and maintenance; 4) outdoor
     > living, which includes grills, lighting, and hardscape products.
     > Customers primarily include swimming pool remodelers and builders;
     > specialty retailers that sell swimming pool supplies; swimming pool
     > repair and service businesses; irrigation construction and landscape
     > maintenance contractors; and commercial customers who service
     > large commercial installations such as hotels, universities, and
     > community recreational facilities.

Over the past decade, this medium-size company has grown sales and earnings at annualized rates of 12.3% and 28.0% per year, respectively. Lines are up, mostly straight, and narrowing. PTPM leads peer and industry averages while increasing from 7.6% (’13) to 15.9% (’22) with a last-5-year mean of 12.5%.

Also over the past decade, ROE leads peer and industry averages by increasing from 27.7% (’13) to 61.4% (’22) with a last-5-year mean of 62.1%. Debt-to-Capital is higher than peer and industry averages while ranging from 46.3% in ’13 to 74.9% in ’19 with a last-5-year mean of 60.3%.

Interest Coverage is 11.5 (Value Line) and Current Ratio 2.7 (M*). Value Line gives an “A” rating for Financial Strength.

With regard to sales growth:

My forecast of 2.0%/year discounts the available long-term estimate given the general agreement on shorter-term contraction.

With regard to EPS growth:

My forecast of -2.0% per year is less than the long-term-estimate mean (-1.0% for five estimates). My initial value will be 2023 Q2 $15.09/share EPS rather than the 2022 EPS of $18.70. For low EPS, I will use a -4.0% growth rate (arbitrary). These result in high and low EPS of $13.64 and $12.30/share, respectively.

My Forecast High P/E is 28.0. Over the past decade, high P/E ranges from 26.5 in ’14 to 43.6 in ’20 with a last-5-year mean of 35.5. The last-5-year average P/E is 27.3. I am forecasting toward the bottom of the range (only ’14 is lower).

My Forecast Low P/E is 18.0. Over the past decade, low P/E goes from 20.9 in ’13 to 22.2 in ’19 before taking a nosedive to 14.9 in ’22. The last-5-year mean is 19.2. I am forecasting toward the bottom of the range [only ’22 and ’20 (17.9) are lower].

My Low Stock Price Forecast (LSPF) is $256.00. Sticking with default gives $221.40, which is 22.0% less than the 52-week low. My Forecast Low P/E is uncertain because I don’t know whether the first or last five years of the past decade will be more representative of the future. Nevertheless, I think the default is too extreme. My LSPF is 20.5% less than the previous close and 9.8% less than the 52-week low. I think that is sufficiently low even from a conservative standpoint.

Over the past decade, Payout Ratio ranges from 18.7% in ’21 to 35.6% in ’13 with a last-5-year mean of 25.6%. I am forecasting below the range at 18%.

These inputs land POOL in the HOLD zone with a U/D ratio of 0.9. Total Annualized Return (TAR) is 4.1%.

PAR (using Forecast Average—not High—P/E) of 0.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 (still far below my target).

To assess MOS, I start by comparing my inputs with those of Member Sentiment (MS). Based on only 55 studies (my study and 14 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 8.8%, 7.9%, 27.3, 18.2, and 27.0%. I am lower on all but Forecast High P/E (28.0). Value Line’s projected average annual P/E of 24.0 is higher than MS (22.8) and mine (23.0).

MS high / low EPS are $23.98 / $15.09. My EPS range (see above) is lower. Value Line’s high EPS is $20.00.

MS LSPF of $260.30 implies a Forecast Low P/E of 17.2: less than the above-stated 18.2. MS LSPF is 5.2% less than the default $15.09/share * 18.2 = $274.64, which results in more conservative zoning. MS LSPF is still 1.7% greater than mine.

My TAR (over 15.0% preferred) is much less than the 15.6% from MS. MOS seems robust in the current study.

I track a few different [usually conflicting] valuation metrics. PEG is 4.1 per Zacks: 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” suggests the stock to be 15.3% undervalued: 21.0 * [$5.00 – ($6.00 + $0.90)] = $380.10/share.

POOL is a BUY under $287. With a forecast high price near $382, TAR should meet my 15% criterion around $191/share.

My investment outlook will improve dramatically if/when [most/all] analysts start seeing growth back on the horizon. Until then, it’s not a high-quality BI stock anyway.

Categories: BetterInvesting | Comments (0) | Permalink

NFLX Stock Study (10-24-23)

Posted by on January 29, 2024 at 06:45 | Last modified: October 24, 2023 10:14

I recently did a stock study on Netflix Inc. (NFLX) with a closing price of $406.84. Previous studies are here, here, and here.

M* writes:

     > Netflix’s primary business is a streaming video on demand
     > service now available in almost every country worldwide
     > except China. The firm primarily generates revenue from
     > subscriptions to its eponymous service. Netflix delivers
     > original and third-party digital video content to PCs,
     > internet-connected TVs, and consumer electronic devices,
     > including tablets, video game consoles, Apple TV, Roku,
     > and Chromecast. Netflix is the largest SVOD platform in
     > the world with over 220 million subscribers globally.

Over the past decade, this large-size company has grown sales and earnings at annualized rates of 26.6% and 58.4%, respectively. Lines are mostly up, narrowing, and parallel except for EPS declines in ’15 and ’22. PTPM lags peer and industry averages despite trending higher from 3.9% (’13) to 16.6% (’22) with a last-5-year mean of 13.4%.

Also over the past decade, ROE lags peer and industry averages despite trending up from 9.2% (’13) to 21.6% (’22) with a last-5-year mean of 26.0%. Debt-to-Capital is roughly even with peer and industry averages while increasing from 27.3% in ’13 to 66.4% in ’18 then reversing lower to 40.9% in ’22 for a last-5-year mean of 56.5%.

Interest Coverage and Quick Ratio are 7.5 and 1.1, respectively. M* gives the company a “Standard” rating for Capital Allocation while Value Line gives an A rating for Financial Strength.

With regard to sales growth:

I am forecasting toward the low end of the range at 6.0% per year.

With regard to EPS growth:

I am forecasting just under the long-term-estimate range (mean of six: 21.0%) at 13.0% per year. I will use 2023 Q2 EPS of $9.39/share (annualized) as the initial value rather than ’22 EPS of $9.95.

My Forecast High P/E is 35.0. Over the past decade, high P/E has decreased from 211 (’13) to 61.3 (’22) with a last-5-year mean of 93.9. The last-5-year-mean average P/E is 71.0. At some point, I expect P/E to fall back to earth. For now, I am forecasting at the upper end of my comfort zone.

My Forecast Low P/E is 30.0. Over the past decade, low P/E has decreased from 49.1 (’13) to 16.4 (’22) with a last-5-year mean of 48.1. Again, at some point I expect P/E to fall back to earth and we may already be starting to see this with a current P/E of 43.3. I am forecasting toward the bottom of the range (only ’22 is lower).

My Low Stock Price Forecast (LSPF) is $281.70: default based on $9.39/share initial value. This is 30.8% less than the previous close but 11.7% greater than the 52-week low.

These inputs land NFLX in the HOLD zone with a U/D ratio of 1.6. Total Annualized Return (TAR) is 8.3%.

PAR (using Forecast Average—not High—P/E) of 6.7% is less than I seek 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 compare my inputs with those of Member Sentiment (MS). Based on 182 studies (my study and 40 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.9%, 48.5, and 30.0. I am lower on the first and third but slightly higher on the second (13.0%). Value Line’s projected average annual P/E of 38.0 is lower than MS (39.3) and higher than mine (32.5).

MS high / low EPS are $17.54 / $9.27 versus my $17.30 / $9.39 (per share). My high EPS is lower due to a lower growth rate. Value Line’s high EPS is $18.85. I am lowest of the three.

MS LSPF of $225 implies a Forecast Low P/E of 24.3: less than the above-stated 30.0. MS LSPF is 19.1% less than the default $9.27/share * 30.0 = $278.10, which results in more conservative zoning. MS LSPF is also 20.1% less than mine.

My TAR (over 15.0% preferred) is much less than the 16.3% from MS. MOS seems robust in the current study.

I track a few different [usually conflicting] valuation metrics. PEG is 1.3 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 12.0 * [$18.85 – ($0.00 + $1.25)] = $211.20: overvalued by 48.1%.

NFLX is a BUY under $362. With a forecast high price of $605.50, TAR should meet my 15% criterion around $303/share.

Categories: BetterInvesting | Comments (0) | Permalink

MBUU Stock Study (10-23-23)

Posted by on January 25, 2024 at 06:46 | Last modified: October 23, 2023 10:25

I recently did a stock study on Malibu Boats Inc. (MBUU, $50.00). Previous studies are here and here.

M* writes:

     > Malibu Boats is a leading designer and manufacturer of power
     > boats in the United States. It is the market leader in
     > performance sport boats, sold under its Malibu and Axis brands.
     > It acquired Cobalt Boats, a leading producer of sterndrive
     > boats in the U.S. in the 24-foot to 29-foot segment, and
     > Pursuit Boats, which makes high-end offshore and outboard
     > motorboats in 2018. In 2021, it purchased Maverick Boat Group,
     > a leading seller of flat fishing boats, with exposure to bay,
     > dual-console, and center-console boats. Malibu has also
     > expanded into boat trailers and accessories, and in 2020
     > began producing its own engines (Monsoon) for its performance
     > sport boats. Malibu’s target market includes a wide range of
     > water enthusiasts who embrace the active outdoor lifestyle.

Over the past decade, this medium-size company has grown sales and earnings at annualized rates of 26.6% and 30.5% [86.0% if the 2014 loss is included], respectively. Lines are mostly up, straight, and parallel except for a sales decline in ’20 (FY ends Jun 30) and EPS declines in ’18, ’20, and ’23. PTPM is higher than peer and industry averages, ranging from 10.2% in ’23 (excluding the loss from ’14) to 18.0% in ’18 with a last-5-year mean of 13.9%.

Over the past five years, ROE is slightly better than peer and industry averages despite falling from 35.6% in ’19 to 16.7% in ’23 with a mean of 28.6%. Debt-to-Capital is lower than peer and industry averages by falling from 35.7% in ’19 to 0.4% in ’23 with a last-5-year mean of 21.7%.

Interest Coverage is 48.8 and Quick Ratio is 0.63. M* rates the company “Standard” for Capital Allocation while Value Line assigns a B+ rating (down from B++ last quarter) for Financial Strength. The company currently has zero long-term debt.

With regard to sales growth:

I am forecasting less than both long-term estimates at 0%.

With regard to EPS growth:

I am forecasting toward the bottom of the long-term-estimate range (mean of four: 7.1%). I will use ’23 EPS of $5.06/share as the initial value.

My Forecast High P/E is 12.0. Since 2015, high P/E falls from 26.0 (34.2 in ’18 excluded) to 14.0 (’23) with a last-5-year mean of 16.3. The last-5-year-mean average P/E is 12.2. I am forecasting below the latter [only ’22 is lower (11.5)].

My Forecast Low P/E is 7.0. Since 2015, low P/E generally trends down from 17.4 to 9.2 (’23) with a last-5-year mean of 8.1. I am forecasting toward the bottom of the range [only 6.1 (’20) and 6.4 (’22) are lower].

My Low Stock Price Forecast (LSPF) is $35.40: default based on $5.06/share initial value. This is 29.2% less than the previous close and 24.0% less than the 52-week low.

These inputs land MBUU in the HOLD zone with a U/D ratio of 1.6. Total Annualized Return (TAR) is 8.1%.

PAR (using Forecast Average—not High—P/E) is 3.2%, 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 instead.

To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 196 studies (my study and 29 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 9.0%, 8.9%, 14.0, and 7.6, respectively. I am lower across the board. Value Line’s projected average annual P/E of 10.0 is lower than MS (10.8) and higher than mine (9.5).

MS high / low EPS are $8.82 / $5.06 versus my $6.16 / $5.06 (per share). My high EPS is lower due to a lower growth rate. Value Line’s high EPS is $8.30. I am lowest of the three.

MS LSPF of $38.20 implies a Forecast Low P/E of 7.5, which is consistent with above. MS LSPF is 7.9% greater than mine thereby implying more aggressive zoning.

My TAR (over 15.0% preferred) is much less than the 20.2% from MS. MOS seems robust in the current study.

I track a few different [usually conflicting] valuation metrics. PEG per my projected P/E is overvalued at 2.4. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is slightly undervalued at 0.8. Kim Butcher’s “quick and dirty DCF” prices the stock at 8.0 * [$10.05 – ($0.00 + $2.60)] = $59.60, which suggests the stock to be 15.9% undervalued.

MBUU is a BUY under $45. With a forecast high price near $74, TAR should meet my 15% criterion around $37/share.

Categories: BetterInvesting | Comments (0) | Permalink

TGT Stock Study (10-20-23)

Posted by on January 23, 2024 at 07:05 | Last modified: October 20, 2023 12:17

I recently did a stock study on Target Corp. (TGT) with a closing price of $108.36. Previous studies are here, here, and here.

CFRA writes:

     > Incorporated in 1902 and headquartered in Minneapolis, Target
     > Corporation is one of the largest retailers in the U.S. As of
     > January 29, 2022, the company operated 1,926 Target locations
     > in the U.S. with 243.3 million square feet of floor space, up
     > from 1,897 stores with 241.6 million square feet of floor
     > space twelve months earlier. Target currently has stores in
     > all 50 states and the District of Columbia. Its stores
     > generally cater to middle- and upper-income consumers,
     > carrying a broad assortment of fashion apparel, electronics,
     > home furnishings, household products, and other general
     > merchandise. Target.com offers a more extensive selection of
     > merchandise than the company’s physical stores, including
     > exclusive online products.

Over the past decade, this mega-sized company (revenue > $50B) has grown sales and earnings at annualized rates of 4.9% and 11.9%, respectively (FY ends Jan 31). Lines are mostly up except for dips in sales (’17) and EPS (’17 and ’23). PTPM leads peer and industry averages throughout the decade despite a disappointing ’23 contributing to a last-5-year mean of 5.5%.

Also over the past decade, ROE leads peer and industry averages by increasing from 12.0% (’14) to 25.0% (’23) with a last 5-year mean of 31.9%. Debt-to-Capital is higher than peer and industry averages, increasing from 45.9% (’14) to 62.9% (’23) with a last-5-year mean of 55.7%.

Quick Ratio is chronically low (0.08 in the last quarter), but Interest Coverage is 8.8. Value Line gives a B++ rating for Financial Strength while M* assigns an “Exemplary” rating for Capital Allocation.

With regard to 2023 EPS decline, Value Line wrote:

     > Followers of this story will recall that the bottom line last year
     > was torpedoed when management announced a serious inventory
     > bloat would be worked down by across-the-board discounting.
     > Shortly thereafter, a clearance run event was held to get
     > shoppers to spend at the tail end of the holiday season, thus
     > again clearing inventory space for items geared toward warmer
     > weather. The end result was a sharp drop in profitability and
     > a full-year earnings figure of just $5.98 a share.

With regard to sales growth:

I am forecasting less than the long-term estimate at 1.0% per year.

With regard to EPS growth:

The long-term estimates are dramatically higher than three months ago. The mean (of six) has increased from 10.3% to 16.4%. This is primarily due to two negative estimates (Seeking Alpha at -0.6% and YF at -7.5%) that are now significantly positive. It’s almost mind-boggling to imagine the arithmetic average of ~30 analysts changing so much over one quarter. I sometimes wonder if I’m looking at data importation errors on the website. One such error, which could never actually be confirmed, can dramatically affect my forecast.

I am forecasting below the long-term-estimate range at 12.0% per year. I will use ’23 EPS of $5.98 as the initial value. Three months ago, I went with the trendline since $5.98/share—down 57.6% YOY—seemed unreasonably low. Owing largely to the negative long-term estimates just discussed, however, three months ago my forecast EPS growth rate was only 4.0%.

My Forecast High P/E is 15.0. Over the past decade, high P/E ranges from 14.8 (’18) to 42.6 (upside outlier in ’23) with a last-5-year mean (excluding the outlier) of 19.8. The last-5-year-mean average P/E is 15.4. I am forecasting near the bottom of the range (only ’18 is lower).

My Forecast Low P/E is 10.5. Over the past decade, low P/E ranges from 9.1 (’18) to 22.9 (’23). Low P/E has been 14.2 or less since ’15, which makes the 22.9 seem like an outlier. Excluding that, the last-5-year mean is 11.0. I am forecasting near the bottom of the range [only ’18 and ’21 (10.4) are lower].

My Low Stock Price Forecast (LSPF) is $80.00. This is a rare instance where the default value of $62.80 is unreasonably low. That would be 42.0% less than the previous close and a whopping 39.0% less than the 52-week low. The stock has already fallen 59.7% from its all-time high (2021) and with EPS cratering in ’23, growth is expected moving forward. Sticking with the default in this case feels like trying to fit a square peg in a round hole. Instead, I am going with a price 26.2% less than the previous close and 22.3% less than the 52-week low. In my opinion, that is still conservative.

Over the past decade, Payout Ratio ranges from 22.4% (’22) to 66.2% (’23). The last-5-year mean is 41.3%. I am forecasting below the range at 22.0%.

These inputs land TGT in the HOLD zone with a U/D ratio of 1.8. Total Annualized Return (TAR) is 9.3%.

PAR (using Forecast Average—not High—P/E) of 6.1% is less than I seek for a mega-size company. If a healthy margin of safety (MOS) anchors the study, then I can proceed based on TAR instead.

To assess MOS, I compare my inputs with those of Member Sentiment (MS). Based on 120 studies (my study and 62 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.7%, 10.0%, 19.0, 11.5, and 41.3%, respectively. I am lower on all but EPS growth (12.0%). Value Line’s projected average annual P/E of 15.0 is just lower than MS (15.8) and higher than mine (12.8).

MS high / low EPS are $11.32 / $6.89 versus my $10.54 / $5.98 (per share). My high EPS is lower due to a lower growth rate. Value Line’s high EPS is $17.00. I am lowest of the three.

MS LSPF of $92.20 implies a Forecast Low P/E of 13.4: more than the above-stated 11.5. MS LSPF is 16.4% greater than the default $11.32/share * 11.5 = $79.24, which results in more aggressive zoning. Like mine, other studies may also have overridden default to select a higher LSPF. MS LSPF is 15.3% greater than mine.

My TAR (over 15.0% preferred) is much less than MS 15.3%. MOS seems robust in the current study.

I track a few different valuation metrics. PEG is 1.1 per Zacks and my projected P/E: fairly valued. Relative Value per M* [(current P/E) / 5-year-mean average P/E] is fair at 1.0. Although these metrics often conflict, they are quite consistent here.

TGT is a BUY under $99. With a forecast high price around $158, TAR should meet my 15% criterion around $79/share.

Categories: BetterInvesting | Comments (0) | Permalink

DG Stock Study (10-19-23)

Posted by on January 19, 2024 at 06:19 | Last modified: October 19, 2023 11:01

I recently did a stock study on Dollar General Corp. (DG) with a closing price of $116.02. Previous studies are here and here.

M* writes:

     > A leading American discount retailer, Dollar General operates
     > over 19,000 stores in 47 states, selling branded and private-
     > label products across a wide variety of categories. In fiscal
     > 2022, 80% of net sales came from consumables (including paper
     > and cleaning products, packaged and perishable food, tobacco,
     > and health and beauty items), 11% from seasonal merchandise
     > (such as toys, greeting cards, decorations, and gardening
     > supplies), 6% from home products (for example, kitchen
     > supplies, small appliances, and cookware), and 3% from
     > apparel. Stores average roughly 7,500 square feet, and about
     > 75% of Dollar General locations are in towns of 20,000 or
     > fewer people. The firm emphasizes value, with most of its
     > items sold at everyday low prices of $5 or less.

Over the past decade, this large-size company has grown sales and EPS at annualized rates of 9.1% and 16.1%, respectively. Lines are up, straight, and parallel except for an EPS dip in ’22. PTPM leads peer and industry averages while decreasing from 9.3% (’14) to 8.2% (’23) with a last-5-year mean of 8.6% (FY ends Jan 31).

Also over the past decade, ROE leads peer and industry averages while trending higher from 19.1% (’14) to 39.2% (’23) with a last-5-year mean of 32.7%. Debt-to-Capital is less than peer and industry averages until ’20 when it spikes higher and continues to increase. The last-5-year mean is somewhat uncomfortable at 61.4%.

Despite a Quick Ratio of only 0.08, Current Ratio is 1.39 and Interest Coverage is 10.5. Value Line gives an A rating for Financial Strength. M* gives a “Standard” rating for Capital Allocation and writes:

     > Dollar General has featured a sound balance sheet
     > historically, and we see little reason for solvency concerns
     > moving forward as we look at the firm’s midterm prospects.

With regard to sales growth:

I am forecasting near the bottom of the range at 2.0% per year.

With regard to EPS growth:

I am forecasting just below the mean long-term estimate (-0.3%) at -1.0% per year. This is not conservative unless one is convinced the company will grow long-term earnings. Analyst long-term estimates are split with three each siding for growth and contraction. I will use 2024 Q2 EPS of $9.76 (annualized) rather than ’23 EPS of $10.68/share to get a high EPS of 9.76 * (0.99 ^ 5) = $9.28/share. As low EPS, $9.76 * (0.97 ^ 5) = $8.38/share uses a -3.0% [arbitrary] growth rate.

My Forecast High P/E is 19.0. Over the past decade, high P/E increases from 19.9 (’14) to 24.6 (’23) with a last-5-year mean of 22.9. The last-5-year-mean average P/E is 19.1. I am forecasting near the bottom of the range (only 18.8 in ’17 is lower).

My Forecast Low P/E is 11.0. Over the past decade, low P/E ranges from 11.7 in ’18 to 17.2 in ’23 with a last-5-year mean of 15.3. I am forecasting below the entire range.

My Low Stock Price Forecast (LSPF) of $92.20 is default based on low EPS of $8.38/share. This is 20.5% less than the previous close and 8.8% less than the 52-week low.

Since a dividend was first issued in ’16, Payout Ratio ranges from 13.6% in ’21 to 22.6% in ’17. I am forecasting below the range at 13.0%.

These inputs land DG in the HOLD zone with a U/D ratio of 2.5. Total Annualized Return (TAR) is 9.4%.

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 210 studies (my study and 102 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 6.0%, 8.2%, 21.3, 14.4, and 17.9%, respectively. I am lower across the board. Value Line’s projected average annual P/E of 19.0 is higher than MS (17.9) and higher than mine (16.0).

MS high / low EPS are $15.33 / $9.96 versus my $9.28 / $8.38 (per share). Despite mentioning above that my forecast growth rate is not conservative, my EPS range is completely below MS thereby suggesting it may be more conservative than I think. Value Line’s high EPS is $11.80. I am lowest of the three.

MS LSPF of $130.30 (invalid on today’s date) implies a Forecast Low P/E of 13.1: less than the above-stated 14.4. MS LSPF is 9.2% less than the default $9.96/share * 14.4 = $143.42 (also invalid on today’s date), which results in more conservative zoning. MS LSPF is still 41.3% greater than mine.

My TAR (over 15.0% preferred) is much less than MS 21.7%. MOS seems robust in the current study.

I track a few different [usually conflicting] valuation metrics. PEG (Zacks) is overvalued at 2.1. Relative Value [(current P/E) / 5-year-mean average P/E] per M* is cheap around 0.6. Kim Butcher’s “quick and dirty DCF” suggests the stock to be 51.0% overvalued with a fair value of: 14.5 * [$15.00 – ($2.68 + $8.40)] = $56.84 [from 2023 10-K, $1.9B projected ’24 Capex / 226.3M diluted shares outstanding = $8.40—and even that is likely less than the 5-year projection].

DG is a BUY under $113. With a forecast high price near $176, TAR should meet my 15% criterion around $88/share.

Categories: BetterInvesting | Comments (0) | Permalink
Older Entries Newer Entries