Horizontal Analysis for Income Statement

For 20Y3, Greyhound Technology Company reported its most significant decline in net income in years. At the end of the year, Duane Vogel, the president, is presented with the following condensed comparative income statement:

GREYHOUND TECHNOLOGY COMPANY Comparative Income Statement For the Years Ended December 31, 20Y3 and 20Y2
	20Y3		20Y2
Sales	$ 355,052		$ 313,000
Cost of goods sold	(256,000)		(200,000)
Gross profit	$ 99,052		$ 113,000
Selling expenses	$ (35,100)		$ (26,000)
Administrative expenses	(21,280)		(17,000)
Total operating expenses	$ (56,380)		$ (43,000)
Income from operations	$ 42,672		$ 70,000
Other revenue	1,617		1,300
Income before income tax	$ 44,289		$ 71,300
Income tax expense	(12,400)		(21,400)
Net income	$ 31,889		$ 49,900

Instructions:

Question Content Area

1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y2 as the base year. Enter decreases as negative amounts and negative percentages. Round percentage changes to one decimal place.

Greyhound Technology Company Comparative Income Statement For the Years Ended December 31, 20Y3 and 20Y2

	20Y3	20Y2	Increase (Decrease) Amount	Increase (Decrease) Percent
Sales	$355,052	$313,000	$fill in the blank dcc62df69faa063_1	fill in the blank dcc62df69faa063_2%
Cost of goods sold	(256,000)	(200,000)	fill in the blank dcc62df69faa063_3	fill in the blank dcc62df69faa063_4%
Gross profit	$99,052	$113,000	$fill in the blank dcc62df69faa063_5	fill in the blank dcc62df69faa063_6%
Selling expenses	$(35,100)	$(26,000)	$fill in the blank dcc62df69faa063_7	fill in the blank dcc62df69faa063_8%
Administrative expenses	(21,280)	(17,000)	fill in the blank dcc62df69faa063_9	fill in the blank dcc62df69faa063_10%
Total operating expenses	$(56,380)	$(43,000)	$fill in the blank dcc62df69faa063_11	fill in the blank dcc62df69faa063_12%
Income from operations	$42,672	$70,000	$fill in the blank dcc62df69faa063_13	fill in the blank dcc62df69faa063_14%
Other revenue	1,617	1,300	fill in the blank dcc62df69faa063_15	fill in the blank dcc62df69faa063_16%
Income before income tax	$44,289	$71,300	$fill in the blank dcc62df69faa063_17	fill in the blank dcc62df69faa063_18%
Income tax expense	(12,400)	(21,400)	fill in the blank dcc62df69faa063_19	fill in the blank dcc62df69faa063_20%
Net income	$31,889	$49,900	$fill in the blank dcc62df69faa063_21	fill in the blank dcc62df69faa063_22%

Question Content Area

2. Based on the horizontal analysis prepared in 1 which of the following statements is correct? a. Net income declined from 20Y2 to 20Y3. b. Sales increased, but the cost of goods also increased causing gross profit to decline. c. Other revenues decreased slightly and income tax expense increased. d. Over all there is decline in net income.