What Is a T12 (T-12) in Real Estate? How to Read One

What is a T12?

A T12 (also written T-12 or TTM, short for trailing twelve months) is an operating statement that shows a property’s actual income and expenses for each of the last 12 months, plus a total column. It ends at the most recent closed month, so a T12 received in October covers October of last year through September of this year.

Brokers include one in most offering packages, usually as a PDF export from the owner’s accounting system, such as Yardi, RealPage, AppFolio or QuickBooks. Layouts vary, but the content is the same: what the property earned and what it spent, month by month.

The bottom line is net operating income (NOI). Everything you do with a T12 comes back to two questions: is that NOI accurate, and will it hold up once you own the building?

What lines a T12 contains

Most T12s follow the order of a standard real estate income statement.

Income

• Gross potential rent (GPR): the rent the property would collect with every unit occupied at its current rent.
• Vacancy and credit loss: rent lost to empty units and non-payment. Concessions are included here or shown on their own line. Shown as a negative.
• Other income: parking, laundry, pet fees, late and application fees, utility reimbursements (often billed through RUBS), storage.
• Effective gross income (EGI): GPR minus vacancy and credit loss, plus other income. This is the income the property actually earned.

Operating expenses

• Real estate taxes
• Insurance
• Utilities the owner pays (water and sewer, common-area electric, gas, trash)
• Repairs and maintenance
• Payroll for on-site staff
• Contract services (landscaping, pest control, elevator, security)
• Marketing and leasing
• General and administrative
• Management fee

NOI is EGI minus total operating expenses.

Debt service, capital expenditures, depreciation and owner distributions are “below the line” and don’t belong in NOI. If a T12 includes them in operating expenses, that’s the first thing to fix.

T12 vs T3 vs budget vs pro forma

These are four different documents, and each one says something different about the same building.

A T12 reports 12 months of actuals. It smooths out seasonal costs, such as snow removal in winter and unit turnover in summer, and gives you a full year of expenses. Its weakness is lag. If rents moved in the last quarter, the T12 won’t fully reflect where the property is today.

A T3 (trailing three months, annualized) takes the last 3 months and multiplies them by 4. Brokers favor it when rents are rising because it shows the highest run-rate revenue. Be careful using it for expenses. Annualizing 3 months of a seasonal cost will overstate or understate that cost depending on the season. The common approach is T3 for revenue and T12 for expenses.

A budget is the owner’s plan for the current year. It tells you what the owner expected to spend, not what was actually spent.

A pro forma is the broker’s projection of how the property will perform under new ownership, usually after rent increases and a renovation program. Every number in it is a forecast. Don’t use it in your underwriting until you’ve rebuilt it with your own assumptions.

How to normalize a T12

The T12 reports what the current owner did. You're underwriting what you'll do. Normalizing closes that gap.

One-time items: a roof repair or a legal settlement, for example. Remove them from the trailing expenses, then decide separately whether you’re likely to face a similar cost. The test is whether it would recur in a normal year.

Owner-specific expenses: owner salary, travel, or a related-party vendor charging below-market rates. Remove them and replace them with a market cost where the service is still needed.

Below-the-line items: debt service, capex, depreciation, amortization and partnership costs. Move them out of operating expenses if the owner’s accountant included them.

Management fee: self-managed properties often show no fee at all. Add one at the market rate for the asset size, typically 2.5% to 4% of EGI for multifamily. Your lender will include one regardless.

Replacement reserves: most T12s don’t include reserves because they aren’t a cash expense. Lenders underwrite them anyway, often $250 to $300 per unit per year for multifamily. Include them in your underwriting, either above or below NOI depending on your firm’s convention.

Real estate taxes: this is the most common normalization error. The T12 shows taxes based on the seller’s assessment, but in many jurisdictions a sale triggers a reassessment at or near the purchase price. Recalculate taxes on the post-sale value.

Normalizing the T12 is the first step of full underwriting. Our guide to commercial real estate underwriting takes it from there.

Red flags to check before you trust the NOI

Expense lines that drop in the last quarter. If repairs ran $11,000 a month for nine months and then $4,000 for three, someone stopped fixing things ahead of the sale. Annualize the earlier run rate.

Missing months. A "T12" with eleven months, or with a month that reads zero on every line, isn't a T12. Ask for the full statement.

Revenue that doesn't match the rent roll. Multiply the rent roll's in-place monthly rent by 12 and compare it with the T12's collected rent. A gap of a few percent is normal. A gap of 10% or more means something changed recently (units re-rented, a tenant who stopped paying) or someone's numbers are wrong. More on this below.

A worked example: 120-unit multifamily

Here is a T12 summary for a 120-unit garden-style multifamily property, as it might arrive from a broker. Average in-place rent is $1,500 a month.

A few quick ratios:

• Operating expenses are 47.5% of EGI, or $8,417 per unit.
• NOI is $9,303 per unit.
• The management fee is 3% of EGI, which is a market rate, so it doesn’t need adjusting.

Now normalize it. The monthly detail turns up three adjustments.

1. One-time repair. Repairs and maintenance include a $22,000 roof repair in March. It’s a one-time cost, so add it back. NOI rises to $1,138,400.
2. Reserves. The T12 carries no replacement reserves. Add $300 per unit, or $36,000. NOI falls to $1,102,400.
3. Taxes. The $310,000 in taxes is based on the seller’s assessment. The broker’s pricing guidance is $19.5 million. Applying the county’s tax rate to a reassessed value near that price, you estimate taxes of $390,000, an increase of $80,000. NOI falls to $1,022,400.

Your underwritten NOI is $1,022,400, about 8.4% below the T12. At the $19.5 million guidance price, the going-in cap rate drops from 5.7% on the T12 NOI to 5.2% on your normalized NOI. That half-point difference is why the T12 deserves a closer read than the executive summary.

We use the same property in the debt yield guide, where a lender takes the normalized NOI and works backward to the loan it will write, and in the offering memorandum guide, where the broker’s pro forma takes the same property to an NOI of $1,343,200.

How to tie the T12 to the rent roll

The rent roll is a snapshot of the property today. The T12 is a record of the past year. The two won’t match exactly, but they should point in the same direction.

Start with rent. Take the rent roll’s total monthly in-place rent for occupied units and multiply by 12. On our 120-unit property, the rent roll shows 113 occupied units at an average of $1,520 a month. That’s $171,760 a month, or $2,061,120 a year. The T12 shows 2,030,400collected(2,160,000 less $129,600). The rent roll runs 1.5% ahead, which is consistent with modest rent growth over the year.

Then check occupancy. 113 of 120 is 94.2% physical occupancy; the T12's 6% vacancy and credit loss implies economic occupancy of about 94%. Close enough.

When the two disagree by more than a few percent, ask the broker for the last three months of rent collection reports. The answer is usually mundane. Once in a while it is the whole deal. Our rent roll template has a tie-out tab built for this.

The T12 template

Broker T12s arrive in whatever layout the owner’s software produces. Rebuilding each one in a standard format lets you compare this deal’s expense ratios with every other deal you’ve reviewed.

The template has three tabs:

1. T12: one row per standard line item, 12 monthly columns, a trailing 12-month total, a per-unit column and a percent-of-EGI column, with below-the-line items separated at the bottom.
2. Normalization: broker figure, adjustment, reason and underwritten figure for each line.
3. Rent roll tie-out: the check described above.

What Altrio does with the T12

Altrio connects to your Gmail or Outlook inbox and captures the deals your whitelisted brokers send. When an offering package arrives, Altrio extracts the data from the T12, OM and rent roll and saves it to the deal, so the trailing NOI and the rent roll are easily accessible without anyone retyping them. You still do the normalization, but the data entry is handled for you. Read more about how Altrio reads the T12 and other deal documents.

$49 per user per month, with a 30-day free trial and no credit card required. Start free