Kellogg Company Ratio Analysis

profilenavingolyan
details_of_ratios_1.xlsx
Home>Business & Finance homework help>Kellogg Company Ratio Analysis

Sheet1

Kellogg Company (NYSE:K) Ratios
Restatement: Latest Filings   Period Type: Annual
Order: Latest on Right   Decimals: Capital IQ (Default)
Source: Capital IQ & Proprietary Data  
Ratios
For the Fiscal Period Ending 12 months Dec-31-2011 12 months Dec-29-2012 12 months Dec-28-2013 12 months Jan-03-2015 12 months Jan-02-2016
Profitability Ratios 2011 2012 2013 2014 2015
Return on Assets % 7.8% 7.8% 12.8% 5.6% 6.1%
Return on Common Equity % 43.8% 45.8% 60.7% 20.0% 25.0%
Gross Margin % 39.3% 38.6% 42.7% 35.9% 36.5%
EBIT (Operating) Margin % 11.3% 11.9% 21.3% 9.3% 11.0%
Net Income Avail. for Common Margin % 6.6% 6.8% 12.2% 4.3% 4.5%
Asset Turnover 2011 2012 2013 2014 2015
Total Asset Turnover 1.1x 1.0x 1.0x 1.0x 0.9x
Fixed Asset Turnover 4.1x 4.0x 3.9x 3.8x 3.7x
Accounts Receivable Turnover 14.1x 13.1x 12.3x 12.6x 12.0x
Inventory Turnover 7.2x 6.9x 6.5x 7.4x 6.8x
Liquidity 2011 2012 2013 2014 2015
Current Ratio 0.9x 0.7x 0.9x 0.8x 0.6x
Quick Ratio 0.5x 0.4x 0.4x 0.4x 0.3x
Avg. Days Sales Out. 25.7 27.7 29.6 29.5 30.3
Avg. Days Inventory Out. 50.7 53.0 56.1 50.2 53.6
Avg. Days Payable Out. 52.4 52.9 61.7 58.6 73.0
Debt Ratios 2011 2012 2013 2014 2015
Total Liabilities/Total Assets 84.9% 83.7% 76.7% 81.2% 86.0%
EBIT / Interest Exp. (Times interest earned) 6.4x 6.5x 13.4x 6.5x 6.5x
Growth Over Prior Year 2011 2012 2013 2014 2015
Total Revenue 6.5% 7.6% 4.2% (1.4%) (7.2%)
Gross Profit (3.1%) 5.6% 15.2% (17.0%) (5.9%)
Earnings from Cont. Ops. (32.5%) 11.2% 88.1% (65.0%) (3.0%)
Net Income (32.7%) 11.0% 88.0% (65.0%) (2.8%)
Growth Over Prior Year Total Revenue Gross Profit Earnings from Cont. Ops. Net Income
2011 6.5% (3.1%) (32.5%) (32.7%)
2012 7.6% 5.6% 11.2% 11.0%
2013 4.2% 15.2% 88.1% 88.0%
2014 (1.4%) (17.0%) (65.0%) (65.0%)
2015 (7.2%) (5.9%) (3.0%) (2.8%)