Please complete the listed ratios for 2021 for Microsoft based on the financial statements below.

(In millions, except per share amounts) Year Ended June 30, Revenue: Product Service and other Total revenue ITEM 8. FINANCIAL STATEMENTS AND SUPPLEMENTARY DATA INCOME STATEMENTS 2021 $ 71,074 97,014 168,088 18,219 34,013 52,232 115,856 20,716 20,117 5,107 69,916 1,186 71,102 9,831 61,271 $ 8.12 $ 8.05 $ 7,547 7,608 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 Diluted Weighted average shares outstanding: Basic Diluted Refer to accompanying notes. $ $ $ 2020 68,041 $ 74,974 143,015 16,017 30,061 46,078 96,937 19,269 19,598 5,111 52,959 77 53,036 8,755 44,281 $ 5.82 $ 5.76 $ 7,610 7,683 2019 66,069 59,774 125,843 16,273 26,637 42,910 82,933 16,876 18,213 4,885 42,959 729 43,688 4,448 39,240 5.11 5.06 7,673 7,753 BALANCE SHEETS (In millions) 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 $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 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 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,519 and 7,571 Retained earnings Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity Refer to accompanying notes. 10 2021 14,224 $ 116,110 130,334 38,043 2,636 13,393 184,406 59,715 11,088 5,984 49,711 7,800 15,075 333,779 $ 15,163 $ 8,072 10,057 2,174 41,525 11,666 88,657 50,074 27,190 2,616 198 9,629 13,427 191,791 83,111 57,055 1,822 141,988 333,779 $ 2020 13,576 122,951 136,527 32,011 1,895 11,482 181,915 44,151 8,753 2,965 43,351 7,038 13,138 301,311 12,530 3,749 7,874 2,130 36,000 10,027 72,310 59,578 29,432 3,180 204 7,671 10,632 183,007 80,552 34,566 3,186 118,304 301,311 (In millions) Year Ended June 30, Net income Other comprehensive income (loss), net of tax: Net change related to derivatives Net change related to investments Translation adjustments and other Other comprehensive income (loss) Comprehensive income Refer to accompanying notes. PART II Item 8 COMPREHENSIVE INCOME STATEMENTS $ $ 2021 61,271 19 (2,266) 873 (1,374) 59,897 $ $ 2020 44,281 (38) 3,990 (426) $ 3,526 47,807 $ 2019 39,240 (173) 2,405 (318) 1,914 41,154 CASH FLOWS STATEMENTS (In millions) Year Ended June 30, Operations Net income Adjustments to reconcile net income to net cash from operations: Depreciation, amortization, and other Stock-based compensation expense Net recognized gains on investments and derivatives Deferred income taxes Changes in operating assets and liabilities: Accounts receivable Inventories Other current assets Other long-term assets Accounts payable Unearned revenue Income taxes Other current liabilities Other long-term liabilities Net cash from operations Financing Cash premium on debt exchange Repayments of debt Common stock issued Common stock repurchased Common stock cash dividends paid Other, net Net cash used in financing Investing Additions to property and equipment Acquisition of companies, net of cash acquired, and purchases of intangible and other assets Purchases of investments Maturities of investments Sales of investments Other, net Net cash used in investing Effect of foreign exchange rates on cash and cash equivalents Net change in cash and cash equivalents Cash and cash equivalents, beginning of period Cash and cash equivalents, end of period Refer to accompanying notes. $ $ 2021 61,271 $ 11,686 6,118 (1,249) (150) (6,481) (737) (932) (3,459) 2,798 4,633 (2,309) 4,149 1,402 76,740 (1,754) (3,750) 1,693 (27,385) (16,521) (769) (48,486) (20,622) (8,909) (62,924) 51,792 14,008 (922) (27,577) (29) 648 13,576 14,224 $ 2020 44,281 $ 12,796 5,289 (219) 11 (2,577) 168 (2,330) (1,037) 3,018 2,212 (3,631) 1,346 1,348 60,675 (3,417) (5,518) 1,343 (22,968) (15,137) (334) (46,031) (15,441) (2,521) (77,190) 66,449 17,721 (1,241) (12,223) (201) 2,220 11,356 13,576 $ 2019 39,240 11,682 4,652 (792) (6,463) (2,812) 597 (1,718) (1,834) 232 4,462 2,929 1,419 591 52,185 0 (4,000) 1,142 (19,543) (13,811) (675) (36,887) (13,925) (2,388) (57,697) 20,043 38,194 0 (15,773) (115) (590) 11,946 11,356 STOCKHOLDERS' EQUITY STATEMENTS (In millions, except per share amounts) Year Ended June 30, Common stock and paid-in capital Balance, beginning of period Common stock issued Common stock repurchased Stock-based compensation expense Other, net Balance, end of period Retained earnings Balance, beginning of period Net income Common stock cash dividends Common stock repurchased Cumulative effect of accounting changes Balance, end of period Accumulated other comprehensive income (loss) Balance, beginning of period Other comprehensive income (loss) Cumulative effect of accounting changes Balance, end of period Total stockholders' equity Cash dividends declared per common share Refer to accompanying notes. 61 LA $ $ 2021 80,552 $ 1,963 (5,539) 6,118 17 83,111 34,566 61,271 (16,871) (21,879) (32) 57,055 3,186 (1,374) 10 1,822 141,988 694 2020 78,520 1,343 (4,599) 5,289 80,552 24,150 44,281 (15,483) (18,382) 0 34,566 2.24 $ (1) (340) 2019 $ 71,223 6,829 (4,195) 4,652 11 78,520 13,682 39,240 (14,103) (15,346) 677 24,150 (2,187) 1,914 (67) (340) 102,330 1.84 3,526 3,186 $ 118,304 $ 2.04 $ Earnings per Share of Common Stock (basic - common) Current Ratio Gross Profit Rate Profit Margin Inventory Turnover Days in Inventory Accounts Receivable Turnover Average Collection Period Asset turnover Return on Assets (ROA) Debt to assets ratio As given in the income statement Current assets Current liabilities Gross profit Net sales Net income Net sales Cost of goods sold Average inventory 365 days Inventory turnover Net credit sales Average net accounts receivable 365 days Accounts receivable turnover Net sales Average total assets Net income Average total assets Total Liabilities Total Assets Return on Assets (ROA) Debt to assets ratio Times-Interest Earned Ratio Dividend Yield (Please follow the Course Project instructions to calculate the current dividend Return on Common Stockholders' Equity (ROE) Free cash flow Price-Earnings Ratio (Please see the Course Project instructions for the dates to use for this ratio.) Net income Average total assets Total Liabilities Total Assets Net income + interest expense + income tax expense interest expense Dividend per share of common stock (Yahoo Finance 12/24/2015) Market price per share of common stock (Yahoo Finance 12/24/2015) Net income - preferred dividends Average common stockholders' equity Net cash provided by operating activities minus capital expenditures minus cash dividends Market price per share of common stock as of 5/30/2014 for Nike and 12/31/2014 for Under Armour Earnings per share

Question

Please complete the listed ratios for 2021 for Microsoft based on the financial statements below.

image text in transcribed

(In millions, except per share amounts) Year Ended June 30, Revenue: Product Service and other Total revenue ITEM 8. FINANCIAL STATEMENTS AND SUPPLEMENTARY DATA INCOME STATEMENTS 2021 $ 71,074 97,014 168,088 18,219 34,013 52,232 115,856 20,716 20,117 5,107 69,916 1,186 71,102 9,831 61,271 $ 8.12 $ 8.05 $ 7,547 7,608 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 Diluted Weighted average shares outstanding: Basic Diluted Refer to accompanying notes. $ $ $ 2020 68,041 $ 74,974 143,015 16,017 30,061 46,078 96,937 19,269 19,598 5,111 52,959 77 53,036 8,755 44,281 $ 5.82 $ 5.76 $ 7,610 7,683 2019 66,069 59,774 125,843 16,273 26,637 42,910 82,933 16,876 18,213 4,885 42,959 729 43,688 4,448 39,240 5.11 5.06 7,673 7,753 BALANCE SHEETS (In millions) 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 $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 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 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,519 and 7,571 Retained earnings Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity Refer to accompanying notes. 10 2021 14,224 $ 116,110 130,334 38,043 2,636 13,393 184,406 59,715 11,088 5,984 49,711 7,800 15,075 333,779 $ 15,163 $ 8,072 10,057 2,174 41,525 11,666 88,657 50,074 27,190 2,616 198 9,629 13,427 191,791 83,111 57,055 1,822 141,988 333,779 $ 2020 13,576 122,951 136,527 32,011 1,895 11,482 181,915 44,151 8,753 2,965 43,351 7,038 13,138 301,311 12,530 3,749 7,874 2,130 36,000 10,027 72,310 59,578 29,432 3,180 204 7,671 10,632 183,007 80,552 34,566 3,186 118,304 301,311 (In millions) Year Ended June 30, Net income Other comprehensive income (loss), net of tax: Net change related to derivatives Net change related to investments Translation adjustments and other Other comprehensive income (loss) Comprehensive income Refer to accompanying notes. PART II Item 8 COMPREHENSIVE INCOME STATEMENTS $ $ 2021 61,271 19 (2,266) 873 (1,374) 59,897 $ $ 2020 44,281 (38) 3,990 (426) $ 3,526 47,807 $ 2019 39,240 (173) 2,405 (318) 1,914 41,154 CASH FLOWS STATEMENTS (In millions) Year Ended June 30, Operations Net income Adjustments to reconcile net income to net cash from operations: Depreciation, amortization, and other Stock-based compensation expense Net recognized gains on investments and derivatives Deferred income taxes Changes in operating assets and liabilities: Accounts receivable Inventories Other current assets Other long-term assets Accounts payable Unearned revenue Income taxes Other current liabilities Other long-term liabilities Net cash from operations Financing Cash premium on debt exchange Repayments of debt Common stock issued Common stock repurchased Common stock cash dividends paid Other, net Net cash used in financing Investing Additions to property and equipment Acquisition of companies, net of cash acquired, and purchases of intangible and other assets Purchases of investments Maturities of investments Sales of investments Other, net Net cash used in investing Effect of foreign exchange rates on cash and cash equivalents Net change in cash and cash equivalents Cash and cash equivalents, beginning of period Cash and cash equivalents, end of period Refer to accompanying notes. $ $ 2021 61,271 $ 11,686 6,118 (1,249) (150) (6,481) (737) (932) (3,459) 2,798 4,633 (2,309) 4,149 1,402 76,740 (1,754) (3,750) 1,693 (27,385) (16,521) (769) (48,486) (20,622) (8,909) (62,924) 51,792 14,008 (922) (27,577) (29) 648 13,576 14,224 $ 2020 44,281 $ 12,796 5,289 (219) 11 (2,577) 168 (2,330) (1,037) 3,018 2,212 (3,631) 1,346 1,348 60,675 (3,417) (5,518) 1,343 (22,968) (15,137) (334) (46,031) (15,441) (2,521) (77,190) 66,449 17,721 (1,241) (12,223) (201) 2,220 11,356 13,576 $ 2019 39,240 11,682 4,652 (792) (6,463) (2,812) 597 (1,718) (1,834) 232 4,462 2,929 1,419 591 52,185 0 (4,000) 1,142 (19,543) (13,811) (675) (36,887) (13,925) (2,388) (57,697) 20,043 38,194 0 (15,773) (115) (590) 11,946 11,356 STOCKHOLDERS' EQUITY STATEMENTS (In millions, except per share amounts) Year Ended June 30, Common stock and paid-in capital Balance, beginning of period Common stock issued Common stock repurchased Stock-based compensation expense Other, net Balance, end of period Retained earnings Balance, beginning of period Net income Common stock cash dividends Common stock repurchased Cumulative effect of accounting changes Balance, end of period Accumulated other comprehensive income (loss) Balance, beginning of period Other comprehensive income (loss) Cumulative effect of accounting changes Balance, end of period Total stockholders' equity Cash dividends declared per common share Refer to accompanying notes. 61 LA $ $ 2021 80,552 $ 1,963 (5,539) 6,118 17 83,111 34,566 61,271 (16,871) (21,879) (32) 57,055 3,186 (1,374) 10 1,822 141,988 694 2020 78,520 1,343 (4,599) 5,289 80,552 24,150 44,281 (15,483) (18,382) 0 34,566 2.24 $ (1) (340) 2019 $ 71,223 6,829 (4,195) 4,652 11 78,520 13,682 39,240 (14,103) (15,346) 677 24,150 (2,187) 1,914 (67) (340) 102,330 1.84 3,526 3,186 $ 118,304 $ 2.04 $ Earnings per Share of Common Stock (basic - common) Current Ratio Gross Profit Rate Profit Margin Inventory Turnover Days in Inventory Accounts Receivable Turnover Average Collection Period Asset turnover Return on Assets (ROA) Debt to assets ratio As given in the income statement Current assets Current liabilities Gross profit Net sales Net income Net sales Cost of goods sold Average inventory 365 days Inventory turnover Net credit sales Average net accounts receivable 365 days Accounts receivable turnover Net sales Average total assets Net income Average total assets Total Liabilities Total Assets Return on Assets (ROA) Debt to assets ratio Times-Interest Earned Ratio Dividend Yield (Please follow the Course Project instructions to calculate the current dividend Return on Common Stockholders' Equity (ROE) Free cash flow Price-Earnings Ratio (Please see the Course Project instructions for the dates to use for this ratio.) Net income Average total assets Total Liabilities Total Assets Net income + interest expense + income tax expense interest expense Dividend per share of common stock (Yahoo Finance 12/24/2015) Market price per share of common stock (Yahoo Finance 12/24/2015) Net income - preferred dividends Average common stockholders' equity Net cash provided by operating activities minus capital expenditures minus cash dividends Market price per share of common stock as of 5/30/2014 for Nike and 12/31/2014 for Under Armour Earnings per share