Cash Visibility

Capital & FinanceEssay7 min read

In many businesses the bank balance is the only measure of cash anyone looks at. A profitable month that ends short of cash is a surprise. A good year whose cash did not keep up with its profit is a puzzle the accountant explains months later. And when a buyer who models cash arrives, the first person to compute how much of the business's EBITDA became cash is the buyer's quality-of-earnings team, so whatever they find, the seller hears it for the first time in the middle of a sale.

Cash Visibility reverses that order. It measures cash with a monthly cash flow statement that walks from EBITDA to the change in cash, a rolling weekly forecast whose accuracy is recorded, and a yearly cash conversion figure with every gap explained, so the business sees its cash before the buyer computes it.

Where Cash Visibility sits

Three drivers turn earnings after maintenance into cash a buyer can count on. This essay covers the third.

EBITDA less maintenance capex

  1. Working Capital ManagementDefines working capital once, sets the level the business needs, and manages the days to targets
  2. Balance Sheet QualityMakes the balance sheet collectible, saleable and complete, with every debt-like item listed
  3. Cash VisibilityThis essayMeasures cash: a monthly cash flow statement, a tracked weekly forecast, and cash conversion explained

Cash conversion

A monthly walk from EBITDA to cash

Every monthly package for the last two years carries a cash flow statement that walks from EBITDA through capital spending, the change in working capital, taxes and financing to the change in cash, reconciled to the bank.

The statement becomes part of the monthly close, built from the closed balance sheets and the classified capital spending schedule, in the same layout every month. The prior months are backfilled from the closed statements, so that the two years exist when an inspector asks, without waiting two years from the day the work began.

The walk locates every dollar of difference between profit and cash. A month in which EBITDA was strong and cash fell stops being a mystery, because the statement shows whether the cash went into a receivable not yet paid, a batch of stock, a capital purchase, a tax payment or a loan repayment. A buyer can then read the business's cash directly, with no reconstruction and no discount for doubt about what the reconstruction missed.

A forecast that records its own accuracy

The second record is a thirteen-week cash forecast, rolled every week for months on end, with the forecast made four weeks earlier landing close to actual closing cash in nearly every week.

The first bridge introduced the thirteen-week forecast as a tool for the owner, a way to see tight weeks coming. On this bridge it becomes evidence. Receipts are built from the aged receivables and the order book, and payments from approved payables, the payroll calendar and the capital spending plan, week by week. Every week, the forecast made four weeks earlier is set beside what happened, on one line, with a one-line reason for any miss beyond the margin.

How close the forecast came

Illustrative. Each week, the closing cash the forecast predicted four weeks earlier, compared with the actual figure, as a percentage error. The band marks an illustrative margin of 10 percent either way.

Four-week-ahead forecast error

An illustrative margin of 10 percent: −10% to 10%1: 6%2: −4%3: 12%4: 3%5: −8%6: 5%7: −2%8: 9%9: −11%10: 4%11: 3%12: −6%13: 2%6%−4%12%3%−8%5%−2%9%−11%4%3%−6%2%An illustrative margin of 10 percent−10%−5%0%5%10%12345678910111213An illustrative margin of 10 percent: −10% to 10%1: 6%2: −4%3: 12%4: 3%5: −8%6: 5%7: −2%8: 9%9: −11%10: 4%11: 3%12: −6%13: 2%12%−11%An illustrative margin of 10 percent−10%−5%0%5%10%12345678910111213

Eleven of the thirteen weeks land within the margin. The two misses, weeks three and nine, each carry a one-line reason: a customer's payment run moved, and a supplier asked for payment early.

Show the numbers
WeekFour-week-ahead forecast error
16%
2−4%
312%
43%
5−8%
65%
7−2%
89%
9−11%
104%
113%
12−6%
132%
An illustrative margin of 10 percent−10% to 10%

A forecast is a claim about the future, and buyers discount claims. One that carries months of its own track record, showing how close it came each week and why it missed when it did, is a claim the business has already tested. The accuracy record is what turns the forecast into evidence that the business can see its own cash.

Cash conversion, stated and defended

The third record is cash conversion, EBITDA less capital spending less the change in working capital as a share of EBITDA, reported for each of the last three years and each quarter of the latest, with every significant movement explained.

Cash conversion, quarter by quarter

Illustrative. EBITDA less capital spending less the change in working capital, as a share of EBITDA, for each of the last twelve quarters, with the average of the latest four quarters drawn over it.

Cash conversion

Average of the latest four quarters

Y1 Q1: 42%Y1 Q2: 55%Y1 Q3: 86%Y1 Q4: 79%Y2 Q1: 40%Y2 Q2: 54%Y2 Q3: 84%Y2 Q4: 80%Y3 Q1: 38%Y3 Q2: 50%Y3 Q3: 80%Y3 Q4: 76%Average of the latest four quarters, Y1 Q1: 66%Average of the latest four quarters, Y1 Q2: 66%Average of the latest four quarters, Y1 Q3: 66%Average of the latest four quarters, Y1 Q4: 66%Average of the latest four quarters, Y2 Q1: 65%Average of the latest four quarters, Y2 Q2: 65%Average of the latest four quarters, Y2 Q3: 64%Average of the latest four quarters, Y2 Q4: 64%Average of the latest four quarters, Y3 Q1: 64%Average of the latest four quarters, Y3 Q2: 63%Average of the latest four quarters, Y3 Q3: 62%Average of the latest four quarters, Y3 Q4: 61%42%55%86%79%40%54%84%80%38%50%80%76%0%25%50%75%100%Y1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2Y2 Q3Y2 Q4Y3 Q1Y3 Q2Y3 Q3Y3 Q4Y1 Q1: 42%Y1 Q2: 55%Y1 Q3: 86%Y1 Q4: 79%Y2 Q1: 40%Y2 Q2: 54%Y2 Q3: 84%Y2 Q4: 80%Y3 Q1: 38%Y3 Q2: 50%Y3 Q3: 80%Y3 Q4: 76%Average of the latest four quarters, Y1 Q1: 66%Average of the latest four quarters, Y1 Q2: 66%Average of the latest four quarters, Y1 Q3: 66%Average of the latest four quarters, Y1 Q4: 66%Average of the latest four quarters, Y2 Q1: 65%Average of the latest four quarters, Y2 Q2: 65%Average of the latest four quarters, Y2 Q3: 64%Average of the latest four quarters, Y2 Q4: 64%Average of the latest four quarters, Y3 Q1: 64%Average of the latest four quarters, Y3 Q2: 63%Average of the latest four quarters, Y3 Q3: 62%Average of the latest four quarters, Y3 Q4: 61%86%38%0%25%50%75%100%Y1Q1Y1Q2Y1Q3Y1Q4Y2Q1Y2Q2Y2Q3Y2Q4Y3Q1Y3Q2Y3Q3Y3Q4

Each year the quarters swing between about 40 and 85 percent, so a buyer modelling by quarter needs the swing. The yearly figure looks steady at a glance, yet it slips from about 66 percent to 61 percent over the three years, which is the trend a buyer reads first.

Show the numbers
QuarterCash conversionAverage of the latest four quarters
Y1 Q142%66%
Y1 Q255%66%
Y1 Q386%66%
Y1 Q479%66%
Y2 Q140%65%
Y2 Q254%65%
Y2 Q384%64%
Y2 Q480%64%
Y3 Q138%64%
Y3 Q250%63%
Y3 Q380%62%
Y3 Q476%61%

The ratio is computed in the monthly package on a trailing twelve-month basis, with the prior year beside it. Every movement of more than a few points gets a written reason that cites the schedule behind it: capital spending timing from the capex schedule, a working-capital swing from the peg schedule, a large prepayment from the deferred revenue list. That makes the share of earnings that becomes cash a number the business has stated and defended, which leaves a buyer far less room to compute it and interpret it in its own favour.

What good conversion looks like

No single level of cash conversion is right; it depends on what the business is. A service business that owns little equipment and is paid promptly converts most of its EBITDA into cash. A manufacturer that replaces machines and carries stock converts less. A distributor selling on long credit terms converts less again, especially while it grows. A buyer compares the ratio with businesses like it, and with the business's own history.

The history is often the more useful comparison, and its trend tells a buyer more than its level. A ratio steady for three years says the business's capital needs are understood and stable. A falling ratio, even from a high level, says something is absorbing more cash each year: receivables lengthening, stock building, capital spending rising. The quarterly figures matter for a related reason. A seasonal business can show a healthy yearly ratio built from quarters that swing widely, and a buyer modelling it by quarter needs to know the swing.

Hence the requirement to explain every significant movement. A number on its own invites the buyer to supply the reason, and a number that arrives with its reason, drawn from the schedule that caused it, settles the question.

The forecast as a management tool

The forecast earns its keep long before any buyer reads it. The business uses it to decide when it can afford a capital purchase, whether a quarter's tax payment needs the credit line, how much the owner can safely take out after the reserve is funded, and whether a large order can be accepted on the payment terms the customer wants. Before the forecast, each of those was a guess. With a forecast whose accuracy is known, each becomes a judgment made against a figure whose error is also known. The record a buyer eventually reads is a by-product of running the business this way.

What it does to value

In the framework's valuation, Cash Visibility moves no value at all. The cash the business produces is the same whether or not anyone measures it; the driver only reveals it. What changes is the buyer's uncertainty. A buyer without the business's own measure of conversion assumes a worst case and holds back a margin for it. Given a measured, explained ratio and a tested forecast, the buyer can work from the measured variance, and the margin narrows. The framework records that as an effect on price and certainty. The driver carries no rank on the bridge and is done for the certainty it gives a buyer.

The owner has a reason to want it regardless of any buyer. The previous two drivers manage and clean working capital, and this one is how the business knows whether they are working. A fall in cash conversion is usually the first visible sign that working capital is ballooning, and a business that measures conversion every month sees the swing in the month it starts.

What has to be in place first

The cash flow statement and the conversion ratio are built from two schedules, the capital spending classification from Capex Discipline and the working-capital history from Working Capital Management. The forecast needs a finance seat with an hour a week, from Management Install, because it is a weekly discipline and an owner keeping it in a notebook does not count. And it needs bank data to reconcile against, through bank feeds into the accounting system set up under Books.

Knowing that it works

The driver is tracked by the number of weeks with a rolled forecast on record; by the four-week-ahead forecast error each week, as a percentage of actual closing cash; and by trailing twelve-month cash conversion each month, against the prior year.

Reading this week's forecast, the owner should be able to name the lowest week in the next thirteen and what drives it, from the forecast alone. Last year's cash conversion should come as easily, explained in three sentences from the cash flow statement, the way a modelling buyer's analyst will.

Why it slips, and what holds it

The forecast stops being updated: a busy month, a finance seat on leave, and the weekly record develops gaps a buyer will notice. And working capital balloons without anyone seeing it, because nobody is looking at conversion.

Both are kept in front of the people who can act. The forecast and its accuracy line are a standing item at the weekly leadership meeting, so a missed week shows up as a gap in a record the leads look at every week. The cash flow statement and the conversion ratio sit on the first page of the monthly package, where a fall in conversion reaches the owner every month as the first sign of a working-capital swing.