In: Accounting
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.