Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

When answering questions one through 34, you are to assume: MSFT's operating cash is the smaller of: (1) its cash and cash equivalents or (2)

When answering questions one through 34, you are to assume:

  • MSFT's operating cash is the smaller of: (1) its cash and cash equivalents or (2) two percent of its total revenues.
  • The following financial statement line items relate to operating activities: Other current assets (balance sheet). Other long-term assets (balance sheet). Other current liabilities (balance sheet). Deferred income taxes (balance sheet). Other long-term liabilities (balance sheet).
  • Regarding all other financial statement line items, it is your responsibility to determine whether a particular line item relates either to operating activities or to financing activities.
  • Inventory shown on MSFT's balance sheet relates to physical inventory?i.e., products that MSFT resells to its customers. The cost of revenue from sales of products equals the cost of physical inventory that was sold during the year.
  • Accounts payable consists of: (1) amounts owed to suppliers of physical inventory and (2) amounts owed to advertisers of MSFT products, suppliers of services, etc. As of June 30, 2021 (June 30, 2020), the portion of accounts payable relating to amounts owed by MSFT to its suppliers of physical inventory was 5,000 (4,500) million U.S. dollars.
  • During the fiscal year ending on June 30, 2021 MSFT's depreciation expense relating to property and equipment was 11,686 million U.S. dollars.
  • The tax rate equals 21 percent

Finally, note that MSFT provides the following footnote disclosure about its cash, cash equivalents, short-term investments, and equity investments:

Our investments are intended to facilitate capital preservation. Our cash equivalents and short-term investments consist predominantly of highly liquid investment-grade fixed-income securities issued by governments, government agencies, and large corporations. Our equity investments consist predominantly of mutual fund securities.

QUESTIONS:

16) During the fiscal year ending on June 30, 2021, what was the average number of days between the day MSFT purchased physical inventory and the day it paid the supplier of the physical inventory?

17) During the fiscal year ending on June 30, 2021, what amount of cash did MSFT pay its suppliers of physical inventory? Your answer should be in millions of U.S. dollars.

18) For the fiscal year ending on June 30, 2021, what was MSFT's operating asset turnover?

19) For the fiscal year ending on June 30, 2021, what was MSFT's fixed asset turnover?

20) For the fiscal year ending on June 30, 2021, what was MSFT's net expenditures on property and equipment? Note by "net" I mean the difference between amounts spent by MSFT on property and equipment and amounts received by MSFT from selling property and equipment. Assume that MSFT did not record any asset impairments during the year. Also, assume that any property/equipment that was either retired or sold during the year was fully depreciated. Your answer should be in millions of U.S. dollars.

image text in transcribedimage text in transcribed
Balance Sheets June 30, (millions of USD) 2021 2020 Cash and cash equivalents 14,224 13,576 Short-term investments 116,110 122,951 Total cash, cash equivalents, and short-term investment 130,334 136,527 Accounts receivable 38,043 32,011 Inventories 2,636 1,895 Other current assets 13,393 11,482 Total current assets 184,406 181,915 Property and equipment 59,715 44,151 Operating lease right-of-use assets 11,088 8,753 Equity investments 5,984 2,965 Goodwill 49,711 43,351 Intangible assets, net 7,800 7,038 Other long-term assets 15,075 13,138 Total assets 333,779 301,311 Accounts payable 15,163 12,530 Current portion of long-term debt 8,072 3,749 Accrued compensation 10,057 7,874 Short-term income taxes 2,174 2,130 Short-term unearned revenue 41,525 36,000 Other current liabilities 11,666 10,027 Total current liabilities 88,657 72,310 Long-term debt 50,074 59,578 Long-term income taxes 27,190 29,432 Long-term unearned revenue 2,616 3,180 Deferred income taxes 198 204 Operating lease liabilities 9,629 7,671 Other long-term liabilities 13,427 10,632 Total liabilities 191,791 183,007 Common stock and paid-in capital 83,111 80,552 Retained earnings 57,055 34,566 Accumulated other comprehensive income 1,822 3,186 Total stockholders' equity 141,988 118,304 Total liabilities and stockholders' equity 333,779 301,311Total 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 Interest and dividend income Interest expense Income before income taxes Income tax expense Net income Income Statements Year Ended June 30, [In millions USD] Revenue: Product Service and other 7 FLUIM 58,041 2021 ' 2020 ' 2013 66,059 9?,{114 2'43?! 59, W4 13,213 34,013 32,232 113,333 20,213 20,112 3,102 33,313 3,332 2,343 21,102 3,331 31,221 13,012 30,031 43,023 33,332 13,233 13,333 3,111 32,333 2,333 -2,322 33,033 3,233 44,231 153,038 1433015 125,843 13,223 23,332 42,310 32,333 13,323 13,213 4,333 42,333 3,334 -2,323 43,333 4,443 33,240

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_2

Step: 3

blur-text-image_3

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

Fraud Data Analytics Methodology

Authors: Leonard W Vona

1st Edition

111918679X, 9781119186793

More Books

Students also viewed these Accounting questions

Question

3. Call on low achievers as often as you do high achievers.

Answered: 1 week ago

Question

3. Avoid making mistakes when reaching our goals

Answered: 1 week ago