The first thing I do when a deal package lands on my desk is skip the pro forma. I go straight to the T-12. The pro forma is the seller's version of the future, written by someone who benefits if I believe it. The T-12 is the building's trailing twelve months of actual income and expenses, month by month. It is the only document in the package that shows what the building actually did, not what someone hopes it will do.

A T-12 is simple. It covers the most recent twelve months, ending at the last closed month, with one column per month and a total column. Gross potential rent at the top, vacancy and concessions below it, other income like laundry and parking, then every operating expense line, and net operating income at the bottom. The monthly columns matter. An annual total hides seasonality. A monthly T-12 shows me the winter heating spike, the summer turnover costs, and the month the insurance premium landed. If a seller hands me an annual summary instead of a monthly T-12, I ask for the monthly version before I do anything else.

Then I rebuild the NOI, because the seller's T-12 is a starting point, not a verdict. Three adjustments almost always move the number. First, property taxes. The T-12 shows taxes at the seller's assessment, and in most places a sale triggers a reassessment at or near the purchase price. I underwrite taxes on my basis, not theirs. Second, the management fee. A self-managing owner often reports no fee at all. I add one at the market rate, usually 3 to 4 percent of effective gross income, because the lender will add one regardless and my time is not free. Third, replacement reserves, typically 250 to 300 dollars per unit per year. The T-12 rarely includes them because they are not a cash expense, but every lender underwrites them. These three changes routinely move NOI by several percent, and several percent of NOI at a five and a half cap is a lot of value.

I also check the expense lines for what's missing. A repairs and maintenance line that is suspiciously low or trending down is a flag, not a bargain. It usually means deferred maintenance, which I will pay for later at a worse price. On a market-rate building, total operating expenses generally run 35 to 50 percent of effective gross income. When a T-12 shows a ratio well below that range, something has been left out. I would rather find the missing line now than discover it in my own operating statement next year.

The rent roll is the second document, and I use it to cross-check the T-12. The T-12 tells me what was collected. The rent roll tells me who is paying what, on what lease, and when it expires. I divide trailing collections from the T-12 by the rent roll's gross potential rent. If collections run 91 percent of gross potential rent and the seller claims 95 percent economic occupancy, the two documents disagree, and I trust the bank deposits. The T-12 is also where I catch the trailing three months trick. A broker who favors the T-3 is usually showing me annualized rent growth, which is fine for revenue, but annualizing three months of a seasonal expense is a good way to understate winter costs. I use the T-3 for revenue and the T-12 for expenses.

None of this makes the pro forma useless. Once I have rebuilt NOI from the T-12, I read the pro forma with my own numbers beside it. The gap between the two tells me what the seller is assuming: rent growth I haven't seen yet, expenses they haven't paid, a renovation program that exists on paper. Sometimes the gap is reasonable and the deal is a business plan I want to execute. Sometimes the gap is the whole deal, and there is nothing underneath it. The T-12 does not tell me whether to buy the building. It tells me what I am actually buying, and that is the only honest place to start.

← All insights