Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The reported net income of Microsoft includes LinkedIn data only from December 6, 2016. Compute the percentage growth in Microsoft net income in 2016, 2017,

image text in transcribedimage text in transcribedThe reported net income of Microsoft includes LinkedIn data only from December 6, 2016. Compute the percentage growth in Microsoft net income in 2016, 2017, and 2018, using the following different sets of data: a. The net income data in the first section of Table 2, which were originally reported in its Form 10-Ks for those years b. The net income for Microsoft in the second section of Table 2, using the restated net income data where applicable c. If you were an analyst, trying to predict future growth, which of these sets of growth rates would you find most useful? Explain your answer.

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. 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions

Question

What degrees does the program offer?

Answered: 1 week ago