Completion Statue QUESTION 4 The attached poffe shows the income statement and balance sheet from Microsoft's 2020 annual 10-K filling Use the information for fiscal year 2020 (ended June 30, 2020) to rower the following questions. Please pay close attention to the format for submitting answers, such as the numbe decimal places. If an answer is to be provided as a percentage, do not include the sig in your answer. MISET 2020 Microsoft reported gross marge of $96.937 million for FY 2020. What doilar amount of that gross margin in millors resulted from the sale of Service and other? Microsoft reported basic EPS of 55.82 for FY2020. 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 we for past purchases at the end of FY 2007 d. What was Microsoft's current ratione 30.20207 Round your awer to decilla, 2.42 t. What was Microsoft profit margin percentage for FY20297 Round you to one dromal place become they What was Microsoft's a turnover ratio for 2002 Round your towel decimal places What was Microsoft's to remonts for 2007 Round your answer to one decimal place out on the ch o E up - 26 5 6 7. 8 9. 1 1 2 74% + TEMPIKIANCIAL STATEMENTS AND SUPPLEMENTARI DATA INCOME STATEMENTS er har Yew Ende Jones Revenue 2013 Product Service and other $ 68,041 $ 66,069 $ 54,497 74.974 59.774 45.863 Total revenue 143,015 125.843 110,360 Cost of revenue Product 16,017 Service and other 16.273 15.420 30,061 26 637 22.983 Total cost of revenue 46,078 42 910 38.353 Gross margin 96,937 82.933 72.007 Research and development 19.269 16,878 Sales and marketing 14,726 19,598 18.213 17.480 General and administrative 5,111 4.885 4,754 Operating income 52,959 42.959 35,058 Other income net 77 729 1416 Income before income taxes 53,038 43.680 16.474 Provision for income taxes 8,755 4448 19.903 Net income $ 44.281 $39.240 $ 16.571 Earnings per share Bad 5115 2.15 Duted 5.765 5.00 $ 2 2.13 Weighted average shares outstanding 7,610 7,623 7.700 Diluted 7.750 7794 Basic Refer to accompanying notes 9 OH . dbb522te/189507527X-Blackboard-Expiration=1618801200000&X-Blad 2 12 61% + $ 13.576 122.551 136,527 11358 122:46 133 819 32,011 1,895 11,482 181.315 29.4 2083 10.10 175,552 3477 7.379 269 42020 4187 Assets Current Cash and cash equivalent Short-term investments Totalcah, cash equivalents, and short.com investments Accounts receivable et of lowance for doit counts of $788 and 5411 Inventories Omer current Total current Property and equipment, net of acomited depreciation of 565,197 and Opening houses Equity woments Goodwie Intangible net Other long-term Total Liabilities and stockholdersuit Current Acounts payable Current prolong term Gott Acond compensation Shorter income the Dommere Other current Tocument Logomet Long terminos Languee Detened income Opening Other long Tu 8.75 2.65 0.351 7,038 7.750 14. 205 550 5 301,3115 5 5.510 30 5.605 12,500 5 1740 7,874 2,130 16.000 10,027 T30 S.STO 29.4 9.35 2012 204 TATT 230 RIN 7583 181.00 TI YAT Fees 10 21 12.30 300313 . Question Completion Status: QUESTION 4 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. MSET 2020 excerpt Rat 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 20207 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 FY20207 Round your answer to two decimal places. e. 2.76. B What was Microsoft's RCA (return on assets) for FY 20202. Round your answer to one decimal place butonit the ** here to search ITEM 8. FINANCIAL STATEMENTS AND SUPPLEMENTARY DATA INCOME STATEMENTS 2010 $ 68,041 $ 66,069 $ 54497 74,974 59.774 45.863 143,015 125.843 110.360 16,017 30,061 46,078 16.273 26,637 42 910 millons, except per share amounts) Year Ended June 30, Revenue Product Service and other Total revenue Cost of revenue: Product Service and other Total cost of revenue Gross margin Research and development Sales and marketing General and administrative Operating income Other income, net Income before income taxes Provision for income taxes Net income Earnings per share: Basic Dited Weighted average shares outstanding Basic Diluted 96,937 19,269 19,598 5,111 15,420 22,933 38.353 72,007 14,726 17.469 4,754 82,933 16,876 18.213 4.885 52.959 77 42.959 729 35,058 1.410 53,036 43.688 36.474 8,755 19,903 $ 44,281 5 39 240 5 10,571 s 582 5.76 S 5115 500 5 2.15 2.13 7.610 7,683 7.679 2,753 7.700 7.79% Refer to accompanying notes II ** UTE 2 12 85% + BALANCE SHEETS 2020 $ 13,576 5 122.951 TE 136,527 13 in min) 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 543,197 and $35,330 Operating lease right-of-use assets Equity investments Goodwill Intangible assets, net Other long-term assets Total assets 32,011 1,895 11,482 20 2 10 181,915 175, ELE 44,15 8,753 2,965 43,351 7,038 13,138 301,311 5 36.4 7,3 2,64 42 02 7.75 14,722 286,556 2 5 516 6,800 5,665 32.670 Liabilities and stockholders' equity Current liabilities Accounts payable Current portion of long-term debt Accrued compensation Short-term income taxes Short-term uneamed revenue Other current liabilities Total current liabities Long-term debit Long term income taxes Long-term uneamed revenue Deferred income taxes Operating lease liabilities Other long-term liabilities 12.500 5 2.749 7.874 2.130 36.000 10,027 72.310 59,578 29.432 3,180 69,420 0660 4,630 230 7,671 10,632 7581 . O I ON here to search 2,130 36,000 10,027 5 326 9,30 72,310 59,578 29,432 3,180 204 7,671 10,632 183,007 89.420 66.662 29,612 4,530 233 6,188 7,581 184 226 Short-term uneared 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 7643 Retained earnings Accumulated other comprehensive income (loss) Total stockholders' equity Total liabilities and stockholders' equity Refer to accompanying notes 57 80,552 34,566 3,186 118,304 78.520 24,150 (340) 102,330 286,556 $ 301,311 S Completion Statue QUESTION 4 The attached poffe shows the income statement and balance sheet from Microsoft's 2020 annual 10-K filling Use the information for fiscal year 2020 (ended June 30, 2020) to rower the following questions. Please pay close attention to the format for submitting answers, such as the numbe decimal places. If an answer is to be provided as a percentage, do not include the sig in your answer. MISET 2020 Microsoft reported gross marge of $96.937 million for FY 2020. What doilar amount of that gross margin in millors resulted from the sale of Service and other? Microsoft reported basic EPS of 55.82 for FY2020. 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 we for past purchases at the end of FY 2007 d. What was Microsoft's current ratione 30.20207 Round your awer to decilla, 2.42 t. What was Microsoft profit margin percentage for FY20297 Round you to one dromal place become they What was Microsoft's a turnover ratio for 2002 Round your towel decimal places What was Microsoft's to remonts for 2007 Round your answer to one decimal place out on the ch o E up - 26 5 6 7. 8 9. 1 1 2 74% + TEMPIKIANCIAL STATEMENTS AND SUPPLEMENTARI DATA INCOME STATEMENTS er har Yew Ende Jones Revenue 2013 Product Service and other $ 68,041 $ 66,069 $ 54,497 74.974 59.774 45.863 Total revenue 143,015 125.843 110,360 Cost of revenue Product 16,017 Service and other 16.273 15.420 30,061 26 637 22.983 Total cost of revenue 46,078 42 910 38.353 Gross margin 96,937 82.933 72.007 Research and development 19.269 16,878 Sales and marketing 14,726 19,598 18.213 17.480 General and administrative 5,111 4.885 4,754 Operating income 52,959 42.959 35,058 Other income net 77 729 1416 Income before income taxes 53,038 43.680 16.474 Provision for income taxes 8,755 4448 19.903 Net income $ 44.281 $39.240 $ 16.571 Earnings per share Bad 5115 2.15 Duted 5.765 5.00 $ 2 2.13 Weighted average shares outstanding 7,610 7,623 7.700 Diluted 7.750 7794 Basic Refer to accompanying notes 9 OH . dbb522te/189507527X-Blackboard-Expiration=1618801200000&X-Blad 2 12 61% + $ 13.576 122.551 136,527 11358 122:46 133 819 32,011 1,895 11,482 181.315 29.4 2083 10.10 175,552 3477 7.379 269 42020 4187 Assets Current Cash and cash equivalent Short-term investments Totalcah, cash equivalents, and short.com investments Accounts receivable et of lowance for doit counts of $788 and 5411 Inventories Omer current Total current Property and equipment, net of acomited depreciation of 565,197 and Opening houses Equity woments Goodwie Intangible net Other long-term Total Liabilities and stockholdersuit Current Acounts payable Current prolong term Gott Acond compensation Shorter income the Dommere Other current Tocument Logomet Long terminos Languee Detened income Opening Other long Tu 8.75 2.65 0.351 7,038 7.750 14. 205 550 5 301,3115 5 5.510 30 5.605 12,500 5 1740 7,874 2,130 16.000 10,027 T30 S.STO 29.4 9.35 2012 204 TATT 230 RIN 7583 181.00 TI YAT Fees 10 21 12.30 300313 . Question Completion Status: QUESTION 4 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. MSET 2020 excerpt Rat 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 20207 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 FY20207 Round your answer to two decimal places. e. 2.76. B What was Microsoft's RCA (return on assets) for FY 20202. Round your answer to one decimal place butonit the ** here to search ITEM 8. FINANCIAL STATEMENTS AND SUPPLEMENTARY DATA INCOME STATEMENTS 2010 $ 68,041 $ 66,069 $ 54497 74,974 59.774 45.863 143,015 125.843 110.360 16,017 30,061 46,078 16.273 26,637 42 910 millons, except per share amounts) Year Ended June 30, Revenue Product Service and other Total revenue Cost of revenue: Product Service and other Total cost of revenue Gross margin Research and development Sales and marketing General and administrative Operating income Other income, net Income before income taxes Provision for income taxes Net income Earnings per share: Basic Dited Weighted average shares outstanding Basic Diluted 96,937 19,269 19,598 5,111 15,420 22,933 38.353 72,007 14,726 17.469 4,754 82,933 16,876 18.213 4.885 52.959 77 42.959 729 35,058 1.410 53,036 43.688 36.474 8,755 19,903 $ 44,281 5 39 240 5 10,571 s 582 5.76 S 5115 500 5 2.15 2.13 7.610 7,683 7.679 2,753 7.700 7.79% Refer to accompanying notes II ** UTE 2 12 85% + BALANCE SHEETS 2020 $ 13,576 5 122.951 TE 136,527 13 in min) 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 543,197 and $35,330 Operating lease right-of-use assets Equity investments Goodwill Intangible assets, net Other long-term assets Total assets 32,011 1,895 11,482 20 2 10 181,915 175, ELE 44,15 8,753 2,965 43,351 7,038 13,138 301,311 5 36.4 7,3 2,64 42 02 7.75 14,722 286,556 2 5 516 6,800 5,665 32.670 Liabilities and stockholders' equity Current liabilities Accounts payable Current portion of long-term debt Accrued compensation Short-term income taxes Short-term uneamed revenue Other current liabilities Total current liabities Long-term debit Long term income taxes Long-term uneamed revenue Deferred income taxes Operating lease liabilities Other long-term liabilities 12.500 5 2.749 7.874 2.130 36.000 10,027 72.310 59,578 29.432 3,180 69,420 0660 4,630 230 7,671 10,632 7581 . O I ON here to search 2,130 36,000 10,027 5 326 9,30 72,310 59,578 29,432 3,180 204 7,671 10,632 183,007 89.420 66.662 29,612 4,530 233 6,188 7,581 184 226 Short-term uneared 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 7643 Retained earnings Accumulated other comprehensive income (loss) Total stockholders' equity Total liabilities and stockholders' equity Refer to accompanying notes 57 80,552 34,566 3,186 118,304 78.520 24,150 (340) 102,330 286,556 $ 301,311 S