Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help please do on excel For the next few questions, refer to the attached financial statements for Apple. Calculate the following for Apple's

i need help please do on excel
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
For the next few questions, refer to the attached financial statements for Apple. Calculate the following for Apple's for the NINE MONTH PERIOD ending in June 2021? Please show the work clearly for partial credit. Mark your answers clearly. 1) Gross Margin (in Ss) for both Products and for Services? 2) Gross Margin (in %) for Products, services, and Total? 3) For the nine month period, what is total revenue growth and which segment (products or services) 4) grew faster (please include actual growth rate %)? 5) What is Apple's Operating (EBIT) Margin? 6) What is their tax rate (in %)? 7) What is their profit margin (in %)? 8) What is Apple's EBITDA (in Ss) and EBITDA Margin (in %)? 9) What is Apple's Cash Flow from Operations? 10) How much did Apple spend on Capital Expenditures? 11) What is Apple's Free Cash Flow? 12) How much money did Apple use to pay dividends? 13) How much did they spend to repurchase their stock? Apple Inc. CONDENSED CONSOLIDATED STATEMENTS OF OPERATIONS (Unaudited) (In millions, except number of shares which are reflected in thousands and per share amounts) Three Months Ended Nine Months Ended June 26 June 27 June 26 June 27 2021 2020 2021 2020 Net sales: Products 63,948 46,529 $ 232,309 $ 170,598 Services 17,486 13,156 50,148 39,219 Total net sales 81,434 59,685 282,457 209,817 Cost of sales: Products 40,899 32,693 149,476 116,089 Services 5,280 4,312 15,319 13,461 Total cost of sales 46,179 37,005 164,795 129,550 Gross margin 35,255 22,680 117,662 80,267 Operating expenses Research and development Selling, general and administrative Total operating expenses 5,717 5,412 11,129 4,758 4,831 9,589 16,142 16,357 32,499 13,774 14,980 28,754 Operating income Other income/(expense), net Income before provision for income taxes Provision for income taxes Net income 24,126 243 24,369 2,625 21,744 13,091 46 13,137 1,884 11,253 85,163 796 85,959 11,830 74,129 $ 51,513 677 52,190 7,452 44,738 $ $ $ 2.56 Earnings per share: Basic Diluted Shares used in computing earnings per share: Basic Diluted 1.31 $ 1.30 $ 0.65 $ 0.65 $ 4.42 $ 4.38 $ 2.54 16,629,371 16,781,735 17,250,291 17,419,154 16,772,656 16,941,527 17,450,284 17,618,778 June 26, 2021 September 26, 2020 ASSETS: Current assets Cash and cash equivalents Marketable securities Accounts receivable, net Inventories Vendor non-trade receivables Other current assets Total current assets 34.050 $ 27,648 17,475 5.178 16,433 13,641 114,423 38,016 52,927 16,120 4,061 21,325 11,264 143,713 Non-current assets: Marketable securities Property, plant and equipment, net Other non-current assets Total non-current assets Total assets 131.948 38,615 44,854 215,417 329,840 100,887 36,766 42,522 180,175 323,888 LIABILITIES AND SHAREHOLDERS' EQUITY: Current liabilities: Accounts payable Other current liabilities Deferred revenue Commercial paper Term debt Total current liabilities 40,409 $ 43,625 7,681 8,000 8,039 107,754 42,296 42,684 6,643 4,996 8,773 105,392 Non-current liabilities: Term debt Other non-current liabilities Total non-current liabilities Total liabilities Commitments and contingencies 105,752 52,054 157,806 265,560 98,667 54,490 153,157 258,549 Shareholders' equity: Common stock and additional paid-in capital, $0.00001 par value: 50,400,000 shares authorized: 16,556,942 and 16,976,763 shares issued and outstanding, respectively Retained earnings Accumulated other comprehensive income/loss) Total shareholders' equity Total liabilities and shareholders' equity 54,989 9,233 58 64,280 329,840 50,779 14,966 (406) 65,339 323,888 $ Apple Inc. CONDENSED CONSOLIDATED STATEMENTS OF CASH FLOWS (Unaudited) in millions) Nine Months Ended June 26, June 27, 2021 2020 39,789 50,224 74,129 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 expense/(benefit) 44,738 B.295 5,961 (737) (689) 8,354 5,105 182 194) Other 11,316) (1.213) 4,892 (5,899) (1,786) 1738 463 83,838 5,149 10 8,685 16,760) (10,787) 1,649 3,867 60,098 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 Other Cash 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 Proceeds from commercial paper.net Proceeds from repurchase agreements Other Cash used in financing activities Decrease in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash, ending balances 194,052) 49,880 36,745 17,862) (13) (78) (15,380) 196,606) 54,865 39,780 (5,525) 11.473) (841) (9,820) 430 561 (5,855) (10,827) (66,223) 13,923 7,500) 3,022 (3,234) (10,570) (55,171) 10,635 (12,629) 31 5,165 (120) (65,4631 (15,185) 35,039 1721 (72.971) (4,513) 35,276 $

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

Business Analysis With Microsoft Excel

Authors: Conrad Carlberg

3rd Edition

0789736640, 9780789736642

More Books

Students also viewed these Accounting questions

Question

Describe the stockholders liability to creditors of a corporation.

Answered: 1 week ago

Question

Do Exercise 17-47 on the standard-form NLP of Exercise 17-48(a).

Answered: 1 week ago