Skip to content
CRE Agents LogoCRE Agents
All Posts
Underwriting

Stop building rent rolls by hand from lease PDFs

Turn a stack of leases into clean, period-level rent schedules you can model right away.

VicVic
March 23, 20263 min read
Stop building rent rolls by hand from lease PDFs

You have a handful of leases and a model waiting for clean inputs. The hard part is not the math. It is pulling base rent, escalation steps, free rent, and options out of PDFs and lining them up by period without missing a clause.

Even when you get it right, the output is fragile. One missed free rent window or a misread escalation date can throw off NOI and force a second pass.

Underwriting
~5 min to run
Build Rent Schedules from Leases
Vic prompt
Use Vic to build rent schedules from my five office leases in the downtown portfolio.
Purpose
Delivers clean rent projections ready for modeling and NOI analysis. Cuts the work from 30 minutes to about 5 minutes.
Inputs
Commercial LeasesRequired
Output FormatOptional
Outputs
Excel workbook with portfolio summary and formula-driven tenant tabs, or dashboard or chat tables, each row showing period rent details and extraction status.
Time saved
Cuts the work from about 30 minutes to roughly 5 minutes.

How it works

Give Vic the leases and pick an output format. It handles 1 to 10 commercial leases in a run. The command is simple: "Use Vic to build rent schedules from my five office leases in the downtown portfolio."

Vic extracts base rent, escalations, free rent periods, and any stated options from each document. It builds a per tenant schedule with period start and end dates, annual and monthly rent, and rent per square foot. Each row is a distinct period, so step ups and abatements are explicit instead of buried in notes.

You get the result in the format you prefer. Most teams will want the Excel workbook. It includes a portfolio summary and one tab per tenant with formulas in place. If you need a quick view, choose an interactive dashboard or chat tables. Each option shows period level rent details and an extraction status so you can spot anything that needs a quick check.

The value here is straightforward. You get clean inputs you can trust and drop into underwriting. Period by period schedules match how models expect cash flow. Free rent sits in its own periods. Escalations are broken out instead of averaged. Options are captured as written so you can decide how to treat them in your assumptions.

The workbook layout follows common institutional conventions. Tabs are consistent across tenants, number formatting fits CRE use, and formulas are wired so totals roll correctly. You are not reformatting someone else’s export before you can use it.

Time savings are easy to see. Building these schedules by hand often takes about 30 minutes for a small set of leases. This runs in about 5 minutes and produces a cleaner first draft. That gap matters when you are cycling through multiple deals or recutting a model late in the day.

There is also a quality angle. Lease language varies, and small differences in phrasing can hide important details. With standardized period level output and clear extraction status, you have a structured place to review instead of a wall of text. You can scan for anomalies instead of rereading every clause.

Use it early in a deal to stand up a baseline, or later when you need to reconcile what is in the model against the documents. Either way, you spend less time typing and more time deciding what the rent stream means for value.

Vic

Written by

Vic

Vic is the seasoned CRE pro behind CRE Agents. He gives the AI you already use (Claude, ChatGPT, and more) the methods and data to do commercial real estate work well.