{"id":9154,"date":"2021-10-18T12:02:08","date_gmt":"2021-10-18T12:02:08","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/project-3-horizontal-and-vertical-analysis\/"},"modified":"2021-10-18T12:02:08","modified_gmt":"2021-10-18T12:02:08","slug":"project-3-horizontal-and-vertical-analysis","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/project-3-horizontal-and-vertical-analysis\/","title":{"rendered":"Project 3: horizontal and vertical analysis"},"content":{"rendered":"
\n

\u00a0Hypothetical balance sheets of Nike, Inc. <\/strong>are presented here. <\/p>\n

NIKE, INC.<\/strong>
Condensed Balance Sheet<\/strong>
May 31<\/strong>
($ in millions)20222021Assets<\/strong>Current Assets$9,580$8,770Property, plant, and equipment (net)1,8101,800Other assets1,5401,670Total assets$12,930$12,240Liabilities and Stockholders’ Equity<\/strong>Current Liabilities$3,150$3,320Long-term liabilities1,3201,370Stockholders\u2019 equity8,4607,550Total liabilities and stockholders’ equity$12,930$12,240<\/p>\n

(a) <\/strong>Prepare a horizontal analysis of the balance sheet data for Nike, using 2021 as a base. (If \u00a0amount and percentage are a decrease show the numbers as negative, e.g. \u00a0-55,000, -20% or (55,000), (20%). Round percentages to 1 decimal place, \u00a0e.g. 12.5%.)<\/strong><\/em><\/p>\n

NIKE, INC.<\/strong>
Condensed Balance Sheet<\/strong>
May 31<\/strong>
($ in millions)20222021Increase<\/strong>
(Decrease)Percentage<\/strong>
Change<\/strong>
from 2021Assets<\/strong>\u00a0\u00a0\u00a0Current Assets$9,580$8,770$enter a dollar amount \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0enter percentages rounded to 1 decimal place rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0%\u00a0\u00a0\u00a0Property, plant, and equipment (net)1,8101,800enter a dollar amount \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0enter percentages rounded to 1 decimal place rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0%\u00a0\u00a0\u00a0Other assets1,5401,670enter a dollar amount \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0enter percentages rounded to 1 decimal place rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0%\u00a0\u00a0\u00a0Total assets$12,930$12,240$enter a dollar amount \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0enter percentages rounded to 1 decimal place rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0%Liabilities and Stockholders’ Equity<\/strong>\u00a0\u00a0\u00a0Current Liabilities$3,150$3,320$enter a dollar amount \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0enter percentages rounded to 1 decimal place rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0%\u00a0\u00a0\u00a0Long-term liabilities1,3201,370enter a dollar amount \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0enter percentages rounded to 1 decimal place rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0%\u00a0\u00a0\u00a0Stockholders\u2019 equity8,4607,550enter a dollar amount \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0enter percentages rounded to 1 decimal place rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0%\u00a0\u00a0\u00a0Total liabilities and stockholders’ equity$12,930$12,240$enter a dollar amount \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0enter percentages rounded to 1 decimal place rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0%<\/p>\n

(b)<\/strong> Prepare a vertical analysis of the balance sheet data for Nike for 2022.<\/p>\n

NIKE, INC.<\/strong>
Condensed Balance Sheet<\/strong>
choose the accounting period \u00a0<\/p>\n

$ (in millions)<\/strong><\/p>\n

Percent<\/strong><\/p>\n

Assets<\/strong><\/p>\n

\u00a0\u00a0\u00a0Current Assets\u00a0<\/p>\n

$9,580<\/p>\n

enter percentages rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

%<\/p>\n

\u00a0\u00a0\u00a0Property, plant, and equipment (net)<\/p>\n

1,810<\/p>\n

enter percentages rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

%<\/p>\n

\u00a0\u00a0\u00a0Other assets<\/p>\n

1,540<\/p>\n

enter percentages rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

%<\/p>\n

Total assets<\/p>\n

$12,930<\/p>\n

enter percentages rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

%<\/p>\n

Liabilities and Stockholders’ Equity<\/strong><\/p>\n

\u00a0\u00a0\u00a0Current Liabilities<\/p>\n

$3,150<\/p>\n

enter percentages rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

%<\/p>\n

\u00a0\u00a0\u00a0Long-term Liabilities<\/p>\n

1,320<\/p>\n

enter percentages rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

%<\/p>\n

\u00a0\u00a0\u00a0Stockholders\u2019 equity<\/p>\n

8,460<\/p>\n

enter percentages rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

%<\/p>\n

Total liabilities and stockholders’ equity<\/p>\n

$12,930<\/p>\n

enter percentages rounded to 1 decimal place \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

%<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u00a0Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC.Condensed Balance SheetMay 31($ in millions)20222021AssetsCurrent Assets$9,580$8,770Property, plant, and equipment (net)1,8101,800Other assets1,5401,670Total assets$12,930$12,240Liabilities and Stockholders’ EquityCurrent Liabilities$3,150$3,320Long-term liabilities1,3201,370Stockholders\u2019 equity8,4607,550Total liabilities and stockholders’ equity$12,930$12,240 (a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2021 as a base. (If \u00a0amount and percentage are […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-9154","post","type-post","status-publish","format-standard","hentry","category-homework-help"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/9154","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=9154"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/9154\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=9154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=9154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=9154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}