Excel work 3 hrs
Vincent666
Linrui.Zhang-PlacerHills-08.xlsxTier 2
| Commission Split | ||||
| Calculator | ||||
| Price Tier | Minimum Price | Maximum Price | Commission Split | Fees |
| 1 | $ - 0 | $ 1,499,999 | 25% | 9.0% |
| 2 | $ 1,500,000 | $ 5,499,999 | 35% | 11.0% |
| 3 | $ 5,500,000 | $ 9,499,999 | 45% | 12.5% |
| 4 | $ 9,500,000 | $ 13,499,999 | 55% | 13.5% |
| Selling Price | $ 4,500,000 | |||
| Listing Commission | 6% | |||
| Total Commission | $ 270,000 | |||
| PHRE Split | $ 94,500 | |||
| Fee Calculation | $ 10,395 | |||
| Net Commission | $ 84,105 | |||
| Possible Rates | Split | Net Pay | ||
| $ 94,500.00 | $ 84,105.00 | |||
| 25% | ||||
| 30% | ||||
| Tier 2 | 35% | |||
| 40% | ||||
| 45% | ||||
| 50% | ||||
| 55% | ||||
| 60% |
Scenario Summary 4
| Scenario Summary | ||||||
| Current Values: | 50,000 | 75,000 | 100,000 | |||
| Created by Microsoft Office User on 11/6/2019 | Created by Microsoft Office User on 11/6/2019 | Created by Microsoft Office User on 11/6/2019 | ||||
| Changing Cells: | ||||||
| Selling_Price | $ 2,616,431 | $ 2,616,431 | $ 3,924,647 | $ 5,232,862 | ||
| Result Cells: | ||||||
| Selling_Price | $ 2,616,431 | $ 2,616,431 | $ 3,924,647 | $ 5,232,862 | ||
| Total_Commission | $ 156,986 | $ 156,986 | $ 235,479 | $ 313,972 | ||
| 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. |
Price Solver
| Commission Split | ||||
| Calculator | ||||
| Price Tier | Minimum Price | Maximum Price | Commission Split | Fees |
| 1 | $ - 0 | $ 1,499,999 | 25% | 9.0% |
| 2 | $ 1,500,000 | $ 5,499,999 | 35% | 11.0% |
| 3 | $ 5,500,000 | $ 9,499,999 | 45% | 12.5% |
| 4 | $ 9,500,000 | $ 13,499,999 | 55% | 13.5% |
| Selling Price | $ 2,616,431 | |||
| Listing Commission | 6% | |||
| Total Commission | $ 156,986 | |||
| PHRE Split | $ 54,945 | |||
| Fee Calculation | $ 4,945 | |||
| Net Commission | $ 50,000 | |||
| Fee percentage is calculated on PHRE Split | ||||
Sales Forecast
| November 7 | |||||||
| Address | City | Sq Ft | Sale Date | Sale Price | Sale Price | ||
| 3420 Milburn Street | Rocklin | 1900 | 8/9/19 | $228,900 | |||
| 2128 Wedgewood | Roseville | 1184 | 8/16/19 | $345,000 | Mean | 370593.181818182 | |
| 4336 Newland Heights Drive | Rocklin | 1840 | 8/23/19 | $327,000 | Standard Error | 19986.6076090226 | |
| 131 Aeolia Drive | Auburn | 1905 | 8/30/19 | $385,000 | Median | 365000 | |
| 12355 Krista Lane | Auburn | 2234 | 9/6/19 | $260,000 | Mode | ERROR:#N/A | |
| 1096 Kinnerly Lane | Lincoln | 1948 | 9/13/19 | $238,000 | Standard Deviation | 93745.4993147666 | |
| 272 Lariat Loop | Lincoln | 1571 | 9/20/19 | $265,900 | Sample Variance | 8788218641.7749 | |
| 1255 Copperdale | Auburn | 1456 | 9/27/19 | $237,000 | Kurtosis | -1.2325104176 | |
| 324 Center Point | Roseville | 1480 | 10/4/19 | $319,000 | Skewness | 0.019390093 | |
| 411 Marion Street | Auburn | 1950 | 10/11/19 | $315,000 | Range | 294100 | |
| 17523 Oleander | Sacramento | 2100 | 10/18/19 | $415,000 | Minimum | 228900 | |
| 1044 Lake Street | Elk Grove | 1755 | 10/25/19 | $505,500 | Maximum | 523000 | |
| 15802 Centennial | Davis | 1950 | 11/1/19 | $340,000 | Sum | 8153050 | |
| 14313 Clearview | Sacramento | 2200 | 11/8/19 | $440,000 | Count | 22 | |
| 12222 South Ann Street | Elk Grove | 2100 | 11/15/19 | $425,000 | Largest(1) | 523000 | |
| 2330 West 120 Street | Davis | 1700 | 11/22/19 | $310,000 | Smallest(1) | 228900 | |
| 7240 Westbrook Drive | Sacramento | 1900 | 11/29/19 | $523,000 | Confidence Level(95.0%) | 41564.425892863 | |
| 419 Harlem Avenue | Elk Grove | 2000 | 12/6/19 | $500,000 | |||
| 9023 Evergreen Lane | Davis | 1850 | 12/13/19 | $435,750 | |||
| 4230 Madison Street | Sacramento | 1900 | 12/20/19 | $475,000 | |||
| 1330 Harrison Street | Elk Grove | 2100 | 12/27/19 | $465,000 | |||
| 401 Lombard Avenue | Davis | 1650 | 1/3/20 | $398,000 |
