For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $18,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 | $627,000 | $539,000 | |
Cost of goods sold | 288,420 | 269,500 | |
Gross profit | $338,580 | $269,500 | |
Selling expenses | $125,400 | $102,410 | |
Administrative expenses | 68,970 | 70,070 | |
Total operating expenses | $194,370 | $172,480 | |
Income from operations | $144,210 | $97,020 | |
Other revenue | 18,810 | 32,340 | |
Income before income tax | $163,020 | $129,360 | |
Income tax expense | 62,700 | 53,900 | |
Net income | $100,320 | $75,460 |
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 | $627,000 | % | $539,000 | % |
Cost of goods sold | 288,420 | % | 269,500 | % |
Gross profit | $338,580 | % | $269,500 | % |
Selling expenses | $125,400 | % | $102,410 | % |
Administrative expenses | 68,970 | % | 70,070 | % |
Total operating expenses | $194,370 | % | $172,480 | % |
Income from operations | $144,210 | % | $97,020 | % |
Other revenue | 18,810 | % | 32,340 | % |
Income before income tax | $163,020 | % | $129,360 | % |
Income tax expense | 62,700 | % | 53,900 | % |
Net income | $100,320 | % | $75,460 | % |
2. The vertical analysis indicates that the costs other than selling expenses (cost of goods sold and administrative expenses) improved or deteriorated as a percentage of sales. As a result, net income as a percentage of sales increased or decreased . The sales promotion campaign appears to have been successful or unsuccessful . While selling expenses as a percent of sales increased or decreased slightly, the increased or decreased cost was more than made up for by increased or decreased sales.
Solution
Tri-Comic Company | ||||
Comparative Income Statement | ||||
For the Years Ended December 31, 20Y2 and 20Y1 | ||||
20Y2 Amount | 20Y2 Percent | 20Y1 Amount | 20Y1 Percent | |
Sales | $627,000.00 | 100% | $539,000.00 | 100% |
Cost of goods sold | $288,420.00 | 46% | $269,500.00 | 50% |
Gross profit | $338,580.00 | 54% | $269,500.00 | 50% |
Selling expenses | $125,400.00 | 20% | $102,410.00 | 19% |
Administrative expenses | $ 68,970.00 | 11% | $ 70,070.00 | 13% |
Total operating expenses | $194,370.00 | 31% | $172,480.00 | 32% |
Income from operations | $144,210.00 | 23% | $ 97,020.00 | 18% |
Other revenue | $ 18,810.00 | 3% | $ 32,340.00 | 6% |
Income before income tax | $163,020.00 | 26% | $129,360.00 | 24% |
Income tax expense | $ 62,700.00 | 10% | $ 53,900.00 | 10% |
Net income | $100,320.00 | 16% | $ 75,460.00 | 14% |
.Requirement 2
The vertical analysis indicates that the costs other than selling expenses (cost of goods sold and administrative expenses) improved as a percentage of sales. As a result, net income as a percentage of sales increased . The sales promotion campaign appears to have been successful . While selling expenses as a percent of sales increased slightly, the increased cost was more than made up for by increased sales.
For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional...
For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $50,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 1 20Y2 20Y1 2 Sales $890,000.00 $600,000.00 3 Cost of goods sold 320,400.00 228,000.00 4 Gross profit $569,600.00 $372,000.00 5 Selling expenses $142,400.00 $84,000.00 6 Administrative expenses 62,300.00...
Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $21,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 2041 20Y2 20Y1 $746,000 $642,000 Sales Cost of goods sold Gross profit 350,620 333,840 $395,380 $308,160 Selling expenses $156,660 $128,400 82,060 83,460 Administrative expenses...
Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $19,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 $680,000 $585,000 Cost of goods sold 326,400 310,050 Gross profit $353,600 $274,950 Selling expenses $129,200 $105,300 Administrative expenses 68,000 70,200...
Vertical analysis of income statement Instructions Income Statement Final Question Instructions For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $50,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, 2042 and 2041 2092 2011 Sales $850,000.00 $500,000.00 Cost of goods sold 340,000.00 Gross profit $510,000.00 210,000.00 $290,000.00 $90,000.00 35,000.00...
For 2016, Indigo Company initiated a sales promotion campaign that included the expenditure of an additional $39,000 for advertising. At the end of the year, Lumi Neer, the president, is presented with the following condensed comparative income statement: Indigo Company Comparative Income Statement For the Years Ended December 31, 2016 and 2015 1 2016 2015 2 Sales $890,000.00 $600,000.00 3 Cost of goods sold 320,400.00 228,000.00 4 Gross profit $569,600.00 $372,000.00 5 Selling expenses $142,400.00 $84,000.00 6 Administrative expenses 62,300.00...
For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $767,410 $665,000 Cost of goods sold 554,400 420,000 Gross profit $213,010 $245,000 Selling expenses $78,400 $56,000 Administrative expenses 45,080 35,000 Total operating expenses $123,480 $91,000 Income from operations $89,530 $154,000 Other revenue 3,567 2,800...
For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $489,402 $408,000 Cost of goods sold 364,000 260,000 Gross profit $125,402 $148,000 Selling expenses $51,000 $34,000 Administrative expenses 29,920 22,000 Total operating expenses $80,920 $56,000 Income from operations $44,482 $92,000 Other revenue 2,055 1,700...
Sales ........ For 2016, Indigo Company initiated a sales promotion campaign that included the expenditure of an additional $39,000 for advertising. At the end of the year, Lumi Neer, the president, is presented with the following condensed comparative income statement: Indigo Company Comparative Income Statement For the Years Ended December 31, 2016 and 2015 2016 2015 Sales $820,000 $600,000 Cost of goods sold............ 311,600 240,000 Gross profit ............... $508,400 $360,000 Selling expenses ............... $164,000 $108,000 Administrative expenses......... 57,400 54,000 Total...
Instructions Tri-Comic Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 2011 2 Sales 3 Cost of goods sold 2092 $830,000.00 323,700.00 $506,300.00 $149,400.00 4 Gross profit $620,000.00 254,200.00 $365,800.00 $99,200.00 43,400.00 5 Selling expenses 6 Administrative expenses 41,500.00 7 Total operating expenses $190,900.00 8 Income from operations 9 Other income $315,400.00 66,400.00 $381,800.00 215,800.00 $142,600.00 $223,200.00 49,600.00 $272,800.00 161,200.00 $111,600.00 10 Income before income tax 11 Income tax expense 12 Net income $166,000.00 Check My...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $647,570 $551,000 Cost of goods sold 476,000 350,000 Gross profit $171,570 $201,000 Selling expenses $66,700 $46,000 Administrative expenses 38,400 29,000 Total operating expenses $105,100 $75,000 Income from operations $66,470...