Revenue and expense data for Innovation Quarter Inc. for two recent years are as
ID: 2438364 • Letter: R
Question
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales Cost of goods sold Selling expenses Administrative expenses Income tax expense $496,000 302,560 79,360 79,360 14,880 $441,000 246,960 79,380 66,150 17,640 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 $441,000 246,960 Sales $496,000 Cost of goods sold 302,560 Selling expenses 79,360 79,380 Administrative expenses _79,360 66,150 Income tax expense 14,880 17,640 b. The vertical analysis indicates that the cost of goods sold as a percent of sales while selling expenses points. Thus, net income as a percent of sales by 5 percentage points, by 2 percentage points, and administrative expenses by 1 percentage by 3 percentage points.Explanation / Answer
Answers
Current Year Amount
Current year %
Previous Year Amount
Previous year %
Sales
$ 496,000.00
100.0%
$ 441,000.00
100.0%
Cost of Goods Sold
$ 302,560.00
61.0%
$ 246,960.00
56.0%
Gross Profits
$ 193,440.00
39.0%
$ 194,040.00
44.0%
Selling Expenses
$ 79,360.00
16.0%
$ 79,380.00
18.0%
Administrative expenses
$ 79,360.00
16.0%
$ 66,150.00
15.0%
Total Operating Expenses
$ 158,720.00
32.0%
$ 145,530.00
33.0%
Operating Income - Before taxes
$ 34,720.00
7.0%
$ 48,510.00
11.0%
Income tax expense
$ 14,880.00
3.0%
$ 17,640.00
4.0%
Net Income -after taxes
$ 19,840.00
4.0%
$ 30,870.00
7.0%
The vertical analysis indicates that the cost of goods sold as a percent of Sale INCREASED by 5% points, while Selling expenses DECREASED by 2% points and administrative expenses INCREASED by 1% points. Thus Net Income as a percent of sales DECREASED by 3% points.
Current Year Amount
Current year %
Previous Year Amount
Previous year %
Sales
$ 496,000.00
100.0%
$ 441,000.00
100.0%
Cost of Goods Sold
$ 302,560.00
61.0%
$ 246,960.00
56.0%
Gross Profits
$ 193,440.00
39.0%
$ 194,040.00
44.0%
Selling Expenses
$ 79,360.00
16.0%
$ 79,380.00
18.0%
Administrative expenses
$ 79,360.00
16.0%
$ 66,150.00
15.0%
Total Operating Expenses
$ 158,720.00
32.0%
$ 145,530.00
33.0%
Operating Income - Before taxes
$ 34,720.00
7.0%
$ 48,510.00
11.0%
Income tax expense
$ 14,880.00
3.0%
$ 17,640.00
4.0%
Net Income -after taxes
$ 19,840.00
4.0%
$ 30,870.00
7.0%
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.