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.
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% |
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.
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?
Chapter 9 Solutions
Survey of Accounting (Accounting I)
- The 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_forwardRevenue and expense data for Gresham Inc. for two recent years are as follows: a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round to one decimal place. b. Comment on the significant changes disclosed by the comparative income statement.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. 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_forward
- Sundahl 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_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_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_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_forwardJasmine Company provided the following income statements for its first 3 years of operation: Refer to the information for Jasmine Company above. Required: Prepare common-size income statements by using net sales as the base. (Note: Round answers to the nearest whole percentage.)arrow_forwardThe following data (in millions) are taken from recent financial statements of Nike Inc.: a. Determine the amount of change (in millions) and percent of change in net income for Year 2. Round to one decimal place. b. Determine the percentage relationship between net income and net sales (net income divided by net sales) for Year 2 and Year 1. Round to one decimal place. c. What conclusions can you draw from your analysis?arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning