-
Excel workbook preview
Financial Projections, Startup Costs and Funding
Working Capital and Cash Conversion Cycle Calculator
3 downloads per free account, no card needed.
Who this is for
An owner whose profitable business is short of cash needs to see how many days of cash sit in debtors and stock, and what fixing it would release.
What is inside
- Debtor, stock and creditor days on average balances, against your targets
- Cash conversion cycle (DIO + DSO - DPO) with green, amber and red
- Working capital, trade working capital, current ratio and quick ratio
- Cash released if each target is met, and the value of one day
- 12-month trend of DSO, DIO, DPO and the cycle
- Line chart of the cycle by month
How to use it: Replace the wholesaler example on the Inputs sheet (year figures, balances, targets, monthly balances); read the Calculator and Monthly trend sheets.
Files & formats
- XLSXworking-capital-and-cash-conversion-cycle-calculator.xlsx13 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.



