Read the rent roll with the stacking plan and rollover beside it

1 · Learn the move · Template pattern

The decision a developer faces with the last pad on a site is whether to build the next building, and the existing buildings' rent roll is half the answer. Who sits where, how much rolls in the same year, and how much of the rent one tenant carries. A template makes that readable and comparable: the same three tables in the same order every quarter, with the columns named and the empty-cell rule written down. A stacking plan by building and suite. A rollover schedule by year with square feet and base rent summed from the roll. A concentration line with the math shown. Name what goes in a cell when the roll is blank, or the model fills it: a blank expiration becomes a plausible date, a vacant suite becomes zero rent and disappears from the square footage. The template says UNKNOWN for a blank field and VACANT for a vacant suite, and every sum shows its arithmetic. The template never contains a market rent column, because the roll does not have one.

Produce three tables and nothing else, from the rent roll only. STACKING: Building | Suite | Tenant | SF | Base rent $/SF | Expiration. ROLLOVER BY YEAR: Year | Suites | SF | Annual base rent. CONCENTRATION: top tenant share of base rent. Blank field reads UNKNOWN. Vacant suite reads VACANT and stays in the SF. Every sum shows its math. No market rent. [rent roll]