Question

The following summarized data (amounts in millions) are taken from the September 30, 2017, and September 24, 2016, comparative financial statements of Apple Inc., a company that designs, manufactures, and markets mobile communication and media devices and personal computers, sells a variety of related software, services, accessories, networking solutions, and offers third-party digital content and applications: 2017 $ 229, 234 114,048 61,344 $ 48,351 2016 $ 215,639 131,376 60,024 $ 45,687 (Amounts Expressed in Millions) For the Fiscal Years Ended September 30 and September 24, respectively: Net sales Costs of sales Operating income Net income At Year End: Assets Current assets: Cash and cash equivalents Short-term marketable securities Accounts receivable, less allowance of $58 and $53, respectively Inventories Vendor nontrade receivables Other current assets Total current assets Long-term marketable securities Property, plant, and equipment, net Goodwill Acquired intangible assets, net Other assets Total assets Liabilities and Shareholders' Equity Current liabilities: Accounts payable Accrued expenses Deferred revenue Commercial paper Current portion of long-term debt Total current liabilities Deferred revenue-noncurrent Long-term debt Other noncurrent liabilities Total liabilities 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 Retained earnings Accumulated other comprehensive income (loss) Total shareholders' equity Total liabilities and shareholders' equity $ 20,289 53,892 17,874 4,855 17,799 13,936 128,645 194,714 33,783 5,717 2,298 10,162 $ 375,319 $ 20,484 46,671 15,754 2,132 13,545 8,283 106,869 170,430 27,010 5,414 3,206 8,757 $ 321,686 $ $ 49,049 25,744 7,548 11,977 6,496 100,814 2,836 97,207 40,415 241, 272 37,294 22,027 8,080 8,105 3,500 79,006 2,930 75,427 36,074 193,437 35,867 98,330 (150) 134,047 $ 375,319 31, 251 96,364 634 128, 249 $ 321,686

At September 26, 2015, total assets were $290,345 and total shareholders’ equity was $119,355.

Required:

1. Calculate Apple Inc.’s working capital, current ratio, and acid-test ratio at September 30, 2017, and September 24, 2016.
2. Calculate Apple’s ROE for the years ended September 30, 2017, and September 24, 2016.
3. Calculate Apple’s ROI, showing margin and turnover, for the years ended September 30, 2017, and September 24, 2016.

Answer 1

		Sept 30, 2017	Sept 24, 2016
Part 1	Working Capital =Current Assets - Current Liabilities
	Working Capital =$128,645 - $100,814	$27,831
	Working Capital =$106,869 - $79,006		$27,863
	Current Ratio =Current Assets / Current Liabilities
	Current Ratio =$128,645 / $100,814	1.28
	Current Ratio =$106,869 / $79,006		1.35
	Acid-test Ratio =[(Current Assets - Inventories - Prepaid expenses)/Current laibilities]
	Acid-test Ratio =[($128,645 - $4,855)/$100,814]	1.23
	Acid-test Ratio =[($106,869 - $2,132)/$79,006]		1.33
Part 2	ROE =Net Income / Average shareholders equity
	Average shareholders equity =(Opening Shareholders equity + Closing Shareholders equity) / 2
	ROE =$48,351 / [($128,249 + $134,047)/2] =$48,351 / $131,148	36.87%
	ROE =$45,687 / [($119,355 + $128,249)/2] =$45,684 / $123,802		36.90%
Part 3	Margin =Net income / Net Sales
	Turnover =Net sales / Average Operating Assets
	ROI =Margin*Turnover
	Margin =$48,351 / $229,234	21.09%
	Margin =$45,684 / $215,639		21.19%
	Turnover =$229,234 / [($321,686 + $375,319) /2]	0.6578
	Turnover =$215,639 / [($290,345 + $321,686) /2]		0.7047
	ROI	13.87%	14.93%