• Preview of Working Capital and Cash Conversion Cycle CalculatorExcel workbook preview

Financial Projections, Startup Costs and Funding

Working Capital and Cash Conversion Cycle Calculator

$17.99 Free XLSX
Excel workbook · 13 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

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.