Tabellab
Career & Interview Prep Beginner

Real Estate Agent Business Math: Commission Splits, Caps, GCI Goals & Expenses

Run a real estate career like a business in a spreadsheet: side commissions and GCI, brokerage splits with an annual cap, an income goal turned into deals, a lead funnel with cost per closing, expenses, team and referral splits, a quarterly tax set-aside and a plan-vs-actual dashboard, every cell checked as you go. Fictional agent and brokerage, illustrative numbers, not legal or tax advice.

8 lessons 8 labs 2 h Certificate

The first lesson is free — no account needed.

About this course

A real estate agent business course that runs the year of one fictional agent, Maya Ortiz of Bluefinch Realty, in a spreadsheet, for new and experienced agents, team leads and brokers. You work out the commission and the agent's side of six closed deals and total the gross commission income, run a brokerage split with an annual cap deal by deal, turn an income goal into the GCI and the number of deals needed per year and month, push five lead sources through the funnel to a cost per closing, annualise marketing and desk expenses, take team deals through referral fee, brokerage and team split, set aside an illustrative quarterly tax reserve, and compare plan and actual GCI on a dashboard with a chart. Fictional agent and brokerage. Commissions are negotiable and tax rules vary. Not legal, tax or financial advice. The first lab is free.

Lessons

  1. Commission on a Sale: Listing Side, Buyer Side & Your GCILab14 minFree
  2. Brokerage Split & Cap: When You Keep 100 %Lab16 min Pro
  3. From Income Goal to GCI to Deals NeededLab15 min Pro
  4. The Lead Funnel: Leads → Appointments → Signed → ClosedLab15 min Pro
  5. Marketing & Desk Expenses: Annual Cost, Fixed vs VariableLab14 min Pro
  6. Team Splits & Referral Fees: Who Gets WhatLab16 min Pro
  7. Quarterly Income & a Tax Set-Aside (Illustrative)Lab13 min Pro
  8. Annual Business Plan Dashboard: Plan vs Actual (Chart)Lab17 min Pro