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.

Analysis of Investments

Microsoft Excel

Adjustment to Net Income (Loss): Mark to Market Available-for-sale Securities

Expedia Group Inc., adjustment to net income (loss) attributable to Expedia Group, Inc.

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Net income (loss) attributable to Expedia Group, Inc. (as reported) 12 (2,612) 565 406 378
Add: Unrealized losses on available for sale securities, net of taxes (7)
Net income (loss) attributable to Expedia Group, Inc. (adjusted) 12 (2,612) 565 406 371

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


Adjusted Profitability Ratios: Mark to Market Available-for-sale Securities (Summary)

Expedia Group Inc., adjusted profitability ratios

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Net Profit Margin
Reported net profit margin 0.14% -50.24% 4.68% 3.62% 3.76%
Adjusted net profit margin 0.14% -50.24% 4.68% 3.62% 3.69%
Return on Equity (ROE)
Reported ROE 0.58% -103.16% 14.24% 9.89% 8.36%
Adjusted ROE 0.58% -103.16% 14.24% 9.89% 8.21%
Return on Assets (ROA)
Reported ROA 0.06% -13.98% 2.64% 2.25% 2.04%
Adjusted ROA 0.06% -13.98% 2.64% 2.25% 2.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).

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Expedia Group Inc. adjusted net profit margin ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Expedia Group Inc. adjusted ROE deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Expedia Group Inc. adjusted ROA deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.

Expedia Group Inc., Profitability Ratios: Reported vs. Adjusted


Adjusted Net Profit Margin

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Expedia Group, Inc. 12 (2,612) 565 406 378
Revenue 8,598 5,199 12,067 11,223 10,060
Profitability Ratio
Net profit margin1 0.14% -50.24% 4.68% 3.62% 3.76%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income (loss) attributable to Expedia Group, Inc. 12 (2,612) 565 406 371
Revenue 8,598 5,199 12,067 11,223 10,060
Profitability Ratio
Adjusted net profit margin2 0.14% -50.24% 4.68% 3.62% 3.69%

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

2021 Calculations

1 Net profit margin = 100 × Net income (loss) attributable to Expedia Group, Inc. ÷ Revenue
= 100 × 12 ÷ 8,598 = 0.14%

2 Adjusted net profit margin = 100 × Adjusted net income (loss) attributable to Expedia Group, Inc. ÷ Revenue
= 100 × 12 ÷ 8,598 = 0.14%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Expedia Group Inc. adjusted net profit margin ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.

Adjusted Return on Equity (ROE)

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Expedia Group, Inc. 12 (2,612) 565 406 378
Total Expedia Group, Inc. stockholders’ equity 2,057 2,532 3,967 4,104 4,522
Profitability Ratio
ROE1 0.58% -103.16% 14.24% 9.89% 8.36%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income (loss) attributable to Expedia Group, Inc. 12 (2,612) 565 406 371
Total Expedia Group, Inc. stockholders’ equity 2,057 2,532 3,967 4,104 4,522
Profitability Ratio
Adjusted ROE2 0.58% -103.16% 14.24% 9.89% 8.21%

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

2021 Calculations

1 ROE = 100 × Net income (loss) attributable to Expedia Group, Inc. ÷ Total Expedia Group, Inc. stockholders’ equity
= 100 × 12 ÷ 2,057 = 0.58%

2 Adjusted ROE = 100 × Adjusted net income (loss) attributable to Expedia Group, Inc. ÷ Total Expedia Group, Inc. stockholders’ equity
= 100 × 12 ÷ 2,057 = 0.58%

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Expedia Group Inc. adjusted ROE deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.

Adjusted Return on Assets (ROA)

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Expedia Group, Inc. 12 (2,612) 565 406 378
Total assets 21,548 18,690 21,416 18,033 18,516
Profitability Ratio
ROA1 0.06% -13.98% 2.64% 2.25% 2.04%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income (loss) attributable to Expedia Group, Inc. 12 (2,612) 565 406 371
Total assets 21,548 18,690 21,416 18,033 18,516
Profitability Ratio
Adjusted ROA2 0.06% -13.98% 2.64% 2.25% 2.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).

2021 Calculations

1 ROA = 100 × Net income (loss) attributable to Expedia Group, Inc. ÷ Total assets
= 100 × 12 ÷ 21,548 = 0.06%

2 Adjusted ROA = 100 × Adjusted net income (loss) attributable to Expedia Group, Inc. ÷ Total assets
= 100 × 12 ÷ 21,548 = 0.06%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Expedia Group Inc. adjusted ROA deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.