Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The attached pdf file shows the income statement and balance sheet from Microsoft's 2020 annual 10-K filing. Use the information for fiscal year 2020 (ended

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
The attached pdf file shows the income statement and balance sheet from Microsoft's 2020 annual 10-K filing. Use the information for fiscal year 2020 (ended June 30, 2020) to answer the following questions. Please pay close attention to the format for submitting answers, such as the number of decimal places. If an answer is to be provided as a percentage, do not include the % sign in your answer. MSFT 2020 excerpt.pdf a. Microsoft reported gross margin of $96,937 (in millions) for FY 2020. What dollar amount of that gross margin (in Millions) resulted from the sale of "Service and other? b. Microsoft reported basic EPS of $5.82 for FY 2020. Show the numbers reported on p. 55 (the income statement) that can be used to calculate this EPs. Numerator = denominator c. What dollar amount (in Millions) did Microsoft's customers owe for past purchases at the end of FY 2020? d. What was Microsoft's current ratio at June 30, 20207 Round your answer to one decimal place, eg. 4.2. e. What was Microsoft's profit margin percentage for FY 20207 Round your answer to one decimal place but omit the sign. 1. What was Microsoft's asset turnover ratio for FY 20207 Round your answer to two decimal places, c.8. 2.76. & What was Microsoft's ROA (return on assets) for FY 20207 Round your answer to one decimal place but omit the sign. PARTI Item ITEM 8. FINANCIAL STATEMENTS AND SUPPLEMENTARY DATA INCOME STATEMENTS in millions, except per share amounts) Year Ended June 30, 2020 2019 2018 Revenue: Product $ 68,041 $ 66,069 $ 64,497 Service and other 74,974 59,774 45.863 Total revenue 143,015 125,843 110,360 Cost of revenue Product 16,017 16,273 15,420 Service and other 30,061 26,637 22,933 Total cost of revenue 46,078 42,910 38,353 Gross margin 96,937 82,933 Research and development 72,007 19,269 16,876 14,726 Sales and marketing 19,598 18.213 17,469 General and administrative 5,111 4,885 4.754 Operating income 52,959 42.959 35,058 Other income, net 77 729 1,416 Income before income taxes 53,036 43,688 36,474 Provision for income taxes 8.755 4,448 19.903 Net income $ 44,281 S 39,240 $ 16,571 Earnings per share: Basic 5.82 $ 5.11 $ Diluted 5.76 $ 5.06 $ 2.13 Weighted average shares outstanding Basic 7,610 7,673 7.700 Diluted 7.683 7,753 7,794 2.15 Refer to accompanying notes PART Item 8 BALANCE SHEETS (in millions) 2020 2019 $ 13,576 $ 122,951 11,356 122,463 136,527 133,819 32,011 1,895 11,482 29,524 2,063 10.146 181,915 175,552 June 30, Assets Current assets: Cash and cash equivalents Short-term investments Total cash, cash equivalents, and short-term investments Accounts receivable, net of allowance for doubtful accounts of $788 and $411 Inventories Other current assets Total current assets Property and equipment, net of accumulated depreciation of $43,197 and $35,330 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 Short-term unearned revenue Other current liabilities Total current liabilities Long-term debt Long-term income taxes Long-term uneamed revenue Deferred income taxes 44,151 8,753 2,965 43,351 7,038 13,138 36,477 7,379 2,649 42,026 7.750 14,723 $ 301,311 $ 280,556 12,530 $ 3,749 7,874 2,130 36,000 10,027 9,382 5,516 6,830 5,085 32,676 9.351 72,310 59,578 29,432 3,180 204 69.420 66.662 29,612 4,530 233 $ 12,530 S 3,749 7,874 2,130 36,000 10,027 9,382 5,516 6,830 5,665 32,676 9,351 Liabilities and stockholders' equity Current liabilities: Accounts payable Current portion of long-term debt Accrued compensation Short-term income taxes Short-term unearned revenue Other current liabilities 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,571 and 7,643 Retained earnings Accumulated other comprehensive income (loss) Total stockholders' equity Total liabilities and stockholders' equity 72,310 59,578 29,432 3,180 204 7,671 10,632 69,420 66,662 29,612 4,530 233 6,188 7.581 184.226 183,007 80,552 34,566 3,186 78.520 24,150 (340) 118,304 301,311 $ 102,330 286,556 $ Refer to accompanying notes 57

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