I need to create a formula to calculate agent commissions For example:
Option 1
Agent 95%
Brokerage 4%
TC 1%
Option 2
Agent 85%
Brokerage 5%
TC 7%
Investment fund 3%
Option 3
Agent 75%
Brokerage 5%
TC 2.5%
Investment fund 2.5%
Option 4 - referral commissions
Agent 40%
Brokerage 5%
Referring Agent 50%
TC 2.5%
Investment fund 2.5%
Option 1 has a 10,000 Commission cap - the amount of commission each agents pays needs to be tracked and once an agent has reached 10,000 paid to the brokerage they will only pay a file fee of $200