Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Schlumberger Ltd. (NYSE:SLB)

This company was transferred to the archive: financial data is no longer updated!

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 -42.66% = -18.00% × 2.37
Sep 30, 2019 -41.53% = -17.13% × 2.43
Jun 30, 2019 5.85% = 2.97% × 1.97
Mar 31, 2019 5.63% = 2.89% × 1.95
Dec 31, 2018 5.91% = 3.03% × 1.95
Sep 30, 2018 -1.80% = -0.94% × 1.92
Jun 30, 2018 -2.07% = -1.08% × 1.92
Mar 31, 2018 -3.41% = -1.76% × 1.94
Dec 31, 2017 -4.09% = -2.09% × 1.95
Sep 30, 2017 1.38% = 0.74% × 1.86
Jun 30, 2017 0.45% = 0.24% × 1.89
Mar 31, 2017 -4.70% = -2.51% × 1.88
Dec 31, 2016 -4.11% = -2.16% × 1.90
Sep 30, 2016 -5.92% = -3.10% × 1.91
Jun 30, 2016 -3.96% = -2.08% × 1.90
Mar 31, 2016 4.52% = 2.31% × 1.96
Dec 31, 2015 5.81% = 3.05% × 1.91
Sep 30, 2015 — = — × 1.67
Jun 30, 2015 — = — × 1.71
Mar 31, 2015 — = — × 1.74

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 -42.66% = -30.80% × 0.58 × 2.37
Sep 30, 2019 -41.53% = -30.21% × 0.57 × 2.43
Jun 30, 2019 5.85% = 6.38% × 0.47 × 1.97
Mar 31, 2019 5.63% = 6.19% × 0.47 × 1.95
Dec 31, 2018 5.91% = 6.52% × 0.47 × 1.95
Sep 30, 2018 -1.80% = -2.00% × 0.47 × 1.92
Jun 30, 2018 -2.07% = -2.34% × 0.46 × 1.92
Mar 31, 2018 -3.41% = -4.01% × 0.44 × 1.94
Dec 31, 2017 -4.09% = -4.94% × 0.42 × 1.95
Sep 30, 2017 1.38% = 1.86% × 0.40 × 1.86
Jun 30, 2017 0.45% = 0.62% × 0.38 × 1.89
Mar 31, 2017 -4.70% = -6.77% × 0.37 × 1.88
Dec 31, 2016 -4.11% = -6.07% × 0.36 × 1.90
Sep 30, 2016 -5.92% = -8.78% × 0.35 × 1.91
Jun 30, 2016 -3.96% = -5.64% × 0.37 × 1.90
Mar 31, 2016 4.52% = 5.03% × 0.46 × 1.96
Dec 31, 2015 5.81% = 5.84% × 0.52 × 1.91
Sep 30, 2015 — = — × — × 1.67
Jun 30, 2015 — = — × — × 1.71
Mar 31, 2015 — = — × — × 1.74

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 -42.66% = — × — × -29.89% × 0.58 × 2.37
Sep 30, 2019 -41.53% = — × — × -29.35% × 0.57 × 2.43
Jun 30, 2019 5.85% = 0.84 × 0.81 × 9.42% × 0.47 × 1.97
Mar 31, 2019 5.63% = 0.83 × 0.81 × 9.21% × 0.47 × 1.95
Dec 31, 2018 5.91% = 0.83 × 0.82 × 9.63% × 0.47 × 1.95
Sep 30, 2018 -1.80% = — × -0.75 × 1.01% × 0.47 × 1.92
Jun 30, 2018 -2.07% = — × -1.62 × 0.68% × 0.46 × 1.92
Mar 31, 2018 -3.41% = — × — × -0.94% × 0.44 × 1.94
Dec 31, 2017 -4.09% = — × — × -2.00% × 0.42 × 1.95
Sep 30, 2017 1.38% = 0.69 × 0.59 × 4.62% × 0.40 × 1.86
Jun 30, 2017 0.45% = 0.56 × 0.36 × 3.11% × 0.38 × 1.89
Mar 31, 2017 -4.70% = — × — × -5.89% × 0.37 × 1.88
Dec 31, 2016 -4.11% = — × — × -5.02% × 0.36 × 1.90
Sep 30, 2016 -5.92% = — × — × -8.25% × 0.35 × 1.91
Jun 30, 2016 -3.96% = — × — × -4.54% × 0.37 × 1.90
Mar 31, 2016 4.52% = 0.75 × 0.84 × 7.98% × 0.46 × 1.96
Dec 31, 2015 5.81% = 0.74 × 0.89 × 8.92% × 0.52 × 1.91
Sep 30, 2015 — = — × — × — × — × 1.67
Jun 30, 2015 — = — × — × — × — × 1.71
Mar 31, 2015 — = — × — × — × — × 1.74

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 -18.00% = -30.80% × 0.58
Sep 30, 2019 -17.13% = -30.21% × 0.57
Jun 30, 2019 2.97% = 6.38% × 0.47
Mar 31, 2019 2.89% = 6.19% × 0.47
Dec 31, 2018 3.03% = 6.52% × 0.47
Sep 30, 2018 -0.94% = -2.00% × 0.47
Jun 30, 2018 -1.08% = -2.34% × 0.46
Mar 31, 2018 -1.76% = -4.01% × 0.44
Dec 31, 2017 -2.09% = -4.94% × 0.42
Sep 30, 2017 0.74% = 1.86% × 0.40
Jun 30, 2017 0.24% = 0.62% × 0.38
Mar 31, 2017 -2.51% = -6.77% × 0.37
Dec 31, 2016 -2.16% = -6.07% × 0.36
Sep 30, 2016 -3.10% = -8.78% × 0.35
Jun 30, 2016 -2.08% = -5.64% × 0.37
Mar 31, 2016 2.31% = 5.03% × 0.46
Dec 31, 2015 3.05% = 5.84% × 0.52
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 -18.00% = — × — × -29.89% × 0.58
Sep 30, 2019 -17.13% = — × — × -29.35% × 0.57
Jun 30, 2019 2.97% = 0.84 × 0.81 × 9.42% × 0.47
Mar 31, 2019 2.89% = 0.83 × 0.81 × 9.21% × 0.47
Dec 31, 2018 3.03% = 0.83 × 0.82 × 9.63% × 0.47
Sep 30, 2018 -0.94% = — × -0.75 × 1.01% × 0.47
Jun 30, 2018 -1.08% = — × -1.62 × 0.68% × 0.46
Mar 31, 2018 -1.76% = — × — × -0.94% × 0.44
Dec 31, 2017 -2.09% = — × — × -2.00% × 0.42
Sep 30, 2017 0.74% = 0.69 × 0.59 × 4.62% × 0.40
Jun 30, 2017 0.24% = 0.56 × 0.36 × 3.11% × 0.38
Mar 31, 2017 -2.51% = — × — × -5.89% × 0.37
Dec 31, 2016 -2.16% = — × — × -5.02% × 0.36
Sep 30, 2016 -3.10% = — × — × -8.25% × 0.35
Jun 30, 2016 -2.08% = — × — × -4.54% × 0.37
Mar 31, 2016 2.31% = 0.75 × 0.84 × 7.98% × 0.46
Dec 31, 2015 3.05% = 0.74 × 0.89 × 8.92% × 0.52
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 -30.80% = — × — × -29.89%
Sep 30, 2019 -30.21% = — × — × -29.35%
Jun 30, 2019 6.38% = 0.84 × 0.81 × 9.42%
Mar 31, 2019 6.19% = 0.83 × 0.81 × 9.21%
Dec 31, 2018 6.52% = 0.83 × 0.82 × 9.63%
Sep 30, 2018 -2.00% = — × -0.75 × 1.01%
Jun 30, 2018 -2.34% = — × -1.62 × 0.68%
Mar 31, 2018 -4.01% = — × — × -0.94%
Dec 31, 2017 -4.94% = — × — × -2.00%
Sep 30, 2017 1.86% = 0.69 × 0.59 × 4.62%
Jun 30, 2017 0.62% = 0.56 × 0.36 × 3.11%
Mar 31, 2017 -6.77% = — × — × -5.89%
Dec 31, 2016 -6.07% = — × — × -5.02%
Sep 30, 2016 -8.78% = — × — × -8.25%
Jun 30, 2016 -5.64% = — × — × -4.54%
Mar 31, 2016 5.03% = 0.75 × 0.84 × 7.98%
Dec 31, 2015 5.84% = 0.74 × 0.89 × 8.92%
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).