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

Current Attempt in Progress

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

NIKE, INC.
Condensed Balance Sheet
May 31
($ in millions)
2022 2021
Assets
Current Assets $9,520 $8,800
Property, plant, and equipment (net) 1,990 1,810
Other assets 1,590 1,610
Total assets $13,100 $12,220
Liabilities and Stockholders’ Equity
Current Liabilities $3,220 $3,380
Long-term liabilities 1,260 1,340
Stockholders’ equity 8,620 7,500
Total liabilities and stockholders’ equity $13,100 $12,220

(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,520 $8,800 $enter a dollar amount enter percentages rounded to 1 decimal place rounded to 1 decimal place %
Property, plant, and equipment (net) 1,990 1,810 enter a dollar amount enter percentages rounded to 1 decimal place rounded to 1 decimal place %
Other assets 1,590 1,610 enter a dollar amount enter percentages rounded to 1 decimal place rounded to 1 decimal place %
Total assets $13,100 $12,220 $enter a dollar amount enter percentages rounded to 1 decimal place rounded to 1 decimal place %
Liabilities and Stockholders’ Equity
Current Liabilities $3,220 $3,380 $enter a dollar amount enter percentages rounded to 1 decimal place rounded to 1 decimal place %
Long-term liabilities 1,260 1,340 enter a dollar amount enter percentages rounded to 1 decimal place rounded to 1 decimal place %
Stockholders’ equity 8,620 7,500 enter a dollar amount enter percentages rounded to 1 decimal place rounded to 1 decimal place %
Total liabilities and stockholders’ equity $13,100 $12,220 $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, 2022 For the Month Ended May 31, 2022
$ (in millions) Percent
Assets
Current Assets $9,520 enter percentages rounded to 1 decimal place %
Property, plant, and equipment (net) 1,990 enter percentages rounded to 1 decimal place %
Other assets 1,590 enter percentages rounded to 1 decimal place %

Total assets $13,100 enter percentages rounded to 1 decimal place %

Liabilities and Stockholders’ Equity
Current Liabilities $3,220 enter percentages rounded to 1 decimal place %
Long-term Liabilities 1,260 enter percentages rounded to 1 decimal place %
Stockholders’ equity 8,620 enter percentages rounded to 1 decimal place %

Total liabilities and stockholders’ equity $13,100 enter percentages rounded to 1 decimal place %

Last Completed Projects