In: Accounting
Vertical Analysis of Income Statement
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:
| Current Year | Previous Year | |||
| Sales | $432,000 | $372,000 | ||
| Cost of goods sold | 267,840 | 212,040 | ||
| Selling expenses | 64,800 | 63,240 | ||
| Administrative expenses | 73,440 | 59,520 | ||
| Income tax expense | 8,640 | 14,880 | ||
a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers.
| Innovation Quarter Inc. | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31 | ||||
| Current year Amount | Current year Percent | Previous year Amount | Previous year Percent | |
| Sales | $432,000 | % | $372,000 | % |
| Cost of goods sold | 267,840 | % | 212,040 | % |
| Gross profit | $ | % | $ | % |
| Selling expenses | 64,800 | % | 63,240 | % |
| Administrative expenses | 73,440 | % | 59,520 | % |
| Total operating expenses | $ | % | $ | % |
| Income from operations | % | % | ||
| Income tax expense | 8,640 | % | 14,880 | % |
| Net income | $ | % | $ | % |
| Innovation Quarter Inc | |||||
| Comparative Income statement | |||||
| Particulars | Current year | % | previous year | % | |
| sale | $ 4,32,000.00 | 100% | $ 3,72,000.00 | 100% | |
| cost of goods sold | $ 2,67,840.00 | 62% | $ 2,12,040.00 | 57% | |
| Gross profit | $ 1,64,160.00 | 38% | $ 1,59,960.00 | 43% | |
| Selling expenses | $ 64,800.00 | 15% | $ 63,240.00 | 17% | |
| administrative exp | $ 73,440.00 | 17% | $ 59,520.00 | 16% | |
| total operating expenses | $ 1,38,240.00 | 32% | $ 1,22,760.00 | 33% | |
| income from operation | $ 25,920.00 | 6% | $ 37,200.00 | 10% | |
| income tax expenses | $ 8,640.00 | 2% | $ 14,880.00 | 4% | |
| Net income | $ 17,280.00 | 4% | $ 22,320.00 | 6% | |