MyLab Accounting with Pearson eText -- Access Card -- for Horngren's Accounting, The Financial Chapters (My Accounting Lab)
11th Edition
ISBN: 9780133877502
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 17, Problem E17.15E
Performing horizontal analysis−income statement
Data for McCormick Designs, Inc. follow:
MCCORMICK DESIGNS, INC.
Comparative Income Statement
Years Ended December 31, 2016 and 2015
2016 | 2015 | |
Net Sales Revenue | $ 431,250 | $ 373,000 |
Expenses: | ||
Cost of Goods Sold | 202,000 | 189,000 |
Selling and Administrative Expenses | 100,050 | 92.550 |
Other Expenses | 8,000 | 2.150 |
total Expenses | 310,050 | 283.700 |
Net income | $ 121,200 | $89,300 |
Requirements
- Prepare a horizontal analysis of the comparative income statement of McComrmicDesigns, Inc. Round percentage changes to one decimal place.
- Why did 2016 net income increase by a higher percentage than net sales revenue?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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
-
-
-…
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%…
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%…
Chapter 17 Solutions
MyLab Accounting with Pearson eText -- Access Card -- for Horngren's Accounting, The Financial Chapters (My Accounting Lab)
Ch. 17 - Prob. 1QCCh. 17 - Prob. 2QCCh. 17 - Prob. 3QCCh. 17 - Prob. 4QCCh. 17 - Prob. 5QCCh. 17 - Prob. 6QCCh. 17 - Prob. 7QCCh. 17 - Prob. 8QCCh. 17 - Prob. 9QCCh. 17 - Prob. 10QC
Ch. 17 - Prob. 1RQCh. 17 - Prob. 2RQCh. 17 - Prob. 3RQCh. 17 - Prob. 4RQCh. 17 - Prob. 5RQCh. 17 - Prob. 6RQCh. 17 - What is benchmarking, and what are the two main...Ch. 17 - Prob. 8RQCh. 17 - Prob. 9RQCh. 17 - Prob. 10RQCh. 17 - Prob. 11RQCh. 17 - Prob. 12RQCh. 17 - Prob. 13RQCh. 17 - Prob. 14ARQCh. 17 - Prob. 15ARQCh. 17 - Prob. S17.1SECh. 17 - Prob. S17.2SECh. 17 - Prob. S17.3SECh. 17 - Performing vertical analysis Hoosier Optical...Ch. 17 - Prob. S17.5SECh. 17 - Prob. S17.6SECh. 17 - Use the following information for Short Exercises...Ch. 17 - Prob. S17.8SECh. 17 - Prob. S17.9SECh. 17 - Prob. S17.10SECh. 17 - Prob. S17.11SECh. 17 - Prob. S17.12SECh. 17 - Prob. S17.13SECh. 17 - Prob. S17.14SECh. 17 - Performing horizontal analysisincome statement...Ch. 17 - Prob. E17.16ECh. 17 - Prob. E17.17ECh. 17 - Prob. E17.18ECh. 17 - Prob. E17.19ECh. 17 - Prob. E17.20ECh. 17 - Prob. E17.21ECh. 17 - Prob. E17.22ECh. 17 - Prob. E17.23ECh. 17 - Prob. E17.24ECh. 17 - Prob. E17.25ECh. 17 - Prob. E17.26ECh. 17 - Prob. P17.27APGACh. 17 - Prob. P17.28APGACh. 17 - Prob. P17.29APGACh. 17 - Prob. P17.30APGACh. 17 - P17-31A Using ratios to evaluate a stock...Ch. 17 - Prob. P17.32APGACh. 17 - Prob. P17.33APGACh. 17 - Prob. P17.34BPGBCh. 17 - Prob. P17.35BPGBCh. 17 - Prob. P17.36BPGBCh. 17 - Prob. P17.37BPGBCh. 17 - Prob. P17.38BPGBCh. 17 - Prob. P17.39BPGBCh. 17 - Prob. P17A.40BPGBCh. 17 - Prob. P17.41CPCh. 17 - Prob. P17.1CPCh. 17 - Prob. 17.1DCCh. 17 - Prob. 17.1EICh. 17 - Prob. 17.1FSC
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
- The following select account data is taken from the records of Reese Industries for 2019. A. Use the data provided to compute net sales for 2019. B. Prepare a simple income statement for the year ended December 31, 2019. C. Compute the gross margin for 2019. D. Prepare a multi-step income statement for the year ended December 31, 2019.arrow_forwardThe following information is available for Cooke Company for the current year: The gross margin is 40% of net sales. What is the cost of goods available for sale? a. 5840,000 b. 960,000 c. 1,200,000 d. 1,220,000arrow_forwardMac 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 profitarrow_forward
- Data for Micatin Designs, Inc. follow: Data table Micatin Designs, Inc. Comparative Income Statement Years Ended December 31, 2024 and 2023 2024 2023 Net Sales Revenue $429,000 $374,000 Expenses: Cost of Goods Sold 201,000 187,000 Selling and Administrative Expenses 97,450 92,750 Other Expenses 8,500 3,250 Total Expenses 306,950 283,000 Net Income $122,050 $91,000 . Requirements 1. Prepare a comparative common-size income statement for Micatin Designs, Inc. using the 2024 and 2023 data. Round percentages to one-tenth percent. 2. To an investor, how does 2024 compare with 2023? Explain your reasoning.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_forwardSelected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2021–2015 ($ thousands) 2021 2020 2019 2018 2017 2016 2015 Sales $ 2,318 $ 2,030 $ 1,847 $ 1,693 $ 1,580 $ 1,469 $ 1,204 Cost of goods sold 1,667 1,356 1,167 1,021 949 887 707 Gross profit 651 674 680 672 631 582 497 Operating expenses 497 389 356 263 228 225 187 Net income $ 154 $ 285 $ 324 $ 409 $ 403 $ 357 $ 310 HAROUN COMPANY Comparative Year-End Balance Sheets December 31, 2021–2015 ($ thousands) 2021 2020 2019 2018 2017 2016 2015 Assets Cash $ 89 $ 118 $ 122 $ 125 $ 130 $ 128 $ 132 Accounts receivable, net 640 672 608 467 411 389 275 Merchandise inventory 2,315 1,685 1,472 1,241 1,114 946 686 Other…arrow_forward
- Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2021–2015 ($ thousands) 2021 2020 2019 2018 2017 2016 2015 Sales $ 2,260 $ 1,979 $ 1,801 $ 1,651 $ 1,540 $ 1,432 $ 1,174 Cost of goods sold 1,625 1,322 1,137 995 925 865 689 Gross profit 635 657 664 656 615 567 485 Operating expenses 483 378 347 256 222 219 182 Net income $ 152 $ 279 $ 317 $ 400 $ 393 $ 348 $ 303 HAROUN COMPANY Comparative Year-End Balance Sheets December 31, 2021–2015 ($ thousands) 2021 2020 2019 2018 2017 2016 2015 Assets Cash $ 111 $ 147 $ 153 $ 156 $ 162 $ 160 $ 165 Accounts receivable, net 800 840 760 583 514 487 343 Merchandise inventory 2,893 2,106 1,840 1,551 1,393 1,183 858 Other current assets 74 67 41 74 62 63 33 Long-term investments 0 0 0 228 228 228 228 Plant assets, net 3,541 3,527 3,086 1,740 1,799 1,599 1,373 Total assets $ 7,419 $ 6,687 $ 5,880 $ 4,332 $ 4,158 $ 3,720 $ 3,000 Liabilities and…arrow_forwardSelected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2021–2015 ($ thousands) 2021 2020 2019 2018 2017 2016 2015 Sales $ 2,272 $ 1,989 $ 1,810 $ 1,659 $ 1,548 $ 1,440 $ 1,180 Cost of goods sold 1,634 1,329 1,143 1,001 930 870 693 Gross profit 638 660 667 658 618 570 487 Operating expenses 486 380 349 257 223 220 183 Net income $ 152 $ 280 $ 318 $ 401 $ 395 $ 350 $ 304 HAROUN COMPANY Comparative Year-End Balance Sheets December 31, 2021–2015 ($ thousands) 2021 2020 2019 2018 2017 2016 2015 Assets Cash $ 85 $ 113 $ 117 $ 120 $ 124 $ 123 $ 127 Accounts receivable, net 613 644 583 447 394 373 263 Merchandise inventory 2,218 1,615 1,411 1,189 1,068 907 658 Other current assets 57 51 32 56 48 48 25 Long-term investments 0 0 0 175 175 175 175 Plant assets, net 2,715 2,704 2,365 1,334 1,379 1,226 1,052 Total assets $ 5,688 $ 5,127 $ 4,508 $ 3,321…arrow_forwardBOARD ACTIVITY Instructions: Horizontal Vertical Make a Horizontal Analysis and Vertical Analysis for 2014 2015 Analysis Analysis Revenue 1,939,500 1,674,675 1. the given SCI. Cost of Goods Sold 900,000 843,975 2. 8. Gross Profit 1,039,500 830,700 10. Selling and General Expenses 445,500 409,725 ur Other Expenses 37,575 30,825 giv 5. 11. Net Income 556,425 390,150 12.arrow_forward
- 1. Data for Abakada Trading Company are given below: 2014 2015 Revenue 1,939,500 1,674,675 Cost of Goods Sold 900,000 843,975 Gross Profit 1,039,500 830,700 Selling and General Expenses 445,500 409,725 Other Expenses 37,575 30,825 Net Income 556,425 390,150 Requirements: a. Prepare a Vertical Analysis Statement A of Comprehensive Income for 2014 and 2015 for Abakada Trading Company. b. Prepare a horizontal analysis for Abakada Trading Company.arrow_forwardSelected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2019, 2018, and 2017 2019 2018 2017 $ 292,600 Sales $ 550,381 331,329 $ 421,637 Cost of goods sold 266,053 155,584 58,186 187,264 Gross profit 219,052 105,336 38,623 Selling expenses 78,154 49,534 127,688 91,364 16,994 Administrative expenses 37,104 24,286 Total expenses 95,290 60,294 12,360 62,909 Income before taxes 42,427 Income tax expense 8,613 Net income 74,370 47,934 33,814 KORBIN COMPANY Comparative Balance Sheets December 31, 2019, 2018, and 2017 2019 2018 2017 Assets Current assets Long-term investments Plant assets, net 2$ 61,979 %24 41,483 24 55,453 600 4,440 111,633 102.135 59,592 Total assets 173,612 24 144,218 $ 119,485 Liabilities and Equity Current liabilities 2$ 25,347 21,488 $ 64,000 $ 20,910 Common stock 64,000 46,000 Other paid-in capital Retained earnings 8,000 8,000 5,111 47,464 76,265 50,730 Total liabilities and equity 24…arrow_forwardWINDSOR, INC.Income StatementFor the Year Ended December 31, 2023 Net Sales $340 Cost of Goods Sold 238 Gross Profit 102 Operating Expenses 40 Net Income $ 62 Using vertical analysis, what percentage is assigned to gross profit? 100% 70.0% 42.9% 30.0%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 LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License