7.3 Rent Roll Analysis, Escalations, and Percentage Rent

7.3 Rent Roll Analysis, Escalations, and Percentage Rent

To develop a rigorous income projection, the Certified General Appraiser must master the audit of commercial rent rolls, evaluate inflation escalation clauses, and accurately calculate retail percentage rent using natural and unnatural breakpoints.

---

1. Anatomy and Comprehensive Audit of a Commercial Rent Roll

A certified commercial rent roll contains essential contractual parameters for every tenant suite in the building:

+-------------------------------------------------------------------------+
|                   ANATOMY OF A COMMERCIAL RENT ROLL                     |
+-------------------------------------------------------------------------+
| 1. Tenant Legal Name & Trade Name (DBA)                                 |
| 2. Suite / Unit Identification & Physical Location                      |
| 3. Leased Area: Usable SF vs. Rentable SF (BOMA Standard)               |
| 4. Lease Commencement Date & Expiration Date                            |
| 5. Current Contract Base Rent ($/SF/Year and $/Month)                   |
| 6. Scheduled Rent Steps & Escalation Formulae                           |
| 7. Expense Recovery Structure (Full Service Gross, Modified Gross, NNN) |
| 8. Renewal, Expansion, Contraction, and Early Termination Options       |
| 9. Security Deposit & Letter of Credit (LOC) Collateral                 |
+-------------------------------------------------------------------------+

The Appraiser's Rent Roll Audit Checklist

When auditing a commercial rent roll during due diligence, the appraiser must verify:

1. Executed Leases vs. Rent Roll Entries: Verify that the rent roll reflects the latest executed amendments, renewals, and side letters rather than outdated original lease agreements.
2. BOMA Measurement Verification: Confirm whether leased areas reflect Usable Area (actual physical space occupied by tenant furniture and personnel) or Rentable Area (usable space plus a pro-rata share of shared building core spaces like main lobbies, elevator banks, and public restrooms).
   • Common Area Add-On Factor (Core Factor): $\text{Rentable Area} = \text{Usable Area} \times (1 + \text{Add-On Factor})$
   • A discrepancy between building gross leasable area and the sum of rent roll suite square footages signals phantom space, incorrect measurements, or unrecorded expansions.
3. Concessions and Free Rent: Identify unexpired rent abatements (free rent periods), tenant improvement allowances, or cash allowances that temporarily reduce effective collections below scheduled contract rent.
4. Tenant Options and Termination Rights:
   • Option to Renew: Does the renewal rent adjust to "Fair Market Value (FMV)" or a fixed rate? Fixed below-market renewal options suppress property value.
   • Contraction or Kick-Out Rights: Does the tenant have the right to terminate early if sales fall below a specific threshold (common in retail co-tenancy clauses)?
   • Right of First Refusal (ROFR) / Right of First Offer (ROFO): Grants existing tenants priority to lease adjacent suites, potentially limiting landlord leasing flexibility.

---

2. Commercial Rent Escalation Mechanisms

Because commercial leases often extend for 5, 10, or 20+ years, landlords incorporate rent escalation clauses to protect net income against monetary inflation and increasing market rates:

+-------------------------------------------------------------------------+
|                     RENT ESCALATION MECHANISMS                          |
+------------------------------------+------------------------------------+
|        FIXED STEP INCREASES        |        INDEX-LINKED (CPI)          |
|   - Predetermined $/SF steps       |   - Tied to Consumer Price Index   |
|   - Fixed percentage annual bumps  |   - Constrained by Caps & Floors   |
+------------------------------------+------------------------------------+
|       PORTER'S WAGE ESCALATION     |     OPERATING EXPENSE PASS-THROUGH |
|   - Tied to union labor wage rates |   - Direct recovery of actual      |
|   - Traditional New York office    |     operating expense increases    |
+------------------------------------+------------------------------------+

1. Fixed Step Escalations

• Dollar Steps: Rent increases by a stated dollar amount at specified milestones (e.g., $25.00/RSF in Years 1–2, $27.00/RSF in Years 3–4, and $29.00/RSF in Year 5).
• Percentage Steps: Rent compounds annually by a fixed percentage (e.g., 2.5% to 3.5% per year), providing predictable cash flow forecasting.

2. Index-Based Escalations (Consumer Price Index - CPI)

• Mechanics: Rent adjustments are pegged to an external economic inflation metric, typically the Consumer Price Index for All Urban Consumers (CPI-U) published by the U.S. Bureau of Labor Statistics (BLS): $\text{New Contract Rent} = \text{Base Rent} \times \left( 1 + \frac{\text{CPI}_{\text{Current}} - \text{CPI}_{\text{Base}}}{\text{CPI}_{\text{Base}}} \right)$
• Caps and Floors:
  • Cap (Ceiling): Protects the tenant by capping the maximum annual increase (e.g., "not to exceed 4.0% in any calendar year").
  • Floor (Collar): Protects the landlord by guaranteeing a minimum annual increase (e.g., "not less than 1.5% in any calendar year"), even during deflationary periods.

3. Porter's Wage Escalation

• Historical Background: A traditional office escalation clause developed in high-density unionized office markets (such as Manhattan). Instead of indexing general inflation, rent escalates based on changes in the hourly wage rate paid to building cleaning staff (porters) under union master agreements.
• Formula Example: A "1-for-1" or "penny-for-penny" clause provides that for every $0.10 increase in the hourly union porter wage, the tenant's annual rent increases by $0.10 per square foot.

---

3. Retail Leases and Percentage Rent

In retail properties (regional shopping malls, lifestyle centers, and community shopping strips), leases frequently feature a two-part rental structure: Base Minimum Rent plus Percentage Rent.

+-------------------------------------------------------------------------+
|                     RETAIL PERCENTAGE RENT STRUCTURE                    |
+-------------------------------------------------------------------------+
|   TOTAL RENT = Base Minimum Rent + Overage (Percentage) Rent            |
|                                                                         |
|   - Base Minimum Rent: Guaranteed monthly floor payment                 |
|   - Percentage Rent: Paid only when Gross Retail Sales exceed           |
|     an agreed-upon sales threshold called the BREAKPOINT                |
+-------------------------------------------------------------------------+

The Economic Rationale for Percentage Rent

• Landlord Advantage: Allows the property owner to participate directly in the retail tenant's commercial success and sales upside without assuming direct retail operational management.
• Tenant Advantage: Lowers the tenant's fixed overhead burden during economic downturns or slow sales cycles, tying high rental expenditures directly to high cash register revenue.
• Gross Sales Audits: Retail leases require tenants to submit certified monthly sales reports and annual audited tax statements. Gross sales generally exclude returned merchandise, sales taxes collected for the government, and employee discounts.

---

4. Breakpoints: Natural vs. Unnatural (Negotiated)

The Breakpoint is the gross sales hurdle above which percentage rent begins to accrue. The appraiser must distinguish between natural and unnatural breakpoints:

1. The Natural Breakpoint

• Definition: The exact gross sales volume at which the agreed percentage rent rate, when applied to total sales, produces a dollar amount exactly equal to the base minimum rent.
• Mathematical Derivation: $\text{Natural Breakpoint} = \frac{\text{Annual Base Minimum Rent}}{\text{Percentage Rent Rate}}$
• Overage Rent Calculation: $\text{Overage Rent} = (\text{Actual Gross Sales} - \text{Natural Breakpoint}) \times \text{Percentage Rent Rate}$ (Applicable only when Actual Gross Sales > Natural Breakpoint; otherwise Overage Rent = $0.00).
• The "Greater Of" Equivalence: When a natural breakpoint is utilized, the total rent paid by the tenant is mathematically identical to: $\text{Total Rent} = \max(\text{Annual Base Rent}, \text{Actual Gross Sales} \times \text{Percentage Rent Rate})$

2. Unnatural (Negotiated) Breakpoints

• Definition: An arbitrary gross sales dollar threshold established through commercial negotiation that does not equal $\frac{\text{Base Rent}}{\text{Percentage Rate}}$.
• Strategic Positioning:
  • Breakpoint Set HIGHER Than Natural Breakpoint (Favors Tenant): The retailer must achieve a higher level of retail sales before the landlord begins collecting overage rent.
  • Breakpoint Set LOWER Than Natural Breakpoint (Favors Landlord): The landlord begins collecting overage rent earlier, before the percentage rate fully matches the base rent.
• Calculation Rule: When an unnatural breakpoint is specified, you must use the negotiated breakpoint dollar figure directly; do not compute a natural breakpoint.

---

5. Comprehensive Worked Mathematical Walkthroughs

Case Study 1: Retail Tenant with Natural Breakpoint

• Tenant: Specialty Athletic Apparel Retailer
• Store Size: 4,000 SF of Gross Leasable Area (GLA)
• Base Minimum Rent: $45.00/SF/year (4,000 SF × $45.00 = $180,000/year)
• Percentage Rent Rate: 6.0% of gross sales over natural breakpoint

Step 1: Calculate Natural Breakpoint

$\text{Natural Breakpoint} = \frac{\text{Annual Base Rent}}{\text{Percentage Rate}} = \frac{\$180{,}000}{0.06} = \mathbf{\$3{,}000{,}000}$

Scenario A: Gross Retail Sales = $2,700,000 (Below Breakpoint)

• Gross sales did not exceed the natural breakpoint of $3,000,000.
• Overage Rent = $0.00
• Total Annual Rent Paid = Base Rent = $180,000

Scenario B: Gross Retail Sales = $3,800,000 (Above Breakpoint)

• Excess Sales over Breakpoint = $3,800,000 - $3,000,000 = $800,000
• Overage Rent = $800,000 × 0.06 = $48,000
• Total Annual Rent Paid = Base Rent ($180,000) + Overage Rent ($48,000) = $228,000
• Verification via "Greater Of" Formula: 6% × $3,800,000 = $228,000 (Exact match!).

---

Case Study 2: Retail Tenant with Unnatural (Negotiated) Breakpoint

• Tenant: Luxury Jewelry Boutique
• Store Size: 2,500 SF of GLA
• Base Minimum Rent: $120,000/year ($48.00/SF)
• Percentage Rent Rate: 5.0%
• Natural Breakpoint would be: $120,000 / 0.05 = $2,400,000.
• Negotiated Unnatural Breakpoint: Due to tenant bargaining power, the lease specifies a negotiated breakpoint of $3,000,000 ($600,000 higher than the natural breakpoint).
• Annual Gross Retail Sales: $3,600,000

Calculation:

1. Identify Relevant Breakpoint: Use the negotiated breakpoint of $3,000,000.
2. Calculate Excess Sales: $\text{Excess Sales} = \$3{,}600{,}000 - \$3{,}000{,}000 = \mathbf{\$600{,}000}$
3. Calculate Overage Rent: $\text{Overage Rent} = \$600{,}000 \times 0.05 = \mathbf{\$30{,}000}$
4. Calculate Total Rent: Total Rent = Base Rent ($120,000) + Overage Rent ($30,000) = $150,000

---

Case Study 3: CPI Escalation with Caps and Floors

• Tenant: Regional Corporate Headquarters occupying 40,000 RSF.
• Current Base Rent: $30.00/RSF/year ($1,200,000 annually).
• Escalation Clause: Annual rent adjustment based on the percentage change in CPI-U, subject to a 4.0% Cap (Maximum) and a 2.0% Floor (Minimum).