Week 10 project
hlove23
week10project.docxCurrent 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 |
|
