Pick 5 solvency and 5 profitability ratios and conduct ratio analysis for the current year and the prior year and indicate whether the change in the ratios is favorable or unfavorable. (Include all calculations)

FINANCIAL HIGHLIGHTS

(In millions, except per share data)
Year Ended June 30,	2015	2014 (b)	2013	2012	2011
Revenue	$93,580	$86,833	$77,849	$73,723	$69,943
Gross margin	$60,542	$59,755	$57,464	$56,193	$54,366
Operating income	$18,161 (a)	$27,759	$26,764 (c)	$21,763 (d)	$27,161
Net income	$12,193 (a)	$22,074	$21,863 (c)	$16,978 (d)	$23,150
Diluted earnings per share	$1.48 (a)	$2.63	$2.58 (c)	$2.00 (d)	$2.69
Cash dividends declared per share	$1.24	$1.12	$0.92	$0.80	$0.64
Cash, cash equivalents, and short-term investments	$96,526	$85,709	$77,022	$63,040	$52,772
Total assets	$176,223	$172,384	$142,431	$121,271	$108,704
Long-term obligations	$46,282	$36,975	$26,070	$22,220	$22,847
Stockholders' equity	$80,083	$89,784	$78,944	$66,363	$57,083

BALANCE SHEETS

(In millions)
June 30,	2015		2014
Assets
Current assets:
Cash and cash equivalents	$5,595		$8,669
Short-term investments (including securities loaned of $75 and $541)	90,931		77,040
Total cash, cash equivalents, and short-term investments	96,526		85,709
Accounts receivable, net of allowance for doubtful accounts of $335 and $301	17,908		19,544
Inventories	2,902		2,660
Deferred income taxes	1,915		1,941
Other	5,461		4,392
Total current assets	124,712		114,246
Property and equipment, net of accumulated depreciation of $17,606 and $14,793	14,731		13,011
Equity and other investments	12,053		14,597
Goodwill	16,939		20,127
Intangible assets, net	4,835		6,981
Other long-term assets	2,953		3,422
Total assets	$176,223		$172,384
Liabilities and stockholders equity
Current liabilities:
Accounts payable	$6,591		$7,432
Short-term debt	4,985		2,000
Current portion of long-term debt	2,499		0
Accrued compensation	5,096		4,797
Income taxes	606		782
Short-term unearned revenue	23,223		23,150
Securities lending payable	92		558
Other	6,766		6,906
Total current liabilities	49,858		45,625
Long-term debt	27,808		20,645
Long-term unearned revenue	2,095		2,008
Deferred income taxes	2,835		2,728
Other long-term liabilities	13,544		11,594
Total liabilities	96,140		82,600
Commitments and contingencies
Stockholders equity:
Common stock and paid-in capital shares authorized 24,000; outstanding 8,027 and 8,239	68,465		68,366
Retained earnings	9,096		17,710
Accumulated other comprehensive income	2,522		3,708
Total stockholders equity	80,083		89,784
Total liabilities and stockholders equity	$176,223		$172,384

See accompanying notes.

CASH FLOWS STATEMENTS

(In millions)
Year Ended June 30,	2015		2014		2013
Operations
Net income	$12,193		$22,074		$21,863
Adjustments to reconcile net income to net cash from operations:
Goodwill and asset impairments	7,498		0		0
Depreciation, amortization, and other	5,957		5,212		3,755
Stock-based compensation expense	2,574		2,446		2,406
Net recognized losses (gains) on investments and derivatives	(443)		(109)		80
Excess tax benefits from stock-based compensation	(588)		(271)		(209)
Deferred income taxes	224		(331)		(19)
Deferral of unearned revenue	45,072		44,325		44,253
Recognition of unearned revenue	(44,920)		(41,739)		(41,921)
Changes in operating assets and liabilities:
Accounts receivable	1,456		(1,120)		(1,807)
Inventories	(272)		(161)		(802)
Other current assets	62		(29)		(129)
Other long-term assets	346		(628)		(478)
Accounts payable	(1,054)		473		537
Other current liabilities	(624)		1,075		146
Other long-term liabilities	1,599		1,014		1,158
Net cash from operations	29,080		32,231		28,833
Financing
Proceeds from issuance of short-term debt, maturities of 90 days or less, net	4,481		500		0
Proceeds from issuance of debt	10,680		10,350		4,883
Repayments of debt	(1,500)		(3,888)		(1,346)
Common stock issued	634		607		931
Common stock repurchased	(14,443)		(7,316)		(5,360)
Common stock cash dividends paid	(9,882)		(8,879)		(7,455)
Excess tax benefits from stock-based compensation	588		271		209
Other	362		(39)		(10)
Net cash used in financing	(9,080)		(8,394)		(8,148)
Investing
Additions to property and equipment	(5,944)		(5,485)		(4,257)
Acquisition of companies, net of cash acquired, and purchases of intangible and other assets	(3,723)		(5,937)		(1,584)
Purchases of investments	(98,729)		(72,690)		(75,396)
Maturities of investments	15,013		5,272		5,130
Sales of investments	70,848		60,094		52,464
Securities lending payable	(466)		(87)		(168)
Net cash used in investing	(23,001)		(18,833)		(23,811)
Effect of exchange rates on cash and cash equivalents	(73)		(139)		(8)
Net change in cash and cash equivalents	(3,074)		4,865		(3,134)
Cash and cash equivalents, beginning of period	8,669		3,804		6,938
Cash and cash equivalents, end of period	$5,595		$8,669		$3,804

See accompanying notes.

STOCKHOLDERS EQUITY STATEMENTS

(In millions)
Year Ended June 30,	2015		2014		2013
Common stock and paid-in capital
Balance, beginning of period	$68,366		$67,306		$65,797
Common stock issued	634		607		920
Common stock repurchased	(3,700)		(2,328)		(2,014)
Stock-based compensation expense	2,574		2,446		2,406
Stock-based compensation income tax benefits	588		272		190
Other, net	3		63		7
Balance, end of period	68,465		68,366		67,306
Retained earnings
Balance, beginning of period	17,710		9,895		(856)
Net income	12,193		22,074		21,863
Common stock cash dividends	(10,063)		(9,271)		(7,694)
Common stock repurchased	(10,744)		(4,988)		(3,418)
Balance, end of period	9,096		17,710		9,895
Accumulated other comprehensive income
Balance, beginning of period	3,708		1,743		1,422
Other comprehensive income (loss)	(1,186)		1,965		321
Balance, end of period	2,522		3,708		1,743
Total stockholders equity	$80,083		$89,784		$78,944

See accompanying notes.