In: Accounting
4.
Vertical Analysis of Income Statement
For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $23,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 | $804,000 | $691,000 | |
| Cost of goods sold | 393,960 | 380,050 | |
| Gross profit | $410,040 | $310,950 | |
| Selling expenses | $160,800 | $131,290 | |
| Administrative expenses | 88,440 | 89,830 | |
| Total operating expenses | $249,240 | $221,120 | |
| Income from operations | $160,800 | $89,830 | |
| Other income | 48,240 | 41,460 | |
| Income before income tax | $209,040 | $131,290 | |
| Income tax expense | 80,400 | 55,280 | |
| Net income | $128,640 | $76,010 | |
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 | $804,000 | % | $691,000 | % | 
| Cost of goods sold | 393,960 | % | 380,050 | % | 
| Gross profit | $410,040 | % | $310,950 | % | 
| Selling expenses | 160,800 | % | 131,290 | % | 
| Administrative expenses | 88,440 | % | 89,830 | % | 
| Total operating expenses | $249,240 | % | $221,120 | % | 
| Income from operations | $160,800 | % | $89,830 | % | 
| Other income | 48,240 | % | 41,460 | % | 
| Income before income tax | $209,040 | % | $131,290 | % | 
| Income tax expense | 80,400 | % | 55,280 | % | 
| Net income | $128,640 | % | $76,010 | % | 
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.
Correct Answer:
| 
 Tri-Comic Company  | 
||||
| 
 Comparative Income Statement  | 
||||
| 
 For the Years Ended December 31, 20Y2 and 20Y1  | 
||||
| 
 20Y2 Amount  | 
 20Y2 Percent  | 
 20Y1 Amount  | 
 20Y1 Percent  | 
|
| 
 Amount / sales *100  | 
 Amount / sales *100  | 
|||
| 
 Sales  | 
 $ 804,000  | 
 100%  | 
 $ 691,000  | 
 100%  | 
| 
 Cost of goods sold  | 
 $ 393,960  | 
 49%  | 
 $ 380,050  | 
 55%  | 
| 
 Gross profit  | 
 $ 410,040  | 
 51%  | 
 $ 310,950  | 
 45%  | 
| 
 Selling expenses  | 
 $ 160,800  | 
 20%  | 
 $ 131,290  | 
 19%  | 
| 
 Administrative expenses  | 
 $ 88,440  | 
 11%  | 
 $ 89,830  | 
 13%  | 
| 
 Total operating expenses  | 
 $ 249,240  | 
 31%  | 
 $ 221,120  | 
 32%  | 
| 
 Income from operations  | 
 $ 160,800  | 
 20%  | 
 $ 89,830  | 
 13%  | 
| 
 Other income  | 
 $ 48,240  | 
 6%  | 
 $ 41,460  | 
 6%  | 
| 
 Income before income tax  | 
 $ 209,040  | 
 26%  | 
 $ 131,290  | 
 19%  | 
| 
 Income tax expense  | 
 $ 80,400  | 
 10%  | 
 $ 55,280  | 
 8%  | 
| 
 Net income  | 
 $ 128,640  | 
 16%  | 
 $ 76,010  | 
 11%  | 
End of answer.
Thanks.