Question

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 $97,000
Other revenue 2,291 1,800
Income before income tax $60,262 $98,800
Income tax expense 16,900 29,600
Net income $43,362 $69,200

Required:

1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round percentages to one decimal place. Use the minus sign to indicate a decrease in the "Increase (Decrease)" columns.

McDade Company
Comparative Income Statement
For the Years Ended December 31, 20Y2 and 20Y1
20Y2 20Y1 Difference - Amount Difference - Percent
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 $97,000 $ %
Other revenue 2,291 1,800 %
Income before income tax $60,262 $98,800 $ %
Income tax expense 16,900 29,600 %
Net income $43,362 $69,200 $ %

2. Net income has   from 20Y1 to 20Y2. Sales have  ; however, the cost of goods sold has  , causing the gross profit to  .

Homework Answers

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
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 $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...
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...
PR 17-1B Horizontal analysis of income statement OBJ. 2 For 20Y2, Macklin Inc. reported a significant...
PR 17-1B Horizontal analysis of income statement OBJ. 2 For 20Y2, Macklin Inc. reported a significant increase in net income. At the end of the year, John Mayer, the president, is presented with the following condensed comparative income statement: Macklin Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 Sales................................................................. Costofgoodssold..................................................... Grossprofit........................................................... Sellingexpenses...................................................... Administrativeexpenses............................................... Totaloperatingexpenses .............................................. Incomefromoperations............................................... Otherrevenue........................................................ Incomebeforeincometax ............................................. Incometaxexpense................................................... Netincome........................................................... Instructions 20Y2 $910,000 441,000 $469,000 $ 139,150 99,450 $238,600 $230,400 65,000 $295,400 65,000 $230,400...
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 the Income Statement Income statement data for Winthrop Company for two recent years...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $550,000 $440,000 Cost of goods sold 467,400 380,000 Gross profit $82,600 $60,000 Selling expenses $24,150 $21,000 Administrative expenses 20,910 17,000 Total operating expenses $45,060 $38,000 Income before income tax $37,540 $22,000 Income tax expenses 15,000 8,800 Net income $22,540 $13,200 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
Horizontal Analysis of the Income Statement Income statement data for Boone Company for the years ended...
Horizontal Analysis of the Income Statement Income statement data for Boone Company for the years ended December 31, 20Y5 and 20Y4, are as follows:     20Y5     20Y4 Sales $487,500 $390,000 Cost of goods sold (414,800) (340,000) Gross profit $72,700 $50,000 Selling expenses $(20,700) $(18,000) Administrative expenses (18,450) (15,000) Total operating expenses $(39,150) $(33,000) Income before income tax $33,550 $17,000 Income tax expenses (13,400) (6,800) Net income $20,150 $10,200 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
For 2016, Clapton Company reported a decline in net income. At the end of the year,...
For 2016, Clapton Company reported a decline in net income. At the end of the year, S. Hand, the president, is presented with the following condensed comparative income statement: Clapton Company Comparative Income Statement For the Years Ended December 31, 2016 and 2015 1 2016 2015 2 Sales $6,787,200.00 $6,060,000.00 3 Cost of goods sold 2,444,200.00 2,020,000.00 4 Gross profit $4,343,000.00 $4,040,000.00 5 Selling expenses $1,125,000.00 $900,000.00 6 Administrative expenses 711,200.00 560,000.00 7 Total operating expenses $1,836,200.00 $1,460,000.00 8 Income...
Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Sales $...
Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Sales $ 2,579,820 $ 2,376,910 Cost of goods sold 950,460 874,420 Gross profit $ 1,629,360 $ 1,502,490 Selling expenses $ 558,100 $ 695,720 Administrative expenses 475,420 408,590 Total operating expenses 1,033,520 1,104,310 Income from operations $ 595,840 $ 398,180 Other income 31,360 25,420 $ 627,200 $ 423,600 Other expense (interest) 184,000 101,600 Income before income tax $ 443,200 $ 322,000 Income tax expense 53,200 38,300 Net...