Retail Real Estate Model Structure
Executive Summary
Key Takeaways
- ✓ Turnover rent, where a portion of rent is contingent on the tenant's actual sales performance above a stated threshold, should be modelled as its own explicit calculation per lease, distinct from the base (minimum guaranteed) rent line.
- ✓ Anchor tenant covenant strength and footfall contribution should be modelled explicitly, since anchor tenant performance materially affects the achievable rent and occupancy of surrounding smaller units, a dependency a corporate or office model does not need to represent.
- ✓ Tenant mix (the composition of anchor, mid-size, and small-format tenants by category) should be tracked as its own schedule, since an imbalanced mix is itself a value risk independent of any individual lease's terms.
- ✓ Service charge recovery should be modelled as its own reconciliation, recoverable costs billed to tenants against actual expenditure, with any shortfall explicitly identified as a non-recoverable cost to the landlord rather than absorbed silently into the operating cost line.
- ✓ Co-tenancy or anchor-departure clauses, which can trigger reduced rent or lease termination rights for other tenants if an anchor tenant vacates, should be modelled explicitly given their potential to compound a single anchor departure into portfolio-wide income loss.
Institutional Definition¶
A retail model specializes the income-producing asset model structure around turnover rent mechanics, tenant mix, and anchor tenant covenant and footfall dependency, each of which affects value in ways not present in an office or industrial asset. These retail-specific mechanics must be represented explicitly rather than absorbed into a generic rent roll structure.
Turnover Rent Mechanics¶
Turnover rent, rent contingent on a percentage of the tenant's actual sales above a stated threshold, should be modelled as its own explicit calculation per lease — the stated percentage applied to projected tenant turnover above the threshold — kept distinct from the base (minimum guaranteed) rent line. Blending the two into a single combined rent figure per lease prevents testing the model's sensitivity to tenant sales performance independently of the guaranteed base rent, which is precisely the variable a downturn scenario needs to stress.
Anchor Tenant Covenant and Footfall Dependency¶
Anchor tenant footfall drives customer traffic for surrounding smaller units, so anchor tenant covenant strength and performance affect not just that unit's own income risk but the achievable rent and occupancy of the rest of the scheme — a cross-unit dependency that does not exist in the same way in an office or industrial asset. The model should track anchor tenant covenant strength explicitly and, where material, represent the sensitivity of surrounding smaller-unit rent and occupancy assumptions to an anchor tenant scenario.
Tenant Mix¶
Tenant mix, the composition of anchor, mid-size, and small-format tenants by category, should be tracked as its own schedule. An imbalanced mix, too much concentration in one retail category or excessive reliance on a single anchor, is itself a value risk independent of any individual lease's specific terms, and a model without an explicit tenant mix schedule cannot represent this concentration risk to a reviewer.
Service Charge Recovery¶
Service charge recovery should be modelled as its own reconciliation: recoverable costs billed to tenants against actual expenditure incurred, with any shortfall, whether from vacant units not contributing service charge or costs exceeding what leases permit to be recovered, explicitly identified as a non-recoverable cost to the landlord. Absorbing this shortfall silently into a general operating cost line conceals the specific driver of any NOI variance from budget.
Co-Tenancy and Anchor-Departure Clauses¶
Co-tenancy or anchor-departure clauses, common in shopping centre leases, grant a tenant reduced rent or a termination right if a named anchor tenant vacates or occupancy falls below a stated threshold. These should be modelled explicitly given their potential to compound a single anchor departure into a wider portfolio income loss that a lease-by-lease rent roll, without an explicit co-tenancy trigger, would not otherwise capture.
Common Structural Errors¶
Blended base and turnover rent. Combining the two into a single rent figure per lease prevents independently testing sensitivity to tenant sales performance.
Missing tenant mix schedule. Omitting an explicit tenant category schedule conceals concentration risk that exists independently of individual lease terms.
Silent service charge shortfall. Absorbing a service charge recovery shortfall into general operating costs rather than identifying it explicitly conceals the specific driver of NOI variance.
Audit Checks¶
Turnover rent separation check. Confirm base and turnover rent are calculated as separate, distinct lines per lease.
Tenant mix schedule check. Confirm an explicit tenant category schedule exists and is used to assess concentration risk.
Service charge reconciliation check. Confirm recoverable costs are reconciled against actual expenditure with any shortfall explicitly identified.
Best Practices¶
| Best Practice | Why It Matters |
|---|---|
| Model base and turnover rent as separate calculations per lease | Preserves the ability to stress-test tenant sales performance independently |
| Track anchor tenant covenant strength and footfall dependency explicitly | Represents the cross-unit value dependency retail carries that office and industrial do not |
| Maintain an explicit tenant mix schedule by category | Surfaces concentration risk independent of any individual lease's terms |
| Reconcile service charge recovery against actual expenditure | Identifies the specific driver of any non-recoverable cost shortfall |
Further Reading¶
- International Council of Shopping Centers (ICSC), research publications on retail leasing structures
- RICS, Valuation — Global Standards (Red Book), Royal Institution of Chartered Surveyors
Continue Reading¶
Prerequisites¶
- Real Estate Financial Modelling — the parent pillar
- Income-Producing Asset Model Structure
Related Technical Guides¶
Related Glossary¶
Related Products¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is turnover rent, and how should it be modelled?
Rent contingent on a percentage of the tenant's actual sales above a stated threshold, in addition to or instead of a base rent. It should be modelled as its own explicit calculation per lease, applying the stated percentage to projected tenant turnover above the threshold, kept distinct from the base rent line so each component can be tested independently.
Why does anchor tenant covenant strength matter more in a retail model than an office model?
Because anchor tenant footfall drives customer traffic for surrounding smaller units, so anchor tenant performance and covenant strength affect not just that unit's own rent risk but the achievable rent and occupancy of the rest of the scheme, a dependency that does not exist in the same way in an office model.
How should tenant mix be modelled?
As its own explicit schedule tracking the composition of anchor, mid-size, and small-format tenants by category, since an imbalanced mix, too much of one category, or over-reliance on a single anchor, is itself a value risk independent of any individual lease's specific terms.
How should service charge recovery be modelled?
As its own reconciliation between recoverable costs billed to tenants and actual expenditure incurred, with any shortfall (non-recoverable cost, or costs incurred exceeding what leases allow to be recovered) explicitly identified as a cost to the landlord, rather than absorbed silently into a general operating cost line.
What is a co-tenancy or anchor-departure clause?
A lease provision, common in shopping centre leases, that grants a tenant reduced rent or a termination right if a named anchor tenant vacates or if occupancy falls below a stated threshold. It should be modelled explicitly given its potential to compound a single anchor departure into a wider portfolio income loss.
What is the most common structural error in retail models?
Blending turnover rent into a single base-plus-turnover rent figure per lease rather than modelling the two components separately, which prevents testing the model's sensitivity to tenant sales performance independently of the guaranteed base rent.
Related Articles
Income-Producing Asset Model Structure
An income-producing asset model differs structurally from a development appraisal because it starts from an existing or near-complete asset's rent roll and builds forward to a stabilised net operating income, valued through direct capitalization or a full discounted cash flow, rather than building value forward from construction cost. This guide sets out the module architecture — rent roll, operating expense and NOI build, valuation module, and returns output — that makes such a model auditable, and how lease-level detail should be represented.
Commercial Office Model Structure
Commercial office models specialize the income-producing asset structure around lease-level detail — individual lease terms, rent review and break clause mechanics, and a weighted average unexpired lease term (WAULT) that summarizes portfolio lease risk. This guide sets out how the rent roll should be built, how rent reviews and break options should be tested, and how void and re-leasing costs should be modelled at each lease event.
Industrial and Logistics Model Structure
Industrial and logistics models specialize the income-producing asset structure around a small number of long-dated leases, often a single tenant, which concentrates income risk in a way a diversified multi-let office or retail asset does not, together with a specification-driven yield basis (clear height, loading, power capacity) distinct from other property types. This guide sets out how single-tenant concentration risk, specification-linked pricing, and rack-rent reversion at expiry should be modelled.
Net Operating Income
Net operating income (NOI) is a real estate asset's total revenue less operating expenses, calculated before debt service, capital expenditure, and depreciation. It is the anchor figure for valuing an income-producing asset, whether through direct capitalization (NOI divided by a market capitalization rate) or as the cash flow line discounted in a real estate DCF. NOI should be built from a lease-level rent roll and an itemized operating expense schedule, and normalized for one-off items before being used in a stabilised valuation.
Exit Capitalization Rate
The exit capitalization rate (or reversion cap rate) is the rate applied to terminal-year net operating income to derive a real estate asset's projected value at the end of a discounted cash flow holding period. It is a distinct assumption from the discount rate used to present-value the explicit cash flow forecast, and conflating the two, using one rate for both roles, is a common sector-specific modelling error. The exit cap rate is typically set at a premium to the entry cap rate to reflect asset ageing and uncertainty further into the future.