Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Footnote 9 of Microsofts 2017 annual report discloses how much revenue Microsoft consolidated from LinkedIn in the year of the acquisition, fiscal year 2017. It

Footnote 9 of Microsofts 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 worlds 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 Microsofts 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management For Public Health And Not For Profit Organizations

Authors: Steven A. Finkler

3rd Edition

0136070736, 978-0136070733

More Books

Students also viewed these Accounting questions