Office · Lease Abstract Template
Office Lease Abstract Template
Office lease abstract template covering base year, expense stops, gross-up %, renewal options, TI obligations, and SNDA status. Free template.
Why the lease abstract template looks different for office
Office rent economics hinge on the base year and expense stop, then get distorted further by the gross-up provision that adjusts variable expenses to a stabilized occupancy, usually 95–100%. A generic abstract that records the stop as a flat number without the gross-up methodology will misstate every future year's reimbursement calculation, not just the base year.
Renewal and expansion options in office leases carry specific notice windows, rent-reset mechanisms (fixed bump, FMV determination, or CPI), and space-availability conditions that materially affect leasing risk on adjacent vacant suites. An abstract that omits an active expansion right means underwriting nearby vacant space as available inventory when it's contractually already spoken for, inflating projected absorption.
TI obligations and SNDA status determine whether an acquirer is inheriting undisclosed liabilities or subordination risk. Unamortized landlord TI allowances transfer at closing as an assumed cost, and a missing or unrecorded SNDA can leave a tenant's leasehold interest unprotected in a foreclosure; both are financial and legal exposures a lease summary alone won't surface.
The office-specific checklist
- 1
Capture parties and premises
Verify: landlord, tenant, guarantor, demised premises, building, suite
- 2
Record full rent schedule
Verify: step rents, free rent, concessions
- 3
Document recoveries
Verify: method, caps, gross-ups, base year
- 4
List restrictions
Verify: exclusives, co-tenancy, radius, use restrictions
- 5
Note options and rights
Verify: options to extend, ROFO/ROFR, termination rights
- 6
Record the base year and confirm whether the gross-up provision applies, and to what occupancy percentage
Verify: gross-up target (typically 95–100%) and whether it applies to all variable expenses or only specific line items
- 7
Recalculate the expense stop from the base-year operating statement, grossed up per the lease formula
Verify: grossed-up $/SF stop within $0.10 of the abstract; flag any variance above that
- 8
Map every renewal and expansion option with notice windows and rent-reset methodology
Verify: notice period (typically 6–12 months), rent basis (fixed %, FMV, CPI), and whether expansion rights encumber specific suites
- 9
Confirm SNDA execution status for the tenant
Verify: SNDA on file and recorded, or open as a diligence gap; unrecorded SNDAs are a lender condition on most institutional loans
- 10
Quantify unamortized TI and leasing commission balances as of closing
Verify: remaining balance = total TI/LC ÷ amortization term × remaining months; treat as an assumed liability in pricing
- 11
Verify parking ratio and allocation against the lease's stated entitlement
Verify: reserved vs. unreserved spaces per 1,000 SF matches the executed lease, not the marketing package
Metrics that matter for office
| Metric | Target | Calculation |
|---|---|---|
| Expense stop accuracy | within $0.10/SF of the recalculated grossed-up figure | |abstracted stop − recalculated grossed-up stop| ÷ SF |
| Encumbered vacancy | <5% of vacant SF under active expansion rights | vacant SF subject to expansion options ÷ total vacant SF |
| Unamortized TI/LC liability | reconciled to $0 unbooked | Σ (remaining TI + LC balance per tenant) at close |
| Net effective rent | ≥80% of face rent | (face rent × term - TI - free rent value) / term |
| WALT (yrs) | >5 for core | weighted avg remaining lease term |
| Occupancy | >90% for core | leased SF / rentable SF |
Red flags unique to office
-
Expense stop abstracted at the actual (ungrossed) base-year figure instead of the grossed-up figure
understates the tenant's future reimbursement obligation for the life of the lease, especially in buildings below 95% occupancy in the base year
-
Active expansion option on space currently marketed as available
double-counts the same square footage as both a leasing opportunity and an encumbered right, inflating projected absorption and rent growth
-
Unamortized TI balance omitted from the abstract entirely
the balance transfers to the buyer as an assumed cost at closing and is routinely missed when abstracts summarize TI as 'per lease' without a dollar figure
-
Net effective rent more than 15% below face rent
high TI + free rent burns more of stated rent than the pro forma assumes
-
Rollover concentration above 30% in any single year
single-year rollover exposure in a soft office market is the dominant underwriting risk
-
Sublease availability exceeding 10% of market stock
tenants are offloading space — direct rents will follow down
-
Operating expense pass-through base year inconsistency
mismatched base years mean recoveries don't actually protect landlord
Example — office lease abstract template walkthrough
Fourteen tenants fill a 240,000 SF Class A office building in a secondary CBD trading at $54M ($225/SF, 89% leased), with in-place NOI of $3.6M underwriting to a 6.7% cap.
The anchor tenant occupies 42,000 SF on a full-service gross lease with a 2024 base year. The broker's abstract lists the expense stop at $9.10/SF. That figure is the building's actual 2024 operating expense per square foot ($2,688,000 in total opex divided across the building's 240,000 SF), but it isn't grossed up. The lease's gross-up clause requires expenses to be adjusted to 95% occupancy before setting the stop, and the building ran at 89% occupancy in the base year, exactly the vacancy condition the gross-up clause exists to correct for. Recalculating the variable expense component at 95% occupancy produces a grossed-up base year figure of $9.85/SF. The $0.75/SF gap understates the tenant's expense pass-through obligation by $31,500 a year ($0.75 × 42,000 SF) for the remaining seven years of the term, roughly $220,000 on a present-value basis at an 8% discount rate.
The second issue is a TI obligation the abstract records only as "landlord TI: per lease," with no dollar figure; that shorthand is exactly how the number gets missed. The underlying lease shows a 2023 expansion allowance of $65/SF on the 19,000 SF the tenant added that year: $1,235,000 total, amortized over 10 years at 6%. As of the current closing date, roughly $1,020,000 of that balance is unamortized and transfers to the buyer as an assumed liability, since the purchase agreement is silent on TI proration.
The understated expense stop ($220,000 in present value) and the unbooked TI balance ($1,020,000) total roughly $1.24M, which the buyer's team used to negotiate a corresponding price adjustment before closing. Neither number appears anywhere in the broker's abstract; both came from pulling the underlying operating statement and the amortization schedule and recalculating from the lease's actual formulas. The same recalculation discipline applies to every suite on the roll; this tenant simply carried the largest balances.
Download the office lease abstract template template
Pre-populated Excel template matching this checklist, ready to use on your next deal.
Get the template →Questions about office lease abstract template
A gross-up provision adjusts variable operating expenses to what they would be at a stabilized occupancy, usually 95–100%, so the expense stop and reimbursements aren't distorted by vacancy. Skipping the gross-up recalculation in a partially leased building understates the true expense stop and the tenant's pass-through obligation.
Unless the purchase agreement states otherwise, unamortized landlord TI and leasing commission balances transfer to the buyer as an assumed liability, the buyer effectively pays for improvements that benefited the seller's occupancy history. This should be priced into the offer, not discovered after closing.
A Subordination, Non-Disturbance, and Attornment agreement protects a tenant's leasehold in a foreclosure and protects a lender's priority. Missing or unrecorded SNDAs are a common closing condition for institutional debt and can delay financing if discovered late in diligence.
Parties, premises, term, rent schedule, recoveries, restrictions, options, and any red-flag clauses. The abstract is the structured-data version of the lease used for underwriting and asset management.
Automate office lease abstract template with Moraine
Upload the documents and get the analysis, the red-flag report, and the template in one pass.