Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. prepare a horizontal analysis of the balance sheet

Prepare a horizontal analysis of the balance sheet data for Nike, using 2019 as a base....

Free

90.2K

Verified Solution

Question

Accounting

Prepare a horizontal analysis of the balance sheet data forNike, using 2019 as a base. (Show the amount of increase ordecrease as well.)

b. Prepare a vertical analysis of the balancesheet data for Nike for 2020.

Prepare horizontal and vertical analyses.

E13.6 (LO 2) Here are the comparative incomestatements of Delaney Corporation.

Delaney Corporation

Comparative Income Statements

For the Years Ended December 31

    2020    2019
Net sales    $598,000    $500,000
Cost of goods sold477,000420,000
Gross profit121,00080,000
Operating expenses80,00044,000
Net income$?41,000$?36,000

Answer & Explanation Solved by verified expert
3.8 Ratings (606 Votes)

Comparative Income Statement - Horizontal Analysis
2020 2019 Difference Horizontal Analysis
(a) (b) (c) = (a) - (b) (b) / (c)
Sales $ 5,98,000 $           5,00,000 $     98,000 19.60%
Cost of goods sold $ 4,77,000 $           4,20,000 $     57,000 13.57%
Gross profit $ 1,21,000 $               80,000 $     41,000 51.25%
Operating expenses $     80,000 $               44,000 $     36,000 81.82%
Net Income $     41,000 $               36,000 $       5,000 13.89%
Comparative Income Statement - Vertical Analysis
2020 Percent of Sales 2019 Percent of Sales
(a) [(a) / $598000] X 100 (b) [(b) / $500000] X 100
Sales $ 5,98,000 100.00% $ 5,00,000 100.00%
Cost of goods sold $ 4,77,000 79.77% $ 4,20,000 84.00%
Gross profit $ 1,21,000 20.23% $     80,000 16.00%
Operating expenses $     80,000 13.38% $     44,000 8.80%
Net Income $     41,000 6.86% $     36,000 7.20%

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

How can you use transmedia strategies to communicate this ethos (persuasive) ? What will your CSR...

General Management
Q

A magnetic needle laying parallel to a magnetic field requires W unit of work to...

Physics
Q

11 mi 2 6 cm 17 5 mi 1291son sem 8 mi 11 mi 18...

Geometry
Q

Use the calculator displays to the right to make a decision to reject or fail...

Basic Math
Q

10 a In a game of poker 5 card han A flush is a 5...

Statistics
Q

4 The half life of a medication is the amount of time for half of...

Algebra
Q

2 x 9 x 3

Algebra
Q

what of the following statements regarding the basis of mutual fund

Accounting
Q

(Ignore income taxes in this problem.) Beaver Corporation is investigating the purchase of a new...

Accounting
Q

An employee has gross earnings of $1,400 with withholdings of 6.2% FICAOASDI, 1.45% FICAMedicare, $50...

Accounting
Q

urgent !! please help by showing work on e-notes/ notebook NOT excel or other...

Accounting
Q

Nordic American Tankers (NAT) and Double Hull Tankers (DHT) are to shipping companies listen at...

Finance