Question

Vertical Analysis for Income Statement

For 20Y6, Fishing Experiences Inc. initiated a sales promotion campaign that included the expenditure of an additional $19,000 for advertising. At the end of the year, Colt Schultz, the president, is presented with the following condensed comparative income statement:

FISHING EXPERIENCES INC. Comparative Income Statement For the Years Ended December 31, 20Y6 and 20Y5
	20Y6		20Y5
Sales	$695,000		$598,000
Cost of goods sold	(326,650)		(328,900)
Gross profit	$ 368,350		$ 269,100
Selling expenses	(152,900)		(119,600)
Administrative expenses	(62,550)		(77,740)
Total operating expenses	$ (215,450)		$ (197,340)
Operating income	$ 152,900		$ 71,760
Other revenue	41,700		23,920
Income before income tax	$ 194,600		$ 95,680
Income tax expense	(76,450)		(35,880)
Net income	$ 118,150		$ 59,800

Instructions:

1. Prepare a comparative income statement for the two-year period, presenting a vertical analysis of each item in relationship to sales for each of the years.

Fishing Experiences Inc.
Comparative Income Statement
For the Years Ended December 31, 20Y6 and 20Y5
	20Y6 Amount	20Y6 Percent	20Y5 Amount	20Y5 Percent
Sales	$695,000	%	$598,000	%
Cost of goods sold	(326,650)	%	(328,900)	%
Gross profit	$368,350	%	$269,100	%
Selling expenses	$(152,900)	%	$(119,600)	%
Administrative expenses	(62,550)	%	(77,740)	%
Total operating expenses	$(215,450)	%	$(197,340)	%
Operating income	$152,900	%	$71,760	%
Other revenue	41,700	%	23,920	%
Income before income tax	$194,600	%	$95,680	%
Income tax expense	(76,450)	%	(35,880)	%
Net income	$118,150	%	$59,800	%

2. Based on the vertical analysis prepared in 1 which of the following statements is correct?
a. Costs other than selling expenses (cost of goods sold and administrative expenses) improved as a percentage of sales.
b. Net income as a percentage of sales increased.
c. The sales promotion campaign appears to have been successful.
d. Selling expenses as a percent of sales increased slightly

Answer 1

Aus fishing ENTERPRISES INC Comparative Income Statement for the Year Ended Dec 31, 2016 and 2015 2046 2046 1 2045 Amount | Percent Amount 1 $ 695000 | looy | $598,0T0 2045 Percent | 100 Y. Sales Cost of Goods Sold (326, 650) (479) (328,900 (55%) Cross profit 14368,350 | 53% $269,100 | 45% Selling expenses 1*(158,960) (2x) *(113,600) | 6200) Administractive Expert (62,550) (94) |(277,740) | (1864) Hotel operating Expenale (5: 1458) (314) (197,34) (334) Operating Income 41532,900 pody. 471,760 lapu Other Revenue 41,700 6% 23,920 un Arome before income 14194,600 284. 95,680 16%. __Tax Anamne task Eppense (76.450) (116) 35.860)| (64) Net Income 118,150 L 17% $59800 loy,

2. Net income as a percentage of sales increased.

If you have any query ask in comment section. If you like the answer plz rate. Thanks