Lease Rollover Analysis

Track expiring square footage year by year, with declining occupancy exposure

What this tool does

Enter each tenant's current lease and a rollover assumption (downtime + future term), and get a full expiration schedule — year by year expiring square footage, projected lease generations, and a declining occupancy exposure line. Load directly from a saved Rent Roll file for the current lease data.

  • Load current lease data straight from a saved Rent Roll file
  • Automatic multi-generation rollover projection
  • Excel & PDF export
  • Nothing you enter is stored on our servers
  • One subscription unlocks every Clearcell Reporting tool

See how it works

A 3-step walkthrough of the tool, before you buy.

Company & property 1
Company name, address, logo
Analysis start date & years to project
Load a saved Rent Roll file

1. Set up your property, or load a Rent Roll

Already built a Rent Roll for this property? Load that file directly for each tenant's current lease dates and square footage.

Tenants & assumptions 2
Tenant, lease start/end, square footage
Downtime & future lease term assumptions
+ Add tenant

2. Add each tenant's lease and rollover assumption

Current lease data can be loaded automatically — the downtime and future lease term assumptions are yours to set per tenant.

Rollover schedule 3
Year 4 expiring45,000 SF
Occupancy, Year 420.4%
Schedule generated   10-year window

3. Get your rollover schedule

Expiring SF by year, projected lease generations, and a declining occupancy line — all calculated automatically, exportable as PDF or Excel.

View a sample PDF report →

$39 one-time
One price unlocks every Clearcell Reporting tool — current and future · pay once, yours forever
Already purchased?

Lease Rollover Analysis

Build your property's rollover schedule, step by step

Load from a saved Rent Roll

Already built a Rent Roll for this property? Load that file to bring over each tenant's current lease start, end, and square footage automatically. Downtime and future lease term assumptions are always entered separately, since those are forward-looking assumptions specific to this analysis.

Company information

Shown on the letterhead of your rollover schedule PDF.

No logo

Property & analysis settings

Tenants & rollover assumptions

Current lease dates and square footage can be loaded from a Rent Roll file. Downtime and future lease term are your assumptions for what happens after each lease expires.

Lease generations

Each tenant's current lease, rollover assumptions, and projected future lease generations within the analysis window.

Rollover analysis

Expiring square footage by year. A bold 0 marks a lease event already covered by a future-term assumption — occupancy only declines when a tenant's space reaches an expiration with no further renewal assumed.

Export

Save downloads a small file to your own computer with everything you've entered — nothing is stored on our servers. Load it back anytime to pick up where you left off.

This tool provides estimated figures for informational purposes only, based solely on the inputs and assumptions provided. It does not constitute accounting, tax, or legal advice. Verify all figures against the governing lease documents before relying on them.