In: Accounting
Vertical Analysis of Income Statement
For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $20,000 for advertising. At the end of the year, Lumi Neer, the president, is presented with the following condensed comparative income statement:
| Tri-Comic Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1  | 
|||
| 20Y2 | 20Y1 | ||
| Sales | $724,000 | $623,000 | |
| Cost of goods sold | 369,240 | 348,880 | |
| Gross profit | $354,760 | $274,120 | |
| Selling expenses | $137,560 | $112,140 | |
| Administrative expenses | 72,400 | 74,760 | |
| Total operating expenses | $209,960 | $186,900 | |
| Income from operations | $144,800 | $87,220 | |
| Other revenue | 28,960 | 18,690 | |
| Income before income tax | $173,760 | $105,910 | |
| Income tax expense | 72,400 | 43,610 | |
| Net income | $101,360 | $62,300 | |
Required:
1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in relationship to sales for each of the years. Enter percentages as whole numbers. Enter all amounts as positive numbers.
| Tri-Comic Company | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31, 20Y2 and 20Y1 | ||||
| 20Y2 Amount | 20Y2 Percent | 20Y1 Amount | 20Y1 Percent | |
| Sales | $724,000 | % | $623,000 | % | 
| Cost of goods sold | 369,240 | % | 348,880 | % | 
| Gross profit | $354,760 | % | $274,120 | % | 
| Selling expenses | $137,560 | % | $112,140 | % | 
| Administrative expenses | 72,400 | % | 74,760 | % | 
| Total operating expenses | $209,960 | % | $186,900 | % | 
| Income from operations | $144,800 | % | $87,220 | % | 
| Other revenue | 28,960 | % | 18,690 | % | 
| Income before income tax | $173,760 | % | $105,910 | % | 
| Income tax expense | 72,400 | % | 43,610 | % | 
| Net income | $101,360 | % | $62,300 | % | 
2. The vertical analysis indicates that the costs other than selling expenses (cost of goods sold and administrative expenses) as a percentage of sales. As a result, net income as a percentage of sales . The sales promotion campaign appears to have been . While selling expenses as a percent of sales slightly, the cost was more than made up for by sales.
| 
 Tri-Comic Company  | 
||||
| 
 Comparative Income Statement  | 
||||
| 
 For the Years Ended December 31, 20Y2 and 20Y1  | 
||||
| 
 20Y2 Amount  | 
 20Y2 Percent  | 
 20Y1 Amount  | 
 20Y1 Percent  | 
|
| 
 Sales  | 
 $724,000  | 
 100.0%  | 
 $623,000  | 
 100.0%  | 
| 
 Cost of goods sold  | 
 $369,240  | 
 51.0%  | 
 $348,880  | 
 56.0%  | 
| 
 Gross profit  | 
 $354,760  | 
 49.0%  | 
 $274,120  | 
 44.0%  | 
| 
 Selling expenses  | 
 $137,560  | 
 19.0%  | 
 $112,140  | 
 18.0%  | 
| 
 Administrative expenses  | 
 $72,400  | 
 10.0%  | 
 $74,760  | 
 12.0%  | 
| 
 Total operating expenses  | 
 $209,960  | 
 29.0%  | 
 $186,900  | 
 30.0%  | 
| 
 Income from operations  | 
 $144,800  | 
 20.0%  | 
 $87,220  | 
 14.0%  | 
| 
 Other revenue  | 
 $28,960  | 
 4.0%  | 
 $18,690  | 
 3.0%  | 
| 
 Income before income tax  | 
 $173,760  | 
 24.0%  | 
 $105,910  | 
 17.0%  | 
| 
 Income tax expense  | 
 $72,400  | 
 10.0%  | 
 $43,610  | 
 7.0%  | 
| 
 Net income  | 
 $101,360  | 
 14.0%  | 
 $62,300  | 
 10.0%  | 
The vertical analysis indicates that the costs other than selling expenses (cost of goods sold and administrative expenses) DECREASED as a percentage of sales. As a result, net income INCREASED as a percentage of sales . The sales promotion campaign appears to have been EFFECTIVE. While selling expenses as a percent of sales INCREASED slightly, the INCREASED cost was more than made up for by INCREASED sales.