Search Here

What a Pro Forma Model Should Show Prospective Buyers

Home / What a Pro Forma Model Should Show...

What a Pro Forma Model Should Show Prospective Buyers What a Pro Forma Model Should Show Prospective Buyers What a Pro Forma Model Should Show Prospective Buyers

What a Pro Forma Model Should Show Prospective Buyers

Spread the love

A pro forma model should show prospective buyers exactly how your business makes money, how reliably it does so, what assumptions drive future performance, and where risk could cause results to miss the plan.

For founders preparing for a sale, that definition matters because a pro forma model is not just a spreadsheet exercise. It is one of the clearest windows a buyer has into the quality of your financial thinking. In M&A, a pro forma model is a forward-looking financial projection built from historical performance, operating assumptions, and planned changes. It usually includes projected revenue, gross profit, operating expenses, EBITDA, cash flow, working capital needs, and sometimes a buyer-specific synergy view. Buyers use it to test whether your growth story is believable, whether margins are durable, and whether the company can support the purchase price being discussed.

This matters far beyond finance. A weak model signals weak management, poor controls, or unrealistic expectations. A strong model does the opposite. It tells strategic buyers and private equity groups that management understands the business at a driver level, not just at the top-line revenue level. In my experience, the best pro forma models reduce friction in diligence because they answer questions before the buyer has to ask them. They also support valuation by showing how EBITDA grows, why working capital behaves the way it does, and what levers management can actually pull post-close.

As the hub page for valuation and financial tools, this article covers the full framework founders need to understand. If you are building an exit strategy, your pro forma model should connect to every major financial tool buyers care about: historical financial statements, normalized EBITDA schedules, customer concentration analysis, revenue quality reviews, scenario planning, cash flow forecasting, and valuation sensitivity work. A buyer does not evaluate projections in isolation. They compare your pro forma model against your trailing twelve months, your last three years of trends, your margins by line of business, your sales pipeline conversion rates, and your capital needs. That is why this article looks at the model as both a standalone tool and part of a broader valuation toolkit.

The core financial statements a buyer expects to see

A buyer should be able to open your pro forma package and immediately understand the three core projected statements: income statement, balance sheet, and statement of cash flows. If one of those is missing, the model is incomplete. Founders often over-focus on the projected profit and loss statement because revenue growth and EBITDA are the headline numbers. Buyers care about those numbers, but they also want to know what happens to cash, receivables, payables, debt, and reinvestment requirements as the business grows.

The projected income statement should show monthly detail for at least the next 12 months and annual detail for two to four years beyond that. Monthly detail matters because seasonality, customer timing, and margin swings often get hidden in annual numbers. The model should show revenue by stream, cost of goods sold or direct labor, gross profit, operating expenses by meaningful category, and EBITDA. If depreciation, amortization, interest, and taxes are material, they should be visible below EBITDA as well.

The projected balance sheet should show accounts receivable, inventory if relevant, prepaid expenses, fixed assets, accounts payable, accrued liabilities, deferred revenue, debt, and equity. Buyers look here to assess working capital intensity and whether projected growth consumes more cash than the business generates. Deferred revenue is especially important in software, maintenance, and service contracts because it can tell a very different story about cash than the P&L alone.

The cash flow statement should reconcile EBITDA to actual cash generation. That means changes in working capital, capital expenditures, debt service, and taxes cannot be afterthoughts. A business projecting rapid growth but negative operating cash flow needs to show how that gap gets funded. If the answer is “we will figure it out later,” the buyer will discount the model immediately.

The assumptions that make the model credible

The assumptions tab is where strong models separate themselves from fantasy. Prospective buyers do not expect certainty, but they do expect logic. Every major line item should tie back to a clear operational driver. Revenue should not simply grow by 20 percent because management wants it to. It should grow because average contract value is rising, retention is holding, unit volume is increasing, pricing is improving, or a sales team expansion is expected to produce a defined number of qualified opportunities.

Credible assumptions usually start with historical baselines. If your close rate has been 18 percent for the last eight quarters, projecting 35 percent next year requires proof. If gross margin has fluctuated between 42 and 45 percent, projecting 55 percent needs a specific explanation, such as vendor renegotiation, product mix shift, automation, or elimination of an unprofitable offering. Buyers are not allergic to aggressive assumptions; they are allergic to unsupported ones.

At minimum, your model should show assumptions for customer acquisition, churn or retention, pricing, headcount, compensation, gross margin, sales productivity, capital expenditures, payment timing, and working capital turns. If you are a recurring revenue business, include monthly recurring revenue, net revenue retention, gross retention, and cohort assumptions. If you are a project-based or services business, include billable utilization, average rates, labor mix, and backlog conversion timing.

A good practice is to highlight which assumptions are management-controlled and which are market-dependent. That distinction helps buyers understand what can be improved post-close and what remains subject to macro conditions. It also improves trust because it shows you are not pretending all variables are equally controllable.

How the model should explain revenue quality and growth durability

Not all revenue deserves the same multiple, and a useful pro forma model should make that obvious. Buyers care about revenue quality as much as revenue size. That means the model should separate recurring from non-recurring revenue, contractual from transactional revenue, high-margin from low-margin work, and concentrated revenue from diversified revenue.

For SaaS and subscription businesses, buyers want to see annual recurring revenue, monthly recurring revenue, churn, expansion, contraction, and cohort behavior. For agencies and service firms, they want to see retainer revenue versus one-off project revenue, average client tenure, wallet share, and the margin profile of each service line. For product businesses, they want to see channel mix, repeat purchase behavior, contribution margin, and customer concentration.

A pro forma model should also show whether growth is driven by volume, pricing, new products, geography, acquisitions, or improved sales execution. Those drivers carry different risk profiles. Price-led growth may be more durable than discount-fueled customer acquisition. Expansion within an installed client base is often viewed as lower risk than opening a new channel with no track record. Buyers know this, and your model should help them see it fast.

Revenue driver What buyers want to see Why it matters to valuation
Recurring contracts Renewal rates, contract terms, churn assumptions Improves predictability and supports stronger multiples
Project revenue Pipeline conversion, average deal size, close timing Higher volatility usually means more discounting
Pricing increases Historical pricing power and customer acceptance Signals margin resilience and brand strength
Cross-sell or upsell Account expansion trends and attach rates Shows efficient growth inside the customer base
New market expansion Launch costs, ramp time, and channel assumptions Adds upside, but raises execution risk

Margin analysis, EBITDA bridge, and normalized earnings

One of the most important things a pro forma model should show prospective buyers is how the business converts revenue into profit over time. That starts with margin visibility. Gross margin should be modeled by revenue stream if the economics differ. Operating expenses should be grouped into meaningful buckets such as sales and marketing, payroll, technology, occupancy, G&A, and founder-specific items. If a buyer cannot quickly see where money goes, they will assume the business lacks discipline.

The model should also include an EBITDA bridge from historical actuals to future projections. This is where you explain what changes. Maybe you are removing a low-margin service line. Maybe you hired ahead of growth last year and now expect operating leverage. Maybe you renegotiated a major vendor contract. Maybe founder compensation will normalize to market. Buyers want to see the bridge because it translates strategy into math.

Normalized earnings matter here too. Many founder-led companies run personal expenses, above-market family payroll, discretionary travel, or one-time legal fees through the business. Those may be legitimate add-backs, but they should be documented separately from the operating forecast. A buyer will not simply accept every adjustment. Your pro forma model should be conservative, transparent, and easy to diligence.

In sell-side prep, one of the fastest ways to lose credibility is to mix aspirational improvements with unproven add-backs. Keep them separate. Historical normalization belongs in one schedule. Future operational improvements belong in the forecast. That distinction matters when a private equity buyer underwrites the deal.

Cash flow, working capital, and capital needs

Many founder models overstate value because they ignore cash demands. Prospective buyers do not. A business can show strong EBITDA and still be unattractive if growth consumes too much cash. Your pro forma model should therefore show not only profits, but cash conversion.

That means projecting accounts receivable days, inventory turns if applicable, accounts payable days, accrued expenses, deferred revenue, taxes, and capital expenditures. If the business typically pays vendors in 15 days and collects from customers in 60, buyers need to see the impact. If growth requires upfront hiring, tooling, or equipment, that needs to be explicit. If software development must continue to maintain product quality, those costs should not be hidden.

Working capital targets become major negotiation points late in deals. A strong model helps avoid surprises by showing what “normal” working capital looks like. It also helps founders avoid one of the classic M&A mistakes: celebrating enterprise value while overlooking the cash, debt, and working capital adjustments that change actual proceeds at close.

Scenario analysis and downside protection

No serious buyer believes only the base case. The best pro forma models include at least three cases: downside, base, and upside. This does not weaken the story. It strengthens it. Scenario analysis shows management understands risk and can plan through it.

Your downside case should answer obvious buyer concerns. What happens if growth slows by 20 percent? What if a top customer leaves? What if gross margin compresses because of input costs? What if hiring ramps slower than planned? Your model should show the operational and financial impact, along with management’s response options. This is especially important in cyclical industries, customer-concentrated businesses, and founder-led service firms.

The upside case should also be credible. It might reflect faster conversion of pipeline, stronger retention, or earlier expansion into adjacent offerings. But if your upside case assumes everything goes right at once, it does not help. A good upside case is selective and anchored in observable leading indicators.

How this fits into the broader valuation and financial tools toolkit

As a hub for valuation and financial tools, this page should make one point clear: the pro forma model is central, but it is not enough by itself. It should connect to your quality of earnings work, EBITDA normalization schedule, valuation range analysis, cap table model, debt schedule, customer cohort reporting, and M&A readiness checklist. If you want deeper exit planning strategy, The Entrepreneur’s Exit Playbook is a useful resource: https://amzn.to/3NOnNVH.

Founders should also treat the model as a live management tool, not a one-time sale document. Buyers trust models more when they can see that management has been running the business with discipline for several quarters. A forecast built the week before going to market usually feels like theater. A forecast that management has used to hire, allocate spend, and explain results feels real.

That is also why this topic belongs inside Tools, Checklists, and Resources. Strong exits come from disciplined preparation. The model should support your M&A checklist, your diligence data room, and your internal operating cadence. If you want additional guidance on preparing the business for market, related resources on Legacy Advisors and insights discussed on the Legacy Advisors Podcast can help connect projections to actual exit execution.

A pro forma model should show prospective buyers that your growth story is grounded, your margins are explainable, your cash needs are understood, and your team knows which levers drive value. It should not read like a fundraising fantasy or a spreadsheet built to impress a banker. It should read like the operating blueprint of a company that understands itself deeply. That is what sophisticated buyers want. More importantly, that is what prepared founders build long before they go to market.

If you are serious about valuation and financial tools, start here: build a model with integrated statements, transparent assumptions, revenue quality analysis, margin bridges, working capital logic, and scenario planning. Then connect it to every other readiness tool in your exit strategy. Do that well, and your pro forma model becomes more than a forecast. It becomes evidence that your business is worth what you say it is.

Frequently Asked Questions

What should a pro forma model show prospective buyers in an M&A process?

A strong pro forma model should show prospective buyers how the business generates revenue, what costs are required to support that revenue, how cash moves through the company, and what assumptions determine future performance. In practical terms, buyers want to see more than a top-line growth story. They want a clear view of revenue drivers such as pricing, customer count, retention, sales efficiency, contract structure, and product mix. They also want to understand the cost base, including fixed versus variable expenses, gross margin trends, headcount needs, customer acquisition costs, and the operating leverage built into the model.

Just as important, the model should connect the income statement, cash flow, and balance sheet in a way that shows the business behaves logically over time. If revenue grows quickly, the model should also reflect what that growth requires in working capital, staffing, inventory, implementation resources, or capital expenditures. Buyers are testing whether the forecast is internally consistent, not just optimistic.

The best pro forma models also identify the assumptions underneath the forecast. A buyer should be able to see what happens if close rates soften, churn rises, hiring slips, margins compress, or payment cycles lengthen. That level of transparency builds confidence because it tells buyers management understands both the opportunity and the risks. In short, a useful pro forma model shows how the business makes money, how predictably it does so, what must go right to hit the plan, and where the plan could miss.

Why do buyers care so much about the assumptions behind a pro forma model?

Buyers focus heavily on assumptions because assumptions are where credibility lives. Almost any spreadsheet can be made to produce attractive growth, margin expansion, and rising cash flow. What distinguishes a compelling model from a weak one is whether the forecast is rooted in operational reality. Buyers want to know what specific inputs drive the numbers and whether those inputs are supported by historical performance, market conditions, customer behavior, and the actual capacity of the business.

For example, if the model assumes revenue will grow 30 percent next year, a buyer will want to understand whether that growth comes from existing customers, new logo acquisition, price increases, geographic expansion, or a new product launch. They will also ask what evidence supports each assumption. Is retention stable enough to support net revenue growth? Does the sales pipeline justify the bookings plan? Can the company hire enough salespeople or implementation staff to deliver on the forecast? Are margins expected to improve because of scale, vendor savings, automation, or a shift in product mix? Each answer matters because buyers are evaluating both future earnings potential and the quality of management judgment.

Clear assumptions also help buyers assess downside risk. A model that shows sensitivity around growth rates, gross margins, churn, or working capital is far more useful than one static forecast. It tells a buyer management has thought carefully about what could change and how the business would respond. That kind of discipline often has a direct effect on valuation, because confidence in forecast quality can reduce perceived risk and improve the buyer’s willingness to underwrite future performance.

How detailed should a pro forma model be for prospective buyers?

A pro forma model should be detailed enough to explain the business drivers clearly, but not so cluttered that it becomes difficult to follow. The right level of detail is usually driver-based rather than excessively granular. Buyers typically do not need a forecast built from hundreds of disconnected line items. They need a model that links major outcomes to the economic engine of the business. That means organizing the forecast around the factors that actually move performance, such as customer acquisition, retention, average contract value, utilization, production capacity, pricing, labor costs, and overhead structure.

For many businesses, this means breaking revenue into meaningful components instead of presenting one single growth line. A subscription business might separate new annual recurring revenue, expansion revenue, churn, and net retention. A services business might show headcount, billable utilization, average billing rates, and project mix. A product company might forecast units sold, average selling price, channel mix, returns, and gross margin by category. That kind of structure gives buyers insight into how management thinks and whether the forecast reflects operational reality.

At the same time, the model should remain intuitive. A prospective buyer should be able to trace how assumptions flow into revenue, expenses, EBITDA, and cash flow without needing a long explanation for every tab. Supporting schedules can provide extra detail, but the main model should present a coherent story. In an M&A setting, usefulness matters more than complexity. A clean, well-organized model with transparent drivers is generally more persuasive than a highly complicated file that looks sophisticated but is difficult to audit.

What risks should a pro forma model highlight for buyers?

A credible pro forma model should explicitly highlight the risks that could cause actual results to fall short of the plan. Buyers do not expect a forecast to be risk-free, and trying to present one that way can actually reduce confidence. What buyers want is evidence that management understands the business’s pressure points and has incorporated them into the forecasting process. Common areas of risk include customer concentration, churn, pricing pressure, delayed sales cycles, dependency on key employees, gross margin volatility, supply chain constraints, working capital demands, implementation bottlenecks, and exposure to broader market or regulatory changes.

The model should show where these risks matter financially. If a small number of customers represent a large share of revenue, buyers will want to see the effect of slower renewals or partial attrition. If growth depends on rapid hiring, they will want to understand what happens if recruiting takes longer than planned. If margin expansion is a key part of the value story, they will look closely at whether improvements depend on assumptions that may be outside management’s control. Simply listing risks in narrative form is not enough. The stronger approach is to reflect them through sensitivity analysis, scenario planning, and explicit assumptions.

This is especially important because buyers use the model to test downside resilience. They are asking questions such as: How quickly would profitability erode if bookings slipped? How much cash cushion exists if collections slow? Can the company still operate effectively if expansion timing moves out by two quarters? A pro forma model that addresses these questions head-on demonstrates maturity and preparedness. Rather than weakening the case, transparency around risk often strengthens it because it makes the overall forecast more believable.

How can founders make a pro forma model more credible and useful during a sale process?

Founders can make a pro forma model more credible by grounding it in historical performance, documenting the logic behind key assumptions, and ensuring the forecast tells the same story as the rest of the sale materials. One of the fastest ways to lose buyer trust is to present projections that are materially more aggressive than prior trends without a clear explanation. If future growth is expected to accelerate, the model should show exactly why, whether because of a stronger pipeline, new channel partnerships, improved retention, pricing changes, capacity additions, or identifiable market expansion opportunities.

Credibility also improves when the model is internally consistent and easy to diligence. Buyers should be able to reconcile the forecast to historical financials, understand any normalization adjustments, and follow how operational assumptions feed into financial outcomes. It helps to build explicit links among revenue drivers, cost structure, headcount plans, cash needs, and capital expenditures. Founders should also be ready to explain timing assumptions, such as ramp periods for new hires, implementation delays, seasonality, and sales conversion cycles. These details often matter more to buyers than broad growth claims.

Another best practice is to include multiple cases, such as base, upside, and downside scenarios. That does not mean overwhelming buyers with endless possibilities. It means showing that management has a disciplined view of what is most likely, what could go better, and what might happen if conditions tighten. Finally, the model should align with management’s verbal narrative. If the company positions itself as stable and highly predictable, the forecast should not rely on fragile assumptions or sudden margin leaps. The most effective pro forma models are not just ambitious. They are coherent, evidence-based, and built to withstand scrutiny from sophisticated buyers.