Coursehero USA logo
  • My account
  • Order now
Order Now
Homework Help

Project 3: horizontal and vertical analysis

2 min read
Posted on 
May 26th, 2023
Home Homework Help Project 3: horizontal and vertical analysis

 Hypothetical balance sheets of Nike, Inc. are presented here.

NIKE, INC.
Condensed Balance Sheet
May 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’ 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  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)20222021Increase
(Decrease)Percentage
Change
from 2021Assets   Current Assets$9,580$8,770$enter a dollar amount       enter percentages rounded to 1 decimal place rounded to 1 decimal place        %   Property, plant, and equipment (net)1,8101,800enter a dollar amount       enter percentages rounded to 1 decimal place rounded to 1 decimal place        %   Other assets1,5401,670enter a dollar amount       enter percentages rounded to 1 decimal place rounded to 1 decimal place        %   Total assets$12,930$12,240$enter a dollar amount       enter percentages rounded to 1 decimal place rounded to 1 decimal place        %Liabilities and Stockholders’ Equity   Current Liabilities$3,150$3,320$enter a dollar amount       enter percentages rounded to 1 decimal place rounded to 1 decimal place        %   Long-term liabilities1,3201,370enter a dollar amount       enter percentages rounded to 1 decimal place rounded to 1 decimal place        %   Stockholders’ equity8,4607,550enter a dollar amount       enter percentages rounded to 1 decimal place rounded to 1 decimal place        %   Total liabilities and stockholders’ equity$12,930$12,240$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  

$ (in millions)

Percent

Assets

   Current Assets 

$9,580

enter percentages rounded to 1 decimal place       

%

   Property, plant, and equipment (net)

1,810

enter percentages rounded to 1 decimal place       

%

   Other assets

1,540

enter percentages rounded to 1 decimal place       

%

Total assets

$12,930

enter percentages rounded to 1 decimal place       

%

Liabilities and Stockholders’ Equity

   Current Liabilities

$3,150

enter percentages rounded to 1 decimal place       

%

   Long-term Liabilities

1,320

enter percentages rounded to 1 decimal place       

%

   Stockholders’ equity

8,460

enter percentages rounded to 1 decimal place       

%

Total liabilities and stockholders’ equity

$12,930

enter percentages rounded to 1 decimal place       

%

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order
Share
Tweet
Share
Tweet
Calculate the price
Pages (275 words)
$0.00
Coursehero USA
Company
Legal
How Our Service is Used:
Coursehero USA essays are NOT intended to be forwarded as finalized work as it is only strictly meant to be used for research and study purposes. Coursehero USA does not endorse or condone any type of plagiarism.
Subscribe
No Spam
© 2023 Coursehero USA. All rights reserved.
Coursehero USA will be listed as ‘Coursehero USA’ on your bank statement.