Question

Hypothetical balance sheets of Nike, Inc. are presented here. Please show how to do the equations. Thank you.

NIKE, INC. Condensed Balance Sheet May 31 ($ in millions)
		2022		2021
Assets
Current Assets		$9,600		$8,790
Property, plant, and equipment (net)		1,810		1,800
Other assets		1,580		1,710
Total assets		$12,990		$12,300
Liabilities and Stockholders' Equity
Current Liabilities		$3,170		$3,300
Long-term liabilities		1,230		1,390
Stockholders’ equity		8,590		7,610
Total liabilities and stockholders' equity		$12,990		$12,300

(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,600		$8,790		$enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Property, plant, and equipment (net)		1,810		1,800		enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Other assets		1,580		1,710		enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Total assets		$12,990		$12,300		$enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Liabilities and Stockholders' Equity
Current Liabilities		$3,170		$3,300		$enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Long-term liabilities		1,230		1,390		enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Stockholders’ equity		8,590		7,610		enter a dollar amount		enter percentages rounded to 1 decimal place rounded to 1 decimal place	%
Total liabilities and stockholders' equity		$12,990		$12,300		$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,810		enter percentages rounded to 1 decimal place	%
Other assets		1,580		enter percentages rounded to 1 decimal place	%
Total assets		$12,990		enter percentages rounded to 1 decimal place	%
Liabilities and Stockholders' Equity
Current Liabilities		$3,170		enter percentages rounded to 1 decimal place	%
Long-term Liabilities		1,230		enter percentages rounded to 1 decimal place	%
Stockholders’ equity		8,590		enter percentages rounded to 1 decimal place	%
Total liabilities and stockholders' equity		$12,990		enter percentages rounded to 1 decimal place	%

Answer 1

a
Condensed Balance Sheet
May 31
	2022	2021	Increase(Decrease)	Percentage change
Assets
Current Assets	9600	8790	810	9.2%
Property, plant, and equipment (net)	1810	1800	10	0.6%
Other assets	1580	1710	-130	-7.6%
Total assets	12990	12300	690	5.6%
Liabilities and Stockholders' Equity
Current Liabilities	3170	3300	-130	-3.9%
Long-term liabilities	1230	1390	-160	-11.5%
Stockholders’ equity	8590	7610	980	12.9%
Total liabilities and stockholders' equity	12990	12300	690	5.6%
b
Condensed Balance Sheet
May 31,2022
	$ in millions	Percent
Assets
Current Assets	9600	73.9%
Property, plant, and equipment (net)	1810	13.9%
Other assets	1580	12.2%
Total assets	12990	100.0%
Liabilities and Stockholders' Equity
Current Liabilities	3170	24.4%
Long-term liabilities	1230	9.5%
Stockholders’ equity	8590	66.1%
Total liabilities and stockholders' equity	12990	100.0%