Question

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 $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 $812,000 $698,000
Cost of goods sold 365,400 349,000
Gross profit $446,600 $349,000
Selling expenses $162,400 $132,620
Administrative expenses 89,320 90,740
Total operating expenses $251,720 $223,360
Income from operations $194,880 $125,640
Other income 24,360 20,940
Income before income tax $219,240 $146,580
Income tax expense 89,320 55,840
Net income $129,920 $90,740

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 $812,000 % $698,000 %
Cost of goods sold 365,400 % 349,000 %
Gross profit $446,600 % $349,000 %
Selling expenses 162,400 % 132,620 %
Administrative expenses 89,320 % 90,740 %
Total operating expenses $251,720 % $223,360 %
Income from operations $194,880 % $125,640 %
Other income 24,360 % 20,940 %
Income before income tax $219,240 % $146,580 %
Income tax expense 89,320 % 55,840 %
Net income $129,920 % $90,740 %

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.

Homework Answers

Answer #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 $812,000 100% $698,000 100%
Cost of goods sold 365,400 45% 349,000 50%
Gross profit $446,600 55% $349,000 50%
Selling expenses 162,400 20% 132,620 19%
Administrative expenses 89,320 11% 90,740 13%
Total operating expenses $251,720 31% $223,360 32%
Income from operations $194,880 24% $125,640 18%
Other income 24,360 3% 20,940 3%
Income before income tax $219,240 27% $146,580 21%
Income tax expense 89,320 11% 55,840 8%
Net income $129,920 16% $90,740 13%
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
For 20Y2, Fielder Industries Inc. initiated a sales promotion campaign that included the expenditure of an...
For 20Y2, Fielder Industries Inc. initiated a sales promotion campaign that included the expenditure of an additional $40,000 for advertising. At the end of the year, Leif Grando, the president, is presented with the following condensed comparative income statement: Fielder Industries Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $1,300,000 $1,180,000 Cost of goods sold (682,500) (613,600) Gross profit $617,500 $566,400 Selling expenses $(260,000) $(188,800) Administrative expenses (169,000) (177,000) Total operating expenses...
For 20Y2, Fielder Industries Inc. initiated a sales promotion campaign that included the expenditure of an...
For 20Y2, Fielder Industries Inc. initiated a sales promotion campaign that included the expenditure of an additional $40,000 for advertising. At the end of the year, Leif Grando, the president, is presented with the following condensed comparative income statement: Fielder Industries Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $1,300,000 $1,180,000 Cost of goods sold (682,500) (613,600) Gross profit $617,500 $566,400 Selling expenses $(260,000) $(188,800) Administrative expenses (169,000) (177,000) Total operating expenses...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
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 $526,700 $465,000 Cost of goods sold 371,200 290,000 Gross profit $155,500 $175,000 Selling expenses $52,650 $39,000 Administrative expenses 31,300 25,000 Total operating expenses $83,950 $64,000 Income from operations $71,550...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
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 $495,121 $437,000 Cost of goods sold 358,400 280,000 Gross profit $136,721 $157,000 Selling expenses $49,950 $37,000 Administrative expenses 28,800 23,000 Total operating expenses $78,750 $60,000 Income from operations $57,971...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
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 $756,616 $674,000 Cost of goods sold 541,800 430,000 Gross profit $214,816 $244,000 Selling expenses $75,530 $57,000 Administrative expenses 44,420 36,000 Total operating expenses $119,950 $93,000 Income from operations $94,866...
For 2016, Indigo Company initiated a sales promotion campaign that included the expenditure of an additional...
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 $940,000.00 $540,000.00 3 Cost of goods sold 338,400.00 205,200.00 4 Gross profit $601,600.00 $334,800.00 5 Selling expenses $159,800.00 $81,000.00 6 Administrative expenses 47,000.00...
please show example through Excel Vertical Analysis of Income Statement For 2014, Othere Technology Company initiated...
please show example through Excel Vertical Analysis of Income Statement For 2014, Othere Technology Company initiated a sales promotion campaign that included the expenditure of an additional $15,000 for advertising. At the end of the year, George Wallace, the president, is presented with the following condensed comparative income statement: Othere Technology Company Comparative Income Statement For the Years Ended December 31, 2014 and 2013 2014 2013 Sales $529,240 $455,510 Sales returns and allowances 5,240 4,510 Net sales $524,000 $451,000 Cost...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent...
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 $583,000 $531,000 Cost of goods sold 332,310 276,120 Selling expenses 99,110 100,890 Administrative expenses 110,770 90,270 Income tax expense 17,490 26,550 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...
Vertical Analysis of Income Statement Revenue and expense data for Rogan Technologies Co. are as follows:...
Vertical Analysis of Income Statement Revenue and expense data for Rogan Technologies Co. are as follows: 20Y8 20Y7 Sales $599,000 $539,000 Cost of goods sold 353,410 291,060 Selling expenses 95,840 97,020 Administrative expenses 107,820 118,580 Income tax expense 23,960 10,780 a. Prepare an income statement in comparative form, stating each item for both 20Y8 and 20Y7 as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as a positive number. Rogan Technologies Co. Comparative...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent...
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 $435,000 $396,000 Cost of goods sold 269,700 221,760 Selling expenses 65,250 71,280 Administrative expenses 73,950 59,400 Income tax expense 8,700 15,840 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. (For...