Refer to the following mentioned data. (In millions) 2017 2016 2015 Net sales $34,736 $30,142 $26,512 Cost of products sold 14,970 13,615 13,307 Gross margin $19,766 $16,527 $13,205 Required: a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.) 2017 2016 % 2015 % b. Assume that Campbell's net sales for the first four months of 2018 totaled $12.15 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 (i.e., 5,000,000 should be entered as 5).) Cost of goods sold million Gross profit million

Refer to the following mentioned data. (In millions) 2017 2016 2015 Net sales $34,736 $30,142 $26,512 Cost of products sold 14,970 13,615 13,307 Gross margin $19,766 $16,527 $13,205 Required: a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.) 2017 2016 % 2015 % b. Assume that Campbell's net sales for the first four months of 2018 totaled $12.15 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 (i.e., 5,000,000 should be entered as 5).) Cost of goods sold million Gross profit million

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

In 2016, the automobile Industry announced the average vehicle selling price was $44,466. Six years earlier, the average price was $28,480. hun What was the annual percentage Increase in vehicle selling price? (Do not round Intermediate calculations and round your final answer to 2 decimal places.) Annual percentage Increase in selling price %
Q1) You are required to calculate the Relative Percentage Change in the company for the blanks below and the Net Profit for the other blanks. Show all working out below including the formula used for each year and include the completed table here. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Net Profit ($ 000’) <blank> 50 200 150 225 250 <blank> 200 250 260 Relative Percentage Change N/A -50% 300% <blank> 50% 11% -30% 14% 25% <blank> Table 1: Net Profit ($) per financial year Q1 a) Using Excel, create a column chart of the Net Profit calculated in part (a) for the years 2010-2019. label the axis and provide an appropriate title. Q1 b) Using Excel, create a Sparkline of the Relative Percentage Change calculated in part (a) for the years 2011-2019. use the Sparkline options to mark if there are any negative values and include a horizontal axis to easily visualise…
Krogen Grocer’s 2016 financial statements show net income of $1,680 million, sales of $153,466 million, and average total assets of $46,350 million.How much is Krogen Grocer’s return on sales for the year? Question 22 options: A) 1.09% B) 30.20% C) 3.62% D) 6.42%
What is the sustainable growth rate for 2015? Narrow Falls Lumber 2015 Income Statement Net sales Cost of goods sold Depreciation EBIT Interest Taxable income Taxes Net income Dividends Cash Accounts receivable Inventory Net fixed assets Total assets Select one: a. 10.91% b. 14.46% c. 15.54% d. 12.63% e. 13.97% $28,200 $848,600 542,800 147,400 $158,400 12,600 $145,800 51,800 $94.000 Narrow Falls Lumber Balance Sheets as of December 31, 2014 and 2015 2015 2014 $ 32,300 $ 26,900 74,700 72,300 99,500 97,800 707,100 705,000 $913.600 $902,000 Accounts payable Notes payable Long-term debt Common stock and paid-in surplus ($1 par value) Retained earnings Total liabilities & owners' equity 2015 2014 $ 78,900 $ 79,200 40,000 354,500 50,000 295,600 170,000 175,000 319.100 253,300 $913.600 $902,000
Please do not give solution in image format thanku
Smith Corporation had Sales of $2,350,000 in 2021 and $2,125,000 in 2020. Cost of Good Sold were $1,400,000 in 2021 and $1,325,000 in 2020. a. What was the percentage change in Sales year to year? b. What was the percentage change in Cost of Goods Sold year to year? c. Relative to the percentage in Sales, would you say the percentage change on Cost of Goods Sold was favorable or unfavorable? d. Is this an example of horizontal or vertical analysis?
The following information is taken from the financial statements of Down Home Deli for the last three years. The owner, John Walton is quite pleased to see that his sales are growing steadily. 2018 2017 2016 Sales $ 61,500 $ 50,400 $ 42,000 Cost of goods sold 27,670 21,170 16,800 Operating income 7,530 6,050 4,620 Net income 3,075 4,030 2,940 Instructions: (a) Calculate gross profit margin, profit margin, and profit margin using operating income. (b) Comment on whether the Deli is, in fact, doing better over the three years as John believes.
Solve the Following
ILLUSTRATION 7. From the following information, interpret the results of operations of manufacturing concern using trend ratios : (Amount in '000 $ For the year ended 31st March 2016 2015 2014 2013 10,000 9,500 5,890 Sales (net) 13,000 12,000 Cost of Goods Sold 7,280 6,960 6,000 5,040 1,100 3,610 970 4,000 1,000 Gross Profit 5,720 Selling Expenses 1,200 Net Operating Profit 4,520 3,940 2,640 3,000
Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2021-2015 ($ thousands) Sales 2021 Cost of goods sold $ 1,769 1,271 2020 $ 1,549 2019 2018 2017 2016 2015 $ 1,410 $ 1,292 $ 1,206 $ 1,121 $ 919 1,034 889 778 723 676 539 Gross profit 498 515 521 514 483 445 380 Operating expenses Net income 377 295 271 200 173 171 142 $ 121 $ 220 $ 250 $ 314 $ 310 $ 274 $ 238 HAROUN COMPANY Comparative Year-End Balance Sheets December 31, 2021-2015 ($ thousands) Assets Cash Accounts receivable, net Merchandise inventory Other current assets Long-term investments Plant assets, net Total assets Liabilities and Equity 2021 2020 2019 2018 2017 2016 2015 $ 108 773 $ 142 812 $ 148 735 2,797 2,036 1,779 $ 151 564 1,499 $ 157 496 $ 155 $ 160 470 332 1,346 1,144 829 72 65 40 71 60 61 32 e B 220 220 220 220 3,422 3,409 2,982 1,683 $ 7,172 $ 6,464 $ 5,684 $ 4,188 $ 4,019 1,740 1,546 $ 3,596 $ 2,900 1,327 Current liabilities…
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)…
Sales SOLVE IT ON MS EXCEL or GOOGLE SPREADSHEET (please send the file) Ziegen, Inc. Income Statement for 2013 Make a Proforma Income Statement and ProForma Balance Sheet using the Financial Planning attached. Use 15% as the Sales Growth Rate of the 2013 base year, all other data remain the same. Net Income Ziegen, Inc. Balance Sheet for 2013 Current assets Net fixed assets Total Total Accounts payable Accrued expenses Notes payable Current liabilities Long-term debt Total liabilities Common stock (par) Paid-in capital Retained earnings Common equity $10,000,000 $ 500,000 $ 2,000,000 4,000,000 $ 6,000,000 $ 1,000,000 1,000,000 500,000 $ 2,500,000 2,000,000 $ 4,500,000 100,000 200,000 1,200,000 $ 1,500,000 $6,000,000 Calculation $.5m/$10m = Calculation $2m/$10m = $4m/$10m = $1m/$10m = $1m/$10m = Ziegen, Inc. Pro Forma Income % of 2013 Sales Statement for 2014 5.0% % of 2013 Sales 20.0% 40.0% 10.0% 10.0% NAª NA NA" NA" Calculation 20% Sales growth rate = Sales Net Income Ziegen, Inc. Pro…

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS