For independent agency owners facing an external sale, the due diligence process can feel overwhelming. Buyers will request vast amounts of data, but all of it is designed to feed into one critical document: the Pro Forma Income Statement.
This is not just a look at your past performance; it is the buyer’s primary tool for projecting the future profitability of the merged company. How they build this document, and the data you provide for it, will directly determine their final valuation and offer.
This guide explains what a Pro Forma is, the exact data buyers need from you, and how you can prepare for this critical stage to protect your agency’s value.
The Buyer’s Goal: The Pro Forma Income Statement
A Pro Forma Income Statement is a projection of the combined financial performance of both the buyer’s and seller’s agencies. The buyer uses this analysis to forecast future profitability and identify economies of scale (i.e., new cost savings or revenue opportunities).
Forecasting Future Contingency Income
A primary goal of the Pro Forma is to evaluate Contingency Income (profit-sharing bonuses). A buyer must analyze your carrier data to see how the combined premium volume might affect future bonuses. This is one of the most important factors in your agency’s valuation.
The Pro Forma Loss Ratio Calculation
To forecast contingency income, the buyer must first project a combined Loss Ratio. They will use your agency’s Annual Written Premium and Paid Claims data for each shared carrier. This combined loss ratio analysis is essential for projecting future profit-sharing bonuses, which directly impacts the price they are willing to pay.
The Pro Forma is the buyer’s financial blueprint for the acquisition. It is an active model to predict their future return on investment. Your job is to provide the clean, accurate data that supports the highest, most accurate projection possible.
Your Data Checklist for a Pro Forma Analysis
To build an accurate Pro Forma, the buyer will require comprehensive, standardized financial and operational data. Being unprepared for these requests is a major red flag that can slow down or devalue the deal.
Here is a checklist of the core data you will need to provide.
Standardized Financial Data
Buyers need to normalize your financials to compare them accurately. Be prepared to provide:
- Historical Financials: Income Statements (P&Ls) for the past five years and your most recent Balance Sheet.
- Itemized Revenue Breakdown:
- Commercial Lines Commissions
- Personal Lines Commissions
- Life & Health Commissions
- Contingent Income
- Fee Income & Other Income
- Itemized Expense Breakdown:
- Compensation: Executive/Owner Compensation, Sales Salaries & Commissions, Office/Staff Compensation, Employee Benefits, Payroll Taxes, and Pension/Profit Sharing.
- Administrative: Accounting/Legal, Advertising, Automation/Data Processing, Depreciation, Insurance (P&C, E&O), Interest, Rent, and Utilities.
Operational and Productivity Data
Buyers are not just acquiring your book; they are acquiring your team and its efficiency. They will benchmark your productivity with data like:
- Personnel Data: The number of Agency Owners, Producers, and Support Staff (broken down by Commercial Lines AMs, Personal Lines AMs, etc.).
- Productivity Standards: Key ratios like Commission Per Person and Revenues Per Person. This data proves the value and efficiency of your workforce.
Critical Carrier Data
This is arguably the most critical part of the Pro Forma analysis. For your top 10-12 carriers (or all carriers making up 80% of your commission), you must provide:
- Annual Written Premium: The total premium you wrote with that carrier in the last 12 months.
- Minimum Premium for Contingency: The premium volume required to qualify for their profit-sharing bonus.
- Paid Claims: The total dollar amount of claims paid by the carrier for your book of business in the same 12-month period (this is used to calculate your loss ratio).
Gathering and organizing these documents before you go to market is the single best way to build trust, demonstrate transparency, and ensure the buyer’s analysis accurately reflects your agency’s true value.
How Internal Benchmarking Predicts the Pro Forma
Internal benchmarking (comparing your agency to industry peers) is the best way to predict what a buyer’s Pro Forma analysis will uncover. Benchmarking identifies financial variances that you can fix before a buyer finds them.
Identifying Variances Before the Buyer Does
A buyer’s Pro Forma will normalize your expenses and flag risks. If you benchmark first, you will not be surprised.
- Inflated Owner Compensation: Your internal benchmark might show your compensation is 45% well above average. A buyer’s Pro Forma will immediately normalize this by cutting it to a fair market rate. This can create friction if you have been valuing your agency based on your personal take-home pay. Benchmarking helps you see the agency’s true earning power first.
- Poor Growth or Retention: If your benchmarks show annual revenue growth is well below average or your Retention Ratios are low, a buyer’s Pro Forma will flag this as a major risk. They will project lower future revenue, which directly reduces their valuation.
Use benchmarking as your internal Pro Forma. It helps you spot the exact changes the agency needs to make before you are in a high-stakes negotiation. Fixing these issues beforehand is the best way to defend your price.
Your Preparation is Your Best Defense
The rigor of a buyer’s Pro Forma analysis is precisely why so many unprepared sellers get caught in the Brokerage Gap. When a sophisticated buyer’s financial team faces a seller with no objective data, the buyer controls the entire valuation.
This leads directly to the Valuation Trap, where the buyer dictates the price in 68% of deals. This lack of preparation and representation often results in a 10% to 30% erosion of the agency’s true value.
Don’t Let the Buyer Control the Narrative
Your best defense is to have your own data-backed valuation before you start the conversation. By preparing the data outlined in this guide, you can challenge a buyer’s assumptions with facts.
Leveraging modern, objective tools—like an AI-powered valuation engine—can give you a defensible starting point. This preparation moves you from a position of weakness to one of strength, ensuring you capture the full market worth of the agency you worked so hard to build.
Preparation is your best and only defense against the Valuation Trap.
Get a Data-Backed Valuation First
At Milly Books, we empower agency owners with the data and analysis they need to succeed in an M&A process. We help you understand your value before you talk to a buyer. Do not wait for a buyer to tell you what your agency is worth.
Get your free, instant, and confidential valuation today to begin your data-driven preparation and fortify your agency’s financial health.
Frequently Asked Questions (FAQ)
It is a financial projection created by a buyer during due diligence. It combines the seller’s and buyer’s financials to forecast the future performance, expenses, and profitability of the merged company. The final purchase price is based heavily on this projection.
Contingency income is a major source of profit. By merging two agencies, a buyer might combine their premium volumes to hit a new, higher bonus tier with a carrier. Projecting this new (and highly profitable) income is a critical part of their valuation.
The biggest mistake is being unprepared. This includes having disorganized financials, not knowing key carrier data (like premium minimums for contingencies), or not understanding their own productivity metrics. This forces the buyer to guess, and they will always guess in their own favor.
Normalizing expenses means adjusting your P&L to reflect the true, ongoing cost of running the business. This often involves adjusting an owner’s above-market salary and removing one-time expenses (like a big legal fee or office renovation) to find the real, repeatable profit (EBITDA).
Glossary of Key Terms
- Pro Forma Income Statement: A critical tool used during due diligence to project the combined financial performance of both the buyer and seller agencies, analyzing economies of scale and forecasting future profitability to determine the final valuation.
- Due Diligence: The rigorous process a potential buyer undertakes to verify the financial, operational, and structural health of the selling agency, requiring comprehensive financial and carrier data.
- Contingency Income: Profit-sharing bonuses paid by insurance carriers, which are forecasted in the Pro Forma analysis based on the projected combined premium volume and loss ratios of the merged agencies.
- Loss Ratio: A calculation based on an agency’s Annual Written Premium and Paid Claims data. Buyers analyze this to project future contingency and profit-sharing income.
- Annual Written Premium: The total premium volume the agency writes with a specific carrier, a critical data point needed to calculate loss ratios and assess qualification for contingency bonuses.
- Minimum Premium for Contingency: The lowest annual written premium an agency must meet with a specific carrier to qualify for profit-sharing bonuses, a key piece of information needed for Pro Forma analysis.
- Benchmarking: The process of comparing an agency’s financial, operational, and personnel metrics against industry standards to identify variances and deficiencies.
- Commission Per Person: A personnel standard metric used in benchmarking to measure productivity.
- Valuation Trap: A consequence of poor M&A preparation where the critical purchase price is determined by the buyer in 68% of transactions, compromising the seller’s financial interests.
- Brokerage Gap: A fundamental structural flaw in the M&A landscape where the majority of agencies are excluded from professional representation, increasing their vulnerability during due diligence and financial analysis.
- Value Erosion: The quantifiable loss of wealth, estimated at 10% to 30% of an agency’s value, suffered by unrepresented sellers due to a flawed M&A process.
- Retention Ratio: A key metric measuring the retention of commission for Commercial, Personal, and Life/Health lines.