Key takeaways
- A P&L shows profitability. A 13-week cash flow model shows whether the business can pay its obligations on Thursday. They measure different things, and in a constrained business, only one of them matters that week.
- The most common cash crisis in middle market businesses is not a loss event, it is a timing mismatch: a large payroll hits before a major customer pays, and the line of credit absorbs the gap invisibly.
- PE boards require a 13-week cash flow model from portfolio companies as a standard governance document. Founders who build it before a sale or recap are not doing extra work, they are building what the new owner will require on day one.
- The 13-week horizon is not arbitrary. It matches the standard accounts receivable collection window, the typical vendor payment cycle, and the minimum look-ahead required to make a meaningful borrowing decision.
- Forecast accuracy, not the forecast itself, is what builds institutional confidence. A model that was right 80% of the time over six months is more credible than a model that looks sophisticated but has never been validated against actual results.
In this article
Only 38% of middle market companies below $50M in revenue maintain a rolling weekly cash forecast. The remaining 62% rely on bank balance monitoring and P&L-based cash estimates, methods that consistently miss timing-driven shortfalls by 2–4 weeks.
The median cash forecasting error at 13-week horizon for companies using spreadsheet-based rolling forecasts is 8–12% of the forecasted cash position, compared to 22–35% for companies estimating cash from monthly P&L projections alone.
Companies that maintained a 13-week rolling cash forecast entering a distressed period had a median of 6 additional weeks of response time versus those relying on bank-balance monitoring, the difference between a managed refinancing and an emergency.
A profitable business can run out of cash. That is not a contradiction, it is one of the most common operational surprises in middle market companies. Revenue is growing, the P&L shows healthy EBITDA, and the owner is managing by the income statement. Then a large customer pays 45 days late, a seasonal payroll spike hits, and the line of credit is suddenly at its limit with three vendor payments clearing next week. The P&L did not predict this. It could not have.
The monthly management reporting package answers "how did we perform last period?" The 13-week cash flow model answers "can we meet our obligations over the next quarter?" Both questions matter. Founder-owned businesses typically have strong answers to the first and weak answers to the second.
38%
Share of middle market companies below $50M that maintain a rolling weekly cash forecast
6 weeks
Additional response time for companies with a 13-week model entering a constrained period vs. those relying on bank-balance monitoring
13 weeks
The horizon that covers one full AR collection cycle, one vendor payment cycle, and one seasonal payroll variation
Why the P&L is not a cash management tool
The income statement records revenue when earned and expenses when incurred, not when cash moves. A business that invoices $800K in March and collects in May has recorded that revenue in March. A business that receives $200K of inventory in April and pays in June has recorded the cost in April. Neither transaction affected the bank account when the P&L said it did.
For businesses with stable, short payment cycles and predictable volumes, the gap between accounting timing and cash timing is small enough to manage by feel. For businesses with longer collection windows, project-based revenue, seasonal patterns, or significant supplier credit, the gap is material and can produce week-level cash constraints that the monthly P&L does not surface until they have already created a problem.
The most common cash crisis in a growing, profitable middle market business is not a loss event. It is a timing mismatch: revenue recognized in month one, cash collected in month two or three, payroll and vendor obligations due continuously. The business is solvent. It is just temporarily short, and if it has no visibility into that shortfall until it shows up in the bank balance, the response time is days rather than weeks.
What a 13-week cash flow model is
A 13-week cash flow model is a rolling weekly forecast of cash receipts, cash disbursements, and ending cash balance for the next 13 weeks. It is built from operational data, the AR aging report, vendor payment schedules, payroll calendars, debt service obligations, not from the P&L. It answers a single question: will the business be able to meet its cash obligations each week for the next quarter?
The 13-week horizon is not arbitrary. It corresponds to one full accounts receivable collection window for most businesses (net-30 to net-60 terms), one or two full vendor payment cycles, and at least one payroll period. It is long enough to surface timing problems while they are still manageable and short enough that the forecast can be built from real operational data rather than assumptions.
What Goes Into a 13-Week Cash Flow Model
Cash receipts
Collections from AR aging (applying historical days-to-pay by customer segment), expected new invoicing, and any non-operating cash inflows. Built from the actual AR aging report, not a revenue assumption.
Cash disbursements: operating
Payroll by pay period (exact dates, not monthly averages), vendor payment schedule from AP aging, recurring fixed operating costs (rent, insurance, utilities), and variable costs tied to revenue volume.
Cash disbursements: non-operating
Debt service (principal and interest by due date), tax payments (estimated quarterly payments, annual payments), and capital expenditure commitments already made.
Line of credit activity
Current drawn balance, available borrowing capacity, and projected borrowing or repayment based on the net cash position each week.
Ending cash and available liquidity
Bank balance plus available line of credit capacity. This is the number that answers the operational question: can we meet next week's obligations?
Working through this yourself?
Kolton works directly with founders on M&A readiness, deal structure, and AI implementation — one advisor, not a team of generalists.
Schedule a conversation →How to build a 13-week model from scratch
The first build of a 13-week model takes 2–4 hours for a business with a controller or CFO who has access to the AR aging, AP aging, payroll calendar, and bank statements. After the first build, weekly updates take 30–45 minutes.
Building the 13-Week Model: Step-by-Step
Step 1: Set up the weekly structure
Create 13 columns (weeks), with a starting cash balance from the current bank statement. Match week boundaries to how payroll and vendor payments are scheduled.
Step 2: Build the receipts schedule from AR aging
Pull the current AR aging report. For each aging bucket, apply a historical days-to-pay rate to estimate when each balance will actually be collected. Use actual collection history by customer, do not assume all current invoices pay in 30 days.
Step 3: Build the disbursement schedule from AP and payroll
Pull the AP aging report and map each vendor payment to the week it will clear. Map each payroll date. Add fixed recurring costs to their exact payment dates.
Step 4: Add capital and non-recurring items
CapEx commitments, tax estimated payments, and other known non-recurring disbursements go on their actual payment dates, not averaged across the period.
Step 5: Calculate weekly net cash flow and ending balance
Sum receipts and disbursements for each week. If the ending balance would go negative, model a line of credit draw up to available borrowing capacity. Flag any week where the ending balance after LOC draw is negative, that requires action.
Step 6: Compare forecast to actual each week
When the week closes, record actual results. Calculate the forecast error. Track this variance over time, it reveals systematic gaps (customers who consistently pay later than modeled, timing assumptions that are wrong) and improves accuracy over months.
Illustrative example, A $14M commercial landscaping company had a profitable Q1 but experienced a cash constraint in week 7 of Q2. The controller had been managing by the P&L. When she built the first 13-week model, she discovered that two large commercial clients representing $380K of outstanding AR were on 60-day terms, not the 45 days she had been estimating, and a $220K equipment lease payment was due in week 9. The model showed a $160K negative cash position in week 9 before LOC draws, and a simultaneous payroll of $140K. The total LOC draw required exceeded available borrowing capacity by $85K. With 7 weeks of visibility, she called both clients to accelerate payment, negotiated a 2-week extension on the equipment lease, and drew $60K on the line proactively in week 5. The crisis did not happen. Without the model, it would have been a Thursday surprise.
Why PE boards require it and what that means for sellers
PE operating partners require a 13-week cash flow model from portfolio companies as a standard governance deliverable, typically from the first board meeting post-close. This is not a sign of distress, it is standard for a business with a debt structure and a board that needs cash visibility to make borrowing, investment, and distribution decisions.
For founders preparing to sell or recap, building a 13-week model before the process signals financial infrastructure maturity. A buyer who asks "how do you manage cash week to week?" and receives a clean 13-week model with six months of actuals-vs-forecast tracking is receiving a different answer than one who receives "we watch the bank balance." The former signals that the management team can manage the business without heroic judgment.
PE buyers price financial infrastructure gaps into the post-close improvement plan, which means they price them into the acquisition economics. A business that lacks cash visibility tools requires a finance upgrade in the first 90 days of PE ownership. That upgrade cost is a deduction from the seller's effective multiple. Founders who build it before the process keep the value.
Common cash flow management mistakes
Frequently asked questions
What is the difference between a cash flow model and a cash flow statement?
The cash flow statement is a historical document: it shows what happened to cash in a prior period. A 13-week cash flow model is a forward-looking forecast: it shows what is expected to happen over the next quarter, based on current AR, AP, payroll, and debt service data. The financial statement is audit-ready; the 13-week model is operationally useful.
How often should a 13-week cash flow model be updated?
Weekly. The model rolls forward by one week each week: the first week drops off as actuals are recorded, a new week 13 is added with forecast data. Each update takes 30–45 minutes once the model is built. The variance between prior-week forecast and actual should be tracked and reviewed monthly to improve accuracy over time.
What should I do if the model shows a negative cash position in a future week?
A negative week identified 7–10 weeks out is a planning problem. A negative week identified 3 days out is a crisis. If the model shows a constraint: (1) accelerate AR collection; (2) negotiate vendor payment terms; (3) draw on the line of credit before the constraint, not after; (4) defer non-critical CapEx. Most middle market cash constraints are manageable with 4–6 weeks of lead time and become crises with 4–6 days.
Work with Glacier Lake Partners
Explore Operational Advisory
Assess your cash visibility infrastructure and build the reporting discipline institutional owners expect.
Explore Operational Advisory →Research sources
Disclaimer: Financial figures and case studies in this article are illustrative, based on representative middle market assumptions, and are not guarantees of outcome. Statistical references are drawn from cited third-party research; individual transaction and operational results vary based on business characteristics, market conditions, and deal structure. This content is for informational purposes only and does not constitute legal, financial, or investment advice. Consult qualified advisors for guidance specific to your situation.
Explore adjacent topics
