FUND.ACCT.PRIN -ONLINE ONLY >I<
22nd Edition
ISBN: 9780077632878
Author: Wild
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17, Problem 5QS
Refer to the information in QS17-4. Use that information for Tide Corporation to determine the 2014 and 2015 common-size percents for cost of goods sold using net sales as the base.
Common-size analysis P2
Use the following information for Tide Corporation to determine the 2014 and 2015 trend percents for net sales QS 17-4 using 2014 as the base year.
Trend percents
| r ($ thousands) |
20IS | 12014 |
| Net sales | $801,810 | $453,000 |
| Cost of goods sold | 392,887 | 134.088 |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
!
Required information
Use the following information to determine the prior year and current year trend percents for net sales using
the prior year as the base year.
($ thousands)
Net sales
Cost of goods sold
Current Year Prior Year
$ 802,971
394,306
$ 454,365
135,325
Current Year:
Prior Year:
Determine the Prior Year and Current Year common-size percents for cost of goods sold using net sales as the base. (Enter the
answers in thousands of dollars.)
Common-Size Percent for Cost of Goods Sold using Net Sales as the base:
Denominator:
Numerator:
Analysis period cost of goods sold
$
$
Check my work
394,306 /
135,325 / $
454,365
Common-size percents
0 %
29.78 %
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%…
Chapter 17 Solutions
FUND.ACCT.PRIN -ONLINE ONLY >I<
Ch. 17 - Prob. 1DQCh. 17 - What is the difference between comparative...Ch. 17 - Prob. 3DQCh. 17 - Prob. 4DQCh. 17 - Prob. 5DQCh. 17 - Prob. 6DQCh. 17 - Prob. 7DQCh. 17 - Prob. 8DQCh. 17 - Prob. 9DQCh. 17 - How does inventory turnover provide information...
Ch. 17 - What ratios would you compute to evaluate...Ch. 17 - Why would a company’s return on total assets be...Ch. 17 - Prob. 13DQCh. 17 - Prob. 14DQCh. 17 - Prob. 15DQCh. 17 - Prob. 16DQCh. 17 - Prob. 17DQCh. 17 - Prob. 1QSCh. 17 - Prob. 2QSCh. 17 - Prob. 3QSCh. 17 - Prob. 4QSCh. 17 - Refer to the information in QS17-4. Use that...Ch. 17 - Prob. 6QSCh. 17 - Prob. 7QSCh. 17 - Prob. 8QSCh. 17 - Prob. 9QSCh. 17 - Prob. 1ECh. 17 - Exercise 17-2
Identifying financial...Ch. 17 - Prob. 3ECh. 17 - Prob. 4ECh. 17 - Prob. 5ECh. 17 - Prob. 6ECh. 17 - Prob. 7ECh. 17 - Prob. 8ECh. 17 - Prob. 9ECh. 17 - Prob. 10ECh. 17 - Prob. 11ECh. 17 - Prob. 12ECh. 17 - Prob. 13ECh. 17 - Prob. 14ECh. 17 - Prob. 15ECh. 17 - Prob. 1APSACh. 17 - Prob. 2APSACh. 17 - Prob. 3APSACh. 17 - Prob. 4APSACh. 17 - Prob. 5APSACh. 17 - Prob. 6APSACh. 17 - Prob. 1BPSBCh. 17 - Prob. 2BPSBCh. 17 - Prob. 3BPSBCh. 17 - Prob. 4BPSBCh. 17 - Prob. 5BPSBCh. 17 - Prob. 6BPSBCh. 17 - Prob. 17SPCh. 17 - Prob. 1BTNCh. 17 - Prob. 2BTNCh. 17 - Prob. 3BTNCh. 17 - Prob. 4BTNCh. 17 - Prob. 5BTNCh. 17 - Prob. 6BTNCh. 17 - Prob. 7BTNCh. 17 - Prob. 8BTNCh. 17 - Prob. 9BTN
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 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_forwardGIVE 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_forwardRequired information ($ thousands) Net sales Cost of goods sold Current Year $ 885,182 396,513 Current Year: Prior Year: Determine the Prior Year and Current Year trend percents for net sales using the Prior Year as the base year. (Enter the answers in thousands of dollars.) Prior Year $ 456,779 137,643 Numerator: Trend Percent for Net Sales: Denominator: Trend Percent 0% 0%arrow_forward
- Use the following selected information from Corolla to determine the Year 1 and Year 2 trend percentages for net sales using Year 1 as the base. Year 2 Year 1 Net sales $ 281,200 $ 232,400 Cost of goods sold 150,900 130,590 Operating expenses 54,240 52,240 Net earnings 29,020 20,820arrow_forwardVertical analysis (common-size) percentages for Cullumber Company’s sales revenue, cost of goods sold, and expenses are listed here. Vertical Analysis 2022 2021 2020 Sales revenue 100.0 % 100.0 % 100.0 % Cost of goods sold 60.0 64.2 65.6 Expenses 24.7 27.1 29.5 Calculate Cullumber’s net income as a percent of sales. (Round answers to 1 decimal place, e.g. 5.2.) 2022 2021 2020 Net income Enter percentages rounded to 1 decimal place. Enter percentages rounded to 1 decimal place. Enter percentages rounded to 1 decimal place. Did Cullumber’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period? Cullumber’s net income as a percent of sales Choose the correct answer increaseddecreasedremained unchangedarrow_forwardRefer to the following mentioned data. Net sales Cost of products sold Gross margin 2017 2016 2015 Required: a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.) (In millions) 2016 2017 2015 $34,894 $30,411 $26,113 14,318 13,376 13,767 $20,576 $17,035 $12,346 Cost of goods sold Gross profit 58.94 % % % b. Assume that Campbell's net sales for the first four months of 2018 totaled $12.79 billion. Calculate an estimated cost of goods sold and gross profit for the four months, using the gross profit ratio for 2017. (Round Intermediate calculations to 2 decimal places. Enter your answers in millions rounded to nearest whole number (1.e., 5,000,000 should be entered as 5).) million millionarrow_forward
- 2. Complete the below table to calculate income statement data in common-size percents. (Round your percentage answers to 2 decimal places.) KORBIN COMPANY Common-Size Comparative Income Statements For Years Ended December 31, 2019, 2018, and 2017 2019 2018 2017 Sales % % % Cost of goods sold -1 -1 -1 Gross profit Selling expenses -1 -1 -1 Administrative expenses -1 -1 -1 Total expenses Income before taxes -1 -1 -1 Income tax expense -1 -1 -1 Net income % % % See picturearrow_forwardRefer to the following mentioned data. Net sales Cost of products sold Gross margin (In millions) 2017 2016 $34,954 $30, 040 14,274 13, 395 $20, 680 $16, 645 2017 2016 2015 Required: a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.) 2015 $26, 091 13, 655 $12, 436 59.16 % 55.41 % 47.66 %arrow_forwardCommon-size and trend percents for Roxi Company's sales, cost of goods sold, and expenses follow. P nt 7 erences SC Sales Cost of goods sold Operating expenses Fn Change in Net Income Type here to search Sales Cost of Goods Sold Operating Expenses Net Income Net Income F1 Determine the net income for the following years. Did the net income increase, decrease, or remain unchanged in this three-y period? Complete this question by entering your answers in the tabs below. X Common-Size Percents 1 Year Ago Current Year 100.0% 63.4 14.3 F2 A Determine the net income for the following years. Assuming sales were $100,000 2 yrs ago, what is net income in each year? (Enter all amounts as positive values.) Current Year 100.0% 61.2 13.8 F3 E F6 2 Years Ago 100.0% 100.0 100.0 A + DELL F7 F8 F9 0 Farrow_forward
- Common-size and trend percents for Roxi Company's sales, cost of goods sold, and expenses follow. Trend Percents 1 Year Ago Sales Cost of goods sold Operating expenses Change in Net Income Common-Size Percents Net Income Current Year 100.0% 63.4 15.3 Sales Cost of Goods Sold Operating Expenses Net Income 1 Year Ago 100.0% 61.9 14.8 Complete this question by entering your answers in the tabs below. Determine the net income for the following years. Did the net income increase, decrease, or remain unchanged in this three-year period? 2 Years Ago 100.0% 59.1 15.1 Current Year 1 Year Ago Current Year 105.4% 113.1 106.8 Determine the net income for the following years. Assuming sales were $100,000 2 yrs ago, what is net income in each year? (Enter all amounts as positive values.)arrow_forwardPerform a horizontal analysis for the entry "Gross Sales" shown on the income statement portion below. (Round percentages to one decimal place.) Increase/Decrease Revenue 2019 2018 Amount Percent Gross Sales $277,000 $200,100 $ % Less: Sales Returns and Allowances 14,200 12,400 Net Sales 262,800 187,700 Cost of Goods Sold Merchandise Inventory 31,900 33,800 Net Purchases 60,300 55,500 Goods Available for Sale 92,200 89,300 Less: Merchandise Inventory, Dec. 31 43,000 60,200 Cost of Goods Sold 49,200 29,100 Gross Margin 213,600 158,600arrow_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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License