Week 10 Project Current Attempt in Progress
Exercise 13-05
Hypothetical balance sheets of Nike, Inc. are presented here.
NIKE, INC. Condensed Balance Sheet May 31 ($ in millions)
2022
2021
Assets
Current Assets
$9,770
$8,770
Property, plant, and equipment (net)
1,820
1,800
Other assets
1,600
1,740
Total assets
$13,190
$12,310
Liabilities and Stockholders’ Equity
Current Liabilities
$3,262
$3,340
Long-term liabilities
1,274
1,380
Stockholders’ equity
8,654
7,590
Total liabilities and stockholders’ equity
$13,190
$12,310
(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,770
$8,770
$enter a dollar amount
enter percentages rounded to 1 decimal place rounded to 1 decimal place
%
Property, plant, and equipment (net)
1,820
1,800
enter a dollar amount
enter percentages rounded to 1 decimal place rounded to 1 decimal place
%
Other assets
1,600
1,740
enter a dollar amount
enter percentages rounded to 1 decimal place rounded to 1 decimal place
%
Total assets
$13,190
$12,310
$enter a dollar amount
enter percentages rounded to 1 decimal place rounded to 1 decimal place
%
Liabilities and Stockholders’ Equity
Current Liabilities
$3,262
$3,340
$enter a dollar amount
enter percentages rounded to 1 decimal place rounded to 1 decimal place
%
Long-term liabilities
1,274
1,380
enter a dollar amount
enter percentages rounded to 1 decimal place rounded to 1 decimal place
%
Stockholders’ equity
8,654
7,590
enter a dollar amount
enter percentages rounded to 1 decimal place rounded to 1 decimal place
%
Total liabilities and stockholders’ equity
$13,190
$12,310
$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,770
enter percentages rounded to 1 decimal place
%
Property, plant, and equipment (net)
1,820
enter percentages rounded to 1 decimal place
%
Other assets
1,600
enter percentages rounded to 1 decimal place
%
Total assets
$13,190
enter percentages rounded to 1 decimal place
%
Liabilities and Stockholders’ Equity
Current Liabilities
$3,262
enter percentages rounded to 1 decimal place
%
Long-term Liabilities
1,274
enter percentages rounded to 1 decimal place
%
Stockholders’ equity
8,654
enter percentages rounded to 1 decimal place
%
Total liabilities and stockholders’ equity
$13,190
enter percentages rounded to 1 decimal place
