Question

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 Quarter Inc.
Comparative Income Statement
For the Years Ended December 31
Current year Amount Current year Percent Previous year Amount Previous year Percent
Sales $523,000 fill in the blank a10abe045ffe07e_1% $450,000 fill in the blank a10abe045ffe07e_2%
Cost of goods sold 277,190 fill in the blank a10abe045ffe07e_3% 207,000 fill in the blank a10abe045ffe07e_4%
$fill in the blank a10abe045ffe07e_6 fill in the blank a10abe045ffe07e_7% $fill in the blank a10abe045ffe07e_8 fill in the blank a10abe045ffe07e_9%
Selling expenses 99,370 fill in the blank a10abe045ffe07e_10% 99,000 fill in the blank a10abe045ffe07e_11%
Administrative expenses 104,600 fill in the blank a10abe045ffe07e_12% 85,500 fill in the blank a10abe045ffe07e_13%
$fill in the blank a10abe045ffe07e_15 fill in the blank a10abe045ffe07e_16% $fill in the blank a10abe045ffe07e_17 fill in the blank a10abe045ffe07e_18%
fill in the blank a10abe045ffe07e_20 fill in the blank a10abe045ffe07e_21% fill in the blank a10abe045ffe07e_22 fill in the blank a10abe045ffe07e_23%
Income tax expense 15,690 fill in the blank a10abe045ffe07e_24% 22,500 fill in the blank a10abe045ffe07e_25%
$fill in the blank a10abe045ffe07e_27 fill in the blank a10abe045ffe07e_28% $fill in the blank a10abe045ffe07e_29 fill in the blank a10abe045ffe07e_30%

b. The vertical analysis indicates that the cost of goods sold as a percent of sales   by 7 percentage points, while selling expenses   by 3 percentage points, and administrative expenses   by 1 percentage points. Thus, net income as a percent of sales   by 3 percentage points.

Homework Answers

Answer #1
Innovation Quarter Inc.
Comparative Income Statement
For the Years Ended December 31
Current year Amount Current year Percent Previous year Amount Previous year Percent
Sales 523000 100.0% 450000 100.0%
Cost of goods sold 277190 53.0% 207000 46.0%
Gross profit 245810 47.0% 243000 54.0%
Selling expenses 99370 19.0% 99000 22.0%
Administrative expenses 104600 20.0% 85500 19.0%
Total operating expenses 203970 39.0% 184500 41.0%
Income from operations 41840 8.0% 58500 13.0%
Income tax expense 15690 3.0% 22500 5.0%
Net income 26150 5.0% 36000 8.0%
b
The vertical analysis indicates that the cost of goods sold as a percent of sales increased by 7 percentage points, while selling expenses decreased by 3 percentage points, and administrative expenses increased by 1 percentage points Thus, net income as a percent of sales decreased by 3 percentage points.
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
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...
6. Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two...
6. 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 $554,000 $499,000 Cost of goods sold 326,860 269,460 Selling expenses 88,640 89,820 Administrative expenses 99,720 84,830 Income tax expense 16,620 19,960 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....
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...
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current...
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $4,000,000 $3,600,000 Cost of goods sold 2,280,000 1,872,000 Selling expenses 600,000 648,000 Administrative expenses 520,000 360,000 Income tax expense 240,000 216,000 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.
Vertical Analysis of Income Statement Revenue and expense data for Rogan Technologies Co. are as follows:...
Vertical Analysis of Income Statement Revenue and expense data for Rogan Technologies Co. are as follows: 20Y8 20Y7 Sales $599,000 $539,000 Cost of goods sold 353,410 291,060 Selling expenses 95,840 97,020 Administrative expenses 107,820 118,580 Income tax expense 23,960 10,780 a. Prepare an income statement in comparative form, stating each item for both 20Y8 and 20Y7 as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as a positive number. Rogan Technologies Co. Comparative...
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)...
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 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...
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...