Commercial Rent Roll & Lease Rollover Analyzer
How much of today’s scheduled rent survives the next lease expirations?
Private browser calculationIn-place rent + contractual runoffCSV · project file · print
Method reviewed October 25, 2026 · All prefilled amounts, rates and dates are hypothetical examples. Replace them with supported project figures.
Build a decision you can explain.
Reconcile leased, vacant and unlisted area; measure base-rent concentration and remaining term, then model lease runoff, collection loss and monthly cash gaps. Read the method and boundaries.
Import, save or print a project
Files stay on your device. Download a copy before leaving; inputs are not saved automatically.
Project files retain scenarios across the ten workbench models and share a private label. BRRRR and condo models can also share purchase, acquisition, construction and soft-cost inputs. Each model retains its own financing, cash and operating assumptions. A saved tool scenario restores its own values.
Enable JavaScript to calculate. The methodology and source notes remain available below.
Current spaces and modeled rent-stop dates
Use a private reference. All rows and amounts below are illustrative until you replace them.
Scheduled rent can fall before a replacement lease is ready
The fictional snapshot has $17,500 monthly base rent: $6,500 Retail A through June 30, 2027; $7,500 Office B through October 31, 2028; and $3,500 Store C modeled as three months of holdover income. Monthly reimbursements are $900/$1,200/$400. The 24-month projection runs November 2026 through October 2028, with $16,500 monthly operating, debt and capital outflows, $100,000 opening cash and no assumed replacement leases.
| Measure | Illustrative base result |
|---|---|
| Monthly income, projection months 1–3 | $20,000 |
| Monthly income, months 4–8 | $16,100 |
| Monthly income, months 9–24 | $8,700 |
| Minimum opening cash to avoid month-end deficit | $116,300 |
| Funding gap versus entered opening cash | $16,300 |
Operator A occupies two spaces and accounts for $10,000 of the $17,500 monthly base rent. The 1,000 sf not listed in the roll remains unknown, separately from 2,000 sf explicitly vacant.
Method, assumptions and DC source boundaries
These equations are our planning analysis. Agency sources explain legal or supervisory context; they do not validate a property, approve a lender request or supply the fictional rates and prices above. Method version 2026-10-25.3.
- The snapshot is supplied scheduled rent, not verified occupancy, cash collections or NOI. Related spaces share a tenant/operator group reference for base-rent concentration. Listed area cannot exceed total rentable area. Unlisted area remains unknown and is shown separately from explicitly vacant area.
- Rent-weighted remaining term includes fixed-term rows with positive base rent: sum(monthly base rent × days from snapshot to modeled stop) / sum(fixed-term base rent) / 365.25. Holdover rent is excluded from that average and shown separately. Rent expiring within 365 days is an annualized snapshot amount, not a projected year of collected rent.
- Projection starts on the first day of the calendar month after the snapshot; it does not prorate the snapshot month. Fixed-term rent runs through the entered stop date inclusively, prorated by active calendar days in an ending month. Monthly base rent and reimbursements stay constant; escalators, new leases, renewals, TI and leasing commissions are not inferred.
- Choose a supported stop date after reviewing lease expiration, breaks, options and other conditions. The date is a modeling assumption, not a legal finding. Expired fixed-term rows must be reviewed as holdover or vacant. Holdover income lasts only the entered number of future months and represents a cash scenario, not a right to continued occupancy or rent.
- The downside advances fixed-term stops by the entered calendar days and applies the collection-loss percentage to both base rent and reimbursements. Holdover duration is unchanged. Other income, operating expenses, capital spending and debt service remain the stated monthly amounts.
- Cash need is the largest cumulative month-end deficit before opening cash; the funding gap deducts entered opening cash. Intramonth timing, prior acquisition costs, loan maturity, taxes on owner income and unmodeled capital work can require additional funding. Use lease-up and debt tools for the separate re-leasing and financing plans.
Evidence to confirm
- Commercial Real Estate Lending, version 2.0Office of the Comptroller of the Currency · Context reviewed October 25, 2026 · Bank supervisory reference reviewed 2026-10-24, including March 2025 update note; not universal private-lender terms
- Certificate of Occupancy and zoning questionsDC Department of Buildings · Context reviewed October 25, 2026
- Real Property Tax Database SearchDC Office of Tax and Revenue · Context reviewed October 25, 2026 · Official instructions reviewed October 25, 2026; obtain and reconcile the actual parcel records in the linked application
Keep actual quotes, leases, tax/closing calculations, approval records and release conditions with your project. No automatic entitlement, valuation, savings or funding outcome is represented.