Article 21 — Why Cash Flow Forecasts Consistently Miss the Mark
The forecast had been built with genuine rigor. Bottom-up revenue projections. Segmented collection assumptions. Expense timing based on actual payment sch...
Get started
The term loan had made sense when it was taken.
$6M at a favorable rate, structured to fund the equipment investment the business needed to support its next phase of growth. The amortization schedule was manageable at the revenue level the business was generating when the loan was approved. The debt service coverage ratio looked comfortable in the projections. The decision was sound.
18 months later the business was operating at 85% of the revenue level that had supported the loan decision. The equipment was purchased and deployed. The loan was fully drawn. The amortization schedule had not changed. The debt service obligation was $140K per month regardless of what the revenue was doing, and in a month where collections were softer than expected, the $140K going to principal and interest was capital that was no longer available for payroll, inventory, or supplier payments.
The loan had not become a bad decision. The operating environment had changed in a way that made the interaction between the fixed debt service obligation and the variable operating cash flow a working capital constraint that the original analysis had not modeled.
Debt service obligations create a fixed cash outflow that reduces the operating cash flow available for working capital in every period regardless of what revenue and collections are doing. In a period of strong operating cash flow, debt service is a manageable obligation that is serviced from surplus. In a period of compressed operating cash flow, debt service competes directly with working capital for the cash the operating cycle generates.
This competition is most acute in businesses with variable revenue patterns, where operating cash flow fluctuates significantly across periods. Fixed debt service drawn from variable cash flow creates a floor of cash outflow that the business must meet even in its worst performing periods. When that floor is sized for an average or optimistic cash flow scenario, the worst performing periods produce genuine working capital stress.
The stress is not a consequence of poor financial management in the period it occurs. It is a consequence of how the debt service was sized relative to the full distribution of operating cash flow scenarios rather than to the expected or optimistic case. Debt service sizing that is appropriate for average conditions is inadequate for the 20% of periods where cash flow comes in below average, and those below-average periods are when the adequacy of the sizing matters most.
Debt service coverage ratios are the standard instrument for evaluating whether a business can service its debt from its operating cash flow. A DSCR above 1.25 is typically considered adequate by most lenders. The limitation of the ratio is the same limitation that afflicts the current ratio for working capital assessment. It measures a point in time or a period average without capturing the distribution of the cash flow from which the debt is being serviced.
A business with an average DSCR of 1.4 that has significant quarterly variability in operating cash flow may have a DSCR below 1.0 in 2 out of every 8 quarters. In those quarters the business cannot service its debt from operating cash flow and must draw on reserves or credit facilities to meet the obligation. If the reserve and credit facility are also supporting working capital requirements in those periods, the interaction between debt service and working capital creates a compound cash flow constraint that is more acute than either would produce alone.
“Our DSCR averaged 1.45 over the 3 years before we ran into trouble. In the 2 quarters where it fell below 1.0 simultaneously with a collection shortfall, we needed to draw on both our reserves and our revolving facility to stay current. The average ratio had not told us anything useful about the risk we were carrying.”
Beyond the ongoing interaction between debt service and operating cash flow, term debt creates a refinancing risk that intersects with working capital at the maturity date. When a term loan matures, the business must either refinance, repay from cash, or negotiate an extension. If the refinancing occurs during a period of working capital stress, the lender’s assessment of creditworthiness is influenced by the same working capital conditions that are creating the stress.
A business that approaches refinancing with aged receivables, slow inventory turn, and compressed operating cash flow is presenting a working capital quality profile that makes the refinancing more expensive or less available than the initial financing terms suggested it would be. The working capital problem and the refinancing risk interact to create a compound challenge that neither condition would produce in isolation.
How cash flow planning that incorporates debt service as a working capital variable rather than as a separate financial obligation is the approach that prevents the compound challenge from arriving without warning. The two are not separate subjects. They are part of the same cash flow system.
Managing the interaction between debt service and operating cash flow requires modeling the cash position under the full distribution of operating cash flow scenarios rather than under the expected scenario alone. That means calculating the minimum operating cash flow the business has generated over the trailing 2 to 3 years, modeling the debt service obligation against that minimum, and ensuring the resulting coverage ratio is adequate for the worst realistic scenario rather than just for the average.
“We rebuilt our debt capacity analysis using the 25th percentile of our historical operating cash flow rather than the mean. The answer was significantly different. We took on 30% less debt than we had been approved for. The covenant headroom that created has been used twice in the following 2 years.”
It also requires treating debt service obligations as a first call on operating cash flow in the working capital planning process, ensuring that the working capital available for the operating cycle is calculated net of debt service rather than gross of it. The businesses that manage this interaction effectively build their working capital targets to reflect the actual cash available for operations after debt obligations rather than the theoretical cash generated before them.
This Article Is Part of a Larger Series
Access the complete working Capital Series
The forecast had been built with genuine rigor. Bottom-up revenue projections. Segmented collection assumptions. Expense timing based on actual payment sch...
Get started
The investment committee had approved 4 initiatives in Q1. Each had been evaluated individually on its strategic merit and expected return. Each had a comp...
Get started