How payables turnover works

Payables turnover asks how many times a year the payable account turns over:

$$\text{Payables turnover} = \frac{365}{DPO}$$

DPO of 30 days is $365 / 30 = 12.167$, which prints as 12.17 turns. The cash conversion cycle calculator on this page takes DPO as an input. Type the days, then invert.

That 30 subtracted from a 105 day operating cycle is a 75 day cash conversion cycle. How days payable outstanding works owns those days. This page owns 365 over DPO.

DPO against payables turnover is the same clock as a wait and as a turns figure.

DPO 100 is $365 / 100 = 3.65$ turns. Suppliers are paid about a third as often as at 12.17 turns. With DSO 30 and DIO 20 the operating cycle is 50 days. CCC is minus 50 days.

Fewer turns here means more supplier funding, not a collections win. Ranking payables turnover high to low ranks the firms that pay fastest, which is the opposite of ranking CCC low to high.

DPO 40 is $365 / 40 = 9.125$ turns. DSO 40, DIO 40. Operating cycle 80 days. CCC 40 days. The turns figure became 9.125 because DPO was 40.

Some ledgers use a 360 day year, which makes $360 / 30 = 12$ exactly. This page uses 365, so 30 days is 12.17, not 12. Mixing 365 on one firm and 360 on the next is a fake ranking.

DPO itself is usually payables over daily cost of goods, not over daily sales. Using sales mixes a selling price into a cost clock. Receivables turnover is the customer cousin, 365 over DSO, usually against sales.

3.65 turns on stretched terms can raise the price the supplier charges. The formula will still print a prettier CCC. The cash conversion explorer holds the first two clocks still and lets you drag DPO. Watch the residual fall, then ask what the extra days cost.

It is not a vendor-terms engine, not a 360 day table, and not a target of 12.17 turns. The three sheets are DPO 30 (12.17 turns, CCC 75), DPO 100 (3.65 turns, CCC minus 50), and DPO 40 (9.125 turns, CCC 40). This is educational material, not financial advice.