Perform a horizontal analysis of the company Fiscal year is October-September. All values CAD Millions.202120202019201820175-year trendSales/Revenue18,28317,99816,76814,38313,175Sales Growth1.59%7.34%16.58%9.17%Cost of Goods Sold (COGS) incl. D&A16,19315,92914,69112,65311,566COGS excluding D&A15,71515,46814,40512,41911,371Depreciation & Amortization Expense478462286233194Depreciation400387210185164Amortization of Intangibles7875754830COGS Growth1.66%8.43%16.11%9.40%Gross Income2,0902,0682,0771,7311,610Gross Income Growth1.05%-0.41%19.99%7.52%Gross Profit Margin11.43%SG&A Expense8358371,009876842Other SG&A8371,009876842SGA Growth-0.19%-17.06%15.23%3.98%Other Operating Expense11EBIT1,2551,2311,068844768Unusual Expense237(175)(5)Non Operating Income/Expense(5)(12)391,104(5)Non-Operating Interest Income14118292co Interest Expense14314410910661Interest Expense Growth-0.42%31.56%3.60%72.10%Gross Interest Expense14314410910661Pretax Income1,1211,0849692,046708Pretax Income Growth3.36%11.88%-52.63%188.85%Pretax Margin6.13%Income Tax295288255358193Income Tax - Current Domestic255271232422151Income Tax - Deferred Domestic401723(63)42Equity in Affiliates3194Consolidated Net Income8267967141,719608Minority Interest Expense313217Net Income8237957121,717592Net Income Growth3.50%11.75%-58.54%190.10%Net Margin4.50%Net Income After Extraordinaries8237957121,717592Net Income Available to Common8237957121,717592

Horizontal analysis is a technique for examining a corporation's financial records throughout time.…

year is October-September. All välues CAD Millions. 2021 2020 2019 2018 201 5-year trer Sales/Revenue 18,283 17,998 16,768 14,383 13,175 Sales Growth 1.59% 7.34% 16.58% 9.17% Cost of Goods Sold (COGS) incl. D&A 16,193 15,929 14,691 12,653 11,566 COGS excluding D&A 15,715 15,468 14,405 12,419 11,371 Depreciation & Amortization Expense 478 462 286 233 194 Depreciation 400 387 210 185 164 Amortization of Intangibles 78 5ל 75 48 30 COGS Growth 1.66% 8.43% 16.11% 9.40% Gross Income 2,090 2,068 2,077 1,731 1,610 Gross Income Growth 1.05% -0.41% 19.99% 7.52% Gross Profit Margin 11.43% SG&A Expense 835 837 1,009 876 842 Other SG&A 837 1,009 876 842 SGA Growth -0.19% 17.06% 15.23% 3.98% Other Operating Expense 11 EBIT 1,255 1,231 1,068 844 768 Unusual Expense 37 (175) (5) 2.

year is October-September. All välues CAD Millions. 2021 2020 2019 2018 201 5-year trer Sales/Revenue 18,283 17,998 16,768 14,383 13,175 Sales Growth 1.59% 7.34% 16.58% 9.17% Cost of Goods Sold (COGS) incl. D&A 16,193 15,929 14,691 12,653 11,566 COGS excluding D&A 15,715 15,468 14,405 12,419 11,371 Depreciation & Amortization Expense 478 462 286 233 194 Depreciation 400 387 210 185 164 Amortization of Intangibles 78 5ל 75 48 30 COGS Growth 1.66% 8.43% 16.11% 9.40% Gross Income 2,090 2,068 2,077 1,731 1,610 Gross Income Growth 1.05% -0.41% 19.99% 7.52% Gross Profit Margin 11.43% SG&A Expense 835 837 1,009 876 842 Other SG&A 837 1,009 876 842 SGA Growth -0.19% 17.06% 15.23% 3.98% Other Operating Expense 11 EBIT 1,255 1,231 1,068 844 768 Unusual Expense 37 (175) (5) 2.

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter9: Metric-analysis Of Financial Statements

Section: Chapter Questions

Problem 9.4.6P: Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of...

See similar textbooks

Similar questions

Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?
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,000
Financial statement data for years ending December 31 for Holland Company follow: a. Determine the inventory turnover for 20Y4 and 20Y3. b. Determine the days sales in inventory for 20Y4 and 20Y3. Use 365 days and round to one decimal place. c. Does the change in inventory turnover and the days sales in inventory from 20Y3 to 20Y4 indicate a favorable or an unfavorable trend?
Financial statement data for years ending December 31 for Tango Company follow: a. Determine the inventory turnover for 20Y7 and 20Y6. b. Determine the days sales in inventory for 20Y7 and 20Y6. Use 365 days and round to one decimal place. c. Does the change in inventory turnover and the days sales in inventory from 20Y6 to 20Y7 indicate a favorable or an unfavorable trend?
Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Days’ sale in receivable
Comprehensive The following information for 2019 is available for Marino Company: 1. The beginning inventory is 100,000. 2. Purchases returns of 4,000 were made. 3. Purchases of 300,000 were made on terms of 2/10, n/30. Eighty percent of the discounts were taken. 4. At December 31, purchases of 20,000 were in transit, FOB destination, on terms of 2/10, n/30. 5. The company made sales of 640,000. The gross selling price per unit is twice the net cost of each unit sold. 6. Sales allowances of 6,000 were made. 7. The company uses the LIFO periodic method and the gross method for purchase discounts. Required: 1. Compute the cost of the ending inventory before the physical inventory is taken. 2. Compute the amount of the cost of goods sold that came from the purchases of the period and the amount that came from the beginning inventory.
Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.
On January 1, Pope Enterprises inventory was 625,000. Pope made 950,000 of net purchases during the year. On its year-end income statement, Pope reported cost of goods sold of 1,025,000. Calculate Popes December 31 ending inventory.
Cost of goods sold and related items The following data were extracted from the accounting records of Harkins Company for the year ended April 30, 20Y8: Estimated returns of current year sales 11,600 Inventory, May 1, 20Y7 380,000 Inventory, April 30, 20Y8 415,000 Purchases 3,800,000 Purchases returns and allowances 150,000 Purchases discounts 80,000 Sales 5,850,000 Freight in 16,600 a. Prepare the Cost of goods sold section of the income statement for the year ended April 30, 20Y8, using the periodic inventory system. b. Determine the gross profit to be reported on the income statement for the year ended April 30, 20Y8. c. Would gross profit be different if the perpetual inventory system was used instead of the periodic inventory system?
Refer to RE22-2. Assume Heller Company had sales revenue of 510,000 in 2019 and 650,000 in 2020. Prepare Hellers partial income statements (through gross profit) for 2019 and 2020. RE22-2 Heller Company began operations in 2019 and used the LIFO method to compute its 300,000 cost of goods sold for that year. At the beginning of 2020, Heller changed to the FIFO method. Heller determined that its cost of goods sold under FIFO would have been 250,000 in 2019. For 2020, Hellers cost of goods sold under FIFO was 360,000, while it would have been 410,000 under LIFO. Heller is subject to a 21% income tax rate. Compute the cumulative effect of the retrospective adjustment on prior years income (net of taxes) that Heller would report on its retained earnings statement for 2020.
Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Inventory turnover
Juroe 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.