Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The attached pdf file shows the income statement and balance sheet from Microsoft's 2021 annual 10-K filing. Use the information for fiscal year 2021 (ended
The attached pdf file shows the income statement and balance sheet from Microsoft's 2021 annual 10-K filing. Use the information for fiscal year 2021 (ended June 30, 2021) 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. Microsoft 2021 10-K excerpts.pdf a. Microsoft reported gross margin of $115,856 (in millions) for FY 2021. What dollar amount of that gross margin (in millions) resulted from the sale of "Service and other"? $ b. Microsoft reported basic EPS of $8.12 for FY 2021. Show the numbers reported on p. 57 (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 2021? $ d. What dollar amounts (in milions) did Microsoft expect to collect from customers for past purchaes as of the end of FY 2021?$ e. What was Microsoft's current ratio at June 30, 2021? Round your answer to one decimal place, e.g., 4.2. f. What was Microsoft's profit margin percentage for FY 2021? Round your answer to one decimal place. % g. What was Microsoft's asset turnover ratio for FY 2021? Round your answer to two decimal places, e.g., 2.76. h. What was Microsoft's ROA (return on assets) for FY 2021? Round your answer to one decimal place and remember that ROA is expressed as a percentage. % PART II Item 8 ITEM 8. FINANCIAL STATEMENTS AND SUPPLEMENTARY DATA INCOME STATEMENTS (In millions, except per share amounts) 2021 2020 2019 Year Ended June 30, Revenue: Product Service and other $ $ $ 71,074 97,014 68,041 74,974 66,069 59,774 Total revenue 168,088 143,015 125,843 Cost of revenue: Product Service and other 18,219 34,013 16,017 30.061 16,273 26,637 Total cost of revenue 52,232 46,078 42,910 Gross margin Research and development Sales and marketing General and administrative Operating income Other income, net 115,856 20,716 20,117 5,107 96,937 19,269 19,598 5,111 82,933 16,876 18,213 4,885 69,916 1,186 52,959 77 42,959 729 Income before income taxes Provision for income taxes 71,102 9,831 53,036 8.755 43,688 4,448 Net income $ 61,271 $ 44,281 39,240 8.12 8.05 $ $ 5.82 $ 5.76 $ 5.11 5.06 $ Earnings per share: Basic Diluted Weighted average shares outstanding: Basic Diluted 7,547 7,608 7.610 7,683 7,673 7,753 Refer to accompanying notes. 57 PART 1 Item 8 BALANCE SHEETS (In millions) 2021 2020 June 30, Assets Current assets: Cash and cash equivalents Short-term investments 14,224 $ 116,110 13,576 122,951 136,527 32,011 1,895 11,482 Total cash, cash equivalents, and short-term investments Accounts receivable, net of allowance for doubtful accounts of $751 and $788 Inventories Other current assets Total current assets Property and equipment, net of accumulated depreciation of $51,351 and $43,197 Operating lease right-of-use assets Equity investments Goodwill Intangible assets, net Other long-term assets 130,334 38,043 2,636 13,393 184,406 59,715 11,088 5,984 49,711 7,800 15,075 181,915 44,151 8,753 2,965 43,351 7,038 13,138 Total assets $ 333,779 $ 301,311 $ 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 15,163 $ 8,072 10,057 2.174 41,525 11,666 12,530 3,749 7,874 2,130 36,000 10,027 72,310 59,578 88,657 50,074 27,190 2,616 198 9,629 13,427 29,432 3,180 204 7,671 10,632 Total liabilities 191,791 183,007 Commitments and contingencies Stockholders' equity: Common stock and paid-in capital - shares authorized 24,000; outstanding 7,519 and 7,571 Retained earnings Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity 83,111 57,055 1,822 80,552 34,566 3,186 141,988 118,304 301,311 $ 333,779 $ Refer to accompanying notes. 59
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started