Question: Preparing Common-Size Income Statements by Using Base Period Horizontal Analysis Scherer Company provided the following income statements for its first 3 years of operation: Scherer

Preparing Common-Size Income Statements by Using Base Period Horizontal Analysis

Scherer Company provided the following income statements for its first 3 years of operation:

Scherer Company Income Statements Years of Operation
Year 1 Year 2 Year 3
Net sales $1,000,000.00 $1,100,000.00 $1,300,000.00
Less: Cost of goods sold (300,000.00) (310,000.00) (364,000.00)
Gross margin $700,000.00 $790,000.00 $936,000.00
Less:
Operating expenses (421,000.00) (484,000.00) (591,000.00)
Income taxes (111,600.00) (122,400.00) (137,800.00)
Net income $167,400.00 $183,600.00 $206,200.00

Required:

Prepare common-size income statements by using Year 1 as the base period. (Note: Enter all amounts as positive numbers, except for a net loss. Enter net loss as a negative number, if applicable. Round answers to the nearest whole percentage.)

Year 1 Year 1 Year 2 Year 2 Year 3 Year 3
Dollars Percentage Dollars Percentage Dollars Percentage
Net sales $1,000,000

100%

1,100,000

110%

$1,300,000

130%

Less: Cost of goods sold (300,000)

100%

(310,000)

103%

(364,000)

121%

Gross margin $700,000

100%

$790,000

fill in the blank

$936,000

fill in the blank

Less:
Operating expenses (421,000)

fill in the blank

(484,000)

fill in the blank

(591,000)

fill in the blank

Income taxes (111,600)

fill in the blank

(122,400)

fill in the blank

(137,800)

fill in the blank

Net income $167,400

fill in the blank

$183,600

fill in the blank

$206,200

fill in the blank

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!