Cash today
$48,000
Cash in 13 weeks
$16,750
Lowest balance
$16,750
13-Week Cash Flow Forecast
Week-by-week cash in and out for the next quarter, with your lowest point, shortfalls and runway.
SpreadsheetCash Flow ManagementFree
Track DSO, DIO, DPO and the cash conversion cycle each month, and see how much cash each improvement would release.
Shown with sample data
Track DSO, DIO, DPO and the cash conversion cycle each month, and see how much cash each improvement would release.
Latest: 66.2
Growing companies often run out of cash while profitable because money is tied up in receivables and stock. Enter revenue, cost of sales and month-end receivables, inventory and payables; the sheet calculates days sales outstanding, days inventory outstanding, days payables outstanding and the cash conversion cycle for each period, compares them with targets, and puts a dollar value on collecting faster, holding less stock or paying suppliers on longer terms.
CCC = DSO + DIO − DPO. It is the number of days between paying suppliers and collecting cash from customers. Lower is better; some retailers run a negative CCC.
DSO = receivables ÷ revenue × days. DIO = inventory ÷ cost of sales × days. DPO = payables ÷ cost of sales × days. The days are the days in the period you used for revenue and cost of sales.
Compare it with your payment terms: with 30-day terms, a DSO of 35–40 is healthy. A DSO far above your terms means customers are paying late.
Download a copy
Downloads need a free account.