Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the Income Statement for the 12 months ending 6/30/2019 and the Balance Sheet as of 6/30/2019 [shown in green]. For each ratio, show the

image text in transcribedimage text in transcribedimage text in transcribed

Use the Income Statement for the 12 months ending 6/30/2019 and the Balance Sheet as of 6/30/2019 [shown in green].

For each ratio, show the numerator, denominator, and the ratio. For the ratio, use two digits to the right of the decimal.

For example, for the "Cash Ratio", Total Cash = $133,819. Current Liabilities = $69,420. Cash Ratio = 1.92 Times.

5.

I. Liquidity Ratios

1. Current Ratio

2. Quick Ratio

3. Cash Ratio

II. Financial Risk

4. Liabilities/Equity Ratio

5. Equity Multiplier

6. Debt/Assets Ratio

III. Activity Ratios

7. Inventory Turnover Ratio

8. Inventory Days Sales Outstanding (DSO)

9. Accounts Receivable Turns

10, Days Sales in Receivables

11. Total Asset Turnover Ratio

IV. Profitability

12, Profit Margin

13. Return on Assets

14, Return on Equity

V. Market Value Ratios

15. Price Earnings Ratio

16. Price/Book Ratio

Microsoft Corporation INCOME STATEMENTS - USD ($) shares in Millions, $ in Millions Revenue Cost of revenue Gross margin Research and development Sales and marketing General and administrative Restructuring 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 Jun. 30, 2019 $ 125,843 42,910 82,933 16,876 18,213 4,885 0 42,959 729 43,688 4,448 $ 39,240 [1] 12 Months Ended Jun. 30, 2018 $ 110,360 38,353 72,007 14,726 17,469 4,754 0 35,058 1,416 36,474 19,903 $ 16,571 [2] Jun. 30, 2017 $ 96,571 34,261 62,310 13,037 15,461 4,481 306 29,025 876 29,901 4,412 $ 25,489 $ 5.11 $ 5.06 [3] $ 2.15 $ 2.13 [4] $ 3.29 $ 3.25 7,673 7,753 7,700 7,794 7,746 7,832 Jun. 30, 2019 Jun. 30, 2018 $ 11,356 122,463 133,819 29,524 $ 11,946 121,822 133,768 26,481 2.063 10,146 175,552 36,477 2,662 6,751 169,662 29,460 BALANCE SHEETS - USD ($) $ in Millions 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 $411 and $377 Inventories Other Total current assets Property and equipment, net of accumulated depreciation of $35,330 and $29,223 Operating lease right-of-use assets Equity investments Goodwill Intangible assets, net Other long-term assets Total assets Current liabilities: Accounts payable Current portion of long-term debt Accrued compensation Short-term income taxes Short-term unearned revenue Other Total current liabilities Long-term debt 7,379 2,649 42,026 7,750 14,723 286,556 6,686 1,862 35,683 8,053 7,442 258,848 9,382 5,516 6,830 5,665 32,676 9,351 69,420 66,662 8,617 3,998 6,103 2,121 28,905 8,744 58,488 72,242 29,612 4,530 233 6,188 7,581 184,226 30,265 3,815 541 5,568 5,211 176,130 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,643 and 7,677 Retained earnings Accumulated other comprehensive loss Total stockholders' equity Total liabilities and stockholders' equity 78,520 71,223 24,150 (340) 102,330 $ 286,556 13,682 (2,187) 82,718 $ 258,848 Stock price on June 30, 2019 $ 135.68

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

Financial Planning & Analysis And Performance Management

Authors: Jack Alexander

1st Edition

1119491487, 9781119491484

More Books

Students also viewed these Finance questions

Question

finding entry-level positions;

Answered: 1 week ago

Question

Explain the various methods of job evaluation

Answered: 1 week ago

Question

Differentiate Personnel Management and Human Resource Management

Answered: 1 week ago

Question

Describe the functions of Human resource management

Answered: 1 week ago

Question

What are the objectives of Human resource planning ?

Answered: 1 week ago

Question

=+ What scenarios could draw the audience in?

Answered: 1 week ago

Question

=+ What graphics could stop the viewer?

Answered: 1 week ago