Category Archives: Valuation

Top 20 Undervalued Stocks by Market Cap Class November 2021 Energy Sector

What are the top 20 Undervalued Stocks (selected over 5 market cap classes) in the Energy Sector? I have used the analysis tools on the website stockcalc.com to generate the content of this blog post. Have a look down the Welcome page www.stockcalc.com/Welcome for some of the free lists and reports available.

Or start your StockCalc 30 Day Free Trial

Undervalued Stocks – Energy Sector

Today our focus is the Energy sector and we are looking at companies that are undervalued based on our Weighted Average Valuation (WAV) calculation which we do for the 8000 stocks each night in the StockCalc database.

The Energy sector is comprised of companies in the following Industry groups: Oil & Gas Drilling, E&P, Integrated, Midstream, Refining & Marketing, Equipment & Services as well as Thermal Coal and Uranium.

The sector includes companies that are engaged in exploring, drilling, producing, manufacturing, refining, marketing and transporting of petroleum and natural gas as well as companies that own and operate oilfield pipelines or refine, gather, market, and sell petroleum and petroleum products. This group also includes companies that mine thermal coal or mine, refine, produce, and mill uranium and uranium-related materials.

The stocks are generally held both for their dividends and capital appreciation.

We generate our Weighted Average Valuation (WAV) from 5 models and Analyst consensus. Overview of the models used: Discounted Cash Flow (DCF value) is a valuation technique where cash flow projections are discounted back to the present to calculate value per share. A Comparables model values the company on the basis of ratios from selected comparable companies. We actually do 3 types of comparables models. An Adjusted Book Value (ABV) is calculated by multiplying book value per share by its historical Price to Book ratio. If we have Analyst coverage we look at the consensus target price.

Today’s Data – Energy

In the table below we can see the close price (Nov 26th 2021) and valuation for these companies along with the ratio of valuation to price as well as their market cap class and average trading volume.

Stock Symbol Company Name Close Price($) Valuation ($) Value/ Price M Cap Class Average Volume
PTR-N PetroChina Co 44.28 60.14 1.36 Large Cap 269946
TRP-N TC Energy 47.63 53.16 1.12 Large Cap 1203292
TOU-T Tourmaline Oil 43.96 48.64 1.11 Large Cap 2937667
SNP-N China Petroleum 46.85 51.26 1.09 Large Cap 200676
ENB-N Enbridge 39.72 43.04 1.08 Large Cap 4829399
WES-N Western Midstream 21.13 26.05 1.23 Mid Cap 830993
ETRN-N Equitrans Midstream 10.21 12.33 1.21 Mid Cap 2631998
CTRA-N Coterra Energy 19.99 23.77 1.19 Mid Cap 7171731
PKI-T Parkland 34.20 39.68 1.16 Mid Cap 477090
ENBL-N Enable Midstream Partners 7.40 8.50 1.15 Mid Cap 681337
TGS-N Transportadora de Gas 4.84 7.90 1.63 Small Cap 169565
HWX-T Headwater Exploration 4.71 7.14 1.52 Small Cap 1102829
PBFX-N PBF Logistics 12.47 16.52 1.32 Small Cap 281505
SRLP-N Sprague Resources 15.78 20.66 1.31 Small Cap 61678
CIVI-N Civitas Resources 51.80 67.00 1.29 Small Cap 505568
HMLP-N Hoegh LNG Partners 4.65 9.57 2.06 Micro Cap 95340
TNP-N Tsakos Energy Navigation 7.80 16.00 2.05 Micro Cap 107912
ITE-T i3 Energy 0.19 0.36 1.92 Micro Cap 418814
GLOP-N GasLog Partners 4.93 8.61 1.75 Micro Cap 210116
BPT-N BP Prudhoe Bay 4.00 5.81 1.45 Micro Cap 196440

N-NYSE, Q-Nasdaq, A-American, T-Toronto, X-Toronto Venture

Lets look at a few companies…

Lets look at a couple of the companies on this list to get a better understanding of them.

TC Energy

https://www.tcenergy.com
TransCanada Corp is an energy infrastructure company. Its business segments include, Natural Gas Pipelines, Liquid Pipelines and Energy. The company has pipeline and power generation assets in Canada, the United States, and Mexico.

Tsakos Energy Navigation

https://www.tenn.gr
Tsakos Energy Navigation Ltd operates crude oil and petroleum product tankers which provide marine transportation services for national, major and other independent oil companies and refiners. It also transport liquefied natural gas.

The content presented here is in part from the website stockcalc.com and is provided on an as is or as available basis with all faults and may not be current in all cases. You should not rely on any of the information as authoritative or as a substitute for the exercise of your own skill and judgment in making an investment decision.

Quantitative Analysis and Multiple Linear Regression Modeling using StockCalc Valuation data

Quantitative Analysis and Multiple Linear Regression Modeling
using StockCalc Valuation data

September 2021

Executive Summary:

StockCalc is a fundamental valuation platform. We generate valuations each night for the 8000 equities trading on NYS, NAS, ASE, TSX and TSX-V using an algorithmic approach that has been historically correct 78% of the time.

To build upon our existing product, we created a series of multiple linear regression models. We included the 6 fundamental valuation data points we generate each night (described below) along with technical indicators (Moving Averages, RSI, MACD) and commodity prices.

Using the R programming language we built linear regression models for each stock each night to enable us to test the dependent variables of recent close price, price 13, 26 or 52 weeks later against the series of independent variables (our fundamental valuations, technical indicators and commodity prices)

Our goal was to determine if we could improve upon our current approach to calculating a weighted average valuation (“The Algo”) by using this MLR approach (“The MLR”). Our current approach is correct 78% of the time going out 12 months. That means our valuation is reached 78% of the time over the next 12 months (we refer to as %success) with an average 10.2% difference between close price and our valuation (we refer to as %difference).

From the Analysis …

Near dated regression models (using most recent Close price) were able to outperform The Algo. We looked at both % success rate and % difference (price versus valuation) when making this determination.

Of note: the % difference we refer to in this document shows what the results would be if we assume returns are locked in when price reaches our valuation. Part of the analysis then looked at additional upside if we used a trailing stop protocol to let winning stocks continue to run out for 52 weeks. Those results exceed 40% annual returns once we netted winners against losers (winners up 77%, losers down 20 %)

Stocks on average reach our valuation in 13 weeks implying we can be running these models multiple times each year to magnify the returns. We will be doing more work on this to better quantify results for multiple successful models per year.

Contents

Executive Summary:
Focused on valuation; empowered by analytical tools.
Background:
“The Algo”
Methodology aka “The MLR”
SQL
Back-testing:
Initial Results:
Improving the Results:
The difference between markets:
The finer details:
There is more upside here:
How can you use/access this data?
About the author
Appendix 1: Description of the 5 fundamental valuation models used in Stockcalc
Appendix 2: Independent variables available for the regression models

Figures and Tables

Table 1 Initial regression results – various indexes
Table 2 Extended Results – Capturing 10% or more difference
Table 3 Comparing pre/including Covid results

Figure 1 Regression set-up for 13, 26 and 52 week analysis
Figure 2 sample regression logic using ADBE:NAS

Focused on valuation; empowered by analytical tools.

StockCalc is a company focused on providing the platform and data to enable its clients to undertake Fundamental Valuation of publicly traded companies. The modules that have been created help those looking to analyze companies arrive at a more thorough understanding of the value of the equity in the company they are examining.

Background:

The Stockcalc database contains 8000 equities that are run through 5 fundamental valuation models each night. We also examine Analyst consensus data and will use it if it out-performs our analysis (This occurs 5-15% of the time) Our data and analysis is available for advisors and analysts on TD Ameritrade’s Veo open Access platform as well as Schwab’s Advisor platform. StockCalc is also available in the Globe and Mail platform in Canada.

We generate up to 6 valuation points for each company in the database each night.

DCF: Discounted Cash Flow
PComps: Price Based (PE, PB, PCF) comparables
OComps: Other comparables (for companies that are not profitable)
Mul: Multiples (A comparables using the companies’ historic data)
ABV: Adjusted Book value
Analyst: Consensus Analyst Target Value

A detailed description of each of these is available in Appendix 1

Each night once all the models have been run for the 8000 stocks in the database we generate a Weighted Average Valuation (WAV) for each stock using an algorithm that selects the various models based on a series of criteria (industry, historic accuracy, range) and weighting.

From 2013 to mid 2020 our WAV values have been correct 78% of the time for the S&P 500 list of companies looking out over the next 12 months (ie Close price moved beyond our WAV over the next 12 months 78% of the time). We wanted to see if we could improve on that by generating an MLR model for each company each day. Using an MLR model approach also allowed us to incorporate other independent variables such as technical indicators and commodity prices.

“The Algo”

Looking at the S&P 500 list The Algo modeling has been correct 78% of the time: We define that as the price reached our valuation (either to the up or down side) 78% of the time over the next 12 months. By comparison, analyst consensus data is correct on average 50% of the time (various studies)

From 2013-01-01 to 2020-06-30 (ie 52 weeks ago so we can test against next 52 weeks)

Our Dataset has 368,221 records of daily weighted average valuations (we call those our WAV’s)

# records where our WAV was > ClosePrice and next 52 Week high > WAV: 140,897
# records where our WAV was <= ClosePrice and next 52 Week low <= WAV: 146,845
(140897 + 146845) / 368221 = 78%

Notes: models were initially constructed first of the month until Aug 2018 when we started running them daily for the 8000 stocks in the database.

Methodology aka “The MLR”

The regression set-up:

Each night we run the fundamental models against the 8000 stocks in our database. We constructed code using the R programming language (https://www.r-project.org/about.html) to enable us to select the data and build the regression models. We used the same daily valuation data as mentioned in The Algo to ensure consistency. We then constructed a series of linear regression models using R. Each stock was regressed each day after 50 days of data was available (generally the models started early 2017 as we had monthly data until 2018)

We tested four (4) time frames with our modeling:

Recent close price: We programmatically built the regression models using all data from 2013-01-01 to the run date less 1 day then plugged the current days model values (Fundamentals like DCF, Comparables etc along with technical or commodity prices if selected by the regression equation) to generate what the recent close price should be based on the regression equation.

Price 13, 26 and 52 Weeks later: For the other 3 time frames we needed to go back 13, 26 or 52 weeks into the data to construct the regression models as our dependent variable was the actual price 13, 26 or 52 weeks later so we could not use their present day values. We then used the recent day fundamental, technical or commodity prices (as selected by the regression equation) to generate a next 13, 26 and 52 week price estimate.

It is very important to re-iterate for these three time frames we needed to go back 13, 26 or 52 weeks into the data to construct the regression models as our dependent variable was the actual price 13, 26 or 52 weeks later. This meant we would be using data from 2013-01-01 to a given date to generate the regression equation then plugging in the data from the date we were calculating which was 13, 26 or 52 weeks later. You will see the impact in the results tables later on. The following figure depicts the set-up:



Figure 1 Regression set-up for 13, 26 and 52 week analysis

SQL:

The initial results from the r programs were written to excel then imported into our SQL database for easier processing. Our SQL database contains all the analysis we undertake each night along with the financial, ratio and price data used to generate the valuations.

Determining Model Success:

To determine if our estimate calculations were correct we compared our estimate price to most recent close to first determine if we show the stock as under or over-valued. We then looked out 13, 26 or 52 weeks to see if the High (if undervalued) or Low (if Overvalued) went beyond our estimate price. If they did we considered the model successful for that stock, date and time frame.

In the table below we show these details for Adobe (ADBE :NAS) as of Dec 31, 2018 close.

There are four reference points: Close, 13, 26 and 52 which refer to when (in the past) the regression equation was constructed (using last nights close data back to 52 weeks ago) The data from the date we are running was then run though each of those regression equations to determine what we calculate the price would be Today, 13 , 26 and 52 weeks from now.



Figure 2 Sample regression logic using ADBE:NAS

Our valuation database contains analyses going back to January 1st, 2013. For each company in the S&P 500 we generated an MLR for each date up to June 30th 2020 (52 Weeks), Dec 30th (26 week), (Mar 31st 2021 (13 Week) and June 30th 2021 (Recent close)

Initial Results:

We started by selecting all stocks in a given ETF to proxy the index lists. We used the DIA (Dow 30), SPY (S&P 500), QQQ (Nasdaq 100), IWM (Russell 2000) and XIU (Canada – SP/TSX 60). In the r code we ran each stock each day once we had 50 days of valuation available (we had monthly valuations 2013-mid-2018 then daily thereafter).

From the table below you see the initial results: For example our Algo (WAV columns) for the SPY was correct 76.93 % of the time with an average spread of 7.62% between the close price and what our valuation calculation was. Looking across the columns you see the close price had the highest % success due to the smallest time frame. It also had the least spread between price and value. For the DIA and SPY The Algo outperformed the regressions built with 52 and 26 week old data but the 13 week old data was more correct than our Algo with higher % difference between price and value.

The r2 column shows the minimum value selected based on each equations r2 value. For each model each day we captured the r2 value and used it to help in the selection. We did not track r2 for WAV.

This was the base case run to understand how The Algo compared to the MLR.


Table 1 Initial regression results – various indexes

Improving the Results:

In the next step we started to select sub-groups of data to run though the regression models. In this example we selected all stocks that showed a 10-50% difference between price and our valuation (for the Close, 13, 26 and 52 week analysis).

In the table below you can see there are 2 things happening compared to the previous table. Our average % difference between price and value has jumped to between 12 and 25% and our % success has been reduced due to the higher spread between price and value.

Note how well the close price columns performed in this table. We see a 75 to almost 90% success rate using 1 day old data to generate the regression equations with the % difference ranging from 12 to 17%. (Again noting results shown assume returns are locked in when price reaches our valuation – more on this below)

The Algo was able to outperform on the XIU data here (S&P/TSX 60 stocks) is also of note.


Table 2 Extended Results – Capturing 10% or more difference

The difference between markets:

As you can also see from the tables above we show smaller % difference between price and value for the DOW (DIA) than the SPY and IWM. This inherently makes sense given the coverage and ownership the DOW 30 stocks have compared to for example the Russell 2000 list.

The finer details:

To eliminate the impact of Covid on the markets we also tested data from 2017-2019. You can see the numbers remained consistent with the 2018 markets dragging down overall results slightly.


Table 3 Comparing pre/including Covid results

The real value starts here:

The results shown above assume returns are locked in when price reaches our valuation. To fine tune this further we selected the S&P 500 list of Undervalued stocks to Dec 31 2019 (to eliminate Covid impact again) where our models were 20% or higher than close price. We had 40 stocks during that time period meeting this criteria (64 records including Stocks that met the criteria more than once).

Thirty-five of these stocks were successful (our valuation target was exceeded over next 12 months) for an average return of 77% when we let these stocks run out for 52 weeks. The 5 stocks that were not successful had an average return of -20% 52 weeks later for a combined return of 42.5%. A trailing stop program would easily capture this additional return.

In our database, our WAV valuation models on average are being reached within 13 weeks. This implies the returns we presented in Table 2 could be achieved four times each year. The net 13 week return column in Table 2 ranges from 10 to 15% therefore 40% to 60% returns less negative returns for those stocks not achieving valuation.

The next steps in this process will be analyzing the data further to construct a protocol that can select the superior model (WAV, Close, 13) as well as reassessing when price reaches our valuation to see if we would continue to hold the equity.

How can you use/access this data?

The ability to slice and separate the data is inherent in the r code and resulting SQL database. We are well positioned to assist you with this data and analysis. StockCalc has a powerful API that provides connections for funds and firms looking to access this data. For more information please reach out to Brian to discuss

About the author

Brian Donovan is the President of StockCalc and is a Chartered Business Valuator (CBV – CICBV Website). He obtained in Finance MBA in 1999 from Wilfrid Laurier University in Canada and worked in a variety of capacities from MyPlant.com in the dot com days to founder of StockCalc in 2013. Brian can be reached by email at brian.donovan@stockcalc.com

Appendix 1: Description of the 5 fundamental valuation models used in Stockcalc

Discounted Cash Flow (DCF)
Discounted Cash Flow (DCF) valuation is a cash flow model where cash flow projections are discounted back to the present to calculate value per share. DCF is a common valuation technique especially for companies undergoing irregular cash flows such as resource companies (mining, forestry, oil and gas) going though price cycles or smaller companies about to generate cash flow (junior exploration companies, junior pharma, technology firms…).

Price Comparables
The Price Comparables valuation is the result of valuing the company we are looking at on the basis of ratios from selected comparable companies: Price to Earnings, Price to Book, Price to Sales, Price to Cash Flow, Enterprise Value (EV) to EBITDA. Each of these ratios for the selected comparable companies are averaged and multiplied by the values for the company we are interested in to calculate a value per share for our selected company.

Other Comparables
We have included the Other Comparables as a way to value companies that cannot be valued using Earnings based ratios. This technique is very useful for companies still experiencing negative cash flows such as mining exploration firms. We use Cash/Share, Book Value/Share, MarketCap, 1 Year Return, NetPPE as the ratios here. Each of these ratios for the selected comparable companies are averaged and multiplied by the values for the company we are interested in to calculate a value per share for our selected company.

Multiples
Multiples are similar to Price comparables where we look at current or historic ratios for the company in question to assess what it should be worth today based on those historic ratios. We use the same 5 ratios as in the price comparables and value the company with its historic averages.

Adjusted Book Value
With Adjusted Book Value (ABV) we calculate the book value per share for the company based on its balance sheet and multiply that book value per share by its historical price to book ratio to calculate a value per share.

Analyst Consensus
If we have Analyst coverage for the company we use the consensus target price here.

Appendix 2: Independent variables available for the regression models

Valuation:
DCF, P_Comps, O_Comps, Multiples, Adjusted Book, Analyst Consensus

Technical:
30 and 200 Day moving averages, MACD, RSI

Commodity:
Natural Gas, WTI, Brent, Gasoline, Propane
Aluminum, Copper, Nickel, Steel, Zinc, Iron Ore, Coal, Cobalt, Lead, Moly, Tin
Gold, Silver, Platinum, Palladium,
Lumber, Corn

Top 20 Undervalued Stocks by Market Cap Class March 2021: Health Care

What are the top 20 Undervalued Stocks (selected over 5 market cap classes) in the Health Care Sector? I have used the analysis tools on the website stockcalc.com to generate the content of this blog post. Have a look down the Welcome page www.stockcalc.com/Welcome for some of the free lists and reports available.

Or start your StockCalc 30 Day Free Trial

Undervalued Stocks – Health Care Sector

Today our focus is the Health Care sector and we are looking at companies that are undervalued based on our Weighted Average Valuation (WAV) calculation which we do for the 8000 stocks each night in the StockCalc database. The Health Care sector is comprised of companies in the following Industry groups: Biotechnology, Drug Manufacturers, Healthcare Plans, Providers & Services, Medical Devices, Instruments, Diagnostics, Research and Distribution. Companies in this Sector range in activities from research and discovery through to development and production of innovative drug and drug related technologies. They also include medical software, diagnostics, equipment, retail drug sales through to managed health products and services. The mature companies in this sector tend to have steady revenues and earnings through the economic cycles. The stocks are also held for their dividends.

We generate our Weighted Average Valuation (WAV) from 5 models and Analyst consensus. Overview of the models used: Discounted Cash Flow (DCF value) is a valuation technique where cash flow projections are discounted back to the present to calculate value per share. A Comparables model values the company on the basis of ratios from selected comparable companies. We actually do 3 types of comparables models. An Adjusted Book Value (ABV) is calculated by multiplying book value per share by its historical Price to Book ratio. If we have Analyst coverage we look at the consensus target price.

Today’s Data – Health Care

In the table below we can see the close price (Mar 15th 2021) and valuation for these companies along with the ratio of valuation to price as well as their market cap class and average trading volume.

Symbol Company Name Close Price($) Valuation ($) Value/ Price Class Average Volume
GRFS-Q Grifols 16.05 25.46 1.59 Large Cap 1252042
REGN-Q Regeneron Pharmaceuticals 483.94 670.01 1.38 Large Cap 725117
VRTX-Q Vertex Pharmaceuticals 219.65 281.29 1.28 Large Cap 1539755
FMS-N Fresenius Medical Care 36.32 45.43 1.25 Large Cap 514545
GSK-N GlaxoSmithKline 35.88 44.13 1.23 Large Cap 6011590
OPK-Q OPKO Health 4.72 6.11 1.29 Mid Cap 9264797
CMD-N Cantel Medical 78.43 100.00 1.28 Mid Cap 755123
GLPG-Q Galapagos 83.08 106.05 1.28 Mid Cap 142367
SAGE-Q Sage Therapeutics 79.32 99.00 1.25 Mid Cap 400545
EXEL-Q Exelixis 24.17 29.91 1.24 Mid Cap 2098945
SUPN-Q Supernus Pharmaceuticals 26.80 54.25 2.02 Small Cap 282360
CPRX-Q Catalyst Pharmaceuticals 3.94 7.27 1.84 Small Cap 1443936
CHRS-Q Coherus BioSciences 15.86 27.37 1.73 Small Cap 823515
CO-N Global Cord Blood 4.58 6.66 1.45 Small Cap 59174
GUD-T Knight Therapeutics 5.20 7.19 1.38 Small Cap 508236
HAPP-Q Happiness Biotech Gr 2.08 3.97 1.91 Micro Cap 316488
DR-T Medical Facilities 6.76 9.30 1.38 Micro Cap 77223
VYGR-Q Voyager Therapeutics 5.80 6.77 1.17 Micro Cap 422267
LABS-T MediPharm Labs 0.53 0.61 1.16 Micro Cap 4424442
CRHM-A CRH Medical 3.89 4.45 1.14 Micro Cap 375956
DN-T Delta 9 Cannabis 0.52 0.57 1.10 Nano Cap 245179

N-NYSE, Q-Nasdaq, A-American, T-Toronto, X-Toronto Venture

Lets look at a few companies…

Lets look at a couple of the companies on this list to get a better understanding of them.

Regeneron Pharmaceuticals

http://www.regeneron.com
Regeneron Pharmaceuticals Inc is an integrated biopharmaceutical company. It discovers, invents, develops, manufactures, and commercializes medicines for the treatment of serious medical conditions.

Cantel Medical

http://www.cantelmedical.com
Cantel Medical Corp is dedicated in delivering infection prevention products and services for patients, caregivers, and other healthcare providers which improve outcomes, enhance safety and help save lives.

Medical Facilities

https://www.medicalfacilitiescorp.ca
Medical Facilities Corp is engaged in controlling interests, through its subsidiaries, in specialty hospitals and an ambulatory surgery center. The specialty surgical hospitals perform scheduled surgical, imaging and diagnostic procedures.

Generate lists and valuations like this in StockCalc – have a look here (Free Trial)

Top 25 Undervalued Stocks by Market Cap Class January 2021: Consumer Cyclicals

What are the top 25 (22 this month) Undervalued Stocks (5 by 5 market cap classes) in the Consumer Cyclicals Sector? I have used the analysis tools on the website stockcalc.com to generate the content of this blog post. Have a look down the Welcome page for some of the free lists and reports available www.stockcalc.com/Welcome as well.

Or start your StockCalc 30 Day Free Trial

Undervalued Stocks – Consumer Cyclicals Sector

Today our focus is the Consumer Cyclicals sector and we are looking at companies that are undervalued based on our Weighted Average Valuation (WAV) calculation which we do for the 8000 stocks each night in the StockCalc database. The Consumer Cyclicals sector includes a variety of industries such as advertising, autos, travel and leisure, entertainment and retail. These companies tend to be very sensitive to economic cycles.

We generate our Weighted Average Valuation (WAV) from 5 models and Analyst consensus. Overview of the models used: Discounted Cash Flow (DCF value) is a valuation technique where cash flow projections are discounted back to the present to calculate value per share. A Comparables model values the company on the basis of ratios from selected comparable companies. We actually do 3 types of comparables models. An Adjusted Book Value (ABV) is calculated by multiplying book value per share by its historical Price to Book ratio. If we have Analyst coverage we look at the consensus target price.

Today’s Data – Consumer Cyclicals

In the table below we can see the close price (Jan 8th 2021) and valuation for these companies along with the ratio of valuation to price as well as their market cap class and average trading volume.

Symbol Company Name Close Price($) Valuation ($) Value/ Price Class Average Volume
VIPS-N Vipshop Holdings 15.13 23.45 1.55 Large Cap 4638125
EXPE-Q Expedia Group 108.62 139.26 1.28 Large Cap 1990003
QSR-T Restaurant Brands Intl 81.28 98.32 1.21 Large Cap 987770
WRK-N WestRock 41.74 48.33 1.16 Large Cap 3156442
ARMK-N Aramark 44.27 51.01 1.15 Large Cap 1239589
QRTEA-Q Qurate Retail 7.95 16.00 2.01 Mid Cap 3389376
SIX-N Six Flags Entertainment 43.56 63.00 1.45 Mid Cap 1876296
GIL-N Gildan Activewear 29.53 38.31 1.30 Mid Cap 619339
BERY-N Berry Global Group 44.77 55.71 1.24 Mid Cap 1535864
WYND-N Wyndham Destinations 51.12 59.50 1.16 Mid Cap 453248
CHS-N Chico’s FAS 3.76 7.91 2.10 Small Cap 2234503
RGS-N Regis 16.55 33.00 1.99 Small Cap 277526
CONN-Q Conn’s 11.01 21.75 1.98 Small Cap 1032243
EXPR-N Express 5.09 10.00 1.96 Small Cap 1834662
MOD-N Modine Manufacturing 7.46 14.48 1.94 Small Cap 204739
JILL-N J.Jill 1.26 2.81 2.23 Micro Cap 192705
HOV-N Hovnanian Enterprises 20.84 42.71 2.05 Micro Cap 161152
CXDC-Q China XD Plastics Co 1.99 4.08 2.05 Micro Cap 78384
PRTY-N Party City Holdco 2.53 5.00 1.98 Micro Cap 2868379
FRGI-Q Fiesta Restaurant Gr 10.54 18.29 1.74 Micro Cap 195956
BUS-X Grande West 0.46 0.60 1.32 Nano Cap 100501
BBQ-Q BBQ Hldgs 4.36 4.51 1.04 Nano Cap 79193

N-NYSE, Q-Nasdaq, A-American, T-Toronto, X-Toronto Venture

Lets look at a few companies…

Lets look at a couple of the companies on this list to get a better understanding of them.

Expedia Group

https://www.expediagroup.com
Expedia Group Inc is an online travel company. It offers holiday packages, rental cars, cruises, as well as destination services and activities. The Core OTA segment generates maximum revenue for the company.

Six Flags Entertainment

https://www.sixflags.com
Six Flags Entertainment Corp is the owner and operator of regional theme and water parks in the United States, Mexico and Canada. It offers thrill rides, water attractions, themed areas, concerts and shows, restaurants, game venues and retail outlet

Hovnanian Enterprises

https://www.khov.com
Hovnanian Enterprises Inc is an American construction company. It designs, constructs, markets and sells single-family detached homes, attached townhomes and condominiums, urban infill and active lifestyle homes in planned residential developments.

An Introduction to Stock Valuation

I have put together an overview of how stocks are valued using fundamental valuation methods.

How to value stocks

PDF version of this ebook: An Introduction to Stock Valuation

To run a valuation on a company try it here Get a valuation report

Background:

“Risk comes from not knowing what you are doing.” – Warren Buffet

Buying stocks without understanding their value is like buying a (car, set of golf clubs, vacation) without asking the (price, model, location) first. How do you know you are getting a good deal if you don’t know the value?

This e-book is an overview of valuation. Its purpose is to help you understand how to value stocks. Picking stocks, once you know this, is an easier process as it gives you a level of confidence that you are purchasing stocks that have a value you have determined based on the risks you understand.

The material can be a bit dry at times; we’ll try and keep it light.

Who should read this book?
This book is an introduction to valuation so there is some level of understanding that will be needed (and can easily be obtained). The book is of value:
– If you are investing but are not sure how the stocks you own are valued
– If you are aware of financial statements, may recognize Revenue and Net Income but not much else and want to expand that knowledge as it pertains to the Stock Market

There are many other parts to understanding what stocks to buy (or sell) and we will cover some of those in future editions, specifically analyzing a company’s financial statements and ratios to understand what risks we need to be aware of (does the company have too much debt compared to its industry, does the company face a liquidity crunch in its short term financing…) We do touch on ratios here and introduce some limited financial statement analysis.

About the Author:
Brian is the President of StockCalc (www.stockcalc.com) a fundamental valuation website for retail Investors and Investment Advisors. Brian is a Chartered Business Valuator (CBV), a Canadian valuation designation (www.cicbv.ca)

The full PDF version is available here – no email required. Feedback is very much appreciated.

PDF version of this ebook: An Introduction to Stock Valuation

How to calculate what a stock is worth

How do we calculate what a stock is worth – its intrinsic value?

I am going to provide an overview of how a stock’s value is calculated. Price is what we see traded on the exchange, value is what we calculate.  We will use this introductory article to provide an overview and will go into more detail in later articles.

I use www.stockcalc.com for the calculations and for full disclosure am company president.

When we value companies we generally determine the value of the entire company then subtract the amount  of debt the company owes. The result is what we call the equity value.  So how do we calculate the value of the company?

Look at a sample report here https://www.stockcalc.com/reports/JNJ_NYS_Valuation_report.html or generate a new valuation report each week www.stockcalc.com/valureport.aspx

There are a number of methods that can be used to value the company and they ultimately come down to how much cash flow will the company generate over time and what is that cash flow worth in today’s terms.

Using a simple example: if a company was generating  $100 million in free cash flow (defined below) every year and we expected that to continue forever we would value the company as

$100 million/the cost to the company to raise capital (we call this WACC or weighted average cost of capital) .  If that cost is 10% for example, the company would be valued at  $1 Billion.  If the company has $400 Million in combined short and long term debt (we refer to this as interest bearing debt) , we would calculate the value of the equity at $600 million.  Assuming 60 Million shares outstanding we would value the company to have a share price of 10$ per share.

So from this example we see a few important pieces needed to calculate what a company’s stock price is worth:

  • Its cash flow – which may need to be projected into the future
  • Its cost of capital or WACC
  • The amount of interest bearing debt it has
  • The number of shares outstanding.

Two (2) of these we can get from the company’s financial statements (Debt, Shares) and 2 we need to calculate.

Calculating Free Cash Flow:

Free cash flow is the cash generated by the operations of the company with capital expenditures removed, i.e. the true cash available to the company.

The Free Cash Flows (FCF) for Apple Inc (AAPL), Facebook (FB) and Alphabet or Google Inc. (GOOG) for example can be found on the Cash Flow Statements on the Stockcalc site.

(14 day free trial at www.stockcalc.com/registration.aspx)

To calculate FCF on a go-forward basis we need to make some assumptions or obtain this from others who follow and report on the stocks (analysts).  Here is a sample screen shot of Analyst data for Lowes Companies inc. (LOW)

LOW Analyst Estimates
Average Analyst Estimates for Lowes Companies Inc. (LOW:NYS)

If we are analysing a mature steady growth company, this would be as simple as understanding the annual growth rate we expect for that company and calculating the company value as

Free Cash Flow Current year / (WACC – expected growth rate)

If the company will not be growing at a steady pace (Technology, Mining, Pharma) we need to spend more time understanding what the free cash flow for the company will be.  We will need to look at historic free cash flows and the economic environment the company was in to generate those cash flows then look at projected economic or company specific conditions (Pharma product approval for ex) and project.

For these company’s  our formula looks more like

Present value of Cash flow year 1 +
Present value of Cash flow year 2 +
Present value of Cash flow year 3 +
Present value of Cash flow year 4 +
Present value of Cash flow year 5… +
Present value of Cash flow year n

Present value means we are calculating those future values back to today’s dollars.

For example in year 2 if we project Free Cash flow to be $125 million and WACC 10% we would discount the 125 to today’s terms as follows:  125 / (1.10)^2

To see a detailed fundamental valuation of Lowes Companies Inc. please refer to this blog:  https://www.stockcalc.com/blog/BrianD/2015/12/21/lowes-companies-inc-low-fundamental-valuation-using-analyst-forecast-data/

Summary:
The value of a company is its future cash flow in today’s dollars. The value of a stock is the company value less any interest bearing debt, all divided by number of shares outstanding.  (Note: each of these steps can have other considerations. That level of detail is beyond an introductory overview)

Other methods for Calculating the Value of a Company:
There are 3 other methods that are used to calculate the value of the equity in a company which we will cover in other blogs.

Comparables
Multiples
Adjusted Book Value

If you want to explore the Stockcalc software simply create an account at www.stockcalc.com and have a look around.  Use the walk-throughs (click the walking man icon), videos (video icon on each page) or the help menu to help understand and navigate the site. Please contact us if you have any questions.

Brian

Value a Stock in 4 Easy Steps

Determining what a stock is worth does not have to be a complicated process if you have the right tools to help you.  There are 4 steps to generating a valuation using the Stockcalc website. www.stockcalc.com

In the last blog we outlined the process involved
https://www.stockcalc.com/blog/BrianD/2015/12/21/how-to-calculate-what-a-stock-is-worth/

In this we will dig a little more into the 4 steps:  I am using the Stockcalc website to do these calculations and for full disclose am company President.

The 4 Steps (once you have selected a company)
1)  Determine what the cost is for the funds needed to run and grow the business. We call this the Weighted Average Cost of Capital or WACC.   Large, stable companies have a lower WACC than more speculative companies.
2) Forecast the company’s financials into the future based on assumptions you have or are able to get from Analysts that cover the company. We have a number of forecasting tools on the site starting with Analyst forecasts and Growth projections all the way to using a blank page and creating the forecast yourself.
3) Value the company using Valuation models such as a Discounted Cash Flow (DCF) where you include the financial forecasts, WACC and other calculations and assumptions such as Capital Expenditures needed and Debt levels.  The site has a full DCF framework for you to calculate with and auto-populates each cell to get you started.
4) Test your assumptions, see how sensitive the company is to the inputs.  Testing your assumptions is a critical part of valuation work. When you get a different valuation than you see a company is trading for on the stock exchange you need to ask why, and test. You may have uncovered an opportunity.

Here is a valuation I recently did for Lowes Companies Inc. using this 4 step process.
https://www.stockcalc.com/blog/BrianD/2015/12/21/lowes-companies-inc-low-fundamental-valuation-using-analyst-forecast-data/

And here is the process explained on Video for Alphabet (GOOG)
https://www.youtube.com/watch?v=V5194KeW_d0

Valuation is part art, part science.  The assumptions you make impact the company’s value.  For example, if you think the WACC is 8% instead of 9% the company will calculate to be more valuable because its cost to service its capital will be lower.

Here is a tool you can use for free to quickly test your assumptions :
www.stockcalc.com/dcf.aspx
Simply load a symbol or name into the Symbol text box and select the company from the dropdown.  Test the valuation by changing the growth rates, WACC, Free Cash Flows etc.

Next Steps:
If you are not sure where to begin you can select a company you are familiar with (GOOG, AAPL) and work though the steps above on the Stockcalc site.   Each of these steps are found on the Research Page which you can access either by clicking the Research Button   or selecting Research from the dropdown menu next to the Stockcalc logo (both are on the Dashboard)

About Stockcalc:
If you would like to explore the Stockcalc website and quickly run valuations like  simply create an account at www.stockcalc.com  (Start with a 14 day free trial)  Use the walk-throughs (click the walking man icon), videos (video icon on each page) or the help menu to help navigate the site. The site has a number of tools for data query, backtesting,  forecasting and valuation.  We have a no restrictions  Stockcalc 14 Day Free Trial available as well.
If you would like the above valuation to test simply send us a note from Stockcalc’s “Contact Us” on the dashboard.

 

 

Lowes Companies Inc. (LOW) Fundamental Valuation using Analyst Forecast Data

I used the Stockcalc website (www.stockcalc.com) to run a fundamental analysis for Lowes Companies (LOW:NYS)

Process:
I ran a Weighted Average Cost of Capital with the WACC Tool
I loaded the Analyst Estimate Data and used it to generate an Income Statement Forecast for 2016 to 2018
I then ran a Discounted Cash Flow with that Data.

The following screens show the steps:

Calculation of WACC for LOW:NYS

Lowes Companies WACC
The weighted average cost of capital for Lowes Companies (LOW:NYS)

This resulted in a WACC value of 8.78 for Lowes Companies Inc.

Next I loaded the Analyst Estimate Data and used it to generate an Income Statement Forecast for 2016 to 2018

LOW Analyst Estimates
Average Analyst Estimates for Lowes Companies Inc. (LOW:NYS)

 

LOW:NYS Income Statement
Income Statement Forecast for Lowes Companies Inc. (LOW:NYS)

 

I then loaded a Discounted Cash Flow using the above inputs

LOW:NYS DCF
Discounted Cash Flow Analysis for Lowes Companies (LOW:NYS)

Note – Stockcalc provides default or historic values to generate the initial valuation calculation- the user can then adjust based on their expectations:

Adjustments:
The cash flow values were taken directly from the Analyst estimates.  I reviewed the historic Capex figures and adjusted the ongoing Capital Expenditures to 0.9 billion from an average of 1.2 billion last 5 years based predominately on the last 2 years figures of 0.9 and 0.8 billion.  I also adjusted the terminal growth rate from the default of 3.0 to 3.4 given the Analyst projection for the next 3 years are 11% growth in EBITDA. These 2 adjustments resulted in a value of $74 per share.  I am not aware if there are redundant assets that would add to  company value.

The Analyst Mean Target Price for 2017 is $80.86.  This can be seen on the Average Analyst Estimates above.  To achieve that value I would need to increase the terminal value to 4.0 % per year in the discounted cash flow model.

Company Information:
Lowe’s Companies Inc. was incorporated in North Carolina in 1952 and has been publicly held since 1961. It is a Fortune(r) 100 company and a home improvement retailer. As of January 31, 2014, Lowe’s operated 1,832 home improvement and hardware stores in the United States, Canada and Mexico representing approximately 200 million square feet of retail selling space. The Company serves homeowners, renters and commercial business customers (Pro customer).

About Stockcalc:
If you would like to explore the Stockcalc website and quickly run valuations like  simply create an account at www.stockcalc.com .  Use the walk-throughs (click the walking man icon), videos (video icon on each page) or the help menu to help navigate the site. The site has a number of tools for data query, backtesting, forecasting and valuation.  We have a no restrictions 14 day free trial available. If you would like the above valuation to test simply send us a note from Stockcalc’s “Contact Us” on the dashboard.

 

 

 

 

How sensitive are companies to rising interest rates?

The talk of will they or won’t they raise rates has been ongoing for more than 2 years now.  We have to expect either rates get raised at some point, we stumble along on the current path or we end up in deflationary times.  I want to explore the more optimistic of these scenarios and its impact on stock valuations: the economy improves and rates start to rise.

To look at this in detail I am using www.stockcalc.com  (Disclaimer: I am the President of Patchell Brook Equity Analytics and we created Stockcalc.com precisely for this type of analysis and valuation)

I will examine Caterpillar as it has with a 59/41 Equity to Debt in the Capital Structure

Using Stockcalc I first create and save a WACC for CAT:  (Research Menu, Valuation, WACC).  Stockcalc does a first pass on WACC using default values which results in a WACC of 8.93.

Cost of Equity (Ke) 13.63 (Using CAPM), After Tax cost of Debt : 2.17, 59% Equity, 41% Debt

 

WACC for CAT

Next I load the Quick DCF tool  so I can run the analysis (Research, Forecast, Analyst) (Note – the quick DCF is a testing and teaching tool, the other tools are more detailed in their analysis)

It is available for free at www.stockcalc.com/dcf.aspx or inside the Stockcalc.Com website

Quick DCF for CAT

Value Per Share ($) Calculations for Caterpillar (CAT:NYS) using the Quick DCF tool on Stockcalc.com

Each change in WACC (8.93 – 9.34 – 9.75) implies a 1 % change in Cost of Debt.  Growth rates are next 3 years and thereafter (5% and 3% in the first row for ex)

WACC 8.93 9.34 9.75
Growth rates 5,3% 70.02 61.28 53.60
Growth rates 6,4% 97.40 84.92 74.21
Growth rates 4,2% 50.55 44.08 38.30

(Current Price at the time of valuation (October 2015) was $69.34)

A 1% change in the Cost of Debt results in a 12.5% change in value per share.  A 1% change in Growth rates results in a 28% change in Value per Share.  A 1% change in WACC results in a similar 28% change in Value per Share.

Message: if interest rates are rising, growth prospects need to be rising at half the rate to keep this share price holding steady.

 

If you want to explore the Stockcalc software simply create an account at www.stockcalc.com and have a look around.  Use the walk-throughs (click the walking man icon), videos (video icon on each page) and  help menu to understand and navigate the site.  The site contains a number of tools including screens, queries, backtests, forecasts and a variety of valuation methods.

 

 

It used to be a 6$ stock…

Checking Price versus Market Cap

I often see on chat rooms and bullboards investors discussing small caps with phrases like “but it used to be a 6 $ stock – I’ll buy it and wait for it to get back there”

Should they be looking at Price or Market Cap?

Price vs Market Cap
Price vs Market Cap

Side note: Here is an overview of Price vs Market cap from Khan Academy:

https://www.khanacademy.org/video/price-and-market-capitalization

In some sectors, notably junior mining companies, you need to look at Market Cap (Stock Price * Number of Shares outstanding) instead of share price as a potential upside if conditions return.  Every time one of these junior companies does a reverse split it affects the market cap but may not be reflected in the price over time given their nature to fall off dramatically in tough times.

As a note, any company that goes through a reverse split falls for this math so if you think of buying a company because it “used to be a 6$ stock” please look to see if any reverse splits have occurred.

Here is a example of a small Canadian junior gold company that I ran using the www.stockcalc.com  website – It hit a high of 12 Million market cap in 2008 and the adjusted stock price at that time was in the 1.20$ range (I say adjusted because as each reverse split occurs in order to have apples and apples the charts need to be adjusted to reflect the splits)

The company is currently trading at 13 cents with a market cap of less than 3.5 million.

Market Cap

BMG Market Cap 2008 2015

Let look at 3 points in time here with the share consolidations accounted for:

Jan 1 2010: Market Cap 5.5 Million, Price 57 cents
Jan 1 2014: Market Cap 1.0 Million, Price 10 cents
Jan 1 2015: Market Cap 3.4 Million, Price 13 cents

From these we can calculate the (adjusted) # of shares as 10 Million each of 2010, 2014 and 26 Million in 2015.  The company did a reverse split mid 2014 followed by a number of private placements.

Price – This chart shows the adjusted close prices for the company from 2008 to mid 2015.

BMG Close price 2008 2015

Here is a zoomed in version of the price chart

BMG Close price 2008 2015 zoomed

So if we wanted to speculate thinking conditions were going to turn around for this junior mining company, how high could the share price go based on historical values?

If we look at the price chart we see the company would have been in the 50 to 60 cent range during 2010-2011 and may speculate it could return there if gold prices reverse higher. This would be a 4-5 times return compared to the 13 cents currently.

Conversely if we look at Market Cap:  after the split Market Cap was 3.4 million. To return to the 5.5 million range we see a  60% return.

i.e if the company returned to full value as expressed by 2010-11 market cap it would only rise to  21 cents, not the 50 to 60 cent range it had seen previously.

Yes it is intuitive, just something to keep on your radar when looking at these smaller stocks.

 

If you want to explore the Stockcalc software simply create an account at www.stockcalc.com and have a look around.  Use the walk-throughs (click the walking man icon), videos (video icon on each page) or the help menu to help understand and navigate the site.