Duke Energy Corporation (DUK)

Activity ratios

Short-term

Turnover ratios

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
Inventory turnover 0.83 1.77 1.78 0.94 1.06 2.24 2.47 2.50 1.19 4.82 4.55 4.39 2.12 2.69 2.59 2.56 1.32 1.53 1.48 1.53
Receivables turnover 6.07 14.37 12.21 12.51 5.77 11.98 11.83 11.35 6.71 12.29 12.62 8.46 6.92 6.96 7.52 8.62 7.81 7.04 7.44 8.00
Payables turnover 1.68 2.07 2.26 2.27 1.60 1.87 2.00 2.50 2.15 4.84 5.05 5.41 4.27 3.45 3.56 3.59 2.46 1.61 1.88 1.87
Working capital turnover

The activity ratios of Duke Energy Corp. provide insight into the efficiency of the company's operations in managing its resources.

1. Inventory turnover: Duke Energy Corp.'s inventory turnover ratio has been relatively stable around 2.5 on average over the past eight quarters. This indicates that the company efficiently manages its inventory levels, with a moderate turnover rate. A consistent trend suggests that Duke Energy is effectively controlling its inventory levels and avoiding excess buildup of inventory.

2. Receivables turnover: Duke Energy Corp.'s receivables turnover ratio has shown a slight increase over the past two quarters. The ratio averages around 7.0, indicating that the company collects its accounts receivable approximately seven times a year. A higher receivables turnover ratio signifies that Duke Energy is efficient in collecting payments from customers, which indicates strong credit management practices.

3. Payables turnover: Duke Energy Corp.'s payables turnover ratio has exhibited some fluctuation over the past eight quarters, averaging around 2.5. The ratio indicates how quickly the company pays its suppliers. A higher payables turnover ratio suggests that Duke Energy efficiently manages its payments to suppliers, potentially benefiting from favorable credit terms.

4. Working capital turnover: There is no data provided for Duke Energy Corp.'s working capital turnover, making it challenging to assess the efficiency with which the company utilizes its working capital.

Overall, based on the activity ratios analyzed, Duke Energy Corp. appears to be efficiently managing its inventory, accounts receivable, and accounts payable to support its operations. Monitoring these ratios over time can help evaluate the company's operational efficiency and effectiveness in managing working capital.


Average number of days

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 439.93 205.65 204.89 387.03 344.21 162.80 147.79 145.81 307.68 75.65 80.24 83.06 172.34 135.83 140.70 142.77 275.53 239.00 246.35 238.46
Days of sales outstanding (DSO) days 60.15 25.40 29.90 29.17 63.26 30.46 30.84 32.17 54.41 29.70 28.92 43.15 52.71 52.44 48.52 42.33 46.76 51.85 49.03 45.64
Number of days of payables days 216.68 176.73 161.16 160.92 228.29 194.92 182.94 145.99 169.80 75.34 72.29 67.43 85.54 105.86 102.59 101.54 148.63 226.62 194.05 195.11

Activity ratios provide insights into how efficient a company is managing its resources. Let's analyze Duke Energy Corp.'s activity ratios based on the provided data:

1. Days of Inventory on Hand (DOH): Duke Energy Corp.'s DOH has shown an increasing trend over the last eight quarters, starting at 130.06 days in Q4 2022 and peaking at 161.85 days in Q4 2023. This indicates that Duke Energy is holding inventory for a longer period, which may tie up capital and could suggest potential inefficiencies in inventory management.

2. Days of Sales Outstanding (DSO): The DSO for Duke Energy Corp. has varied slightly over the quarters, ranging from 46.33 days in Q1 2023 to 56.02 days in Q4 2022. Lower DSO values generally indicate that the company is collecting revenue quickly, which is a positive sign for cash flow management.

3. Number of Days of Payables: Duke Energy Corp.'s days of payables have fluctuated over the quarters, with a notable decrease from 172.52 days in Q4 2022 to 112.42 days in Q1 2023. A lower number of days of payables means the company is taking less time to pay its suppliers, which could indicate efficient cash management or improved supplier relationships.

Overall, Duke Energy Corp. should focus on optimizing its inventory management to reduce the days of inventory on hand and continue to monitor its DSO and payables to ensure a balance between cash flow efficiency and supplier relationships.


Long-term

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
Fixed asset turnover 0.23 0.22 0.23 0.23 0.24 0.22 0.22 0.21 0.22 0.20 0.20 0.20 0.20 0.20 0.21 0.21 0.22 0.22 0.23 0.23
Total asset turnover 0.15 0.14 0.15 0.15 0.15 0.15 0.14 0.14 0.13 0.13 0.13 0.13 0.13 0.13 0.14 0.14 0.14 0.14 0.14 0.14

Duke Energy Corp.'s long-term activity ratios, specifically the fixed asset turnover and total asset turnover ratios, have remained relatively stable over the past eight quarters. The fixed asset turnover ratio has consistently ranged between 0.23 to 0.26, indicating that the company generates $0.23 to $0.26 in sales for every dollar invested in fixed assets. This suggests that Duke Energy is efficiently utilizing its fixed assets to generate revenue.

On the other hand, the total asset turnover ratio has consistently been around 0.16, showing that Duke Energy generates $0.16 in sales for every dollar of total assets. This ratio indicates that the company efficiently utilizes all its assets to generate revenue and is consistent over time.

Overall, both these ratios suggest that Duke Energy Corp. is effectively managing and utilizing its assets to generate sales, which is a positive indication of the company's operational efficiency.