Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:          Current Year        Previous Year Sales $4,000,000   $3,600,000   Cost of goods sold 2,280,000   1,872,000   Selling expenses 600,000   648,000   Administrative expenses 520,000   360,000   Income tax expense 240,000   216,000   a.  Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round to the nearest whole percentage. Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31   Current year Amount Current year Percent Previous year Amount Previous year Percent Sales $4,000,000 % $3,600,000 % Cost of goods sold (2,280,000) % (1,872,000) %   $ % $ % Selling expenses $(600,000) % $(648,000) % Administrative expenses (520,000) % (360,000) %   $ % $ %   $ % $ % Income tax expense (240,000) % (216,000) %   $ % $ % b.  The vertical analysis indicates that the cost of goods sold as a percent of sales   by 5 percentage points, while selling expenses   by 3 percentage points, and administrative expenses   by 3 percentage points. Thus, net income as a percent of sales   by 5 percentage points.

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter16: Financial Statement Analysis
Section: Chapter Questions
Problem 1E
icon
Related questions
icon
Concept explainers
Topic Video
Question

Vertical Analysis of Income Statement

Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:

         Current Year        Previous Year
Sales $4,000,000   $3,600,000  
Cost of goods sold 2,280,000   1,872,000  
Selling expenses 600,000   648,000  
Administrative expenses 520,000   360,000  
Income tax expense 240,000   216,000  

a.  Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round to the nearest whole percentage.

Innovation Quarter Inc.
Comparative Income Statement
For the Years Ended December 31
  Current year
Amount
Current year
Percent
Previous year
Amount
Previous year
Percent
Sales $4,000,000 % $3,600,000 %
Cost of goods sold (2,280,000) % (1,872,000) %
  $ % $ %
Selling expenses $(600,000) % $(648,000) %
Administrative expenses (520,000) % (360,000) %
  $ % $ %
  $ % $ %
Income tax expense (240,000) % (216,000) %
  $ % $ %

b.  The vertical analysis indicates that the cost of goods sold as a percent of sales   by 5 percentage points, while selling expenses   by 3 percentage points, and administrative expenses   by 3 percentage points. Thus, net income as a percent of sales   by 5 percentage points.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning