Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:Current YearPrevious YearSales$490,000$446,000Cost of merchandise sold289,100231,920Selling expenses78,40084,740Administrative expenses88,20075,820Income tax expense14,70022,300a. 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 StatementFor the Years Ended December 31Current year Amount Current year PercentPrevious year Amount Previous year PercentSales$490,000%$446,000%Cost of merchandise sold289,100%231,920%%%Selling expenses78,40084,740%Administrative expenses88,200%75,820%%%Income tax expense14,700%22,300%%%b. The vertical analysis indicates that the cost of merchandise sold as a percent of sales- by 7 percentage points, while selling expensesby 3 percentage points, and administrative expenses* by 1 percentage points. Thus, net income as apercent of sales- by 3 percentage points.

a. Statement of Comparative Income Statement Current Year Amount Percent Previous Year Amount…

Answered: The vertical analysis indicates that…

The vertical analysis indicates that the cost of merchandise sold as a percent of sales arcent of sales by 3 percentage points.

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 40E: Cuneo Companys income statements for the last 3 years are as follows: Refer to the information for...

See similar textbooks

Similar questions

Cuneo Companys income statements for the last 3 years are as follows: Refer to the information for Cuneo Company above. Required: 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 3. Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)
Cuneo Companys income statements for the last 3 years are as follows: Refer to the information for Cuneo Company above. Required: 1. Prepare a common-size income statement for Year 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 3 by expressing each line item for Year 3 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.)
Revenue and expense data for Gresham Inc. for two recent years are as follows: a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round to one decimal place. b. Comment on the significant changes disclosed by the comparative income statement.
Sundahl Companys income statements for the past 2 years are as follows: Refer to the information for Sundahl Company above. Required: Prepare a common-size income statement for Year 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.)
Jasmine Company provided the following income statements for its first 3 years of operation: Refer to the information for Jasmine Company above. Required: Prepare common-size income statements by using net sales as the base. (Note: Round answers to the nearest whole percentage.)
Scherer Company provided the following income statements for its first 3 years of operation: Refer to the information for Scherer Company on the previous page. Required: Prepare common-size income statements by using net sales as the base. (Note: Round answers to the nearest whole percentage.)
The following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.
The following data (in millions) were taken from the financial statements of Costco Wholesale Corporation: a. For Costco, determine the amount of change in millions and the percent of change (round to one decimal place) from the prior year to the recent year for: 1. Revenue 2. Operating expenses 3. Operating income b. Comment on the results of your horizontal analysis in part (a). c. Based upon Exercise 2-23, compare and comment on the operating results of Target and Costco for the recent year.
The following data (in millions) are taken from the financial statements of Target Corporation: a. For Target Corporation, determine the amount of change in millions and the percent of change (round to one decimal place) from the prior year to the recent year for: 1. Revenue 2. Operating expenses 3. Operating income b. What conclusions can you draw from your analysis of the revenue and the total operating expenses?
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $586,000 $527,000 Cost of merchandise sold 345,740 279,310 Selling expenses 93,760 100,130 Administrative expenses 105,480 89,590 Income tax expense 17,580 21,080. 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.
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $488,000 $415,000 Cost of goods sold 312,320 232,400 Selling expenses 68,320 74,700 Administrative expenses 78,080 62,250 Income tax expense 9,760 16,600 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 years are as follows: Previous Year Sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Current Year $447,000 272,670 71,520 71,520 13,410 $384,000 215,040 69,120 57,600 15,360