| name | effective-rent-analyzer |
| description | Expert in effective rent calculations using Ponzi Rental Rate (PRR) framework. Use when calculating NER, NPV, breakeven analysis, landlord investment returns, or analyzing lease deal economics. Key terms include net effective rent, gross effective rent, NPV of lease deal, breakeven NER, fully levered breakeven, sinking fund, capital recovery, tenant incentives, TI allowance, free rent, leasing commissions |
| tags | ["effective-rent","NER","NPV","breakeven","PRR","ponzi-rental-rate","lease-economics","landlord-return"] |
| capability | Calculates landlord investment returns using NPV methodology, determines breakeven rent thresholds, analyzes tenant incentive impacts, and provides investment recommendations |
| proactive | true |
Effective Rent Analyzer
You are an expert in effective rent analysis using the Ponzi Rental Rate (PRR) framework, providing rigorous landlord investment analysis for commercial real estate lease deals.
Overview
Effective rent analysis determines the true economic value of a lease deal to the landlord by:
- Converting irregular cash flows to present value (NPV)
- Calculating Net Effective Rent (NER) - the constant annuity equivalent
- Determining breakeven rent thresholds
- Quantifying landlord's investment return
Critical Insight: Gross/headline rent is misleading. Landlords must analyze NPV to understand true deal economics.
Core Concepts
Net Effective Rent (NER)
Definition: The constant monthly rent (annuity) that has the same NPV as the actual lease cash flows, net of all tenant incentives.
Formula:
NER = NPV ÷ PV(Annuity Factor)
Where:
NPV = Present value of all lease cash flows (rent - incentives)
PV(Annuity Factor) = Present value of $1/month for lease term at discount rate
Example:
- 5-year lease, $20/sf gross rent, 3 months free rent, $10/sf TI
- Discount rate: 8%
- NER might be $17.50/sf (accounting for free rent and TI cost)
Gross Effective Rent (GER)
Definition: NER before deducting landlord costs (TI, leasing commissions, free rent).
Used for tenant comparison (tenant doesn't care about landlord's costs), but landlords must use NER for investment decisions.
Ponzi Rental Rate (PRR)
Developed by: R.T. Eppli, C.C. Tu, and M.J. Seiler
Key Insight: NER must exceed a breakeven threshold to recover:
- Sinking fund contribution (to recover capital spent on TI/commissions)
- Financing costs (interest on capital deployed)
Breakeven NER Formula:
Breakeven NER = (TI + LC) × [i + (i ÷ ((1+i)^n - 1))] ÷ Rentable Area
Where:
TI = Tenant Improvement costs
LC = Leasing Commissions
i = Discount rate (landlord's cost of capital)
n = Lease term in years
Investment Decision:
- NER > Breakeven NER: Deal creates value (accept)
- NER < Breakeven NER: Deal destroys value (reject or renegotiate)
- NER = Breakeven NER: Indifferent (zero NPV)
Fully Levered Breakeven
Accounts for:
- Operating expenses (property taxes, insurance, CAM, management fees)
- Debt service (if property is leveraged)
- Capital reserve contributions
Use when: Analyzing whether deal generates positive cash flow, not just NPV.
Methodology
Step 1: Extract Lease Terms
Required inputs:
- Base rent schedule (monthly, may escalate)
- Free rent period (# of months)
- TI allowance ($/ sf)
- Leasing commissions (% of gross rent or $/sf)
- Rentable area (sf)
- Lease term (months/years)
- Discount rate (landlord's cost of capital, typically 6-10%)
Step 2: Build Cash Flow Timeline
Month-by-month cash flow:
Month 1-3: Free rent → Cash flow = $0
Month 4-12: Full rent → Cash flow = Base Rent × Rentable Area
Month 13+: May escalate → Cash flow = Escalated Rent × Rentable Area
Step 3: Calculate NPV
Discount all future cash flows to present value:
NPV = Σ [Cash Flow(t) ÷ (1 + i)^(t/12)]
Where t = month number
Subtract upfront costs:
NPV(net) = NPV(rent) - TI - Leasing Commissions
Step 4: Calculate NER
Convert NPV to constant annuity:
PV(Annuity) = Σ [1 ÷ (1 + i)^(t/12)] for t = 1 to term_months
NER ($/month) = NPV ÷ PV(Annuity)
NER ($/sf/month) = NER ($/month) ÷ Rentable Area
Step 5: Calculate Breakeven NER
Using PRR formula:
Breakeven = (TI + LC) × [i + (i ÷ ((1+i)^n - 1))] ÷ Area
Step 6: Investment Recommendation
If NER > Breakeven:
→ Deal creates value
→ NPV = positive
→ Accept or negotiate better terms
If NER < Breakeven:
→ Deal destroys value
→ NPV = negative
→ Reject or require higher rent / lower concessions
Spread = NER - Breakeven
Key Metrics
Net Effective Rent (NER)
- Units: $/sf/month or $/sf/year
- Interpretation: Constant rent equivalent after all concessions
- Use: Compare deals with different structures
Net Present Value (NPV)
- Units: $
- Interpretation: Total economic value of lease to landlord
- Decision Rule: Accept if NPV > 0
Breakeven NER
- Units: $/sf/month or $/sf/year
- Interpretation: Minimum rent needed to recover capital
- Use: Investment hurdle rate
NER Spread
- Formula: NER - Breakeven NER
- Interpretation: Economic profit per sf
- Target: Positive spread
Payback Period
- Formula: (TI + LC) ÷ (NER × Area × 12)
- Interpretation: Years to recover upfront investment
- Typical: 2-5 years for industrial, 3-7 years for office
Red Flags
Deal Structure Red Flags
Excessive Free Rent:
- More than 1 month free per year of lease (e.g., 6+ months for 5-year lease)
- Erodes NPV and extends payback
High TI Allowance:
- Industrial: >$5-10/sf is generous
- Office: >$30-50/sf requires careful analysis
- High TI + short term = negative NPV risk
Short Term + High Concessions:
- 3-year lease with 3 months free + $20/sf TI
- Insufficient time to recover capital
Backloaded Rent:
- Low Year 1-2 rent, high Year 3-5 rent
- Increases landlord risk (tenant may default before high rent kicks in)
- NPV discounting erodes value of distant cash flows
Financial Red Flags
Negative NPV:
- NER < Breakeven NER
- Deal destroys value
- Action: Reject or renegotiate
Thin Spread:
- NER only $0.50-1.00/sf above breakeven
- Little margin for error
- Action: Require credit enhancement (deposit, guarantee)
Long Payback:
-
7 years to recover TI and commissions
- Exceeds most lease terms
- Action: Reduce TI or increase rent
Negative Leverage:
- Fully levered breakeven > NER
- Debt service exceeds economic rent
- Action: Deal only works unlevered (red flag for leveraged properties)
Common Use Cases
Use Case 1: New Lease Negotiation
Situation: Tenant offers $18/sf with 6 months free rent and $15/sf TI for 5-year lease (10,000 sf industrial).
Analysis:
- Extract terms: Rent = $18/sf, Free = 6 months, TI = $15/sf, LC = 4% = $3.60/sf, Area = 10,000 sf
- Discount rate: 8%
- Calculate NPV of rent stream
- Calculate NER
- Calculate breakeven NER using PRR
- Compare: NER vs Breakeven
Output:
NER: $16.25/sf/year
Breakeven: $15.80/sf/year
Spread: $0.45/sf/year
NPV: $2,250
Recommendation: Accept (positive NPV, but thin spread - require security deposit)
Use Case 2: Competing Offers
Situation: Landlord receives two offers for same space:
- Offer A: $20/sf, 3 months free, $10/sf TI, 5 years
- Offer B: $22/sf, 6 months free, $15/sf TI, 3 years
Analysis: Calculate NER for both offers to determine which creates more value.
Output:
Offer A:
NER: $18.50/sf
NPV: $92,500
Payback: 3.2 years
Offer B:
NER: $17.80/sf
NPV: $53,400
Payback: 5.1 years
Recommendation: Accept Offer A (higher NPV, faster payback)
Use Case 3: Renewal Economics
Situation: Existing tenant at $15/sf requests renewal at $16/sf with 3 months free rent and $5/sf refresh TI. Market rent is $18/sf for new tenants with typical concessions ($10/sf TI, 3 months free).
Analysis: Compare renewal NER vs new tenant NER to determine if renewal creates incremental value.
Output:
Renewal NER: $15.20/sf (after concessions)
New Tenant NER: $16.00/sf (after new deal concessions + 6 months downtime)
Recommendation: Accept renewal (avoids downtime, lower TI)
Use Case 4: Market Rent Benchmarking
Situation: Landlord needs to set asking rent for vacant space. Recent comparable leases show $18-22/sf gross, but with varying concession packages.
Analysis: Calculate NER for all comparables to establish true market NER, then work backward to determine asking rent that achieves target NER.
Output:
Market NER Range: $16.50-$18.00/sf
Target NER: $17.00/sf
Asking Rent (with standard concessions): $19.50/sf
Integration with Slash Commands
This skill is automatically loaded when:
- User mentions: NER, NPV, effective rent, breakeven, landlord return, lease economics
- Commands invoked:
/effective-rent, /renewal-economics, /market-comparison
- Reading files:
*offer*lease*, *_input.json in Eff_Rent_Calculator
Related Commands:
/effective-rent <lease-or-offer-path> <landlord-params-json-path> - Full NER/NPV analysis with Ponzi Rental Rate breakeven/renewal-economics <current-lease-path> - Renewal vs. relocation NPV comparison/market-comparison <subject-lease> [comparables...] - Benchmark rent against market NER
Examples
Example 1: Industrial Warehouse Deal
Inputs:
- Rentable Area: 25,000 sf
- Base Rent: $8.50/sf/year (escalates 2.5% annually)
- Free Rent: 3 months
- TI Allowance: $5/sf
- Leasing Commission: 4% of gross rent
- Term: 5 years
- Discount Rate: 7.5%
Calculations:
-
Gross Rent Stream:
- Year 1: $8.50/sf × 25,000 sf = $212,500/year
- Year 2: $212,500 × 1.025 = $217,813
- Year 3: $217,813 × 1.025 = $223,258
- Year 4: $223,258 × 1.025 = $228,840
- Year 5: $228,840 × 1.025 = $234,561
-
Free Rent Adjustment:
- Month 1-3: $0
- Month 4-60: Full rent
-
NPV of Rent:
- Discount each month's cash flow at 7.5%/12
- NPV(rent) = $982,450
-
Upfront Costs:
- TI: $5/sf × 25,000 = $125,000
- Commission: 4% × ($212,500 × 5 years) = $42,500
- Total: $167,500
-
Net NPV:
- NPV(net) = $982,450 - $167,500 = $814,950
-
NER:
- PV(Annuity, 60 months, 7.5%) = 49.318
- NER = $814,950 ÷ 49.318 ÷ 25,000 = $0.661/sf/month = $7.93/sf/year
-
Breakeven NER (PRR):
- i = 7.5%, n = 5 years
- Breakeven = $167,500 × [0.075 + (0.075 ÷ ((1.075)^5 - 1))] ÷ 25,000
- Breakeven = $167,500 × 0.2548 ÷ 25,000 = $1.71/sf/year
Investment Decision:
NER: $7.93/sf/year
Breakeven: $1.71/sf/year
Spread: +$6.22/sf/year
NPV: $814,950
Payback: 2.1 years
RECOMMENDATION: ACCEPT - Strong positive NPV, wide spread, fast payback
Example 2: Office Lease with Complex Rent Schedule
Inputs:
- Rentable Area: 5,000 sf
- Base Rent: Year 1-2: $25/sf, Year 3-5: $28/sf, Year 6-10: $31/sf
- Free Rent: 6 months
- TI Allowance: $40/sf
- Leasing Commission: 5% of gross rent over 10 years
- Term: 10 years
- Discount Rate: 8%
Calculations:
- NPV of Rent (month-by-month discounting): $1,245,600
- Upfront Costs: TI = $200,000, LC = $66,250, Total = $266,250
- Net NPV: $1,245,600 - $266,250 = $979,350
- NER: $979,350 ÷ PV(annuity, 120 months, 8%) ÷ 5,000 = $2.33/sf/month = $28.00/sf/year
- Breakeven: $266,250 × [0.08 + (0.08 ÷ ((1.08)^10 - 1))] ÷ 5,000 = $7.32/sf/year
Investment Decision:
NER: $28.00/sf/year
Breakeven: $7.32/sf/year
Spread: +$20.68/sf/year
NPV: $979,350
Payback: 1.9 years
RECOMMENDATION: ACCEPT - Excellent economics, long-term stable tenant
Skill Version: 1.0
Last Updated: November 13, 2025
Related Skills: commercial-lease-expert, offer-to-lease-expert, negotiation-expert, portfolio-strategy-advisor
Related Commands: /effective-rent, /renewal-economics, /market-comparison, /recommendation-memo
