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
| Tab | Scope & Formulas |
|---|---|
| Inputs_and_Summary | Editable 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_Tiers | Tranche-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_Economics | In-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). |
| Controls | 8 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.