Provide common size analysis of your companys income statement and balance sheet for two most recent years. My company is Apple Inc. Must be done using excel with formula.

Income Statement

Years ended

September 26, 2015

September 27, 2014

September 28, 2013

Net sales

$233,715.00

$182,795.00

$170,910.00

Cost of sales

140,089

112,258

106,606

Gross margin

93,626

70,537

64,304

Operating expenses:

Research and development

8,067

6,041

4,475

Selling, general and administrative

14,329

11,993

10,830

Total operating expenses

22,396

18,034

15,305

Operating income

71,230

52,503

48,999

Other income/(expense), net

1,285

980

1,156

Income before provision for income taxes

72,515

53,483

50,155

Provision for income taxes

19,121

13,973

13,118

Net income

$53,394.00

$39,510.00

$37,037.00

Earnings per share:

Basic

$9.28

$6.49

$5.72

Diluted

$9.22

$6.45

$5.68

Shares used in computing earnings per share:

Basic

5,753,421

6,085,572

6,477,320

Diluted

5,793,069

6,122,663

6,521,634

Cash dividends declared per share

lalance Sheet

Balance Sheet
	September 26, 2015			September 27, 2014
ASSETS:
Current assets:
Cash and cash equivalents		$21,120.00			$13,844.00
Short-termmarketable securities		20,481			11,233
Accounts receivable, less allowances of $82 and $86, respectively		16,849			17,460
Inventories		2,349			2,111
Deferred tax assets		5,546			4,318
Vendor non-trade receivables		13,494			9,759
Other current assets		9,539			9,806
Total current assets		89,378			68,531
Long-term marketable securities		164,065			130,162
Property, plant and equipment, net		22,471			20,624
Goodwill		5,116			4,616
Acquired intangible assets, net		3,893			4,142
Other assets		5,556			3,764
Total assets		$290,479.00			$231,839.00
LIABILITIES AND SHAREHOLDERS' EQUITY:
Current liabilities:
Accounts payable		$35,490.00			$30,196.00
Accrued expenses		25,181			18,453
Deferred revenue		8,940			8,491
Commercial paper		8,499			6,308
Current portion of long-term debt		2,500			-
Total current liabilities		80,610			63,448
Deferred revenue, non-current		3,624			3,031
Long-term debt		53,463			28,987
Other non-current liabilities		33,427			24,826
Total liabilities		171,124			120,292
Commitments and contingencies
Shareholders' equity:
Common stock and additional paid-in capital, $0.00001 par value: 12,600,000 shares authorized; 5,578,753 and 5,866,161 shares issued and outstanding, respectively		27,416			23,313
Retained earnings		92,284			87,152
Accumulated other comprehensive income		($345.00)			1,082
Total shareholders' equity		119,355			111,547
Total liabilities and shareholders' equity		$290,479.00			$231,839.00

$1.98

$1.82

$1.64

Answer rating: 100% (QA)

Formula used 1 Dollar change Amount in Sept 2015 Amount in Sept 2014 2 Percentage change Dollar Change Amount in Sept 2014 A Income Statement YEAR END... View the full answer