Stock Analysis on Net
Stock Analysis on Net

Schlumberger Ltd. (NYSE:SLB)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Long-term Activity Ratios (Summary)

Schlumberger Ltd., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Net fixed asset turnover 4.70 4.58 4.66 4.58 4.46 4.25 4.13 3.88 3.72 3.57 3.49 3.34 3.23 3.46 3.56 3.83 3.80 3.55 — — —
Total asset turnover 0.71 0.69 0.70 0.70 0.68 0.65 0.60 0.58 0.56 0.55 0.54 0.53 0.51 0.56 0.60 0.66 0.67 0.58 — — —
Equity turnover 1.64 1.64 1.65 1.68 1.65 1.59 1.54 1.52 1.54 1.53 1.66 1.70 1.70 1.96 2.20 2.46 2.09 1.39 — — —

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Schlumberger Ltd. net fixed asset turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Schlumberger Ltd. total asset turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Schlumberger Ltd. equity turnover ratio deteriorated from Q3 2023 to Q4 2023 but then slightly improved from Q4 2023 to Q1 2024.

Net Fixed Asset Turnover

Schlumberger Ltd., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenue 8,707 8,990 8,310 8,099 7,736 7,879 7,477 6,773 5,962 6,225 5,847 5,634 5,223 5,532 5,258 5,356 7,455 8,228 8,541 8,269 7,879
Fixed assets less accumulated depreciation 7,253 7,240 6,875 6,804 6,691 6,607 6,407 6,386 6,354 6,429 6,375 6,473 6,620 6,826 7,396 7,729 8,550 9,270 9,605 11,359 11,533
Long-term Activity Ratio
Net fixed asset turnover1 4.70 4.58 4.66 4.58 4.46 4.25 4.13 3.88 3.72 3.57 3.49 3.34 3.23 3.46 3.56 3.83 3.80 3.55 — — —

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q1 2024 Calculation
Net fixed asset turnover = (RevenueQ1 2024 + RevenueQ4 2023 + RevenueQ3 2023 + RevenueQ2 2023) ÷ Fixed assets less accumulated depreciation
= (8,707 + 8,990 + 8,310 + 8,099) ÷ 7,253 = 4.70

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Schlumberger Ltd. net fixed asset turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.

Total Asset Turnover

Schlumberger Ltd., total asset turnover calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenue 8,707 8,990 8,310 8,099 7,736 7,879 7,477 6,773 5,962 6,225 5,847 5,634 5,223 5,532 5,258 5,356 7,455 8,228 8,541 8,269 7,879
Total assets 47,856 47,957 45,813 44,826 43,855 43,135 44,093 42,827 41,967 41,511 41,038 40,908 42,036 42,434 44,066 44,667 48,594 56,312 57,990 70,591 70,321
Long-term Activity Ratio
Total asset turnover1 0.71 0.69 0.70 0.70 0.68 0.65 0.60 0.58 0.56 0.55 0.54 0.53 0.51 0.56 0.60 0.66 0.67 0.58 — — —

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q1 2024 Calculation
Total asset turnover = (RevenueQ1 2024 + RevenueQ4 2023 + RevenueQ3 2023 + RevenueQ2 2023) ÷ Total assets
= (8,707 + 8,990 + 8,310 + 8,099) ÷ 47,856 = 0.71

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Schlumberger Ltd. total asset turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.

Equity Turnover

Schlumberger Ltd., equity turnover calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenue 8,707 8,990 8,310 8,099 7,736 7,879 7,477 6,773 5,962 6,225 5,847 5,634 5,223 5,532 5,258 5,356 7,455 8,228 8,541 8,269 7,879
Total SLB stockholders’ equity 20,736 20,189 19,386 18,608 18,068 17,685 17,199 16,325 15,347 15,004 13,362 12,762 12,543 12,071 11,941 12,040 15,561 23,760 23,913 35,852 36,103
Long-term Activity Ratio
Equity turnover1 1.64 1.64 1.65 1.68 1.65 1.59 1.54 1.52 1.54 1.53 1.66 1.70 1.70 1.96 2.20 2.46 2.09 1.39 — — —

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q1 2024 Calculation
Equity turnover = (RevenueQ1 2024 + RevenueQ4 2023 + RevenueQ3 2023 + RevenueQ2 2023) ÷ Total SLB stockholders’ equity
= (8,707 + 8,990 + 8,310 + 8,099) ÷ 20,736 = 1.64

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Schlumberger Ltd. equity turnover ratio deteriorated from Q3 2023 to Q4 2023 but then slightly improved from Q4 2023 to Q1 2024.