Free Templates · Business Brokerage

Business Broker Commission Calculator (Excel)

A 4-tab, 100% formula-driven Excel workbook comparing Main Street 10% flat commissions, minimum fee floors, Double Lehman (10/8/6/4/2) tiers, seller net proceeds, and broker-agent splits.

Direct download (free, no registration required)

Includes editable blue inputs, standard Excel formulas (SUM, IF, MAX, MIN) compatible with Excel, LibreOffice, and Google Sheets, and 8 live accounting checks in the Controls tab.

Download Excel Calculator Explore The Business Broker →

What the Workbook Computes Dynamically

TabScope & Formulas
Inputs_and_SummaryEditable blue cells for deal price, Main Street flat rate, minimum fee floors, upfront retainer, seller closing costs, and seller note. Side-by-side comparison of 10% Flat, Double Lehman, and Modified 10/8/6 with full Seller Net Proceeds bridge.
Double_Lehman_TiersTranche-by-tranche breakdown ($0-$1M at 10%, $1M-$2M at 8%, $2M-$3M at 6%, $3M-$4M at 4%, above $4M at 2%) plus a 7-deal benchmark table from $200,000 to $5,000,000 including the $3,370,000 Corvale case.
Broker_Agent_EconomicsIn-house vs. 50/50 co-brokered deal waterfall, house split, close-rate-adjusted marketing cost, effective broker hourly rate, and Thornbeck Business Advisors' annual brokerage P&L ($1,404,000 revenue, $429,600 pre-owner profit).
Controls8 live mathematical identity checks returning OK or CHECK to verify tranche reconciliation, fee floors, seller net proceeds, and broker split totals whenever inputs change.

Read the full worked examples behind the calculator

See the step-by-step math for $750,000 and $2,500,000 sales, seller-note fee traps, and close-rate hourly economics in Business Broker Commission Rates: Worked Examples, or study the complete end-to-end transaction in The Business Broker.