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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education