Stock Analysis on Net

Kraft Heinz Co. (NASDAQ:KHC)

This company has been moved to the archive! The financial data has not been updated since July 31, 2020.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin

Microsoft Excel

Two-Component Disaggregation of ROE

Kraft Heinz Co., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 28, 2019 3.75% = 1.91% × 1.97
Dec 29, 2018 -19.73% = -9.85% × 2.00
Dec 30, 2017 16.66% = 9.15% × 1.82
Dec 31, 2016 6.33% = 3.01% × 2.10
Dec 31, 2015 1.10% = 0.52% × 2.13

Based on: 10-K (reporting date: 2019-12-28), 10-K (reporting date: 2018-12-29), 10-K (reporting date: 2017-12-30), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31).


Three-Component Disaggregation of ROE

Kraft Heinz Co., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 28, 2019 3.75% = 7.75% × 0.25 × 1.97
Dec 29, 2018 -19.73% = -38.80% × 0.25 × 2.00
Dec 30, 2017 16.66% = 41.93% × 0.22 × 1.82
Dec 31, 2016 6.33% = 13.71% × 0.22 × 2.10
Dec 31, 2015 1.10% = 3.46% × 0.15 × 2.13

Based on: 10-K (reporting date: 2019-12-28), 10-K (reporting date: 2018-12-29), 10-K (reporting date: 2017-12-30), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31).


Five-Component Disaggregation of ROE

Kraft Heinz Co., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 28, 2019 3.75% = 0.73 × 0.66 × 16.11% × 0.25 × 1.97
Dec 29, 2018 -19.73% = × × -37.97% × 0.25 × 2.00
Dec 30, 2017 16.66% = 1.99 × 0.82 × 25.82% × 0.22 × 1.82
Dec 31, 2016 6.33% = 0.72 × 0.82 × 23.21% × 0.22 × 2.10
Dec 31, 2015 1.10% = 0.63 × 0.43 × 12.66% × 0.15 × 2.13

Based on: 10-K (reporting date: 2019-12-28), 10-K (reporting date: 2018-12-29), 10-K (reporting date: 2017-12-30), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31).


Two-Component Disaggregation of ROA

Kraft Heinz Co., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 28, 2019 1.91% = 7.75% × 0.25
Dec 29, 2018 -9.85% = -38.80% × 0.25
Dec 30, 2017 9.15% = 41.93% × 0.22
Dec 31, 2016 3.01% = 13.71% × 0.22
Dec 31, 2015 0.52% = 3.46% × 0.15

Based on: 10-K (reporting date: 2019-12-28), 10-K (reporting date: 2018-12-29), 10-K (reporting date: 2017-12-30), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31).


Four-Component Disaggregation of ROA

Kraft Heinz Co., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 28, 2019 1.91% = 0.73 × 0.66 × 16.11% × 0.25
Dec 29, 2018 -9.85% = × × -37.97% × 0.25
Dec 30, 2017 9.15% = 1.99 × 0.82 × 25.82% × 0.22
Dec 31, 2016 3.01% = 0.72 × 0.82 × 23.21% × 0.22
Dec 31, 2015 0.52% = 0.63 × 0.43 × 12.66% × 0.15

Based on: 10-K (reporting date: 2019-12-28), 10-K (reporting date: 2018-12-29), 10-K (reporting date: 2017-12-30), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31).


Disaggregation of Net Profit Margin

Kraft Heinz Co., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 28, 2019 7.75% = 0.73 × 0.66 × 16.11%
Dec 29, 2018 -38.80% = × × -37.97%
Dec 30, 2017 41.93% = 1.99 × 0.82 × 25.82%
Dec 31, 2016 13.71% = 0.72 × 0.82 × 23.21%
Dec 31, 2015 3.46% = 0.63 × 0.43 × 12.66%

Based on: 10-K (reporting date: 2019-12-28), 10-K (reporting date: 2018-12-29), 10-K (reporting date: 2017-12-30), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31).