Comcast Corp (CMCSA)
Cash conversion cycle
| 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 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Days of inventory on hand (DOH) | days | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| Days of sales outstanding (DSO) | days | 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 | 37.83 | 35.98 | 38.14 | 39.75 |
| Number of days of payables | days | 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 | 181.64 | 164.72 | 168.09 | 179.87 |
| Cash conversion cycle | days | -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 | -143.81 | -128.74 | -129.95 | -140.12 |
December 31, 2023 calculation
Cash conversion cycle = DOH + DSO – Number of days of payables
= — + 41.47 – 313.65
= -272.18
To analyze Comcast Corp's cash conversion cycle, we can observe the trend over the past eight quarters. The cash conversion cycle measures the time it takes for a company to convert its investments in inventory and other resources into cash flow from sales. A shorter cash conversion cycle indicates a more efficient process of selling inventory and collecting cash.
We can see that Comcast's cash conversion cycle has been fluctuating over the past eight quarters, ranging from 35.89 days to 41.47 days. Generally, the trend has shown a slight increase in the cash conversion cycle, indicating a potential slowdown in the company's ability to convert its investments into cash.
It's worth noting that a rising cash conversion cycle could suggest challenges in managing inventory, collecting receivables, or paying suppliers. Companies aim to optimize their cash conversion cycle to improve liquidity and overall financial performance. Therefore, Comcast may need to focus on improving its working capital management to shorten its cash conversion cycle and enhance its cash flow efficiency.
Peer comparison
Dec 31, 2023