Prepare a horizontal analysis of the balance sheet

Question

Suppose the comparative balance sheets of Nike, Inc. are presented here.

NIKE, INC. Condensed Balance Sheet May 31 ($ in millions)
		2014		2013
Assets
Current Assets		$9,595		$8,697
Property, plant, and equipment (net)		1,861		1,790
Other assets		1,498		1,643
Total assets		$12,954		$12,130
Liabilities and Stockholders' Equity
Current Liabilities		$3,265		$3,304
Long-term liabilities		1,338		1,351
Stockholders' equity		8,351		7,475
Total liabilities and stockholders' equity		$12,954		$12,130

(a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2013 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.1%.)

NIKE, INC. Condensed Balance Sheet May 31 ($ in millions)
		2014		2013		Increase (Decrease)		Percentage Change from 2013
Assets
Current Assets		$9,595		$8,697		$			%
Property, plant, and equipment (net)		1,861		1,790					%
Other assets		1,498		1,643					%
Total assets		$12,954		$12,130		$			%
Liabilities and Stockholders' Equity
Current Liabilities		$3,265		$3,304		$			%
Long-term liabilities		1,338		1,351					%
Stockholders' equity		8,351		7,475					%
Total liabilities and stockholders' equity		$12,954		$12,130		$			%

(b) Prepare a vertical analysis of the balance sheet data for Nike for 2014.

NIKE, INC. Condensed Balance Sheet May 31, 2014
		$ (in millions)		Percent
Assets
Current Assets		$9,595			%
Property, plant, and equipment (net)		1,861			%
Other assets		1,498			%
Total assets		$12,954			%
Liabilities and Stockholders' Equity
Current Liabilities		$3,265			%
Long-term Liabilities		1,338			%
Stockholders' equity		8,351			%
Total liabilities and stockholders' equity		$12,954			%