Footnote 9 of Microsoft’s 2017 annual report discloses how much revenue Microsof
ID: 2432586 • Letter: F
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.
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
Explanation / Answer
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