10.3 Comparative Lease Analysis: Effective Rent & Net Present Cost Modeling

10.3 Comparative Lease Analysis: Effective Rent & Net Present Cost Modeling

[!NOTE] The CCIM Comparative Decision Framework: In commercial real estate advisory, practitioners rarely evaluate competing lease proposals with identical structures. When a corporate occupier seeks new office, industrial, or retail facilities, competing landlords submit proposals that diverge across every major economic variable:

• Lease Type: Full Service Gross (FSG) with Base Year expense stops versus Modified Gross (MG) versus Triple Net (NNN).
• Rental Rate Progression: Flat initial rents versus aggressive annual compound step-ups (e.g., 2.5% to 3.5%).
• Concession Packages: Disparate periods of upfront or staggered rent abatement (free rent), varying Tenant Improvement (TI) allowances, space planning stipends, and moving allowances.
• Capital Investment Requirements: Landlord turnkey buildouts versus tenant out-of-pocket capital contributions required at lease commencement.

Evaluating competing proposals simply by comparing quoted nominal face rent (or the simple arithmetic average of annual rents) is a dangerous analytical error. A proposal quoting $30.00/RSF NNN may impose a far greater financial burden on an occupier than a competing proposal quoting $45.00/RSF Full Service Gross once operating pass-throughs, concessions, and out-of-pocket fit-out costs are incorporated. To provide fiduciary-level guidance, CCIM designees utilize Comparative Lease Analysis and Net Effective Rent Modeling.

---

The Anatomy of Commercial Lease Concessions

Landlords utilize concessions to preserve property face rental rates—and by extension, the asset's capitalized terminal value in the eyes of institutional lenders and appraisers—while providing necessary financial relief to attract high-credit tenants:

1. Free Rent (Rent Abatement)

Rent abatement waives the tenant's rental obligation for a specified duration:

• Gross Free Rent: Abates both base rent and operating expense pass-throughs. Standard in Full Service Gross leases.
• Net Free Rent: Abates base rent only; the occupier remains legally obligated to pay its pro rata share of property operating expenses, taxes, and insurance from day one. Standard in NNN leases.
• Timing Mechanics: Upfront free rent (months 1 through 5) provides immediate liquidity relief to the occupier during business relocation and buildout. Spreading free rent throughout the lease term (e.g., one month free in each year) dilutes its present value benefit to the occupier due to the time value of money.

2. Tenant Improvement (TI) Allowances

The TI allowance represents landlord capital contributed toward designing and constructing interior space:

• Turnkey Buildout: The landlord builds the space to agreed architectural specifications at its sole expense, absorbing all construction cost overrun risk.
• Stipulated Cash Allowance ($/RSF): The landlord provides a fixed dollar contribution (e.g., $55.00/RSF). If the tenant's actual interior buildout costs $75.00/RSF, the occupier must fund the remaining $20.00/RSF out-of-pocket at Day 0 ($t = 0$).

3. Additional Concessions

Other incentives include moving expense allowances, architectural space planning stipends, and landlord assumption of existing lease liabilities (lease buyouts).

---

Discount Rate Selection in User Decision Modeling

A critical question in comparative lease underwriting is selecting the appropriate discount rate:

• Investor Perspective: Real estate investors discount cash flows at property-level capitalization rates ($R_o$) or equity hurdle rates (typically 8% to 15%+), reflecting asset-level operational and liquidity risks.
• User Perspective: Corporate occupiers evaluate real estate as an overhead cost center. The analysis measures the corporate cost of occupying space. Therefore, the discount rate applied must reflect the tenant's cost of capital, its Weighted Average Cost of Capital (WACC), or its Incremental Borrowing Rate (IBR).

Underwriting Rule: Discounting corporate lease liabilities at an investor hurdle rate (e.g., 12%) artificially deflates the present value of future lease obligations, understating the true economic commitment. The tenant's corporate borrowing rate or WACC (typically 7% to 10%) must be utilized.

---

Mathematical Formulation: Net Present Cost (NPC) & Net Effective Rent

To compare proposals objectively, the analyst models the complete schedule of tenant cash outflows across each period of the lease term. The quantitative framework follows four sequential steps:

Step 1: Quantify Initial Capital Outlays at Day 0 ($t = 0$)

Calculate tenant out-of-pocket space fit-out costs exceeding the landlord's TI allowance:

$\text{Tenant Out-of-Pocket Outlay}_0 = \max(0, \text{Total Fit-Out Cost per RSF} - \text{Landlord TI Allowance per RSF}) \times \text{Tenant RSF}$

Step 2: Project Net Annual Operating Cash Flows ($t = 1$ to $n$)

For each operating year, sum contractual base rent (net of rent abatements) and tenant operating expense liabilities (NNN reimbursements or increases over base year stops):

$\text{Cash Outflow}_t = \text{Base Rent Paid}_t + \text{Operating Expense Obligations}_t$

Step 3: Compute Net Present Cost (NPC)

Discount all projected net cash outflows to present value at the tenant's corporate cost of capital ($k$):

$\text{NPC} = \text{Out-of-Pocket Outlay}_0 + \sum_{t=1}^{n} \frac{\text{Cash Outflow}_t}{(1 + k)^t}$

Step 4: Calculate Net Effective Rent

While Net Present Cost provides the total discounted dollar cost of a lease commitment, corporate decision-makers require a standardized, annual per-square-foot metric to benchmark competing facilities against company budgets and regional market rates.

Net Effective Rent is the constant annual level annuity payment that yields the exact same Net Present Cost as the actual, uneven schedule of projected lease cash flows when discounted at the tenant's cost of capital.

$\text{Present Value Annuity Factor } (AF_{n, k}) = \frac{1 - (1 + k)^{-n}}{k}$

$\text{Annual Net Effective Rent} = \frac{\text{NPC}}{AF_{n, k}} = \frac{\text{NPC} \times k}{1 - (1 + k)^{-n}}$

$\text{Net Effective Rent per RSF} = \frac{\text{Annual Net Effective Rent}}{\text{Rentable Square Feet (RSF)}}$

Financial Calculator Execution (HP-12C & TI BA II Plus)

Once Net Present Cost (NPC) is calculated:

1. Enter $\text{NPC}$ as $PV$ (with positive sign representing cost).
2. Enter lease term in years as $n$ (or $N$).
3. Enter corporate discount rate as $i$ (or $I/Y$).
4. Set $FV = 0$.
5. Compute $PMT$ to obtain Annual Net Effective Rent.
6. Divide by RSF to obtain Net Effective Rent per RSF.

---

Comprehensive Comparative Case Study: Full Service Gross vs. Triple Net

A corporate enterprise requires 25,000 RSF of Class A office space for a 7-year term. The corporate cost of capital is 8.0%. Turnkey interior space fit-out costs are estimated at $75.00/RSF ($1,875,000 total requirement). The corporate real estate advisor models two competing lease proposals:

Proposal A: Full Service Gross (FSG)

• Base Rent: $45.00/RSF in Year 1, escalating at 3.0% annually thereafter.
• Operating Expenses: Base Year expense stop ($12.00/RSF). Building operating expenses are projected to increase by $0.50/RSF each year starting in Year 2.
• Concessions: 5 months of upfront gross free rent in Year 1 (tenant pays 7 months of Year 1 rent); TI allowance of $55.00/RSF ($1,375,000).
• Tenant Out-of-Pocket TI at $t = 0$: $($75.00 - $55.00) \times 25,000 \text{ RSF} = $500,000$.

Proposal B: Triple Net (NNN)

• Base Rent: $30.00/RSF in Year 1, escalating at 3.0% annually thereafter.
• Operating Expenses: NNN structure. Initial Year 1 operating expenses are $12.00/RSF, increasing by $0.50/RSF each year. Tenant pays 100% of operating expenses from Day 1.
• Concessions: 3 months of upfront net free rent in Year 1 (tenant pays 9 months base rent + 12 months OpEx); TI allowance of $35.00/RSF ($875,000).
• Tenant Out-of-Pocket TI at $t = 0$: $($75.00 - $35.00) \times 25,000 \text{ RSF} = $1,000,000$.

Multi-Year Cash Flow Projection Schedule

Cash Flow Derivations:

• Proposal A Year 1: $($45.00 \times 25,000 \times \frac{7}{12}) + $0 \text{ pass-through} = $656,250$.
• Proposal B Year 1: $($30.00 \times 25,000 \times \frac{9}{12}) + ($12.00 \times 25,000) = $562,500 + $300,000 = $862,500$.

Net Effective Rent Calculation

7-year Present Value Annuity Factor at 8.0%: $AF_{7, 8\%} = \frac{1 - (1.08)^{-7}}{0.08} = \frac{1 - 0.5834904}{0.08} = 5.206370$

Proposal A (Full Service Gross):

$\text{Annual Net Effective Rent}_A = \frac{\$6,594,835}{5.206370} = \$1,266,686/\text{year}$ $\text{Net Effective Rent per RSF}_A = \frac{\$1,266,686}{25,000 \text{ RSF}} = \$50.67/\text{RSF}$

Proposal B (Triple Net):

$\text{Annual Net Effective Rent}_B = \frac{\$6,999,310}{5.206370} = \$1,344,374/\text{year}$ $\text{Net Effective Rent per RSF}_B = \frac{\$1,344,374}{25,000 \text{ RSF}} = \$53.77/\text{RSF}$

Financial Synthesis

Despite Proposal B quoting a seemingly lower starting base rent ($30.00 NNN vs. $45.00 FSG), Proposal A provides superior economic value, delivering $404,475 in Net Present Cost savings ($6,594,835 vs. $6,999,310) and reducing Net Effective Rent by $3.10/RSF per year ($50.67 vs. $53.77).

Proposal A outperforms Proposal B because:

1. It provides $500,000 more in landlord TI allowance, halving the tenant's Day 0 capital outlay.
2. It delivers five full months of gross free rent (saving both base rent and operating expenses).
3. It insulates the occupier from the underlying $12.00/RSF baseline operating expense load through the Base Year stop.

---

CCIM Exam Traps & Common Underwriting Pitfalls

• The Simple Arithmetic Mean Trap: Summing total undiscounted nominal cash flows and dividing by the lease term ($8,914,022 / 7 = $1,273,432/yr for Option A vs. $9,121,848 / 7 = $1,303,121/yr for Option B) completely ignores the time value of money. It undervalues front-loaded concessions and produces mathematically distorted lease rankings.
• Conflating Gross Free Rent with Net Free Rent: In a NNN lease, rent abatement almost universally applies strictly to base rent. The tenant remains legally responsible for paying operating expenses, taxes, and insurance during the free rent period. Failing to budget NNN operating costs during free rent months severely distorts Year 1 cash flow projections.
• Omitting Out-of-Pocket Tenant Fit-Out Costs at Day 0: When a landlord offers a lower TI allowance, the tenant must fund the shortfall with corporate cash at lease execution ($t = 0$). Failing to include Day 0 out-of-pocket TI ignores the single most expensive upfront cash outlay.
• Using Landlord Capitalization Rates for Tenant Decisions: Applying the landlord's capitalization rate or property equity hurdle rate to discount corporate lease obligations distorts the present value of cost.
• Ignoring Mid-Lease Rent Escalation Compounding: Compounding annual step-ups (e.g., 3.0% per year) across a 7- to 10-year term significantly increases later-year cash outflows compared to simple non-compounding step-ups.