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 | $700,000 | $602,000 | |
| Cost of goods sold | 357,000 | 343,140 | |
| Gross profit | $343,000 | $258,860 | |
| Selling expenses | $140,000 | $114,380 | |
| Administrative expenses | 70,000 | 72,240 | |
| Total operating expenses | $210,000 | $186,620 | |
| Income from operations | $133,000 | $72,240 | |
| Other income | 35,000 | 30,100 | |
| Income before income tax | $168,000 | $102,340 | |
| Income tax expense | 70,000 | 42,140 | |
| Net income | $98,000 | $60,200 | |
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 | $700,000 | % | $602,000 | % |
| Cost of goods sold | 357,000 | % | 343,140 | % |
| Gross profit | $343,000 | % | $258,860 | % |
| Selling expenses | 140,000 | % | 114,380 | % |
| Administrative expenses | 70,000 | % | 72,240 | % |
| Total operating expenses | $210,000 | % | $186,620 | % |
| Income from operations | $133,000 | % | $72,240 | % |
| Other income | 35,000 | % | 30,100 | % |
| Income before income tax | $168,000 | % | $102,340 | % |
| Income tax expense | 70,000 | % | 42,140 | % |
| Net income | $98,000 | % | $60,200 | % |
| Comparitive income statements are prepared for analysing the results of operations over multiple accounting periods with a few different options for review. | ||||||||||||||
| It is a document that compares a particular financial statement with prior period statements. | ||||||||||||||
| Percentage are calculated as a % of sales | ||||||||||||||
| For eg : Sales / Sales *100 , Cost of goods sold / sales *100 | ||||||||||||||
| Tri-Comic Company | ||||||||||||||
| Comparative Income Statement | ||||||||||||||
| For the Years Ended December 31, 20Y2 and 20Y1 | ||||||||||||||
| 20Y2 Amount | 20Y2 Percent | 20Y1 Amount | 20Y1 Percent | |||||||||||
| Sales | $700,000 | 100% | $602,000 | 100% | ||||||||||
| Cost of goods sold | 357,000 | 51% | 343,140 | 57% | ||||||||||
| Gross profit | $343,000 | 49% | $258,860 | 43% | ||||||||||
| Selling expenses | 140,000 | 20% | 114,380 | 19% | ||||||||||
| Administrative expenses | 70,000 | 10% | 72,240 | 12% | ||||||||||
| Total operating expenses | $210,000 | 30% | $186,620 | 31% | ||||||||||
| Income from operations | $133,000 | 19% | $72,240 | 12% | ||||||||||
| Other income | 35,000 | 5% | 30,100 | 5% | ||||||||||
| Income before income tax | $168,000 | 24% | $102,340 | 17% | ||||||||||
| Income tax expense | 70,000 | 10% | 42,140 | 7% | ||||||||||
| Net income | $98,000 | 14% | $60,200 | 10% | ||||||||||