Survey of Accounting (Accounting I)
8th Edition
ISBN: 9781305961883
Author: Carl Warren
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 9.5E
To determine
Concept Introduction:
Horizontal Analysis:
Horizontal Analysis is used to analyze the trend of an item. Horizontal Analysis is done in different periods for example analysis of trend of sales for several years is done using the horizontal analysis.
Requirement-a:
To Prepare:
The Comparative Income Statement using horizontal analysis.
Expert Solution
Answer to Problem 9.5E
The Comparative Income Statement using horizontal analysis
| Horizontal Analysis of Comparative Income Statement | ||||
| Year | Percentage | |||
| Sales | 9.8% | |||
| Cost of Goods Sold | 30.0% | |||
| Gross Profit | -25.6% | |||
| Selling expenses | 10.0% | |||
| Administrative expenses | 8.0% | |||
| Total Operating expenses | 9.2% | |||
| Income from operations | -35.9% | |||
| Other Revenue | 15.0% | |||
| Income before income tax | -35.5% | |||
| Income Tax Expense | -35.0% | |||
| Net Income | -35.5% | |||
Explanation of Solution
The Comparative Income Statement using horizontal analysis is prepared as follows:
| Horizontal Analysis of Comparative Income Statement | ||||
| Increase (Decrease) | ||||
| Year | 20Y5 | 20Y4 | Amount | Percentage |
| A | B | C = (A-B) | C/B | |
| Sales | $ 862,000 | $ 785,000 | $ 77,000 | 9.8% |
| Cost of Goods Sold | $ 650,000 | $ 500,000 | $ 150,000 | 30.0% |
| Gross Profit | $ 212,000 | $ 285,000 | $ (73,000) | -25.6% |
| Selling expenses | $ 44,000 | $ 40,000 | $ 4,000 | 10.0% |
| Administrative expenses | $ 27,000 | $ 25,000 | $ 2,000 | 8.0% |
| Total Operating expenses | $ 71,000 | $ 65,000 | $ 6,000 | 9.2% |
| Income from operations | $ 141,000 | $ 220,000 | $ (79,000) | -35.9% |
| Other Revenue | $ 2,300 | $ 2,000 | $ 300 | 15.0% |
| Income before income tax | $ 143,300 | $ 222,000 | $ (78,700) | -35.5% |
| Income Tax Expense | $ 13,000 | $ 20,000 | $ (7,000) | -35.0% |
| Net Income | $ 130,300 | $ 202,000 | $ (71,700) | -35.5% |
To determine
Concept Introduction:
Horizontal Analysis:
Horizontal Analysis is used to analyze the trend of a particular item. Horizontal Analysis is done for items for different periods for example sale trends for several years are found using horizontal analysis.
Requirement-a:
To Indicate:
The results from horizontal analysis.
Expert Solution
Answer to Problem 9.5E
The significant results from horizontal analysis are as follows:
- Cost of goods sold has increased more as compared with sales, which has resulted in decrease in gross profit.
- Income from operation has decreased mainly due to decrease in gross profit.
Explanation of Solution
The Comparative Income Statement using horizontal analysis is prepared as follows:
| Horizontal Analysis of Comparative Income Statement | ||||
| Increase (Decrease) | ||||
| Year | 20Y5 | 20Y4 | Amount | Percentage |
| A | B | C = (A-B) | C/B | |
| Sales | $ 862,000 | $ 785,000 | $ 77,000 | 9.8% |
| Cost of Goods Sold | $ 650,000 | $ 500,000 | $ 150,000 | 30.0% |
| Gross Profit | $ 212,000 | $ 285,000 | $ (73,000) | -25.6% |
| Selling expenses | $ 44,000 | $ 40,000 | $ 4,000 | 10.0% |
| Administrative expenses | $ 27,000 | $ 25,000 | $ 2,000 | 8.0% |
| Total Operating expenses | $ 71,000 | $ 65,000 | $ 6,000 | 9.2% |
| Income from operations | $ 141,000 | $ 220,000 | $ (79,000) | -35.9% |
| Other Revenue | $ 2,300 | $ 2,000 | $ 300 | 15.0% |
| Income before income tax | $ 143,300 | $ 222,000 | $ (78,700) | -35.5% |
| Income Tax Expense | $ 13,000 | $ 20,000 | $ (7,000) | -35.0% |
| Net Income | $ 130,300 | $ 202,000 | $ (71,700) | -35.5% |
The significant findings from the horizontal analysis are as follows:
- Cost of goods sold has increased more as compared to sales, which has resulted in decrease in gross profit.
- Income from operation has decreased mainly due to decrease in gross profit.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Income statement data for Winthrop Company for two recent years ended December 31 are as follows:
Please see the attachment for details:
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. Round percentages to one decimal place.b. What conclusions can be drawn from the horizontal analysis?
A. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. Round percentages to one decimal place.
B. What conclusions can be drawn from the horizontal analysis? Round the answers to one decimal place.
Income statements for Campbell Company for Year 3 and Year 4 follow:
CAMPBELL COMPANY
Income Statements
Year 4
Year 3
$180,800
120,400
19,900
14,500
Sales
$200,800
Cost of goods sold
Selling expenses
Administrative expenses
Interest expense
Total expenses
142,400
21,900
12,500
3,900
$180,700
5,900
$160,700
20,100
3,700
Income before taxes
20,100
Income taxes expense
6,500
Net income
$ 13,600
$ 16,400
Required
a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4.
b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year.
Complete this question by entering your answers in the tabs below.
Required A
Required B
Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year
4. (Negative answers should be indicated by a minus sign. Round your percentage answers to 1 decimal place. (i.e., 0.234
should be entered…
Chapter 9 Solutions
Survey of Accounting (Accounting I)
Ch. 9 - What type of analysis is indicated by the...Ch. 9 - Which of the following measures indicates the...Ch. 9 - Prob. 3SEQCh. 9 - Prob. 4SEQCh. 9 - Prob. 5SEQCh. 9 - That is the difference between horizontal and...Ch. 9 - Prob. 2CDQCh. 9 - Prob. 3CDQCh. 9 - Prob. 4CDQCh. 9 - How would the current and quick ratios of a...
Ch. 9 - For Belzcr Corporation, the working capital at the...Ch. 9 - Prob. 7CDQCh. 9 - Prob. 8CDQCh. 9 - a. Why is it advantageous to have a high inventory...Ch. 9 - Prob. 10CDQCh. 9 - Prob. 11CDQCh. 9 - Prob. 12CDQCh. 9 - Prob. 13CDQCh. 9 - Prob. 14CDQCh. 9 - Prob. 15CDQCh. 9 - Favorable business conditions may bring about...Ch. 9 - Prob. 17CDQCh. 9 - Prob. 9.1ECh. 9 - Vertical analysis of income statement The...Ch. 9 - Common-sized income statement Revenue and expense...Ch. 9 - Prob. 9.4ECh. 9 - Prob. 9.5ECh. 9 - Prob. 9.6ECh. 9 - Prob. 9.7ECh. 9 - Current position analysis The bond indenture for...Ch. 9 - Accounts receivable analysis The following data...Ch. 9 - Prob. 9.10ECh. 9 - Inventory analysis The following data were...Ch. 9 - Inventory analysis Costco Wholesale Corporation...Ch. 9 - Ratio of liabilities to stockholders' equity and...Ch. 9 - Prob. 9.14ECh. 9 - Debt ratio, ratio of liabilities to stockholders'...Ch. 9 - Prob. 9.16ECh. 9 - Profitability metrics The following selected data...Ch. 9 - Profitability metrics Macy's, Inc. (M). sells...Ch. 9 - Seven metrics The following data were taken from...Ch. 9 - Prob. 9.20ECh. 9 - Prob. 9.21ECh. 9 - Prob. 9.22ECh. 9 - Unusual income statement items Assume that the...Ch. 9 - Horizontal analysis for income statement For 20Y3....Ch. 9 - Horizontal analysis for income statement For 20Y3....Ch. 9 - Prob. 9.2.1PCh. 9 - Prob. 9.2.2PCh. 9 - Effect of transactions on current position...Ch. 9 - Effect of transactions on current position...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Prob. 9.4.7PCh. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Twenty metrics of liquidity, solvency, and...Ch. 9 - Prob. 9.4.20PCh. 9 - Trend analysis Critelli Company has provided the...Ch. 9 - Trend analysis Critelli Company has provided the...Ch. 9 - Prob. 9.1CCh. 9 - Prob. 9.2CCh. 9 - Prob. 9.3CCh. 9 - Prob. 9.4.1CCh. 9 - Prob. 9.4.2CCh. 9 - Prob. 9.4.3CCh. 9 - Comprehensive profitability and solvency analysis...Ch. 9 - Comprehensive profitability and solvency analysis...
Knowledge Booster
Similar questions
- 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_forwardThe following data (in millions) were taken from the financial statements of Costco Wholesale Corporation: a. For Costco, determine the amount of change in millions and the percent of change (round to one decimal place) from the prior year to the recent year for: 1. Revenue 2. Operating expenses 3. Operating income b. Comment on the results of your horizontal analysis in part (a). c. Based upon Exercise 2-23, compare and comment on the operating results of Target and Costco for the recent year.arrow_forwardSundahl Companys income statements for the past 2 years are as follows: Refer to the information for Sundahl Company above. Required: 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.)arrow_forward
- 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.arrow_forwardWhich of the following is a technique for reviewing relationships on an income statement by assigning net sales as 100%? A. Ratio analysis. B. Current ratio. C. Horizontal analysis. D. Vertical analysis.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_forward
- Vertical analysis of income statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: A. Prepare an income statement in comparative form, stating eachitem for both years as a percent of sales. (Round to the nearestwhole percentage.)B. Comment on the significant changes disclosed by thecomparative income statement.arrow_forward= The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Prime Fish Balance sheet Cash Accounts receivable (net) Inventory Property & equipment (net) Other assets Total assets Current liabilities Long-term debt (interest rate: 15%) Capital stock ($10 par value) Additional paid-in capital Retained earnings Total liabilities and stockholders' equity Income statement Sales revenue (1/2 on credit) Cost of goods sold Operating expenses Net income Other data Per share stock price at end of current year Blue Water $ 42,300 44,500 92,500 159,500 85,300 $ 424,100 $ 92,500 74,100 157,100 30,300 70,100 $ 424,100 $ 427,500 (234,500) (163,600) $ 29,400 $ 23.3 45% $ 19,700 34,900 47,800 416,600 318,000 $ 34,300 $ 837,000 $ 68,500 62,600 525,000 107,300 73,600 $ 837,000 $ 789,000 (401,300) (312,300) $ 75,400 $28 45% Average income tax rate Dividends declared and paid in current year Both companies are in the fish catching and manufacturing business.…arrow_forwardRefer to the information for Sundahl Company on the previous page.Required:1. Prepare a common-size income statement for Year 1 by expressing each line item as apercentage 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 apercentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)arrow_forward
- 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 Year2 as a percentage of that same line item from Year 1. (Note: Round percentages to thenearest tenth of a percent.)2. Prepare a common-size income statement for Year 3 by expressing each line item for Year3 as a percentage of that same line item from Year 1. (Note: Round percentages to thenearest tenth of a percent.)arrow_forwardPerform a vertical analysis for the entry "Gross Sales" on the portion of an income statement shown below (as a %). (Round to nearest tenth.) *Chart is attached with the information*arrow_forwardComparative Income Statement Use the following comparative income statement form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part and on the Profitability Measures part. Compute any missing amounts and complete the horizontal analysis columns. Enter percentages as decimal amounts, rounded to one decimal place. When rounding, look only at the figure to the right of one decimal place. If 5, round up. For example, for 32.048% enter 32.0%. For 32.058% enter 32.1%. Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Operating income Other expense (interest) Income before income tax expense Income tax expense Net income Comparative Income Statement For the Years Ended December 31, 20Y6 and 20Y5 $ 20Y6 8,250,000 X (1,242,000) 20Y5 $7,287,000 (3,444,000) $3,843,000 $(1,457,600) (1,106,000) $(2,563,600) $1,279,400 (120,600) $1,158,800 (181,980) $976,820 $ $ $ Increase/(Decrease) Amount 823,000 X…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 Pub
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Managerial 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 Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
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
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage