Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows:       Current Year       Previous Year Sales $537,600     $420,000   Cost of goods sold 462,500     370,000   Gross profit $75,100     $50,000   Selling expenses $22,420     $19,000   Administrative expenses 20,160     16,000   Total operating expenses $42,580     $35,000   Income before income tax $32,520     $15,000   Income tax expenses 13,000     6,000   Net income $19,520     $9,000   a.  Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.

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 2PB
icon
Related questions
Question

Horizontal Analysis of the Income Statement

Income statement data for Winthrop Company for two recent years ended December 31, are as follows:

      Current Year       Previous Year
Sales $537,600     $420,000  
Cost of goods sold 462,500     370,000  
Gross profit $75,100     $50,000  
Selling expenses $22,420     $19,000  
Administrative expenses 20,160     16,000  
Total operating expenses $42,580     $35,000  
Income before income tax $32,520     $15,000  
Income tax expenses 13,000     6,000  
Net income $19,520     $9,000  

a.  Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.

Winthrop Company
Comparative Income Statement
For the Years Ended December 31
  Current
year
Amount
Previous
year
Amount
Increase
(Decrease)
Amount
Increase
(Decrease)
Percent
Sales $537,600 $420,000 $fill in the blank 0c8da5019fd7011_1 fill in the blank 0c8da5019fd7011_2%
Cost of goods sold 462,500 370,000 fill in the blank 0c8da5019fd7011_3 fill in the blank 0c8da5019fd7011_4%
Gross profit $75,100 $50,000 $fill in the blank 0c8da5019fd7011_5 fill in the blank 0c8da5019fd7011_6%
Selling expenses $22,420 $19,000 $fill in the blank 0c8da5019fd7011_7 fill in the blank 0c8da5019fd7011_8%
Administrative expenses 20,160 16,000 fill in the blank 0c8da5019fd7011_9 fill in the blank 0c8da5019fd7011_10%
Total operating expenses $42,580 $35,000 $fill in the blank 0c8da5019fd7011_11 fill in the blank 0c8da5019fd7011_12%
Income before income tax $32,520 $15,000 $fill in the blank 0c8da5019fd7011_13 fill in the blank 0c8da5019fd7011_14%
Income tax expense 13,000 6,000 fill in the blank 0c8da5019fd7011_15 fill in the blank 0c8da5019fd7011_16%
Net income $19,520 $9,000 $fill in the blank 0c8da5019fd7011_17 fill in the blank 0c8da5019fd7011_18%

b.  The net income for Winthrop Company increased between years. This increase was the combined result of an (INCREASE OR DECREASE)  in sales and  (HIGHER OR LOWER) percentage (INCREASE OR DECREASE)  in cost of goods sold. The cost of goods sold increased at a  (SLOWER OR FASTER) rate than the increase in sales, thus causing the percentage increase in gross profit to be GREATER OR LESS  than the percentage increase in sales.

Expert Solution
Step 1 Calculation
      Current Year       Previous Year Difference
Sales $537,600   $420,000 17600
Cost of goods sold 462,500   370,000 92500
Gross profit $75,100   $50,000 25100
Selling expenses $22,420   $19,000 3420
Administrative expenses 20,160   16,000 4160
Total operating expenses $42,580   $35,000 7580
Income before income tax $32,520   $15,000 17520
Income tax expenses 13,000   6,000 7000
Net income $19,520   $9,000 10520
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Ratio Analysis
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
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
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
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
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,