Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculating Ratios and Estimating Credit Rating The following data are from Kellogg's 10-K report dated December 29, 2018 ($ millions). Revenue $13,547 Earnings from

image text in transcribed

Calculating Ratios and Estimating Credit Rating The following data are from Kellogg's 10-K report dated December 29, 2018 ($ millions). Revenue $13,547 Earnings from continuing operations $1,344 Interest expense 287 Tax expense 181 Amortization expense Depreciation expense 23 493 Capital expenditures (CAPEX) 578 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. 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%) EBITA/Avg. assets EBITA margin Ratio 10.8 % 13.5% Aa Moody's rating Aaa EBITA/Int. expense Debt/EBITDA 639.4 Aa 382 Aaa CAPEX/Dep. expense 117.2 X B

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Financial Accounting Concepts

Authors: Thomas Edmonds, Christopher Edmonds

9th edition

9781259296802, 9781259296758, 78025907, 1259296806, 9781259296765, 978-0078025907

More Books

Students also viewed these Accounting questions