MANAGERIAL ACCOUNTING FUND. W/CONNECT
5th Edition
ISBN: 9781259688713
Author: Wild
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 13, Problem 4QS
To determine
Concept introduction:
Financial Statement analysis is done using the components of financial statement. These components are
Vertical Analysis: Vertical Analysis is used to analyses the % of items in statement for a particular period as the % of total amount. Vertical Analysis is done for particular period for different items. For example analysis of % of assets as % of Total assets for a particular year is done using the Vertical analysis.
Horizontal Analysis: Horizontal Analysis is used to analyses the trend of a particular item. Horizontal Analysis is done for particular items for different periods for example analysis of trend of sales for several years is done using the horizontal analysis.
To calculate:
The Trend % for Net Sales.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Refer 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
million
Refer 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 %
The Cullumber Supply Company reported the following information for 2017. Prepare a common-size income statement for the year ended June 30, 2017. (Round answers to 1 decimal place, e.g. 52.7%.)
Cullumber Supply CompanyIncome Statement for the Fiscal Year Ended June 30, 2017($ thousands)
% of Net Sales
Net sales
$2,111,000
enter percentages of net sales %
Cost of goods sold
1,464,000
enter percentages of net sales %
Selling and administrative expenses
312,200
enter percentages of net sales %
Nonrecurring expenses
27,600
enter percentages of net sales %
Earnings before interest, taxes, depreciation, and amortization (EBITDA)
$307,200
enter percentages of net sales %
Depreciation
117,000
enter percentages of net sales %
Earnings before interest and taxes (EBIT)
190,200
enter percentages of net sales %
Interest expense
118,600
enter percentages of net sales %
Earnings before taxes (EBT)…
Chapter 13 Solutions
MANAGERIAL ACCOUNTING FUND. W/CONNECT
Ch. 13 - Prob. 1MCQCh. 13 - Prob. 2MCQCh. 13 - Prob. 3MCQCh. 13 - Prob. 4MCQCh. 13 - Prob. 5MCQCh. 13 - Prob. 1DQCh. 13 - Prob. 2DQCh. 13 - Prob. 3DQCh. 13 - Prob. 4DQCh. 13 - Prob. 5DQ
Ch. 13 - Prob. 6DQCh. 13 - Prob. 7DQCh. 13 - Prob. 8DQCh. 13 - Prob. 9DQCh. 13 - Prob. 10DQCh. 13 - Prob. 11DQCh. 13 - Prob. 12DQCh. 13 - Where on the income statement does a company...Ch. 13 - Prob. 14DQCh. 13 - Prob. 15DQCh. 13 - Prob. 16DQCh. 13 - Use Samsungs financial statements in Appendix A to...Ch. 13 - Prob. 1QSCh. 13 - Prob. 2QSCh. 13 - Prob. 3QSCh. 13 - Prob. 4QSCh. 13 - Prob. 5QSCh. 13 - Prob. 6QSCh. 13 - Prob. 7QSCh. 13 - Prob. 8QSCh. 13 - Prob. 9QSCh. 13 - Prob. 1ECh. 13 - Prob. 2ECh. 13 - Prob. 3ECh. 13 - Prob. 4ECh. 13 - Prob. 5ECh. 13 - Prob. 6ECh. 13 - Prob. 7ECh. 13 - Prob. 8ECh. 13 - Prob. 9ECh. 13 - Prob. 10ECh. 13 - Prob. 11ECh. 13 - Prob. 12ECh. 13 - Prob. 13ECh. 13 - Prob. 14ECh. 13 - Prob. 15ECh. 13 - Prob. 1PSACh. 13 - Prob. 2PSACh. 13 - Prob. 3PSACh. 13 - Selected year-end and financial statement of...Ch. 13 - Prob. 5PSACh. 13 - Prob. 6PSACh. 13 - Prob. 1PSBCh. 13 - Prob. 2PSBCh. 13 - Kato Corporation began the month of June with...Ch. 13 - Prob. 4PSBCh. 13 - Prob. 5PSBCh. 13 - Prob. 6PSBCh. 13 - This serial Problem began in Chapter 1 and...Ch. 13 - Refer to Apples financial statements in appendix A...Ch. 13 - Prob. 2BTNCh. 13 - Prob. 3BTNCh. 13 - Prob. 4BTNCh. 13 - Prob. 5BTNCh. 13 - Prob. 6BTNCh. 13 - Prob. 7BTNCh. 13 - Prob. 8BTNCh. 13 - 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_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_forwardThe following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.arrow_forward
- Last year, Nikkola Company had net sales of 2,299,500,000 and cost of goods sold of 1,755,000,000. Nikkola had the following balances: Refer to the information for Nikkola Company above. Required: Note: Round answers to one decimal place. 1. Calculate the average inventory. 2. Calculate the inventory turnover ratio. 3. Calculate the inventory turnover in days. 4. CONCEPTUAL CONNECTION Based on these ratios, does Nikkola appear to be performing well or poorly?arrow_forwardUse the following information for the Quick Studies below. (Algo) ($ thousands) Net sales Current Year $ 802,213 393,339 Prior Year $ 453,350 134,505 Cost of goods sold QS 13-7 (Algo) Trend percents LO P1 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.) Current Year: Prior Year: Numerator: Trend Percent for Net Sales: 1 1 1 Denominator: = = = Trend Percent 0% 0 %arrow_forwardRevenue and expense data for Soldner Inc. are as follows: 2014 2013 Sales $1,500,000 $1,450,000 Cost of goodssold 930,000 812,000 Selling expenses 210,000 261,000 Administrative expenses 255,000 232,000 Income tax expense 52,500 72,500 a. Prepare an income statement in comparative form, stating each item for both 2014 and 2013 as a percent of sales. Round to one decimal place. b. Comment on the significant changes disclosed by the comparative income statement.arrow_forward
- 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. (Enter the answers in thousands of dollars.) ($ thousands) CurrentYear PriorYear Net sales $ 453,100 $ 230,000 Cost of goods sold 222,019 68,080 Trend Percent for Net Sales: Choose Numerator: / Choose Denominator: / = Trend Percent Current Year: / = % Prior Year: / = %arrow_forwardColeman, Inc. provides the following data from its Income Statement for 2018: Net Sales $ 560,000.00 Cost of Goods Sold $ (160,000.00) Gross Profit $ 400,000.00 Calculate the gross profit percentage. (round your answer to two decimal places) A 71.43% B 25.00% C 100.00% D 28.57%arrow_forwardUse the following information to determine the Prior Year and Current Year trend percents for net sales using the Prior Year a base year. (Enter the answers in thousands of dollars.) Current Prior ($ thousands) Year Year $1,155,080 $431,000 565,989 Net sales Cost of goods sold 127,576 Trend Percent for Net Sales: Choose Numerator: IChoose Denominator: Trend Percent %3D Current Year: %3D Prior Year: % %Darrow_forward
- ! Required information Use the following information for the Quick Studies below. (Algo) ($ thousands) Net sales Current Year $ 803,470 394,775 Prior Year $ 455,095 135,878 Cost of goods sold QS 17-7 (Algo) Trend percents LO P1 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.) Current Year: Prior Year: Numerator: Trend Percent for Net Sales: 1 1 1 1 Denominator: = = = Trend Percent 0 % 0 %arrow_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_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,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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License