Sign in

Paying users zone. Data is covered by hidden .

Get to Allergan PLC for $15.99, or
get to whole website for at least 3 months from $49.99.

Microsoft Excel

LibreOffice Calc

Allergan PLC (AGN)

DuPont Analysis: Decomposition of ROE
Quarterly Data

Difficulty: Beginner

Annual Data

Quarterly Data

Decomposing ROE involves expressing net income divided by shareholders' equity as the product of component ratios.

Two-Component Disaggregation of ROE
Three-Component Disaggregation of ROE
Five-Component Disaggregation of ROE
Two-Way Decomposition of ROA
Four-Way Decomposition of ROA
Decomposition of Net Profit Margin

Two-Component Disaggregation of ROE

Allergan PLC, decomposition of ROE (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROE	=	ROA	×	Leverage

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	%		%
Dec 31, 2014	%		%
Sep 30, 2014	%		%
Jun 30, 2014	%		%
Mar 31, 2014	%		%
Dec 31, 2013	%		%
Sep 30, 2013	%		%
Jun 30, 2013	%		%
Mar 31, 2013	%		%

Source: Based on data from Allergan PLC Quarterly and Annual Reports

Three-Component Disaggregation of ROE

Allergan PLC, decomposition of ROE (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROE	=	Net Profit Margin	×	Asset Turnover	×	Leverage

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	%		%
Dec 31, 2014	%		%
Sep 30, 2014	%		%
Jun 30, 2014	%		%
Mar 31, 2014	%		%
Dec 31, 2013	%		%
Sep 30, 2013	%		%
Jun 30, 2013	%		%
Mar 31, 2013	%		%

Source: Based on data from Allergan PLC Quarterly and Annual Reports

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	×	Leverage

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	%						%
Dec 31, 2014	%						%
Sep 30, 2014	%						%
Jun 30, 2014	%						%
Mar 31, 2014	%						%
Dec 31, 2013	%						%
Sep 30, 2013	%						%
Jun 30, 2013	%						%
Mar 31, 2013	%						%

Source: Based on data from Allergan PLC Quarterly and Annual Reports

Two-Way Decomposition of ROA

Allergan PLC, decomposition of ROA (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROA	=	Net Profit Margin	×	Asset Turnover

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	%		%
Dec 31, 2014	%		%
Sep 30, 2014	%		%
Jun 30, 2014	%		%
Mar 31, 2014	%		%
Dec 31, 2013	%		%
Sep 30, 2013	%		%
Jun 30, 2013	%		%
Mar 31, 2013	%		%

Source: Based on data from Allergan PLC Quarterly and Annual Reports

Four-Way Decomposition of ROA

Allergan PLC, decomposition of ROA (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROA	=	Tax Burden	×	Interest Burden	×	EBIT Margin	×	Asset Turnover

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	%						%
Dec 31, 2014	%						%
Sep 30, 2014	%						%
Jun 30, 2014	%						%
Mar 31, 2014	%						%
Dec 31, 2013	%						%
Sep 30, 2013	%						%
Jun 30, 2013	%						%
Mar 31, 2013	%						%

Source: Based on data from Allergan PLC Quarterly and Annual Reports

Decomposition of Net Profit Margin

Allergan PLC, decomposition of Net Profit Margin (quarterly data)

Microsoft Excel

LibreOffice Calc

	Net Profit Margin	=	Tax Burden	×	Interest Burden	×	EBIT Margin

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	%						%
Dec 31, 2014	%						%
Sep 30, 2014	%						%
Jun 30, 2014	%						%
Mar 31, 2014	%						%
Dec 31, 2013	%						%
Sep 30, 2013	%						%
Jun 30, 2013	%						%
Mar 31, 2013	%						%

Source: Based on data from Allergan PLC Quarterly and Annual Reports

	Allergan PLC	Other companies (not purchased previously)
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Economic Value Added (EVA)
Long-term Trends
Analysis
Financial Reporting Quality

Price of access to Allergan PLC^*

1 month

$15.99

* You can pay in USD, CHF, GBP or EUR.

Visa

Mastercard

Maestro

Maestro UK

	All companies
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Economic Value Added (EVA)
Long-term Trends
Analysis
Financial Reporting Quality

Prices of access whole website^*

3 months

$49.99

6 months

12% off

~~99.98~~

$87.49

9 months

25% off

~~149.97~~

$112.49

12 months

37% off

~~199.96~~

$124.99

* You can pay in USD, CHF, GBP or EUR.

Visa

Mastercard

Maestro

Maestro UK