Question

Hypothetical balance sheets of Nike, Inc. are presented here.

NIKE, INC. Condensed Balance Sheet May 31 ($ in millions)
		2022		2021
Assets
Current Assets		$9,710		$8,720
Property, plant, and equipment (net)		1,940		1,870
Other assets		1,500		1,690
Total assets		$13,150		$12,280
Liabilities and Stockholders' Equity
Current Liabilities		$3,253		$3,330
Long-term liabilities		1,270		1,380
Stockholders’ equity		8,627		7,570
Total liabilities and stockholders' equity		$13,150		$12,280

(a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2021 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.5%.)

NIKE, INC. Condensed Balance Sheet May 31 ($ in millions)
		2022		2021		Increase (Decrease)		Percentage Change from 2016
Assets
Current Assets		$9,710		$8,720		$enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Property, plant, and equipment (net)		1,940		1,870		enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Other assets		1,500		1,690		enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Total assets		$13,150		$12,280		$enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Liabilities and Stockholders' Equity
Current Liabilities		$3,253		$3,330		$enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Long-term liabilities		1,270		1,380		enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Stockholders’ equity		8,627		7,570		enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Total liabilities and stockholders' equity		$13,150		$12,280		$enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%

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

NIKE, INC. Condensed Balance Sheet choose the accounting periodMay 31, 2022For the Year Ended May 31, 2022For the Month Ended May 31, 2022 May 31, 2022For the Year Ended May 31, 2022For the Month Ended May 31, 2022
		$ (in millions)		Percent
Assets
Current Assets		$9,710		enter percentages rounded to 1 decimal place	%
Property, plant, and equipment (net)		1,940		enter percentages rounded to 1 decimal place	%
Other assets		1,500		enter percentages rounded to 1 decimal place	%
Total assets		$13,150		enter percentages rounded to 1 decimal place	%
Liabilities and Stockholders' Equity
Current Liabilities		$3,253		enter percentages rounded to 1 decimal place	%
Long-term Liabilities		1,270		enter percentages rounded to 1 decimal place	%
Stockholders’ equity		8,627		enter percentages rounded to 1 decimal place	%
Total liabilities and stockholders' equity		$13,150		enter percentages rounded to 1 decimal place

Answer 1

NIKE, INC. Condensed Balance sheet May. 31. (S in millions) 2022 2021 Increase (Decrease) Percentage Change From 2021 990 70 $ 9,710 S 8.720S $ 1.940S 1.870 S $ 1,500S 1.690 S $ 13,150 $ 12.280 S (190) 11.4% 3.7% -11.2% 7.1% 870 Assets Current assets Property, plant & equipment (net) Other assets Total assets liabilities and stockholders' Equity Current liabilities Long Term liabilities stockholders' equity Total liabilities and stockholders' equity $ 3.253 S 3,330 S S 1,270S 1.380 $ S 8.627 $ 7,570S S 13,150 S 12,280 S (77) (110) 1,057 870 -2.3% -8.0% 14.0% 7.19

b) Percent NIKE, INC. Condensed Balance sheets For the Year Ended May 31,2022 Amount Assets Current assets $ 9,710 Property, plant & equipment (net) $ 1.940 Other Assets $ 1,500 Total assets $ 13,150 liabilities and stockholders' Equity Current liabilities $ 3.253 Long Term liabilities $ 1.270 stockholders' equity S 8.627 Total liabilities and stockholders' equity 1$ 13,150 | 73.8% 14.8% 11.4% 100.0% 24.7% 9.7% 65.6% 100.0%