Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Apple Sep. 30, 2017 Sep. 24, 2016 Common Size Balance Sheet Consolidated Balance Sheets (USD $) in Millions Date 1 Date 2 Date 1 In

Apple Sep. 30, 2017 Sep. 24, 2016 Common Size Balance Sheet Consolidated Balance Sheets (USD $) in Millions Date 1 Date 2 Date 1 In Millions, unless otherwise specified Assets: Current assets: Cash and cash equivalents $ 20,289 $ 20,484 5% Short-term marketable securities 53,892 46,671 14% Accounts receivable, less allowances of $58 and $53, respectively 17,874 15,754 5% Inventories 4,855 2,132 1% Vendor non-trade receivables 17,799 13,545 5% Other current assets 13,936 8,283 4% Total current assets 128,645 106,869 34% Long-term marketable securities 194,714 170,430 52% Property, plant and equipment, net 33,783 27,010 9% Goodwill 5,717 5,414 2% Acquired intangible assets, net 2,298 3,206 1% Other non-current assets 10,162 8,757 3% Total assets 375,319 321,686 Current liabilities: Accounts payable 49,049 37,294 13% Accrued expenses 25,744 22,027 7% Deferred revenue 7,548 8,080 2% Commercial paper 11,977 8,105 3% Current portion of long-term debt 6,496 3,500 2% Total current liabilities 100,814 79,006 27% Deferred revenue, non-current 2,836 2,930 1% Long-term debt 97,207 75,427 26% Other non-current liabilities 40,415 36,074 11% Total liabilities 241,272 193,437 64% Commitments and contingencies Shareholders equity: Common stock and additional paid-in capital, $0.00001 par value: 12,600,000 shares authorized; 5,126,201 and 5,336,166 shares issued and outstanding, respectively 35,867 31,251 10% Retained earnings 98,330 96,364 26% Accumulated other comprehensive income/(loss) (150) 634 0% Total shareholders equity 134,047 128,249 36% Total liabilities and shareholders equity $ 375,319 $ 321,686 100% Weighted Average Common Shares Outstanding 4,882,167 5,217,242 Sep. 30, 2017 Sep. 24, 2016 Common Size Income Statement Income Statement [Abstract] Date 1 Date 2 Date 1 Net sales $ 229,234 $ 215,639 100% Cost of sales 141,048 131,376 62% Gross margin 88,186 84,263 38% Operating expenses: Research and development 11,581 10,045 5% Selling, general and administrative 15,261 14,194 7% Total operating expenses 26,842 24,239 12% Operating income 61,344 60,024 27% Other income/(expense), net 2,745 1,348 1% Income before provision for income taxes 64,089 61,372 28% Provision for income taxes 15,738 15,685 7% Net income $ 48,351 $ 45,687 21% Earnings per share: Basic (in dollars per share) $ 9.27 $ 8.35 Diluted (in dollars per share) $ 9.21 $ 8.31 Shares used in computing earnings per share: Basic (in shares) 5,217,242 5,470,820 Diluted (in shares) 5,251,692 5,500,281 (Information from Cash Flow Statement) Depreciation and amortization (1) 10,157 10,505 (2) Info From :CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY CONSOLIDATED STATEMENTS OF STOCKHOLDERS" EQUITY (Parenthetical) (USD $) Cash dividends declared and paid per share (in dollars per share) (2) $ 2.4 $ 2.18 To calculate the ratios, referece the information from the B/S and Income Statement that you just copied (look at the cells for the APPL and/or MSFT and how these numbers refer to cells above THE GAP Sep. 30, 2017 Sep. 24, 2016 Liquidity Ratios Current Ratio Current Assets 128,645 106,869 Current Liablities 100,814 79,006 Current Ratio = CA / CL 1.28 1.35 Quick Ratio Current Assets 128,645 106,869 Merchandise Inventory 4,855 2,132 Current Liablities 100,814 79,006 Quick Ratio = (CA Inventory) / CL 1.227904854 1.325684125 Cash Ratio Current assets: 128,645 106,869 Deferred revenue, non-current 7,548 8,080 Cash Ratio = Cash / CL 17.04358771 13.22636139 Financial Leverage Ratios Total Debt Ratio Total Assets 375,319 321,686 Total Shareholders Equity 134,047 128,249 Total Debt Ratio = (Total Assets- Total Equity)/TA 0.642845153 0.601322408 Debt to Equity Ratio Total Debt 241,272 193,437 Total Equity 134,047 128,249 Debt/Equity 1.799906003 1.508292462 Equity Multiplier Total Assets 375,319 321,686 Total Equity 134,047 128,249 Equity Multiplier = TA/TE = 1+D/E 2.799906003 2.508292462 2.799906003 2.508292462 Asset Manangent Ratios Inventory Turnover COGS 141,048 131,376 Inventory 4,855 2,132 Inventory Turn over =COGS /Inventory 29.05211123 61.62101313 Days Sales in Inventory Inventory Turn over 29.05211123 61.62101313 Days Sales in Inventory = 365/Inventory Turn Over 12.56363082 5.923304104 Receivables Turnover Sales $229,234 $215,639 A-R 17,874 15,754 Receivables Turnover =Sales/A-R 12.82 13.69 Days Sales in Recievables Receivables Turn over 12.82 13.69 Days Sales in Recievables = 365/Recievable Turn Over 28.46 26.67 Payables Turnover COGS 141,048 131,376 A-P 49,049 37,294 Payables Turnover =COGS/AP 2.875654957 3.522711428 Days Sales in Payables Payables Turn over 2.875654957 3.522711428 Days Sales in Paybles = 365/Payables Turn Over 126.9276062 103.6133693 Asset Turnover Assets Sales $229,234 $215,639 Total Assets 375,319 321,686 Asset Turnover = Sales/Total Assets 0.61 0.67 Profitablility Measures Net Income $48,351 $45,687 Sales $229,234 $215,639 Net Profit Margin = NI / Sales 21.09% 21.19% Operating Income 61,344 60,024 Sales $229,234 $215,639 Operating Margin = Operating Income/ Sales $0.27 $0.28 Operating Ratios Net Income $48,351 $45,687 Total Assets 375,319 321,686 Return on Assets (ROA) = NI / TA 13% 14% (NOTE: The book calculates this ratio as (Net Income + Interest Expense)/Total Assets , While others in industry calculate it as NI/TA) Net Income $48,351 $45,687 Total Book Value Equity 134,047 128,249 Return on Equity (ROE) = NI / TE 36% 36% EBIT 61,344 60,024 Tax Rate 25% 25% Book Value of Equity 134,047 128,249 Net Debt 241,272 193,437 Return on Invested Capital (ROIC) = EBIT(1-Tax Rate)/(Book Value of Equity +Net Debt) 0.122583722 0.13994392 46008 45,018 Valuation Ratios (For debt, include long-term and short-term debt; for cash, include marketable securities.)

Share Price = PPS Shares outstanding (million)= 4,882,167 Market Vaue = PPS * Shares Outstanding Not sure how to find the price per share for Apple Inc. caculated all other ratios stuck on PPS

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

Economics Of Money Banking And Financial Markets

Authors: Frederic Mishkin

10th Global Edition

0273765736, 978-0273765738

More Books

Students also viewed these Finance questions