Comcast Corp (CMCSA)
Cash conversion cycle
| 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 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Days of inventory on hand (DOH) | days | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| Days of sales outstanding (DSO) | days | 40.63 | 41.97 | 40.01 | 39.67 | 41.47 | 38.76 | 39.28 | 37.34 | 38.09 | 35.89 | 35.87 | 37.35 | 37.66 | 38.42 | 37.21 | 38.50 | 40.41 | 36.10 | 35.37 | 36.27 |
| Number of days of payables | days | 271.58 | 290.99 | 300.10 | 298.92 | 313.65 | 305.08 | 191.26 | 189.98 | 196.62 | 174.58 | 233.64 | 220.96 | 201.35 | 199.96 | 200.01 | 196.95 | 199.41 | 190.40 | 179.01 | 166.90 |
| Cash conversion cycle | days | -230.96 | -249.02 | -260.09 | -259.25 | -272.18 | -266.32 | -151.98 | -152.65 | -158.53 | -138.70 | -197.77 | -183.61 | -163.69 | -161.54 | -162.81 | -158.45 | -159.00 | -154.30 | -143.64 | -130.63 |
December 31, 2024 calculation
Cash conversion cycle = DOH + DSO – Number of days of payables
= — + 40.63 – 271.58
= -230.96
The cash conversion cycle of Comcast Corp has exhibited fluctuations over the years based on the provided data. The negative values indicate that Comcast is efficiently managing its cash flows as it takes fewer days to convert its inventory into cash.
From March 31, 2020, to June 30, 2022, the cash conversion cycle remained relatively stable, ranging between -130.63 days to -197.77 days. This consistency suggests that Comcast has been effectively managing its working capital during this period.
However, a significant increase in the cash conversion cycle was observed in the latter part of the data available. From September 30, 2022, to December 31, 2024, the cash conversion cycle showed more volatility, with values fluctuating between -138.70 days to -272.18 days.
The drastic drop in the cash conversion cycle towards the end of the data may indicate a more aggressive approach to managing working capital, potentially involving a reduction in inventory and/or accounts receivable levels to free up cash.
Overall, it is essential for Comcast to closely monitor its cash conversion cycle to ensure optimal management of working capital and continued efficiency in converting inventory and receivables into cash.
Peer comparison
Dec 31, 2024