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. If required, round percentages to one decimal place. Enter all amounts as positive numbers. 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 fill in the blank f86a69fccf96045_1% $3,600,000 fill in the blank f86a69fccf96045_2% Cost of goods sold 2,280,000 fill in the blank f86a69fccf96045_3% 1,872,000 fill in the blank f86a69fccf96045_4%   $fill in the blank f86a69fccf96045_6 fill in the blank f86a69fccf96045_7% $fill in the blank f86a69fccf96045_8 fill in the blank f86a69fccf96045_9% Selling expenses 600,000 fill in the blank f86a69fccf96045_10% 648,000 fill in the blank f86a69fccf96045_11% Administrative expenses 520,000 fill in the blank f86a69fccf96045_12% 360,000 fill in the blank f86a69fccf96045_13%   $fill in the blank f86a69fccf96045_15 fill in the blank f86a69fccf96045_16% $fill in the blank f86a69fccf96045_17 fill in the blank f86a69fccf96045_18%   fill in the blank f86a69fccf96045_20 fill in the blank f86a69fccf96045_21% fill in the blank f86a69fccf96045_22 fill in the blank f86a69fccf96045_23% Income tax expense 240,000 fill in the blank f86a69fccf96045_24% 216,000 fill in the blank f86a69fccf96045_25%   $fill in the blank f86a69fccf96045_27 fill in the blank f86a69fccf96045_28% $fill in the blank f86a69fccf96045_29 fill in the blank f86a69fccf96045_30% 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. If required, round percentages to one decimal place. Enter all amounts as positive numbers.

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 fill in the blank f86a69fccf96045_1% $3,600,000 fill in the blank f86a69fccf96045_2%
Cost of goods sold 2,280,000 fill in the blank f86a69fccf96045_3% 1,872,000 fill in the blank f86a69fccf96045_4%
  $fill in the blank f86a69fccf96045_6 fill in the blank f86a69fccf96045_7% $fill in the blank f86a69fccf96045_8 fill in the blank f86a69fccf96045_9%
Selling expenses 600,000 fill in the blank f86a69fccf96045_10% 648,000 fill in the blank f86a69fccf96045_11%
Administrative expenses 520,000 fill in the blank f86a69fccf96045_12% 360,000 fill in the blank f86a69fccf96045_13%
  $fill in the blank f86a69fccf96045_15 fill in the blank f86a69fccf96045_16% $fill in the blank f86a69fccf96045_17 fill in the blank f86a69fccf96045_18%
  fill in the blank f86a69fccf96045_20 fill in the blank f86a69fccf96045_21% fill in the blank f86a69fccf96045_22 fill in the blank f86a69fccf96045_23%
Income tax expense 240,000 fill in the blank f86a69fccf96045_24% 216,000 fill in the blank f86a69fccf96045_25%
  $fill in the blank f86a69fccf96045_27 fill in the blank f86a69fccf96045_28% $fill in the blank f86a69fccf96045_29 fill in the blank f86a69fccf96045_30%

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

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
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
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
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