Team Profitability Dashboard

12 agents · Annual projection · Real estate commission analysis

Total Revenue

$18.00M

12 agents × HKD 1.5M

Total Expenses

$15.32M

85.1% of revenue

Net Profit

$2.67M

Annual projection

Profit Margin

14.9%

Healthy margin

Scenario Comparison

Revenue vs Expenses vs Net Profit across all scenarios

HKD 1.5MHKD 2.0MHKD 3.0M$0$9.00M$18.00M$27.00M$36.00M
  • Revenue
  • Expenses
  • Net Profit

Expense Breakdown

HKD 1.5M scenario

  • Base Salary
  • Operating Cost
  • Commission Payout

Agent Commission Breakdown

Per agent annual commission: HKD 1.5M

AgentTypeCommissionPayoutBase SalaryTotal CostRetained
ChelseaMGRManager$1,500,000$900,000$900,000$600,000
DianaSalaried$1,500,000$425,000$180,000$605,000$895,000
EuniceSalaried$1,500,000$425,000$180,000$605,000$895,000
AnneComm. Only$1,500,000$575,000$575,000$925,000
CherieComm. Only$1,500,000$575,000$575,000$925,000
JoyComm. Only$1,500,000$575,000$575,000$925,000
Coming 1Comm. Only$1,500,000$575,000$575,000$925,000
Coming 2Comm. Only$1,500,000$575,000$575,000$925,000
Coming 3Comm. Only$1,500,000$575,000$575,000$925,000
Coming 4Comm. Only$1,500,000$575,000$575,000$925,000
Coming 5Comm. Only$1,500,000$575,000$575,000$925,000
Coming 6Comm. Only$1,500,000$575,000$575,000$925,000
Manager Override (Chelsea)$3,000,000$3,000,000
Total$18,000,000$9,925,000$360,000$15,325,000$2,675,000

Manager Override — Chelsea

Based on total team commission: $18,000,000

Override Tiers

$0 — $5,000,00010.0%
$5,000,000 — $10,000,00015.0%
$10,000,000 — $15,000,00020.0%
$15,000,000+25.0%

Personal Payout (60%)$900,000
Override Payout$3,000,000

Total Manager Payout$3,900,000

Annual Profitability Summary

Total Team Commission$18,000,000
Base Salary Expense$360,000
Operating Cost$5,040,000
Commission Payout$9,925,000
Total Expenses$15,325,000
Annual Net Profit$2,675,000
Net Profit Margin14.9%

Monthly Cumulative Gross Profit

HKD 1.5M scenario — before commission payouts

JanFebMarAprMayJunJulAugSepOctNovDec$0$3.50M$7.00M$10.50M$14.00M
  • Cumulative Profit
  • Income
  • Fixed Cost

Per-Agent Cost vs Retained

HKD 1.5M scenario

ChelseaDianaEuniceAnneCherieJoyComing 1Coming 2Coming 3Coming 4Coming 5Coming 6Mgr Override$0$750K$1.50M$2.25M$3.00M
  • Commission Payout
  • Base Salary
  • Retained

All Scenarios Comparison

Side-by-side comparison of all projection scenarios

MetricHKD 1.5MHKD 2.0MHKD 3.0M
Per Agent Commission$1,500,000$2,000,000$3,000,000
Total Team Commission$18,000,000$24,000,000$36,000,000
Total Base Salary$360,000$360,000$360,000
Total Operating Cost$5,040,000$5,040,000$5,040,000
Total Commission Payout$9,925,000$14,100,000$22,650,000
Manager Override$3,000,000$4,500,000$7,500,000
Total Expenses$15,325,000$19,500,000$28,050,000
Net Profit$2,675,000$4,500,000$7,950,000
Net Profit Margin14.9%18.8%22.1%