Tag Archives: GOOG

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.