GOOG Stock Study (1-17-23)
Posted by Mark on January 26, 2023 at 07:14 | Last modified: February 10, 2023 14:17I recently did a stock study on Alphabet, Inc. (GOOG) with a closing price of $92.80.
This mega-sized (revenue > $50B) company has grown sales and EPS at annualized rates of 19.2% and 13.2% per year for the last decade. Revenue is up and straight despite 2013 earnings not showing growth until 2018 and beyond. Excluding 2021 (upside outlier), PTPM averages 25.2% for the last five years and is steady over the last 10. This trails peer (stated as META, TCEHY, and SPOT) and industry averages.
Over the last five years, ROE averages 18.4% and is higher than peer and industry averages. Debt-to-capital, under 11% for the last decade, averages 6.6% for the last five years. This is lower than peer and industry averages. Should anyone be concerned about the debt load, interest coverage is a ridiculous 205.6.
M* writes:
> Alphabet is a holding company. Internet media giant Google is a wholly owned
> subsidiary. Google generates 99% of Alphabet revenue, of which more than 85%
> is from online ads. Google’s other revenue is from sales of apps and content
> on Google Play and YouTube, as well as cloud service fees and other licensing
> revenue. Sales of hardware such as Chromebooks, the Pixel smartphone, and
> smart home products, which include Nest and Google Home, also contribute to
> other revenue. Alphabet’s moonshot investments are in its other bets segment,
> where it bets on technology to enhance health (Verily), faster internet
> access to homes (Google Fiber), self-driving cars (Waymo), and more.
I assume long-term annualized sales growth of 7% based on the following:
- CNN Business projects growth of 10% YOY and 9% per year for ’22 and ’21-’23, respectively (based on 43 analysts).
- YF projects YOY growth of 10% and 8% for ’22 and ’23, respectively (31 analysts).
- Zacks projects YOY growth of 10.3% and 7.1% for ’22 and ’23, respectively (9).
- CFRA projects annualized growth of 8.7% and 9.5% for ’21-’23 and ’21-’24, respectively.
- Value Line projects 14% annualized growth from ’21-’26.
- M* offers a 2-year ACE estimate of 6.8% per year.
>
I assume long-term annualized EPS growth of 6% based on the following:
- CNN Business projects 15.9% YOY contraction and 3.9% contraction per year for ’22 and ’21-’23, respectively (based on 43 analysts).
- MarketWatch projects 2.3% contraction per year and 3.7% growth per year for ’21-’23 and ’21-’24, respectively (48 analysts).
- Nasdaq.com projects annualized growth of 11.8% and 17.6% for ’22-’24 and ’22-’25, respectively (12, 8, and 3 analysts for ’22, ’24, and ’25).
- YF projects 16% YOY contraction for ’22, 10.4% YOY growth for ’23, and 8.9% annualized growth for the next five years (35).
- Zacks projects 16.6% YOY contraction for ’22, 8.1% YOY growth for ’23, and 11.3% annualized growth for the next five years (12).
- Value Line projects 12.7% growth per year from ’21-’26.
- M* has long-term ACE at 13% annualized.
- CFRA projects 3-year annualized EPS growth of 5%.
>
I project a future High P/E of 27. High P/E has ranged from 29.2 (’18) to 59.9 (upside outlier in ’17) since ’14 with a last-5-year average of 28.9 (excluding the outlier). The trend is down, however.
I project a future Low P/E of 14. Low P/E has ranged from 15.1 (’21) to 42.9 (upside outlier in ’17). Excluding the outlier, the last-5-year average is 18.8. The trend is down.
The projected low price based on these inputs is $70.60, which is about 23% below the previous closing price.
All this results in an U/D ratio of 4, which puts GOOG in the Buy zone down to $98. CAR (using forecast High P/E) is 14.4% and PAR (using forecast average P/E) is 8.3%. I’d like to see PAR higher, but my interpretation also depends on the margin of safety (MOS) built into the study.
To assess MOS, I look at Member Sentiment (MS). 851 studies over the past 90 days indicate projected sales growth, projected EPS growth, and forecast High P/E averages of 11.9%, 13.1%, and 26.9, respectively. My revenue and EPS growth estimates are significantly lower and my High P/E is about the same (27).
I have two issues with this set of MS data. First, no average forecast Low P/E is available. As I scan through the data, I see 12 unreasonable entries in this field including one “NMF.” I wonder if this non-numeric is responsible for why an average could not be calculated. Second, the average low price among these studies is 217 due to some 4-digit values. Being higher than the previous closing price, this would be invalid average. At first I thought people might have used pre-split stock prices, but GOOG stock split more than three months before (Jul 202) the 90-day window begins. Some other explanation must exist.
Regardless of the questionable data, I believe this stock study contains a healthy MOS. Both growth estimates are significantly lower than MS in addition to being lower than every long-term analyst estimate except CFRA (5% EPS growth). Furthermore, Value Line projects a long-term average P/E of 25 compared to my 20.5.
Although the PAR is suboptimal, the MOS gives me confidence in Alphabet’s chances of beating these estimates and realizing stock appreciation more consistent with the forecast High P/E.
Categories: BetterInvesting® | Comments (0) | PermalinkMKSI Stock Study (1-13-23)
Posted by Mark on January 23, 2023 at 07:07 | Last modified: February 9, 2023 14:36I recently did a stock study on MKS Instruments (MKSI) with a closing price of $99.37.
This medium-sized company has grown sales and EPS at rates of 20% and 29.5% per year since 2013. Historical sales and EPS are up and somewhat straight/parallel as EPS has had more of a rocky ride (down in 2016, 2019, and projected 2022). PTPM over the last 10 years has gone up and down between 8.9% and 23.4% with a 5-year average of 19.4%. This is better than peer (stated as TRMG, CGNX, and TDY) and industry averages. ROE over the last five years has averaged 17.3% and is also better than peer and industry averages.
MKSI had no debt until 2016. Over the last five years, debt to capital has averaged 24.8% and been below peer and industry averages. This has all changed with the recent $5.1B acquisition of Atotech. According to M*, MKSI has Current and Quick ratios of 2.8 and 1.6, respectively. While these are healthy, Interest Coverage is a lukewarm 6.5. Value Line lists the latter over 25, but I don’t believe this takes into account the acquisition involving issuance of $4B in debt and 11M shares, which will dilute future EPS.
From CFRA, MKSI is:
> a leading supplier of components and subsystems that measure, control, power, and
> monitor critical parameters of semiconductors and other advanced manufacturing
> processes. The majority of MKSI’s sales are derived from products sold to
> semiconductor capital equipment manufacturers and semiconductor device manufacturers.
> The company’s products are used in the chipmaking process, including depositing thin
> films of material onto silicon wafer substrates and etching and cleaning circuit patterns.”
I will assume long-term annualized sales growth of 7% based on the following:
- CNN Business projects 20.7% growth for 2023 and 13% growth per year for 2022-2024 (based on eight analysts).
- YF projects YOY 17.2% and 7% growth for ’23 and ’24, respectively (nine analysts).
- Zacks projects YOY 17.2% and 7.3% growth for ’23 and ’24, respectively (3).
- Value Line projects 15.7% growth per year from ’21-’26.
- CFRA projects 11.7% and 12.4% growth per year for ’21-’23 and ’21-’24, respectively.
>
I will assume long-term annualized EPS contraction of 1% based on the following:
- CNN Business reports contraction of 18.7% YOY and 35.5% per year for ’23 YOY and ’22-’24, respectively (based on eight analysts).
- MarketWatch projects annualized contraction of 34.9% and 13.9% from ’22-’24 and ’22-’25, respectively (10 analysts).
- Nasdaq.com projects contraction of 49.3% YOY and 14.8% per year for 2023 and ’22-’24, respectively (5, 5, and 4 analysts for ’22, ’23, and ’24).
- YF projects YOY contraction of 18.7% and 48.8% for ’22 and ’23, respectively, along with 10.2% contraction per year for the next five years.
- Zacks projects 19.2% and 49.3% YOY contraction for ’22 and ’23, respectively (5).
- Value Line projects annualized contraction of 3.5% from ’21-’26.
- CFRA projects annualized contraction of 32.9% and 15% for ’21-’23 and ’21-’24, respectively, with a 3-year EPS growth projection of 2% per year.
>
I project a future High P/E of 17. High P/E has averaged 25.2 over the last five years with 17.4 being the low end of the last-10-year range (2015).
I project a future Low P/E of 9. Low P/E has averaged 13.3 over the last five years, but 24.6 in 2019 seems to be an upside outlier. Without that, the 5-year average drops to 10.5. I was tempted to use 7.5, but that seems too extreme. 7.5 would eclipse the low end of the last-10-year range (7.9 in 2018) and result in a projected low price of $57.50. This would undercut the 2020 low and be 42% below the previous closing price.
The projected low price based on these inputs is $69, which is 30% below the previous close.
All this results in an U/D ratio of 2, which puts MKSI in the Hold zone down to $91.80. CAR (using forecast High P/E) is 10.7% and PAR (using forecast average P/E) is 5.1%. For me, the latter is too low for a medium-sized company. Payout Ratio for the last five years averaged 15%. I have estimated 10% as 2019’s 31.4% seems like an upside outlier.
I look to Member Sentiment to assess margin of safety. Averages of 239 studies over the past 90 days indicate projected sales growth, EPS growth, High P/E, Low P/E, and Payout Ratio to be 10.1%, 8%, 19.4, 10.9, and 17.5%, respectively. I’m lower across the board and much lower on EPS. Analysts project nothing even close to 8%, which leaves me rather puzzled on that one. Member Sentiment also averages ~$75 for the projected low price, which is higher than mine.
I see a lot of risk with this stock. The debt taken on for Atotech seems to have basically set this company back five years. While saying the acquisition should result in longer-term synergies, Value Line projects long-term EPS growth to be even more negative than my -1%. If the synergies don’t materialize, then MKSI will be left with quite a bill to pay.
The best-case scenario would be resumption of MKSI’s previous EPS trajectory. Because I don’t know if this will come to fruition, I believe the healthy margin of safety is warranted.
Categories: BetterInvesting® | Comments (0) | PermalinkADBE Stock Study (1-12-23)
Posted by Mark on January 20, 2023 at 06:41 | Last modified: February 9, 2023 14:38I recently did a stock study on Adobe Inc. (ADBE) with a closing price of $342.93.
This large-sized company has grown sales and EPS at annualized rates of 17.9% and 44.5% per year since 2013. Historical sales and earnings are up, mostly straight, and parallel with the exception of a slight EPS dip in 2014 and flat EPS from 2020-2022. PTPM averages 32.5% for the last five years while being above the industry average since 2016 and roughly on par with its peer (stated as VMW, MSFT, and SQ) average since 2017. Over the same time period, ROE averages 33.4%.
Debt to capital averages 26.8% over the last five years, which is far below peer and industry averages. Interest Coverage is exemplary at 54 with a 5-year average of 34.
According to CFRA:
> Adobe (ADBE) is the largest provider of applications used to produce visual content, best known
> for its Creative Cloud apps, Photoshop (#1 in photo editing, raster graphics), Illustrator (#1
> in drawing, vector graphics), InDesign (#1 in page layout), and Premiere Pro (#1 in video
> editing). Its apps are used by graphic designers, photographers, publishers, video producers,
> animators, and other creative professionals… ADBE’s apps are also used by students, hobbyists,
> and part-time artists.
With regard to sales growth, CNN Business projects 9.1% for 2023 and 10.8% per year for ’22-’24 (based on 32 analysts). YF projects 9.4% YOY and 12.1% YOY for ’23 and ’24, respectively (28). Zacks projects 9% YOY and 11.1% YOY for ’23 and ’24, respectively (11). Value Line projects 15.5% per year from ’21-’26. Morningstar offers a 2-year ACE estimate of 12.1% per year. CFRA projects 11.4% for ’23 and 11.7% per year for ’22-’24.
Based on all this, I estimate long-term sales with a growth rate of 11%.
With regard to EPS growth, CNN Business reports ACE of 11.5% YOY and 13% per year for ’23 and ’22-’24, respectively (32 analysts). MarketWatch projects 13.3% and 13.4% per year from ’22-’24 and ’22-’25, respectively. Nasdaq.com projects 13.9% YOY and 12.3% per year for ’24 and ’23-’25, respectively (11, 10, and 1 analyst for ’23, ’24, and ’25). YF projects 11.7% for 2023, 14.6% for 2024, and 13.6% per year for the next five years. Zacks projects 11% for 2023, 13.7% for 2024, and 13.2% per year for the next five years (28). Value Line projects 13.7% per year from ’21-’26. M* has long-term ACE at 14.1% per year and 11% per year from its analyst. CFRA provides a 3-year projection of 13% per year.
Based on all this, I estimate long-term earnings with a growth rate of 11%.
High P/E has ranged from 47.9 (2016) to 140 (2014) over the last 10 years. The last five years have averaged 58.4. I project a long-term High P/E of 47.
Low P/E has ranged from 23.6 (2020) to 101.8 (upside outlier in 2014). The last five years have averaged 31.8. I project a long-term Low P/E of 23.
I am sticking with the default long-term projected low price of $232.30, which is 32% below the previous closing price.
All this results in an U/D ratio of 4.1, which puts ADBE in the Buy zone. CAR (using forecast High P/E) is 23.6% and PAR (using forecast average P/E) is 11.7%.
In order to assess margin of safety, I look to Member Sentiment. Averages of 662 studies over the past 90 days indicate projected sales, EPS, High P/E, and Low P/E of 13.1%, 13.1%, 42.4, and 29.4, respectively. My growth rate estimates are lower and although my projected High P/E (47) is higher, my average P/E (35) is slightly lower than Member Sentiment (35.9) and Value Line (36). Although of questionable importance due to unknown correlation with other inputs, my projected low price of $232.30 is much lower than the average projected low price of $261.45. This could bias my study toward Sell.
A margin of safety gives me added confidence that the company can outperform relatively conservative inputs.
Categories: BetterInvesting® | Comments (0) | PermalinkIT Stock Study (2-14-23)
Posted by Mark on January 3, 2023 at 07:07 | Last modified: March 9, 2023 11:05I recently* did a stock study on Gartner Inc. (IT) with a closing price of $351.46.
CFRA writes:
> Gartner, Inc. (IT) is one of the world’s largest research and
> advisory providers. [Gartner] supplies business leaders with
> indispensable insights, advice, and tools to achieve their goals and
> help facilitate business outcomes. [Gartner] currently services
> more than 15,000 organizations in over 100 countries worldwide.
This medium-sized company has grown sales and earnings at annualized rates of 13.6% and 20.7% over the last 10 years, respectively. Lines are mostly up, straight, and parallel except for EPS in ’17-’18 (likely due to TCJA) and sales in ’20. Over the last 10 years (excluding ’17), PTPM has ranged from 4.6% (’18) to 20.5% (’21) with a last-5-year average of 11.7%. This leads peer averages and is roughly even with industry averages. Gartner has demonstrated some wild ROE swings ranging from -1819% (’16) to 226.9% (’21) with a last-5-year average (excluding ’21 and -1215% for ’22) of 21%.
Over the last five years, Debt-to-Capital averages an uncomfortable 78.1%, which is higher than peer and industry averages. Interest Coverage is 8, but was less than 4 from ’18-’20. Current and Quick Ratios don’t alleviate much concern at 0.64 and 0.51, respectively. Value Line gives Gartner a B++ for Financial Strength “despite its sizeable debt load.” Rather than pay down debt, the company bought back $1B in stock in ’22, which is about equal to its TTM FCF.
I assume long-term annualized sales growth of 7% based on the following:
- CNN Business projects 7.3% YOY and 8.7% per year for ’23 and ’22-’24, respectively (based on 8 analysts).
- YF projects YOY 8.3% and 10.3% for ’23 and ’24, respectively (9 analysts).
- Zacks projects YOY 8.7% and 10.6% for ’23 and ’24, respectively (3).
- Value Line projects 10% per year from ’22-’27.
- CFRA projects 7.5% YOY and 8.7% per year for ’23 and ’22-’24, respectively.
>
I am forecasting on the low side.
I assume long-term annualized EPS growth of 6% based on the following:
- CNN Business projects 16.3% YOY contraction and 1.5% contraction per year for ’23 and ’22-’24, respectively (based on eight analysts), along with a 5-year annualized growth rate of 6.2%.
- MarketWatch projects 4.5% and 8.2% growth per year for ’22-’24 and ’22-’25, respectively (10 analysts).
- Nasdaq.com projects 18.2% YOY growth and 17.3% growth per year for ’24 and ’23-’25, respectively (4, 4, and 2 analysts for ’23, ’24, and ’25).
- Seeking Alpha projects 4-year annualized growth of 13.4%.
- YF projects 16.3% YOY contraction and 16% YOY growth for ’23 and ’24, respectively (9), along with 5-year annualized growth of 6%.
- Zacks projects 15.8% YOY contraction and 18.2% YOY growth for ’23 and ’24, respectively (4), along with 5-year annualized growth of 6.5%.
- Value Line projects annualized growth of 10.5% from ’22-’27.
- CFRA projects contraction of 19.4% YOY and 4.6% per year for ’23 and ’22-’24, respectively, in addition to 5% annualized growth from ’21-’24.
>
I am forecasting at the bottom of the five-long-term-estimate range (mean 8.5%).
My Forecast High P/E is 35. Excluding ’17-’18, which were outliers over 100, high P/E went from 37 (’13) to 67.1 (’19) and has now come down to 35.9 (’22). The last-5-year average (excluding ’18) is 45.7. I am forecasting just below the range.
My Forecast Low P/E is 23. Excluding ’17-’18, which were outliers over 80, low P/E went from 24.1 (’13) to 47.9 (’19) and has now come down to 22.2 (’22). The last-5-year average (excluding ’18) is 28.1. I am forecasting at the bottom of the range.
My Low Stock Price Forecast (LSPF) is the default value of $229.80. This is 34.6% below the previous closing price and 3.8% above the 52-week low.
All this computes to an U/D ratio of 1.0, which makes IT a HOLD. The Total Annualized Return is 5.5%.
M* categorizes Gartner with a Wide economic moat (despite offering only quantitative analyst coverage).
PAR (using Forecast Average, not High, P/E) is 2%, though, which is much lower than desired for a medium-sized company. This is not a huge surprise as the stock is up almost 38% in the last 4.5 months.
To better understand margin of safety (MOS) in this study, I look to Member Sentiment (MS). Out of only 13 studies over the past 90 days (my own excluded), projected sales growth, projected EPS growth, and Forecast High P/E average 10.6%, 10.7%, and 45.6, respectively. My inputs are all lower. MS is quirky on Forecast Low P/E as three studies have values over 280. Excluding these, the average (10 studies) is 28.6, which is higher than mine. Value Line projects an average annual P/E of 30.5, which is higher than MS (37.1) and slightly higher than mine (29). All this is indicative of a healthy MOS.
What is not lower is my LSPF. MS has this 21% lower at $182. The ’21 low stock price was $149. In this regard, I don’t find MS to be unreasonable. It does imply a Forecast Low P/E of 18.2, however. As my P/E range is somewhat depressed already, I see no need to lower it further.
Somewhere and sometime, I think there’s a discussion to be had with regard to LSPF.
For any growth stock looking five years out, I never actually anticipate a future 52-week low (i.e. LSPF) to be lower than the current stock price. If I do, then I’m really predicting something horrible to happen to the company (e.g. losing its growth entirely), a stock market crash like we have never seen, a prolonged recession not seen in this country since the 1930’s (?), or some other Black Swan that I can’t imagine.
Consider a hypothetical range for LSPF from 20% below the last close to 30% [or more] below. Something seems contradictory about the fact that this can dramatically affect BUY vs. HOLD decisions today even though I fully expect stock price in five years to comfortably exceed the entire hypothetical range.
I’d love to hear some more experienced members weigh in on this.
>
*—Publishing in arrears as I’ve been doing one daily stock study while posting only two blogs per week.
GPN Stock Study (2-13-23)
Posted by Mark on December 16, 2022 at 07:05 | Last modified: March 8, 2023 14:08I recently* did a stock study on Global Payments Inc. (GPN) with a closing price of $117.88.
CFRA writes:
> Global Payments (GPN) provides payment processing and software
> solutions globally through a variety of distribution channels,
> which enable customers to accept card, electronic, check, and
> digital-based payments. Specific offerings include
> authorization, settlement, funding, customer support,
> chargeback, security, and billing services.
This medium-sized company has grown sales and earnings at annualized rates of 14.5% and 6.5% over the last 10 years, respectively. Visual inspection is not great. Revenue data is [missing for ’16 and] down in ’18 while EPS data is [missing for ’16 and] down in ’15, ’18, ’19, and ’20. Q2 and Q3 2022 EPS have declined sharply. [Stock] Price bars in ’17 and ’22 overlap, which represents several years without significant appreciation. PTPM, which averaged 14.6% from ’12-’14, has averaged 11.5% over the last five years. Although apparently in decline, this beats peer and industry averages.
ROE has averaged 4% over the last five years, which seems low. The industry averages 6%, though, while peers average 6.8% (both excluding ’20, which is -161% or worse). Debt-to-Capital, which ranged from 51.1% (’12) to 75.5% (’14) between ’12-’18, has averaged 28% over the last three years. The latter is less than peer and industry averages. Quick Ratio and Interest Coverage are a concerning 0.53 and 1.4, respectively.
The fact that so many analysts are covering this company gives me some [hopefully not illusory] assurance about its liquidity. Aside from all the analysts represented below, M* says the balance sheet is sound. Value Line gives a B++ financial strength grade and says “it should continue to easily meet its various obligations.” CFRA says expected FCF generation ($2.2B and $2.5B in ’22 and ’23, respectively) should allow leverage to return to historical levels by the end of ’23.
I assume long-term annualized sales growth of 8% based on the following:
- CNN Business projects 4.9% YOY growth and 6.6% per year for ’22 and ’21-’23, respectively (based on 27 analysts).
- YF projects YOY 6.3% and 9.2% growth for ’23 and ’24, respectively (24 analysts).
- Zacks projects YOY growth of 6.6% and 2.6% for ’23 and ’24, respectively (7).
- Value Line projects annualized growth of 8.3% from ’21-’26.
- CFRA projects 3.9% YOY contraction for ’23.
- M* provides a 2-year ACE of 1.6% growth and 8% growth per year through ’26 (analyst note).
>
I assume long-term annualized EPS growth of 10% based on the following:
- CNN Business projects 10.4% YOY and 12.5% per year for ’22 and ’21-’23, respectively (based on 27 analysts), along with 5-year annualized growth of 14.8%.
- MarketWatch projects 12.5% and 11.5% per year for ’22-’24 and ’22-’25, respectively (31 analysts).
- Nasdaq.com projects 11.8% YOY growth for ’24 (10 and 2 analysts for ’23 and ’24).
- Seeking Alpha projects 4-year annualized growth of 17%.
- YF projects YOY 11.4% and 14.5% for ’23 and ’24, respectively (24), along with 5-year annualized growth of 15.1%.
- Zacks projects YOY 9.9% and 13.6% for ’23 and ’24, respectively (7), along with 5-year annualized growth of 15.8%.
- Value Line projects annualized growth of 13.7% from ’21-’26.
- CFRA projects 14.5% YOY for ’23 and 3-year projected annualized growth of 15%.
- M* provides a long-term estimate of 16.6%.
>
My forecast is below the range of six long-term estimates (mean 15.5%).
As Q2 and Q3 of ’22 were atypically soft ($0.13 and $0.17/share, respectively), I will not originate the earnings projection from there. Given trendline ($2.90) or ’21 ($3.29), I choose the former (more conservative).
My Forecast High P/E is 35. Over the last 10 years, high P/E has trended up from 18.6 (’12) to 67.1 (’21) excluding upside outliers of 85.8 and 110.6 in ’19 and ’20. The last-5-year average (excluding outliers) is 49.2.
My Forecast Low P/E is 28. Over the last 10 years, low P/E has trended up from 14.3 (’12) to 35.5 (’21). ’19 and ’20 were high at 45.6 and 54.1, but not to an extreme. The last-5-year average is 38.3.
My Low Stock Price Forecast is $92.10. In projecting from the trendline, I also need to manually override EPS (to $2.90) rather than defaulting to TTM ($0.17) for calculation of the Low Stock Price Forecast. This is 21.9% below previous close, equal to the 52-week low, and below both ’20 and ’21 low stock prices.
Payout Ratio was below 3% in ’18 and earlier before averaging 25.8% over the last three years. I will assume 10% to be conservative.
All this computes to an U/D ratio of 2.6, which makes GPN a HOLD. The Total Annualized Return is 9.8%, but PAR (using Forecast Average, not High, P/E) is 7.5%: less than I want out of a medium-sized company.
To better interpret this, I use Member Sentiment (MS) to assess the study’s margin of safety (MOS). Out of 50 studies over the past 90 days (my own and two others with invalid low prices excluded), projected sales, projected EPS, Forecast High P/E, Forecast Low P/E, and Payout Ratio average 9.3%, 22.2%, 44.4, 29, and 13.9%, respectively. My inputs are all lower. Value Line projects an average annual P/E of 40, which is higher than MS (36.7) and me (31.5). MOS seems robust here.
MS has an extreme Low Stock Price Forecast of $63.83. This is over 30% lower than mine and below the 2017 low price. Eleven studies are in the single digits, which leaves me scratching my head. From the lowest price in the last three months to now, GPN has rallied 26.5%. This may explain some of the forecasts, but not those under $30/share.
Excluding these 15 studies, I get an MS Low Stock Price Forecast of $87.42, which seems more reasonable. This would equate to a Forecast Low P/E of 26.5 in my study. I will stick with my $92.10 because my forecast P/E range is low enough already.
>
*—Publishing in arrears as I’ve been doing one daily stock study while posting only two blogs per week.
TGT Stock Study (2-12-23)
Posted by Mark on December 8, 2022 at 06:43 | Last modified: March 8, 2023 10:36I recently* did a stock study on Target Corp. (TGT) with a closing price of $170.02.
Value Line writes:
> Target Corp.’s operations consisted of 1,926 discount stores,
> of which 1,528 were owned, in the U.S., mostly in Cal., Tex.,
> and Fla (as of 1/29/22)… Sales by category in fiscal ’21:
> beauty/household, 26%; hardlines, 18%; apparel/accessories,
> 17%; food, 20%; and home furnish., 19%.
This mega-sized company (annual revenue > $50B) has grown sales and earnings 3.4% and 13.1% per year over the last 10 years, respectively. Lines are mostly up except for dips in sales (’16) and EPS (’13 and ’16). PTPM over the last decade has ranged from 4.3% (’14) to 8.4% (’21) with a last-5-year average of 5.9%. This is higher than peer and industry averages.
ROE has trended up over the last 10 years from 18% (’12) to 32.5% in ’20 (’21 was an upside outlier at 48.1%) with a last 5-year average (excluding ’21) of 28.1%. This is higher than peer and industry averages. Debt-to-Capital has increased from 49.4% (’12) to 56.2% (’21) with a last-5-year average of 53.1%. This is also higher than peer and industry averages. Current Ratio is a suboptimal 0.86, but Interest Coverage is 10.8. M* assigns an Exemplary capital allocation rating while Value Line gives a B++ grade for financial strength.
I assume long-term annualized sales growth of 2% based on the following:
- CNN Business projects 2.5% YOY and 2.2% per year for ’22 and ’21-’23, respectively (based on 31 analysts).
- YF projects YOY 2.3% and 2.2% for ’23 and ’24, respectively (29 analysts).
- Zacks projects YOY 2.3% and 2.8% for ’23 and ’24, respectively (12).
- Value Line projects 3.8% annualized growth from ’21-’26 (11% from ’20-’26).
- CFRA projects growth of 2.8% YOY and 2.3% per year for ’23 and ’22-’24, respectively.
- M* provides a 2-year ACE of 2.1% and a 10-year estimate of 3% in its analyst note.
>
My estimate is just below all of the above.
I assume long-term annualized EPS growth of 2% based on the following:
- CNN Business projects a 59.3% YOY contraction and 17% contraction per year for ’22 and ’21-’23, respectively (based on 31 analysts), along with 5-year annualized contraction of 4.2%.
- MarketWatch projects annualized contraction of 15.9% and 5.5% for ’22-’24 and ’22-’25, respectively (36 analysts).
- Nasdaq.com projects annualized growth of 42.6% and 36.5% for ’23-’25 and ’23-’26, respectively [16, 10, and 2 analysts for ’23, ’25, and ’26].
- Seeking Alpha projects 5-year annualized growth of 10.5%.
- YF projects 59.1% YOY contraction and 70% YOY growth for ’23 and ’24, respectively (33), along with 5-year annualized contraction of 4.9%.
- Zacks projects 59.2% YOY contraction and 71.4% YOY growth for ’23 and ’24, respectively (16), along with 5-year annualized growth of 9.9%.
- Value Line projects annualized growth of 5.8% from ’21-’26.
- CFRA projects 56.8% YOY contraction and 15.9% contraction per year for ’23 and ’22-’24, respectively, and 1% growth per year from ’21-‘24%.
- M* projects long-term annualized growth of 4.8%.
>
I am projecting below the average [of six] long-term estimate[s] (3.6%).
I will override to project earnings from the last annual data point rather than Q3 ’22. Analyst consensus expects a big rebound in earnings for ’23, which is suggestive of a one-year anomaly due to the macroeconomic factors rather than maturation in business cycle. The latter has already occurred for this company.
The ideal situation would be to project from the same point analysts are using for their calculations, but because this is not explicitly disclosed, I have to do my best to work around it. Here, projection from the last quarterly data point or EPS trendline makes no sense because Forecast High Stock Price would be at or below the current stock price.
My Forecast High P/E is 17. Over the last 10 years, high P/E has ranged from 14.6 (’12) to 23.9 (’13) with a last-5-year average of 18.8.
My Forecast Low P/E is 10. Over the last 10 years low P/E has ranged from 9.1 (’17) to 18.2 (’13). The last-5-year average is 10.6. As suggested above, I think Target is a mature company so I don’t expect the kind of P/E compression that might be seen with a younger, more explosive growth company.
I’ve realized that I need to be very careful with the website and future EPS projection. Overriding the base on the estimated EPS growth rate screen leaves TTM EPS for the Low Stock Price Forecast. The latter may require changing as well.
My Low Stock Price Forecast is $137. The default value would be $141. This corresponds to ’21 earnings of $14.10/share and assumes 0% growth for the next five years. With the 52-week low price at $137.2, I’m overriding with $13.70/share to [roughly] match. $137 is 19.4% below the previous close.
Over the last 10 years, Payout Ratio has ranged from 22.4% (’21) to 51.5% (’13). The last-5-year average is 37.2%. I am assuming 31%.
All this computes to an U/D ratio of 2.9, which makes TGT a HOLD. The Total Annualized Return is 11.1%, and PAR (using Forecast Average, not High, P/E) is 6.6%, which is less than desired. Can I convince myself that the inherent margin of safety (MOS) in this study allows for a good chance of realizing Forecast High P/E?
To answer this, I compare my inputs with the larger sample size of Member Sentiment (MS). Out of 192 studies over the past 90 days (my own and four others with projected low prices above last closing price excluded), projected sales, projected EPS, Forecast High P/E, Forecast Low P/E, and Payout Ratio average 4.7%, 7.8%, 18.4, 11.3, and 38.4%, respectively. My inputs—especially the growth rates—are all lower. Value Line projects an average annual P/E of 15, which is barely higher than MS (14.9) and higher than mine (13.5). All this is indicative of a healthy MOS.
MS provides a[n] [average] Low Stock Price Forecast of $97.58, which is 28.8% lower than mine. It’s also closer to the 2020 [COVID crash] low of $90.20. In my opinion, a stock price five years from now > 20% below today’s price is almost unfathomable for [even] a[n] [anemic] growth company. This legitimizes my Low Stock Price Forecast. Forecasting close to the ’20 lows almost seems preposterous. I’d be curious to know if these MS studies were accompanied by a manual EPS override.
A significantly lower Low Stock Price Forecast would move TGT further into the Hold zone, but because this seems unreasonable I choose to ignore it as an offset to the MOS. The only remaining question in my mind is why CNN Business (FactSet) and YF (Refinitiv) project negative 5-year earnings growth when the other four do not.
That concern aside, I feel comfortable with TGT as a BUY under $169/share.
>
*—Publishing in arrears as I’ve been doing one daily stock study while posting only two blogs per week.
ULTA Stock Study (2-11-23)
Posted by Mark on December 1, 2022 at 07:23 | Last modified: July 18, 2023 13:49I recently* did a stock study on Ulta Beauty, Inc. (ULTA) with a closing price of $515.75.
M* writes:
> With roughly 1,350 stores and a partnership with narrow-moat
> Target, Ulta Beauty is the largest specialized beauty retailer
> in the U.S. The firm offers makeup (43% of 2021 sales),
> fragrances, skin care, and hair care products (20% of 2021
> sales), and bath and body items. Ulta offers private-label
> products and merchandise from more than 500 vendors. It also
> offers salon services, including hair, makeup, skin, and brow
> services, in all stores. Most Ulta stores are approximately
> 10,000 square feet and are in suburban strip centers.
This medium-sized company has grown sales and earnings at annualized rates of 15.7% and 16.6% over the last 10 years, respectively. The stock price has hardly seen a reprieve. Lines are mostly up, straight, and parallel except for an EPS decline in ’20. PTPM over the last decade has increased from 12.6% to 15% with a last-5-year average (excluding ’20, which was a downside outlier) of 13.3%. This is higher than BBWI (a peer) and industry averages.
ROE has increased from 24.2% to 47.3% over the last 10 years with a last-5-year average (excluding ’20) of 38.5%. This outpaces BBWI and industry averages. Debt-to-Capital was 0% until 2019 and has averaged 51.3% over the last three years (lower than BBWI and industry averages). This is all uncapitalized leases as the company has zero long-term debt.
I assume long-term annualized sales growth of 7% based on the following:
- CNN Business projects 16.3% YOY and 11.5% per year for ’22 and ’21-’23, respectively (based on 24 analysts).
- YF projects YOY 15.7% and 7.3% for ’23 and ’24, respectively (28 analysts).
- Zacks projects YOY 15.8% and 7.8% for ’23 and ’24, respectively (10).
- Value Line projects 4.4% annualized growth from ’21-’26 (12.5% from ’20-’26).
- CFRA projects growth of 15.6% YOY and 10.1% per year for ’23 and ’22-’24, respectively.
- M* provides a 2-year ACE of 12.1% and a 10-year estimate of 7.5% (analyst note).
>
I assume long-term annualized EPS growth of 8% based on the following:
- CNN Business projects 28.2% YOY and 16.3% per year for ’22 and ’21-’23, respectively (based on 24 analysts), along with a 5-year annualized growth of 12.7%.
- MarketWatch projects annualized growth of 18.9% and 14.8% for ’22-’24 and ’22-’25, respectively (29 analysts).
- Nasdaq.com projects 7.2% and 7.9% growth per year for ’23-’25 and ’23-’26, respectively [14, 8, and 1 analyst(s)].
- Seeking Alpha projects 4-year annualized growth of 23.9%.
- YF projects YOY 27.3% and 5.6% for ’23 and ’24, respectively (30), along with 5-year annualized growth of 12%.
- Zacks projects 5.6% YOY for ’24 and a 5-year annualized growth of 13.8% (14).
- Value Line projects 8.9% annualized from ’21-’26.
- CFRA projects 26.1% YOY and 12.8% per year for ’23 and ’22-’24, respectively, along with 23% per year from ’21-’24.
- M* provides a long-term estimate of 11%.
>
I am projecting well below the average [of seven] long-term estimate[s] (15%).
My Forecast High P/E is 23. Over the last 10 years, high P/E has ranged from 20 (’21) to 42.1 (’13) excluding the upside outlier in ’20 (99.8). The last-5-year average is 29.6 (excluding ’20). This has been trending lower.
My Forecast Low P/E is 15. Excluding the upside outlier in ’20 (39.9), over the last 10 years low P/E has trended down from 28.4 to 15.8. The last-5-year average (excluding ’20) is 18.1.
My Low Stock Price Forecast is the default value of $341.30. The 52-week low price is $330.80, which makes this reasonable despite being 33.8% below the last closing price. The stock has been on a tear lately.
All this computes to an U/D ratio of 0.9, which makes ULTA a HOLD. The Total Annualized Return is 5.3%, and PAR (using Forecast Average, not High, P/E) is 2.6%: less than the current yield on T-Bills.
To assess margin of safety (MOS) in this study, I compare my inputs with Member Sentiment (MS). Out of 536 studies over the past 90 days (my own and eight others with projected low prices above last closing price excluded), projected sales growth, projected EPS growth, Forecast High P/E, and Forecast Low P/E average 10.7%, 10.7%, 29.5, and 20.8, respectively. My inputs are all lower. Value Line projects an average P/E of 22, which is lower than MS (25.1) and higher than mine (19).
MS has a Forecast Low Stock Price of $287.67, which is ~15% below mine. This is no surprise given that the stock has rallied ~20% over the last three months; for many studies, this was calculated when the stock was lower.
Despite a decent MOS, I await prices under $423/share to revisit ULTA.
>
*—Publishing in arrears as I’ve been doing one daily stock study while posting only two blogs per week.
MED Stock Study (2-10-23)
Posted by Mark on November 18, 2022 at 06:38 | Last modified: March 7, 2023 14:27I recently* did a stock study on Medifast Inc. (MED) with a closing price of $109.45.
M* writes:
> Medifast Inc is a US-based company that produces, distributes
> and sells products concerning weight loss, weight management,
> and healthy living. The company generates its revenue from
> point of sale transactions executed over an e-commerce platform
> for weight loss, weight management, and other consumable
> health and nutritional products.
This [as of 2021] medium-sized company has grown sales and earnings at annualized rates of 17.3% and 30.6% over the last 10 years, respectively. Lines are mostly up and parallel except for a 2-3-year dip between ’14 and ’17. Since ’16, lines look more up, straight, and parallel. PTPM has increased from 6.9% in ’12 to 14.2% in ’21 with a last-5-year average of 13.8%. This just beats the industry average.
ROE has increased over the last 10 years from 17.6% to an eye-popping 82.1% and far outpaces industry averages. Zero long-term debt makes this even more impressive. Debt-to-Capital (as leases) over the last five years averages 6.4%, which is far below industry averages. Current Ratio is 1.49.
I assume long-term annualized sales growth of 5% based on the following:
- YF projects YOY 4.2% and 0.6% for ’22 and ’23, respectively, based on one analyst.
- Zacks projects 2.8% YOY growth and 0.7% YOY contraction for ’22 and ’23, respectively (one analyst).
- Value Line projects 5.6% annualized growth from ’21-’26.
>
I assume long-term annualized EPS growth of 4% based on the following:
- MarketWatch projects annualized contraction of 1.4% and 0.9% for ’21-’23 and ’21-’24, respectively, based on one analyst.
- Nasdaq.com projects 2% YOY growth and 3.3% growth per year for ’23 and ’22-’24, respectively [2, 2, and 1 analyst(s) for ’22, ’23, and ’24].
- YF projects 9.7% YOY contraction and 5.7% growth per year for ’22 and ’23, respectively (one analyst), along with 5-year annualized growth of 20%.
- Zacks projects 6.4% YOY contraction and 2% YOY growth for ’22 and ’23, respectively (two analysts).
- Value Line projects annualized growth of 4.6% from ’21-’26 and 12.3% from ’20-’26, but the latter may be [artificially high and] less meaningful as a result of base effects (i.e. a 60% YOY jump in ’21 EPS).
>
This is about as scant as analyst coverage can be, which makes long-term forecast difficult. I basically have 20% and 4.6%. Given one estimate, I might halve to get an acceptable margin of safety. With two, I am just using the lower number.
My Forecast High P/E is 17. Over the last decade, high P/E has ranged from 17 (’13) to 56.5 (upside outlier in ’18) with a last-5-year average (excluding the outlier) of 26.4. I am taking the low end of the range.
My Forecast Low P/E is 6. Over the last decade, low P/E has ranged from 5.6 (downside outlier in ’20) to 18.2 (’16) with a last-5-year average of 12.1. I am targeting the lower end of the range.
My Low Stock Price Forecast is the default value of $79.10. This is 27.7% below the previous closing price. It is also 17.6% below the 52-week low and 57% below the 2021 low.
All this computes to an U/D ratio of 5.4, which makes MED a BUY. The Total Annualized Return is 22.4%.
MED has a hefty dividend yield close to 6%. After dividend inception in ’15, Payout Ratio has ranged from 40.9% (’21) to 71.8% (’16) with a last-5-year average of 51.2%. I am forecasting below the entire range at 40%.
PAR is 14.5%, which is outstanding for a medium-sized company.
I use Member Sentiment (MS) to assess margin of safety (MOS) by getting some idea how likely the company may be to outperform my estimates. Out of 176 studies over the past 90 days (my own and 104 others with projected low prices above last closing price excluded), projected sales, projected EPS, Forecast High P/E, Forecast Low P/E, and Payout Ratio average 10%, 8.7%, 20.5, 11.2, and 50.1%, respectively. I am lower on all inputs. Value Line projects an average annual P/E of 20, which is higher than MS (15.8) and me (11.5). MOS seems healthy here.
MS Low Stock Price Forecast is $77.15—about 3% below mine. This would lower my U/D just a tad while effectively lowering the Forecast Low P/E, which I already selected to be sufficiently low.
As an aside, I’m surprised to see so many [now] invalid studies due to Low Stock Price Forecast > previous close. These studies are all from the past 90 days when MED traded no higher than $130.31. Forecast Low Stock Price is $130 or higher in 77 of those studies, which means they were invalid from the outset.
>
*—Publishing in arrears as I’ve been doing one daily stock study while posting only two blogs per week.
FIVE Stock Study (2-9-23)
Posted by Mark on November 10, 2022 at 07:26 | Last modified: March 6, 2023 13:34I recently* did a stock study on Five Below Inc. (FIVE) with a closing price of $199.04.
Value Line writes:
> Five Below, Inc. offers a broad range of merchandise targeted
> to the teen and pre-teen customer. Most products are priced
> at $5 or below, with some in the $6-$10 range (Five Beyond).
> Products are in the following category worlds: Style, Room,
> Sports, Tech, Create, Party, Candy, and Now.”
This medium-sized company has grown sales and earnings at annualized rates of 22.5% and 26.6% over the last 10 and nine (excluding a loss in ’12) years, respectively. Lines are mostly up, straight, and parallel except for an EPS decline in ’20. PTPM over the last decade has ranged from 7.8% (’20) to 12.9% (’21) with a last-5-year average of 11.5%. This is higher than peer and industry averages.
ROE has fallen from 35.9% (’13) to 26.7% (’21) with a last-5-year average of 25%, which is better than peer and industry averages. The debt-to-capital ratio has averaged 33% over the last five years, which is lower than peer and industry averages. FIVE has zero total debt and a Current Ratio of 1.5.
I assume long-term annualized sales growth of 12% based on the following:
- CNN Business projects 10.7% YOY and 13.4% per year for ’22 and ’21-’23, respectively (based on 23 analysts).
- YF projects YOY 7.4% and 17.2% for ’23 and ’24, respectively (23 analysts).
- Zacks projects YOY 7.4% and 17.4% for ’23 and ’24, respectively (9).
- Value Line projects 17.9% annualized from ’21-’26.
- CFRA projects 7.1% YOY and 12% per year for ’23 and ’22-’24, respectively.
- M* provides a 2-year ACE of 12.4% and a 10-year estimate of 13% (analyst note).
>
I assume long-term annualized EPS growth of 17.3% based on the following:
- CNN Business projects a 5.5% YOY contraction and 6.7% growth per year for ’22 and ’21-’23, respectively (based on 23 analysts), along with a 5-year annualized growth rate of 20.5%.
- MarketWatch projects annualized rates of 6.7% and 11.7% for ’22-’24 and ’22-’25, respectively (26 analysts).
- Nasdaq.com projects annualized rates of 20.6% and 25.7% for ’23-’25 and ’23-’26, respectively [8, 6, and 1 analyst(s) for ’23, ’24, and ’25].
- Seeking Alpha projects 4-year annualized growth of 24.8%.
- YF projects YOY 5.5% contraction and 20.7% growth for ’23 and ’24, respectively (24), along with 5-year annualized growth of 12.2%.
- Zacks projects YOY 5.5% contraction and 20.1% growth for ’23 and ’24, respectively (11), along with a 5-year annualized growth rate of 19%.
- Value Line projects annualized growth of 17.3% from ’21-’26.
- CFRA projects 6.9% YOY contraction and 6.9% growth per year for ’23 and ’22-’24, respectively, along with a 3-year annualized growth rate of 37% [after inquiring, CFRA changed this to NMF due to misleading base effects].
- M* provides a long-term estimate of 18.3%.
>
2022 earnings are in decline and because I believe this to be an isolated event, I will look to exclude the recent quarters. I can do this by projecting from the 2021 data point with my desired 13% growth rate. This is equivalent to projecting from the last quarterly data point ($4.11/share) with a 17.3% growth rate. Doing the latter keeps with the default approach, which will probably be more commonly applied in Member Sentiment (see MS below) studies.
While this type of manual override is more aggressive than my usual methodology, I am still lower than all but one (YF) of six long-term analyst estimates (mean 19.5%).
My Forecast High P/E is 36. Since 2013, High P/E has ranged from 39.5 (’15) to 93.7 (’13) with a last-5-year average of 55.3. I expect that to come down to earth at some point.
My Forecast Low P/E is 25. Since 2013, Low P/E has ranged from 20.2 (’17) to 58.7 (’13) with a last-5-year average of 25.1. I would typically project 20 in such a case, but I’m electing to be more aggressive.
My Low Stock Price Forecast is the default value of $102.80. Although more than the 20% “rule of thumb” below the previous closing price [-48%], I think it reasonable being only 6.1% less than the 52-week low. Raising the Low Stock Price Forecast would effectively be raising the Forecast Low P/E, which is already at my upper limit of comfort.
All this computes to an U/D ratio of 1.3, which makes FIVE a HOLD. The Total Annualized Return (TAR) computes to 10.5%.
PAR, which is based on Forecast Average (not High) P/E, is 6.9%: lower than I want to see for a medium-sized company.
I use MS to assess margin of safety (MOS) by getting an idea how likely the company may be to outperform my estimates. Out of 345 studies over the past 90 days (my own and two others with projected low prices above last closing price excluded), projected sales, projected EPS, Forecast High P/E, and Forecast Low P/E average 15.2%, 16.1%, 39.2, and 25, respectively. My inputs are not substantially different, which means my study has negligible MOS. Value Line projects an average annual P/E of 30, which is just lower than mine (30.5) and lower than MS (32.1).
I will look to revisit FIVE under $159/share.
>
*—Publishing in arrears as I’ve been doing one daily stock study while posting only two blogs per week.
OLLI Stock Study (2-8-23)
Posted by Mark on November 4, 2022 at 07:00 | Last modified: March 5, 2023 13:30I recently* did a stock study on Ollie’s Bargain Outlet Holdings (OLLI) with a closing price of $56.75.
M* writes:
> Ollie’s Bargain Outlet Holdings Inc is a retailer of brand name
> merchandise at drastically reduced prices. It offers customers a
> selection of brand name products, including housewares, food,
> books and stationery, bed and bath, floor coverings, toys, and
> hardware. It operates stores across the Eastern half of the
> United States. Its differentiated go-to-market strategy is
> characterized by a unique, fun and engaging treasure hunt
> shopping experience, compelling customer value proposition and
> witty, humorous in-store signage and advertising campaigns.
> These attributes have driven rapid growth and strong and
> consistent store performance for the company.
This medium-sized company has grown sales and earnings at annualized rates of 16.9% and 32.4%, respectively, over the last nine years. Lines are mostly up, straight, and parallel until 2021 when sales dipped and EPS started to fall. Over the last 10 years, PTPM has been higher than peer (stated as PSMT, DOL.TO, and BIG) and industry averages, increasing from 5.7% in ’13 to 15.4% in ’20 before starting to decline. The last-5-year average is 12.9%.
Since 2015, ROE has increased from 7% to 19% (’20) before heading lower. The last-5-year average is 15.2%, which is lower than peer and industry averages. The debt-to-capital ratio has fallen from 37.7% in ’13 to 25.1% in ’21. This is just over the last-3-year average and lower than peer and industry averages. Long-term debt is minuscule with most debt being uncapitalized leases. Current ratio is 2.83.
I assume long-term annualized sales growth of 5% based on the following:
- CNN Business projects flat YOY and 5.4% growth per year for ’22 and ’21-’23, respectively (based on 15 analysts).
- YF projects YOY 3.8% and 9.9% for ’23 and ’24, respectively (15 analysts).
- Zacks projects YOY 3.8% and 10.6% for ’23 and ’24, respectively (6).
- Value Line projects 9.8% growth per year from ’21-’26.
- CFRA projects 3.8% YOY and 7% per year for ’23 and ’22-’24, respectively (14).
- M* provides a 2-year annualized estimate of 7.8%.
>
I assume long-term annualized EPS growth of 6% based on the following:
- CNN Business projects a 33.1% YOY contraction and 0.2% growth per year for ’22 and ’21-’23, respectively (based on 15 analysts) along with 5-year annualized growth of 0.5%.
- MarketWatch projects 0.9% and 7.1% growth per year for ’22-’24 and ’22-’25, respectively (20 analysts).
- Nasdaq.com projects 49.4% YOY and 32.2% per year for ’24 and ’23-’25, respectively (7, 7, and 3 analysts).
- Seeking Alpha projects 5-year annualized growth of 15.8%.
- YF projects YOY 33.1% contraction and 50% growth for ’23 and ’24, respectively, along with 5-year annualized growth of 7.5% (15).
- Zacks projects YOY 33.1% contraction then 49.4% growth for ’23 and ’24, respectively, along with 5-year annualized growth of 12.1% (7).
- Value Line projects 13.8% annualized growth from ’21-’26.
- CFRA projects YOY 35% contraction and 0.6% contraction per year for ’23 and ’22-’24, respectively (14).
>
While my forecast is lower than the average of five longer-term growth rates (10.5%), I am overriding projection from the last annual (not quarterly) data point. The latter is a more aggressive calculation.
My Forecast High P/E is 29. Over the last seven years, high P/E has ranged from 29.8 (’17) to 48.1 (’19) with a last-5-year average of 39.8.
My Forecast Low P/E is 15. Over the last seven years, low P/E has ranged from 7.8 (potentially a downside outlier in ’20) to 24.7 (’18 and ’19) with a last-5-year average (excluding the 7.8) of 20.6.
My Low Stock Price Forecast is $36.50 based on the annual (not quarterly) earnings as mentioned above. This is just below the 52-week low price and 35.7% below the previous closing price.
All this results in an U/D ratio of 1.9, which makes OLLI a HOLD. The Total Annualized Return (TAR) computes to 10.7%.
PAR is 4.7%, which is lower than desired for a medium-sized company.
To assess margin of safety (MOS), I compare my inputs with those from Member Sentiment (MS). Out of 200 studies over the past 90 days (excluding my own along with 14 others with Low Stock Price Forecast above last closing price), projected sales, projected EPS, Forecast High P/E, and Forecast Low P/E average 10.9%, 11.8%, 31.1, and 18.3, respectively. I am lower on all inputs. Value Line projects an average annual P/E of 24, which is slightly lower than MS (24.7) but higher than mine (22).
Overall, I appear to have a decent MOS built into this study, but I need to see the stock fall ~10% before considering a purchase for longer-term investment
>
*—Publishing in arrears as I’ve been doing one daily stock study while posting only two blogs per week.