Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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 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.

For answering parts g and h, note that Microsoft reported total assets of $286,556 millions on June 30, 2019.

  1. 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 "Product"?
  2. Microsoft reported basic EPS of $5.82 for FY 2020. Show the numbers reported on p. 57 (the income statement) that can be used to calculate this EPS. Numerator = , denominator =
  3. What dollar amount (in millions) did Microsoft's customers owe for past purchases at the end of FY 2020?
  4. What dollar amounts (in milions) did Microsoft expect to collect from customers for past purchaes as of the end of FY 2020?
  5. What was Microsoft's current ratio at June 30, 2020? Round your answer to one decimal place, e.g., 4.2.
  6. What was Microsoft's profit margin percentage for FY 2020? Round your answer to one decimal place. %
  7. What was Microsoft's asset turnover ratio for FY 2020? Round your answer to two decimal places, e.g., 2.76.
  8. What was Microsoft's ROA (return on assets) for FY 2020? Round your answer to one decimal place and remember that ROA is expressed as a percentage.
PART 11 Item 8 ITEM 8. FINANCIAL STATEMENTS AND SUPPLEMENTARY DATA INCOME STATEMENTS 2021 2020 2019 (In millions, except per share amounts) 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 18,219 34,013 16,017 30,061 16,273 26,637 52,232 Cost of revenue: Product Service and other Total cost of revenue Gross margin Research and development Sales and marketing General and administrative 46,078 42,910 115,856 20,716 20,117 5,107 96,937 19,269 19,598 5,111 82,933 16,876 18,213 4,885 Operating income Other income, net 52,959 77 42,959 729 69,916 1,186 71,102 9,831 Income before income taxes Provision for income taxes 53,036 8,755 43,688 4,448 $ 61,271 $ 44,281 $ 39,240 Net income Earnings per share: Basic Diluted Weighted average shares outstanding: Basic Diluted $ $ 8.12 $ 8.05 $ 5.82 $ 5.76 $ 5.11 5.06 7,547 7,608 7,610 7,683 7,673 7,753 Refer to accompanying notes. BALANCE SHEETS (In millions) 2021 2020 $ 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 14,224 $ 116,110 130,334 38,043 2,636 13,393 13,576 122,951 136,527 32,011 1,895 11,482 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 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 12,530 3,749 7,874 2,130 36,000 10,027 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 88,657 50,074 27,190 2,616 198 9,629 13,427 72,310 59,578 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 333,779 $ 118,304 301,311 $ Refer to accompanying notes. 59

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Auditing Mantras Forensic Accounting Important Standards On Auditing

Authors: Buffy Mielcarek

1st Edition

B09PP4SKL1, 979-8796281437

More Books

Students also viewed these Accounting questions

Question

State the uses of job description.

Answered: 1 week ago

Question

Explain in detail the different methods of performance appraisal .

Answered: 1 week ago

Question

6. Explain the strengths of a dialectical approach.

Answered: 1 week ago

Question

2. Discuss the types of messages that are communicated nonverbally.

Answered: 1 week ago