Perform a horizontal analysis of the Balance Sheet. Fiscal year ends in June. USD in millions...

Free

80.2K

Verified Solution

Question

Accounting

Perform a horizontal analysis of the Balance Sheet.

Fiscal year ends in June. USD in millions except per sharedata.
2016-062017-062018-06
Assets193,694241,086258,848
Current assets139,660159,851169,662
Cash113,240132,981133,768
Cash and cash equivalents6,5107,66311,946
Short-term investments106,730125,318121,822
Total cash113,240132,981133,768
Receivables18,27719,79226,481
Inventories2,2512,1812,662
Deferred income taxes
Other current assets5,8924,8976,751
Total current assets139,660159,851169,662
Non-current assets
Property, plant and equipment
Gross property, plant and equipment38,15647,91358,683
Accumulated Depreciation-19,800-24,179-29,223
Net property, plant and equipment18,35623,73429,460
Equity and other investments10,4316,0231,862
Goodwill17,87235,12235,683
Intangible assets3,73310,1068,053
Other long-term assets3,6426,25014,128
Total non-current assets54,03481,23589,186
Total assets193,694241,086258,848
Liabilitiesand stockholders' equity
Liabilities
Current liabilities
Short-term debt12,90410,1213,998
Accounts payable6,8987,3908,617
Taxes payable5807182,121
Deferred revenues27,46834,10228,905
Other current liabilities11,50712,19614,847
Total current liabilities59,35764,52758,488
Non-current liabilities
Long-term debt40,78376,07372,242
Deferred taxes liabilities1,476531541
Deferred revenues6,44110,3773,815
Other long-term liabilities13,64017,18441,044
Total non-current liabilities62,340104,165117,642
Total liabilities121,697168,692176,130
Stockholders' equity
Common stock68,17869,31571,223
Retained earnings2,2822,64813,682
Accumulated other comprehensive income1,537431-2,187
Total stockholders' equity71,99772,39482,718
Total liabilities and stockholders' equity193,694241,086258,848

Answer & Explanation Solved by verified expert
3.7 Ratings (553 Votes)

(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%

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students