5.3 Adjustment Sequencing and Mathematical Adjustments

5.3 Adjustment Sequencing and Mathematical Adjustments

In the Sales Comparison Approach, mathematical adjustments convert the historical sale prices of comparable properties into value indications for the subject. Applying adjustments in an arbitrary or uncoordinated order produces severe mathematical distortion. Appraisal theory mandates a strict sequential order of adjustments for transactional elements, followed by property adjustments.

---

The Mandatory Sequential Hierarchy of Adjustments

Why Sequence Matters

Transactional adjustments represent external, financial, and contractual variables that alter the true economic exchange price of the comparable sale. Because several of these adjustments are calculated as percentages, the base price to which each percentage is applied determines the resulting dollar adjustment.

For example, applying a 10% market conditions adjustment to an unadjusted sale price that includes $500,000 of favorable seller financing incorrectly inflates the financing premium by 10%. Therefore, transactional adjustments must be executed sequentially, with each step generating an intermediate adjusted price.

The Five-Step Transactional Sequence

$\text{Unadjusted Nominal Sale Price}$ $\downarrow$ $\mathbf{Step\ 1:}\ \text{Real Property Rights Conveyed} \longrightarrow \text{Adjusted Price (Rights)}$ $\downarrow$ $\mathbf{Step\ 2:}\ \text{Financing Terms (Cash Equivalency)} \longrightarrow \text{Adjusted Price (Financing)}$ $\downarrow$ $\mathbf{Step\ 3:}\ \text{Conditions of Sale (Motivations)} \longrightarrow \text{Adjusted Price (Conditions)}$ $\downarrow$ $\mathbf{Step\ 4:}\ \text{Expenditures Immediately After Purchase (Added \$ for \$)} \longrightarrow \text{Adjusted Price (Post-Purchase)}$ $\downarrow$ $\mathbf{Step\ 5:}\ \text{Market Conditions (Time)} \longrightarrow \mathbf{Adjusted\ Price\ for\ Market\ Conditions}$

Property Adjustments (Steps 6 through 10)

Once the Adjusted Price for Market Conditions (also called the Market Conditions Adjusted Base) is established, the remaining property adjustments are applied:

• Step 6: Location and Linkages
• Step 7: Physical Characteristics (Size, age, condition, clear height, loading docks)
• Step 8: Economic Characteristics (Operating expenses, lease terms, tenant credit)
• Step 9: Legal and Zoning Characteristics (FAR, permitted uses)
• Step 10: Non-Realty Components of Value (FF&E, business value)

In standard certified commercial practice, property adjustments are applied additively to the Market Conditions Adjusted Base, unless empirical market data substantiates interactive compounding among specific physical variables.

---

Cash Equivalency Calculations (Financing Terms)

When a seller provides below-market purchase money financing, the buyer pays a premium on the nominal purchase price. Cash equivalency quantifies the cash-equivalent value of that debt by calculating the present value ($PV$) of the contractual loan payments discounted at the prevailing market interest rate for equivalent commercial mortgages.

Mathematical Formulation

$PV_{\text{loan}} = \sum_{t=1}^{n} \frac{PMT_t}{(1 + i)^t} + \frac{BAL_n}{(1 + i)^n}$

$\text{Financing Adjustment (Cash Equivalency Discount)} = PV_{\text{loan at market rate}} - \text{Face Value of Loan}$

Where:

• $PMT_t$ = Periodic mortgage debt service payment under the creative financing terms
• $BAL_n$ = Balloon payment or remaining principal balance at term maturity $n$
• $i$ = Prevailing market mortgage interest rate per period
• $n$ = Total number of compounding periods until loan maturity or anticipated payoff

Detailed Worked Calculation: Below-Market Seller Carryback

Appraisal Problem: A comparable suburban office building sold for a nominal contract price of $5,000,000.

• Cash Down Payment: $1,000,000 (20%)
• Seller Financing: $4,000,000 promissory note
• Contract Terms: 4.0% annual interest-only payments, paid annually for 5 years, with full principal balloon payment due at the end of Year 5.
• Prevailing Commercial Market Terms: Commercial mortgage debt on the date of sale required 7.5% annual interest for 5-year balloon financing.

Step 1: Calculate Contractual Annual Debt Service: $PMT = \$4{,}000{,}000 \times 0.040 = \$160{,}000 \text{ per year}$

Step 2: Discount Scheduled Cash Flows at the Market Rate of 7.5%:

1. Present value of annual interest annuity ($160,000/yr for 5 years at 7.5%): $PV_{\text{annuity}} = \$160{,}000 \times \left[\frac{1 - (1 + 0.075)^{-5}}{0.075}\right] = \$160{,}000 \times 4.045885 = \$647{,}342$
2. Present value of balloon reversion ($4,000,000 at end of Year 5 at 7.5%): $PV_{\text{balloon}} = \frac{\$4{,}000{,}000}{(1 + 0.075)^5} = \$4{,}000{,}000 \times 0.696559 = \$2{,}786{,}236$
3. Total present value of the below-market loan: $PV_{\text{loan}} = \$647{,}342 + \$2{,}786{,}236 = \$3{,}433{,}578$

Step 3: Calculate the Cash Equivalency Adjustment: $\text{Financing Adjustment} = \$3{,}433{,}578 - \$4{,}000{,}000 = -\$566{,}422$

Step 4: Determine Cash Equivalent Sale Price: $\text{Cash Equivalent Price} = \$1{,}000{,}000 \text{ (down payment)} + \$3{,}433{,}578 \text{ (PV of loan)} = \$4{,}433{,}578$ $\text{Or: } \$5{,}000{,}000 \text{ nominal price} - \$566{,}422 \text{ discount} = \$4{,}433{,}578$

---

Expenditures Immediately After Purchase Mechanics

Expenditures immediately after purchase reflect capital costs the buyer knew were required upon acquiring the property. These costs are added dollar-for-dollar to the preceding adjusted price:

$\text{Adjusted Price (Post-Purchase)} = \text{Adjusted Price (Conditions)} + \text{Immediate Capital Outlays}$

If a comparable property transacted for $3,800,000 after adjusting for rights, financing, and conditions of sale, and the buyer immediately spent $200,000 on mandated roof replacement and life-safety fire sprinkler upgrades, the post-purchase adjusted price is:

$\text{Adjusted Price} = \$3{,}800{,}000 + \$200{,}000 = \$4{,}000{,}000$

---

Market Conditions (Time) Adjustment Mechanics

The market conditions adjustment updates the comparable transaction price to reflect changes in value levels between the date of sale and the effective date of appraisal.

The Critical Rule: Contract Date vs. Recording Date

Compounding vs. Simple Calculations

• Simple Monthly Rate: $\Delta P = \text{Base} \times (r \times m)$
• Compound Monthly Rate: $\text{Adjusted Base} = \text{Base} \times (1 + r)^m$ Where $r$ is the monthly market appreciation rate and $m$ is the elapsed months from contract date to effective date.

---

Comprehensive Worked Commercial Adjustment Grid

Subject Property Profile

• Property Type: 50,000 SF Class B Light Industrial Distribution Warehouse
• Effective Date of Value: October 5, 2026
• Property Rights: Fee Simple Estate
• Physical Specifications: 28' clear ceiling height; 6 dock-high loading doors; 1.5 parking stalls/1,000 SF; prime arterial location.

Comparable Sales Data

1. Comparable Sale 1: 48,000 SF warehouse. Sold 12 months ago for $6,000,000 ($125.00/SF). Sold encumbered by an above-market leased fee interest (market adjustment: -5%). Transacted with $200,000 cash-equivalent seller financing premium. Conditions of sale normal. No immediate expenditures. Market conditions appreciating at 0.5% per month (compound). Superior location (-5%). Inferior ceiling height of 22' (+8%).
2. Comparable Sale 2: 52,000 SF warehouse. Sold 6 months ago for $5,720,000 ($110.00/SF). Fee simple. Standard third-party financing. Normal conditions of sale. Buyer immediately spent $260,000 ($5.00/SF) to replace leaking roof membrane. Market appreciation 0.5% per month. Similar location. Inferior loading dock configuration (+5%). Superior building condition (-5%).
3. Comparable Sale 3: 50,000 SF warehouse. Sold 3 months ago for $5,500,000 ($110.00/SF). Fee simple. All cash. Distressed corporate liquidation sale (verified 10% conditions-of-sale discount). No immediate expenditures. Market appreciation 0.5% per month. Inferior secondary access location (+5%). Similar physical specs. Included $100,000 in warehouse pallet racking and material handling equipment (FF&E).

Step-by-Step Mathematical Adjustment Grid

Detailed Mathematical Tracking:

• Comp 1 Market Conditions Base: $114.58 × $(1.005)^{12}$ = $114.58 × 1.061678 = $121.65/SF.
• Comp 2 Market Conditions Base: $115.00 × $(1.005)^6$ = $115.00 × 1.030378 = $118.50/SF.
• Comp 3 Market Conditions Base: $121.00 × $(1.005)^3$ = $121.00 × 1.015075 = $122.83/SF.
• Gross Adjustments (sum of absolute dollar adjustments ÷ unadjusted price): Comp 1 = $33.30 ÷ $125.00 = 26.6%; Comp 2 = ($5.00 + $3.50 + $5.93 + $5.93) = $20.35 ÷ $110.00 = 18.5%; Comp 3 = $20.97 ÷ $110.00 = 19.1%. Comp 2's two offsetting ±5% physical adjustments add to its gross adjustment even though they cancel in the net figure.
• Indicated Value Range for Subject (50,000 SF): $118.50/SF to $126.97/SF, corresponding to a total indicated market value range of $5,925,000 to $6,348,500.