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

AT&T Inc. (T)


DuPont Analysis: Decomposition of ROE
Quarterly Data

Difficulty: Beginner


Two-Component Disaggregation of ROE

AT&T Inc., decomposition of ROE (quarterly data)

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

Based on: 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-11-02), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-11-03), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-05), 10-K (filing date: 2015-02-20), 10-Q (filing date: 2014-11-10), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

The primary reason for the decrease in Return on Equity (ROE) over Q1 2019 is the decrease in profitability measured by Return on Assets (ROA).


Three-Component Disaggregation of ROE

AT&T Inc., decomposition of ROE (quarterly data)

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

Based on: 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-11-02), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-11-03), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-05), 10-K (filing date: 2015-02-20), 10-Q (filing date: 2014-11-10), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

The primary reason for the decrease in Return on Equity (ROE) over Q1 2019 is the decrease in profitability measured by Net Profit Margin.


Five-Component Disaggregation of ROE

AT&T Inc., decomposition of ROE (quarterly data)

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

Based on: 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-11-02), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-11-03), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-05), 10-K (filing date: 2015-02-20), 10-Q (filing date: 2014-11-10), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

The primary reason for the decrease in Return on Equity (ROE) over Q1 2019 is the decrease in operating profitability measured by EBIT Margin.


Two-Way Decomposition of ROA

AT&T Inc., decomposition of ROA (quarterly data)

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

Based on: 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-11-02), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-11-03), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-05), 10-K (filing date: 2015-02-20), 10-Q (filing date: 2014-11-10), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

The primary reason for the decrease in Return on Assets (ROA) over Q1 2019 is the decrease in profitability measured by Net Profit Margin.


Four-Way Decomposition of ROA

AT&T Inc., decomposition of ROA (quarterly data)

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

Based on: 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-11-02), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-11-03), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-05), 10-K (filing date: 2015-02-20), 10-Q (filing date: 2014-11-10), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

The primary reason for the decrease in Return on Assets (ROA) over Q1 2019 is the decrease in operating profitability measured by EBIT Margin.


Decomposition of Net Profit Margin

AT&T Inc., decomposition of Net Profit Margin (quarterly data)

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

Based on: 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-11-02), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-03), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-11-03), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-17), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-11-06), 10-Q (filing date: 2015-08-07), 10-Q (filing date: 2015-05-05), 10-K (filing date: 2015-02-20), 10-Q (filing date: 2014-11-10), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

The primary reason for the decrease in Net Profit Margin over Q1 2019 is the decrease in operating profitability measured by EBIT Margin.