Answered step by step
Verified Expert Solution
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
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
- Average Collection Period
- Asset Turnover
- Return on Assets (ROA)
- Debt to assets Ratio
- Times Interest Earned Ratio
- 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. ]
- Return on Common Stockholders' Equity (ROE)
- Free cash flow
- 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.84Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started