Free Excel templates

A free real estate commission split and cap calculator in Excel

A residential brokerage's standard plan, a 70/30 split with a company dollar cap, a transaction fee after the cap and a monthly fee, worked through for an average side and for three agents at different production levels.

At an average sale price of $421,000 and a blended rate of 2.39%, a side brings $10,066.11 of GCI. The $24,000 cap is reached at $80,000 of GCI, on side 8. A 25-side agent pays the brokerage $29,390; a 3.8-side agent pays $12,615.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 181 free models.

Real_Estate_Commission_Split_and_Cap_Calculator.xlsx (14 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Real Estate Brokerage Owner, which explains the method behind it, chapter by chapter.

Get the book on Google Play →

Or the DRM-free PDF, $19.99 →

Want every model at once?

The Financial Model Library: all 182 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

4 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

GCI per side
Cap
Company dollar per agent per fiscal year ($)
Agent year
Checks

What the worked case returns

MeasureValue
Average GCI per side$10,066.11
Brokerage share until the cap30%
Cap, company dollar per agent per year$24,000
GCI at which the cap is reached$80,000
Cap reached on side8
Top agent: GCI$251,653
Top agent: company revenue$29,390
Middle agent: company revenue$25,890
Part-time agent: company revenue$12,615

Until the cap, the brokerage keeps its share of every commission; after it, only the transaction fee per side. The monthly fee is paid by everyone. The top agent produces more than six times the GCI of the part-time agent but pays the brokerage little more than twice as much.

How to use it on your own case

  1. Enter the average sale price, the share of listing sides and the commission rates on Inputs.
  2. Enter the brokerage share, the cap, the transaction fee after the cap and the monthly fee.
  3. Enter the sides each agent closes in a year.
  4. Read GCI per side, the side on which the cap is reached and the company revenue from each agent.

Questions people ask about it

What is a commission split with a cap?

The brokerage keeps a share of each commission, say 30%, until its share for the year reaches a fixed cap; after that the agent keeps 100% less a small transaction fee per side.

How do you calculate when an agent caps?

Divide the cap by the brokerage share to get the GCI at which the cap is reached, then divide by the average GCI per side to get the number of sides.

What is company dollar?

The brokerage's share of gross commission income after paying agents, before the brokerage's own expenses.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of The Real Estate Brokerage Owner go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Real Estate Brokerage Owner. See the book.