1.Using the report calculate the key financial ratios of all the years provided in the balance sheet, that is below the questions:

-Debt To Equity Ratio

-Current Ratio

-Quick Ratio

-Return On Equity

-Net Profit Margin

.

2.Find the industry averages and compare to the calculations in the above question.

.

.

.

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

..Below Is the infromation for question 2.

Microsoft
Recommendations And Estimates
	Company	Industry	SP500
Average Recommendation (1=Buy, 5=Sell)	1.71	2.02	9.99
Current Quarter Estimate	0.68	11.22	30.75
Year Ago Quarter Estimate	0.67	8.66	26.14
Next Quarter Estimate	0.77	13.45	30.75
Next Year Estimate	3.23	10.6	25.44
Growth Rates
	Company	Industry	SP500
This Year (3.6)	3.6	8	17.9
Next Year (11.8)	11.8	19.1	8.4
Last 5 Years	2.2	9.4	4.9
Next 5 Years	7.7	14.7	NA
Financials
	Company	Industry
Price/Earnings (TTM)	21	61.99
Price/Book (MRQ)	6.27	3.85
Price/Cash Flow (MRFY)	15.3	18.17
Dividend Yield	2.48%	0.00%
Net Profit Margin (TTM)	19.33%	10.03%
Return on Equity (TTM)	29.38%	11.82%
Debt to Equity (MRQ)	0.57	18.8
MRQ = Most Recent Quarter
TTM = Trailing Twelve Months
MRFY = Most Recent Fiscal Year
Apple
Recommendations And Estimates
	Company	Industry	SP500
Average Recommendation (1=Buy, 5=Sell)	1.47	2.09	9.99
Current Quarter Estimate	1.64	9.87	30.75
Year Ago Quarter Estimate	1.96	11.23	26.14
Next Quarter Estimate	3.01	17.26	30.75
Next Year Estimate	8.89	19.39	25.44
Growth Rates
	Company	Industry	SP500
This Year (-10.4)	-10.4	-14.6	17.9
Next Year (7.6)	7.6	14.3	8.4
Last 5 Years	29.5	0.6	4.9
Next 5 Years	8.7	12.4	NA
Financials
	Company	Industry
Price/Earnings (TTM)	12.56	46.8
Price/Book (MRQ)	4.58	2.38
Price/Cash Flow (MRFY)	9.48	10.48
Dividend Yield	2.12%	2.86%
Net Profit Margin (TTM)	21.70%	13.12%
Return on Equity (TTM)	37.89%	39.15%
Debt to Equity (MRQ)	0.54	35.27
MRQ = Most Recent Quarter
TTM = Trailing Twelve Months
MRFY = Most Recent Fiscal Year
Oracle corp
Recommendations And Estimates
	Company	Industry	SP500
Average Recommendation (1=Buy, 5=Sell)	1.96	2.02	9.99
Current Quarter Estimate	0.54	11.22	30.75
Year Ago Quarter Estimate	0.49	8.66	26.14
Next Quarter Estimate	0.62	13.45	30.75
Next Year Estimate	2.85	10.6	25.44
Growth Rates
	Company	Industry	SP500
This Year (7.2)	7.2	8	17.9
Next Year (9.3)	9.3	19.1	8.4
Last 5 Years	3.7	9.4	4.9
Next 5 Years	9.2	14.7	NA
Financials
	Company	Industry
Price/Earnings (TTM)	16.93	61.99
Price/Book (MRQ)	3.57	3.85
Price/Cash Flow (MRFY)	13.09	18.17
Dividend Yield	1.46%	0.00%
Net Profit Margin (TTM)	24.02%	10.03%
Return on Equity (TTM)	22.32%	11.82%
Debt to Equity (MRQ)	0.84	18.8
MRQ = Most Recent Quarter
TTM = Trailing Twelve Months
MRFY = Most Recent Fiscal Year