Stock Analysis on Net

Airbnb Inc. (NASDAQ:ABNB)

Return on Capital (ROC)

Microsoft Excel

Return on capital (ROC) is after tax rate of return on net business assets. ROIC is unaffected by changes in interest rates or company debt and equity structure. It measures business productivity performance.


Return on Invested Capital (ROIC)

Airbnb Inc., ROIC calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1 1,681 2,070 465 (4,675)
Invested capital2 5,829 6,849 5,836 4,764
Performance Ratio
ROIC3 28.83% 30.22% 7.96% -98.14%
Benchmarks
ROIC, Competitors4
Booking Holdings Inc. 32.92% 21.73% 4.47% 4.60%
Carnival Corp. & plc 5.60% -10.16% -16.90% -19.00%
Chipotle Mexican Grill Inc. 23.36% 19.01% 14.35% 12.43%
McDonald’s Corp. 18.51% 15.69% 17.77% 13.16%
Starbucks Corp. 20.76% 18.24% 19.53% 6.42%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 NOPAT. See details »

2 Invested capital. See details »

3 2023 Calculation
ROIC = 100 × NOPAT ÷ Invested capital
= 100 × 1,681 ÷ 5,829 = 28.83%

4 Click competitor name to see calculations.

Performance ratio Description The company
ROIC A measure of the periodic, after tax, cash-on-cash yield earned in the business. Airbnb Inc. ROIC improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Decomposition of ROIC

Airbnb Inc., decomposition of ROIC

Microsoft Excel
ROIC = OPM1 × TO2 × 1 – CTR3
Dec 31, 2023 28.83% = 17.09% × 1.74 × 96.79%
Dec 31, 2022 30.22% = 24.64% × 1.27 × 96.81%
Dec 31, 2021 7.96% = 9.31% × 1.11 × 76.96%
Dec 31, 2020 -98.14% = -151.42% × 0.65 × 100.00%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 Operating profit margin (OPM). See calculations »

2 Turnover of capital (TO). See calculations »

3 Effective cash tax rate (CTR). See calculations »

The primary reason for the decrease in return on invested capital (ROIC) over 2023 year is the decrease in profitability measured by operating profit margin (OPM) ratio.


Operating Profit Margin (OPM)

Airbnb Inc., OPM calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1 1,681 2,070 465 (4,675)
Add: Cash operating taxes2 56 68 139 (36)
Net operating profit before taxes (NOPBT) 1,737 2,138 604 (4,711)
 
Revenue 9,917 8,399 5,992 3,378
Add: Increase (decrease) in unearned fees 245 278 496 (267)
Adjusted revenue 10,162 8,677 6,488 3,111
Profitability Ratio
OPM3 17.09% 24.64% 9.31% -151.42%
Benchmarks
OPM, Competitors4
Booking Holdings Inc. 25.31% 24.15% 13.04% 15.18%
Carnival Corp. & plc 8.56% -36.78% -413.03% -166.71%
Chipotle Mexican Grill Inc. 18.74% 16.00% 13.23% 8.03%
McDonald’s Corp. 48.59% 40.79% 46.68% 41.21%
Starbucks Corp. 17.05% 14.97% 20.82% 7.99%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 NOPAT. See details »

2 Cash operating taxes. See details »

3 2023 Calculation
OPM = 100 × NOPBT ÷ Adjusted revenue
= 100 × 1,737 ÷ 10,162 = 17.09%

4 Click competitor name to see calculations.

Profitability ratio Description The company
OPM The operating profit margin (OPM) is the ratio of pretax economic earnings, or NOPBT, to sales. Airbnb Inc. OPM improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Turnover of Capital (TO)

Airbnb Inc., TO calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Revenue 9,917 8,399 5,992 3,378
Add: Increase (decrease) in unearned fees 245 278 496 (267)
Adjusted revenue 10,162 8,677 6,488 3,111
 
Invested capital1 5,829 6,849 5,836 4,764
Efficiency Ratio
TO2 1.74 1.27 1.11 0.65
Benchmarks
TO, Competitors3
Booking Holdings Inc. 1.87 1.25 0.73 0.47
Carnival Corp. & plc 0.55 0.28 0.04 0.11
Chipotle Mexican Grill Inc. 1.65 1.61 1.38 1.22
McDonald’s Corp. 0.51 0.51 0.49 0.41
Starbucks Corp. 1.62 1.57 1.23 1.03

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 Invested capital. See details »

2 2023 Calculation
TO = Adjusted revenue ÷ Invested capital
= 10,162 ÷ 5,829 = 1.74

3 Click competitor name to see calculations.

Efficiency ratio Description The company
TO The turnover of capital (TO) is the ratio of sales to invested capital. Capital turnover is a function of the efficiency of working capital management and of net fixed assets. Airbnb Inc. TO improved from 2021 to 2022 and from 2022 to 2023.

Effective Cash Tax Rate (CTR)

Airbnb Inc., CTR calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1 1,681 2,070 465 (4,675)
Add: Cash operating taxes2 56 68 139 (36)
Net operating profit before taxes (NOPBT) 1,737 2,138 604 (4,711)
Tax Rate
CTR3 3.21% 3.19% 23.04%
Benchmarks
CTR, Competitors4
Booking Holdings Inc. 30.52% 28.16% 53.06% 35.06%
Carnival Corp. & plc -19.35%
Chipotle Mexican Grill Inc. 24.38% 25.95% 21.28% -27.06%
McDonald’s Corp. 25.22% 24.66% 21.80% 22.33%
Starbucks Corp. 24.73% 22.36% 23.58% 21.57%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 NOPAT. See details »

2 Cash operating taxes. See details »

3 2023 Calculation
CTR = 100 × Cash operating taxes ÷ NOPBT
= 100 × 56 ÷ 1,737 = 3.21%

4 Click competitor name to see calculations.

Tax rate Description The company
CTR Effective cash tax rate on operating income. Airbnb Inc. CTR decreased from 2021 to 2022 but then slightly increased from 2022 to 2023.