Stock Analysis on Net

Airbnb Inc. (NASDAQ:ABNB)

$24.99

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

Microsoft Excel

Paying user area


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

Airbnb Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Mar 31, 2025 = ×
Dec 31, 2024 = ×
Sep 30, 2024 = ×
Jun 30, 2024 = ×
Mar 31, 2024 = ×
Dec 31, 2023 = ×
Sep 30, 2023 = ×
Jun 30, 2023 = ×
Mar 31, 2023 = ×
Dec 31, 2022 = ×
Sep 30, 2022 = ×
Jun 30, 2022 = ×
Mar 31, 2022 = ×
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×

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

The analysis of the quarterly financial ratios reveals several notable trends over the reported periods.

Return on Assets (ROA)
The ROA initially showed negative performance with a recorded -2.57% at the end of 2021, which then improved steadily through 2022 and into early 2023. The improvement apexed at 25.47% in the last quarter of 2023. Following this peak, there was a noticeable gradual decline in ROA through 2024 and into the first quarter of 2025, falling to 10.13%. Although the ROA remains positive, indicating efficiency in asset utilization to generate earnings, the recent downward trend suggests some challenges or changes in asset management efficiency or profitability.
Financial Leverage
The financial leverage ratio shows variability over the periods, generally fluctuating between about 2.3 and 4.5. Initially, leverage declined from 3.91 in early 2021 to a low around 2.35 in the third quarter of 2023, reflecting a reduction in the use of debt relative to equity. Subsequently, leverage increased again to reach up to 3.29-3.16 by late 2024 and early 2025. This oscillation implies changes in capital structure strategy, with periods of reducing leverage potentially focusing on risk mitigation, followed by increased borrowing possibly to support growth initiatives or operational needs.
Return on Equity (ROE)
The ROE showed a marked improvement from a negative value of -7.37% at the end of 2021 to an impressive peak of 62.55% in the third quarter of 2024. This demonstrates significantly enhanced profitability for shareholders over time. The ROE trend follows a pattern of steady increase, reaching highs in 2023 and 2024, then experiencing a decline to around 31.98% by the first quarter of 2025. Despite the decline, ROE remains at a strong level, indicating continued effective use of equity to generate earnings. The fluctuations suggest variability in profitability drivers or changes in financial leverage and net income.

In summary, the period analyzed reflects an overall improvement in profitability metrics (ROA and ROE) with some cyclicality and a cautious approach in financial leverage. The improvements in ROE outpace those in ROA, which might be explained by the firm's leverage and capital structure strategies. The recent declines in profitability ratios, although still positive, warrant attention for potential underlying operational or financial factors.


Three-Component Disaggregation of ROE

Airbnb Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Mar 31, 2025 = × ×
Dec 31, 2024 = × ×
Sep 30, 2024 = × ×
Jun 30, 2024 = × ×
Mar 31, 2024 = × ×
Dec 31, 2023 = × ×
Sep 30, 2023 = × ×
Jun 30, 2023 = × ×
Mar 31, 2023 = × ×
Dec 31, 2022 = × ×
Sep 30, 2022 = × ×
Jun 30, 2022 = × ×
Mar 31, 2022 = × ×
Dec 31, 2021 = × ×
Sep 30, 2021 = × ×
Jun 30, 2021 = × ×
Mar 31, 2021 = × ×

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

Net Profit Margin
The net profit margin shows a significant positive trend beginning from the fourth quarter of 2021 where it was reported at -5.88%. Subsequently, it increased steadily, peaking at 56.87% in the fourth quarter of 2023. Following this peak, the margin exhibits a declining pattern but remains strong relative to earlier periods, finishing at 22.6% by the first quarter of 2025. This indicates improved profitability with considerable fluctuations after late 2023.
Asset Turnover
The asset turnover ratio starts reporting from the fourth quarter of 2021 at 0.44 and shows modest fluctuations throughout the observed period. It rises to a high of 0.53 in the first quarter of 2024 but generally oscillates in a narrow band between 0.39 and 0.53. This reflects relatively stable efficiency in utilizing assets to generate revenue over the period, with a slight improvement around early 2024.
Financial Leverage
Financial leverage displays considerable variability across the quarters. Beginning at 3.91 in the first quarter of 2021, it peaks at 4.56 in the second quarter of 2021, then declines to sub-3.0 levels in the last quarter of 2021 and again near the end of 2022 and 2023. Notably, spikes in leverage occur intermittently, such as in the second quarter of 2023 (4.19), but the overall trend suggests a moderate reliance on debt financing with periods of reduction and subsequent increases. The ratio settles around 3.16 in the first quarter of 2025, indicating stabilization in leverage.
Return on Equity (ROE)
ROE starts with negative performance at -7.37% in the fourth quarter of 2021, quickly turning positive and exhibiting a marked upward trend peaking at nearly 63% in the third quarter of 2024. This strong ROE is aligned with the observed increase in net profit margin and stable asset turnover, implying improved overall financial performance. After peaking, ROE declines but maintains relatively high values above 20% by early 2025, demonstrating sustained shareholder value creation despite some volatility.

Two-Component Disaggregation of ROA

Airbnb Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Mar 31, 2025 = ×
Dec 31, 2024 = ×
Sep 30, 2024 = ×
Jun 30, 2024 = ×
Mar 31, 2024 = ×
Dec 31, 2023 = ×
Sep 30, 2023 = ×
Jun 30, 2023 = ×
Mar 31, 2023 = ×
Dec 31, 2022 = ×
Sep 30, 2022 = ×
Jun 30, 2022 = ×
Mar 31, 2022 = ×
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×

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

Net Profit Margin
The net profit margin showed no data until the quarter ending December 31, 2021, where it registered a negative value of -5.88%. Starting in March 31, 2022, a significant positive trend emerged, with margins increasing steadily to reach a peak of 56.87% in December 31, 2023. This peak was followed by fluctuations, with margins decreasing to 16.96% by March 31, 2025. Despite these fluctuations, the margin remained positive and relatively strong, indicating improved profitability since early 2022.
Asset Turnover
Asset turnover data is available beginning December 31, 2021, at 0.44 and showed some variation over the analyzed periods. The ratio generally fluctuated between the range of 0.39 to 0.53, with the highest value recorded at 0.53 on March 31, 2025. Notably, there was an increase from late 2022 into early 2023, followed by minor declines in some quarters. This indicates modest variation in the efficiency with which the company's assets generate sales, with no clear long-term upward or downward trend.
Return on Assets (ROA)
The return on assets began with a negative value of -2.57% in December 31, 2021, then promptly increased to a positive 4.7% by March 31, 2022. From this point, ROA generally increased, reaching a substantial peak of 25.47% in December 31, 2023. Following this peak, there was a gradual decline with some fluctuations, reaching 10.13% by March 31, 2025. This pattern suggests that the company's ability to generate earnings from its assets improved dramatically after 2021 but faced some pressure after the high point at the end of 2023.