Question

Perform a horizontal analysis of the Balance Sheet.

Fiscal year ends in June. USD in millions except per share data.
	2016-06	2017-06	2018-06
Assets	193,694	241,086	258,848
Current assets	139,660	159,851	169,662
Cash	113,240	132,981	133,768
Cash and cash equivalents	6,510	7,663	11,946
Short-term investments	106,730	125,318	121,822
Total cash	113,240	132,981	133,768
Receivables	18,277	19,792	26,481
Inventories	2,251	2,181	2,662
Deferred income taxes
Other current assets	5,892	4,897	6,751
Total current assets	139,660	159,851	169,662
Non-current assets
Property, plant and equipment
Gross property, plant and equipment	38,156	47,913	58,683
Accumulated Depreciation	-19,800	-24,179	-29,223
Net property, plant and equipment	18,356	23,734	29,460
Equity and other investments	10,431	6,023	1,862
Goodwill	17,872	35,122	35,683
Intangible assets	3,733	10,106	8,053
Other long-term assets	3,642	6,250	14,128
Total non-current assets	54,034	81,235	89,186
Total assets	193,694	241,086	258,848
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt	12,904	10,121	3,998
Accounts payable	6,898	7,390	8,617
Taxes payable	580	718	2,121
Deferred revenues	27,468	34,102	28,905
Other current liabilities	11,507	12,196	14,847
Total current liabilities	59,357	64,527	58,488
Non-current liabilities
Long-term debt	40,783	76,073	72,242
Deferred taxes liabilities	1,476	531	541
Deferred revenues	6,441	10,377	3,815
Other long-term liabilities	13,640	17,184	41,044
Total non-current liabilities	62,340	104,165	117,642
Total liabilities	121,697	168,692	176,130
Stockholders' equity
Common stock	68,178	69,315	71,223
Retained earnings	2,282	2,648	13,682
Accumulated other comprehensive income	1,537	431	-2,187
Total stockholders' equity	71,997	72,394	82,718
Total liabilities and stockholders' equity	193,694	241,086	258,848

Answer 1

(Current Year - Previous Year)/ Previous Year

	Increase/(Decrease)
	2017-06	2017-06	2018-06	2018-06
Assets	47392.00	24.47%	17762.00	7.37%
Current assets	20191.00	14.46%	9811.00	6.14%
Cash	19741.00	17.43%	787.00	0.59%
Cash and cash equivalents	1153.00	17.71%	4283.00	55.89%
Short-term investments	18588.00	17.42%	-3496.00	-2.79%
Total cash	19741.00	17.43%	787.00	0.59%
Receivables	1515.00	8.29%	6689.00	33.80%
Inventories	-70.00	-3.11%	481.00	22.05%
Deferred income taxes
Other current assets	-995.00	-16.89%	1854.00	37.86%
Total current assets	20191.00	14.46%	9811.00	6.14%
Non-current assets
Property, plant and equipment
Gross property, plant and equipment	9757.00	25.57%	10770.00	22.48%
Accumulated Depreciation	-4379.00	22.12%	-5044.00	20.86%
Net property, plant and equipment	5378.00	29.30%	5726.00	24.13%
Equity and other investments	-4408.00	-42.26%	-4161.00	-69.09%
Goodwill	17250.00	96.52%	561.00	1.60%
Intangible assets	6373.00	170.72%	-2053.00	-20.31%
Other long-term assets	2608.00	71.61%	7878.00	126.05%
Total non-current assets	27201.00	50.34%	7951.00	9.79%
Total assets	47392.00	24.47%	17762.00	7.37%
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt	-2783.00	-21.57%	-6123.00	-60.50%
Accounts payable	492.00	7.13%	1227.00	16.60%
Taxes payable	138.00	23.79%	1403.00	195.40%
Deferred revenues	6634.00	24.15%	-5197.00	-15.24%
Other current liabilities	689.00	5.99%	2651.00	21.74%
Total current liabilities	5170.00	8.71%	-6039.00	-9.36%
Non-current liabilities
Long-term debt	35290.00	86.53%	-3831.00	-5.04%
Deferred taxes liabilities	-945.00	-64.02%	10.00	1.88%
Deferred revenues	3936.00	61.11%	-6562.00	-63.24%
Other long-term liabilities	3544.00	25.98%	23860.00	138.85%
Total non-current liabilities	41825.00	67.09%	13477.00	12.94%
Total liabilities	46995.00	38.62%	7438.00	4.41%
Stockholders' equity
Common stock	1137.00	1.67%	1908.00	2.75%
Retained earnings	366.00	16.04%	11034.00	416.69%
Accumulated other comprehensive income	-1106.00	-71.96%	-2618.00	-607.42%
Total stockholders' equity	397.00	0.55%	10324.00	14.26%
Total liabilities and stockholders' equity	47392.00	24.47%	17762.00	7.37%