Analysis of Short-term (Operating) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
Mastercard Inc., short-term (operating) activity ratios (quarterly data)
Based on: 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), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
The financial data indicates dynamic fluctuations across key operational efficiency metrics over the examined periods. Trends when reviewing turnover ratios and average periods reveal variations that suggest changes in both collection and payment practices.
- Receivables Turnover
- The receivables turnover ratio exhibits volatility, dropping significantly during late 2019 before recovering sharply in 2020 and maintaining elevated levels subsequently. The lowest ratios appear in the second half of 2019, with values around 5.6 to 6.0, while peaks reach above 20 in late 2021 and late 2022. This trend suggests periods of slower receivable collection followed by marked improvements in efficiency, with faster collection cycles becoming more prominent in recent quarters.
- Payables Turnover
- Similar to receivables turnover, payables turnover ratios show pronounced variability. The ratio fell to single-digit levels in late 2019, followed by a resurgence to double-digit highs exceeding 30 in mid-2021 and again in early 2022. Such fluctuations imply changes in the timing of payments to suppliers, alternating between slower settlement periods in 2019 and much faster payables processing afterwards.
- Working Capital Turnover
- Working capital turnover demonstrates a general upward trend, with a notable dip in 2020 followed by consistent growth thereafter. Starting from below 2 in mid-2020, the ratio climbs steadily, exceeding 9 by the end of 2022. This pattern indicates improving effectiveness in utilizing working capital to generate sales or revenue, particularly in recent years.
- Average Receivable Collection Period
- The average collection period reflects an inverse movement to receivables turnover. It increased sharply towards the end of 2019, reaching over 60 days, before contracting substantially during 2020 and maintaining shorter collection times thereafter. Recent quarters show collection periods around 17 to 21 days, pointing to enhanced efficiency in collecting receivables.
- Average Payables Payment Period
- The average payment period extends notably in late 2019, coinciding with a period of lower payables turnover. It dips to very short intervals of around 10 days in mid-2021, followed by moderate increases in subsequent periods. The shorter payment periods in recent years indicate a strategy of quicker supplier payments at certain intervals, although some variability persists.
Overall, the data portrays a company that experienced operational slowdowns in collections and payments during late 2019, likely due to external factors impacting liquidity and cash conversion cycles. From 2020 onwards, there is a clear trend toward improved working capital management, characterized by faster receivables collection, quicker payments in some quarters, and a more efficient utilization of working capital. These patterns suggest an enhanced focus on cash flow optimization and operational efficiency in the recent fiscal periods.
Turnover Ratios
Average No. Days
Receivables Turnover
Mastercard Inc., receivables turnover calculation (quarterly data)
| 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 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||
| Net revenue | 5,748) | 5,817) | 5,756) | 5,497) | 5,167) | 5,216) | 4,985) | 4,528) | 4,155) | 4,120) | 3,837) | 3,335) | 4,009) | 4,414) | 4,467) | 4,113) | 3,889) | ||||||
| Settlement assets | 1,236) | 1,270) | 1,019) | 1,063) | 1,101) | 1,319) | 861) | 937) | 1,678) | 1,706) | 1,375) | 1,782) | 1,164) | 2,995) | 2,723) | 1,549) | 1,426) | ||||||
| Short-term Activity Ratio | |||||||||||||||||||||||
| Receivables turnover1 | 18.46 | 17.51 | 21.23 | 19.63 | 18.07 | 14.32 | 20.66 | 17.76 | 9.21 | 8.97 | 11.34 | 9.10 | 14.61 | 5.64 | 5.98 | 10.14 | 10.70 | ||||||
| Benchmarks | |||||||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||||||
| Adobe Inc. | 9.99 | 8.53 | 9.98 | 10.51 | 9.58 | 8.41 | 9.77 | 9.74 | 9.00 | 9.20 | 9.44 | 8.82 | 8.40 | — | — | — | — | ||||||
| AppLovin Corp. | 4.56 | 4.01 | 4.37 | 4.23 | 4.11 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Cadence Design Systems Inc. | 7.54 | 7.32 | 8.78 | 8.38 | 8.72 | 8.85 | 9.09 | 7.41 | 7.21 | — | — | — | — | — | — | — | — | ||||||
| CrowdStrike Holdings Inc. | 4.43 | 3.94 | 4.54 | 4.27 | 4.73 | 3.66 | 4.41 | 4.38 | 3.91 | — | — | — | — | — | — | — | — | ||||||
| Datadog Inc. | 4.89 | 4.19 | 4.39 | 4.47 | 4.33 | 3.83 | 3.92 | 4.06 | 4.35 | — | — | — | — | — | — | — | — | ||||||
| International Business Machines Corp. | 10.52 | 9.25 | 10.95 | 10.17 | 9.79 | 8.49 | 9.23 | 9.57 | 10.72 | — | — | — | — | — | — | — | — | ||||||
| Intuit Inc. | 34.68 | 28.53 | 17.44 | 12.84 | 25.10 | 24.64 | 16.04 | 16.60 | 79.16 | — | — | — | — | — | — | — | — | ||||||
| Microsoft Corp. | 6.49 | 4.48 | 5.90 | 5.52 | 6.44 | 4.42 | 6.08 | 5.61 | 6.44 | — | — | — | — | — | — | — | — | ||||||
| Oracle Corp. | 7.44 | 7.13 | 9.12 | 9.28 | 9.11 | 7.48 | 8.56 | 8.91 | 8.57 | — | — | — | — | — | — | — | — | ||||||
| Palantir Technologies Inc. | 7.81 | 7.38 | 5.33 | 6.56 | 6.42 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Palo Alto Networks Inc. | 4.70 | 2.57 | 4.17 | 5.10 | 5.61 | 3.43 | 5.20 | 5.65 | 5.30 | — | — | — | — | — | — | — | — | ||||||
| Salesforce Inc. | 7.07 | 2.72 | 6.22 | 5.78 | 7.04 | 2.73 | 6.12 | 5.63 | 5.93 | — | — | — | — | — | — | — | — | ||||||
| ServiceNow Inc. | 6.87 | 4.20 | 7.71 | 7.74 | 7.59 | 4.24 | 7.13 | 6.62 | 7.49 | — | — | — | — | — | — | — | — | ||||||
| Synopsys Inc. | 5.00 | 6.38 | 7.25 | 6.58 | 4.34 | 7.40 | 7.06 | 6.51 | 4.84 | 4.72 | 5.50 | 5.36 | 4.22 | — | — | — | — | ||||||
| Workday Inc. | 6.94 | 4.14 | 5.66 | 5.35 | 6.91 | 4.18 | 5.60 | 5.75 | 6.54 | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q1 2023 Calculation
Receivables turnover
= (Net revenueQ1 2023
+ Net revenueQ4 2022
+ Net revenueQ3 2022
+ Net revenueQ2 2022)
÷ Settlement assets
= (5,748 + 5,817 + 5,756 + 5,497)
÷ 1,236 = 18.46
2 Click competitor name to see calculations.
- Net Revenue
-
Net revenue exhibited a generally upward trend over the period analyzed. Starting at 3,889 million USD in the first quarter of 2019, the figure increased steadily, peaking at 5,817 million USD in the last quarter of 2022 before slightly declining to 5,748 million USD in the first quarter of 2023. Notably, there was a decline in revenue during the first half of 2020, likely reflecting external economic impacts, followed by a recovery and consistent growth through 2021 and 2022.
- Settlement Assets
-
Settlement assets showed considerable volatility throughout the timeline. Initial values in early 2019 hovered around 1,400-1,500 million USD, with a substantial increase in the third and fourth quarters of that year, reaching nearly 3,000 million USD by year-end. However, in 2020 settlement assets dropped sharply, hitting a low point around 860 million USD in the third quarter, before gradually recovering toward 1,300 million USD by late 2022. The data suggests significant fluctuations that may relate to operational or market factors affecting settlement volumes or timing.
- Receivables Turnover
-
The receivables turnover ratio experienced significant fluctuations across the quarters. Starting at 10.7 initially, it decreased markedly in the third and fourth quarters of 2019, reaching lows near 5.6, indicating slower collection periods or increased credit risk. This was followed by a sharp increase in early 2020, with the ratio peaking at 14.61 and maintaining generally higher levels throughout 2021, with the highest recorded value of 20.66 in the third quarter. Through 2022 and into early 2023, the turnover ratio remained elevated, ranging mostly between 17.5 and 21.2, indicating improved efficiency in managing receivables or changes in credit policy.
Payables Turnover
Mastercard Inc., payables turnover calculation (quarterly data)
| 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 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||
| Net revenue | 5,748) | 5,817) | 5,756) | 5,497) | 5,167) | 5,216) | 4,985) | 4,528) | 4,155) | 4,120) | 3,837) | 3,335) | 4,009) | 4,414) | 4,467) | 4,113) | 3,889) | ||||||
| Settlement obligations | 870) | 1,111) | 1,054) | 672) | 547) | 913) | 496) | 569) | 1,297) | 1,475) | 1,129) | 1,527) | 1,149) | 2,714) | 2,158) | 1,330) | 1,189) | ||||||
| Short-term Activity Ratio | |||||||||||||||||||||||
| Payables turnover1 | 26.23 | 20.02 | 20.53 | 31.05 | 36.37 | 20.68 | 35.86 | 29.24 | 11.91 | 10.37 | 13.81 | 10.63 | 14.80 | 6.22 | 7.54 | 11.81 | 12.83 | ||||||
| Benchmarks | |||||||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||||||
| Accenture PLC | 17.54 | 16.37 | 16.93 | 17.22 | 16.45 | 15.03 | 16.92 | 17.94 | 20.16 | — | — | — | — | — | — | — | — | ||||||
| Adobe Inc. | 7.21 | 5.71 | 6.66 | 5.53 | 6.54 | 5.98 | 5.40 | 5.60 | 6.76 | 5.63 | 7.62 | 6.00 | 6.52 | — | — | — | — | ||||||
| AppLovin Corp. | 4.37 | 4.60 | 4.40 | 3.90 | 2.83 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| CrowdStrike Holdings Inc. | 39.15 | 8.05 | 47.07 | 15.13 | 75.30 | 19.03 | 27.52 | 17.99 | 24.39 | — | — | — | — | — | — | — | — | ||||||
| Datadog Inc. | 8.95 | 14.77 | 11.48 | 6.02 | 14.07 | 9.27 | 6.00 | 6.10 | 12.46 | — | — | — | — | — | — | — | — | ||||||
| International Business Machines Corp. | 7.44 | 6.87 | 7.35 | 7.40 | 7.69 | 6.54 | 6.71 | 7.47 | 8.35 | — | — | — | — | — | — | — | — | ||||||
| Intuit Inc. | 3.98 | 3.26 | 2.52 | 2.31 | 3.47 | 2.70 | 2.56 | 2.82 | 5.25 | — | — | — | — | — | — | — | — | ||||||
| Microsoft Corp. | 3.88 | 3.30 | 3.74 | 3.76 | 3.70 | 3.44 | 3.77 | 3.80 | 3.73 | — | — | — | — | — | — | — | — | ||||||
| Oracle Corp. | 6.72 | 6.74 | 7.65 | 8.03 | 10.79 | 10.54 | 9.49 | 10.71 | 14.72 | — | — | — | — | — | — | — | — | ||||||
| Palantir Technologies Inc. | 93.11 | 9.12 | 6.58 | 6.53 | 13.10 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Palo Alto Networks Inc. | 14.30 | 13.43 | 14.68 | 12.25 | 14.46 | 22.41 | 16.80 | 25.37 | 21.85 | — | — | — | — | — | — | — | — | ||||||
| ServiceNow Inc. | 7.20 | 5.74 | 7.86 | 5.60 | 8.57 | 15.20 | 19.64 | 11.82 | 9.75 | — | — | — | — | — | — | — | — | ||||||
| Workday Inc. | 12.14 | 25.74 | 28.20 | 24.24 | 25.48 | 15.85 | 21.29 | 19.83 | 31.83 | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q1 2023 Calculation
Payables turnover
= (Net revenueQ1 2023
+ Net revenueQ4 2022
+ Net revenueQ3 2022
+ Net revenueQ2 2022)
÷ Settlement obligations
= (5,748 + 5,817 + 5,756 + 5,497)
÷ 870 = 26.23
2 Click competitor name to see calculations.
- Net Revenue
- The net revenue displayed an overall upward trend from March 2019 to March 2023. Starting at $3,889 million in March 2019, it demonstrated steady growth with some fluctuations, particularly a decline between March 2020 and June 2020, likely reflecting external disruptions during that period. Subsequently, net revenue recovered and consistently increased to reach a peak of $5,817 million in December 2022, before a slight decline to $5,748 million in March 2023. This pattern indicates resilience and growth in core business operations over the observed period.
- Settlement Obligations
- Settlement obligations exhibited considerable volatility throughout the timeframe. Initial values rose significantly from $1,189 million in March 2019 to a peak of $2,714 million by December 2019. This was followed by a sharp decrease in early 2020, with values dropping to a low of $496 million in September 2021. Starting late 2021, the obligations began to rise again, stabilizing between $1,000 and $1,100 million towards the end of 2022 and early 2023. The irregular pattern suggests fluctuations in operational activity or changes in timing of settlements that may impact liquidity management.
- Payables Turnover Ratio
- The payables turnover ratio showed significant variability across the quarters. Initially, the ratio decreased from 12.83 in March 2019 to a low of 6.22 by December 2019, indicating a slower rate of paying obligations. The ratio then experienced a sharp increase in early 2020, reaching 14.8 in March 2020, followed by fluctuations with a striking peak at 35.86 in September 2021. After this peak, the ratio decreased but remained elevated compared to the earlier period, with values above 20 through 2022 into 2023. Higher turnover ratios in the latter period may suggest more efficient management of payables or changes in payment timing policies.
- Summary
- Overall, the data indicates that revenue generation improved substantially over the period, recovering quickly following downturns. Settlement obligations fluctuated widely, which may reflect variability in operational cycles or payment schedules. The payables turnover ratio's volatility points to changes in how quickly obligations were settled, with a trend toward faster payments in recent years. These dynamics collectively highlight active management of financial operations amid evolving business conditions.
Working Capital Turnover
Mastercard Inc., working capital turnover calculation (quarterly data)
| 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 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||
| Current assets | 16,420) | 16,606) | 16,823) | 15,211) | 15,953) | 16,949) | 15,382) | 15,079) | 16,405) | 19,113) | 18,469) | 19,381) | 18,123) | 16,902) | 14,847) | 14,165) | 14,396) | ||||||
| Less: Current liabilities | 13,651) | 14,171) | 13,476) | 12,085) | 11,928) | 13,162) | 11,561) | 11,297) | 11,475) | 11,847) | 9,958) | 9,923) | 9,712) | 11,904) | 10,714) | 9,497) | 10,246) | ||||||
| Working capital | 2,769) | 2,435) | 3,347) | 3,126) | 4,025) | 3,787) | 3,821) | 3,782) | 4,930) | 7,266) | 8,511) | 9,458) | 8,411) | 4,998) | 4,133) | 4,668) | 4,150) | ||||||
| Net revenue | 5,748) | 5,817) | 5,756) | 5,497) | 5,167) | 5,216) | 4,985) | 4,528) | 4,155) | 4,120) | 3,837) | 3,335) | 4,009) | 4,414) | 4,467) | 4,113) | 3,889) | ||||||
| Short-term Activity Ratio | |||||||||||||||||||||||
| Working capital turnover1 | 8.24 | 9.13 | 6.46 | 6.67 | 4.94 | 4.99 | 4.66 | 4.40 | 3.13 | 2.11 | 1.83 | 1.72 | 2.02 | 3.38 | 3.94 | 3.36 | 3.68 | ||||||
| Benchmarks | |||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||
| Accenture PLC | 14.81 | 15.07 | 13.41 | 15.55 | 15.85 | 12.77 | 7.71 | 8.35 | 7.70 | — | — | — | — | — | — | — | — | ||||||
| Adobe Inc. | 19.89 | 20.28 | 16.36 | 31.92 | 57.86 | 9.09 | 6.22 | 7.44 | 8.67 | 4.89 | 5.51 | 8.11 | 9.50 | — | — | — | — | ||||||
| AppLovin Corp. | 2.03 | 2.07 | 2.27 | 2.49 | 1.86 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Cadence Design Systems Inc. | 7.12 | 9.92 | 8.31 | 5.34 | 4.07 | 4.01 | 4.68 | 5.45 | 5.03 | — | — | — | — | — | — | — | — | ||||||
| CrowdStrike Holdings Inc. | 1.32 | 1.25 | 1.15 | 1.02 | 0.95 | 0.61 | 1.19 | 0.92 | 0.81 | — | — | — | — | — | — | — | — | ||||||
| Datadog Inc. | 1.06 | 1.06 | 1.02 | 0.95 | 0.85 | 0.77 | 0.68 | 0.61 | 0.47 | — | — | — | — | — | — | — | — | ||||||
| International Business Machines Corp. | 12.14 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Intuit Inc. | 10.83 | 8.98 | 5.68 | 21.87 | 4.39 | 3.85 | 3.40 | 5.45 | 1.74 | — | — | — | — | — | — | — | — | ||||||
| Microsoft Corp. | 2.77 | 2.66 | 2.52 | 1.91 | 1.88 | 1.76 | 1.71 | 1.44 | 1.37 | — | — | — | — | — | — | — | — | ||||||
| Oracle Corp. | — | 3.50 | 3.86 | 3.39 | 1.70 | 1.29 | 1.69 | 1.58 | 1.26 | — | — | — | — | — | — | — | — | ||||||
| Palantir Technologies Inc. | 0.75 | 0.78 | 0.81 | 0.78 | 0.73 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Palo Alto Networks Inc. | — | — | — | — | — | — | 3.52 | — | 2.15 | — | — | — | — | — | — | — | — | ||||||
| Salesforce Inc. | 54.57 | 24.95 | 27.10 | — | 4.36 | 5.11 | 7.48 | 10.29 | 9.75 | — | — | — | — | — | — | — | — | ||||||
| ServiceNow Inc. | 7.83 | 11.16 | 6.63 | 11.21 | 10.61 | 21.76 | 11.15 | 16.31 | 5.62 | — | — | — | — | — | — | — | — | ||||||
| Synopsys Inc. | 17.05 | 21.34 | 14.02 | 7.78 | 9.47 | 10.65 | 9.50 | 9.18 | 16.88 | 9.00 | 27.06 | — | — | — | — | — | — | ||||||
| Workday Inc. | 2.03 | 35.15 | 11.69 | 24.99 | — | 8.31 | 12.50 | 3.44 | 5.62 | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q1 2023 Calculation
Working capital turnover
= (Net revenueQ1 2023
+ Net revenueQ4 2022
+ Net revenueQ3 2022
+ Net revenueQ2 2022)
÷ Working capital
= (5,748 + 5,817 + 5,756 + 5,497)
÷ 2,769 = 8.24
2 Click competitor name to see calculations.
The analysis of Mastercard Inc.'s quarterly financial data reveals significant fluctuations and trends in working capital, net revenue, and working capital turnover over the observed periods.
- Working Capital
- Working capital showed a general increasing trend from early 2019 through mid-2020, peaking at 9,458 million US dollars as of June 30, 2020. This peak was followed by a consistent decline throughout the remainder of 2020 and into 2021, bottoming near 3,782 million US dollars by June 30, 2021. Afterward, working capital remained relatively stable at lower levels with minor fluctuations, ending at 2,769 million US dollars as of March 31, 2023, substantially below the mid-2020 peak.
- Net Revenue
- Net revenue initially increased steadily throughout 2019, reaching a plateau towards the end of the year. It then experienced a downturn in the first half of 2020, likely influenced by external economic conditions. Starting from the third quarter of 2020, net revenue resumed an upward trajectory, surpassing previous highs and peaking in the fourth quarter of 2021 at 5,216 million US dollars. Thereafter, net revenue remained relatively elevated and stable, with only slight decreases, concluding the period with 5,748 million US dollars at the end of the first quarter of 2023.
- Working Capital Turnover
- This ratio exhibited marked variability. From 2019 into early 2020, the turnover ratio declined, reflecting a reduction in net revenue relative to working capital. The ratio reached its lowest point in mid-2020 at approximately 1.72, corresponding with the peak in working capital and trough in revenue. Subsequently, the ratio progressively increased, indicating improved efficiency in utilizing working capital to generate revenue. This increase was particularly pronounced from mid-2021 onward, reaching a significant high of 9.13 by December 31, 2022. Although the ratio slightly declined to 8.24 by March 31, 2023, it remained elevated, signaling enhanced operational efficiency compared to earlier periods.
Overall, the data indicates that despite fluctuations in working capital and net revenue, Mastercard Inc. has improved its working capital utilization efficiency significantly since mid-2020. The inverse relationship observed between working capital and its turnover ratio suggests strategic adjustments in asset management, contributing to a more effective generation of revenue relative to working capital levels.
Average Receivable Collection Period
Mastercard Inc., average receivable collection period calculation (quarterly data)
| 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 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||
| Receivables turnover | 18.46 | 17.51 | 21.23 | 19.63 | 18.07 | 14.32 | 20.66 | 17.76 | 9.21 | 8.97 | 11.34 | 9.10 | 14.61 | 5.64 | 5.98 | 10.14 | 10.70 | ||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||
| Average receivable collection period1 | 20 | 21 | 17 | 19 | 20 | 25 | 18 | 21 | 40 | 41 | 32 | 40 | 25 | 65 | 61 | 36 | 34 | ||||||
| Benchmarks (no. days) | |||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||
| Adobe Inc. | 37 | 43 | 37 | 35 | 38 | 43 | 37 | 37 | 41 | 40 | 39 | 41 | 43 | — | — | — | — | ||||||
| AppLovin Corp. | 80 | 91 | 84 | 86 | 89 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Cadence Design Systems Inc. | 48 | 50 | 42 | 44 | 42 | 41 | 40 | 49 | 51 | — | — | — | — | — | — | — | — | ||||||
| CrowdStrike Holdings Inc. | 82 | 93 | 80 | 85 | 77 | 100 | 83 | 83 | 93 | — | — | — | — | — | — | — | — | ||||||
| Datadog Inc. | 75 | 87 | 83 | 82 | 84 | 95 | 93 | 90 | 84 | — | — | — | — | — | — | — | — | ||||||
| International Business Machines Corp. | 35 | 39 | 33 | 36 | 37 | 43 | 40 | 38 | 34 | — | — | — | — | — | — | — | — | ||||||
| Intuit Inc. | 11 | 13 | 21 | 28 | 15 | 15 | 23 | 22 | 5 | — | — | — | — | — | — | — | — | ||||||
| Microsoft Corp. | 56 | 81 | 62 | 66 | 57 | 83 | 60 | 65 | 57 | — | — | — | — | — | — | — | — | ||||||
| Oracle Corp. | 49 | 51 | 40 | 39 | 40 | 49 | 43 | 41 | 43 | — | — | — | — | — | — | — | — | ||||||
| Palantir Technologies Inc. | 47 | 49 | 68 | 56 | 57 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Palo Alto Networks Inc. | 78 | 142 | 88 | 72 | 65 | 106 | 70 | 65 | 69 | — | — | — | — | — | — | — | — | ||||||
| Salesforce Inc. | 52 | 134 | 59 | 63 | 52 | 134 | 60 | 65 | 62 | — | — | — | — | — | — | — | — | ||||||
| ServiceNow Inc. | 53 | 87 | 47 | 47 | 48 | 86 | 51 | 55 | 49 | — | — | — | — | — | — | — | — | ||||||
| Synopsys Inc. | 73 | 57 | 50 | 55 | 84 | 49 | 52 | 56 | 75 | 77 | 66 | 68 | 86 | — | — | — | — | ||||||
| Workday Inc. | 53 | 88 | 65 | 68 | 53 | 87 | 65 | 63 | 56 | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q1 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 18.46 = 20
2 Click competitor name to see calculations.
- Receivables Turnover Ratio
- The receivables turnover ratio exhibited considerable fluctuations over the observed periods. Initially, it showed a gradual decline from 10.7 in March 2019 to a low of 5.64 by December 2019, indicating slower collection of receivables during this timeframe. In the subsequent quarters of 2020, the ratio experienced volatility, peaking at 14.61 in March 2020 before declining again. From 2021 onwards, the ratio generally increased, reaching a peak of 21.23 in the third quarter of 2022, which reflects an improvement in efficiency regarding receivables collection. However, by March 2023, it slightly decreased to 18.46, suggesting a minor easing in turnover speed but still remaining at a relatively high level compared to earlier periods.
- Average Receivable Collection Period
- The average receivable collection period inversely mirrored the trends observed in the receivables turnover ratio. It started at 34 days in March 2019 and gradually increased to 65 days by December 2019, pointing to a lengthening of the time taken to collect receivables. In early 2020, this period shortened to 25 days but then exhibited some fluctuations, staying mostly within the range of 17 to 41 days through 2020 and 2021. Notably, the collection period reached its shortest intervals in mid to late 2021, with values as low as 18 days in September 2021. During 2022 and into early 2023, the collection period stabilized around 17 to 21 days, indicating a more consistent and efficient receivables management process compared to the earlier years.
- Insights and Summary
- Over the full span of the periods reviewed, receivables management showed marked improvement, transitioning from longer collection periods and lower turnover ratios to more efficient collections characterized by higher turnover ratios and shortened average collection periods. The volatility early in the timeline could be attributed to operational or market factors affecting payment behavior, while the consistent improvements in recent periods suggest effective management strategies or improved customer payment patterns. The stabilization seen in the last several quarters points toward a mature receivables process with relatively predictable cash conversion timings.
Average Payables Payment Period
Mastercard Inc., average payables payment period calculation (quarterly data)
| 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 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||
| Payables turnover | 26.23 | 20.02 | 20.53 | 31.05 | 36.37 | 20.68 | 35.86 | 29.24 | 11.91 | 10.37 | 13.81 | 10.63 | 14.80 | 6.22 | 7.54 | 11.81 | 12.83 | ||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||
| Average payables payment period1 | 14 | 18 | 18 | 12 | 10 | 18 | 10 | 12 | 31 | 35 | 26 | 34 | 25 | 59 | 48 | 31 | 28 | ||||||
| Benchmarks (no. days) | |||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||
| Accenture PLC | 21 | 22 | 22 | 21 | 22 | 24 | 22 | 20 | 18 | — | — | — | — | — | — | — | — | ||||||
| Adobe Inc. | 51 | 64 | 55 | 66 | 56 | 61 | 68 | 65 | 54 | 65 | 48 | 61 | 56 | — | — | — | — | ||||||
| AppLovin Corp. | 84 | 79 | 83 | 94 | 129 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| CrowdStrike Holdings Inc. | 9 | 45 | 8 | 24 | 5 | 19 | 13 | 20 | 15 | — | — | — | — | — | — | — | — | ||||||
| Datadog Inc. | 41 | 25 | 32 | 61 | 26 | 39 | 61 | 60 | 29 | — | — | — | — | — | — | — | — | ||||||
| International Business Machines Corp. | 49 | 53 | 50 | 49 | 47 | 56 | 54 | 49 | 44 | — | — | — | — | — | — | — | — | ||||||
| Intuit Inc. | 92 | 112 | 145 | 158 | 105 | 135 | 142 | 129 | 70 | — | — | — | — | — | — | — | — | ||||||
| Microsoft Corp. | 94 | 111 | 98 | 97 | 99 | 106 | 97 | 96 | 98 | — | — | — | — | — | — | — | — | ||||||
| Oracle Corp. | 54 | 54 | 48 | 45 | 34 | 35 | 38 | 34 | 25 | — | — | — | — | — | — | — | — | ||||||
| Palantir Technologies Inc. | 4 | 40 | 55 | 56 | 28 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Palo Alto Networks Inc. | 26 | 27 | 25 | 30 | 25 | 16 | 22 | 14 | 17 | — | — | — | — | — | — | — | — | ||||||
| ServiceNow Inc. | 51 | 64 | 46 | 65 | 43 | 24 | 19 | 31 | 37 | — | — | — | — | — | — | — | — | ||||||
| Workday Inc. | 30 | 14 | 13 | 15 | 14 | 23 | 17 | 18 | 11 | — | — | — | — | — | — | — | — | ||||||
Based on: 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), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q1 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 26.23 = 14
2 Click competitor name to see calculations.
The payables turnover ratio and the average payables payment period demonstrate notable fluctuations over the observed quarters, indicating variability in the company's payment management strategy and supplier relationship dynamics.
- Payables Turnover Ratio
- This ratio exhibits a cyclical pattern with marked peaks and troughs. From early 2019 through the end of that year, the ratio declined from 12.83 to 6.22, suggesting a slower rate of paying off suppliers during that period. The first quarter of 2020 shows a strong rebound to 14.8, followed by some volatility throughout 2020 with values ranging between approximately 10 and 14.
- In 2021, the ratio rises significantly, peaking at 35.86 in the third quarter, indicating accelerated payments to suppliers. However, this is followed by a decrease to 20.68 by the year's end. Similarly, 2022 shows substantial variability with the ratio swinging between 20 and 36, and the first quarter of 2023 maintains a relatively high turnover of 26.23, suggesting continued active payables management.
- Average Payables Payment Period (number of days)
- The average payment period inversely correlates with the payables turnover ratio, reflecting changes in payment speed. Initially, in early 2019, the period lengthened from 28 to 59 days by the end of the year, consistent with lower turnover ratios in that timeframe.
- In early 2020, the payment period shortens sharply to 25 days, aligning with the increase in the turnover ratio, then fluctuates moderately within the 25 to 35 day range for the remainder of 2020. In 2021, the payment period drops dramatically to a low of 10 days in the third quarter, aligning with the peak turnover ratio, before rising slightly towards the end of the year.
- During 2022, the payment period remains relatively short, generally between 10 and 18 days, indicating a maintained tendency for quicker payments. The first quarter of 2023 shows a further reduction to 14 days, suggesting an emphasis on prompt settlement of payables.
Overall, the data reveal an emphasis on accelerated payment cycles starting around 2021, as evidenced by the increase in payables turnover and corresponding decreases in payment periods. This could reflect strategic changes in supplier negotiation terms or an improved liquidity position allowing for faster payments. The variability across quarters also suggests responsiveness to operational or external factors affecting cash flow management.