Agent Partnership GCI Calculator
Explore what a few more closings could mean for your business.
Set production, partnership, conversion, past-client, vendor, and event assumptions in Workbook. Total GCI Estimate shows the same results, with only additional transactions added.
In the print window, choose “Save as PDF,” then “Save.” If no window opens, open the calculator in its own tab and press Ctrl+P.
GCI = gross commission income, before brokerage splits and expenses. Sample assumptions below are editable, not guaranteed results.
01 Agent estimated yearly production
Workbook controls both views- Total buy-side volume
- —
- Total listing-side volume
- —
- Total estimated volume
- —
- Current annual GCI
- —
Your business today
- Annual closed transactions
- —
- Average commission per closing
- —
- Current annual GCI
- —
From Workbook · These calculated values stay linked. Edit purchase price, units, or commission in Workbook to change them here.
Your connected opportunities
All five results come from the Workbook assumptions and feed this same estimate.
New referral closings
Improved lead conversion
Repeat business & past client referrals
Expanded professional network
Webinars & co-branded events
Current results are shown for comparison but are already part of current GCI. A transaction must appear in only one opportunity section.
02 Return on your partnership
Adjusted partnership feeds your total| Partnership scenario | Buy-side units | Listing-side units | Opportunities | One-side commission (%) | Closing rate | Expected closings | Referral income |
|---|---|---|---|---|---|---|---|
100% partnershipRow 16 · comparison only | — | — | — | — | — | — | |
Adjusted partnershipRow 18 · enter the shared business Used in total | — | — | — | — | — |
Edit One-side commission (%) in the 100% partnership row. The same rate automatically carries to the Adjusted row, annual production, conversion, and Total GCI Estimate. Adjusted partnership always supplies the referral income used in totals.
Opportunities = shared units × opportunities per transaction × introduction rate. Fractional closings are expected averages. The editable 70% rate is applied here, correcting its omission from the original spreadsheet formula.
03 Increase conversion on existing leads
| Current annual leads | Buy-side closings | Current conversion | Increase (percentage points) | Improved conversion | Added closings | Additional volume | Commission | Conversion income |
|---|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — |
A 10-percentage-point increase means 20% becomes 30%, not 22%. Current closings come from annual buy-side units above; improved conversion cannot exceed 100%.
Keep the lead pools separate: this row is for existing leads only. Do not include the new introductions already modeled in the partnership rows.
For the sections below, “current” means the last 12 months and “target” means the next 12 months. Past-client and event targets match current inputs until you edit a target. Closing percentages start at an editable 33% planning assumption, not a promised result.
04 Past Clients
Repeat business and referralsRepeat buyers count as resulting transactions. Referrals are introductions and use the editable closing percentage. Targets below current performance add zero, not negative income.
05 Vendor Referral Partners
Aim for at least one referral back per vendorProjected transactions = vendors × target referrals per vendor × closing percentage. Current vendor transactions are already in current GCI and are subtracted before improvement is added.
06 Events
Webinars and co-branded eventsTransactions per event is editable. Current event transactions are already in current GCI; only the projected improvement feeds Total GCI Estimate.
07 Opportunity improvement summary
- Repeat business & past client referrals
- —
- Expanded professional network
- —
- Webinars & events
- —
Only additional transactions above current results are included. Do not count the same transaction in more than one section.
Your shared annual estimate
Connected in both views- Adjusted partnership referral income
- —
- Conversion income
- —
- Total GCI Estimate extra opportunities
- —
Current GCI covers the whole annual business. Adjusted partnership, one conversion calculation, and three separate extras contribute once each.
Your path to potential growth
Annual gross commission income
Enter valid business numbers to see your chart.
Start with one opportunity. Move a slider to see what an additional closing could mean.
How the numbers work
Annual scenario assumptions
Current results cover the last 12 months; targets cover the next 12 months. Only positive improvement is added. Closing percentages are planning assumptions, not guarantees.
| Opportunity | Current transactions | Projected transactions | Additional transactions | Additional GCI |
|---|