EBK FINANCIAL & MANAGERIAL ACCOUNTING
13th Edition
ISBN: 9780100545052
Author: WARREN
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 15, Problem 15.1APR
Horizontal analysis of income statement
For 2016, Clapton Company reported a decline in net income. At the end of the year, S. Hand, the president, is presented with the following condensed comparative income statement:
Indigo Company Comparative Income Statement For the Years Ended December 31, 2016 and 2015 |
||
2016 | 2015 | |
Sales..................... | $6,750,000 | $6,000,000 |
Cost of goods sold......... | 2,480,000 | 2,000,000 |
Gross profit............... | $ 4,270,400 | $4,000,000 |
Selling expenses.......... | $1,260,000 | $1,000,000 |
Administrative expenses…. | 625,000 | 500,000 |
Total operating expenses…. | $1,885,000 | $1,500,000 |
Income from operators.... | $2,385,000 | $2,500,000 |
Other income............ | 110,000 | 100,000 |
Income before income tax…. | $2,495,000 | $2,600,000 |
Income tax expense....... | 60,000 | 50,000 |
Net income............... | $2,435,000 | $2,550,000 |
Instructions
- 1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 2015 as the base year. Round 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 & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Use the following tables to answer the question:
LOGIC COMPANY Income Statement For years ended December 31, 2016 and 2017
(values in $) 2016 2017
Gross sales 19,800 15,600
Sales returns and allowances 900 100
Net sales 18,900 15,500
COGS 11,800 8,800
Gross profit 7,100 6,700
Depreciation 780 640
Selling and administrative expenses 2,800 2,400
Research 630 540
Miscellaneous 440 340
Total operating expenses 4,650 3,920
Income before interest and taxes 2,450 2,780
Interest expense 640 540
Income before taxes 1,810 2,240
Provision for taxes 724 896
LOGIC COMPANY Balance Sheet For years ended December 31, 2016 and 2017
(values in $) 2016 2017
Current assets 12,300 9,400
Accounts receivable 16,900 12,900
Merchandise inventory 8,900 14,400
Prepaid expenses 24,400 10,400
Total current assets 62,500 47,100
Building (net) 14,900 11,400
Land 13,900 9,400
Total plant and equipment 28,800 20,800
Total assets 91,300 67,900
Accounts payable 13,400 7,400
Salaries payable 7,500 5,400
Total current…
A. The following items were taken from the
financial statements of Salley, Inc. over a three
year period: Using the horizontal analysis and
2016 as the base year, compute the change in
percentages for net sales, cost of goods sold,
gross profit, operating expenses and net
income. Explain whether the trends are
favorable or unfavorable for each item.
Item
2018
Net Sales
825,000
Cost of Goods Sold
630,000
Gross Profit
195,000
Operating Expenses
100,000
Net Income
P 95,000
2017
P
740,000
580,000
160,000
80,000
P
80,000
2016
675,000
535,000
140,000
75,000
P
65,000
Mac Donald company reported the following on its comparative income statement:
2017
2018
2019
Revenue
9,000
10,000
14,000
Cost of goods sold
6,000
4,000
9,000
Prepare a horizontal analysis of revenue , cost of goods sold and gross profit
Chapter 15 Solutions
EBK 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
- Financial statement data for years ending December 31 for Latchkey Company follows: a. Determine the ratio of sales to assets for 2016 and 2015. b. Does the change in the ratio of sales to assets from 2015 to 2016 indicate a favorable or an unfavorable trend?arrow_forwardVertical analysis (common-size) percentages for Baker Company’s sales revenue, cost of goods sold, and expenses are as follows. Did Baker’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period? Provide numerical support for your answer. Vertical Analysis 2018 2017 2016 Sales revenue 100.0% 100.0% 100.0% Cost of goods sold 60.0 63.9 65.0 Expenses 26.0 26.6 27.5arrow_forwardIn its year-end financial statements, Pillar Inc. reported the following (in millions): 2016 2015 Sales $38,152 $46,541 Cost of goods sold $28,309 $33,211 As a percentage of sales, did Pillar's gross profit increase or decrease during the year? Select one: a. Gross profit decreased from 28.6% to 25.8% b. Gross profit increased from 71.4% to 74.2% c. Gross profit decreased from 74.2% to 71.4% d. There is not enough information to answer the question. e. Gross profit increased from 25.8% to 28.6%arrow_forward
- GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL AND VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - -…arrow_forwardGiven the income statement below, Mega Trade Inc. wants to find the resulting net income for the year 2016 (in million). What is the right amount? Income Statement ($ Million) YEAR END YEAR END YEAR END YEAR END 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost Sales -679.1 -659 -681.3 -667 Gross Operating Income Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income/Expenses 11.8 7.6 7 8.2 Earnings Before Interest and Taxes Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Pre Tax Income Income Taxes -56.8 -64.2 -67.5 -72.6 Net Income Dividends -38.3 -38.7 -39.8 -40.1arrow_forwardHorizontal Analysis of Income Statement For 20Y2, Macklin Inc. reported a significant decrease in net income. At the end of the year, John Mayer, the president, is presented with the following condensed comparative income statement: Macklin Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $794,884 $722,000 i ne si st Cost of goods sold (561,200) (460,000) Gross profit $233,684 $262,000 Selling expenses $(77,780) $(61,000) Administrative expenses (45,520) (38,000) $(123,300) $(99,000) Total operating expenses Operating income $110,384 $163,000 Other revenue 3,846 Income before income tax expense $114,230 $166,000 Income tax expense (32,000) (49,800) $82,230 $116,200 Net income Required: 1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Use the minus sign to indicate a decrease in the "Increase/(Decrease)" columns. If required, round percentages to one decimal place.…arrow_forward
- GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…arrow_forwardGIVE THE COMPARATIVE INCOME STATEMENT VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…arrow_forwardSelected financial statement data for Schmitzer Inc. is shown below: 2016 2015 Balance sheet: Inventories 60,000 48,000 Ratios: Gross profit ratio for 2016 Inventory turnover ratio for 2016 40% What was the amount of net sales for 2016?arrow_forward
- 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 CompanyComparative Income StatementFor the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $587,944 $532,000 Cost of goods sold 414,800 340,000 Gross profit $173,144 $192,000 Selling expenses $57,380 $45,000 Administrative expenses 33,540 28,000 Total operating expenses $90,920 $73,000 Income from operations $82,224 $119,000 Other revenue 2,644 2,200 Income before income tax $84,868 $121,200 Income tax expense 23,800 36,400 Net income $61,068 $84,800 Required: 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. Use the minus sign to indicate a decrease in the "Increase (Decrease)"…arrow_forwardHorizontal 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) Operating income $ 2,310,000 $ 2,500,000 Other revenue 256,950 225,000 Income before income tax expense $ 2,566,950 $ 2,725,000 Income tax expense (1,413,000) (1,500,000) Net income $ 1,153,950 $ 1,225,000 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. For…arrow_forwardHorizontal 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) Operating income $ 2,310,000 $ 2,500,000 Other revenue 256,950 225,000 Income before income tax expense $ 2,566,950 $ 2,725,000 Income tax expense (1,413,000) (1,500,000) Net income $ 1,153,950 $ 1,225,000 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. For…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License