Middlesex Water Company (MSEX)

Number of days of payables

		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
Payables turnover		4.20	1.77	1.78	1.78	1.95	1.74	1.81	2.40	2.04	2.33	1.76	1.66	1.33	1.54	1.67	1.57	1.62	1.79	2.01	2.60
Number of days of payables	days	86.87	205.72	205.52	204.74	187.62	209.98	201.62	151.88	178.67	156.47	207.64	219.65	275.20	236.58	218.81	232.69	225.65	203.73	181.78	140.54

December 31, 2023 calculation

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

To analyze Middlesex Water Co.'s number of days of payables, we would need specific data on accounts payable and cost of goods sold for each quarter. Without this information, it is not possible to calculate the number of days of payables. The number of days of payables ratio provides insight into how long on average it takes a company to pay its suppliers. A decreasing number of days of payables may indicate improved efficiency in managing payables, while an increasing number of days may suggest liquidity issues or potential strain on relationships with suppliers. Monitoring this ratio over time can help in assessing the company's financial health and operational efficiency.