Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 14, Problem 14.24BE
To determine
To prepare: Horizontal analysis of comparative income statement of firm SG.
To explain: The reason for net income increase by higher percentage than net revenue during the year 2017.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
E12-24B Vertical analysis (Learning Objective 2) 15-20 min.
Simpson Painting, Inc., requested that you perform a vertical analysis
of its balance sheet to determine the component percentages of its
assets, liabilities, and stockholders' equity. Round to the nearest tenth
of a percent.
P. Donnelly, Inc.
Comparative Income Statement
Years Ended December 31, 2018 and 2017
Revenue
Expenses:
Cost of Goods Sold
Selling and General Expenses
Interest Expense
Income Tax Expense
Total Expenses
Net Income
2018
$500,000
$245,000
111,000
10,000
54,700
420,700
$ 79,300
2017
$439,500
$236,000
103,500
6,500
44,400
390,400
$ 49,100
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%…
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
-
-
-…
Chapter 14 Solutions
Managerial Accounting (5th Edition)
Ch. 14 - (Learning Objective 1) Which of the following...Ch. 14 - Prob. 2QCCh. 14 - Prob. 3QCCh. 14 - Prob. 4QCCh. 14 - (Learning Objective 3) Which of the following is...Ch. 14 - (Learning Objective 4) Working capital is defined...Ch. 14 - Prob. 7QCCh. 14 - Prob. 8QCCh. 14 - Prob. 9QCCh. 14 - Prob. 10QC
Ch. 14 - Prob. 14.1SECh. 14 - Find trend percentages (Learning Objective 1)...Ch. 14 - Prob. 14.3SECh. 14 - Prepare common-size income statements (Learning...Ch. 14 - Analyze common-size income statements (Learning...Ch. 14 - Cartwrights Data Set used for S14-6 through...Ch. 14 - Cartwrights Data Set used for S14-6 through...Ch. 14 - Cartwrights Data Set used for S14-6 through...Ch. 14 - Prob. 14.9SECh. 14 - Prob. 14.10SECh. 14 - Prob. 14.11SECh. 14 - Prob. 14.12AECh. 14 - Prob. 14.13AECh. 14 - Prob. 14.14AECh. 14 - Prob. 14.15AECh. 14 - Prob. 14.16AECh. 14 - Calculate ratios (Learning Objective 4) Kelleher...Ch. 14 - Prob. 14.18AECh. 14 - Prob. 14.19AECh. 14 - Prob. 14.20AECh. 14 - Prob. 14.21AECh. 14 - Classify company sustainability measurements into...Ch. 14 - Prob. 14.23BECh. 14 - Prob. 14.24BECh. 14 - Prob. 14.25BECh. 14 - Prob. 14.26BECh. 14 - Prob. 14.27BECh. 14 - Calculate ratios (Learning Objective 4) Ponderosa...Ch. 14 - Prob. 14.29BECh. 14 - Prob. 14.30BECh. 14 - Prob. 14.31BECh. 14 - Calculate ratios (Learning Objective 4) Thornton...Ch. 14 - Prob. 14.33BECh. 14 - Prob. 14.34APCh. 14 - Comprehensive analysis (Learning Objectives 2, 3, ...Ch. 14 - Prob. 14.36APCh. 14 - Ratio analysis over two years (Learning Objective...Ch. 14 - Prob. 14.38APCh. 14 - Prob. 14.39BPCh. 14 - Prob. 14.40BPCh. 14 - Prob. 14.41BPCh. 14 - Ratio analysis over two years (Learning Objective...Ch. 14 - Make an investment decision (Learning Objective 4)...Ch. 14 - Prob. 14.44SCCh. 14 - Discussion Questions 1. Describe horizontal...Ch. 14 - Prob. 14.47ACTCh. 14 - Using financial statement ratios to analyze...
Knowledge Booster
Similar questions
- GIVE 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_forward(Learning Objective 2: Analyze accounts payable turnover) Barnacle Sales, Inc.’s,comparative income statements and balance sheets show the following selected information for2017 and 2018:2018$2,850,000$ 800,000$ 600,000$ 305,0002017$2,700,000$ 600,000$ 400,000$ 255,000Cost of goods sold.......................................................Ending inventory.........................................................Beginning inventory ....................................................Average accounts payable ...........................................Requirements1. Calculate the company’s accounts payable turnover and days’ payable outstanding (DPO)for 2017 and 2018.2. On the basis of this computation alone, has the company’s liquidity position improved ordeteriorated during 2018?arrow_forwardIncome 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…arrow_forward
- (Learning Objective 7: Calculate return on assets) Handley Grocery Corporationreported the following information in its comparative financial statements for the fiscal yearended January 31, 2018:January 31,2018January 31,2017Net sales....................................Net earnings..............................Average total assets...................$50,000$ 2,200$40,000$48,350$ 2,100$39,300Requirements1. Compute the net profit margin ratio for the years ended January 31, 2018, and 2017. Did itimprove or worsen in 2018?2. Compute asset turnover for the years ended January 31, 2018, and 2017. Did it improve orworsen in 2018?3. Compute return on assets for the years ended January 31, 2018, and 2017. Did it improveor worsen in 2018? Which component—net profit margin ratio or asset turnover—wasmostly responsible for the change in the company’s return on assets?arrow_forward(Learning Objective 7: Calculate return on assets) Hometown Supply Companyreported the following information in its comparative financial statements for the fiscal yearended January 31, 2018:January 31,2018January 31,2017Net sales....................................Net earnings..............................Average total assets...................$84,000$ 4,200$70,000$82,600$ 4,050$69,450Requirements1. Compute the net profit margin ratio for the years ended January 31, 2018, and 2017. Did itimprove or worsen in 2018?2. Compute asset turnover for the years ended January 31, 2018, and 2017. Did it improve orworsen in 2018?3. Compute return on assets for the years ended January 31, 2018, and 2017. Did it improveor worsen in 2018? Which component—net profit margin ratio or asset turnover—wasmostly responsible for the change in the company’s return on assets?arrow_forwardThe gross profit margin indicates how profitable sales have been. Q.1 Calculate the gross profit margin for Pearson & Litt for 2020.Q.2 Explain the results of the gross profit margin calculation.arrow_forward
- Compute the following for year 20171. Gross Margin Ratio2. Operating Profit Margin3. Net Profit Margin or Return on Sales4. Return on Equity5. Return on Assetsarrow_forwardPerforming horizontal analysis—income statement Data for Mulberry Designs, Inc. follow: Requirements Prepare a horizontal analysis of the comparative income statement of Mulberry Designs, Inc. Round percentage changes to one decimal place. Why did 2018 net income increase by a higher percentage than net sales revenue?arrow_forwardIncome and Education. Using Exhibit 1.8, discuss the relationship between annual income and the highest level of education completed. Provide specific examples of the difference between having no high school diploma and having a bachelors degree, and between having a bachelors degree and a professional degree.arrow_forward
- The average price of a gallon of gas in 2015 dropped $0.94 (28 percent) from $3.34 in 2014 (to $2.40 in 2015). Let's see whether these changes are reflected in the income statement of Insignia Corporation for the year ended December 31, 2015 (amounts in billions). 2015 $220 2014 $238 Revenues Cost of Purchased Crude Oil and Products Other Operating Costs Income before Income Tax Expense Income Tax Expense 120 126 57 53 43 59 19 22 Net Income $ 24 $ 37 Required: 1. Compute the gross profit percentage for each year. Assuming that the change from 2014 to 2015 is the beginning of a sustained trend, is Insignia likely to earn more or less gross profit from each dollar of sales in 2016? 2. Compute the net profit margin for each year. Given your calculations here and in requirement 1, explain whether Insignia did a better or worse job of controlling expenses other than the costs of crude oil and products in 2015 relative to 2014. 3. Insignia reported average net fixed assets of $165 billion…arrow_forwardRequired: Compute the following: (For Requirements 1 to 4, enter your percentage answers rounded to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) 1. Gross margin percentage. 2. Net profit margin percentage. 3. Return on total assets. 4. Return on equity. 5. Was financial leverage positive or negative for the year? 1. Gross margin percentage % 2. Net profit margin percentage % 3. Return on total assets % 4. Return on equity % 5. Financial Leveragearrow_forwardComputing and Interpreting Financial Statement Ratios Following are selected ratios of Norfolk Southern for 2018 and 2017. Return on Assets (ROA) Component 2018 2017 Profitability (Net income/Sales) 24.3% 52.2% Productivity (Sales/Average assets) 0.328 0.309 a. Was the company profitable in 2018?AnswerYesNo b. Was the company more profitable in 2018 or 2017?Answer20172018 c. Is the change in productivity a positive or negative development?AnswerPositiveNegative d. Compute the company’s ROA for 2018 and for 2017.Note: Round answers to one decimal places (example: 10.4%). ROA 2018 Answer 2017 Answerarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningPfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning