Paying users zone. Data is covered by hidden.


We accept:

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

Microsoft Excel LibreOffice Calc

Allergan PLC (AGN)


DuPont Analysis: Decomposition of ROE

Difficulty: Beginner


Two-Component Disaggregation of ROE

Allergan PLC, decomposition of ROE

Microsoft Excel LibreOffice Calc
ROE = ROA × 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-15), 10-K (filing date: 2018-02-16), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-18).


Three-Component Disaggregation of ROE

Allergan PLC, decomposition of ROE

Microsoft Excel LibreOffice Calc
ROE = Net Profit Margin × Asset Turnover × 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-15), 10-K (filing date: 2018-02-16), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-18).


Five-Component Disaggregation of ROE

Allergan PLC, decomposition of ROE

Microsoft Excel LibreOffice Calc
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × 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-15), 10-K (filing date: 2018-02-16), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-18).


Two-Way Decomposition of ROA

Allergan PLC, 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-15), 10-K (filing date: 2018-02-16), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-18).


Four-Way Decomposition of ROA

Allergan PLC, 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-15), 10-K (filing date: 2018-02-16), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-18).


Decomposition of Net Profit Margin

Allergan PLC, decomposition of Net Profit Margin

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-15), 10-K (filing date: 2018-02-16), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-18).