close solutoin list

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. Tannenhill Company Electronics Industry Average Sales $4,000,000 100% Cost of goods sold 2,120,000 60 Gross profit $1,880,000 40% Selling expenses $1,080,000 24% Administrative expenses 640,000 14 Total operating expenses $ 1,720,000 38% Operating income $ 160,000 2% Other revenue 120,000 3 $ 280.000 5% Other expense 80,000 2 Income before income tax $ 200,000 3% Income tax expense 80,000 2 Net income $ 120,000 1% a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. Round to the nearest whole percentage. b. As far as the data permit, comment on significant relationships revealed by the comparisons.

BuyFind

Accounting

27th Edition
WARREN + 5 others
Publisher: Cengage Learning,
ISBN: 9781337272094
BuyFind

Accounting

27th Edition
WARREN + 5 others
Publisher: Cengage Learning,
ISBN: 9781337272094

Solutions

Chapter
Section
Chapter 17, Problem 17.3EX
Textbook Problem

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.

 

Tannenhill

Company

Electronics

Industry

Average

Sales $4,000,000 100%
Cost of goods sold 2,120,000 60
Gross profit $1,880,000 40%
Selling expenses $1,080,000 24%
Administrative expenses 640,000 14
Total operating expenses $ 1,720,000 38%
Operating income $ 160,000 2%
Other revenue 120,000 3
  $ 280.000 5%
Other expense 80,000 2
Income before income tax $ 200,000 3%
Income tax expense 80,000 2
Net income $ 120,000 1%

a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. Round to the nearest whole percentage.

b. As far as the data permit, comment on significant relationships revealed by the comparisons.

Expert Solution

1.

To determine

Vertical Analysis

Vertical analysis is prepared to analyze the relationship among various financial statements with a particular base amount.

Formula:

Vertical analysis percentage =(Specific itemBaseamount)×100

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.

Explanation of Solution

Vertical analysis for income statement is performed by setting the net sales as 1...

Expert Solution

2.

To determine

To comment: Significant relationships revealed by the vertical analysis.

Want to see this answer and more?

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

See solution

Chapter 17 Solutions

Accounting
Show all chapter solutions
Ch. 17 - Horizontal analysis The comparative temporary...Ch. 17 - Horizontal analysis The comparative accounts...Ch. 17 - Vertical analysis Income statement information for...Ch. 17 - Vertical analysis Income statement information for...Ch. 17 - Current position analysis The following items are...Ch. 17 - Current position analysis The followingitems are...Ch. 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 - Long-term solvency analysis The following...Ch. 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 - Earnings per share and price-earnings ratio A...Ch. 17 - Earnings per share and price-earnings ratio A...Ch. 17 - Vertical analysts of income statement Revenue and...Ch. 17 - Vertical analysis of income statement The...Ch. 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 - Current position analysis PepsiCo, Inc., the...Ch. 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 - Asset turnover Three major segments of the...Ch. 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 - Earnings per share, price-earnings ratio, dividend...Ch. 17 - Price-earnings ratio; dividend yield The table...Ch. 17 - Earnings per share, discontinued operations The...Ch. 17 - Income statement and earnings per share for...Ch. 17 - Unusual items Explain whether Colston Company...Ch. 17 - Horizontal analysis of income statement For 20Y2,...Ch. 17 - Vertical analysis of income statement For 20Y2,...Ch. 17 - Effect of transactions on current position...Ch. 17 - Measures of liquidity, solvency, and profitability...Ch. 17 - Solvency and profitability trend analysis Addai...Ch. 17 - Horizontal analysis of income statement For 20Y2,...Ch. 17 - Vertical analysis of income statement For 20Y2,...Ch. 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 - Ethics in Action Rodgers Industries Inc. completed...Ch. 17 - Communication The president of Freeman Industries...Ch. 17 - Common-sized income statements The condensed...Ch. 17 - Profitability analysis Deere Company manufactures...Ch. 17 - Comprehensive profitability and solvency analysis...

Additional Business Textbook Solutions

Find more solutions based on key concepts
Show solutions
When is a stock said to be in equilibrium? Why might a stock at any point in time not be in equilibrium?

Fundamentals of Financial Management, Concise Edition (MindTap Course List)

MIRR Refer to Problem 11-1. What is the projects MIRR?

Fundamentals of Financial Management (MindTap Course List)

DUPONT ANALYSIS A firm has been experiencing low profitability in recent years Perform an analysis of the firms...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)