The good, the bad and the ugly of finance truly shows in the stock market. Which is why LinkedIn has publicly given up its stocks to Microsoft.
After a share take over from Microsoft, LinkedIn is taking a step back. LinkedIn is known for being the most used social network site for job applicants and human resource. When the company agreed to the acquisition, it publicly has given up.
The reason being is that LinkedIn has not even met its beginning of the year share price as of yet. LinkedIn stocks were beginning to look bleak. When Microsoft stepped in, it solves a problem for the tech company. According to Forbes, when LinkedIn saw its shares plummet, it has experienced its lowest of lows. It was not internal turmoil or instability in the company and its market that drove LinkedIn to give up. In fact, Reid Hoffman made sure the company is stable and consistent in its main goal. It may have generated a strong niche for job seekers and career advancement.
The problem lies in the sales report. It only reported a 34% increase in fourth quarter sales as its online ad sales grew 20%, or roughly half its previous rate of growth. These are different numbers compared to the numbers the company has enjoyed in the previous years. It was experiencing a slow decline. It then ripped off Hoffman"s net worth.
Now, after a four month stay in the stock market lows, LinkedIn is back at around $200 from $100. Microsoft"s takeover shows investors were wrong to give up on LinkedIn. LinkedIn"s failure stemmed from issuing soft earnings and guidance into a panicking market. This prompts investors to look for stability and growth in long term value.
So Microsoft is now buying LinkedIn shares for $26.2 billion, according to CNBC. LinkedIn shares have since then jumped 47%.
According to The Fly, linkedIn (NYSE: LNKD) received a Hold rating and a $196 price target from Jefferies analyst Brian Pitz yesterday. The companys shares closed yesterday at $192.21.
Pitz noted, Earlier today Microsoft announced that it is acquiring LinkedIn for $196/sh in cash. We do not see any other bidders stepping up and raising the deal price at this time. We continue to believe that M&A will be a key theme in the Internet space over the course of 16.
According to TipRanks.com, Pitz is a top 100 analyst with an average return of 12.4% and a 67.5% success rate. Pitz covers the Technology sector, focusing on stocks such as Activision Blizzard, Active Network Inc, and Electronic Arts.
Currently, the analyst consensus on LinkedIn is Moderate Buy and the average price target is $175.64, representing a -8.6% downside
. In a report issued on June 6, MKM Partners also reiterated a Hold rating on the stock with a $130 price target.
The company has a one year high of $258.39 and a one year low of $98.25. Currently, LinkedIn has an average volume of 2.68M.
Unlike Jefferies` latest rating, based on the recent corporate insider activity of 110 insiders, corporate insider sentiment is negative on the stock. Last month, Jeff Weiner, a the CEO of LNKD sold 3,240 shares for a total of $415,206.
LinkedIn Corp. operates an online professional network on the Internet. Its proprietary platform enables members to create, manage and share their professional identities online, build and engage with their professional networks, access shared knowledge and insights, and find business opportunities. It product lines include Talent Solutions, Marketing Solutions and Premium Subscriptions these three product lines are sold through two channels, an offline field sales organization which engages with both large and small enterprise customers, as well as an online, selfserve channel. The company was founded by Allen Blue, Reid G. Hoffman, Jean-Luc Vaillant, Konstantin Guericke and Eric Ly in November 2002 and is headquartered in Mountain View, CA.
SummaryAfter LinkedIn"s (NYSE: LNKD) share price plummeted in February the share price has risen steadily. LinkedIn also reported OK Q1 numbers at the end of April. However, current share price implies that LinkedIn needs to execute better than the relatively demanding consensus forecast. This also is due to their seemingly generous stock compensation plan. That is, LinkedIn is relatively expensive at these levels.
BackgroundLinkedIn is the biggest business-oriented online social networking service. More information about LinkedIn on their Investor Homepage. The below chart from YCharts shows the number of shares outstanding.
Click to enlarge
Number of shares outstanding have been increasing with about 5% each year.
Forecast assumptionsI will create a forecast based on LinkedIn"s historical financial performance and current consensus forecast. I have used the Equity Analysis Model from SimulationFinance.com to generate this analysis. I have copied historical financial data from LinkedIn"s Interactive Analyst Center. The below image shows the historical financial data copied from LinkedIn"s spreadsheet and pasted into the Equity Analysis Model. Important! I have used reported adjusted EBITDA.
Click to enlarge
I then clicked the Generate forecast button to create an analysis based on extrapolation of the historical development. This will create forecast assumptions based on the most recent quarter and the historical trends. It also will calculate historical standard deviations and correlations used in the analysis to create fan charts and distribution charts. I will change some of the forecast assumptions further down in this analysis.
The below image shows the extrapolation assumptions chosen.
After having automatically generated forecast assumptions based on the historical development I then manually change some forecast assumptions to reflect the consensus forecast.
The below image shows LinkedIn consensus forecast from 4-traders.com.
The below image from the Equity Analysis Model shows the forecast assumptions used in the calculation. The forecast assumptions are generated from the historical development and manually adjusted to reflect current consensus forecast.
Click to enlarge
I have assumed a quarterly revenue growth of 4.8% and a quarterly cost growth of 4.4% to reflect consensus forecast. The total depreciation rate is calculated to 37% to cover depreciation of fixed assets, amortization of goodwill and intangibles, and to cover the non-cash effect from the stock-based compensation. In this analysis, all the long-term assets are input as fixed assets in the Equity Analysis Model. I have assumed a flat tax rate of 30%. I have assumed capital expenditures to be more like consensus forecast.
Important! I have used adjusted EBITDA to reflect that stock-based compensation is not a cash cost. In my forecast the negative balance sheet effect from stock-based compensation appears as shrinking long-term assets instead of as accrued liabilities. I have not included an increase in the number of shares outstanding as a result of the stock-based compensation.
ForecastAll the statements and charts below are calculated in the Equity Analysis Model and based on the assumptions above. The below statements summarizes the forecast.
The below chart shows the historical and the assumed future revenues. Historical data with dark blue columns and the forecasted data with light blue columns.
Click to enlarge
The below chart shows the historical and assumed future adjusted EBITDA.
Click to enlarge
The below chart shows the historical and the assumed future earnings per share and cash earnings per share, assuming unchanged number of shares outstanding.
Click to enlarge
ValuationBased on the discounted cash flow valuation method, assuming a weighted cost of capital of 8% and perpetual growth of 4% from the end of 2018. The below image shows the calculated fair value per share based on the assumptions above, and assuming 132.8 million shares. That is, the fair value per share is about $114 (the column to the right). Current share price is about $126.
Click to enlarge
Confidence AnalysisThe Equity Analysis Model allows to include uncertainty assumptions in the forecast, that is, standard deviations and correlations. In this example, they are automatically calculated based on the historical financial data. Calculated historical standard deviation in revenues is 4.38%. Calculated historical standard deviation in costs is 3.15%. The Equity Analysis Model calculates multiple scenarios based on these standard deviations. The below image shows the historical and the assumed future adjusted EBITDA with uncertainty assumptions.
Click to enlarge
The black line shows the historical development and the dotted line shows the main case assumed future development. The darkest blue area shows the range containing 75% of the calculated outcomes. The two darkest blue areas combined shows the range containing 90% and the total blue area shows the range containing 95% of the calculated outcomes.
The below image shows the historical and the assumed future net profit with uncertainty assumptions. Important! This assumes a fixed stock compensation cost.
Click to enlarge
There"s a striking difference with the calculated historical adjusted EBITDA and the reported historical net profit. Calculated historical adjusted EBITDA which does not include stock compensation costs has increased, but reported net profit which includes stock compensation costs has fallen.
The below image shows the calculated fair value per share range. Assuming 132.8 million shares and a fixed stock compensation cost. That is, fair value per share range is between $64 and $200 per share.
Click to enlarge
The horizontal axis shows the distribution of calculated fair value per share and the vertical axis shows the probability of each outcome. The percentages on top of the bars have been chosen to show the accumulated probability, starting from the left. That is, it is calculated to be about 55% probability that the fair value per share is below $118.92.
Historically, the number of shares outstanding has been increasing with about 4%-5% each. Historically, the number of shares outstanding has increased by about 4%-5% each year. If I assume that the numbers of shares outstanding increases by 4% each year then the number of shares in 2020 will be about 160 million.The below image shows the calculated fair value per share range assuming 160 million shares outstanding. I still assume a fixed stock compensation cost. That is, fair value per share range is between $46 and $172 per share. It is about 89% probability that the fair value per share is below $121.97. Current share price is about $126.
Click to enlarge
SummaryLinkedIn is a good company with good products in a long-term growth market. However, a long-term growth market will attract other behemoths such as Facebook (NASDAQ: FB) as mentioned in the article by Dana Blankenhorn. This may limit both the revenue growth and the margin potential for LinkedIn.The threat of other players entering this market combined with LinkedIn"s seemingly generous stock-based compensation makes the risk-return seem unattractive.
Disclosure: I/we have no positions in any stocks mentioned, and no plans to initiate any positions within the next 72 hours.
I wrote this article myself, and it expresses my own opinions. I am not receiving compensation for it. I have no business relationship with any company whose stock is mentioned in this article.
