Question

In: Accounting

Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included...

  1. 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 $724,000 $623,000
    Cost of goods sold 369,240 348,880
    Gross profit $354,760 $274,120
    Selling expenses $137,560 $112,140
    Administrative expenses 72,400 74,760
    Total operating expenses $209,960 $186,900
    Income from operations $144,800 $87,220
    Other revenue 28,960 18,690
    Income before income tax $173,760 $105,910
    Income tax expense 72,400 43,610
    Net income $101,360 $62,300

    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 $724,000 % $623,000 %
    Cost of goods sold 369,240 % 348,880 %
    Gross profit $354,760 % $274,120 %
    Selling expenses $137,560 % $112,140 %
    Administrative expenses 72,400 % 74,760 %
    Total operating expenses $209,960 % $186,900 %
    Income from operations $144,800 % $87,220 %
    Other revenue 28,960 % 18,690 %
    Income before income tax $173,760 % $105,910 %
    Income tax expense 72,400 % 43,610 %
    Net income $101,360 % $62,300 %

    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.

Solutions

Expert Solution

  • [1]

Tri-Comic Company

Comparative Income Statement

For the Years Ended December 31, 20Y2 and 20Y1

20Y2 Amount

20Y2 Percent

20Y1 Amount

20Y1 Percent

Sales

$724,000

100.0%

$623,000

100.0%

Cost of goods sold

$369,240

51.0%

$348,880

56.0%

Gross profit

$354,760

49.0%

$274,120

44.0%

Selling expenses

$137,560

19.0%

$112,140

18.0%

Administrative expenses

$72,400

10.0%

$74,760

12.0%

Total operating expenses

$209,960

29.0%

$186,900

30.0%

Income from operations

$144,800

20.0%

$87,220

14.0%

Other revenue

$28,960

4.0%

$18,690

3.0%

Income before income tax

$173,760

24.0%

$105,910

17.0%

Income tax expense

$72,400

10.0%

$43,610

7.0%

Net income

$101,360

14.0%

$62,300

10.0%

  • [2]

The vertical analysis indicates that the costs other than selling expenses (cost of goods sold and administrative expenses) DECREASED  as a percentage of sales. As a result, net income INCREASED as a percentage of sales  . The sales promotion campaign appears to have been  EFFECTIVE. While selling expenses as a percent of sales INCREASED   slightly, the  INCREASED cost was more than made up for by INCREASED   sales.


Related Solutions

Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included...
Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $16,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 $579,000 $498,000 Cost of goods sold 306,870 283,860 Gross profit $272,130 $214,140 Selling expenses $110,010 $89,640 Administrative expenses 57,900 59,760...
Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included...
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...
Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included...
Vertical Analysis of Income Statement 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 $639,000 $550,000 Cost of goods sold 325,890 308,000 Gross profit $313,110 $242,000 Selling expenses $121,410 $99,000 Administrative expenses 63,900 66,000...
Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included...
Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $12,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 $440,000 $378,000 Cost of goods sold 228,800 215,460 Gross profit $211,200 $162,540 Selling expenses $83,600 $68,040 Administrative expenses 44,000 45,360...
Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included...
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...
Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included...
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 $729,000 $627,000 Cost of goods sold 328,050 313,500 Gross profit $400,950 $313,500 Selling expenses $145,800 $119,130 Administrative expenses 72,900 75,240...
Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included...
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 20Y1 20Y2 20Y1 Sales $750,000 $645,000 Cost of goods sold 397,500 380,550 Gross profit $352,500 $264,450 Selling expenses $142,500 $116,100 Administrative expenses 75,000 77,400...
4. Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that...
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...
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 $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 $728,000 $626,000 Cost of goods sold 349,440 331,780 Gross profit $378,560 $294,220 Selling expenses $145,600 $118,940 Administrative expenses 80,080 81,380 Total operating expenses $225,680 $200,320...
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 $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 20Y1 20Y2 20Y1 Sales $758,000 $652,000 Cost of goods sold 379,000 365,120 Gross profit $379,000 $286,880 Selling expenses $151,600 $123,880 Administrative expenses 83,380 84,760 Total operating expenses $234,980 $208,640...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT