Stock Analysis on Net
Stock Analysis on Net

EQT Corp. (NYSE:EQT)

This company has been moved to the archive! The financial data has not been updated since October 27, 2022.

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

Microsoft Excel

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

Two-Component Disaggregation of ROE

EQT Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Sep 30, 2022 19.34% = 8.25% × 2.34
Jun 30, 2022 -8.87% = -3.55% × 2.50
Mar 31, 2022 -32.13% = -12.06% × 2.66
Dec 31, 2021 -11.52% = -5.35% × 2.15
Sep 30, 2021 -35.08% = -12.57% × 2.79
Jun 30, 2021 -18.26% = -7.97% × 2.29
Mar 31, 2021 -9.12% = -4.66% × 1.96
Dec 31, 2020 -10.45% = -5.34% × 1.96
Sep 30, 2020 -24.96% = -12.56% × 1.99
Jun 30, 2020 -20.85% = -10.93% × 1.91
Mar 31, 2020 -16.40% = -8.48% × 1.93
Dec 31, 2019 -12.46% = -6.50% × 1.92
Sep 30, 2019 -6.25% = -3.38% × 1.85
Jun 30, 2019 -3.20% = -1.76% × 1.82
Mar 31, 2019 -4.20% = -2.30% × 1.83
Dec 31, 2018 -20.48% = -10.83% × 1.89
Sep 30, 2018 — = — × 2.61
Jun 30, 2018 — = — × 2.48
Mar 31, 2018 — = — × 2.36

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

Three-Component Disaggregation of ROE

EQT Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Sep 30, 2022 19.34% = 15.05% × 0.55 × 2.34
Jun 30, 2022 -8.87% = -7.69% × 0.46 × 2.50
Mar 31, 2022 -32.13% = -32.25% × 0.37 × 2.66
Dec 31, 2021 -11.52% = -16.99% × 0.31 × 2.15
Sep 30, 2021 -35.08% = -59.90% × 0.21 × 2.79
Jun 30, 2021 -18.26% = -41.53% × 0.19 × 2.29
Mar 31, 2021 -9.12% = -27.41% × 0.17 × 1.96
Dec 31, 2020 -10.45% = -36.49% × 0.15 × 1.96
Sep 30, 2020 -24.96% = -82.92% × 0.15 × 1.99
Jun 30, 2020 -20.85% = -69.47% × 0.16 × 1.91
Mar 31, 2020 -16.40% = -48.83% × 0.17 × 1.93
Dec 31, 2019 -12.46% = -32.22% × 0.20 × 1.92
Sep 30, 2019 -6.25% = -15.58% × 0.22 × 1.85
Jun 30, 2019 -3.20% = -7.74% × 0.23 × 1.82
Mar 31, 2019 -4.20% = -9.87% × 0.23 × 1.83
Dec 31, 2018 -20.48% = -47.80% × 0.23 × 1.89
Sep 30, 2018 — = — × — × 2.61
Jun 30, 2018 — = — × — × 2.48
Mar 31, 2018 — = — × — × 2.36

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

Five-Component Disaggregation of ROE

EQT Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Sep 30, 2022 19.34% = 0.76 × 0.90 × 21.98% × 0.55 × 2.34
Jun 30, 2022 -8.87% = — × — × -7.10% × 0.46 × 2.50
Mar 31, 2022 -32.13% = — × — × -39.40% × 0.37 × 2.66
Dec 31, 2021 -11.52% = — × — × -18.83% × 0.31 × 2.15
Sep 30, 2021 -35.08% = — × — × -74.84% × 0.21 × 2.79
Jun 30, 2021 -18.26% = — × — × -49.64% × 0.19 × 2.29
Mar 31, 2021 -9.12% = — × — × -29.44% × 0.17 × 1.96
Dec 31, 2020 -10.45% = — × — × -37.54% × 0.15 × 1.96
Sep 30, 2020 -24.96% = — × — × -98.71% × 0.15 × 1.99
Jun 30, 2020 -20.85% = — × — × -80.14% × 0.16 × 1.91
Mar 31, 2020 -16.40% = — × — × -54.25% × 0.17 × 1.93
Dec 31, 2019 -12.46% = — × — × -36.86% × 0.20 × 1.92
Sep 30, 2019 -6.25% = — × — × -13.22% × 0.22 × 1.85
Jun 30, 2019 -3.20% = — × — × -5.03% × 0.23 × 1.82
Mar 31, 2019 -4.20% = — × — × -9.89% × 0.23 × 1.83
Dec 31, 2018 -20.48% = — × — × -57.76% × 0.23 × 1.89
Sep 30, 2018 — = — × — × — × — × 2.61
Jun 30, 2018 — = — × — × — × — × 2.48
Mar 31, 2018 — = — × — × — × — × 2.36

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

Two-Component Disaggregation of ROA

EQT Corp., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Sep 30, 2022 8.25% = 15.05% × 0.55
Jun 30, 2022 -3.55% = -7.69% × 0.46
Mar 31, 2022 -12.06% = -32.25% × 0.37
Dec 31, 2021 -5.35% = -16.99% × 0.31
Sep 30, 2021 -12.57% = -59.90% × 0.21
Jun 30, 2021 -7.97% = -41.53% × 0.19
Mar 31, 2021 -4.66% = -27.41% × 0.17
Dec 31, 2020 -5.34% = -36.49% × 0.15
Sep 30, 2020 -12.56% = -82.92% × 0.15
Jun 30, 2020 -10.93% = -69.47% × 0.16
Mar 31, 2020 -8.48% = -48.83% × 0.17
Dec 31, 2019 -6.50% = -32.22% × 0.20
Sep 30, 2019 -3.38% = -15.58% × 0.22
Jun 30, 2019 -1.76% = -7.74% × 0.23
Mar 31, 2019 -2.30% = -9.87% × 0.23
Dec 31, 2018 -10.83% = -47.80% × 0.23
Sep 30, 2018 — = — × —
Jun 30, 2018 — = — × —
Mar 31, 2018 — = — × —

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

Four-Component Disaggregation of ROA

EQT Corp., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Sep 30, 2022 8.25% = 0.76 × 0.90 × 21.98% × 0.55
Jun 30, 2022 -3.55% = — × — × -7.10% × 0.46
Mar 31, 2022 -12.06% = — × — × -39.40% × 0.37
Dec 31, 2021 -5.35% = — × — × -18.83% × 0.31
Sep 30, 2021 -12.57% = — × — × -74.84% × 0.21
Jun 30, 2021 -7.97% = — × — × -49.64% × 0.19
Mar 31, 2021 -4.66% = — × — × -29.44% × 0.17
Dec 31, 2020 -5.34% = — × — × -37.54% × 0.15
Sep 30, 2020 -12.56% = — × — × -98.71% × 0.15
Jun 30, 2020 -10.93% = — × — × -80.14% × 0.16
Mar 31, 2020 -8.48% = — × — × -54.25% × 0.17
Dec 31, 2019 -6.50% = — × — × -36.86% × 0.20
Sep 30, 2019 -3.38% = — × — × -13.22% × 0.22
Jun 30, 2019 -1.76% = — × — × -5.03% × 0.23
Mar 31, 2019 -2.30% = — × — × -9.89% × 0.23
Dec 31, 2018 -10.83% = — × — × -57.76% × 0.23
Sep 30, 2018 — = — × — × — × —
Jun 30, 2018 — = — × — × — × —
Mar 31, 2018 — = — × — × — × —

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).

Disaggregation of Net Profit Margin

EQT Corp., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Sep 30, 2022 15.05% = 0.76 × 0.90 × 21.98%
Jun 30, 2022 -7.69% = — × — × -7.10%
Mar 31, 2022 -32.25% = — × — × -39.40%
Dec 31, 2021 -16.99% = — × — × -18.83%
Sep 30, 2021 -59.90% = — × — × -74.84%
Jun 30, 2021 -41.53% = — × — × -49.64%
Mar 31, 2021 -27.41% = — × — × -29.44%
Dec 31, 2020 -36.49% = — × — × -37.54%
Sep 30, 2020 -82.92% = — × — × -98.71%
Jun 30, 2020 -69.47% = — × — × -80.14%
Mar 31, 2020 -48.83% = — × — × -54.25%
Dec 31, 2019 -32.22% = — × — × -36.86%
Sep 30, 2019 -15.58% = — × — × -13.22%
Jun 30, 2019 -7.74% = — × — × -5.03%
Mar 31, 2019 -9.87% = — × — × -9.89%
Dec 31, 2018 -47.80% = — × — × -57.76%
Sep 30, 2018 — = — × — × —
Jun 30, 2018 — = — × — × —
Mar 31, 2018 — = — × — × —

Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).