Paying users zone. Data is hidden behind hidden.


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

Allergan PLC (NYSE:AGN)


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

Beginner level


Two-Component Disaggregation of ROE

Allergan PLC, decomposition of ROE (quarterly data)

Microsoft Excel LibreOffice Calc
ROE = ROA × Financial Leverage
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×
Dec 31, 2018 = ×
Sep 30, 2018 = ×
Jun 30, 2018 = ×
Mar 31, 2018 = ×
Dec 31, 2017 = ×
Sep 30, 2017 = ×
Jun 30, 2017 = ×
Mar 31, 2017 = ×
Dec 31, 2016 = ×
Sep 30, 2016 = ×
Jun 30, 2016 = ×
Mar 31, 2016 = ×
Dec 31, 2015 = ×
Sep 30, 2015 = ×
Jun 30, 2015 = ×
Mar 31, 2015 = ×

Based on: 10-K (filing date: 2020-02-18), 10-Q (filing date: 2019-11-05), 10-Q (filing date: 2019-08-08), 10-Q (filing date: 2019-05-07), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-03), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-16), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-09), 10-Q (filing date: 2017-05-09), 10-K (filing date: 2017-02-24), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-08), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-26), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-06), 10-Q (filing date: 2015-05-11).


Three-Component Disaggregation of ROE

Allergan PLC, decomposition of ROE (quarterly data)

Microsoft Excel LibreOffice Calc
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2019 = × ×
Sep 30, 2019 = × ×
Jun 30, 2019 = × ×
Mar 31, 2019 = × ×
Dec 31, 2018 = × ×
Sep 30, 2018 = × ×
Jun 30, 2018 = × ×
Mar 31, 2018 = × ×
Dec 31, 2017 = × ×
Sep 30, 2017 = × ×
Jun 30, 2017 = × ×
Mar 31, 2017 = × ×
Dec 31, 2016 = × ×
Sep 30, 2016 = × ×
Jun 30, 2016 = × ×
Mar 31, 2016 = × ×
Dec 31, 2015 = × ×
Sep 30, 2015 = × ×
Jun 30, 2015 = × ×
Mar 31, 2015 = × ×

Based on: 10-K (filing date: 2020-02-18), 10-Q (filing date: 2019-11-05), 10-Q (filing date: 2019-08-08), 10-Q (filing date: 2019-05-07), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-03), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-16), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-09), 10-Q (filing date: 2017-05-09), 10-K (filing date: 2017-02-24), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-08), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-26), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-06), 10-Q (filing date: 2015-05-11).


Five-Component Disaggregation of ROE

Allergan PLC, decomposition of ROE (quarterly data)

Microsoft Excel LibreOffice Calc
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2019 = × × × ×
Sep 30, 2019 = × × × ×
Jun 30, 2019 = × × × ×
Mar 31, 2019 = × × × ×
Dec 31, 2018 = × × × ×
Sep 30, 2018 = × × × ×
Jun 30, 2018 = × × × ×
Mar 31, 2018 = × × × ×
Dec 31, 2017 = × × × ×
Sep 30, 2017 = × × × ×
Jun 30, 2017 = × × × ×
Mar 31, 2017 = × × × ×
Dec 31, 2016 = × × × ×
Sep 30, 2016 = × × × ×
Jun 30, 2016 = × × × ×
Mar 31, 2016 = × × × ×
Dec 31, 2015 = × × × ×
Sep 30, 2015 = × × × ×
Jun 30, 2015 = × × × ×
Mar 31, 2015 = × × × ×

Based on: 10-K (filing date: 2020-02-18), 10-Q (filing date: 2019-11-05), 10-Q (filing date: 2019-08-08), 10-Q (filing date: 2019-05-07), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-03), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-16), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-09), 10-Q (filing date: 2017-05-09), 10-K (filing date: 2017-02-24), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-08), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-26), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-06), 10-Q (filing date: 2015-05-11).


Two-Component Disaggregation of ROA

Allergan PLC, decomposition of ROA (quarterly data)

Microsoft Excel LibreOffice Calc
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×
Dec 31, 2018 = ×
Sep 30, 2018 = ×
Jun 30, 2018 = ×
Mar 31, 2018 = ×
Dec 31, 2017 = ×
Sep 30, 2017 = ×
Jun 30, 2017 = ×
Mar 31, 2017 = ×
Dec 31, 2016 = ×
Sep 30, 2016 = ×
Jun 30, 2016 = ×
Mar 31, 2016 = ×
Dec 31, 2015 = ×
Sep 30, 2015 = ×
Jun 30, 2015 = ×
Mar 31, 2015 = ×

Based on: 10-K (filing date: 2020-02-18), 10-Q (filing date: 2019-11-05), 10-Q (filing date: 2019-08-08), 10-Q (filing date: 2019-05-07), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-03), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-16), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-09), 10-Q (filing date: 2017-05-09), 10-K (filing date: 2017-02-24), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-08), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-26), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-06), 10-Q (filing date: 2015-05-11).


Four-Component Disaggregation of ROA

Allergan PLC, decomposition of ROA (quarterly data)

Microsoft Excel LibreOffice Calc
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2019 = × × ×
Sep 30, 2019 = × × ×
Jun 30, 2019 = × × ×
Mar 31, 2019 = × × ×
Dec 31, 2018 = × × ×
Sep 30, 2018 = × × ×
Jun 30, 2018 = × × ×
Mar 31, 2018 = × × ×
Dec 31, 2017 = × × ×
Sep 30, 2017 = × × ×
Jun 30, 2017 = × × ×
Mar 31, 2017 = × × ×
Dec 31, 2016 = × × ×
Sep 30, 2016 = × × ×
Jun 30, 2016 = × × ×
Mar 31, 2016 = × × ×
Dec 31, 2015 = × × ×
Sep 30, 2015 = × × ×
Jun 30, 2015 = × × ×
Mar 31, 2015 = × × ×

Based on: 10-K (filing date: 2020-02-18), 10-Q (filing date: 2019-11-05), 10-Q (filing date: 2019-08-08), 10-Q (filing date: 2019-05-07), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-03), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-16), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-09), 10-Q (filing date: 2017-05-09), 10-K (filing date: 2017-02-24), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-08), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-26), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-06), 10-Q (filing date: 2015-05-11).


Disaggregation of Net Profit Margin

Allergan PLC, decomposition of net profit margin ratio (quarterly data)

Microsoft Excel LibreOffice Calc
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2019 = × ×
Sep 30, 2019 = × ×
Jun 30, 2019 = × ×
Mar 31, 2019 = × ×
Dec 31, 2018 = × ×
Sep 30, 2018 = × ×
Jun 30, 2018 = × ×
Mar 31, 2018 = × ×
Dec 31, 2017 = × ×
Sep 30, 2017 = × ×
Jun 30, 2017 = × ×
Mar 31, 2017 = × ×
Dec 31, 2016 = × ×
Sep 30, 2016 = × ×
Jun 30, 2016 = × ×
Mar 31, 2016 = × ×
Dec 31, 2015 = × ×
Sep 30, 2015 = × ×
Jun 30, 2015 = × ×
Mar 31, 2015 = × ×

Based on: 10-K (filing date: 2020-02-18), 10-Q (filing date: 2019-11-05), 10-Q (filing date: 2019-08-08), 10-Q (filing date: 2019-05-07), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-03), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-16), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-09), 10-Q (filing date: 2017-05-09), 10-K (filing date: 2017-02-24), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-08), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-26), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-06), 10-Q (filing date: 2015-05-11).