Question

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

Nike, Inc. Comparative Balance Sheets May 31 ($ in millions)
		2020		2019
Assets
Current assets		$ 9,379		$ 8,300
Property, plant, and equipment (net)		1,836		1,700
Other assets		1,536		1,600
Total assets		$12,751		$11,600
Liabilities and Stockholders’ Equity
Current liabilities		$ 3,267		$ 3,300
Long-term liabilities		1,358		1,400
Stockholders’ equity		8,126		6,900
Total liabilities and stockholders’ equity		$12,751		$11,600

(a)

Prepare a horizontal analysis of the balance sheet data for Nike, using 2019 as a base. (Show the amount of increase or decrease as well.) (Enter amounts in millions. Enter negative amounts and percentages using either a negative sign preceding the number e.g. -45, -45% or parentheses e.g. (45), (45%). Round percentages to 1 decimal place, e.g. 12.3%.)

NIKE, INC. Condensed Balance Sheet May 31For the Year Ended May 31For the Quarter Ended May 31 ($ in millions)
		2020		2019			Increase (Decrease)		Percentage Change from 2019
Assets
Current assets		$9,379		$8,300			$		%
Property, plant & equipment (net)		1,836		1,700					%
Other assets		1,536		1,600					%
Total Assets		$12,751		$11,600			$		%
Liabilities and Stockholders' Equity
Current liabilities		$3,267		$3,300			$		%
Long-term liabilities		1,358		1,400					%
Stockholders' equity		8,126		6,900					%
Total liabilities and Stockholders' Equity		$12,751		$11,600			$		%

(b)

Prepare a vertical analysis of the balance sheet data for Nike for 2020. (Round percentages to 1 decimal place, e.g. 12.3%.)

NIKE, INC. Condensed Balance Sheet May 31, 2020 For the Quarter Ended May 31, 2020 For the Year Ended May 31, 2020
		$ (in millions)		Percent
Assets
Current assets		$9,379		%
Property, plant, and equipment (net)		1,836		%
Other assets		1,536		%
Total Assets		$12,751		%
Liabilities and Stockholders' Equity
Current liabilities		$3,267		%
Long-term liabilities		1,358		%
Stockholders' equity		8,126		%
Total liabilities and Stockholders' Equity		$12,751		%

Answer 1

• Requirement [a]

Condensed Balance Sheet
at May 31
	2020	2019	Increase (Decrease)	% Change from 2019
ASSETS
Current Assets	$                    9,379.00	$                    8,300.00	$                                         1,079.00	13.0%
Property Plant Equipment	$                    1,836.00	$                    1,700.00	$                                            136.00	8.0%
Other assets	$                    1,536.00	$                    1,600.00	$                                            (64.00)	-4.0%
Total Assets	$                  12,751.00	$                  11,600.00	$                                         1,151.00	9.9%
LIABILITIES & STOCKHOLDERS' EQUITY
Current Liabilities	$                    3,267.00	$                    3,300.00	$                                            (33.00)	-1.0%
Long Term Liabilities	$                    1,358.00	$                    1,400.00	$                                            (42.00)	-3.0%
Stockholder's Equity	$                    8,126.00	$                    6,900.00	$                                         1,226.00	17.8%
Total Liabilities & Stockolder's Equity	$                  12,751.00	$                  11,600.00	$                                         1,151.00	9.9%

• Requirement [b]

At May 31
	Amount	%
ASSETS
Current Assets	$                    9,379.00	73.6%
Property Plant Equipment	$                    1,836.00	14.4%
Other assets	$                    1,536.00	12.0%
Total Assets	$                  12,751.00	100.0%
LIABILITIES & STOCKHOLDERS' EQUITY
Current Liabilities	$                    3,267.00	25.6%
Long Term Liabilities	$                    1,358.00	10.7%
Stockholder's Equity	$                    8,126.00	63.7%
Total Liabilities & Stockolder's Equity	$                  12,751.00	100.0%