Middlesex Water Company (MSEX)

Number of days of payables

		Dec 31, 2023	Dec 31, 2022	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019
Payables turnover		4.20	1.95	2.04	1.33	1.62
Number of days of payables	days	86.87	187.62	178.66	275.21	225.65

December 31, 2023 calculation

Number of days of payables = 365 ÷ Payables turnover
= 365 ÷ 4.20
= 86.87

Unfortunately, without specific data for the number of days of payables for Middlesex Water Co. over the past five years, a detailed analysis cannot be provided in this scenario. However, in a typical analysis, the number of days of payables ratio is calculated by dividing accounts payable by cost of goods sold and then multiplying by the number of days in the period.

This ratio measures the average number of days a company takes to pay its suppliers. A lower number of days indicates that the company pays its suppliers more quickly, potentially signaling strong supplier relationships or efficient cash management. On the other hand, a higher number of days may suggest that the company is taking longer to pay its suppliers, potentially indicating potential cash flow issues or strained vendor relationships.

For a comprehensive analysis, it would be beneficial to obtain the specific data for Middlesex Water Co.'s number of days of payables over the stated periods to evaluate trends and assess the company's payment practices in more detail.