Paying users zone. Data is hidden behind hidden.

  • Get 1-month access to Eli Lilly & Co. for $17.99, or

  • get full access to the entire website for at least 3 months from $49.99.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

This is a one-time payment. There is no automatic renewal.

Microsoft Excel LibreOffice Calc

Eli Lilly & Co. (LLY)


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

Low level of difficulty


Two-Component Disaggregation of ROE

Eli Lilly & Co., decomposition of ROE

Microsoft Excel LibreOffice Calc
ROE = ROA × Financial Leverage
Dec 31, 2018 hidden = hidden × hidden
Dec 31, 2017 hidden = hidden × hidden
Dec 31, 2016 hidden = hidden × hidden
Dec 31, 2015 hidden = hidden × hidden
Dec 31, 2014 hidden = hidden × hidden

Based on: 10-K (filing date: 2019-02-19), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-19).


Three-Component Disaggregation of ROE

Eli Lilly & Co., decomposition of ROE

Microsoft Excel LibreOffice Calc
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2018 hidden = hidden × hidden × hidden
Dec 31, 2017 hidden = hidden × hidden × hidden
Dec 31, 2016 hidden = hidden × hidden × hidden
Dec 31, 2015 hidden = hidden × hidden × hidden
Dec 31, 2014 hidden = hidden × hidden × hidden

Based on: 10-K (filing date: 2019-02-19), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-19).


Five-Component Disaggregation of ROE

Eli Lilly & Co., decomposition of ROE

Microsoft Excel LibreOffice Calc
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2018 hidden = hidden × hidden × hidden × hidden × hidden
Dec 31, 2017 hidden = hidden × hidden × hidden × hidden × hidden
Dec 31, 2016 hidden = hidden × hidden × hidden × hidden × hidden
Dec 31, 2015 hidden = hidden × hidden × hidden × hidden × hidden
Dec 31, 2014 hidden = hidden × hidden × hidden × hidden × hidden

Based on: 10-K (filing date: 2019-02-19), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-19).


Two-Component Disaggregation of ROA

Eli Lilly & Co., decomposition of ROA

Microsoft Excel LibreOffice Calc
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2018 hidden = hidden × hidden
Dec 31, 2017 hidden = hidden × hidden
Dec 31, 2016 hidden = hidden × hidden
Dec 31, 2015 hidden = hidden × hidden
Dec 31, 2014 hidden = hidden × hidden

Based on: 10-K (filing date: 2019-02-19), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-19).


Four-Component Disaggregation of ROA

Eli Lilly & Co., decomposition of ROA

Microsoft Excel LibreOffice Calc
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2018 hidden = hidden × hidden × hidden × hidden
Dec 31, 2017 hidden = hidden × hidden × hidden × hidden
Dec 31, 2016 hidden = hidden × hidden × hidden × hidden
Dec 31, 2015 hidden = hidden × hidden × hidden × hidden
Dec 31, 2014 hidden = hidden × hidden × hidden × hidden

Based on: 10-K (filing date: 2019-02-19), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-19).


Disaggregation of Net Profit Margin

Eli Lilly & Co., decomposition of net profit margin ratio

Microsoft Excel LibreOffice Calc
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2018 hidden = hidden × hidden × hidden
Dec 31, 2017 hidden = hidden × hidden × hidden
Dec 31, 2016 hidden = hidden × hidden × hidden
Dec 31, 2015 hidden = hidden × hidden × hidden
Dec 31, 2014 hidden = hidden × hidden × hidden

Based on: 10-K (filing date: 2019-02-19), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-19).