Paying users zone. Data is hidden behind hidden.

  • Get 1-month access to Schlumberger Ltd. for $15.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
Unlock

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

Microsoft Excel LibreOffice Calc

Schlumberger Ltd. (SLB)

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

Beginner level

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

Two-Component Disaggregation of ROE

Schlumberger Ltd., 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-01-22), 10-Q (filing date: 2019-10-23), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-24), 10-K (filing date: 2019-01-23), 10-Q (filing date: 2018-10-24), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-24), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-01-25), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-01-27), 10-Q (filing date: 2015-10-21), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

Three-Component Disaggregation of ROE

Schlumberger Ltd., 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-01-22), 10-Q (filing date: 2019-10-23), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-24), 10-K (filing date: 2019-01-23), 10-Q (filing date: 2018-10-24), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-24), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-01-25), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-01-27), 10-Q (filing date: 2015-10-21), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

Five-Component Disaggregation of ROE

Schlumberger Ltd., 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-01-22), 10-Q (filing date: 2019-10-23), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-24), 10-K (filing date: 2019-01-23), 10-Q (filing date: 2018-10-24), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-24), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-01-25), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-01-27), 10-Q (filing date: 2015-10-21), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

Two-Component Disaggregation of ROA

Schlumberger Ltd., 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-01-22), 10-Q (filing date: 2019-10-23), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-24), 10-K (filing date: 2019-01-23), 10-Q (filing date: 2018-10-24), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-24), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-01-25), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-01-27), 10-Q (filing date: 2015-10-21), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

Four-Component Disaggregation of ROA

Schlumberger Ltd., 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-01-22), 10-Q (filing date: 2019-10-23), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-24), 10-K (filing date: 2019-01-23), 10-Q (filing date: 2018-10-24), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-24), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-01-25), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-01-27), 10-Q (filing date: 2015-10-21), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).

Disaggregation of Net Profit Margin

Schlumberger Ltd., 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-01-22), 10-Q (filing date: 2019-10-23), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-24), 10-K (filing date: 2019-01-23), 10-Q (filing date: 2018-10-24), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-24), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-01-25), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-01-27), 10-Q (filing date: 2015-10-21), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).