Expedia Group Inc. (NASDAQ:EXPE)

An analysis of operating activity ratios indicates significant fluctuations in liquidity management, characterized by a notable deviation in efficiency metrics during the 2020 fiscal year followed by a partial return to historical norms in 2021.

Receivables Management

A gradual decline in receivables turnover was observed from 2017 to 2019, falling from 5.39 to 4.78, which corresponded with an increase in the average receivable collection period from 68 to 76 days. This trend reversed sharply in 2020, where turnover peaked at 7.42 and the collection period dropped to its lowest point of 49 days. In 2021, the turnover ratio moderated to 6.80 with a collection period of 54 days, suggesting a more efficient collection cycle compared to the 2017-2019 period.

Payables Management

Payables turnover remained relatively stable between 2017 and 2019, hovering around 1.0, with the average payables payment period remaining high, between 333 and 382 days. A significant shift occurred in 2020, marked by a spike in turnover to 2.79 and a drastic reduction in the payment period to 131 days. By 2021, these metrics returned toward historical levels, with the turnover decreasing to 1.14 and the payment period extending back to 320 days.

Working Capital Efficiency

Working capital turnover shows limited visibility, with a reported ratio of 22.80 for the period ending December 31, 2020. Due to the absence of values for other years, a trend analysis for this specific metric is not possible.

The analysis of receivables turnover from 2017 to 2021 reveals a period of initial decline followed by a significant volatility spike and a subsequent stabilization at a higher efficiency level. The relationship between revenue growth and the collection of outstanding receivables shifted markedly during the observed five-year window.

Pre-Crisis Performance (2017–2019)

During this period, revenue experienced steady growth, increasing from 10,060 million USD to 12,067 million USD. However, accounts receivable grew at a faster relative pace, rising from 1,866 million USD to 2,524 million USD. This imbalance resulted in a consistent decline in the receivables turnover ratio, which dropped from 5.39 in 2017 to 4.78 in 2019, suggesting a slowing of the collection cycle or a widening of credit terms offered to clients.

Crisis Impact and Anomaly (2020)

The year 2020 was characterized by a severe contraction in operations, with revenue falling to 5,199 million USD. Concurrently, net accounts receivable plummeted to 701 million USD. The disproportionate decrease in receivables relative to the drop in revenue caused the turnover ratio to spike to 7.42. This peak indicates a rapid liquidation of outstanding balances or a fundamental shift in the volume of credit-based transactions during the operational downturn.

Recovery and Stabilization (2021)

In 2021, a recovery trend is evident as revenue climbed back to 8,598 million USD and accounts receivable increased to 1,264 million USD. The receivables turnover ratio moderated to 6.80. Although this represents a slight decrease from the 2020 peak, the ratio remains significantly higher than the levels recorded between 2017 and 2019, indicating a more efficient conversion of receivables into cash in the post-crisis environment.

The analysis of short-term operating activity indicates a period of relative stability in payables management between 2017 and 2019, followed by significant volatility in 2020 and a return toward baseline levels in 2021.

Payables Turnover Ratio Trends

From 2017 to 2019, the payables turnover ratio remained consistent, fluctuating slightly between 0.96 and 1.08. This suggests a steady rate of supplier payment relative to the cost of revenue. A significant anomaly occurred in 2020, where the ratio spiked to 2.79, the highest value in the analyzed period, before correcting to 1.14 in 2021.

Impact of Accounts Payable Volatility

The spike in the turnover ratio in 2020 is primarily attributed to a substantial contraction in merchant accounts payable, which decreased to 602 million US dollars from 1,921 million US dollars in 2019. While the cost of revenue also declined during this period, the magnitude of the decline in payables was disproportionately larger, resulting in a sharp increase in the turnover ratio.

Cost of Revenue and Obligation Correlation

Costs of revenue, exclusive of depreciation and amortization, exhibited a growth trend through 2019, peaking at 2,077 million US dollars. The subsequent decline in 2020 and 2021 aligns with a reduction in operating activity. The recovery of accounts payable to 1,333 million US dollars in 2021 indicates a normalization of supplier obligations, returning the turnover ratio to a range consistent with pre-2020 performance.

The analysis of short-term operating activity reveals significant volatility in both revenue and working capital positions between 2017 and 2021, characterized by a severe disruption in 2020 followed by a recovery phase.

Revenue Trends

Revenue exhibited steady growth from 2017 to 2019, increasing from 10,060 million to 12,067 million. A sharp contraction occurred in 2020, where revenue declined to 5,199 million, representing a substantial decrease from the previous year. A partial recovery was observed in 2021, with revenue rising to 8,598 million.

Working Capital Dynamics

A negative working capital position was maintained from 2017 through 2019, reaching a peak deficit of -2,979 million in 2019. This trend shifted abruptly in 2020, when working capital turned positive at 228 million. By 2021, the company returned to a negative working capital state of -1,269 million.

Working Capital Turnover Analysis

The working capital turnover ratio is reported only for 2020, as negative working capital values in the other periods render the traditional turnover calculation non-standard. In 2020, the ratio was 22.80, reflecting the operational efficiency relative to the positive working capital balance during a period of significantly reduced revenue.

The analysis of short-term operating activity reveals a distinct shift in the efficiency of receivable management between 2017 and 2021, characterized by an initial period of decline followed by a significant operational improvement.

Receivables Turnover

A downward trend is observed from 2017 to 2019, with the ratio declining from 5.39 to 4.78, indicating a slowing rate of receivable conversion. This trend reversed sharply in 2020, when the turnover ratio reached a peak of 7.42. Although there was a slight moderation to 6.80 in 2021, the turnover rate remained substantially higher than the levels recorded during the 2017-2019 period.

Average Receivable Collection Period

The collection period experienced a steady increase during the first three years of the analyzed period, rising from 68 days in 2017 to a high of 76 days in 2019. This expansion suggests a decrease in the velocity of cash inflows from customers. A dramatic contraction occurred in 2020, with the collection period dropping to 49 days, the lowest point in the dataset. In 2021, the period increased slightly to 54 days, yet it remained significantly more efficient than the pre-2020 averages.

The correlation between the increase in turnover and the decrease in the collection period starting in 2020 suggests a fundamental change in credit management or a shift in the composition of receivables. The company transitioned from a period of deteriorating collection efficiency to a more accelerated cash conversion cycle that remained largely intact through 2021.

The analysis of operating activity ratios reveals a consistent pattern of extended payable cycles, characterized by a significant anomaly during the 2020 fiscal year.

Payables Turnover

The turnover ratio remained relatively stable from 2017 to 2019, fluctuating between 0.96 and 1.10. A substantial spike occurred in 2020, where the ratio increased to 2.79, indicating a significant acceleration in the rate at which obligations were settled. This trend reversed in 2021, as the ratio declined to 1.14, returning to levels consistent with the pre-2020 period.

Average Payables Payment Period

The duration required to settle payables was notably high between 2017 and 2019, ranging from 333 to 382 days. This period experienced a sharp contraction in 2020, falling to 131 days, which corresponds with the peak in the turnover ratio. By 2021, the payment period extended again to 320 days, indicating a return to the historical practice of longer-term payment deferrals.

The inverse correlation between payables turnover and the payment period is maintained throughout the observed timeframe. The drastic shift in 2020 suggests a temporary deviation in working capital management or an extraordinary settlement of liabilities, followed by a normalization of the operating cycle in 2021.