Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Apple, Inc. Consolidated Balance Sheets ( In millions, except number of shares which are reflected in thousands and par value ) September 2 8 ,
Apple, Inc.
Consolidated Balance Sheets
In millions, except number of shares which are reflected in thousands and par value
September September Select data from
Current assets
Cash and cash equivalents $ $
Marketable securities
Accounts receivable, net
Inventory
Vendor nontrade receivables
Other current assets
Total current assets
Noncurrent assets
Marketable securities
Property, plant and equipment, net
Other noncurrent assets
Total noncurrent assets
Total assets $ $ $
Current liabilities
Accounts payable $ $
Other current liabilities
Deferred revenue
Commercial paper
Term debt
Total current liabilities
Noncurrent liabilities
Term debt
Other noncurrent liabilities
Total noncurrent liabilities
Total liabilities
Shareholders' equity
Common stock and additional paidin capital, $ par value: shares authorized; and shares issued and outstanding, respectively
Retained earnings
Accumulated other comprehensive income loss
Total shareholders' equity
Total liabilities and shareholders' equity $ $
Apple, Inc.
Consolidated Statements of Operations
In millions, except per share amounts
Years ended September September September
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 $ $
Weightedaverage common shares outstanding used to find EPS:
Basic number of shares
Market value price per share to find PE ratio:
Market price per share on Sept. $ Ch
Calculate the return on assets ROA in for each company. Use formulas with cell references.
Select the company with the highest return on assets, and fill in see paint can icon above the cell with yellow. Select one cell as a team choose Apple, Google, or Samsung.
Ch
Assume that an ROA of is the industry average for these companies. Is the return on assets for each company better or worse than the industry average? Enter "Better" or "Worse" for each company.
Ch
Calculate the debt ratio for each company in and Use formulas with cell references.
Ch
Did your company's financial leverage increase or decrease from to Enter "Increase" or "Decrease" in the column for each company.
Ch
Looking at the debt ratio, is your company a more risky or less risky investment than the two competitiors? Hint: If your company is Apple, then decide if Apple a more or less risky investment than Google and Samsung. In the column for your company, write a short statement like, "Company A is a more risky investment than Company B but less risky than Company C
Ch
Calculate the profit margin for each company in and Use formulas with cell references.
For and select the company with the highest profit margin and fill in the cells with yellow. Select two cells as a team for each year choose Apple, Google, or Samsung.
Ch
Calculate the current ratio for each company in and Use formulas with cell references.
For and select the company that has the best ability to pay shortterm obligations based on the current ratio and fill in the cells with yellow. Select two cells as a team for each year choose Apple, Google, or Samsung.
Ch
Calculate the gross margin ratio for each company in and Use formulas with cell references.
For and select the company that earns more in gross margin for each dollar of net sales and fill in the cells with yellow. Select two cells as a team for each year choose Apple, Google, or Samsung.
Ch
For and did your company's gross margin ratio underperform or outperform the industry average? Enter "underperform" or "outperform" for each company for each year.
Step 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