14.1 Commission Splits, Net Sheets & Profit/Loss Math

14.1 Commission Splits, Net Sheets & Profit/Loss Math

Exam Focus: Broker candidates must master the mathematics of real estate transactions. On the Texas Real Estate Broker Examination, calculation questions require precision, an understanding of multi-tiered commission disbursements, and algebraic restructuring for seller net sheets and profit/loss scenarios. Remember: under the Texas Real Estate License Act (TRELA, Texas Occupations Code § 1101.806), only a licensed broker may receive a commission directly from a principal, and sales agents may only receive compensation from their sponsoring broker.

---

1. Commission Calculations & Multi-Tier Brokerage Splits

Under federal antitrust laws (the Sherman Antitrust Act of 1890), brokerage commission rates are never fixed by law, trade associations, or local real estate boards. All commission rates and fee structures are strictly negotiable between the broker and the principal.

The Fundamental Commission Formula Trio

The standard commission formula is derived from the basic percentage triangle (Part = Total × Rate):

$\text{Total Gross Commission} = \text{Sales Price} \times \text{Commission Rate}$

$\text{Sales Price} = \frac{\text{Total Gross Commission}}{\text{Commission Rate}}$

$\text{Commission Rate} = \frac{\text{Total Gross Commission}}{\text{Sales Price}}$

Multi-Tiered Split Disbursements

In modern brokerage operations, a single commission dollar undergoes multiple sequential splits before arriving in the individual agent's bank account. Candidates must calculate these disbursements in the exact chronological order specified by the problem:

┌─────────────────────────────────────────────────────────────────────────────┐
│                     MULTI-TIER COMMISSION DISBURSEMENT FLOW                 │
├─────────────────────────────────────────────────────────────────────────────┤
│                             TOTAL SALES PRICE                               │
│                                     │                                       │
│                                     ▼                                       │
│                          TOTAL GROSS COMMISSION                             │
│                                     │                                       │
│                 ┌───────────────────┴───────────────────┐                   │
│                 ▼                                       ▼                   │
│      LISTING BROKERAGE SHARE                 SELLING BROKERAGE SHARE        │
│      (e.g., 50% of Total)                    (e.g., 50% of Total)           │
│                 │                                       │                   │
│        ┌────────┴────────┐                     ┌────────┴────────┐          │
│        ▼                 ▼                     ▼                 ▼          │
│  Listing Broker    Listing Agent         Selling Broker    Selling Agent    │
│  (e.g., 30%)       (e.g., 70%)           (e.g., 20%)       (e.g., 80%)      │
└─────────────────────────────────────────────────────────────────────────────┘

Step-by-Step Multi-Tier Calculation Example

• Scenario: A commercial-residential property sells for $680,000 with an agreed total commission rate of 6.0%. The listing brokerage and the cooperating (selling) brokerage agree to split the total commission 50/50.
• The listing agent has a 70/30 split with their sponsoring broker (agent receives 70%).
• The selling brokerage charges a 6.0% national franchise fee off the top of their cooperating share before splitting with the selling agent. The selling agent is on an 80/20 split with their sponsoring broker.
• Calculate the net commission earned by each party.

1. Calculate Total Gross Commission: $\text{Total Gross Commission} = \$680,000 \times 0.06 = \$40,800$

2. Calculate Brokerage Co-op Split (50/50): $\text{Listing Brokerage Share} = \$40,800 \times 0.50 = \$20,400$ $\text{Selling Brokerage Share} = \$40,800 \times 0.50 = \$20,400$

3. Calculate Listing Side Disbursements: $\text{Listing Agent Net} = \$20,400 \times 0.70 = \$14,280$ $\text{Listing Sponsoring Broker Net} = \$20,400 \times 0.30 = \$6,120$

4. Calculate Selling Side Disbursements (with Franchise Fee): $\text{Franchise Fee (6\%)} = \$20,400 \times 0.06 = \$1,224$ $\text{Adjusted Selling Brokerage Base} = \$20,400 - \$1,224 = \$19,176$ $\text{Selling Agent Net} = \$19,176 \times 0.80 = \$15,340.80$ $\text{Selling Sponsoring Broker Net} = \$19,176 \times 0.20 = \$3,835.20$

Graduated Commission Caps

Many modern brokerages implement a graduated split structure or a company dollar cap. Under a graduated split, an agent's percentage increases as their Gross Commission Income (GCI) passes designated production thresholds (e.g., 60% on the first $50,000 GCI, 70% on the next $50,000, and 80% on all volume thereafter). Under a cap model, once the broker's retained portion reaches a set annual figure (e.g., $18,000), the agent receives 100% of all subsequent commissions for the remainder of that anniversary year.

Commission Split Calculation Matrix Table

---

2. Seller Net Sheet & Minimum Required Sales Price Math

A Seller Net Sheet is an estimated closing statement prepared by a real estate broker or sales agent to show a property owner their projected net cash proceeds upon closing.

The Algebraic Derivation of Required Sales Price

A common exam question requires finding the minimum gross sales price a seller must accept to pay off all liens, cover transactional closing expenses, pay the agreed brokerage commission, and walk away with a specific net cash amount.

Let $S$ equal the Gross Sales Price. The seller's accounting equation is:

$S = \text{Desired Net Cash} + \text{Mortgage Payoff} + \text{Closing Costs} + \text{Repairs} + (S \times \text{Commission Rate})$

Subtract $(S \times \text{Commission Rate})$ from both sides of the equation:

$S - (S \times \text{Commission Rate}) = \text{Desired Net Cash} + \text{Mortgage Payoff} + \text{Closing Costs} + \text{Repairs}$

Factor out $S$:

$S \times (1 - \text{Commission Rate}) = \text{Total Required Non-Commission Dollars}$

Divide both sides by $(1 - \text{Commission Rate})$:

$\text{Required Sales Price} = \frac{\text{Desired Net Cash} + \text{Mortgage Payoff} + \text{Closing Costs} + \text{Repairs}}{1 - \text{Total Commission Rate}}$

Exam Warning (The 100% Complement Rule): Always divide the total non-commission dollars by the complement of the commission rate $(1 - \text{Rate})$. Never multiply the expenses by $(1 + \text{Rate})$.

Why? If expenses are $100,000 and commission is 6%, multiplying by $1.06$ gives $106,000. But 6% of $106,000 is $6,360, leaving the seller with only $99,640 ($360 short!). Dividing $100,000 by $0.94$ yields the true required price: $106,382.98 ($106,382.98 × 6% = $6,382.98; $106,382.98 - $6,382.98 = $100,000.00).

Step-by-Step Net Sheet Guide & Worked Example

• Problem: A seller wishes to net $115,000 in cash from the sale of their home. The existing first mortgage payoff is $194,500, unpaid accrued property taxes are estimated at $2,800, seller-paid buyer closing cost concessions are $5,000, title and escrow settlement fees are $2,700, and the broker charges a 6.0% commission. What is the minimum sales price required?

┌─────────────────────────────────────────────────────────────────────────────┐
│                     STEP-BY-STEP SELLER NET SHEET CALCULATION               │
├─────────────────────────────────────────────────────────────────────────────┤
│ 1. Desired Net Cash to Seller                      $115,000.00              │
│ 2. Existing First Lien Mortgage Payoff             $194,500.00              │
│ 3. Unpaid Accrued Property Taxes                     $2,800.00              │
│ 4. Seller Concessions (Buyer Closing Costs)          $5,000.00              │
│ 5. Title, Escrow & Settlement Fees                   $2,700.00              │
├─────────────────────────────────────────────────────────────────────────────┤
│ TOTAL NON-COMMISSION OBLIGATIONS                   $320,000.00              │
│ Commission Rate Complement (1.00 - 0.06)                 94.0% (0.94)       │
├─────────────────────────────────────────────────────────────────────────────┤
│ MINIMUM REQUIRED SALES PRICE ($320,000 / 0.94)     $340,425.53              │
└─────────────────────────────────────────────────────────────────────────────┘

• Verification Check:
  • Gross Sales Price: $340,425.53
  • Less 6% Commission ($340,425.53 × 0.06): -$20,425.53
  • Balance remaining: $320,000.00
  • Less non-commission payoffs ($194,500 + $2,800 + $5,000 + $2,700): -$205,000.00
  • Net Cash in Seller's Hands: $115,000.00 (Exact match!)

3. Percentage of Profit and Loss Calculations

Profit and loss calculations evaluate investment performance by measuring the monetary gain or loss against the investor's original capital outlay. In real estate mathematics, the original purchase price (or total cost basis) is ALWAYS the 100% baseline (denominator).

Core Formulas

$\text{Dollar Profit or Loss} = \text{Selling Price} - \text{Original Purchase Cost}$

$\text{Percentage Profit or Loss} = \frac{\text{Dollar Profit or Loss}}{\text{Original Purchase Cost}} \times 100$

$\text{Selling Price} = \text{Original Purchase Cost} \times (1 \pm \text{Profit/Loss \%})$

$\text{Original Purchase Cost} = \frac{\text{Selling Price}}{1 \pm \text{Profit/Loss \%}}$

Worked Scenarios for the Broker Exam

Scenario A: Solving for Original Purchase Cost (Given Sales Price and Profit %)

• Problem: An investor sold an unimproved commercial tract for $517,500, which represented a 15% profit over their initial purchase price. What was the investor's original purchase price?
• Step 1: Recognize that the sales price represents $100% + 15% = 115%$ ($1.15$) of original cost.
• Step 2: Apply the original cost formula: $\text{Original Cost} = \frac{\$517,500}{1 + 0.15} = \frac{\$517,500}{1.15} = \$450,000$
• Verification: $$450,000 \times 0.15 = $67,500$ profit. $$450,000 + $67,500 = $517,500$.

Scenario B: Solving for Original Purchase Cost (Given Sales Price and Loss %)

• Problem: A seller disposed of a residential rental property for $275,500, realizing a 5.0% loss on their original purchase price. What did the seller originally pay for the property?
• Step 1: The sales price represents $100% - 5.0% = 95.0%$ ($0.95$) of the original acquisition price.
• Step 2: Apply the formula: $\text{Original Cost} = \frac{\$275,500}{1 - 0.05} = \frac{\$275,500}{0.95} = \$290,000$
• Verification: $$290,000 \times 0.05 = $14,500$ loss. $$290,000 - $14,500 = $275,500$.

Scenario C: Multi-Step Profit with Capital Additions and Closing Expenses

• Problem: An investor purchased a duplex for $320,000 and invested $45,000 in capital renovations. Two years later, the property sold for $450,000. The seller paid a 6.0% broker commission and $3,000 in title/closing costs. What was the investor's net percentage profit on total capital invested?
• Step 1: Calculate Total Capital Invested (Adjusted Cost Basis): $\text{Cost Basis} = \$320,000 + \$45,000 = \$365,000$
• Step 2: Calculate Net Selling Proceeds: $\text{Commission} = \$450,000 \times 0.06 = \$27,000$ $\text{Net Proceeds} = \$450,000 - \$27,000 - \$3,000 = \$420,000$
• Step 3: Calculate Dollar Profit: $\text{Net Dollar Profit} = \$420,000 - \$365,000 = \$55,000$
• Step 4: Calculate Percentage Profit: $\text{Percentage Profit} = \frac{\$55,000}{\$365,000} \times 100 = 15.0685\% \approx 15.07\%$