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.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question

Transcribed Image Text:Calculating Ratios and Estimating Credit Rating
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
Total debt
8,893
23
Average assets 17,066
493
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.
b. Refer to Exhibit 7.4 and the ratios you calculated in part a. Estimate the credit rating that Moody's might assign to Kellogg.
Round answers to one decimal place (percentage ex: 0.2345 = 23.5%)
Ratio Moody's rating
EBITA/Avg. assets
EBITA margin
EBITA/Int. expense
Debt/EBITDA
CAPEX/Dep. expense
Please answer all parts of the question.
0%
0%
0
0
0
◆
◆
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps

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.Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education