Anna.Arnold-PlacerHills-09.xlsx - Commission Split...

Commission Split
Calculator
Price Group Current Splits
1 $ - $ 1,499,999 50% 2.5%
2 $ 1,500,000 $ 5,499,999 50% 3.0%
3 $ 5,500,000 $ 9,499,999 45% 3.0%
4 $ 9,500,000 $ 13,499,999 45% 3.0%
Selling Price $ 2,750,000
Commission Rate 6%
Total Commission $ 165,000
PHRE $ 82,500
Fee Calculation $ 2,475
Net Commission $ 80,025
Proposed Split Before Fees After Fees
$ 82,500 $ 80,025
30% $ 49,500 $ 48,015
35% $ 57,750 $ 56,018
40% $ 66,000 $ 64,020
45% $ 74,250 $ 72,023
50% $ 82,500 $ 80,025
55% $ 90,750 $ 88,028
60% $ 99,000 $ 96,030
65% $ 107,250 $ 104,033
Minimum
Price
Maximum
Price
Estimated
Fees

Scenario Summary
Current Values: $50,000 $75,000 $100,000
Changing Cells:
Selling_Price $ 1,709,402 $ 1,709,402 $ 2,564,103 $ 3,418,803
Result Cells:
Selling_Price $ 1,709,402 $ 1,709,402 $ 2,564,103 $ 3,418,803
Total_Commission $ 102,564 $ 102,564 $ 153,846 $ 205,128
PHRE_Commission $ 50,000 $ 50,000 $ 75,000 $ 100,000
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.

Commission Split
Calculator
Price Group Fees
1 $ - $ 1,499,999 50% 2.5%
2 $ 1,500,000 $ 5,499,999 50% 3.0%
3 $ 5,500,000 $ 9,499,999 45% 3.0%
4 $ 9,500,000 $ 13,499,999 45% 3.0%
Selling Price $ 1,709,402
Listing Commission 6%
Total Commission $ 102,564
PHRE Split $ 51,282
Fee Calculation $ 1,282
Net Commission $ 50,000
Minimum
Price