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.2BPR
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 horizontal analysis.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
. Prepare a comparative income statement for the two-year period, presenting a vertical analysis of each item in relationship to sales for each of the years.
Fishing Experiences Inc.Comparative Income StatementFor the Years Ended December 31, 20Y6 and 20Y5
20Y6 Amount
20Y6 Percent
20Y5 Amount
20Y5 Percent
Sales
$498,000
fill in the blank 1753e5018073ffe_1%
$428,000
fill in the blank 1753e5018073ffe_2%
Cost of goods sold
(268,920)
fill in the blank 1753e5018073ffe_3%
(196,880)
fill in the blank 1753e5018073ffe_4%
Gross profit
$229,080
fill in the blank 1753e5018073ffe_5%
$231,120
fill in the blank 1753e5018073ffe_6%
Selling expenses
$(114,540)
fill in the blank 1753e5018073ffe_7%
$(85,600)
fill in the blank 1753e5018073ffe_8%
Administrative expenses
(49,800)
fill in the blank 1753e5018073ffe_9%
(55,640)
fill in the blank 1753e5018073ffe_10%
Total operating expenses
$(164,340)
fill in the blank 1753e5018073ffe_11%
$(141,240)
fill in the blank 1753e5018073ffe_12%…
Vertical Analysis of Income Statement
For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $21,000 for advertising. At the end of the year, Lumi Neer, the president, is presented with the following condensed comparative income statement:
Tri-Comic CompanyComparative Income StatementFor the Years Ended December 31, 20Y2 and 20Y1
20Y2
20Y1
Sales
$741,000
$637,000
Cost of merchandise sold
348,270
337,610
Gross profit
$392,730
$299,390
Selling expenses
$148,200
$121,030
Administrative expenses
74,100
76,440
Total operating expenses
$222,300
$197,470
Income from operations
$170,430
$101,920
Other revenue
29,640
31,850
Income before income tax expense
$200,070
$133,770
Income tax expense
81,510
50,960
Net income
$118,560
$82,810
Required:
Question Content Area
1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in…
Vertical analysis of income statement
For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $50,000 for advertising. At the end of the year, Lumi Neer, the president, is presented with the following condensed comparative income statement:
Tri-Comic Company
Comparative Income Statement
For the Years Ended December 31, 20Y2 and 20Y1
20Y2
20Y1
Sales
$ 1,500,000
$ 1,250,000
Cost of goods sold
(510,000)
(475,000)
Gross profit
$ 990,000
$ 775,000
Selling expenses
$ (270,000)
$ (200,000)
Administrative expenses
(180,000)
(156,250)
Total operating expenses
$ (450,000)
$ (356,250)
Operating income
$ 540,000
$ 418,750
Other revenue
60,000
50,000
Income before income tax expense
$ 600,000
$ 468,750
Income tax expense
(450,000)
(375,000)
Net income
$ 150,000
$ 93,750
1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in relationship to sales for…
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
- Sundahl Companys income statements for the past 2 years are as follows: Refer to the information for Sundahl 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.)arrow_forwardCuneo 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.)arrow_forwardJuroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.arrow_forward
- 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.)arrow_forwardVertical analysis of income statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $50,000 for advertising. At the end of the year, Lumi Neer, the president, is presented with the following condensed comparative income statement: REFER IMAGE Instructions1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in relationship to sales for each of the years. (Round percentages to one decimal place.)2. To the extent the data permit, comment on the significant relationships revealed by the vertical analysis prepared in (1).arrow_forwardVertical analysis income statement Revenue expense data for Innovation quarter Inc for two recent years as follows. Sales Cost of goods. Selling expenses Administrative expenses Income tax expense Current year. 4,000,000 2,280,000 600,000 520,000 240,000 Previous year 3,600,000 1,872,000 648,000 360,000 216,000 A. Prepare an income statement in comparative form, stating to each item for both of years as a percent of sales. Round to the nearest whole percentage. Innovation quarter Inc comparative income tax for the years ended December 31st Sales Cost of goods Selling expenses Administrative expenses Income tax expense $ % $ % $ % $ % $ % $ % $ % $ % B. The vertical analysis indicates that the cost of the goods sold as a percent of sales by 5 percentage points, while selling expenses by 3% percentage and administrative expenses by 3% percentage points. Thus net income as…arrow_forward
- Vertical analysis of income statementFor 20Y2, Tri-Comic Company initiated a sales promotion campaign thatincluded the expenditure of an additional $50,000 for advertising. At theend of the year, Lumi Neer, the president, is presented with the attached condensed comparative income statement: Instructions 1. Prepare a comparative income statement for the two-yearperiod, presenting an analysis of each item in relationship to salesfor each of the years. (Round percentages to one decimal place.)2. To the extent the data permit, comment on the significantrelationships revealed by the vertical analysis prepared in (1).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_forwardb. 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_forward
- 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.…arrow_forwardRevenue and expense data for Young Technologies Inc. are as follows: Year 2 Year 1 Sales $500,000 $440,000 Cost of goods sold 325,000 242,000 Selling expense 70,000 79,200 Administrative expenses 75,000 70,400 Income tax expense 10,500 16,400 Required: Question Content Area a. Prepare an income statement in comparative form, stating each item for both years as an amount and as a percent of sales. Round percentage amounts to nearest whole percent. Young Technologies Inc.Comparative Income StatementFor the Years Ended December 31, Year 2 and Year 1 Year 2 Amount Year 2 Percent Year 1 Amount Year 1 Percent $- Select - - Select -% $- Select - - Select -% - Select - - Select -% - Select - - Select -% $- Select - - Select -% $- Select - - Select -% - Select - - Select -% - Select - - Select -% - Select - - Select -% - Select - - Select -% Total expenses $fill in the blank 3bd7f90c1fc4f97_26 fill in…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 $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…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning