Question

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

NIKE, INC. Condensed Balance Sheet May 31 ($ in millions)
		2022		2021
Assets
Current Assets		$9,600		$8,730
Property, plant, and equipment (net)		1,910		1,830
Other assets		1,470		1,620
Total assets		$12,980		$12,180
Liabilities and Stockholders' Equity
Current Liabilities		$3,210		$3,370
Long-term liabilities		1,254		1,330
Stockholders’ equity		8,516		7,480
Total liabilities and stockholders' equity		$12,980		$12,180

(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 2021
Assets
Current Assets		$9,600		$8,730		$enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Property, plant, and equipment (net)		1,910		1,830		enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Other assets		1,470		1,620		enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Total assets		$12,980		$12,180		$enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Liabilities and Stockholders' Equity
Current Liabilities		$3,210		$3,370		$enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Long-term liabilities		1,254		1,330		enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Stockholders’ equity		8,516		7,480		enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Total liabilities and stockholders' equity		$12,980		$12,180		$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 period                                                           May 31, 2022For the Year Ended May 31, 2022For the Month Ended May 31, 2022
		$ (in millions)		Percent
Assets
Current Assets		$9,600		enter percentages rounded to 1 decimal place	%
Property, plant, and equipment (net)		1,910		enter percentages rounded to 1 decimal place	%
Other assets		1,470		enter percentages rounded to 1 decimal place	%
Total assets		$12,980		enter percentages rounded to 1 decimal place	%
Liabilities and Stockholders' Equity
Current Liabilities		$3,210		enter percentages rounded to 1 decimal place	%
Long-term Liabilities		1,254		enter percentages rounded to 1 decimal place	%
Stockholders’ equity		8,516		enter percentages rounded to 1 decimal place	%
Total liabilities and stockholders' equity		$12,980		enter percentages rounded to 1 decimal place	%

Answer 1

NIKE, INC. Condensed Balance Sheet For The Year Ended May 31, 2022
	2022	2021
Assets
Current assets	$9,600	74	%	$8,730	71.7	%
Property, plant and equipment (net)	1,910	14.7		1,830	15
Other assets	1,470	11.3		1,620	13.3
Total assets	12,980	100	%	12,180	100	%
Liabilities and Stockholders' Equity
Current liabilities	3,200	24.6		3,370	27.7
Long-term liabilities	1,310	10.1		1,330	10.9
Stockholders' equity	8,470	65.3		7,480	61.4
Total liabilities and stockholders' equity	$12,980	100	%	$12,180	100	%