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

Microsoft Excel

Two-Component Disaggregation of ROE

EQT Corp., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2021 -11.52% = -5.35% × 2.15
Dec 31, 2020 -10.45% = -5.34% × 1.96
Dec 31, 2019 -12.46% = -6.50% × 1.92
Dec 31, 2018 -20.48% = -10.83% × 1.89
Dec 31, 2017 11.33% = 5.11% × 2.22

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Three-Component Disaggregation of ROE

EQT Corp., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2021 -11.52% = -16.99% × 0.31 × 2.15
Dec 31, 2020 -10.45% = -36.49% × 0.15 × 1.96
Dec 31, 2019 -12.46% = -32.22% × 0.20 × 1.92
Dec 31, 2018 -20.48% = -47.80% × 0.23 × 1.89
Dec 31, 2017 11.33% = 56.90% × 0.09 × 2.22

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Five-Component Disaggregation of ROE

EQT Corp., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2021 -11.52% = × × -18.83% × 0.31 × 2.15
Dec 31, 2020 -10.45% = × × -37.54% × 0.15 × 1.96
Dec 31, 2019 -12.46% = × × -36.86% × 0.20 × 1.92
Dec 31, 2018 -20.48% = × × -57.76% × 0.23 × 1.89
Dec 31, 2017 11.33% = 4.71 × 0.66 × 18.41% × 0.09 × 2.22

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Two-Component Disaggregation of ROA

EQT Corp., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2021 -5.35% = -16.99% × 0.31
Dec 31, 2020 -5.34% = -36.49% × 0.15
Dec 31, 2019 -6.50% = -32.22% × 0.20
Dec 31, 2018 -10.83% = -47.80% × 0.23
Dec 31, 2017 5.11% = 56.90% × 0.09

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Four-Component Disaggregation of ROA

EQT Corp., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2021 -5.35% = × × -18.83% × 0.31
Dec 31, 2020 -5.34% = × × -37.54% × 0.15
Dec 31, 2019 -6.50% = × × -36.86% × 0.20
Dec 31, 2018 -10.83% = × × -57.76% × 0.23
Dec 31, 2017 5.11% = 4.71 × 0.66 × 18.41% × 0.09

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Disaggregation of Net Profit Margin

EQT Corp., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2021 -16.99% = × × -18.83%
Dec 31, 2020 -36.49% = × × -37.54%
Dec 31, 2019 -32.22% = × × -36.86%
Dec 31, 2018 -47.80% = × × -57.76%
Dec 31, 2017 56.90% = 4.71 × 0.66 × 18.41%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).