Accounting, Chapters 1-13
27th Edition
ISBN: 9781337272100
Author: Carl Warren, James M. Reeve, Jonathan Duchac
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 solutionStudents have asked these similar questions
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 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…
Vertical 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.
Chapter 17 Solutions
Accounting, Chapters 1-13
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_forwardRevenue and expense data for Bluestem Company are as follows: Administrative expenses Cost of goods sold Income tax expense Sales Selling expenses Year 2 $37,000 350,000 40,000 800,000 150,000 Year 1 a. Prepare a comparative income statement, with vertical analysis, stating each item for both years as a percent of sales. Round percents to one decimal point. Bluestem Company Total operating expenses $ $ There was Comparative Income Statement For Years Ended December 31, Year 2 and Year 1 $20,000 320,000 32,000 700,000 110,000 Year 2 Year 2 Amount Percent 11% % Year 1 Year 1 Amount Percent %%$ % $ %$ % % % % % % % b. Comment upon significant changes disclosed by the comparative income statement. in the cost of goods sold, and in cost of goods sold and contributed greatly to the in administrative expenses. However, the more significant in net income. in selling expenses offset thearrow_forwardThe balance sheet of ATLF, Inc. reports total assets of $1,950,000 and $2,050,000 at the beginning and end of the year, respectively. Net income and sales for the year are $150,000 and $1,000,000, respectively. What is ATLF's profit margin? Select one: a. 10% Ob. 8% O c. 7.5% O d. 15% e. 12%arrow_forward
- Game-On Sports operates in two distinct segments: athletic equipment and accessories. The income statement for each operating segment is presented below.Required:1. Complete the "%" columns to be used in a vertical analysis of Game-On Sports’ two operating segments. Express each amount as a percentage of sales. (Round your percentage answers to 1 decimal place.) GAME-ON SPORTS Income Statement For the Year Ended December 31, 2021 Athletic Equipment Accessories Amount % Amount % Net sales $2,800,000 $3,250,000 Cost of goods sold 1,250,000 1,620,000 Gross profit 1,550,000 1,630,000 Operating expenses 650,000 700,000 Operating income 900,000 930,000 Other income (expense) 75,000 (10,000) Income before tax 975,000 920,000 Income tax expense 225,000 200,000 Net income $750,000 $720,000 2. Use vertical analysis to compare the profitability of the two operating segments. Which segment is more…arrow_forward5. Revenue 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 expenses 70,000 79,200 Administrative expenses 75,000 70,400 Income tax expense 10,500 16,400 Required: 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. ... b. Complete the following regarding the significant changes disclosed by the comparative income statement. The vertical analysis indicates that the cost of goods sold as a percent of sales (increased/decreased) between the two years. Selling and administrative expenses as a percentage of sales (increased/decreased) and income tax expense (increased/decreased). Overall, net income as a percent of sales (increased/decreased).arrow_forwardRevenue and expense data for Bluestem Company are as follows: Year 2 Year 1 Administrative expenses $37,000 $20,000 Cost of merchandise sold 350,000 320,000 Income tax expense 40,000 32,000 Sales 800,000 700,000 Selling expenses 150,000 110,000 a. Prepare a comparative income statement, with vertical analysis, stating each item for both years as a percent of sales. Round percentages to one decimal place. Bluestem Company Comparative Income Statement For Years Ended December 31, Year 2 and Year 1 Year 2 Amount Year 2 Percent Year 1 Amount Year 1 Percent % % % Total operating expenses b. Complete the following regarding significant changes disclosed by the comparative income statement. The most significant increase in expenses is which offsets the decrease in resulting in the overall of net income. 111111111arrow_forward
- Preparing Income Statements by Using Net Sales as the Base: Vertical Analysis Scherer Company provided the following income statements for its first 3 years of operation: Scherer CompanyIncome StatementsYears of Operation Year 1 Year 2 Year 3 Net sales $1,000,000 $1,100,000 $1,300,000 Less: Cost of goods sold (300,000) (315,000) (369,000) Gross margin $700,000 $785,000 $931,000 Less: Operating expenses (431,000) (488,000) (600,500) Income taxes (111,000) (123,000) (135,800) Net income $158,000 $174,000 $194,700 Required: Prepare common-size income statements by using net sales as the base. (Note: Enter all amounts as positive numbers, except for a net loss. Enter net loss as a negative number, if applicable. Round answers to the nearest whole percentage. Percentages may not calculate down.) Scherer Company Common-Size Income Statements Years of Operation Year 1 Year 1 Year 2 Year 2 Year 3 Year 3 Dollars Percentage Dollars Percentage…arrow_forwardPreparing Common-Size Income Statements by Using BasePeriod Horizontal AnalysisRefer to the information for Scherer Company on the previous page.Required:Prepare common-size income statements by using Year 1 as the base period. (Note: Roundanswers to the nearest whole percentage.)arrow_forwardPlease answer Exercise 9-1. Prepare a forecasted income statement for Year 12.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 PubSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningManagerial 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 LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
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
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College