Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Shown above are the income statement, balance sheet, and cash flow statement for a company. I need the 14 risk ratios for this company and

image text in transcribedimage text in transcribed

image text in transcribed

Shown above are the income statement, balance sheet, and cash flow statement for a company. I need the 14 risk ratios for this company and how to solve them for the years 2020 and 2019: Receivable Turnover Ratio, Inventory Turnover Ratio, Current Ratio, Acid-Test Ratio, Debt to Equity Ratio, Times Interest Earned, Gross Profit Ratio, Return on Assets, Profit Margin, Asset Turnover, Return on Equity, Price-Earnings Ratio, Average Collection Period, Average Days in Inventory

Am I missing information in order to obtain ratios?

E F B D 12 Months Ended Jun. 30, 2020 Jun. 30, 2019 $ 143,015 100.00% $ 125,843 46,078 32.22% 42,910 96,937 67.78% 82,933 100.00% 34.10% 65.90% 1 INCOME STATEMENTS - USD ($) shares 2 in Millions, $ in Millions 3 Revenue 4 Cost of revenue 5 Gross margin 6 7 Expenses: 8 Research and development 9 Sales and marketing 10 General and administrative 11 Operating income 12 Other income, net 13 Income before income taxes 14 Provision for income taxes 15 Net income 16 17 Earnings per share: 18 Basic 19 19,269 19,598 5,111 52,959 77 53,036 8,755 $ 44,281 13.47% 13.70% 3.57% 37.03% 0.05% 37.08% 6.12% 30.96% 16,876 18,213 4,885 42,959 729 43,688 4,448 $ 39,240 13.41% 14.47% 3.88% 34.14% 0.58% 34.72% 3.53% 31.18% $ 5.82 $ 5.11 20 21 22 23 24 25 26 27 28 29 30 31 32 Income Statement - Vertical Income Statement - Horizontal Balance Sheet Risk Ratios + Ready B C D E F G H 1 Jun 30, 2020 Jun 30, 2019 Difference Percent Change ul $ 13,576 122,951 136,527 32,011 1,895 11,482 181,915 AA154 44,151 8,753 2,965 43,351 7,038 13,138 $ 11,356 122,463 133,819 29,524 2,063 10,146 175,552 26 227 36,477 7,379 2,649 ca 42,026 7,750 14,723 $ 2,220 $ 488 $ 2,708 $ 2,487 $ (168) S 1,336 ces $ 6,363 $ 7,674 $ 1,374 $ 316 $ 1,325 S (712) $(1,585) $ 14,755 19.55% 0.40% 2.02% 8.42% -8.14% 19 13.17% 3.62% 21.04% 18.62% 11.93% 3.15% -9.19% -10.77% 5.15% 301,311 286,556 33.55% BALANCE SHEETS - USD ($) $ in Millions 1 Current assets: 3 Cash and cash equivalents 4 5 Short-term investments 6 Total cash, cash equivalents, and short-term investments 7 Accounts receivable, net of allowance for doubtful accounts of $788 and $411 8 Inventories 9 Other current assets 10 Total current assets 11 Property and equipment, net of accumulated depreciation of $43,197 and $35,330 12 Operating lease right-of-use assets 13 Equity investments 14 Goodwill 15 Intangible assets, net 16 Other long-term assets 17 Total assets 19 19 Current liabilities: 20 Accounts payable 21 Current portion of long-term debt 22 Accrued compensation 23 Short-term income taxes 24 Short-term unearned revenue 25 Other current liabilities 26 Total current liabilities 27 Long-term debt 28 Long-term income taxes 29 Long-term unearned revenue 30 Deferred income taxes 31 Operating lease liabilities 32 Other long-term liabilities 33 Total liabilities 34 Commitments and contingencies 35 36 Stockholders' equity: 36 37 Common stock and paid-in capital - shares authorized 24,000; outstanding 7,571 38 Retained earnings 39 Accumulated other comprehensive income (loss) 40 Total stockholders' equity 41 Total liabilities and stockholders' equity 42 -32.03% 15.29% -62.40% 12,530 3,749 7,874 2,130 36,000 10,027 72,310 59,578 29,432 3,180 9,382 5,516 6,830 5,665 32,676 9,351 69,420 66,662 29,612 4,530 233 6,188 7,581 184,226 $ 3,148 $ (1,767) $ 1,044 $ (3,535) $ 3,324 $ 676 $ 2,890 $ 17,084) $(180) $ (1,350) S (29) $ 1,483 $ 3,051 $ (1,219) 10.17% 7.23% 4.16% -10.63% -0.61% -29.80% - 12.45% 23.97% 40.25% -0.66% 204 7,671 10,632 183,007 80,552 34,566 3,186 118,304 $ 301,311 78,520 24,150 (340) 102,330 $ 286,556 $ 2,032 $ 10,416 $ 3,526 $ 15,974 $ 14,755 2.59% 43.13% -1037.06% 15.61% 5.15% 43 44 45 46 47 48 49 Income Statement - Vertical Income Statement - Horizontal Balance Sheet Risk Ratios Ready 1,419 A B 4 US$ in millions 5 12 months ended: Jun 30, 2020 Jun 30, 2019 6 Net income 44,281 39,240 7 Asset impairments 8 Depreciation, amortization, and other 12,796 11,682 9 Stock-based compensation expense 5,289 4,652 10 Net recognized gains on investments and derivatives (219) (792) 11 Excess tax benefits from stock-based compensation 12 Deferred income taxes 11 (6,463) 13 Deferral of unearned revenue 14 Recognition of unearned revenue 15 Accounts receivable (2,577) (2,812) 16 Inventories 168 597 17 Other current assets (2,330) (1,718) 18 Other long-term assets (1,037) (1,834) 19 Accounts payable 3,018 232 20 Unearned revenue 2,212 4,462 21 Income taxes (3,631) 22 Other current liabilities 1,346 23 Other long-term liabilities 1,348 591 24 Changes in operating assets and liabilities (1,483) 3,866 25 Adjustments to reconcile net income to net cash from operations 16,394 12,945 26 Net cash from operations 60,675 52,185 Proceeds from issuance (repayments) of short-term debt, maturities of 27 90 days or less, net 28 Proceeds from issuance of debt 29 Cash premium on debt exchange (3,417) 30 Repayments of debt (5,518) (4,000) 31 Common stock issued 1,343 1,142 32 Common stock repurchased (22,968) (19,543) 33 Common stock cash dividends paid (15,137) (13,811) 34 Excess tax benefits from stock-based compensation 35 Other, net (334) (675) 36 Net cash from (used in) financing (46,031) (36,887) 37 Additions to property and equipment (15,441) (13,925) Acquisition of companies, net of cash acquired, and purchases of 38 intangible and other assets (2,521) (2,388) 39 Purchases of investments (77,190) (57,697) 40 Maturities of investments 66,449 20,043 41 Sales of investments 17,721 38,194 42 Other, net (1,241) 43 Net cash used in investing (12,223) (15,773) 44 Effect of foreign exchange rates on cash and cash equivalents (201) (115) 45 Net change in cash and cash equivalents 2,220 (590) 46 Cash and cash equivalents, beginning of period 11,356 11,946 47 Cash and cash equivalents, end of period 13,576 11,356 48 Based on:10-K (filing date: 2020-07-31),10-K (filing date: 2019-08-01),10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07- 49 50 51 52 53 54 Cash Flow Statement +

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

The Definitive Guide To Blockchain For Accounting And Business

Authors: Saurav K. Dutta

1st Edition

1789738687, 9781789738681

More Books

Students also viewed these Accounting questions

Question

How will you establish groups?

Answered: 1 week ago

Question

How can evaluation of LMD become more than an act of faith?

Answered: 1 week ago