Current Attempt in Progress

Hypothetical balance sheets ofNike, Inc.are presented here.

NIKE, INC.

Condensed Balance Sheet

May 31

($ in millions)

2022

2021

Assets

Current Assets

$9,800

$8,720

Property, plant, and equipment (net)

1,910

1,820

Other assets

1,540

1,670

Total assets

$13,250

$12,210

Liabilities and Stockholders' Equity

Current Liabilities

$3,277

$3,370

Long-term liabilities

1,280

1,310

Stockholders' equity

8,693

7,530

Total liabilities and stockholders' equity

$13,250

$12,210

(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,800

$8,720

$

enter a dollar amount

enter percentages rounded to 1 decimal place rounded to 1 decimal place

%

Property, plant, and equipment (net)

1,910

1,820

enter a dollar amount

enter percentages rounded to 1 decimal place rounded to 1 decimal place

%

Other assets

1,540

1,670

enter a dollar amount

enter percentages rounded to 1 decimal place rounded to 1 decimal place

%

Total assets

$13,250

$12,210

$

enter a dollar amount

enter percentages rounded to 1 decimal place rounded to 1 decimal place

%

Liabilities and Stockholders' Equity

Current Liabilities

$3,277

$3,370

$

enter a dollar amount

enter percentages rounded to 1 decimal place rounded to 1 decimal place

%

Long-term liabilities

1,280

1,310

enter a dollar amount

enter percentages rounded to 1 decimal place rounded to 1 decimal place

%

Stockholders' equity

8,693

7,530

enter a dollar amount

enter percentages rounded to 1 decimal place rounded to 1 decimal place

%

Total liabilities and stockholders' equity

$13,250

$12,210

$

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, 2022

For the Year Ended May 31, 2022

For the Month Ended May 31, 2022

$ (in millions)

Percent

Assets

Current Assets

$9,800

enter percentages rounded to 1 decimal place

%

Property, plant, and equipment (net)

1,910

enter percentages rounded to 1 decimal place

%

Other assets

1,540

enter percentages rounded to 1 decimal place

%

Total assets

$13,250

enter percentages rounded to 1 decimal place

%

Liabilities and Stockholders' Equity

Current Liabilities

$3,277

enter percentages rounded to 1 decimal place

%

Long-term Liabilities

1,280

enter percentages rounded to 1 decimal place

%

Stockholders' equity

8,693

enter percentages rounded to 1 decimal place

%

Total liabilities and stockholders' equity

$13,250

enter percentages rounded to 1 decimal place

%