Skip to content
CRE Agents LogoCRE Agents
All Posts
Underwriting

Stop hand-building T-12s in Excel

Append T1, T3, T6, and T12 columns to a monthly operating statement with clean formulas and matching format.

VicVic
January 14, 20263 min read
Stop hand-building T-12s in Excel

You have the monthly operating statement open, a deadline coming up, and you still need T1, T3, T6, and T12. It is the same routine every time. Insert columns, write formulas, drag them across every line, then check that nothing broke.

The risk is not the math. It is the small mistakes that creep in when you rush. One misaligned range or a missed row and your NOI rolls are off. This task cuts that step out.

Underwriting
~5 min to run
Annualize a Monthly Operating Statement
Vic prompt
Use Vic to add annualized T1, T3, T6, and T12 columns to the monthly operating statement for the 180,000 sf industrial asset.
Purpose
Produces clean annualized data for NOI and T-12 analysis without manual formula work. Cuts the task from roughly 20 minutes to about 5 minutes.
Inputs
Property Income Statement With Monthly PeriodsRequired
Outputs
The original file returned as [original-name]_annualized.xlsx with four new trailing columns, formulas applied to all rows, and formatting copied from the source.
Time saved
Turns roughly 20 minutes of manual work into about 5 minutes.

How it works

You give Vic the existing monthly operating statement as is. No reformatting, no setup. Vic reads the sheet, finds the last monthly column, and inserts four new columns right after it labeled T1, T3, T6, and T12.

Run it with a single line: "Use Vic to add annualized T1, T3, T6, and T12 columns to the monthly operating statement for the 180,000 sf industrial asset."

Vic then builds the trailing period formulas for every data row. T1 pulls the most recent month, T3 sums the last three, T6 the last six, and T12 the full trailing year. The formulas fill across the entire statement so revenue, expenses, and subtotals all update the same way.

The output keeps your file intact. Headers stay in the same style. Number formats carry through so currency, commas, and decimals match what you started with. You get the original file back as a new workbook with an _annualized suffix, with the four trailing columns added and ready to use.

This part gets overlooked. Matching the source format matters because these files move. They go into IC decks, to lenders, and to asset management. When the annualized columns look like they were always part of the sheet, no one stops to question them.

The time savings are real, but the bigger win is consistency. Every property, every time, the trailing periods are built the same way across each line item. You are not rethinking formulas or checking whether a row was skipped. You can go straight to reviewing trends, variances, and what is driving NOI.

There is also a quieter benefit when you revisit a deal weeks later. You are not decoding your own spreadsheet to remember how you set up T6. It is already there, clean and uniform.

In practice, this takes about five minutes end to end. The manual version is closer to twenty once you include checks. More if you are careful, which you should be when these numbers feed decisions.

If your workflow still includes building T12s by hand, this is easy to offload. Keep your attention on the analysis. Let the columns take care of themselves.

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.