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

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Work out the total commission on six closed deals, pick Maya's side of each with IF, total her gross commission income (GCI) and split it by side with SUMIF.
• Run Maya's cap year deal by deal: cumulative GCI, the broker's capped share, what she keeps, and the GCI at which she reaches the cap.
• Turn three income goals into the GCI Maya must earn (with split and cap), the GCI of an average deal and the whole number of deals she needs per year and per month.
• Push five lead sources through a three-step funnel, find the cost per closing of each source, the overall conversion rate and how many leads the plan needs.
• Annualise nine expenses that are billed per month, per year, per listing or per closing with a lookup table, then total them, split out the fixed part and compare them with the planned GCI.
• Take six team deals through the waterfall referral fee → brokerage → team split, find what the buyer's agent and the team lead each earn and how much went out in referral fees.
• Calculate four quarters of net profit, set aside a percentage only of positive quarters, total it and compare it with the set-aside on the full-year profit.
• Compare nine months of actual GCI with the plan, track the cumulative share of the annual goal, project the year at the current pace and chart plan vs actual.