Lumen Technologies Inc (LUMN)
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 | 56.12 | 51.88 | 49.64 | 43.93 | 37.78 | 31.86 | 36.01 | 34.53 | 33.34 | 45.41 | 54.83 | 65.13 | 88.42 | 83.82 | 76.47 | 88.35 | 85.09 | 82.36 | 78.51 | 82.29 |
| Receivables turnover | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| Payables turnover | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| Working capital turnover | 17.36 | 16.70 | — | — | 11.73 | 20.44 | 17.13 | 29.69 | 28.33 | 27.77 | 3.17 | 3.16 | 4.51 | 5.87 | — | — | — | — | — | — |
Lumen Technologies Inc's inventory turnover ratio has fluctuated over the years, indicating the efficiency of the company in managing its inventory levels. The ratio was highest in December 2021 and gradually decreased until December 2024. This may suggest potential issues with inventory management or changes in sales patterns.
Regarding receivables turnover, payables turnover, and working capital turnover ratios, the data provided show that these ratios were not available for analysis as they were marked as "—." This lack of information hinders a comprehensive assessment of the company's efficiency in collecting receivables, managing payables, and utilizing working capital.
In summary, Lumen Technologies Inc's inventory turnover has shown volatility, while the absence of data for receivables turnover, payables turnover, and working capital turnover limits the depth of analysis in these areas. Additional information or context would be needed to provide a more detailed assessment of the company's activity ratios.
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 | 6.50 | 7.03 | 7.35 | 8.31 | 9.66 | 11.46 | 10.14 | 10.57 | 10.95 | 8.04 | 6.66 | 5.60 | 4.13 | 4.35 | 4.77 | 4.13 | 4.29 | 4.43 | 4.65 | 4.44 |
| Days of sales outstanding (DSO) | days | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| Number of days of payables | days | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
Based on the provided data for Lumen Technologies Inc, we can analyze the activity ratios as follows:
1. Days of Inventory on Hand (DOH):
- The Days of Inventory on Hand represents the number of days it takes for a company to sell its entire inventory.
- Lumen Technologies Inc's DOH has fluctuated over the years, ranging from a low of 4.13 days in December 31, 2021, to a high of 11.46 days in September 30, 2023.
- The increasing trend in DOH from March 31, 2022, to December 31, 2024, indicates that the company is holding inventory for a longer period, which may tie up working capital and increase carrying costs.
2. Days of Sales Outstanding (DSO):
- The Days of Sales Outstanding shows the average number of days it takes for a company to collect payments from its customers.
- The data provided does not include information on DSO for Lumen Technologies Inc, which suggests that the company's accounts receivable turnover was not provided or may not have been calculated.
3. Number of Days of Payables:
- The Number of Days of Payables indicates the average number of days a company takes to pay its suppliers.
- Similar to DSO, the data provided does not include information on the Number of Days of Payables for Lumen Technologies Inc, which limits our ability to assess the company's efficiency in managing its payables.
Overall, while the Days of Inventory on Hand ratio provides insight into Lumen Technologies Inc's inventory management efficiency, the absence of DSO and Payables information hinders a comprehensive analysis of the company's overall activity and liquidity management performance. It would be beneficial to have additional data on these ratios to get a more complete picture of the company's operational effectiveness.
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 | — | — | — | — | — | 0.76 | 0.80 | 0.86 | 0.91 | 0.89 | 0.92 | 0.93 | 0.94 | 0.95 | 0.78 | 0.79 | 0.79 | 0.80 | 0.83 | 0.85 |
| Total asset turnover | 0.39 | 0.39 | 0.42 | 0.43 | 0.43 | 0.41 | 0.43 | 0.36 | 0.38 | 0.34 | 0.33 | 0.33 | 0.34 | 0.34 | 0.34 | 0.35 | 0.35 | 0.34 | 0.34 | 0.34 |
Based on the provided data, we can analyze the long-term activity ratios of Lumen Technologies Inc using the fixed asset turnover and total asset turnover ratios.
1. Fixed Asset Turnover Ratio: This ratio measures how efficiently the company is utilizing its fixed assets to generate sales. A declining trend in the fixed asset turnover ratio over time may indicate inefficiencies in asset utilization or a decrease in sales relative to fixed assets. In the case of Lumen Technologies Inc, the fixed asset turnover ratio has generally decreased from 0.85 in March 2020 to 0.80 in September 2023 before experiencing a slight recovery to 0.86 in March 2024. However, it is important to note that the data for December 31, 2023, and beyond is not available.
2. Total Asset Turnover Ratio: This ratio assesses the company's ability to generate sales revenue from its total assets. A higher total asset turnover ratio reflects effective asset utilization. In the case of Lumen Technologies Inc, the total asset turnover ratio has remained relatively stable around 0.34 to 0.38 from March 2020 to December 2022, with a notable increase to 0.43 by March 2023. This increase suggests that the company may have improved its efficiency in generating sales revenue relative to its total assets during this period.
Overall, while the fixed asset turnover ratio for Lumen Technologies Inc showed a declining trend over the years analyzed, the total asset turnover ratio displayed more stability with a notable improvement in certain periods. In interpreting these ratios, it is essential to consider the company's industry, business model, and strategic initiatives to gain a comprehensive understanding of its operational efficiency and asset utilization.