Comcast Corp (CMCSA)

Activity ratios

Short-term

Turnover ratios

	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
Inventory turnover	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—
Receivables turnover	8.98	8.70	9.12	9.20	8.80	9.42	9.29	9.78	9.58	10.17	10.18	9.77	9.69	9.50	9.81	9.48	9.03	10.11	10.32	10.06
Payables turnover	1.34	1.25	1.22	1.22	1.16	1.20	1.91	1.92	1.86	2.09	1.56	1.65	1.81	1.83	1.82	1.85	1.83	1.92	2.04	2.19
Working capital turnover	—	—	—	—	—	—	—	—	—	—	—	—	—	165.10	—	—	—	—	—	—

Based on the data provided, let's analyze Comcast Corp's activity ratios:

1. Inventory Turnover: The inventory turnover ratio for Comcast Corp is not available for the given periods, as indicated by "—". This suggests that inventory turnover information is not disclosed or may not be applicable for this company.

2. Receivables Turnover: The receivables turnover ratio measures how well a company efficiently collects its outstanding accounts receivable during a specific period. Comcast Corp's receivables turnover ratio ranges from 8.70 to 10.32 over the periods provided. A higher turnover ratio indicates that the company is collecting its accounts receivable more frequently, which is positive for cash flow.

3. Payables Turnover: The payables turnover ratio reflects how quickly a company pays its suppliers. Comcast Corp's payables turnover ratio ranges from 1.16 to 2.09 over the periods given. A higher turnover ratio suggests that the company is paying its suppliers more frequently, which could indicate good relationships with suppliers or efficient working capital management.

4. Working Capital Turnover: The working capital turnover ratio measures how efficiently a company utilizes its working capital to generate sales revenue. Comcast Corp's working capital turnover ratio is provided only for September 30, 2021, at 165.10. A higher turnover ratio indicates that the company is effectively using its working capital to generate sales.

Overall, analyzing these activity ratios can provide insights into how well Comcast Corp manages its inventory, accounts receivable, accounts payable, and working capital to support its operations and financial performance over time.

Average number of days

		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

Based on the data provided, Comcast Corp's activity ratios can be analyzed as follows:

1. Days of Sales Outstanding (DSO):
- DSO represents the average number of days it takes for Comcast to collect revenue after a sale.
- The trend indicates that Comcast's DSO has been relatively stable, ranging between 35 to 41 days over the past few years.
- A low DSO figure can indicate efficient credit management and timely collections from customers.

2. Days of Inventory on Hand (DOH):
- Unfortunately, detailed data on Comcast's DOH is not available in the provided information.
- However, a lower DOH usually implies efficient inventory management and faster turnover of inventory, which can lead to cost savings and improved cash flow.

3. Number of Days of Payables:
- This ratio measures the average number of days Comcast takes to pay its suppliers.
- Comcast's payables period has shown some fluctuation, ranging from around 166 to 313 days over the observed periods.
- A longer payables period can indicate that Comcast is taking longer to pay its suppliers, potentially improving cash flow but also possibly straining supplier relationships.

In conclusion, while the DSO and payables period provide insights into Comcast's efficiency in managing receivables and payables, the lack of data on DOH limits a comprehensive assessment of Comcast's overall activity efficiency.

Long-term

	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
Fixed asset turnover	1.96	1.98	1.99	2.02	2.04	2.08	2.12	2.13	2.19	2.26	2.27	2.23	2.16	2.15	2.07	1.99	1.99	2.07	2.15	2.24
Total asset turnover	0.46	0.45	0.46	0.46	0.46	0.46	0.46	0.46	0.47	0.48	0.46	0.44	0.42	0.41	0.39	0.37	0.38	0.39	0.40	0.41

Comcast Corp's long-term activity ratios, specifically the fixed asset turnover and total asset turnover, provide insights into the efficiency of the company in generating revenue from its assets over time.

The fixed asset turnover ratio, which measures how effectively the company is utilizing its fixed assets to generate sales, shows a declining trend from March 31, 2020, to December 31, 2024, fluctuating between 1.96 and 2.27. This indicates that Comcast Corp's ability to generate revenue from its fixed assets has somewhat decreased over time. A possible explanation for this trend could be an increase in fixed assets without a proportional increase in revenue generation.

On the other hand, the total asset turnover ratio, reflecting the company's efficiency in generating sales from all assets, shows a relatively stable trend between 0.37 and 0.48 during the same period. This suggests that Comcast Corp has been able to maintain a consistent level of revenue generation relative to its total assets, despite fluctuations in the fixed asset turnover ratio.

Overall, while the fixed asset turnover ratio for Comcast Corp has shown a decreasing trend over time, the total asset turnover ratio has remained relatively stable. This indicates the need for the company to potentially re-evaluate its fixed asset utilization strategies to improve efficiency in revenue generation from its fixed assets.