Question

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) for the current year when compared with the previous year. If required, round to one decimal place.

Winthrop Company
Comparative Income Statement
For the Years Ended December 31
Current
year
Amount
Previous
year
Amount
Increase
(Decrease)
Amount
Increase
(Decrease)
Percent
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 expense 15,000 8,800 %
Net income $22,540 $13,200 $ %

b. The net income for Winthrop Company increased by 70.8% between years. This increase was the combined result of an in sales of 25% 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.

Homework Answers

Answer #1

statement showing comparative income statement

Particulars CY(A) PY(B) CHANGE(C=A-B) PERCENT(C/B*100)
sales 550000 440000 110000 25%
cost of goods sold 467400 380000 87400 23%
gross profit 82600 60000 22600 37.7%
selling expense 24150 21000 3150 15%
administrative expense 20910 17000 3910 23%
total operating cost 45060 38000 7060 18.6%
income before income tax 37540 22000 15540 70.6%
income tax expense 15000 8800 6200 70.5%
net income 22540 13200 9340 70.8%

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

Note:Part b of question is not properly framed or copied from text book ,although i have solved by assuming there is fill in the blank .

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
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 $1,016,400 $770,000 Cost of goods sold 845,000 650,000 Gross profit $171,400 $120,000 Selling expenses $52,460 $43,000 Administrative expenses 46,800 36,000 Total operating expenses $99,260 $79,000 Income before income tax $72,140 $41,000 Income tax expenses 28,900 16,400 Net income $43,240 $24,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: 1 Current Year Previous Year 2 Sales $1,846,800.00 $1,620,000.00 3 Cost of goods sold 1,541,430.00 1,401,300.00 4 Gross profit $305,370.00 $218,700.00 5 Selling expenses $80,500.00 $70,000.00 6 Administrative expenses 50,600.00 46,000.00 7 Total operating expenses $131,100.00 $116,000.00 8 Income before income tax $174,270.00 $102,700.00 9 Income tax expense 12,960.00 8,100.00 10 Net income $161,310.00 $94,600.00 A. Prepare a comparative income statement with horizontal analysis,...
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 $838,200 $660,000 Cost of goods sold 706,800 570,000 Gross profit $131,400 $90,000 Selling expenses $38,610 $33,000 Administrative expenses 35,000 28,000 Total operating expenses $73,610 $61,000 Income before income tax $57,790 $29,000 Income tax expenses 23,100 11,600 Net income $34,690 $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 Boone Company for two recent years ended December 31, are as follows:...
Income statement data for Boone Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $396,000 $330,000 Cost of goods sold 330,400 280,000 Gross profit $65,600 $50,000 Selling expenses $17,600 $16,000 Administrative expenses 16,520 14,000 Total operating expenses $34,120 $30,000 Income before income tax $31,480 $20,000 Income tax expenses 12,600 8,000 Net income $18,880 $12,000 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared...
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)...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:        Current Year        Previous Year Sales $583,000 $531,000 Cost of goods sold 332,310 276,120 Selling expenses 99,110 100,890 Administrative expenses 110,770 90,270 Income tax expense 17,490 26,550 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:        Current Year        Previous Year Sales $435,000 $396,000 Cost of goods sold 269,700 221,760 Selling expenses 65,250 71,280 Administrative expenses 73,950 59,400 Income tax expense 8,700 15,840 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. (For...
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...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:        Current Year        Previous Year Sales $523,000 $450,000 Cost of goods sold 277,190 207,000 Selling expenses 99,370 99,000 Administrative expenses 104,600 85,500 Income tax expense 15,690 22,500 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation...
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT