December 2020 Apple All 16 ratios for each company with the supporting calculations and commentary on your Worksheet Rat
Posted: Sat Feb 19, 2022 2:31 pm
December 2020 Apple All 16 ratios for each company with the
supporting calculations and commentary on your Worksheet Ratio
tab.
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
14.Return on Common Stockholders' Equity (ROE)
15. Free cash flow
16.Price-Earnings Ratio [For the purpose of this ratio, look up
the market price per share as of the balance sheet date, or last
business day prior to the balance sheet date for each company.] I
specifically need assistance with: (PLEASE INCLUDE HOW YOU GOT
ANSWER SO THAT I MAY LEARN MOVING FORWARD)
12 Months Ended Sep. 26, 2020 Sep. 28, 2019 Sep. 29, 2018 $ 50,224 $ 25,913 $ 20,289 57,411 55,256 59,531 11,056 6,829 (215) 12,547 6,068 (340) (652) 10,903 5,340 (32,590) (444) (97) 6,917 (127) 1,553 (9,588) (4,062) 2,081 8,916 80,674 245 (289) 2,931 873 (1,923) (625) (4,700) 69,391 (5,322) 828 (8,010) (423) 9,175 (3) 38,449 77,434 CONSOLIDATED STATEMENTS OF CASH FLOWS - USD ($) $ in Millions Statement of Cash Flows [Abstract] Cash, cash equivalents and restricted cash, beginning balances Operating activities: Net income Adjustments to reconcile net income to cash generated by operating activities: Depreciation and amortization Share-based compensation expense Deferred income tax benefit Other Changes in operating assets and liabilities: Accounts receivable, net Inventories Vendor non-trade receivables Other current and non-current assets Accounts payable Deferred revenue Other current and non-current liabilities Cash generated by operating activities Investing activities: Purchases of marketable securities Proceeds from maturities of marketable securities Proceeds from sales of marketable securities Payments for acquisition of property, plant and equipment Payments made in connection with business acquisitions, net Purchases of non-marketable securities Proceeds from non-marketable securities Other Cash generated by used in) investing activities Financing activities: Proceeds from issuance of common stock Payments for taxes related to net share settlement of equity awards Payments for dividends and dividend equivalents Repurchases of common stock Proceeds from issuance of term debt, net Repayments of term debt Repayments of commercial paper, net Other Cash used in financing activities Increase/(Decrease) in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash, ending balances Supplemental cash flow disclosure: Cash paid for income taxes, net Cash paid for interest (114,938) 69,918 50,473 (7,309) (1,524) (210) 92 (791) (4,289) (39,630) 40,102 56,988 (10,495) (624) (1,001) 1,634 (1,078) 45,896 (71,356) 55,881 47,838 (13,313) (721) (1,871) 353 (745) 16,066 880 (3,634) (14,081) (72,358) 16,091 (12,629) (963) (126) (86,820) (10,435) 39,789 781 (2,817) (14,119) (66,897) 6,963 (8,805) (5,977) (105) (90,976) 24,311 50,224 669 (2,527) (13,712) (72,738) 6,969 (6,500) (37) 0 (87,876) 5,624 25,913 9,501 $ 3,002 15,263 $ 3,423 10,417 $ 3,022
Sep. 26, 2020 Sep. 28, 2019 $ 38,016 52,927 16,120 4,061 21,325 11,264 143,713 $ 48,844 51,713 22,926 4,106 22,878 12,352 162,819 100,887 36,766 42,522 180,175 323,888 105,341 37,378 32,978 175,697 338,516 CONSOLIDATED BALANCE SHEETS - USD ($) $ in Millions Current assets: Cash and cash equivalents Marketable securities Accounts receivable, net Inventories Vendor non-trade receivables Other current assets Total current assets Non-current assets: Marketable securities Property, plant and equipment, net Other non-current assets Total non-current assets Total assets Current liabilities: Accounts payable Other current liabilities Deferred revenue Commercial paper Term debt Total current liabilities Non-current liabilities: Term debt Other non-current liabilities Total non-current liabilities Total liabilities Commitments and contingencies Shareholders' equity: Common stock and additional paid-in capital, S0.00001 par value: 50,400,000 shares authorized; 16,976,763 and 17,772,945 shares issued and outstanding, respectively Retained earnings Accumulated other comprehensive income/(loss) Total shareholders' equity Total liabilities and shareholders' equity 42,296 42,684 6,643 4,996 8,773 105,392 46,236 37,720 5,522 5,980 10,260 105,718 98,667 54,490 153,157 258,549 91,807 50,503 142,310 248,028 50,779 45, 174 14,966 (406) 65,339 $ 323,888 45,898 (584) 90,488 $ 338,516
12 Months Ended Sep. 26, 2020 Sep. 28, 2019 Sep. 29, 2018 $ 274,515 $ 260,174 $ 265,595 169,559 161,782 163,756 104,956 98,392 101,839 CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) shares in Thousands, $ in Millions Net sales Cost of sales Gross margin Operating expenses: Research and development Selling, general and administrative Total operating expenses Operating income Other income/(expense), net Income before provision for income taxes Provision for income taxes Net income Earnings per share: Basic (in dollars per share) Diluted (in dollars per share) Shares used in computing earnings per share: Basic (in shares) Diluted (in shares) Products Net sales Cost of sales Services Net sales Cost of sales 18,752 19,916 38,668 66,288 803 67,091 9,680 $ 57,411 16,217 18,245 34,462 63,930 1,807 65,737 10,481 $ 55,256 14,236 16,705 30,941 70,898 2,005 72,903 13,372 $ 59,531 $ 3.31 $ 3.28 $ 2.99 $ 2.97 $ 3.00 $ 2.98 17,352, 119 17,528,214 18,471,336 18,595,651 19,821,510 20,000,435 $ 220,747 151,286 $ 213,883 144,996 $ 225,847 148,164 53,768 $ 18,273 46,291 $ 16,786 39,748 $ 15,592
supporting calculations and commentary on your Worksheet Ratio
tab.
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
14.Return on Common Stockholders' Equity (ROE)
15. Free cash flow
16.Price-Earnings Ratio [For the purpose of this ratio, look up
the market price per share as of the balance sheet date, or last
business day prior to the balance sheet date for each company.] I
specifically need assistance with: (PLEASE INCLUDE HOW YOU GOT
ANSWER SO THAT I MAY LEARN MOVING FORWARD)
- December 2020 Apple All 16 Ratios For Each Company With The Supporting Calculations And Commentary On Your Worksheet Rat 1 (68.58 KiB) Viewed 46 times
Sep. 26, 2020 Sep. 28, 2019 $ 38,016 52,927 16,120 4,061 21,325 11,264 143,713 $ 48,844 51,713 22,926 4,106 22,878 12,352 162,819 100,887 36,766 42,522 180,175 323,888 105,341 37,378 32,978 175,697 338,516 CONSOLIDATED BALANCE SHEETS - USD ($) $ in Millions Current assets: Cash and cash equivalents Marketable securities Accounts receivable, net Inventories Vendor non-trade receivables Other current assets Total current assets Non-current assets: Marketable securities Property, plant and equipment, net Other non-current assets Total non-current assets Total assets Current liabilities: Accounts payable Other current liabilities Deferred revenue Commercial paper Term debt Total current liabilities Non-current liabilities: Term debt Other non-current liabilities Total non-current liabilities Total liabilities Commitments and contingencies Shareholders' equity: Common stock and additional paid-in capital, S0.00001 par value: 50,400,000 shares authorized; 16,976,763 and 17,772,945 shares issued and outstanding, respectively Retained earnings Accumulated other comprehensive income/(loss) Total shareholders' equity Total liabilities and shareholders' equity 42,296 42,684 6,643 4,996 8,773 105,392 46,236 37,720 5,522 5,980 10,260 105,718 98,667 54,490 153,157 258,549 91,807 50,503 142,310 248,028 50,779 45, 174 14,966 (406) 65,339 $ 323,888 45,898 (584) 90,488 $ 338,516
12 Months Ended Sep. 26, 2020 Sep. 28, 2019 Sep. 29, 2018 $ 274,515 $ 260,174 $ 265,595 169,559 161,782 163,756 104,956 98,392 101,839 CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) shares in Thousands, $ in Millions Net sales Cost of sales Gross margin Operating expenses: Research and development Selling, general and administrative Total operating expenses Operating income Other income/(expense), net Income before provision for income taxes Provision for income taxes Net income Earnings per share: Basic (in dollars per share) Diluted (in dollars per share) Shares used in computing earnings per share: Basic (in shares) Diluted (in shares) Products Net sales Cost of sales Services Net sales Cost of sales 18,752 19,916 38,668 66,288 803 67,091 9,680 $ 57,411 16,217 18,245 34,462 63,930 1,807 65,737 10,481 $ 55,256 14,236 16,705 30,941 70,898 2,005 72,903 13,372 $ 59,531 $ 3.31 $ 3.28 $ 2.99 $ 2.97 $ 3.00 $ 2.98 17,352, 119 17,528,214 18,471,336 18,595,651 19,821,510 20,000,435 $ 220,747 151,286 $ 213,883 144,996 $ 225,847 148,164 53,768 $ 18,273 46,291 $ 16,786 39,748 $ 15,592