Wednesday, April 10, 2013

Earnings multiples aren't driven by growth alone

A high earnings multiple is commonly used to classify a stock as a growth stock (just look at what Jim Cramer from Mad Money writes). Growth is not the whole story. By looking at the key value driver formula, we can see that the earnings multiple is determined by growth and the return on invested capital (ROIC). Divide both sides of the formula with the net operating profit less adjusted taxes (NOPLAT) to get the earnings multiple.


  • Value = (NOPLAT(1-g/ROIC))/(WACC-g)
  • Divide both sides with NOPLAT
  • Value/NOPLAT = (1-g/ROIC)/(WACC-g)
  • As we can see, the earnings multiple on the left is a function of both growth and ROIC




Tuesday, April 09, 2013

The Key Value Driver Formula and the Zen of Corporate Finance

This post is a part of my series on valuation. Today, I look at the fundamental drivers of value in a business.


When valuing a company, there are two main factors to consider. The Return on Invested Capital (ROIC) and the growth in cash flows (g)


  • Growth rate = return on new invested capital * investment rate
  • ROIC = capital invested in the business = PPE + net working capital (typically)



If the growth remains constant in perpetuity, we can use the following formula to calculate the value of a company:


  • Value = Free Cash Flow,t=1/(Cost of Capital - Growth)
The cost of capital can be substituted for the Weighted Average Cost of Capital (WACC)

Example: 
Earnings = 100
Net investment = 25
Cash Flow,t=1 = 75
Cost of Capital = 10%
Growth = 5%
Value = 75/(10%-5%) = 75/0.05 = 1500 

Based on this valuation, we can also calculate an implied earnings multiple:

  • Earnings multiple = Valuation/Earnings = 1500/100 = 15X
The free cash flow is calculated as NOPLAT minus net investment. NOPLAT is Net Operating Profit Less Adjusted Taxes and represents the cash generated by the business in a given year. From this we can create what is called the key value driver formula:

  • Value = (NOPLAT,t=1 * (1 - g / WACC)) / (WACC - g)
This article is based on the book Valuation by Koller, Goedhart & Wessel. They call the key value driver formula the Zen of Corporate Finance "because it relates a company's value to the fundamental drivers of economic value: growth , ROIC and the cost of capital".






Monday, April 08, 2013

Currently reading: Great Minds in Finance: The Efficient Market Hypothesis


I'm reading the fourth book in Colin Read's series Great Minds in Finance that describes the people and discoveries behind the Efficient Market Hypothesis. Since I'm an avid chess player myself, this quote stood out:

To better understand the meaning of a fair game of the type Bachelier modeled, contrast the analogy with chess and the card game poker. A game of chess can be resumed at any time by any player without disadvantage. All observers of a snapshot of the chess board have all the available information. The past history of moves and captures is immaterial. The only relevant issue is the position of the chess men at any moment. However, in poker, even if one could observe all hands at a time t or have all inside information belonging to each player at a given stage in the game, past history remains important. The composition of the pile of cards that have been discarded and swapped are only partially known, and only to individual players. And even if one were to know the cards they discarded, and hence had som idea of the cards remaining in the deck or in the hands of others, the information is imperfect. In fact, poker is an imperfect game of insiders information while chess or coin tossing are games that are informationally perfect, as Bachelier and the proponents of efficient markets have assumed of financial markets ever since.
So chess, not poker, would be the best analogy for an efficient market.

Sunday, April 07, 2013

Bitcoins are the first asset class driven solely by attention




I downloaded Bitcoin price data for 1.4.2012-31.3.2013 and assembled daily Google searches for Bitcoin for the same time period. This is the scatterplot of the two. 90% of the variation in the Bitcoin price is explained by search volume on Google Trends, which is pretty impressive.

Research on the correlation between Google Trends data and stock prices have found correlations between volatility and searches. But to see this direct relationship between actual prices and searches is pretty stunning.

Does this mean that an increase in searches indicates a price increase? It might of course very well be the other way around, that increasing Bitcoin prices lead to more attention.

Saturday, April 06, 2013

How to get daily Google Trends data for more than 90 days (Excel)

Note: This post describes how to combine Google Trends series using Excel. If you wish to use R, please read this article.

Google Trends is a great source for insight, but the tool can be a bit limiting. For instance, it is only possible to download daily search data three months at a time. Google Trends will give you weekly data for up to a year at a time, and after that only monthly data. Since the data is provided in an index format, we need to adjust the independent indexes. So how can we merge the quarterly time series into a yearly time series with daily data?

The three graphs show the problem of merging quarterly data directly. By using the weekly data as a benchmark we can create an accurate index with daily data.

Step 1 

Download the data in 90-day increments. In this example I assume that we want a whole year worth of daily data, that means four csv files to merge.

  • Report (1).csv: January - March 2012 
  • Report (2).csv: April - June 2012 
  • Report (3).csv: July - September 2012 
  • Report (4).csv: October - December 2012 

Step 2 

Download the weekly data for the same year.

  • Report (5).csv: January - December 2012 

Step 3 

Merge the daily data files into one Excel spreadsheet. Leave a gap in between each quarter so you remember where the adjustment must be made.

Step 4 

This is where we need to adjust the indexes based on the weekly data file we downloaded. We will do this based on the weekly time series data for the whole year we also downloaded. At the start of each quarter, write the corresponding index value from the weekly data. Then calculate the percentage change between the days and add that to the new index value. Repeat for each quarter and you have created a new yearly index with daily data.


Entertaining Blogs - BlogCatalog Blog Directory
Bloggtoppen.se