Accounting
27th Edition
ISBN: 9781337272094
Author: WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Question
Chapter 17, Problem 17.2EX
1.
To determine
Vertical Analysis
Vertical analysis is prepared to analyze the relationship among various financial statements with a particular base amount.
Formula:
This analysis is otherwise called as common-size statement.
To prepare: Comparative income statement for the two-year period.
Given info: Income statement for the two year period.
2.
To determine
To comment: Significant relationships revealed by the vertical analysis.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Perform ratio analysis to the financial statements
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
$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. Round to the nearest whole percentage.
Innovation Quarter Inc.
Comparative Income Statement
For the Years Ended December 31
Current yearAmount
Current yearPercent
Previous yearAmount
Previous yearPercent
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)
%
$
%
$
%
b.…
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
$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.
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
$4,000,000
fill in the blank f86a69fccf96045_1%
$3,600,000
fill in the blank f86a69fccf96045_2%
Cost of goods sold
2,280,000
fill in the blank f86a69fccf96045_3%
1,872,000
fill in the blank f86a69fccf96045_4%
$fill…
Chapter 17 Solutions
Accounting
Ch. 17 - Prob. 1DQCh. 17 - Prob. 2DQCh. 17 - A companys current year net income (after income...Ch. 17 - How would the current and quick ratios of a...Ch. 17 - Prob. 5DQCh. 17 - What do the following data, taken from a...Ch. 17 - a. How does the return on total assets differ from...Ch. 17 - Kroger, a grocery store, recently had a price-...Ch. 17 - Prob. 9DQCh. 17 - Prob. 10DQ
Ch. 17 - Horizontal analysis The comparative temporary...Ch. 17 - Prob. 17.1BPECh. 17 - Vertical analysis Income statement information for...Ch. 17 - Vertical analysis Income statement information for...Ch. 17 - Prob. 17.3APECh. 17 - Prob. 17.3BPECh. 17 - Accounts receivable analysis A company reports the...Ch. 17 - Accounts receivable analysis A company reports the...Ch. 17 - Inventory analysis A company reports the...Ch. 17 - Inventory analysis A company reports the...Ch. 17 - Prob. 17.6APECh. 17 - Long-term solvency analysis The following...Ch. 17 - Times interest earned A company reports the...Ch. 17 - Times interest earned A company reports the...Ch. 17 - Asset turnover A company reports the following:...Ch. 17 - Asset turnover A company reports the following:...Ch. 17 - Return on total assets A company reports the...Ch. 17 - Return on total assets A company reports the...Ch. 17 - Common stockholders profitability analysis A...Ch. 17 - Common stockholders profitability analysis A...Ch. 17 - Prob. 17.11APECh. 17 - Prob. 17.11BPECh. 17 - Prob. 17.1EXCh. 17 - Prob. 17.2EXCh. 17 - Common-sized income statement Revenue and expense...Ch. 17 - Vertical analysis of balance sheet Balance sheet...Ch. 17 - Horizontal analysis of the income statement Income...Ch. 17 - Current position analysis The following data were...Ch. 17 - Prob. 17.7EXCh. 17 - Current position analysis The bond indenture for...Ch. 17 - Accounts receivable analysis The following data...Ch. 17 - Accounts receivable analysis Xavier Scores Company...Ch. 17 - Inventory analysis The following data were...Ch. 17 - Inventory analysis QT, Inc. and Elppa Computers,...Ch. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Prob. 17.16EXCh. 17 - Profitability ratios The following selected data...Ch. 17 - Profitability ratios Ralph Lauren Corporation...Ch. 17 - Six measures of solvency or profitability The...Ch. 17 - Five measures of solvency or profitability The...Ch. 17 - Prob. 17.21EXCh. 17 - Prob. 17.22EXCh. 17 - Earnings per share, discontinued operations The...Ch. 17 - Prob. 17.24EXCh. 17 - Prob. 17.25EXCh. 17 - Prob. 17.1APRCh. 17 - Prob. 17.2APRCh. 17 - Prob. 17.3APRCh. 17 - Measures of liquidity, solvency, and profitability...Ch. 17 - Solvency and profitability trend analysis Addai...Ch. 17 - Prob. 17.1BPRCh. 17 - Prob. 17.2BPRCh. 17 - Effect of transactions on current position...Ch. 17 - Measures of liquidity, solvency and profitability...Ch. 17 - Solvency and profitability trend analysis Crosby...Ch. 17 - Financial statement analysis The financial...Ch. 17 - Prob. 17.1CPCh. 17 - Prob. 17.3CPCh. 17 - Common-sized income statements The condensed...Ch. 17 - Profitability analysis Deere Company manufactures...Ch. 17 - Comprehensive profitability and solvency analysis...
Knowledge Booster
Similar questions
- Common-Sized Income Statement Revenue and expense data for the current calendar year for Sorenson Electronics Company and for the electronics industry are as follows. Sorenson Electronics Company data are expressed in dollars. The electronics industry averages are expressed in percentages. SorensonElectronicsCompany ElectronicsIndustryAverage Sales $1,940,000 100 % Cost of goods sold (1,358,000) (76) Gross profit $582,000 24 % Selling expenses $(329,800) (9) % Administrative expenses (116,400) (9) Total operating expenses $(446,200) (18) % Operating income $135,800 6 % Other revenue and expense: Other revenue 38,800 4 Other expense (19,400) (3) Income before income tax $155,200 7 % Income tax expense (58,200) (5) Net income $97,000 2 % a. Prepare a common-sized income statement comparing the results of operations for Sorenson Electronics Company with the industry average. If…arrow_forwardRevenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous YearSales $4,000,000 $3,600,000Cost of goods sold 2,280,000 1,872,000Selling expenses 600,000 648,000Administrative expenses 520,000 360,000Income tax expense 240,000 216,000a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round to the nearest whole percentage.b. Comment on the significant changes disclosed by the comparative income statement.arrow_forwardRevenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $ 2,580,000 $3,550,000 Cost of goods sold 1,578,960 1,938,300 Selling expenses 304,440 546,700 Administrative expenses 397,320 440,200 Income tax expense 134,160 198,800 A. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round your percentages answers to one decimal place. Enter all amounts as positive numbers. B. Comment on the significant changes disclosed by the comparative income statement.arrow_forward
- b. The vertical analysis indicates that the cost of goods sold as a percent of sales by 8 percentage points, while selling expenses - by 4 percentage points, and administrative expenses by 1 percentage points. Thus, net income as a percent of sales by 3 percentage points.arrow_forwardVertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $457,000 $407,000 Cost of goods sold 283,340 231,990 Selling expenses 68,550 69,190 Administrative expenses 77,690 65,120 Income tax expense 9,140 16,280 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 $457,000 % $407,000 % Cost of goods sold 283,340 231,990 % % % Selling expenses 68,550 % 69,190 Administrative expenses 77,690 % 65,120 % % % % % Income tax expense 9,140 % 16,280 % % % b. The vertical analysis indicates that the cost of goods sold as a percent of sales by 5 percentage points, while selling…arrow_forwardVertical analysisarrow_forward
- Ratio Analysis of Comparative Financial Statements Amounts from the comparative income statement and balance sheet of Miller Electronics Corporation for the last two years are as follows: Miller Electronics CorporationComparative Income StatementFor Years Ended December 31, 20-2 and 20-1 20-2 20-1 Net Sales (all on account) $643,800 $415,800 Cost of goods sold 387,260 254,650 Gross profit $256,540 $161,150 Administrative expenses $63,715 $41,626 Selling expenses 66,780 44,317 Total operating expenses $130,495 $85,943 Operating income $126,045 $75,207 Interest expense 1,316 1,241 Income before income taxes $124,729 $73,966 Income tax expense 30,895 13,143 Net income $93,834 $60,823 Miller Electronics CorporationComparative Balance SheetDecember 31, 20-2 and 20-1 20-2 20-1 Assets Current assets: Cash $42,848…arrow_forwardRevenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $ 2,920,000 $2,150,000 Cost of goods sold 1,769,520 1,182,500 Selling expenses 332,880 322,500 Administrative expenses 449,680 279,500 Income tax expense 169,360 116,100 A. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round your percentages answers to one decimal place. Enter all amounts as positive numbers. B. Comment on the significant changes disclosed by the comparative income statement. Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31 1 Current year Current year Previous year Previous year 2 Amount Percent Amount Percent 3 Sales $2,920,000.00 $2,150,000.00 4 Cost of goods sold 1,769,520.00 1,182,500.00 5 Gross profit $1,150,480.00…arrow_forwardVertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous YearSales $4,000,000 $3,600,000Cost of merchandise sold 2,280,000 1,872,000Selling expenses 600,000 648,000Administrative expenses 520,000 360,000Income tax expense 240,000 216,000a. 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.arrow_forward
- Horizontal Analysis of Comparative Financial Statements Amounts from the comparative income statement and balance sheet of Miller Electronics Corporation for the last two years are as follows: Miller Electronics CorporationComparative Income StatementFor Years Ended December 31, 20-2 and 20-1 20-2 20-1 Net Sales (all on account) $652,380 $415,280 Cost of goods sold 390,370 259,050 Gross profit $262,010 $156,230 Administrative expenses $63,250 $41,768 Selling expenses 65,883 43,889 Total operating expenses $129,133 $85,657 Operating income $132,877 $70,573 Interest expense 1,231 1,152 Income before income taxes $131,646 $69,421 Income tax expense 30,197 13,283 Net income $101,449 $56,138 Miller Electronics CorporationComparative Balance SheetDecember 31, 20-2 and 20-1 20-2 20-1 Assets Current assets: Cash $41,957…arrow_forwardHorizontal 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 $965,200 $760,000 Cost of goods sold 818,400 660,000 Gross profit $146,800 $100,000 Selling expenses $43,290 $37,000 Administrative expenses 38,750 31,000 Total operating expenses $82,040 $68,000 Income before income tax $64,760 $32,000 Income tax expenses 25,900 12,800 Net income $38,860 $19,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 Previous Increase Increase year year (Decrease) (Decrease) Amount Amount Amount Percent Sales $965,200 $760,000 % Cost of goods sold 818,400 660,000 % Gross profit $146,800 $100,000 % Selling expenses $43,290 $37,000 % Administrative…arrow_forwardCommon-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill's data are expressed in dollars. The electronics industry averages are expressed in percentages. TannenhillCompany ElectronicsIndustryAverage Sales $4,000,000 100.0 % Cost of goods sold (2,120,000) (60.0) Gross profit $1,880,000 40.0 % Selling expenses $(1,080,000) (24.0) % Administrative expenses (640,000) (14.0) Total operating expenses $(1,720,000) (38.0) % Operating income $160,000 2.0 % Other revenue and expense: Other revenue 120,000 3.0 Other expense (80,000) (2.0) Income before income tax expense $200,000 3.0 % Income tax expense (80,000) (2.0) Net income $120,000 1.0 % a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Corporate Financial AccountingAccountingISBN:9781337398169Author:Carl Warren, Jeff JonesPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Corporate Financial Accounting
Accounting
ISBN:9781337398169
Author:Carl Warren, Jeff Jones
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning