Pro Forma Cash Flow

Pro forma cash flow is a projection of future cash movements built around a specific scenario or assumption that has not yet happened. It answers the question: if we do this, hire someone, raise prices, take on a loan, what does the cash position look like going forward? It is a decision-support tool, not a report of what occurred.

How It's Built

Pro forma cash flow follows the same structure as any cash flow projection, with one defining characteristic: at least one input reflects a planned or hypothetical change rather than current reality.

Pro Forma Closing Balance = Opening Balance + Pro Forma Inflows - Pro Forma Outflows

The projection rolls forward period by period, with the closing balance of each period becoming the opening balance of the next.

What distinguishes a pro forma from a standard forecast is the layer of scenario assumptions applied on top of the base case. The base case reflects the business as it currently operates, existing revenue run rate, current cost structure, known payment timing. The pro forma adjusts one or more of those inputs to reflect the planned change and shows what the cash position looks like as a result.

Common scenario inputs include:

Revenue change, a price increase, a new contract, a product launch, or the loss of a major customer. Each shifts projected inflows by a specific amount from a specific date.

Cost change, a new hire, a lease on additional space, a software contract, or a supplier price increase. Each adds to projected outflows from the date the cost takes effect.

Capital event, a loan drawdown, an equipment purchase, or an investor round. These create one-time or structured cash movements that change both the opening balance and the ongoing payment obligations.

The pro forma is only as useful as the assumptions behind it. A revenue projection that assumes a new contract closes in Month 2 needs to be stress-tested against what happens if it closes in Month 4 or not at all. Running a pro forma without also running the downside version of the same scenario produces a plan, not an analysis.

A small logistics company is considering hiring a second operations manager at a fully-loaded cost of $6,500 per month, starting in Month 2. The hire is expected to support a new service contract that begins generating $9,000 in monthly revenue from Month 4 onwards. The owner wants to see what the cash position looks like over six months under this scenario, compared to the base case.

Base case (no hire, no new contract):

MonthOpening BalanceInflowsOutflowsClosing Balance1$48,000+$52,000-$47,000$53,0002$53,000+$52,000-$47,000$58,0003$58,000+$52,000-$47,000$63,0004$63,000+$52,000-$47,000$68,0005$68,000+$52,000-$47,000$73,0006$73,000+$52,000-$47,000$78,000

Pro forma (hire from Month 2, new revenue from Month 4):

MonthOpening BalanceInflowsOutflowsClosing Balance1$48,000+$52,000-$47,000$53,0002$53,000+$52,000-$53,500$51,5003$51,500+$52,000-$53,500$50,0004$50,000+$61,000-$53,500$57,5005$57,500+$61,000-$53,500$65,0006$65,000+$61,000-$53,500$72,500

The pro forma shows Months 2 and 3 as the pressure point: the hire adds cost before the new revenue begins. The cash balance dips from $53,000 to $50,000 during that period, still positive, with comfortable headroom in this example. By Month 6 the positions are close: $78,000 in the base case versus $72,500 in the pro forma, with the gap explained by two months of net cost before the revenue contract started. The owner can see the shape of the bet before making it: a three-month drag, followed by a recovery.

If the new contract were delayed to Month 5 instead of Month 4, the pro forma would show the trough extending by a month, and the Month 6 closing balance would be lower. Running that version takes a few minutes and changes the conversation from "should we hire?" to "what is our exposure if the contract is delayed, and can we absorb it?"

It converts a business decision into a cash question

Most decisions with financial consequences are discussed in terms of revenue potential or cost. The pro forma translates those terms into cash timing: not "this hire will cost $78,000 a year" but "this hire will reduce our cash balance by $6,500 per month starting in six weeks, and the revenue that justifies it does not arrive until Month 4." That framing changes the decision, because the question becomes whether the business has the cash to bridge the gap, a question the pro forma answers directly.

It forces the assumptions to be explicit

A business decision made without a pro forma is still based on assumptions, they are just unstated. The owner planning to hire still has a mental model of when the revenue will arrive and whether the cash can handle the interim period. The pro forma makes those assumptions visible and testable. Once the numbers are on the page, it is possible to examine them: Is Month 4 a realistic start for the new contract? What if the revenue is $7,000 a month rather than $9,000? What if the hire takes until Month 3 to become fully productive? Each of those questions produces a different pro forma, and the range of outcomes is more informative than any single projection.

It is what lenders and investors expect

When a business applies for a loan to fund a hire, a new location, or a piece of equipment, the lender wants to see a pro forma showing how the loan affects cash flow, the drawdown, the repayment schedule, and whether operating cash flow covers the new debt service. When an investor evaluates a business plan, the pro forma cash flow is how the financial projections get tested against reality. A business that can present a well-constructed pro forma with clearly stated assumptions is in a better position than one that presents revenue projections without connecting them to the cash timeline.

A pro forma projects cash under a planned scenario, like a new hire or a price change, before you commit.

The value of that timing, before you commit, is specific. Once a hire is made, the cost is running. Once a lease is signed, the obligation is fixed. The pro forma is the tool that shows the cash consequence while the decision is still reversible. In the logistics example, the owner can see that Months 2 and 3 require the business to carry the cost of the hire without the offsetting revenue. If the cash balance were $35,000 instead of $53,000 at the start of that period, the trough would be more concerning and the decision might change. The pro forma surfaces that before the hire, not after.

Run alongside the base case forecast, the pro forma also shows the opportunity cost of not acting. The base case closes Month 6 at $78,000; the pro forma closes at $72,500 after absorbing the hiring cost, but with a new service contract generating $9,000 per month that does not exist in the base case. By Month 8 or Month 9, the pro forma position overtakes the base case entirely. That longer view is only visible when the pro forma and the base case are both on the table.

Cash Flow Frog connects to QuickBooks Online, QuickBooks Desktop, Xero, and Sage Intacct and builds a rolling cash flow forecast automatically from your accounting data. QuickBooks records what happened. Cash Flow Frog projects what is coming.

The base case forecast, built from live accounting data, is the starting point for any pro forma scenario. Planned changes are layered on top of that base: a new cost line from a specific date, a revenue assumption that starts in a particular month, a loan drawdown with a repayment schedule. Because the base case updates from live data as the books update, the pro forma stays grounded in current reality rather than assumptions made months ago. The forecast runs up to three years out, which is long enough to show whether a scenario that costs cash in the short term generates a return over a reasonable horizon. For businesses with multiple entities or currencies, scenario modeling runs natively across all of them. You can see how projections work in Cash Flow Frog at cashflowfrog.com/features/projections/.

Frequently Asked Questions

A forecast projects what is likely to happen based on current conditions and historical patterns. A pro forma models what would happen under a specific scenario that represents a change from current conditions. A forecast is descriptive, this is where the business is heading. A pro forma is hypothetical, this is where the business would go if a particular decision were made. In practice, a pro forma is built by modifying a base case forecast, so the two are closely related.

How detailed do the assumptions in a pro forma need to be?

Detailed enough to be testable. A revenue assumption that says "new contract: $9,000 per month from Month 4" can be examined, is Month 4 realistic? What does the pipeline look like? A revenue assumption that says "revenue grows" cannot be tested or challenged in any useful way. The discipline of building a pro forma is partly the discipline of converting vague expectations into specific numbers with specific start dates, which forces a clearer-eyed assessment of whether those expectations are realistic.

Should a pro forma always include a downside scenario?

Yes, if the decision is material. A pro forma built on a single set of assumptions shows one possible outcome. A downside scenario, where the new revenue comes in later, lower, or not at all, shows the risk. The gap between the base case pro forma and the downside pro forma is the exposure the business is taking on. A business comfortable with that gap can proceed; one that sees the downside taking the balance to a level that threatens operations needs either a different plan or more cash in reserve before committing.

Can a pro forma be used for an acquisition or merger?

Yes, and it is standard practice. When a business acquires another, the combined entity's projected cash flows are modeled in a pro forma that incorporates the target's cash flows, the cost of the acquisition, any integration costs, and the financing structure. The same applies to a merger. The pro forma is how the acquirer tests whether the combined business generates enough cash to service acquisition debt, cover integration costs, and still maintain adequate liquidity. The complexity of the assumptions increases, but the structure is identical to any other pro forma.

How far forward should a pro forma project?

Long enough to show the full consequence of the decision. A hire that costs cash for three months before generating revenue needs at least a six-month horizon to show the recovery. A capital expenditure with a multi-year payback needs a horizon that includes enough of that payback to assess whether the investment is justified. As a general principle, the projection should extend to the point where the scenario has either stabilised into a new steady state or clearly returned to the pre-decision trajectory. Anything shorter risks presenting only the cost without the return.

Is a pro forma the same as a financial model?

A financial model is a broader term that can include income statement projections, balance sheet forecasts, valuation analysis, and sensitivity tables, in addition to cash flow projections. A pro forma cash flow is one component of a financial model, focused specifically on cash timing. In a small business context, a pro forma cash flow is often the only modelling that is practically needed, the income statement and balance sheet implications of a hire or a price change are secondary to whether the cash position can support the decision.

• Cash Flow Forecast
• Cash Flow Projection
• Scenario Planning
• Operating Cash Flow
• Cash Flow Budget
• Free Cash Flow