Brokerage Contribution Margin Template: What Each Closing Covers

The hypothetical closing below starts with $12,000 in gross commission income and leaves $900 for the brokerage to put toward fixed overhead. This brokerage contribution margin template traces the deductions: agent compensation, referral fees, lead acquisition and other costs, including work on contracts that never close. The remaining contribution must cover rent, salaries and other fixed costs before it becomes profit.

The worksheet uses hypothetical U.S. brokerage figures in dollars. Gather commission disbursement statements, agent and referral agreements, cap balances, lead invoices, transaction-support bills and your overhead budget. Choose one planning period and one perspective: the brokerage or the team operating within it.

Establish which commission revenue you retain

Use the commission credited to your brokerage’s side of the transaction as gross commission income, or GCI. Exclude another brokerage’s compensation; record an outbound referral separately only if it has not already been deducted. For a team within a brokerage, begin with the team’s receipts after host-brokerage charges, then subtract team-member compensation.

Reported revenue can look much larger than the amount available to run the business. In its 2025 Form 10-K, dated February 24, 2026, eXp World Holdings recognizes gross commission revenue at closing and separately reports commissions and other agent-related costs, including revenue share and agent stock compensation. Those definitions illustrate why every compensation obligation matters; its margins are not a benchmark for an independent firm.

Your agreements determine the order of deductions. Check whether a referral fee reduces the amount subject to the agent split or whether the brokerage absorbs it afterward. Confirm which fees the brokerage keeps in full. Our commission economics coverage provides broader context, but the written terms supply your worksheet inputs.

Copy the brokerage contribution margin template

Paste the tab-separated block into cell A1 of a blank spreadsheet. Labels occupy column A; values and formulas occupy column B. Format B4 as a percentage and monetary rows as currency. Enter expenses as positive numbers.

All amounts are invented for illustration. The example assumes the agent receives 80% of GCI after the referral deduction, the brokerage keeps the entire $250 fee, and future lead and failed-file costs average $700 per comparable closing.

GCI for brokerage side    12000
Outbound referral fee    3000
Agent split base    =B1-B2
Agent share    80%
Agent compensation    =B3*B4
Retained transaction fee    250
Brokerage retained revenue    =B1-B2-B5+B6
Incremental support per closing    300
Other per-closing costs    150
Contribution before source costs    =B7-B8-B9
Lead acquisition cost per closing    600
Failed-contract cost per closing    100
Contribution toward overhead    =B10-B11-B12
Fixed overhead for planning period    18000
Other contribution for same period    3000
Remaining overhead    =MAX(0,B14-B15)
Comparable closings needed    =IF(B16=0,0,IF(B13>0,ROUNDUP(B16/B13,0),"No finite break-even"))

The agent receives $7,200. Brokerage retained revenue is $2,050, contribution before source costs is $1,600, and contribution after lead and failed-contract costs is $900.

The split base changes the result. If the agreement instead pays the agent 80% of the full $12,000, change B3 to =B1. Keeping every other assumption unchanged produces negative $1,500 in B13.

B13 is a management estimate of contribution after source-cost allocations, not brokerage profit per closing. Contribution margin covers fixed costs before producing profit. Ask your accountant to reconcile this worksheet with your books and confirm expense timing and classification.

Separate per-closing costs from fixed overhead

Classify each expense by what makes it change. Put a coordinator’s per-file charge below retained revenue; keep a salaried coordinator’s base pay in overhead for the period. Include brokerage-paid transaction marketing, per-closing royalties and compensation incentives where applicable, net of reimbursements not already counted as revenue.

Office rent, base software subscriptions, insurance and management salaries generally belong in overhead within the capacity being modeled. Include compensation for an owner’s management work in the planning budget so unpaid labor does not make the arrangement appear sustainable.

Separate mixed costs. A hypothetical $500 monthly support retainer plus $100 per completed file creates $500 of overhead and $100 of variable cost per closing. The SBA’s break-even guidance, updated October 3, 2024, recommends separating fixed and variable components.

Allocating a fixed bill across closings does not make it variable. If a lead subscription stays fixed during your forecast period, include its cost in B14 and exclude it from B11’s per-closing allocation. Count each expense once. If more closings require another employee, raise overhead at that staffing threshold.

Calculate lead cost per closing across the full cycle

To calculate real estate lead cost per closing, group leads by source and acquisition month—a cohort—and follow that group through its outcomes. Divide the group’s acquisition spend by its resulting closed brokerage sides, including spend on leads that never converted.

For example, assume a fully observed cohort cost $6,000 to acquire and produced 10 closed sides. Its acquisition cost is $600 per closing, the B11 input. If unsuccessful contracts from that cohort also incurred $1,000 in incremental, unrecovered support and marketing charges, B12 is $100. Keep those charges out of the $6,000 numerator and out of overhead. A success-based lead fee belongs in either the referral row or the acquisition row, never both.

Count failed attempts even when the same customer later closes on another property. Include only costs the business actually bears; salaried staff time already covered in overhead should not reappear as an additional cash expense.

Long conversion lags require two views. The cohort view connects acquisition spending to the closings it eventually generates. The monthly cash view shows when bills are paid and commissions arrive. Dividing this month’s advertising spend by this month’s closings can mix different lead populations.

Record acquisition, contract, cancellation, closing and payment dates. Show open leads separately and compare cohorts at similar ages. If a cohort has no closings yet, report spend and pending outcomes rather than a zero acquisition cost. Keep actual results separate from forecasts, and base forecast conversion assumptions on your own observed history. Cohort allocation does not change when expenses belong in the accounting records.

Recalculate contribution as an agent approaches a cap

A cap limits the commission amount an agent contributes to the brokerage under the agreement. Track the remaining balance, reset date, eligible charges and post-cap fees. Last quarter’s average retention may be a poor estimate for the next transaction.

This mechanism appears in eXp’s 2025 filing, which identifies increased agent capping as a factor reducing gross profit. Your own contract determines the effect.

For a hypothetical agreement that caps the brokerage’s split dollar for dollar, suppose only $500 remains before the cap. The uncapped split in the worksheet is $9,000 × 20% = $1,800; the brokerage instead keeps $500 from that split. With the same $250 fee and $1,150 of other costs, contribution becomes negative $400. This assumes the fee does not count toward the cap and no other post-cap charges apply.

For a pending deal, separately examine costs still avoidable. Acquisition spending already incurred is part of the source’s economics but is not a new cash outlay at closing.

Build separate forecasts before the cap, for the crossing transaction and after the cap. For recruiting decisions, include signing incentives and promised support across the expected relationship, with payout dates visible in the cash forecast. Different brokerage business models require different retention assumptions.

Calculate the closings needed to cover overhead

The SBA’s unit break-even formula divides fixed costs by revenue per unit minus variable costs per unit. In this brokerage break-even worksheet, the unit is a comparable closed brokerage side.

In the original example, $18,000 of period overhead less $3,000 of other contribution leaves $15,000 to cover. At $900 each, the worksheet rounds $15,000 ÷ $900 up to 17 closings. Other contribution means revenue after its associated variable costs, counted once in the same period.

That estimate assumes similar commissions, splits, source costs and available capacity. B11 and B12 must represent costs expected to scale with those future closings; committed costs belong in overhead. For a finite existing lead cohort, forecast its total remaining revenue and costs directly rather than assuming it can supply unlimited comparable closings.

When business differs materially by agent or source, calculate each group separately and sum its expected contribution. Preserve negative contributions. If contribution per closing is zero or negative while overhead remains uncovered, additional identical closings cannot produce break-even.

Before renewing a lead contract or offering a recruiting package, reconcile one completed transaction to its disbursement statement and reconcile one mature cohort’s costs. Rerun the forecast with the actual cap schedule and a lower conversion assumption. Then check whether cash lasts until the projected commissions arrive.