In: Accounting
Vertical Analysis of Income Statement
For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $15,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 | $545,000 | $469,000 | |
| Cost of merchandise sold | 261,600 | 253,260 | |
| Gross profit | $283,400 | $215,740 | |
| Selling expenses | $114,450 | $93,800 | |
| Administrative expenses | 59,950 | 60,970 | |
| Total operating expenses | $174,400 | $154,770 | |
| Income from operations | $109,000 | $60,970 | |
| Other revenue | 32,700 | 23,450 | |
| Income before income tax expense | $141,700 | $84,420 | |
| Income tax expense | 54,500 | 32,830 | |
| Net income | $87,200 | $51,590 | |
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 | $545,000 | fill in the blank | $469,000 | fill in the blank | 
| Cost of merchandise sold | 261,600 | fill in the blank | 253,260 | fill in the blank | 
| Gross profit | $283,400 | fill in the blank | $215,740 | fill in the blank | 
| Selling expenses | $114,450 | fill in the blank | $93,800 | fill in the blank | 
| Administrative expenses | 59,950 | fill in the blank | 60,970 | fill in the blank | 
| Total operating expenses | $174,400 | fill in the blank | $154,770 | fill in the blank | 
| Income from operations | $109,000 | fill in the blank | $60,970 | fill in the blank | 
| Other revenue | 32,700 | fill in the blank | 23,450 | fill in the blank | 
| Income before income tax expense | $141,700 | fill in the blank | $84,420 | fill in the blank | 
| Income tax expense | 54,500 | fill in the blank | 32,830 | fill in the blank | 
| Net income | $87,200 | fill in the blank | $51,590 | fill in the blank | 
2. The vertical analysis indicates that the costs other than selling expenses (cost of merchandise 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 sale