The following data are from Kellogg's 10-K report dated December 29, 2018 ($ millions). Revenue Interest expense Tax expense Amortization expense Depreciation expense $13,547 Earnings from continuing operations $1,344 Capital expenditures (CAPEX) 578 287 181 23 493 Total debt 8,893 Average assets 17,066 a. Use the data above to calculate the following ratios: EBITA/Average assets, EBITA Margin, EBITA/ Interest expense, Debt/EBITDA, CAPEX/Depreciation Expense. Definitions for these ratios are in Exhibit 7.4.

The following data are from Kellogg's 10-K report dated December 29, 2018 ($ millions). Revenue Interest expense Tax expense Amortization expense Depreciation expense $13,547 Earnings from continuing operations $1,344 Capital expenditures (CAPEX) 578 287 181 23 493 Total debt 8,893 Average assets 17,066 a. Use the data above to calculate the following ratios: EBITA/Average assets, EBITA Margin, EBITA/ Interest expense, Debt/EBITDA, CAPEX/Depreciation Expense. Definitions for these ratios are in Exhibit 7.4.

Financial Accounting: The Impact on Decision Makers

10th Edition

ISBN:9781305654174

Author:Gary A. Porter, Curtis L. Norton

Publisher:Gary A. Porter, Curtis L. Norton

Chapter13: Financial Statement Analysis

Section: Chapter Questions

Problem 13.8E

See similar textbooks

Similar questions

Assigning a Long-Term Debt Rating Using Financial Ratios Refer to the information below from Stryker’s 2018 financial statements. Use the information to answer the requirements ($ millions). Revenue $13,601 Interest expense, gross $181 Depreciation expense 306 Dividends, including to noncontrolling interest 717 Amortization expense 417 Cash and cash equivalents 3,616 Operating profit (EBIT) 2,537 Marketable securities 83 Total debt 9,859 Average assets 24,713 Cash from operating activities 2,610 CAPEX 572 Funds from operations 2,852 a. Compute the following 10 Moody’s metrics for Stryker for 2018.Round all answers (except Revenue) to one decimal place (example for percentage ratios: 0.2345 = 23.5%). Ratio Debt / EBITDA Answer EBITA to interest expense Answer Revenue ($ millions) Answer Retained Cash Flow / Net Debt Answer EBITA margin Answer Operating margin Answer FFO / Debt Answer (FFO + Interest Expense)/Interest Expense Answer…
Assigning a Long-Term Debt Rating Using Financial Ratios Refer to the information below from Stryker’s 2018 financial statements. Use the information to answer the requirements ($ millions). Revenue $13,601 Interest expense, gross $181 Depreciation expense 306 Dividends, including to noncontrolling interest 717 Amortization expense 417 Cash and cash equivalents 3,616 Operating profit (EBIT) 2,537 Marketable securities 83 Total debt 9,859 Average assets 24,713 Cash from operating activities 2,610 CAPEX 572 Funds from operations 2,852 a. Compute the following 10 Moody’s metrics for Stryker for 2018.Round all answers (except Revenue) to one decimal place (example for percentage ratios: 0.2345 = 23.5%). Ratio Debt / EBITDA Answer EBITA to interest expense Answer Revenue ($ millions) Answer Retained Cash Flow / Net Debt Answer EBITA margin Answer Operating margin Answer FFO / Debt Answer (FFO + Interest Expense)/Interest Expense Answer…
1. Compute the following ratios for the comparative periods (2018 and 2019). The company used 365 days in its computation for some of the ratios. Show your solution. d. Accounts Receivable Turnover Ratio e. Average Collection Period f. Inventory Turnover Ratio g. Average Days in Inventory h. Number of days in Operating Cycle i. Debt to Total Assets Ratio j. Debt to Equity Ratio k. Times Interest Earned Ratio l. Gross Profit Ratio m. Profit Margin Ratio n. Return on Assets o. Return on Equity p. Assets Turnover Ratio
FINANCIAL RATIO: Requirement: Compute for the following financial ratios for the year 2021 (round-off answers to two decimal places) f. Accounts receivable turnover (assume all sales are on credit) g. Days of receivable (use 365 days) h. Debt ratio i. Equity ratio j. Debt-to-equity ratio k. Gross profit ratio 1. Net profit ratio m. Return on assets n. Return on equity
1. Compute for the financial health ratios of the company for 2019 C.Financial Health/ (Solvency and Liquidity) Solvency ratio: a. Debt to equity ratio b. Debt Ratio c. Equity Ratio d. Interest Coverage Ratio Liquidity ratio: a. Current Ratio b. Quick Ratio
Using the financial statements provided below for ABC Manufacturing Company, calculate all the ratios listed below for both 2020 and2021. Assume that all sales are credit sales. (a) Calculate the ratios forABC Manufacturing Company for2020 and 2021. (b)Put an“I/D” beside the Year 2021 ratio calculation if the ratio has Improved/Deteriorated. Putan“S”/“W” beside the Year 2021 ratio if ABC Manufacturing Company’s ratio is Stronger/Weake rthan its competitors
Using the financial statements in the image, calculate the following ratios for both the FY 2017 and FY 2018: Current Ratio Quick Ratio Total Asset Turnover Average Collection Total Debt to Total Assets Times Interest Earned Net Profit Margin Return on Assets Return on Equity Modified Du Point Equation for FY 2018 PE Ratio Market to Book Ratio
Assume the following information is given:Income statementNet sales sh. 200,000Operating income 10,000 Balance sheetCurrent assets 95,000Total assets 150,000 Current liabilities 80,000Total liabilities 125,000Retained earnings 25,000 The market value of equity is sh. 300,000Required:Evaluate the credit worthiness of the borrower using Altman Z
1. Compute the following ratios for the comparative periods (2018 and 2019). The company used 365 days in its computation for some of the ratios. Show your solution. a. Working Capital b. Current Ratio c. Acid Test Ratio d. Accounts Receivable Turnover Ratio e. Average Collection Period f. Inventory Turnover Ratio g. Average Days in Inventory h. Number of days in Operating Cycle i. Debt to Total Assets Ratio j. Debt to Equity Ratio k. Times Interest Earned Ratio l. Gross Profit Ratio m. Profit Margin Ratio n. Return on Assets o. Return on Equity p. Assets Turnover Ratio
Examine the selected data over the 5-year period as shown in the table below for Dumbledore Ltd. Item Sales Cost of sales EBIT Interest NPAT Current assets Total assets current liabilities Total liabilities Equity Gross margin Interest coverage Current ratio 2021 $m 286.41 180.03 51.18 37.07 35.13 43.85 226.18 55.99 98.99 127.19 0.37 1.38 0.78 Year 2020 $m 280.80 166.69 51.08 33.70 35.10 43.20 221.75 53.58 91.66 130.09 0.41 1.52 0.81 2019 $m 275.29 154.35 50.98 30.64 35.06 42.56 217.40 51.27 84.87 132.53 0.44 1.66 0.89 2018 $m 269.89 142.91 50.88 27.85 35.03 41.93 213.13 49.06 78.58 134.56 0.47 1.83 U.OJ 2017 $m 264.60 134.19 49.88 25.32 34.51 41.31 206.93 47.40 74.48 132.44 0.49 1.97 0.87 2016 $m 252.00 126.00 48.90 24.00 34.00 40.70 200.90 45.80 70.60 130.30 0.50 2.04 0.89
Based on the attached balanced sheet and income statement, Computate the ratios and complete the table below Ratio Analysis 2021 Est. 2020 2019 Industry Average Liquidity Ratios Current Ratio (times) 4.2 Quick Ratio (times) 2.1 Asset Management Ratios Average sales/day 9 Inventory Turnover Ratio (times) 9 Days Sales Outstanding (days) 36 Fixed Assets Turnover Ratio (times) 3 Total Asset Turnover Ratio 1.8 Debt Management Ratios Total Debt to Total Assets (%) 40 Times Interest Earned (times) 6 Debt to Equity Ratio (%) 1 Profitability Ratios Profit Margin on Sales (%) 8 Earning Power (%) 17.2 Return on Total…
Using the attached balanced sheet and income statement Calculate the following ratios for the respective years: 2019, 2020, 2021 est Liquidity Ratios Current Ratio (times) Quick Ratio (times) Asset Management Ratios Average sales/day Inventory Turnover Ratio (times) Days Sales Outstanding (days) Fixed Assets Turnover Ratio (times) Total Asset Turnover Ratio Debt Management Ratios Total Debt to Total Assets (%) Times Interest Earned (times) Debt to Equity Ratio (%) Profitability Ratios Profit Margin on Sales (%) Earning Power (%) Return on Total Assets (%) Return on Common Equity (%) Market Value Ratios Price/Earnings Ratio Price/Earnings Ratio (times) Price/Cash Flow Ratio (times) Market /Book Value Ratio (times) Comment on the liquidity, profitability, leverage, asset management and market value