What it means
Averages hide risk. A business averaging $30,000 of net cash inflow a month sounds comfortable, but if individual months range from minus $10,000 to plus $70,000 it will still need an overdraft.
Fluctuation is measured with the same tools used for any variable data, most commonly the standard deviation of monthly net cash flow. The causes fall into predictable and unpredictable groups.
Predictable fluctuation comes from seasonality, quarterly tax payments, annual insurance renewals and payroll cycles, all of which can be mapped in advance. Unpredictable fluctuation comes from customers paying late, orders arriving in lumps, equipment failures and price shocks.
Translating fluctuation into a buffer is the practical step. A common approach is to hold cash or a facility covering the average outflow plus one or two standard deviations of the monthly swing, which covers the large majority of bad months.
That converts a statistical measure into a specific overdraft size or minimum balance policy. The coefficient of variation is useful when comparing businesses or divisions of different sizes.
It divides the standard deviation by the average, giving a relative measure, so a small unit swinging by $20,000 around a $25,000 average is correctly identified as more volatile than a large unit swinging by $80,000 around a $400,000 average. Anything approaching or above 1.0 signals genuinely unstable cash flow.
Fluctuation can also be reduced rather than merely funded. Subscription pricing, deposits, retainers, direct debit collection, staged invoicing and supplier terms that mirror customer terms all smooth the pattern.
Many businesses find that cutting the size of the swings is cheaper than borrowing to survive them.
In practice
Real-world examples.
Example
A ski equipment retailer sees net cash flow swing from plus $400,000 in December to minus $180,000 in June. It arranges a seasonal facility sized to the June trough rather than to the annual average, which is close to zero.
Example
A civil engineering contractor with three large clients experiences swings driven entirely by certification dates. Moving two clients to monthly interim applications cuts its standard deviation by roughly a third without changing total revenue.
Example
A veterinary practice group compares two clinics with similar profits and finds one has a coefficient of variation of 0.3 and the other 1.1. The volatile clinic is put on weekly cash reporting and given a larger minimum balance.
Think of it
“Cash flow fluctuation is the ups and downs in your cash flow-how much it varies over time.
Formula
Calculation
Standard deviation of net monthly cash flow = the square root of the average squared difference between each month's net cash flow and the mean. Coefficient of variation = Standard deviation / Mean.
A design agency records six months of net cash flow: $20,000, $60,000, -$10,000, $40,000, $0 and $70,000.
Total = $180,000, so the mean is $180,000 / 6 = $30,000 a month.
Differences from the mean are -$10,000, $30,000, -$40,000, $10,000, -$30,000 and $40,000. Squaring and adding them gives 5,200,000,000, and dividing by six gives 866,666,667. The square root of that is approximately $29,400.
Coefficient of variation = $29,400 / $30,000 = 0.98. The typical monthly swing is almost as large as the average month itself, so the agency sets its overdraft at roughly two standard deviations, about $60,000, rather than relying on the comfortable-looking $30,000 average.Case study
Seen in the real world.
Fernwood Print Co is an illustrative and entirely fictional commercial printer. Its owner tracked only the annual figure, which showed a healthy $420,000 of net cash generated, and was repeatedly caught out by months when payroll was difficult to meet.
Plotting 24 months of net cash flow revealed a mean of $35,000 with a standard deviation of about $52,000, giving a coefficient of variation near 1.5. The swings came from a handful of large publishing clients who ordered in bursts and paid in 75 days, while paper suppliers demanded payment in 21 days.
In this fictional case the company introduced 30% deposits on runs above $50,000, negotiated 45-day paper terms and added a small retainer-based reprographics service. Within a year the standard deviation had fallen to about $24,000 while the mean was broadly unchanged, and the overdraft was rarely used.
Watch out
Common mistakes.
- Planning around average monthly cash flow while ignoring the size of the swings, which is how profitable businesses end up missing payroll.
- Assuming all fluctuation is unpredictable, when seasonality, tax dates and annual renewals can be mapped a year ahead.
- Comparing the raw standard deviation of two businesses of very different sizes instead of using the coefficient of variation.
Questions
People also ask.
How many months of history are needed?
At least 12 to capture seasonality, and 24 months if the business has been growing quickly or changed its customer mix.
Does high fluctuation always mean high risk?
Not if the business holds enough cash or committed facilities to cover the troughs, since the risk is a funding gap rather than the variation itself.
What is the cheapest way to reduce fluctuation?
Changing payment patterns, through deposits, direct debits, retainers and staged invoicing, usually costs far less than carrying a large permanent cash buffer.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%