• Home
  • Blog
  • Horizontal and Vertical Analysis Ratio Analysis

Horizontal and Vertical Analysis Ratio Analysis

0 comments

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 2021

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 period

$ (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

%

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}