Question

In: Accounting

Income statement data for Winthrop Company for two recent years ended December 31 are as follows:...

Income statement data for Winthrop Company for two recent years ended December 31 are as follows: 1 Current Year Previous Year 2 Sales $1,938,000.00 $1,700,000.00 3 Cost of goods sold 1,608,200.00 1,462,000.00 4 Gross profit $329,800.00 $238,000.00 5 Selling expenses $67,800.00 $60,000.00 6 Administrative expenses 49,280.00 44,000.00 7 Total operating expenses $117,080.00 $104,000.00 8 Income before income tax $212,720.00 $134,000.00 9 Income tax expense 13,090.00 8,500.00 10 Net income $199,630.00 $125,500.00 A. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. Round percentages to one decimal place. B. What conclusions can be drawn from the horizontal analysis? Round the answers to one decimal place.

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

Winthrop Company

Comparative Income Statement

For the Years Ended December 31

1

Increase (Decrease)

Increase (Decrease)

2

Current Year

Previous Year

Amount

Percent

3

Sales

$1,938,000.00

$1,700,000.00

4

Cost of goods sold

1,608,200.00

1,462,000.00

5

Gross profit

$329,800.00

$238,000.00

6

Selling expenses

$67,800.00

$60,000.00

7

Administrative expenses

49,280.00

44,000.00

8

Total operating expenses

$117,080.00

$104,000.00

9

Income before income tax

$212,720.00

$134,000.00

10

Income tax expense

13,090.00

8,500.00

11

Net income

$199,630.00

$125,500.00

What conclusions can be drawn from the horizontal analysis? Round the answers to one decimal place.

The net income for Winthrop Company increased by % between years. This increase was the combined result of an   in sales of % and     percentage     in cost of goods sold.

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

Solutions

Expert Solution


Related Solutions

Income statement data for Winthrop Company for two recent years ended December 31, are as follows:...
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $799,100 $610,000 Cost of goods sold 665,600 520,000 Gross profit $133,500 $90,000 Selling expenses $39,930 $33,000 Administrative expenses 36,120 28,000 Total operating expenses $76,050 $61,000 Income before income tax $57,450 $29,000 Income tax expenses 23,000 11,600 Net income $34,450 $17,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared...
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:...
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $372,000 $310,000 Cost of goods sold 318,600 270,000 Gross profit $53,400 $40,000 Selling expenses $14,300 $13,000 Administrative expenses 12,980 11,000 Total operating expenses $27,280 $24,000 Income before income tax $26,120 $16,000 Income tax expenses 10,400 6,400 Net income $15,720 $9,600 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared...
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:...
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $458,500    $350,000 Cost of goods sold 384,000 300,000 Gross profit $74,500 $50,000 Selling expenses $22,990 $19,000 Administrative expenses 20,640 16,000 Total operating expenses $43,630 $35,000 Income before income tax $30,870 $15,000 Income tax expenses 12,300 6,000 Net income $18,570 $9,000 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when...
Income statement data for Winthrop Company for two recent years ended December 31 are as follows:...
Income statement data for Winthrop Company for two recent years ended December 31 are as follows: Question not attempted. 1 Current Year Previous Year 2 Sales $1,836,800.00 $1,640,000.00 3 Cost of goods sold 1,556,442.00 1,402,200.00 4 Gross profit $280,358.00 $237,800.00 5 Selling expenses $79,800.00 $70,000.00 6 Administrative expenses 48,840.00 44,000.00 7 Total operating expenses $128,640.00 $114,000.00 8 Income before income tax $151,718.00 $123,800.00 9 Income tax expense 12,300.00 8,200.00 10 Net income $139,418.00 $115,600.00 A. Prepare a comparative income statement...
Income statement data for Winthrop Company for two recent years ended December 31 are as follows:...
Income statement data for Winthrop Company for two recent years ended December 31 are as follows: 1 Current Year Previous Year 2 Sales $2,280,000.00 $2,000,000.00 3 Cost of goods sold 1,960,000.00 1,750,000.00 4 Gross profit $320,000.00 $250,000.00 5 Selling expenses $156,500.00 $125,000.00 6 Administrative expenses 122,000.00 100,000.00 7 Total operating expenses $278,500.00 $225,000.00 8 Income before income tax $41,500.00 $25,000.00 9 Income tax expense 16,600.00 10,000.00 10 Net income $24,900.00 $15,000.00 A. Prepare a comparative income statement with horizontal analysis,...
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)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT