Stock Analysis on Net
Stock Analysis on Net

Expedia Group Inc. (NASDAQ:EXPE)

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

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

Microsoft Excel

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

Two-Component Disaggregation of ROE

Expedia Group Inc., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2021 0.58% = 0.06% × 10.48
Dec 31, 2020 -103.16% = -13.98% × 7.38
Dec 31, 2019 14.24% = 2.64% × 5.40
Dec 31, 2018 9.89% = 2.25% × 4.39
Dec 31, 2017 8.36% = 2.04% × 4.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).

Three-Component Disaggregation of ROE

Expedia Group Inc., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2021 0.58% = 0.14% × 0.40 × 10.48
Dec 31, 2020 -103.16% = -50.24% × 0.28 × 7.38
Dec 31, 2019 14.24% = 4.68% × 0.56 × 5.40
Dec 31, 2018 9.89% = 3.62% × 0.62 × 4.39
Dec 31, 2017 8.36% = 3.76% × 0.54 × 4.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).

Five-Component Disaggregation of ROE

Expedia Group Inc., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2021 0.58% = — × -0.13 × 3.61% × 0.40 × 10.48
Dec 31, 2020 -103.16% = — × — × -51.45% × 0.28 × 7.38
Dec 31, 2019 14.24% = 0.74 × 0.82 × 7.80% × 0.56 × 5.40
Dec 31, 2018 9.89% = 0.82 × 0.72 × 6.09% × 0.62 × 4.39
Dec 31, 2017 8.36% = 0.89 × 0.70 × 6.01% × 0.54 × 4.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).

Two-Component Disaggregation of ROA

Expedia Group Inc., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2021 0.06% = 0.14% × 0.40
Dec 31, 2020 -13.98% = -50.24% × 0.28
Dec 31, 2019 2.64% = 4.68% × 0.56
Dec 31, 2018 2.25% = 3.62% × 0.62
Dec 31, 2017 2.04% = 3.76% × 0.54

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

Expedia Group Inc., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2021 0.06% = — × -0.13 × 3.61% × 0.40
Dec 31, 2020 -13.98% = — × — × -51.45% × 0.28
Dec 31, 2019 2.64% = 0.74 × 0.82 × 7.80% × 0.56
Dec 31, 2018 2.25% = 0.82 × 0.72 × 6.09% × 0.62
Dec 31, 2017 2.04% = 0.89 × 0.70 × 6.01% × 0.54

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

Expedia Group Inc., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2021 0.14% = — × -0.13 × 3.61%
Dec 31, 2020 -50.24% = — × — × -51.45%
Dec 31, 2019 4.68% = 0.74 × 0.82 × 7.80%
Dec 31, 2018 3.62% = 0.82 × 0.72 × 6.09%
Dec 31, 2017 3.76% = 0.89 × 0.70 × 6.01%

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).