13-Week Cash Flow Forecast for ABL: How to Build a Lender-Ready Liquidity Package

A 13-week cash flow forecast is one of the clearest ways for a CFO to explain how a business plans to fund payroll, vendors, inventory, debt service, and seasonal working-capital needs over the next quarter. For an asset-based lending (ABL) discussion, the useful version is not a top-down budget. It is a weekly liquidity forecast that connects expected receipts and disbursements to the borrowing base, revolver balance, and availability the company expects to have at its tightest point.

This guide is for owners, CFOs, controllers, and treasury teams preparing for a new ABL facility, a refinancing, a renewal conversation, or an initial lender meeting. It explains how to build a lender-ready 13-week cash flow forecast before the conversation becomes urgent. It does not predict lender decisions or replace a lender’s independent underwriting, diligence, documentation, or approval process.

What Is a 13-Week Cash Flow Forecast?

A 13-week cash flow forecast is a rolling, week-by-week view of expected cash receipts, cash disbursements, financing activity, ending cash, and—when a company has or is seeking an ABL revolver—projected borrowing-base availability. Thirteen weeks is a practical horizon: it is near enough for management to tie receipts to actual invoices and purchasing plans, while still long enough to reveal a seasonal inventory build, a collections slowdown, or a period when cash need may exceed collateral support.

For lender conversations, the forecast should answer four questions quickly: What is the company’s lowest projected cash or availability point? What operating events cause it? Which assumptions drive the result? What information lets a lender test those assumptions? The point is not to manufacture certainty. It is to give the lender a transparent, traceable view of the liquidity plan.

Why Build It Before an ABL Discussion?

An ABL request is usually evaluated through collateral and operating cash flow together. The borrowing base shows what eligible receivables and inventory may support; the cash forecast explains when the business expects to need that capacity. A lender may look for the relationship between sales, collections, purchases, payroll, customer concentration, inventory movement, and expected revolver usage—not simply a requested commitment amount.

Building the forecast before outreach can also help management separate a structural financing need from a short timing issue. A recurring seasonal build, a planned growth program, a maturing line, and a temporary collections delay may each call for a different conversation. DCE’s guide to ABL facility size, commitment, and availability explains why the headline commitment is not the same as usable borrowing capacity on any particular day.

The Seven Building Blocks of a Lender-Ready Forecast

1. Start with current cash, debt, and availability

Set the opening week from the latest available information: bank cash, outstanding revolver loans, letters of credit, current borrowing-base availability, and any material restrictions on cash use. Use a clear as-of date and identify any timing differences. If management cannot reconcile the opening position to ordinary reporting, the later weeks will be difficult for a lender to rely on.

For a proposed facility, label preliminary availability as an internal estimate rather than a lender commitment. Apply conservative, explainable assumptions and keep the source schedules behind them. The lender will perform its own eligibility, advance-rate, reserve, and collateral analysis.

2. Build receipts from invoices and collection behavior

Cash receipts are usually the most important forecast input. Rather than using a flat percentage of projected sales, start with the current accounts-receivable aging and identify when major invoices are expected to pay. Group smaller balances using actual collection patterns, but isolate large customers, slow-paying accounts, disputed invoices, credits, and accounts approaching an eligibility cutoff.

Receipts should reconcile conceptually to the cash conversion cycle. If collections are expected to accelerate, identify the operational reason: a specific invoice due date, a documented customer payment change, or a collection action already underway. Do not assume cash arrives simply because the sales plan requires it. DCE’s DSO, DIO, and cash conversion cycle guide details how collection velocity can affect ABL availability.

3. Schedule operating disbursements by timing, not annual budget

Build weekly outflows from the payment calendar. Separate payroll, critical vendors, inventory purchases, freight, rent, benefits, debt service, capital expenditures, and other material categories. The level of detail should reflect the business: a distributor may need a granular purchase-order and inbound-freight view, while a service company may focus on payroll and customer collections.

Show timing honestly. Moving a disbursement from one week to another without a factual basis may make the forecast look better, but it does not improve liquidity. If a payment is discretionary, contingent, or subject to a management decision, label it as such and explain the assumption rather than mixing it with contracted operating requirements.

4. Translate operating activity into a borrowing-base outlook

For an ABL borrower, cash alone is not the full liquidity picture. Add a weekly borrowing-base outlook showing the expected movement in eligible receivables and inventory, expected ineligibles or reserves, revolver loans, letters of credit, and resulting availability. The schedule does not need to replicate every lender certificate line for an initial discussion, but it should identify the drivers that could change the result.

For example, an inventory purchase may reduce cash in week two but create eligible inventory only after goods are received, owned, properly recorded, and within the lender’s eligibility parameters. A large shipment may create receivables, but availability may not rise as expected if the customer is concentrated, the invoice is disputed, or collection terms are unusually long. The weekly borrowing-base early-warning metrics guide provides a practical view of the trends worth monitoring.

5. Identify the binding week and the assumptions behind it

Flag the week with the lowest cash balance, the lowest availability, or both. Then state what causes the pressure: inventory purchases ahead of a selling season, a customer concentration, payroll timing, a planned capital expenditure, a debt maturity, or slower expected collections. This is often the most useful part of the forecast because it turns a general request for “more flexibility” into a specific operating story a lender can evaluate.

Illustrative weekly view	Week 1	Week 6	Week 10	Week 13
Beginning cash	$650,000	$510,000	$375,000	$740,000
Customer receipts	$1,420,000	$1,180,000	$1,030,000	$1,690,000
Operating disbursements	($1,360,000)	($1,470,000)	($1,610,000)	($1,420,000)
Projected ending cash	$710,000	$220,000	($205,000)	$1,010,000
Projected ABL availability	$2,100,000	$1,250,000	$620,000	$1,860,000

The figures are illustrative only. In this example, week 10 is the binding availability week. A lender would likely ask what drove the lower receipts, the higher disbursements, and the projected borrowing-base movement; the forecast should point to source data and operating assumptions, not rely on the table alone.

6. Run a focused downside case

A base case is a planning tool, not a complete liquidity view. Add a downside case that tests a small number of assumptions most likely to matter to the business: slower collections from a major customer, lower sales or gross margin, an inventory delay, a higher reserve, or a reduced advance rate assumption. Do not create a dramatic scenario merely to look sophisticated. Use assumptions management can explain and monitor.

The goal is to show where the liquidity plan becomes sensitive and what facts management would watch. A downside case is also a useful way to prepare for lender questions without suggesting that a lender must accept the company’s analysis or provide additional capacity.

7. Establish an actual-versus-forecast routine

A 13-week forecast gains value when it is refreshed weekly. Preserve the original forecast, record actual receipts and disbursements, explain material variances, and roll the horizon forward one week. A simple variance log can distinguish timing differences from changes in the underlying operating plan.

This discipline can be more persuasive than a polished one-time workbook because it shows whether management recognizes changes early and can update the liquidity story with current facts. It also helps keep the finance team, operations, and executive leadership aligned before a lender sees a surprise.

What to Include With the Forecast

The 13-week is strongest when it is part of a concise lender-ready package rather than a stand-alone spreadsheet. The supporting materials should make key assumptions easy to test.

Supporting item	What it helps explain
Current AR aging and customer detail	Expected collections, concentration, slow-pay accounts, credits, and disputes
Inventory and purchasing schedule	Timing of purchases, inventory build, ownership, locations, and expected turns
Current borrowing-base support	Existing availability, reserves, letters of credit, and collateral movement
Historical monthly results	Whether sales, margins, collections, and working-capital needs follow a consistent pattern
Debt and maturity summary	Current balances, scheduled cash demands, and refinancing timing
Management assumptions memo	Source, owner, timing, and risk factors behind the forecast’s key inputs

The broader set of documents is covered in DCE’s ABL credit package guide. Before initial lender outreach, management can also use the ABL lender-outreach checklist to test whether the forecast, collateral schedules, and financing request tell the same story.

Common Forecast Mistakes in ABL Conversations

• Forecasting receipts as a percentage of sales only. A lender may need to see how cash collections tie to the current receivable book and customer behavior.
• Showing cash without availability. For an ABL borrower, liquidity may depend on collateral eligibility, reserves, loan balances, and letters of credit—not cash alone.
• Using one forecast for every audience. The board budget, operating plan, and lender liquidity forecast can use different levels of timing and support. Reconcile them; do not assume they are interchangeable.
• Hiding the tight week. The low point is where a lender will focus. Identify it, explain it, and support the assumptions.
• Failing to refresh against actuals. A forecast that is never compared with results becomes less useful with every passing week.
• Confusing a forecast with approval. A lender may use different eligibility, advance-rate, reserve, and underwriting assumptions. The forecast prepares the conversation; it does not determine the outcome.

How This Differs From a Forbearance Forecast

A 13-week forecast is useful well before a covenant breach, default, or forbearance request. In a proactive ABL or refinancing discussion, it helps a lender understand the expected working-capital cycle and whether the proposed facility matches the business plan. In a workout, the same tool is typically more detailed, refreshed more frequently, and paired with a formal availability bridge, milestone plan, and relief request. If the company is already seeking a waiver, amendment, or forbearance, read DCE’s ABL forbearance package guide.

Where DCE Fits

Don Clarke Enterprises helps middle-market borrowers organize lender-ready commercial-finance information, including the operating assumptions, collateral narrative, and liquidity materials that can support a focused ABL conversation. DCE does not originate, underwrite, fund, approve, or guarantee financing. Lenders independently determine credit decisions, collateral treatment, facility terms, and required diligence for each transaction.

Educational only; not legal, tax, accounting, investment, or financial advice. Forecasts, financing structures, collateral eligibility, lender decisions, and outcomes vary by transaction and are subject to independent lender review, diligence, documentation, and approval.