Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

In excel, perform horizontal analysis of the balance sheet for Microsoft's 2019 Annual Report Microsoft Annual Report 2019 BALANCE SHEETS (In millions) 2019 2018 June

In excel, perform horizontal analysis of the balance sheet for Microsoft's 2019 Annual Reportimage text in transcribed

Microsoft Annual Report 2019 BALANCE SHEETS (In millions) 2019 2018 June 30. Assets Current assets: S $ 11,946 11,356 122,463 121,822 133,819 29,524 2,063 10,146 133,768 26,481 2,662 6.751 169,662 175,552 36,477 29,460 6,686 1,862 Cash and cash equivalents Short-term investments Total cash, cash equivalents, and short-term investments Accounts receivable net of allowance for doubtful accounts of $411 and 5377 Inventories Other Total current assets Property and equipment, net of accumulated depreciation of $35,330 and $29,223 Operating lease right-of-use assets Equity investments Goodwill Intangible assets, net Other long-term assets Total assets Liabilities and stockholders' equity Current liabilities: Accounts payable Current portion of long-term debt Accrued compensation Short-term income taxes 7,379 2,649 42,026 7,750 35,683 8,053 7,442 14,723 $ 286,556 $ 258,848 $ $ 8,617 3,998 9,382 5,516 6,830 5,665 32,676 9,351 6,103 2.121 28,905 Short-term unearned revenue Other 8.744 58.488 72.242 69,420 66,662 29,612 4,530 233 30,265 3.815 541 6,188 5,568 7,581 5,211 Total current liabilities Long-term debt Long-term income taxes Long-term unearned revenue Deferred income taxes Operating lease liabilities Other long-term liabilities Total liabilities Commitments and contingencies Stockholders' equity: Common stock and paid-in capital - shares authorized 24,000; outstanding 7,643 and 7.677 Retained earnings Accumulated other comprehensive loss Total stockholders' equity Total liabilities and stockholders' equity 184,226 176,130 78,520 71,223 13,682 24,150 (340) (2.187) 82,718 102,330 $ 286,556 $ 258,848

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

Recommended Textbook for

Managerial Accounting

Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

13th Edition

978-0697789938

Students also viewed these Accounting questions