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

• 4

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 4 out of 4 pages.

Commission SplitCalculatorPrice GroupCurrent Splits1\$-\$1,499,99950%2.5%2\$1,500,000 \$5,499,99950%3.0%3\$5,500,000 \$9,499,99945%3.0%4\$9,500,000 \$13,499,99945%3.0%Selling Price\$2,750,000Commission Rate6%Total Commission\$165,000PHRE\$82,500Fee Calculation\$2,475Net Commission\$80,025Proposed SplitBefore FeesAfter Fees\$82,500 \$80,02530% \$49,500 \$48,01535% \$57,750 \$56,01840% \$66,000 \$64,02045% \$74,250 \$72,02350% \$82,500 \$80,02555% \$90,750 \$88,02860% \$99,000 \$96,03065%\$107,250 \$104,033MinimumPriceMaximumPriceEstimatedFees
Scenario SummaryCurrent Values:\$50,000\$75,000\$100,000Changing Cells:Selling_Price\$1,709,402 \$1,709,402 \$2,564,103 \$3,418,803Result Cells:Selling_Price\$1,709,402 \$1,709,402 \$2,564,103 \$3,418,803Total_Commission\$102,564 \$102,564 \$153,846 \$205,128PHRE_Commission\$50,000 \$50,000 \$75,000 \$100,000Notes:Current Values column represents values of changing cells attime Scenario Summary Report was created.Changing cells for eachscenario are highlighted in gray.
Commission SplitCalculatorPrice GroupFees1\$-\$1,499,99950%2.5%2\$1,500,000 \$5,499,99950%3.0%3\$5,500,000 \$9,499,99945%3.0%4\$9,500,000 \$13,499,99945%3.0%Selling Price\$1,709,402Listing Commission6%Total Commission\$102,564PHRE Split\$51,282Fee Calculation\$1,282Net Commission\$50,000MinimumPrice
End of preview. Want to read all 4 pages?

Course Hero member to access this document

Term
Fall
Professor
NoProfessor
Tags
Sacramento California, Sacramento metropolitan area, Net Commission, Roseville California, price group

Unformatted text preview: Sq Ft Closing Date Sale Price 350000 3420 Milburn Street Rocklin 1900 10/27/2021 \$570,000 400000 1 2128 Wedgewood Roseville 1184 11/3/2021 \$355,200 450000 2 4336 Newland Heights Drive Rocklin 1840 11/10/2021 \$552,000 500000 2 131 Aeolia Drive Auburn 1905 11/17/2021 \$571,500 550000 2 12355 Krista Lane Auburn 2234 11/24/2021 \$670,200 600000 10 1096 Kinnerly Lane Lincoln 1948 12/1/2021 \$584,400 650000 3 272 Lariat Loop Lincoln 1571 12/8/2021 \$471,300 700000 2 1255 Copperdale Auburn 1456 12/15/2021 \$436,800 750000 324 Center Point Roseville 1480 12/22/2021 \$444,000 800000 411 Marion Street Auburn 1950 12/29/2021 \$585,000 More 17523 Oleander Sacramento 2100 1/5/2022 \$630,000 1044 Lake Street Elk Grove 1755 1/12/2022 \$526,500 15802 Centennial Davis 1950 1/19/2022 \$585,000 14313 Clearview Sacramento 2200 1/26/2022 \$660,000 12222 South Ann Street Elk Grove 2100 2/2/2022 \$630,000 2330 West 120 Street Davis 1700 2/9/2022 \$510,000 7240 Westbrook Drive Sacramento 1900 2/16/2022 \$570,000 419 Harlem Avenue Elk Grove 2000 2/23/2022 \$600,000 9023 Evergreen Lane Davis 1850 3/2/2022 \$555,000 4230 Madison Street Sacramento 1900 3/9/2022 \$570,000 1330 Harrison Street Elk Grove 2100 3/16/2022 \$630,000 401 Lombard Avenue Davis 1650 3/23/2022 \$495,000 350000 400000 450000 500000 550000 600000 650000 700000 750000 800000 More 2 4 6 8 10 12 Sales by Price Group Selling Price Number of Sales...
View Full Document