Ncome statement data for winthrop company for two recent years ended december 31 are as follows: current year previous year

sales $2,280,000 $2,000,000

cost of goods sold 1,960,000 1,750,000

gross profit $320,000 $250,000

selling expenses $156,500 $125,000

administrative expenses 122,000 100,000

total operating expenses $278,500 $225,000

income before income tax $41,500 $25,000

income tax expense 16,600 10,000

net income $24,900 $15,000

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.)
what conclusions can be drawn from the horizontal analysis?

Answer is attached in the excel file.

Explanation:

Sales have increased by 280,000 in the current year which shows a difference of 14%, this seems to be result of increased no of units sold or selling price increase.

The Cost of Goods sold is increased by 210,000 which makes 12% difference. This is 2% less than rise in sales which means the increase in sales is due to selling price increase.

As a result of this Gross Profit has also increased by 70,000 which is 28% rise.

Selling expense increased by 25% which is due to increased marketing of the product which increased sales.

Admin expense increased by 22%, might be due to increase in salary expense of the staff.

Income before Income tax is increased by 66%, Income tax is increased by 66% and also Net Income increased by 66%.