Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Required ratios for 2021: Earnings per Share of Common Stock Current Ratio Gross Profit Rate Profit Margin Inventory Turnover Days in Inventory Accounts Receivable Turnover

image text in transcribedimage text in transcribedimage text in transcribed

Required ratios for 2021:

  1. Earnings per Share of Common Stock
  2. Current Ratio
  3. Gross Profit Rate
  4. Profit Margin
  5. Inventory Turnover
  6. Days in Inventory
  7. Accounts Receivable Turnover
  8. Average Collection Period
  9. Asset Turnover
  10. Return on Assets (ROA)
  11. Debt to assets Ratio
  12. Times Interest Earned Ratio
  13. Dividend Yield [For the purposes of this ratio, use obtain the dividend per share information from each company's statement of stockholders' equity. Obtain the stock prices for each company from Yahoo Finance. Use the closing price as of 9/24/21 for Apple, and 06/30/21 for Microsoft. ]
  14. Return on Common Stockholders' Equity (ROE)
  15. Free cash flow
  16. Price-Earnings Ratio (Obtain the stock prices for each company from Yahoo Finance. Use the closing price as of 9/24/21 for Apple, and 06/30/21 for Microsoft.)

PLease help

Please with all ratios possible with the given information. Any ratios that cant be answered due to lack of information can be left out

On 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 assets Total 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 labilties Other long-term liabilities Total liabilities BALANCE SHEETS 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. 59 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 $ 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 On 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 Uneamed 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 CASH FLOWS STATEMENTS PART 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. 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) 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 (3417) (5,518) 1,343 (22,968) (15,137) (334) (46,031) (20,622) (15,441) (8,909) (2.521) (62,924) (77,190) 51,792 66,449 14,008 17,721 (922) (1,241) (27,577) (29) 648 2,220 13,576 11,356 14,224 $ 13,576 S (12,223) (201) 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 (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 On milions, 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 PART Tam 8 STOCKHOLDERS' EQUITY STATEMENTS 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 2021 80,552 $ 1,963 (5,539) 6,118 17 83,111 34,566 61,271 (16,871) (21,879) (32) 57,055 2020 78,520 1,343 (4.599) 5,289 (1) 80,552 24,150 44,281 (15,483) (18,382) 34,566 (340) 3,526 0 3,186 (1,374) 10 1,822 3,186 $ 141,988 $ 118,304 $ 2.24 $ $ 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 2.04 $ 1.84

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

Corporate Financial Reporting And Analysis

Authors: David Young, Jacob Cohen

3rd Edition

1118470559, 9781118470558

More Books

Students also viewed these Accounting questions