← All prebuilt solutions
Planning & Finance

Working Capital Calculator

See how much cash is tied up in your business – and how to release it

£20

Secure checkout. Your download link is sent as soon as payment clears.

Working Capital Calculator

Overview

Working capital is the cash a business needs to keep running day to day: money owed by customers (debtors) plus stock, less money you owe suppliers (creditors). Profitable, growing businesses often run short of cash because more and more of it gets tied up in unpaid invoices and stock. This workbook turns 24 months of figures from your management accounts into the measures banks and advisers use – debtor days, stock days, creditor days and the cash conversion cycle – and then shows how much cash you could release, how you compare with your sector, whether you are at risk of overtrading and whether your facility will cover the growth you are planning.

Price
£20
Who it’s for
Planning & Finance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Monthly Data

The 24 months of figures everything else is built on. What you do: enter one row per month, oldest first, with no gaps.

Monthly Data
Ratios

Step 2

Ratios

Days, cash conversion cycle, working capital, headroom and cash tied up vs target for every month. What you do: nothing – read it. The month being analysed is highlighted.

Step 3

Cash Release

The £ value of collecting faster, holding less stock and paying later. What you do: type the number of days for each lever.

Cash Release
Benchmarks

Step 4

Benchmarks

Sector benchmark days and how you compare. What you do: edit the sector figures if you have better data.

Who it is for

Made for people like you

  • Example – text
  • Owners and directors – A clear view of where cash is tied up and the three levers that release it.
  • Finance managers and bookkeepers – Monthly ratios on a consistent basis, ready for board packs and bank reviews.
  • Growing businesses – An early warning of overtrading and a 12-month funding gap forecast for planned growth.
  • Advisers and lenders – A structured way to discuss credit terms, stock levels and facility needs.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter your business name and the first of your 24 months. Choose the days basis (Rolling 3 months suits most businesses), whether your ledger balances include VAT, your target debtor, stock and creditor days, your overdraft or facility limit and interest rate, and your sector.
  2. Monthly Data – For each month enter revenue, cost of sales and purchases for the month (all excluding VAT), then the month-end balances for trade debtors, stock, trade creditors, cash and overdraft. Your management accounts or bookkeeping software will give you all of these.
  3. Read the Dashboard – The cash conversion cycle, working capital, cash tied up beyond your targets, facility headroom, overtrading status and your growth funding gap.
  4. Try the levers – On Cash Release, type how many days faster you could collect, how many fewer days of stock you could hold and how many days later you could pay. The cash released and interest saved appear at once.
  5. Check your sector – On Benchmarks, replace the illustrative sector figures with real ones from your trade body or bank if you have them.
  6. Plan growth – On Growth Funding, enter your planned growth and any changes to your days. The sheet shows how much extra working capital you need and whether your facility covers it.

Key features

  • Debtor days, stock days, creditor days and the cash conversion cycle month by month from 24 months of figures.
  • Working capital requirement and % of sales, cash tied up against your target days and sector benchmarks.
  • Cash release levers – collect faster, hold less stock, pay later – with the £ impact and interest saved.
  • Overtrading warning and a 12-month growth funding forecast showing whether your facility will cover planned growth.

What’s included

  • Dashboard – Working capital at a glance
  • Settings – Targets, facility and options
  • Monthly Data – 24 months of figures
  • Ratios – Days, cycle and working capital
  • Cash Release – What-if levers
  • Benchmarks – You vs your sector
  • Overtrading – Growth vs cash warning
  • Growth Funding – Funding gap for planned growth
  • Trends – Trend charts
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions