Question

In: Accounting

Horizontal Analysis of the Income Statement Income statement data for Boone Company for two recent years...

  1. Horizontal Analysis of the Income Statement

    Income statement data for Boone Company for two recent years ended December 31, are as follows:

        Current Year     Previous Year
    Sales $533,400 $420,000
    Cost of goods sold 434,000 350,000
    Gross profit $99,400 $70,000
    Selling expenses $29,250 $25,000
    Administrative expenses 26,250 21,000
    Total operating expenses $55,500 $46,000
    Income before income tax $43,900 $24,000
    Income tax expenses 17,600 9,600
    Net income $26,300 $14,400

    a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.

    Boone Company
    Comparative Income Statement
    For the Years Ended December 31
    Current year Amount Previous year Amount Increase (Decrease) Amount Increase (Decrease) Percent
    Sales $533,400 $420,000 $ %
    Cost of goods sold 434,000 350,000 %
    Gross profit $99,400 $70,000 $ %
    Selling expenses 29,250 25,000 %
    Administrative expenses 26,250 21,000 %
    Total operating expenses $55,500 $46,000 $ %
    Income before income tax $43,900 $24,000 $ %
    Income tax expense 17,600 9,600 %
    Net income $26,300 $14,400 $ %

    Feedback

    a. Show the difference in each line item amount as either an increase or a decrease. Divide each difference by the base year amount for that item to obtain the horizontal percentage.

    Learning Objective 2

    b. The net income for Boone Company increased by 82.6% between years. This increase was the combined result of an increase

    • increase
    • decrease
    in sales of 27% and higher
    • higher
    • lower
    percentage increase
    • increase
    • decrease
    in cost of goods sold. The cost of goods sold increased at a slower
    • slower
    • faster
    rate than the increase in sales, thus causing the percentage increase in gross profit to be greater
    • greater
    • less
    than the percentage increase in sales.

    Feedback

    b. Review the relationship the accounts have and the effect the differences show about the business.

    Learning Objective 2

    Feedback

    Partially correct

Loading item

There was an error loading this item. If this continues to occur, please contact Technical Support.

Check My Work1 more Check My Work uses remaining.

  • Previous
  • Next
  • 100% Correct
  • Partially Correct
  • Incorrect
  • Needs Instructor Grading

Basic Calculatorclose

0

UseEntBSBSpCEHomCEnd

789+

456-

123*

0.=/

Solutions

Expert Solution

  • [1]

Boone Company

Comparative Income Statement

For the Years Ended December 31

Current year Amount

Previous year Amount

Increase (Decrease) Amount

Increase (Decrease) Percent

[A]

[B]

[C = A- B]

[D = (C/B) x 100

Sales

$533,400

$420,000

$113,400

27.0%

Cost of goods sold

$434,000

$350,000

$84,000

24.0%

Gross profit

$99,400

$70,000

$29,400

42.0%

Selling expenses

$29,250

$25,000

$4,250

17.0%

Administrative expenses

$26,250

$21,000

$5,250

25.0%

Total operating expenses

$55,500

$46,000

$9,500

20.7%

Income before income tax

$43,900

$24,000

$19,900

82.9%

Income tax expense

$17,600

$9,600

$8,000

83.3%

Net income

$26,300

$14,400

$11,900

82.6%

  • [2]

The net income for Boone Company increased by 82.6% between years. This increase was the combined result of an increase in sales of 27% and lower

percentage increase in cost of goods sold. The cost of goods sold increased at a slower rate than the increase in sales, thus causing the percentage increase in gross profit to be greater than the percentage increase in sales.


Related Solutions

Horizontal Analysis of the Income Statement Income statement data for Boone Company for two recent years...
Horizontal Analysis of the Income Statement Income statement data for Boone Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $546,000 $420,000 Cost of goods sold 473,600 370,000 Gross profit $72,400 $50,000 Selling expenses $21,600 $18,000 Administrative expenses 19,200 15,000 Total operating expenses $40,800 $33,000 Income before income tax $31,600 $17,000 Income tax expenses 12,600 6,800 Net income $19,000 $10,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 two recent years...
Horizontal Analysis of the Income Statement Income statement data for Boone Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $488,000 $400,000 Cost of goods sold 420,000 350,000 Gross profit $68,000 $50,000 Selling expenses $19,040 $17,000 Administrative expenses 16,800 14,000 Total operating expenses $35,840 $31,000 Income before income tax $32,160 $19,000 Income tax expenses 12,900 7,600 Net income $19,260 $11,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
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 $925,000 $740,000 Cost of goods sold 780,800 640,000 Gross profit $144,200 $100,000 Selling expenses $41,400 $36,000 Administrative expenses 36,900 30,000 Total operating expenses $78,300 $66,000 Income before income tax $65,900 $34,000 Income tax expenses 26,400 13,600 Net income $39,500 $20,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
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 $806,000 $650,000 Cost of goods sold 683,200 560,000 Gross profit $122,800 $90,000 Selling expenses $35,340 $31,000 Administrative expenses 31,720 26,000 Total operating expenses $67,060 $57,000 Income before income tax $55,740 $33,000 Income tax expenses 22,300 13,200 Net income $33,440 $19,800 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
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 $806,000 $650,000 Cost of goods sold 683,200 560,000 Gross profit $122,800 $90,000 Selling expenses $35,340 $31,000 Administrative expenses 31,720 26,000 Total operating expenses $67,060 $57,000 Income before income tax $55,740 $33,000 Income tax expenses 22,300 13,200 Net income $33,440 $19,800 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
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 $496,100 $410,000 Cost of goods sold 413,000 350,000 Gross profit $83,100 $60,000 Selling expenses $23,310 $21,000 Administrative expenses 20,230 17,000 Total operating expenses $43,540 $38,000 Income before income tax $39,560 $22,000 Income tax expenses 15,800 8,800 Net income $23,760 $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 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 $864,000 $720,000 Cost of goods sold 731,600 620,000 Gross profit $132,400 $100,000 Selling expenses $36,300 $33,000 Administrative expenses 33,040 28,000 Total operating expenses $69,340 $61,000 Income before income tax $63,060 $39,000 Income tax expenses 25,200 15,600 Net income $37,860 $23,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
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 $725,000 $580,000 Cost of goods sold 597,800 490,000 Gross profit $127,200 $90,000 Selling expenses $36,800 $32,000 Administrative expenses 33,210 27,000 Total operating expenses $70,010 $59,000 Income before income tax $57,190 $31,000 Income tax expenses 22,900 12,400 Net income $34,290 $18,600 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
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 $736,600 $580,000 Cost of goods sold 607,600 490,000 Gross profit $129,000 $90,000 Selling expenses $37,440 $32,000 Administrative expenses 33,750 27,000 Total operating expenses $71,190 $59,000 Income before income tax $57,810 $31,000 Income tax expenses 23,100 12,400 Net income $34,710 $18,600 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
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 $800,000 $640,000 Cost of goods sold 676,500 550,000 Gross profit $123,500 $90,000 Selling expenses $35,650 $31,000 Administrative expenses 31,980 26,000 Total operating expenses $67,630 $57,000 Income before income tax $55,870 $33,000 Income tax expenses 22,300 13,200 Net income $33,570 $19,800 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT