Financial Modeling for Capital Planning: Understanding How Much Financing a Business Actually Needs

The amount of financing a business needs is the largest cash shortfall it expects to face over the planning period, plus a cushion for things going worse than planned. A financial model for debt financing finds that number by forecasting cash in and cash out month by month, layering in facility draws and repayments, and testing whether the facility will actually have enough availability at the moment the business needs it.

Choosing a facility size first and working backward rarely holds up. Ask for too little and the business runs short at its seasonal or growth peak. Ask for too much and it pays unused fees and invites questions from lenders about how the figure was chosen. A forecast built from the business’s own collection and payment history answers both problems.

Why Liquidity Forecasting Comes Before Profit

A profitable company can still need substantial outside capital. Revenue is often recorded weeks or months before it is collected, while payroll, inventory and supplier invoices are paid on schedule. An annual profit forecast smooths that timing away. A capital planning model is therefore built around a monthly (and sometimes weekly) liquidity forecast that tracks the cash balance through each period.

Monthly detail matters because the largest need usually falls between year ends. A model that only shows December can report a comfortable position while missing a June trough that would push the facility to its limit.

Working Capital Forecasting

The gap between paying for inputs and collecting from customers is often the biggest single driver of financing need. If suppliers are paid in 30 days and customers pay in 75, each additional dollar of sales ties up cash for about 45 days. Modeling receivables, payables and inventory explicitly, using days outstanding or collection curves, makes that effect visible in a way a percentage of revenue assumption does not.

Growth

Growth increases the working capital requirement. For lenders and originators the effect is direct: each new loan or lease has to be funded before it repays anything. Tying origination or sales volume to funding needs month by month shows how much a faster plan raises the peak, and whether the facility can keep up.

Collections

Collection assumptions deserve the most scrutiny. A historical collection curve, showing the share of each month’s billings or originations collected in each following month, is far more defensible than a single average. Where history is short, use conservative assumptions and note them clearly.

Facility costs

Interest, unused line fees, minimum balance requirements and other facility costs consume cash too. They belong in the forecast, not in a footnote.

Commitment Versus Availability

Two figures matter when sizing a debt facility. The commitment is the maximum the lender has agreed to provide. Availability is what the business can draw on a given day. In asset based facilities, availability is generally the lower of the commitment and the borrowing base, which is calculated from eligible collateral after advance rates, concentration limits and reserves. Our guide to how a borrowing base is calculated explains each step.

This is where many capital plans break. The commitment may sit comfortably above the projected peak while the borrowing base, which moves with collateral balances and eligibility, falls below it in the same month. Borrowing base modeling, done period by period, is what reveals that risk.

A Hypothetical Example

A growing receivables business has a $6.0 million committed facility. Availability is limited to 80% of eligible receivables. Its base case forecast for the next six months:

Utilization peaks in Month 5, when the balance reaches $5.5 million, about 92% of the commitment. The more important figure is headroom to the borrowing base, which falls to $260,000. The borrowing base, not the commitment, is the binding constraint.

The downside case

Now assume customers pay about two weeks slower. More invoices pass the facility’s aging cutoff, so eligible receivables in Month 5 fall to $6.6 million and the borrowing base to $5.28 million. Slower collections also mean the business must draw more, lifting the required balance to $5.6 million.

The result is a $320,000 shortfall while the $6.0 million commitment still looks adequate on paper. Seeing that months ahead gives management time to act: tighten collections, phase growth, hold a cash reserve, negotiate eligibility terms or consider a different structure. Discovering it in Month 5 leaves far fewer choices.

Scenario Analysis

A single forecast is one estimate among many possible outcomes. Lenders and boards want to know which assumptions the financing need is most sensitive to. Scenarios work best when they change one or two drivers at a time, so the effect of each is clear. Useful ones include slower collections, higher dilution, faster or slower growth, a larger share of business from one customer or payor, a lower advance rate or tighter eligibility, higher interest costs, and the delay of a single large receipt.

The aim is to understand how much cushion the business needs to absorb reasonable variation, not to predict the worst case precisely.

Forecast Versus Actual

A model is only useful if it is maintained. Comparing forecast to actual results each month shows which assumptions were too optimistic and builds a record that capital providers come to rely on. A company that explains its variances consistently earns more credibility than one that starts from a fresh forecast every quarter. The same review supports facility management after closing: anticipating covenant pressure, planning draws and preparing for renewals. Our Capital & Facility Management team works from this analysis.

Where AI Can Help

AI financial modeling tools are most useful on the parts of the work that are repetitive or data heavy. They can build collection curves from transaction level data rather than relying on a single average, run many scenarios quickly, flag forecast versus actual variances that exceed a threshold, and track facility utilization against the borrowing base as new data arrives. They can also help spot inconsistencies between the model and the source reports it draws from.

AI does not choose the assumptions or own the result. Management still has to decide what growth plan is realistic and stand behind the forecast, and every figure that goes to a lender needs to be checked against source records. Treated as an analytical aid, these tools mainly shorten the time between a change in the business and a clear view of what it means for financing.

What a Lender Ready Model Includes

• An assumptions page with the source or rationale for each key input
• Monthly projections covering at least the next 12 to 24 months or the expected facility term
• An integrated income statement, balance sheet and cash flow statement
• A borrowing base calculation that mirrors proposed or existing facility terms
• Draws, repayments, interest and fees
• Covenant calculations where they apply
• Scenario switches that do not require rebuilding the model
• Historical periods for comparison against the projections

How Gen Ventures Helps

Our Financial Modeling team builds and reviews capital planning models, liquidity forecasts and borrowing base projections with management, often as part of broader Institutional Readiness work before a company approaches lenders. If you are deciding how much to ask for, or whether a facility will hold up under pressure, that analysis is the place to start. Our Capital Solutions page describes how we support the financing process that follows.