Question Description
I need help with a Management question. All explanations and answers will be used to help me learn.
Current Attempt in Progress
undefined
Hypothetical balance sheets of Nike, Inc. are presented here.
undefined
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
undefined
(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%.)
undefined
NIKE, INC.
Condensed Balance Sheet
May 31
($ in millions)
2022
2021
Increase
(Decrease)
Percentage
Change
from 2021
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
%
undefined
(b) Prepare a vertical analysis of the balance sheet data for Nike for 2022.
undefined
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,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
%
undefined