S18-1 Horizontal analysis McCormick Ltd reported the following on its comparative income statement: (In millions) 2016 2015 2014 Revenue $9 575 $9 300 $8 975 Cost of sales 6 000 5 975 5 900 Requirement Prepare a horizontal analysis of revenues and gross profit–both in dollar amounts and in percentages-for 2016 and 2015.

S18-1 Horizontal analysis McCormick Ltd reported the following on its comparative income statement: (In millions) 2016 2015 2014 Revenue $9 575 $9 300 $8 975 Cost of sales 6 000 5 975 5 900 Requirement Prepare a horizontal analysis of revenues and gross profit–both in dollar amounts and in percentages-for 2016 and 2015.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

What is the percent change in a trend analysis of income statement for the gross profit?
Analysis and Interpretation of ProfitabilityBalance sheets and income statements for 3M Company follow. 3M COMPANY Consolidated Statements of Income For Years ended December 31 ($ millions) 2018 2017 Net sales $32,765 $31,657 Operating expenses Cost of sales 16,682 16,055 Selling, general and administrative expenses 7,602 6,626 Research, development and related expenses 1,821 1,870 Gain on sale of businesses (547) (586) Total operating expenses 25,558 23,965 Operating income 7,207 7,692 Other expense, net* 207 144 Income before income taxes 7,000 7,548 Provision for income taxes 1,637 2,679 Net income including noncontrolling interest 5,363 4,869 Less: Net income attributable to noncontrolling interest 14 11 Net income attributable to 3M $ 5,349 $ 4,858 *Interest expense, gross $350 million in 2018 and $322 million in 2017. 3M COMPANY Consolidated Balance Sheets At December 31 ($ millions, except per share amount) 2018 2017…
Data for Sherman, Inc. are as follows: Net Sales Cost of Goode Sold Selling and Administrative Expenses Other Expenses Income Tax 2017 $850,000 635,000 50,000 20,000 40,000 Use the editor to format your answer 2016 $798,000 580,000 35,000 15,000 55,000 Prepare a horizontal analysis of the comparative income statement of Sherman, Inc. (Round to one decimal place.) Use a multi-step income statement.
discuss the results of the Company's Horizontal and Vertical Analysis from 2014-2018
I. Complete the horizontal analysis below. Use the name of the company you belong to in your iLS Activity. Round off your answers to the nearest hundredths. Name: Income Statement for the years ending December 31, 201X and December 31, 201Y 2015 2016 Annual Percentage Growth 2015-2016 Sales 475,000 500,000 1. Cost of Goods Sold 265,000 269,000 2. Gross Profit 210,000 231,000 3. Wages 154,000 163,000 4. Repairs 5,800 4,150 5. Rent 13,000 12,000 6. Taxes 16,940 17,930 7. Office Expenses 1,023 587 8. Total Expenses 190,763 197,667 9. Net Income 19,237 33,333 10. II. Analyze the following ratios (Good/Not good, Undervalued/Overvalued, or just OK) based on the given industry averages. Write the answers in the spaces provided. Ratios Annual Data Industry Average Interpretation Current 5.7 4 Days Sales Outstanding 37 days 42 days Total Debt to Total Capital 47.80% 32.60% Times-Interest Earned 2.2 6 Profit Margin 6.10% 6.00% Return on Invested Capital 10.03% 10.00% Enterprise Value to EBITDA…
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
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)…
9 - The income statement of a Business for the period 2019 is as follows: 31.12.2019 % Gross sales 45.200 TL 102.72 Discounts From Sales 1.200 TL 2.72 Net Sales 44,000 TL 100.00 Cost of sales 12.500 TL 28.41 Gross Profit on Sales 31,500 TL 71.59 This table was prepared according to which of the following analysis methods? a) Technical analysis B) Analysis with Vertical Percentage Method NS) Ratio Analysis D) Comparative Tables Analysis TO) Trend Percentages Analysis
The following balances were reported in the financial statements for Ruby Company. 2016 2015 Net Sales $1,650,000 $1,750,000 Net Income 170,000 205,000 Current Assets 410,000 535,000 Current Liabilities 170,000 210,000 Total Liabilities 500,000 675,000 Total Assets 1,550,000 2,450,000 Required: 1. Compute the following ratios for 2016 and 2015 for Ruby Company. a. Return on sales ratio b. Current ratio c. Debt-to-total-assets ratio
PSA12.1 Here are comparative statement data for Spencer Ltd and Forrester Lnd, two competito All data relating to the statement of financial position are as at 30 June, the end of the reporting period for both entities. SPENCER LTD FORRESTER LTD 2016 2015 2016 2015 Net sales $1 250 000 $410 000 Cost of sales 690 000 257 000 Operating expenses Finance costs 321 000 62 000 6 000 1 200 Income tax expense Profit 69 900 26 940 163 100 62 860 Current assets 325 975 $ 312 410 S 180 000 188 000 Non-current assets Current liabilities 521 310 500 000 240 000 216 000 79 595 75 815 36 000 32 000 Non-current liabilities 108 500 90 000 27 000 24 000 Share capital, $10 each Retained earnings 500 000 500 000 320 000 300 000 159 190 40 000 146 595 45 000 Required Comment on the relative profitability of the entities (2 comments) by calculating the profit margin, return on assets and the asset turnover for both entities.
I need assistance in finding the ratios for the following (see attached sheets). Calculate the following financial ratios for 2016 and 2017 10. Average collection period 11. Inventory turnover ( 2015, inventory = $1,540.9 million) 12. Days' sales in inventory