Question
In: Accounting
Hypothetical balance sheets of Nike, Inc. are presented here.
Hypothetical balance sheets of Nike, Inc. are presented here.
(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, es -55,000, -20% or (55,000). (20%). Round percentages to 1 decimal place, es. 12.5%)
b) Prepare a vertical analysis of the balance sheet data for Nike for 2022 NIKE
Solutions
Expert Solution
horizontal analysis
| Particulars | 2022 (a) | 2021 (b) |
Increase/Decrease (a)-(b) = (c) |
Percentage change % (c ) / (b) x 100 |
| Current Assets | 9770 | 8770 | 1000 | 11.40 |
| Property Plant Equipment | 1820 | 1800 | 20 | 1.11 |
| other assets | 1600 | 1740 | (140) | (8.04) |
| Total Assets | 13190 | 12310 | 880 | 7.14 |
| Liabilities & Stockholders | ||||
| Current Liabilities | 3262 | 3340 | (78) | (2.33) |
| Long term Liabilities | 1274 | 1380 | (106) | (7.68) |
| Stockholders equity | 8654 | 7590 | 1064 | 14.01 |
| Total Liabilities & Stockholders | 13190 | 12310 | 880 | 7.14 |
Vertical Analysis
| Particulars | 2022 | Percent | Calculation |
| Current Assets | 9770 | 74.07 | 9770 / 13190 x 100 |
| Property Plant Equipment | 1820 | 13.80 | 1820 / 13190 x 100 |
| other assets | 1600 | 12.13 | 1600 / 13190 x 100 |
| Total Assets | 13190 | ||
| Liabilities & Stockholders | |||
| Current Liabilities | 3262 | 24.72 | 3262 / 13190 x 100 |
| Long term Liabilities | 1274 | 9.66 | 1274 / 13190 x 100 |
| Stockholders equity | 8654 | 65.62 | 8654 / 13190 x 100 |
| Total Liabilities & Stockholders | 13190 |
ekkarill92 answered 2 years agoRelated Solutions
Hypothetical balance sheets of Nike, Inc. are presented here.
Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) (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, eg. 12.5%.) NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) (b) Prepare a vertical analysis of the balance sheet data for Nike for...
Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31...
Hypothetical balance sheets of Nike, Inc. are
presented here.
NIKE, INC.
Condensed Balance Sheet
May 31
($ in millions)
2022
2021
Assets
Current Assets
$9,670
$8,740
Property, plant, and equipment (net)
1,900
1,850
Other assets
1,590
1,690
Total assets
$13,160
$12,280
Liabilities and Stockholders' Equity
Current Liabilities
$3,200
$3,320
Long-term liabilities
1,270
1,320
Stockholders’ equity
8,690
7,640
Total liabilities and stockholders' equity
$13,160
$12,280
(a) Prepare a horizontal analysis of the
balance sheet data for Nike, using 2021 as a...
Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31...
Hypothetical balance sheets of Nike, Inc. are
presented here.
NIKE, INC.
Condensed Balance Sheet
May 31
($ in millions)
2022
2021
Assets
Current Assets
$9,500
$8,880
Property, plant, and equipment (net)
1,950
1,830
Other assets
1,530
1,640
Total assets
$12,980
$12,350
Liabilities and Stockholders' Equity
Current Liabilities
$3,200
$3,300
Long-term liabilities
1,250
1,270
Stockholders’ equity
8,530
7,780
Total liabilities and stockholders' equity
$12,980
$12,350
(a) Prepare a horizontal analysis of the balance
sheet data for Nike, using 2021 as a...
Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31...
Hypothetical balance sheets of Nike, Inc. are
presented here.
NIKE, INC.
Condensed Balance Sheet
May 31
($ in millions)
2022
2021
Assets
Current Assets
$9,800
$8,760
Property, plant, and equipment (net)
1,970
1,800
Other assets
1,550
1,770
Total assets
$13,320
$12,330
Liabilities and Stockholders' Equity
Current Liabilities
$3,294
$3,320
Long-term liabilities
1,287
1,350
Stockholders’ equity
8,739
7,660
Total liabilities and stockholders' equity
$13,320
$12,330
(a) Prepare a horizontal analysis of the balance
sheet data for Nike, using 2021 as a...
Exercise 13-05 Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet...
Exercise 13-05 Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) (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) (b) Prepare a vertical analysis of the balance sheet data for...
Suppose the comparative balance sheets of Nike, Inc. are presented here. Nike, Inc. Comparative Balance Sheets...
Suppose the comparative balance sheets of Nike,
Inc. are presented here.
Nike, Inc.
Comparative Balance Sheets
May 31
($ in millions)
2020
2019
Assets
Current assets
$ 9,379
$ 8,300
Property, plant, and equipment (net)
1,836
1,700
Other assets
1,536
1,600
Total assets
$12,751
$11,600
Liabilities and Stockholders’ Equity
Current liabilities
$ 3,267
$ 3,300
Long-term liabilities
1,358
1,400
Stockholders’ equity
8,126
6,900
Total liabilities and stockholders’ equity
$12,751
$11,600
(a)
Prepare a horizontal analysis of the balance sheet data...
Hypothetical balance sheets of Nike, Inc. are presented here. Please show how to do the equations....
Hypothetical balance sheets of Nike, Inc. are
presented here. Please show how to do the equations. Thank you.
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
(a) Prepare a horizontal analysis of the...
Suppose the comparative balance sheets of Nike, Inc. are presented here.
Suppose the comparative balance sheets of Nike, Inc. are presented here. Nike, Inc. Comparative Balance Sheets May 31 ($ in millions) (a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2019 as a base. (Show the amount of increase or decrease as well.) (Enter amounts in millions. Enter negative amounts and percentages using either a negative sign preceding the number e.g. -45, -45% or parentheses e.g. (45), (45%). Round percentages to 1 decimal place, e.g. 12.3%.) (b) Prepare a vertical analysis of the balance...
Suppose the comparative balance sheets of Nike, Inc. are presented here. Nike, Inc. Condensed Balance Sheet...
Suppose the comparative balance sheets of Nike,
Inc. are presented here.
Nike, Inc.
Condensed Balance Sheet
May 31
($ in millions)
2020
2019
Assets
Current Assets
$9,600
$8,830
Property, plant, and equipment (net)
2,000
1,900
Other assets
1,500
1,700
Total assets
$13,100
$12,430
Liabilities and Stockholders' Equity
Current Liabilities
$3,240
$3,320
Long-term liabilities
1,200
1,340
Stockholders’ equity
8,660
7,770
Total liabilities and stockholders' equity
$13,100
$12,430
(a) Prepare a horizontal analysis of the balance
sheet data for Nike, using 2019...
Suppose the comparative balance sheets of Skysong, Inc. are presented here. SKYSONG, INC. Condensed Balance Sheet...
Suppose the comparative balance sheets of Skysong, Inc. are
presented here. SKYSONG, INC. Condensed Balance Sheet May 31 ($ in
millions) 2017 2016 Assets Current Assets $9,550 $8,900 Property,
plant, and equipment (net) 2,050 1,850 Other assets 1,480 1,730
Total assets $13,080 $12,480 Liabilities and Stockholders' Equity
Current Liabilities $3,230 $3,330 Long-term liabilities 1,270 1,300
Stockholders’ equity 8,580 7,850 Total liabilities and
stockholders' equity $13,080 $12,480 (a) Prepare a horizontal
analysis of the balance sheet data for Skysong, using 2016...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
- X Company is considering the purchase of a new processor that costs $200,000. Shipping and setup...
- There are a large number of tasks involved in information technology and programming, and many of...
ADVERTISEMENT