close solutoin list

Horizontal analysis of income statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income Statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales.......................... $16,800,000 $15,000,000 Cost of goods sold.............. 11,500,000 10,000,000 Gross profit.................... $ 5,300,000 $ 5,000,000 Selling expenses............... $ 1,770,000 $ 1,500,000 Administrative expenses........ 1,220,000 $ 1,000,000 Total operating expenses....... $ 2,990,000 $ 2,500,000 Income from operations........ $ 2,310,000 $ 2,500,000 Other revenue................. 256,950 225,000 Income before income tax...... $ 2,566,950 $ 2,725,000 Income tax expense............ 1,413,000 1,500,000 Net income.................... $ 1,153,950 $ 1,225,0000 Instructions 1. Prepare a comparative 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 relationships revealed by the horizontal analysis prepared in (1).

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.1APR
Textbook Problem

Horizontal analysis of income statement

For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income Statement:

McDade Company

Comparative Income Statement

For the Years Ended December 31, 20Y2 and 20Y1

  20Y2 20Y1
Sales.......................... $16,800,000 $15,000,000
Cost of goods sold.............. 11,500,000 10,000,000
Gross profit.................... $ 5,300,000 $ 5,000,000
Selling expenses............... $ 1,770,000 $ 1,500,000
Administrative expenses........ 1,220,000 $ 1,000,000
Total operating expenses....... $ 2,990,000 $ 2,500,000
Income from operations........ $ 2,310,000 $ 2,500,000
Other revenue................. 256,950 225,000
Income before income tax...... $ 2,566,950 $ 2,725,000
Income tax expense............ 1,413,000 1,500,000
Net income.................... $ 1,153,950 $ 1,225,0000

Instructions

1. Prepare a comparative 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 relationships revealed by the horizontal analysis prepared in (1).

Expert Solution

1.

To determine

Horizontal Analysis

Horizontal analysis refers to the measurement of percentage change in the comparative financial statements. It compares the items from the financial statements from one to the other years, and indicates the trends.

To Prepare: The horizontal analysis of the comparative income statement of Company M for the year 20Y2.

Given info: Income statement for 20Y2 and 20Y1.

Explanation of Solution

Following formula is used for computing the change in dollar amount of items in the income statement of 20Y1 and 20Y2, and the percentage change for the respective items.

Change in amount = Amount in 20Y2-Amou

Expert Solution
To determine

2.

To comment: Significant relationships revealed by the horizontal 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
What is a systems flowchart?

Accounting Information Systems

To match human resources supply and demand, how is attrition used?

Foundations of Business (MindTap Course List)

Describe a plant asset.

College Accounting, Chapters 1-27

EXCESS CAPACITY Krogh Lumbers 2014 financial statements are shown here. Krogh Lumber: Balance Sheet as of Decem...

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

What is tactical decision making?

Cornerstones of Cost Management (Cornerstones Series)