Comcast Corp (CMCSA)

Fixed asset turnover

		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
Revenue (ttm)	US$ in thousands	121,572,000	120,872,000	120,606,000	120,109,000	121,428,000	121,211,000	121,660,000	120,190,000	116,385,000	113,757,000	108,991,000	104,160,000	103,564,000	104,254,000	105,549,000	108,692,000	108,942,000	108,390,000	103,698,000	98,575,000
Property, plant and equipment	US$ in thousands	59,686,000	58,165,000	56,851,000	56,279,000	55,485,000	53,555,000	53,508,000	53,820,000	54,000,000	52,809,000	52,769,000	52,317,000	51,995,000	50,466,000	48,985,000	48,442,000	48,322,000	46,790,000	46,047,000	45,721,000
Fixed asset turnover		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	2.25	2.32	2.25	2.16

December 31, 2023 calculation

Fixed asset turnover = Revenue (ttm) ÷ Property, plant and equipment
= $121,572,000K ÷ $59,686,000K
= 2.04

The fixed asset turnover ratio for Comcast Corp has shown a consistent downward trend from March 31, 2022, with a value of 2.27, to December 31, 2023, with a value of 2.04. This trend indicates a declining efficiency in generating sales from fixed assets. While the ratio remained relatively stable from September 30, 2022, to March 31, 2023, it experienced a more notable decrease in the subsequent periods.

A fixed asset turnover ratio of less than 1 suggests that the company is not effectively utilizing its fixed assets to generate revenue. In Comcast's case, all the values provided are well above 1, indicating that the company is efficiently utilizing its fixed assets to generate sales.

However, the decreasing trend in the ratio may indicate a declining sales performance relative to the investment in fixed assets, which could be a concern. It is important for the company to monitor this trend and take necessary steps to improve the efficiency of its fixed asset utilization to drive revenue growth.