Skip to content

Outputs & exports

Pro forma & analysis

Read the cash flow annually or monthly, trace any cell, and reconcile Year 1 against the broker.

Pro Forma (⌘9) is the computed cash flow. Three tabs — Annual, Monthly, vs Broker — and a Single / Compare scenarios toggle. Every value is clickable: click any value for its math.

The annual pro forma: statistics rows (avg occupancy, economic occupancy, SF expiring, in-place and market $/SF) above revenue line items with EDIT chips, years Y1 through the exit year in columns.
Fig 01The statistics rows above the ledger are the fastest read of the deal's shape — occupancy path, rollover years, in-place vs market rent.

Rows with an EDIT chip jump to the input that owns them — the pro forma itself is never typed into. The header rail holds forward NOI at exit, net reversion, and the going-in/exit caps. ⌘C · copy as TSV copies the table for Excel; Export XLSX exports it; + Save view pins the current tab/filter combination.

The same ledger at monthly grain — 132 months on a 10-year hold with the exit year projected. Use it when timing matters: absorption, abatement burn-off, a mid-year expiry.

The monthly pro forma with month columns from Jul 2026 onward, showing physical occupancy, occupied SF, and revenue lines by month.
Fig 02Monthly grain. The occupancy stat rows show exactly which month a vacancy hits.

Your modeled Year 1 next to the broker’s pro forma, line by line, with the delta in dollars and percent, a severity Status chip, and the OM page citation (e.g. p.19) on every line.

The vs Broker view: Broker PF and Ours Y1 columns with deltas, status chips (High, Critical, Medium, Reconciled), per-line narrative explanations, Reconcile and Jump actions, and a Fix with agent button.
Fig 03A $122K vacancy divergence marked Critical, with the model's own explanation and a Jump to the input behind it. Fix with agent hands the line to the modeling agent.

Each divergent line explains itself in words (“We model +$129,993 more potential base rent than the broker — check market rents and occupancy”), then offers Jump → (go to the driving input), Reconcile (accept the difference as intended), or Fix with agent. Work it top to bottom after an OM build — this is the fidelity check.