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.5EX
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.
2.
To determine
To provide: Conclusion from the horizontal analysis.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Horizontal Analysis of the Income Statement
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:
Current Year
Previous Year
Sales
$965,200
$760,000
Cost of goods sold
818,400
660,000
Gross profit
$146,800
$100,000
Selling expenses
$43,290
$37,000
Administrative expenses
38,750
31,000
Total operating expenses
$82,040
$68,000
Income before income tax
$64,760
$32,000
Income tax expenses
25,900
12,800
Net income
$38,860
$19,200
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
Winthrop Company
Comparative Income Statement
For the Years Ended December 31
Current Previous
Increase
Increase
year
year
(Decrease) (Decrease)
Amount Amount
Amount
Percent
Sales
$965,200 $760,000
%
Cost of goods sold
818,400
660,000
%
Gross profit
$146,800 $100,000
%
Selling expenses
$43,290
$37,000
%
Administrative…
Horizontal Analysis of the Income Statement
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:
Current Year
Previous Year
Sales
$897,900
$730,000
774,400
Cost of goods sold
640,000
Gross profit
$123,500
$90,000
Selling expenses
$35,030
$31,000
Administrative expenses
31,460
26,000
Total operating expenses
$66,490
$57,000
$57,010
Income before income tax
$33,000
22,800
Income tax expenses
13,200
$34,210
$19,800
Net income
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round
to one decimal place.
Winthrop Company
Comparative Income Statement
For the Years Ended December 31
Current Previous
Increase
(Decrease) (Decrease)
Percent
Increase
year
Amount
year
Amount
Amount
Horizontal Analysis of the Income Statement
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:
Current Year
Previous Year
Sales
$878,400
$720,000
Cost of goods sold
725,900
610,000
Gross profit
$152,500
$110,000
Selling expenses
$42,560
$38,000
Administrative expenses
38,400
32,000
Total operating expenses
$80,960
$70,000
Income before income tax
$71,540
$40,000
Income tax expenses
28,600
16,000
Net income
$42,940
$24,000
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
Winthrop Company
Comparative Income Statement
For the Years Ended December 31
CurrentyearAmount
PreviousyearAmount
Increase(Decrease)Amount
Increase(Decrease)Percent
Sales
$878,400
$720,000
$
%
Cost of goods…
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
- Juroe 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_forwardSundahl 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_forwardThe following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.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 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. Refer to the information for Juroe Company on the previous page. Also, assume that Juroes total assets at the beginning of last year equaled 17,350,000 and that the tax rate applicable to Juroe is 40%. Required: Note: Round answers to two decimal places. 1. Calculate the average total assets. 2. Calculate the return on assets.arrow_forwardBrandt Corporation had sales revenue of 500,000 for the current year. For the year, its cost of goods sold was 240,000, its operating expenses were 50,000, its interest revenue was 2,000, and its interest expense was 12,000. Brandts income tax rate is 30%. Prepare Brandts multiple-step income statement for the current year.arrow_forward
- During the current year, Plainfield Manufacturing earned income of $845,000 from total sales of $9,350,000 and average capital assets of $13,500,000. Using the sales margin from the previous exercise, what is the total ROI for the company during the current year?arrow_forwardOn January 1, Pope Enterprises inventory was 625,000. Pope made 950,000 of net purchases during the year. On its year-end income statement, Pope reported cost of goods sold of 1,025,000. Calculate Popes December 31 ending inventory.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 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_forward
- Horizontal Analysis of the Income Statement Income statement data for Boone Company for two recent years ended December 31, are as follows: Current Year Previous Year Sales $810,700 $670,000 Cost of goods sold 678,300 570,000 Gross profit $132,400 $100,000 Selling expenses $36,630 $33,000 Administrative expenses 33,320 28,000 Total operating expenses $69,950 $61,000 Income before income tax $62,450 $39,000 Income tax expenses 25,000 15,600 Net income $37,450 $23,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place. Boone Company Comparative Income Statement For the Years Ended December 31 Current year Amount Previous year Amount Increase (Decrease) Amount Increase (Decrease) Percent Sales $810,700 $670,000 % Cost of goods sold 678,300 570,000 Gross profit $132,400 $100,000 % Selling expenses 36,630 33,000 Administrative expenses 33,320…arrow_forwardHorizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows: Current Year Previous Year Sales $537,600 $420,000 Cost of goods sold 462,500 370,000 Gross profit $75,100 $50,000 Selling expenses $22,420 $19,000 Administrative expenses 20,160 16,000 Total operating expenses $42,580 $35,000 Income before income tax $32,520 $15,000 Income tax expenses 13,000 6,000 Net income $19,520 $9,000 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place. Winthrop Company Comparative Income Statement For the Years Ended December 31 CurrentyearAmount PreviousyearAmount Increase(Decrease)Amount Increase(Decrease)Percent Sales $537,600 $420,000 $fill in the blank…arrow_forwardHorizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows: Current Year Previous Year Sales $418,200 $340,000 Cost of goods sold 350,900 290,000 Gross profit $67,300 $50,000 Selling expenses $19,210 $17,000 Administrative expenses 16,940 14,000 Total operating expenses $36,150 $31,000 Income before income tax $31,150 $19,000 Income tax expenses 12,500 7,600 Net income $18,650 $11,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place. Winthrop Company Comparative Income Statement For the Years Ended December 31 CurrentyearAmount PreviousyearAmount Increase(Decrease)Amount Increase(Decrease)Percent Sales $418,200 $340,000 $fill in the blank…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License