provide horizontal analysis of your companys (Apple Inc) income statement and balance sheet showing the dollar amount and percent of change using the two most recent years ( must be done using spreadsheet with formulas

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

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		$1.98		$1.82		$1.64