NiSource Inc (NI)

Receivables turnover

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
Revenue (ttm) US$ in thousands 9,150,200 4,601,300 4,552,400 4,557,700 4,817,400 5,278,400 5,340,500 5,433,700 5,341,000 5,038,000 4,907,900 4,710,700 4,383,000 3,824,700 3,767,800 3,744,500 3,804,400 5,272,200 5,301,200 5,348,900
Receivables US$ in thousands 964,200 572,000 624,000 845,600 862,000 569,600 603,600 922,800 1,041,900 586,700 714,600 961,100 825,600 526,800 563,700 794,500 1,129,600 521,400 545,700 716,500
Receivables turnover 9.49 8.04 7.30 5.39 5.59 9.27 8.85 5.89 5.13 8.59 6.87 4.90 5.31 7.26 6.68 4.71 3.37 10.11 9.71 7.47

December 31, 2024 calculation

Receivables turnover = Revenue (ttm) ÷ Receivables
= $9,150,200K ÷ $964,200K
= 9.49

The receivables turnover for NiSource Inc has fluctuated over the past few years. It stood at 7.47 on March 31, 2020, indicating that the company collected its accounts receivable approximately 7.47 times during that period. The turnover increased to 10.11 by September 30, 2020, reflecting a more efficient collection of receivables.

However, the ratio dropped significantly to 3.37 by December 31, 2020, suggesting a slowdown in receivables turnover. The trend continued with a further decline to 4.71 by March 31, 2021, and 5.31 by December 31, 2021.

There was a slight improvement in receivables turnover during the following quarters, with ratios ranging from 6.68 to 8.85 by June 30, 2021, and June 30, 2023, respectively. The turnover then decreased slightly to 7.30 by June 30, 2024.

Overall, NiSource Inc's receivables turnover has displayed some variability, indicating changes in the company's ability to collect on credit sales efficiently. The management may need to further analyze the reasons behind these fluctuations and implement strategies to maintain a consistent and optimal level of receivables turnover.