Team Profitability Dashboard

10 agents · Annual projection · Real estate commission analysis

Total Revenue

$15.00M

10 agents × HKD 1.5M

Total Expenses

$12.59M

83.9% of revenue

Net Profit

$2.42M

Annual projection

Profit Margin

16.1%

Healthy margin

Scenario Comparison

Revenue vs Expenses vs Net Profit across all scenarios

HKD 1.5MHKD 2.0MHKD 3.0M$0$7.50M$15.00M$22.50M$30.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
Manager Override (Chelsea)$2,250,000$2,250,000
Total$15,000,000$8,025,000$360,000$12,585,000$2,415,000

Manager Override — Chelsea

Based on total team commission: $15,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$2,250,000

Total Manager Payout$3,150,000

Annual Profitability Summary

Total Team Commission$15,000,000
Base Salary Expense$360,000
Operating Cost$4,200,000
Commission Payout$8,025,000
Total Expenses$12,585,000
Annual Net Profit$2,415,000
Net Profit Margin16.1%

Monthly Cumulative Gross Profit

HKD 1.5M scenario — before commission payouts

JanFebMarAprMayJunJulAugSepOctNovDec$0$3.00M$6.00M$9.00M$12.00M
  • Cumulative Profit
  • Income
  • Fixed Cost

Per-Agent Cost vs Retained

HKD 1.5M scenario

ChelseaDianaEuniceAnneCherieJoyComing 1Coming 2Coming 3Coming 4Mgr Override$0$600K$1.20M$1.80M$2.40M
  • 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$15,000,000$20,000,000$30,000,000
Total Base Salary$360,000$360,000$360,000
Total Operating Cost$4,200,000$4,200,000$4,200,000
Total Commission Payout$8,025,000$11,500,000$18,650,000
Manager Override$2,250,000$3,500,000$6,000,000
Total Expenses$12,585,000$16,060,000$23,210,000
Net Profit$2,415,000$3,940,000$6,790,000
Net Profit Margin16.1%19.7%22.6%