Financial & Managerial Accounting
13th Edition
ISBN: 9781285866307
Author: Carl Warren, James M. Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 15, Problem 15.3CP
Requirement 1:
To determine
Vertical analysis: Vertical analysis is prepared to analyze the relationship among various financial statements with a particular base amount. Use the following formula to calculate vertical analysis percentage:
This analysis is otherwise called as common-size statement.
To prepare: A common-size income statement and
Requirement 2:
To determine
To compare: Financial performance of the three companies.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Common-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…
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.
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…
Chapter 15 Solutions
Financial & Managerial Accounting
Ch. 15 - Prob. 1DQCh. 15 - What is the advantage of using comparative...Ch. 15 - A companys current year net income (after income...Ch. 15 - Prob. 4DQCh. 15 - Prob. 5DQCh. 15 - Prob. 6DQCh. 15 - Prob. 7DQCh. 15 - Prob. 8DQCh. 15 - Prob. 9DQCh. 15 - Prob. 10DQ
Ch. 15 - Prob. 15.1APECh. 15 - Prob. 15.1BPECh. 15 - Prob. 15.2APECh. 15 - Vertical analysis Income statement information for...Ch. 15 - Prob. 15.3APECh. 15 - Prob. 15.3BPECh. 15 - Accounts receivable analysis A company reports the...Ch. 15 - Accounts receivable analysis A company reports the...Ch. 15 - Prob. 15.5APECh. 15 - Inventory analysis A company reports the...Ch. 15 - Prob. 15.6APECh. 15 - Long-term solvency analysis The following...Ch. 15 - Prob. 15.7APECh. 15 - Times interest earned A company reports the...Ch. 15 - Prob. 15.8APECh. 15 - Prob. 15.8BPECh. 15 - Prob. 15.9APECh. 15 - Prob. 15.9BPECh. 15 - Prob. 15.10APECh. 15 - Common stockholders' profitability analysis A...Ch. 15 - Prob. 15.11APECh. 15 - Earnings per share and price-earnings ratio A...Ch. 15 - Prob. 15.1EXCh. 15 - Vertical analysis of income statement The...Ch. 15 - Common-sized income statement Revenue and expense...Ch. 15 - Vertical analysis of balance sheet Balance sheet...Ch. 15 - Prob. 15.5EXCh. 15 - Current position analysis The following data were...Ch. 15 - Prob. 15.7EXCh. 15 - Prob. 15.8EXCh. 15 - Prob. 15.9EXCh. 15 - Prob. 15.10EXCh. 15 - Inventory analysis The following data were...Ch. 15 - Inventory analysis Dell Inc. and Hewlett-Packard...Ch. 15 - Prob. 15.13EXCh. 15 - Prob. 15.14EXCh. 15 - Prob. 15.15EXCh. 15 - Prob. 15.16EXCh. 15 - Profitability ratios The following selected data...Ch. 15 - Profitability ratios Ralph Lauren Corporation...Ch. 15 - Six measures of solvency or profitability The...Ch. 15 - Five measures of solvency or profitability The...Ch. 15 - Prob. 15.21EXCh. 15 - Prob. 15.22EXCh. 15 - Prob. 15.23EXCh. 15 - Prob. 15.24EXCh. 15 - Prob. 15.25EXCh. 15 - Prob. 15.26EXCh. 15 - Horizontal analysis of income statement For 2016,...Ch. 15 - Prob. 15.2APRCh. 15 - Prob. 15.3APRCh. 15 - Nineteen measures of solvency and profitability...Ch. 15 - Solvency and profitability trend analysis Addai...Ch. 15 - Prob. 15.1BPRCh. 15 - Prob. 15.2BPRCh. 15 - Effect of transactions on current position...Ch. 15 - Nineteen measures of solvency and profitability...Ch. 15 - Prob. 15.5BPRCh. 15 - Financial Statement Analysis The financial...Ch. 15 - Prob. 15.1CPCh. 15 - Prob. 15.2CPCh. 15 - Prob. 15.3CPCh. 15 - Prob. 15.4CPCh. 15 - Prob. 15.5CP
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Common-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 $2,740,000 100 % Cost of goods sold 1,753,600 69 Gross profit $986,400 31 % Selling expenses $602,800 18 % Administrative expenses 219,200 7 Total operating expenses $822,000 25 % Operating income $164,400 6 % Other revenue 54,800 2 $219,200 8 % Other expense 27,400 1 Income before income tax $191,800 7 % Income tax expense 82,200 5 Net income $109,600 2 % a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. If required, round percentages to one decimal place. Enter all amounts as positive…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_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. Electronics Tannenhill Industry Company Average $1,390,000 100 % Sales 736,700 59 Cost of merchandise sold $653,300 41 % Gross profit $417,000 25 % Selling expenses Administrative expenses 152,900 10 Total operating expenses $569,900 35 % Income from operations $83,400 6 % Other revenue and expense: Other revenue 27,800 2 Other expense (13,900) 1 Income before income tax expense $97,300 7 % Income tax expense 41,700 Net income $55,600 2 % a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. If required, round percentages to one decimal place. econ.docx Show all Type here to search 6:05 AM 59 F 局 10/30/2021 12 prt sc 00 5.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_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_forwardPreparing 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_forward
- Vertical analysisarrow_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_forwardSolvency and Profitability Trend Analysis (Graph Picture from A-D is on the buttom for references) Addai Company has provided the following comparative information: 20Y8 20Y7 20Y6 20Y5 20Y4 Net income $273,406 $367,976 $631,176 $884,000 $800,000 Interest expense 616,047 572,003 528,165 495,000 440,000 Income tax expense 31,749 53,560 106,720 160,000 200,000 Total assets (ending balance) 4,417,178 4,124,350 3,732,443 3,338,500 2,750,000 Total stockholders’ equity (ending balance) 3,706,557 3,433,152 3,065,176 2,434,000 1,550,000 Average total assets 4,270,764 3,928,396 3,535,472 3,044,250 2,475,000 Average total stockholders' equity 3,569,855 3,249,164 2,749,588 1,992,000 1,150,000 You have been asked to evaluate…arrow_forward
- What is thearrow_forwardHorizontal analysis of income statement For 20Y2, Macklin Inc. reported a significant increase in net income. At the end of the year, John Mayer, the president, is presented with the following condensed comparitive income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $910, 000 $700,000 Cost of goods sold 441,000 350,000 Gross Profit $469,000 350,000 Selling expenses $139,150 $115,000 Administrative expenses 99,450 85,000 Total operating expenses $238,600 $200,000 Income from operations $230,400 $150,000 Other income 65,000 50,000 Income before income tax $295,400 $200,000 Income tax expense 65,000 50,000 Net income $230,400 $150,000 Instructions 1. Prepare a comparitive income statement with horizontal analysis for the two-year period , using 20Y1 as the base year. (Round percentages to one decimal place.) 2. To the extent the data permit, comment on the significant…arrow_forwardVERTICAL ANALYSIS Give the analysis per line item. Sabina Electronics Comparative Income Statement This year Last year This year 5,000,000 3,875,000 1,125,000 653,000 472,000 72,000 400,000 120,000 280,000 110,000 Last year 4,350,000 3,450,000 900,000 548,000 352,000 72,000 280,000 84,000 196,000 95,000 Sales 100% 100% Cost of goods sold Gross margin Selling and administrative expenses Net operating income Interest expense Net income before taxes 78% 79% 23% 21% 13% 13% 9% 8% 1% 2% 6% 2% 5% 2% 8% Income taxes (30%) Net income 2% 6% Common dividends 2% 101,000 579,000 680,000 Net income retained 170,000 3% 2% Beginning retained earnings Ending retained earnings 680,000 850,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
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
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License