LinkedIn Financials

Part
01
of eight
Part
01

LinkedIn Financials - 2011

The column D on the “Pre-Acquisition” tab of the spreadsheet has been filled. All information was taken from LinkedIn’s 10-K form for 2011. Some cells were labeled as N/A because the document differed from the titles provided on the spreadsheet.

The document did not provide the information for level four of the “Fair Value Assets and Liabilities by Level” sector in the spreadsheet. Additionally, for the "Goodwill and Other Intangible Assets" sector found in the spreadsheet, the spreadsheet did not provide which of the columns of the table from the document to add. The options were "Gross Carrying Amount," "Accumulated Amount," and the other two. Lastly, the “Income (per) loss share” sector of the spreadsheet did not provide the two classes required (Class A and Class B) for the year 2011.
Part
02
of eight
Part
02

LinkedIn Financials - 2012

We acquired and recorded the specified information in LinkedIn’s 2012 10-K form. In 2012, LinkedIn had net revenue of $972,309,000; $1,382,330,000 in total assets; and adjusted EBITDA of $233,030,000. The entire project is here.

Methodology

Our inquiry relied on the 10-K form filed by LinkedIn to the SEC. All numbers are in the thousands except per share data. Parenthetical numbers in the form are represented by a negative symbol before the dollar sign (-$). The very few cases where there are blanks are instances where there was no corresponding match in the 10-K.

LinkedIn Financials — 2012

The following are numbers from LinkedIn’s Consolidated Statements of Operations Data, Other Financial and Operational Data, Stock-Based Compensation from Above Statements of Operations Data, Compensation Balance Sheet Data, and Reconciliation of Adjusted EBITDA. For brevity, we have provided this brief snippet of LinkedIn’s 10-K due to the amount of information recorded in the form. The entirety of the data and project are here.

Consolidated Statements of Operations Data

Costs and Expenses
  • Cost of Revenue (exclusive of depreciation and amortization shown separately below) $125,521
  • Sales and Marketing $324,896
  • Product Development $257,179
  • General and Administrative $128,002
  • Depreciation and Amortization $79,849
  • Total Costs and Expenses $915,447
  • Income (loss) from Operations $56,862
  • Other Income (expense), Net $252
  • Income (loss) before Income Taxes $57,114
  • Provision for Income Taxes $35,504
  • Net Income (loss) $21,610
  • Net Income (loss) Attributable to Common Stockholders $21,610
Net Income (loss) per Share Attributable to Common Stockholders
Weighted-Average Shares used to Compute Net Income (loss) per Share Attributable to Common Stockholders

Other Financial and Operational Data

Stock-Based Compensation from Above Statements of Operations Data

Compensation Balance Sheet Data

  • Cash and Cash Equivalents $270,408
  • Short-Term Investments $479,141
  • Property and Equipment, Net $186,677
  • Working Capital $603,418
  • Total Assets $1,382,330
  • Redeemable Convertible Preferred Stock
  • Convertible Preferred Stock
  • Total Stockholders' Equity $908,424

Reconciliation of Adjusted EBITDA

  • Net Income (loss) $21,610
  • Provision for Income Taxes $35,504
  • Other (income) Expense, Net -$252
  • Depreciation and Amortization $79,849
  • Stock-Based Compensation $86,319
  • Adjusted EBITDA $223,030

Conclusion

We successfully located and recorded the specified data from LinkedIn’s 2012 10-K form.
Part
03
of eight
Part
03

LinkedIn Financials - 2013

According to LinkedIn’s 2013 10-K, the company had a net revenue of $1,528,545,000. The research team has provided additional information in the "Pre-Acquisition" tab of the attached spreadsheet. Below is the overview of our findings.

Methodology

To find LinkedIn financials for 2013, we relied solely on their 10-k form filled with the SEC. The data was pulled directly and inputted in the spreadsheet. Also, the blank spaces in the attached spreadsheet were as a result of lack of data which could not be retrieved in the provided source. We have updated the attached spreadsheet with the available information in the provided source.

NET REVENUE

NET REVENUE BY PRODUCT
Hiring Solutions — $859,674,000
Marketing Solutions — $362,360,000
Premium Solutions — $306,511,000
NET REVENUE BY GEOGRAPHIC LOCATION
United States — $942,122,000
International — $586, 423,000
TOTAL — $1,528,545,000

LONG-LIVED ASSETS

United States- $328,384,000
International — $33, 357,000
TOTAL PROPERTY AND EQUIPMENT, NET — $361,741,000

Additional information concerning the LinkedIn financials for 2013 can be accessed here.


Part
04
of eight
Part
04

LinkedIn Financials - 2014

In 2014, LinkedIn’s net revenue and net loss in 2015 were $2.218 billion and $15.32 million respectively. Details on the company's financials were taken from LinkedIn’s 10-K form for 2014 and provided in column G on the "Pre-Acquisition" tab of the attached spreadsheet.

Net Revenue by Product

Net Revenue by Geographic Location



Lastly, LinkedIn's number of registered members was 346,731 for the year ended December 31, 2014.
Part
06
of eight
Part
06

LinkedIn Financials - 2016

We acquired and recorded the specified information in Microsoft’s 2016 10-K form. In 2016, Microsoft facilities occupied a total of 26.1 million sq ft of space in the United States; had revenue of $85,320 million; and $193,694 million in total assets. The entire project is here.

METHODOLOGY

Our inquiry relied on the 10-K form filed by Microsoft to the SEC. All numbers are in the millions except per share data. We indicated parenthetical numbers in the form with a negative symbol before the dollar sign (-$). Empty cells are instances where the form's corresponding section was blank, or there was no match in the 10-K.

LINKEDIN FINANCIALS — 2016

The following are numbers from Microsoft’s Summary of Square Footage of All Facilities, High and Low Common Stock Sales Prices per Share, Financial Highlights, and Segment Results of Operation. For brevity, we have provided this brief snippet of Microsoft’s 10-K due to the amount of information recorded in the form. The entirety of the data and project are here.

Summary of Square Footage of All Facilities

U.S.
International

High and Low Common Stock Sales Prices per Share

Financial Highlights

Financial Highlights

Segment Results of Operations

Revenue
Operating Income
Part
07
of eight
Part
07

LinkedIn Financials - 2017

The company financial information for LinkedIn in 2017 was calculated using Microsoft's 2017 10-K form from the U.S. Securities and Exchange Commission and can be found in column G of the attached spreadsheet on the "Post Acquisition" tab. A 10-K form is an even more detailed report than a company annual report and contains all required information regarding their financial performance. Unfortunately, however, Microsoft does not publish detailed financial information for each portion of this business. As a result, it was necessary to calculate what portion of Microsoft's revenue and finances came from their business through LinkedIn. This was done by locating revenue from LinkedIn on the 10-K form, and then dividing it by Microsoft's total revenue. Then, all financial values from the 10-K form were multiplied by the above percentage to provide an estimate of how much is attributed to LinkedIn.

All financial values are represented in millions, except where noted, such as for square footage and number of shares.

CALCULATION OF LINKEDIN CONTRIBUTION IN 2017

According to Microsoft's 2017 10-K form, LinkedIn brought in $2,268,000,000 in revenue that year. Microsoft as a whole brought in $89,950,000,000 in revenue in 2017. This means that LinkedIn contributed approximately 2.52% of the company's total financials.

[LinkedIn Revenue] / [Total Microsoft Revenue] * (100%) =
[$2,268,000,000] / [$89,950,000,000] * (100%) = 2.52%

This value (2.52%) has been multiplied by each value in Microsoft's 2017 10-K form that involved stock, income, revenue, taxes, costs, etc. that LinkedIn was involved in, so as to provide an estimate of the actual numbers credible to LinkedIn.


Please review column G on the "Post Acquisition" tab of the attached spreadsheet for a full analysis of LinkedIn's financials. Microsoft's financials, of which LinkedIn is a part of, are also stated in column F for 2017.
Sources
Sources