Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

LinkedIns September 30, 2016 Form 10-Q balance sheet data reported certain items very differently from the way that Microsoft allocated its purchase price to LinkedIns

image text in transcribedimage text in transcribedLinkedIns September 30, 2016 Form 10-Q balance sheet data reported certain items very differently from the way that Microsoft allocated its purchase price to LinkedIns assets and liabilities as of December 6, 2016. a. Compare intangible assets, as reported as of September 30 and December 6. What is the difference in amount, and why do you think this occurred?

b. Compare goodwill, as reported as of the two dates. What is the difference, and why do you think it occurred? c. Compare shareholders equity as of September 30, 2016 to the purchase price paid by Microsoft of $27 billion. i. What is the difference in amount? ii. Why do you think that the balance sheet equity amount is so far below the amount Microsoft was willing to pay?

rated 26 Key LinkedIn Data, drawn from Form 10-K's (Millions) 2011 2012 2013 2014 2015 12/8/16 Pro 204 Pro- Year months Days rated Ended ended 2016 Ending Year 6/30/18 9/30/16 Annual 6/30/17 Ending 6/30/17 Income Statement Data Net revenues 522 972 1,528 2,218 2,991 2,753 ND 3,670 2,271 4,063 5,300 Depreciation/Amortization 43 80 135 237 | 420 420 | ND 560 866 1,550 1,500 Sales/Marketing 165 522 774 | 1,048 921 1,300 2,326 2,500 Product Development 132 257 396 536 776 720 ND 960 745 1,333 1,500 Total operating expenses 43 80 135 237 420 2.802 ND 3,735 2,300 4,115 4,500 Operating income (loss) 57 48 36 (151) (49) ND (65) (924) (1,653) (987) Other income (expense) (3)| 0 1 (5) (64) (35) ND (47) Pretax income (loss) 57 49 31 (214) (84) (112) Net income (loss) 22 27 (15) (165)| (155) ND (207) Stock compensation 16 29 49 432 ND 576 Adjusted EBITDA | 99 223 376 592 780 818 ND 1,090 Balance Sheet Data Working Capital 499 603 2,113 3,239 2,757 2,843 1,695 Goodwill 1 12 115 151 357 1,507 1,609 16,803 Other Intangible assets 8 33 43 131 373 263 7,887 Total assets 874 1,382 3,352 5,427 7,011 7,556 30,354 Stockholders' equity 625 908 2,6293,325 4,469 4,874 27,009* * The purchase price is assumed to equal equity as of the acquisition date. Microsoft's fiscal year ends June 30. 2011 to September 30, 2016 data were obtained from LinkedIn Forms 10-K for 2012 to 2015, and its Form 10-Q for September 30, 2016. The prorated columns were calculated by the authors. Data for LinkedIn revenues and expenses after the acquisition, and the balance sheet allocation at the acquisition date, are from Microsoft 2017 and 2018 Form 10-Ks. ND Key Microsoft Data, from Form 10-K's (Millions of $) FY 2013 FY 2014 FY2015 FY2016 FY2017 FY 2018 As originally reported Revenues 77,849 86,833 93,580 85,320 89,950 110,360 Operating Income 26,764 27,759 18,161 20,182 22,326 35,058 Depreciation and amortization 3,755 5,212 5,957 6,622 8,778 10,261 Income tax expenses 5,169 5,746 6,314 2,953 1,945 19,903 Net Income 21,863 22,074 12,193 16,798 21,204 16,571 As restated, for change in revenue recognition policy Revenues Not changed 91,154 96,571 110,360 Operating Income 26,078 29,025 35,058 Income tax expense 5,100 4,412 19,903 Net Income 20,539 25,489 16,571 Balance sheet data (restated) Cash and marketable securities 77,022 85,709 96,526 113,240 132,981 133,768 Goodwill 20,127 16,939 17,872 35,122 35,683 Intangible Assets 3,083 6,981 4,835 3,733 10,106 8,053 Total assets 140,890 170,569 174,303 193,468 241,086 258,848 Total Liabilities 63,487 82,600 96,140 121,471 168,692 176,130 Stockholders' Equity 78,944 89,784 80,083 71,997 72,394 82,728 Some events affecting comparability include: A $13.7 billion tax charged related to a tax law change in 2018 The acquisition of LinkedIn in December 2016 The impact of deferring revenue from Windows 10, in the originally reported 016 and 2017 data Approximately $1,110 of write-offs related to the phone business in 2016, which reduced operating income and net income by $1,110 and $895 million Approximately $10 billion of goodwill write-offs and restructuring charges in 2015 related to the phone business, which reduce operating income and net income by $10 billion and $9,5 billion. The acquisition of the Nokia phone business in April, 2014. If Nokia had been included as of the earliest data, revenues in 2013 and 2014 would have been 99,243 and 96,248, respectively. rated 26 Key LinkedIn Data, drawn from Form 10-K's (Millions) 2011 2012 2013 2014 2015 12/8/16 Pro 204 Pro- Year months Days rated Ended ended 2016 Ending Year 6/30/18 9/30/16 Annual 6/30/17 Ending 6/30/17 Income Statement Data Net revenues 522 972 1,528 2,218 2,991 2,753 ND 3,670 2,271 4,063 5,300 Depreciation/Amortization 43 80 135 237 | 420 420 | ND 560 866 1,550 1,500 Sales/Marketing 165 522 774 | 1,048 921 1,300 2,326 2,500 Product Development 132 257 396 536 776 720 ND 960 745 1,333 1,500 Total operating expenses 43 80 135 237 420 2.802 ND 3,735 2,300 4,115 4,500 Operating income (loss) 57 48 36 (151) (49) ND (65) (924) (1,653) (987) Other income (expense) (3)| 0 1 (5) (64) (35) ND (47) Pretax income (loss) 57 49 31 (214) (84) (112) Net income (loss) 22 27 (15) (165)| (155) ND (207) Stock compensation 16 29 49 432 ND 576 Adjusted EBITDA | 99 223 376 592 780 818 ND 1,090 Balance Sheet Data Working Capital 499 603 2,113 3,239 2,757 2,843 1,695 Goodwill 1 12 115 151 357 1,507 1,609 16,803 Other Intangible assets 8 33 43 131 373 263 7,887 Total assets 874 1,382 3,352 5,427 7,011 7,556 30,354 Stockholders' equity 625 908 2,6293,325 4,469 4,874 27,009* * The purchase price is assumed to equal equity as of the acquisition date. Microsoft's fiscal year ends June 30. 2011 to September 30, 2016 data were obtained from LinkedIn Forms 10-K for 2012 to 2015, and its Form 10-Q for September 30, 2016. The prorated columns were calculated by the authors. Data for LinkedIn revenues and expenses after the acquisition, and the balance sheet allocation at the acquisition date, are from Microsoft 2017 and 2018 Form 10-Ks. ND Key Microsoft Data, from Form 10-K's (Millions of $) FY 2013 FY 2014 FY2015 FY2016 FY2017 FY 2018 As originally reported Revenues 77,849 86,833 93,580 85,320 89,950 110,360 Operating Income 26,764 27,759 18,161 20,182 22,326 35,058 Depreciation and amortization 3,755 5,212 5,957 6,622 8,778 10,261 Income tax expenses 5,169 5,746 6,314 2,953 1,945 19,903 Net Income 21,863 22,074 12,193 16,798 21,204 16,571 As restated, for change in revenue recognition policy Revenues Not changed 91,154 96,571 110,360 Operating Income 26,078 29,025 35,058 Income tax expense 5,100 4,412 19,903 Net Income 20,539 25,489 16,571 Balance sheet data (restated) Cash and marketable securities 77,022 85,709 96,526 113,240 132,981 133,768 Goodwill 20,127 16,939 17,872 35,122 35,683 Intangible Assets 3,083 6,981 4,835 3,733 10,106 8,053 Total assets 140,890 170,569 174,303 193,468 241,086 258,848 Total Liabilities 63,487 82,600 96,140 121,471 168,692 176,130 Stockholders' Equity 78,944 89,784 80,083 71,997 72,394 82,728 Some events affecting comparability include: A $13.7 billion tax charged related to a tax law change in 2018 The acquisition of LinkedIn in December 2016 The impact of deferring revenue from Windows 10, in the originally reported 016 and 2017 data Approximately $1,110 of write-offs related to the phone business in 2016, which reduced operating income and net income by $1,110 and $895 million Approximately $10 billion of goodwill write-offs and restructuring charges in 2015 related to the phone business, which reduce operating income and net income by $10 billion and $9,5 billion. The acquisition of the Nokia phone business in April, 2014. If Nokia had been included as of the earliest data, revenues in 2013 and 2014 would have been 99,243 and 96,248, respectively

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

Accounting For Construction Frameworks Productivity Cost And Performance

Authors: Rick Best, Jim Meikle

1st Edition

1138293970, 978-1138293977

More Books

Students also viewed these Accounting questions