Question

Footnote 9 of Microsoft’s 2017 annual report discloses how much revenue Microsoft consolidated from LinkedIn in the year of the acquisition, fiscal year 2017.  It also discloses pro-forma consolidated revenues for 2017 and 2016 had the acquisition closed seventeen months earlier, on July 1, 2015.  

NOTE 9 — BUSINESS COMBINATIONS On December 8, 2016, we completed our acquisition of all issued and outstanding shares of LinkedIn Corporation, the world’s largest professional network on the Internet, for a total purchase price of $27.0 billion. The financial results of LinkedIn have been included in our consolidated financial statements since the date of the acquisition. Our consolidated income statement includes the following revenue and operating loss attributable to LinkedIn since the date of acquisition: (In millions) Year Ended June 30, 2017 Revenue $  2,268 Operating loss $  (948) Following are the supplemental consolidated financial results of Microsoft Corporation on an unaudited pro forma basis, as if the acquisition had been consummated on July 1, 2015: (In millions, except earnings per share) Year Ended June 30, 2017 2016 Revenue $  91,668 $  88,652 Net income    20,894    15,383 Diluted earnings per share        2.67        1.92

            By analyzing the revenue disclosures in the footnote in conjunction with the revenue reported in the income statement, we can gain quick insights into why Microsoft purchased LinkedIn.  The next two Work Schedules will walk you through some basic analysis of the information disclosed in the footnote and in the financial statements themselves.  The first Work Schedule asks you to gather information from the 2017 “five-year summary” and Footnote 9 to analyze what percentage of Microsoft’s 2017 revenue was generated by the newly acquired LinkedIn.

Please see the Excel file with the formula already entered to calculate percentage changes.

Work Schedule 1. Microsoft 2017 revenue with and without LinkedIn
Microsoft 2017 revenue (in millions), including seven months during which it owned LinkedIn (source: income statement or 5-year summary)
LinkedIn revenue included by Microsoft in 2017 (in millions; source: Footnote 9)
Percentage of 2017 Microsoft revenue consisting of LinkedIn revenue (Answer as a percentage X.X%)
Microsoft 2017 revenue (in millions), excluding LinkedIn

Work Schedule 2. Microsoft growth rate (reported, pro-forma, organic) and LinkedIn growth rate
		2017 (millions)	2016 (millions)	Growth (X.X%)
a	Microsoft reported revenues, which includes seven months of LinkedIn for 2017 source: income statement or 5-year summary
b	Microsoft pro-forma revenues, including twelve months of LinkedIn source: Footnote 9
c	Microsoft revenues excluding LinkedIn 2017 source: last line of Schedule 1 above   2016 source: income statement or 5-year summary
d	Twelve-month LinkedIn revenue calculation: b minus c

4a Insert your answer from Work Schedule 1 here.

LinkedIn revenue included by Microsoft in 2017 (in millions; source: Footnote 9)

4b. Insert your answer from Work Schedule 2 here.	2017
Twelve-month LinkedIn revenue calculation: b minus c

4c. Explain why your answers in 4a and 4b are different.

Answer 1

Requirement 4A

LinkedIn revenue included by microsoft in 2017 = $2,268

Requirement 4B

Twelve-month LinkedIn Revenue = $3,888

Requirement 4C

Because in requirement 4A we have included LinkedIn's Post acquisition revenue i.e. for 7 months while in requirement 4B we have considred LinkedIn's 12 months revenue while preparing proforma consolidated financial statements.

Work Schedule 1. Microsoft 2017 revenue with and without LinkedIn
Microsoft 2017 revenue (in millions), including seven months during which it owned LinkedIn (source: income statement or 5-year summary)	$        90,048
LinkedIn revenue included by Microsoft in 2017 (in millions; source: Footnote 9)	$          2,268
Percentage of 2017 Microsoft revenue consisting of LinkedIn revenue (Answer as a percentage X.X%)	2.52%
Microsoft 2017 revenue (in millions), excluding LinkedIn	$        87,780

Work Schedule 2. Microsoft growth rate (reported, pro-forma, organic) and LinkedIn growth rate
		2017 (millions)	2016 (millions)	Growth (X.X%)
a	Microsoft reported revenues, which includes seven months of LinkedIn for 2017 source: income statement or 5-year summary	$        90,048	$        84,764	6.23%
b	Microsoft pro-forma revenues, including twelve months of LinkedIn source: Footnote 9	$        91,668	$        88,652	3.40%
c	Microsoft revenues excluding LinkedIn 2017 source: last line of Schedule 1 above 2016 source: income statement or 5-year summary	$        87,780	$        84,764	3.56%
d	Twelve-month LinkedIn revenue calculation: b minus c	$          3,888	$          3,888	0.00%