Retail · Lease Abstract Template

Retail Lease Abstract Template

Retail lease abstract template covering percentage rent breakpoints, co-tenancy triggers, exclusives, and CAM caps. Free template for institutional buyers.

Why the lease abstract template looks different for retail

Retail leases layer variable economics onto the base rent that generic abstract templates don't capture: percentage rent above a breakpoint, CAM caps and floors, and exclusives that restrict what other tenants in the center can sell. Missing any one of them leaves the abstract out of date the moment sales or occupancy move.

Co-tenancy clauses tie one tenant's rent obligation to another tenant's presence: if a named anchor closes or occupancy falls below a threshold, an in-line tenant's rent can drop to a reduced rate, convert to percentage-only, or trigger a kick-out right entirely. A lease abstract that doesn't map this dependency web understates downside risk across the whole rent roll, not just one suite.

Exclusive-use and radius restrictions in retail leases constrain leasing velocity on vacant space and can create default exposure if a new tenant's use conflicts with an existing exclusive. Office and industrial abstracts have no equivalent field; retail abstraction has to track exclusives across every executed lease simultaneously to avoid inadvertently violating one when backfilling a vacancy.

The retail-specific checklist

  1. 1

    Capture parties and premises

    Verify: landlord, tenant, guarantor, demised premises, building, suite

  2. 2

    Record full rent schedule

    Verify: step rents, free rent, concessions

  3. 3

    Document recoveries

    Verify: method, caps, gross-ups, base year

  4. 4

    List restrictions

    Verify: exclusives, co-tenancy, radius, use restrictions

  5. 5

    Note options and rights

    Verify: options to extend, ROFO/ROFR, termination rights

  6. 6

    Record the percentage rent breakpoint as natural or artificial, with the underlying formula

    Verify: natural breakpoint = annual base rent ÷ percentage rate; flag any lease where the stated breakpoint doesn't reconcile to this formula within 1%

  7. 7

    Map every co-tenancy and kick-out clause to the specific named anchors and occupancy thresholds that trigger it

    Verify: clause fires below what occupancy % or upon which named tenant's closure; note the rent remedy (reduction, percentage-only, termination right)

  8. 8

    Abstract the exclusive-use and radius-restriction language verbatim, not summarized

    Verify: exact permitted/prohibited use categories; cross-check against every other tenant's use clause in the center for conflicts

  9. 9

    Capture the CAM cap structure, cumulative vs. non-cumulative, and the base year if applicable

    Verify: cap ceiling (e.g., 5% annually) and whether unused cap carries forward; recompute the 3-year CAM trend against the cap

  10. 10

    Log co-tenancy cure periods and the landlord's right-to-cure window

    Verify: days the landlord has to backfill before the tenant's remedy activates, typically 90–270 days

  11. 11

    Verify sales-reporting obligations and audit rights tied to percentage rent

    Verify: reporting frequency (monthly/annual), landlord audit window (usually 2–3 years), and any confidentiality restriction on using the data

Metrics that matter for retail

Metric Target Calculation
Percentage rent capture rate >90% of eligible tenants reporting tenants submitting sales reports ÷ tenants with percentage rent clauses
Occupancy cost ratio (rent-paying tenants) 10–13% of sales (base rent + CAM + percentage rent) ÷ reported gross sales
Co-tenancy exposure <15% of GLA under active co-tenancy rights SF with unexpired co-tenancy clauses ÷ total center GLA
Occupancy cost ratio 8–12% for anchors, 10–15% for in-line total occupancy cost / tenant sales
Sales PSF varies by category reported tenant sales / leased SF
Recovery ratio >90% recovered expenses / recoverable expenses

Red flags unique to retail

  • Percentage rent breakpoint abstracted as artificial when the lease specifies natural

    overstates percentage rent revenue in the pro forma, natural breakpoints run 2–4x higher than artificial ones set in older amendments, so most tenants never cross them

  • Co-tenancy clause tied to a specific named anchor that has already been replaced

    if the replacement isn't a like-kind anchor meeting the lease's defined criteria, the clause may already be triggered and generating a rent abatement the seller hasn't disclosed

  • Exclusive-use clause silently conflicts with the intended backfill tenant for a vacant suite

    signing a new tenant into a use an existing lease prohibits creates immediate default exposure and can force a costly lease termination or use amendment

  • Co-tenancy trigger above 70% occupancy

    common anchor departure clause that can cascade into reduced rent across the center

  • CAM cap below 3% annual

    suppresses expense recovery and flows inflation directly to NOI

  • Exclusive-use clauses blocking lease-up

    limits the pool of replacement tenants even before the space goes vacant

  • Radius restrictions under 3 miles

    constrains the operator's ability to relocate or expand nearby

Example — retail lease abstract template walkthrough

Run the abstract exercise on a 145,000 SF grocery-anchored retail center in a Sun Belt market trading at $31M, roughly $214/SF, anchored by a 38,000 SF regional grocer with 22 in-line tenants. In-place NOI is $2.05M, underwriting to a 6.6% cap on the asking price.

The center's largest percentage-rent payer comes first: a national apparel tenant on 4,000 SF paying $30/SF base rent ($120,000/year) plus 6% percentage rent above the breakpoint. The broker's package lists the breakpoint at $1,500,000, an artificial figure carried over from a 2019 lease amendment. Recalculating from the current lease's actual formula, the natural breakpoint is annual base rent divided by the percentage rate: $120,000 ÷ 6% = $2,000,000, and that recalculated figure is what the revenue line should carry. On trailing sales of $2,300,000, the correctly abstracted breakpoint produces percentage rent of 6% × ($2,300,000 − $2,000,000) = $18,000. The broker's artificial figure would have produced 6% × ($2,300,000 − $1,500,000) = $48,000, a $30,000 annual overstatement on this tenant alone.

The co-tenancy map is less forgiving. Eight in-line tenants, averaging 3,500 SF each at $22/SF, carry a co-tenancy clause requiring at least two of three named anchors to remain open; if the count falls below two, rent for those eight tenants drops to the lesser of $15/SF or 4% of sales. The grocery anchor's ten-year lease has an early termination right if its own sales fall below a stated threshold for two consecutive years, a scenario the broker's pro forma doesn't model. If that termination right is exercised, the co-tenancy clause fires: rent on the eight affected tenants (28,000 SF) drops by $7/SF, a $196,000 annual NOI hit that runs until a qualifying replacement anchor opens.

The breakpoint correction removes $30,000 of overstated revenue, and the co-tenancy exposure puts $196,000 of NOI at risk under a plausible anchor-departure scenario: a $226,000 swing against $2.05M of in-place NOI, roughly 11%. At the underwritten 6.6% cap, that's a $3.4M valuation gap between the broker's abstract and a correctly built one.

Download the retail lease abstract template template

Pre-populated Excel template matching this checklist, ready to use on your next deal.

Get the template →

Questions about retail lease abstract template

Automate retail lease abstract template with Moraine

Upload the documents and get the analysis, the red-flag report, and the template in one pass.