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 ago

Next > < Previous

Related 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...

Presented here are the comparative balance sheets of Hames Inc. at December 31, 2020 and 2019....

Presented here are the comparative balance sheets of Hames Inc. at December 31, 2020 and 2019. Sales for the year ended December 31, 2020, totaled $1,700,000. HAMES INC. Balance Sheets December 31, 2020 and 2019 2020 2019 Assets Cash $ 63,000 $ 57,000 Accounts receivable 285,000 266,000 Merchandise inventory 261,000 247,000 Total current assets $ 609,000 $ 570,000 Land 109,000 82,000 Plant and equipment 375,000 330,000 Less: Accumulated depreciation (195,000 ) (180,000 ) Total assets $ 898,000 $ 802,000 Liabilities...

Subjects