How to Analyze a T12 Statement
Master T12 analysis for commercial real estate acquisitions. This guide covers how to read trailing 12-month operating statements, verify income, analyze expenses, calculate NOI, normalize for underwriting, and spot red flags.
What is a T12 Statement?
A T12 (trailing 12-month) statement—also called a trailing twelve or operating statement—shows a property's actual income and expenses over the most recent 12 months. It's the financial foundation for underwriting any commercial real estate acquisition.
While the rent roll tells you who's paying rent and when leases expire, the T12 tells you what the property actually earned and spent. Together, they provide the complete picture needed for due diligence.
Verify Income
Confirm that collected rent matches the rent roll and understand other income sources like CAM recoveries, parking, and late fees.
Analyze Expenses
Understand operating costs, compare to market benchmarks, and identify what will change under new ownership.
Calculate NOI
Determine true Net Operating Income after normalizations to accurately value the property and project returns.
Understand the T12 Structure
A T12 follows a standard structure: income at the top, expenses in the middle, and NOI at the bottom. Here's how the pieces fit together:
Sample T12 Structure
Key Formula
NOI = EGI - Operating Expenses
Where EGI = Gross Rent - Vacancy + Other Income
What NOI Excludes
- • Debt service (mortgage payments)
- • Capital expenditures
- • Depreciation & amortization
- • Income taxes
Verify and Analyze Income
The income section is where most T12 manipulation occurs. Cross-reference everything with the rent roll and ask questions about anything that doesn't match.
Gross Potential Rent (GPR)
Total rent if all units were leased at current contract rents with no vacancy.
Rent Roll Monthly Total × 12 ≈ T12 GPR Vacancy & Credit Loss
Actual vacancy, concessions, bad debt, and collection losses.
Other Income
CAM/NNN recoveries, parking, laundry, late fees, antenna income, etc.
Common Income Manipulation
Sellers sometimes include one-time income (lease termination fees, insurance proceeds) or project forward rent increases that haven't occurred. Always verify income is recurring and actually collected.
Analyze Operating Expenses
Expense analysis separates amateur investors from professionals. Understand each category, compare to benchmarks, and identify what will change under your ownership.
| Category | Description | Normalization Notes | Controllable? |
|---|---|---|---|
| Property Taxes | Real estate taxes paid to local government | Reassessment risk post-acquisition—often increases significantly | No |
| Insurance | Property, liability, and umbrella coverage | Verify coverage is adequate; rates have increased significantly | No |
| Utilities | Electric, gas, water, sewer, trash | Varies by lease structure (NNN vs gross); check who pays | Yes |
| Repairs & Maintenance | Routine repairs, HVAC service, plumbing, electrical | Low R&M often means deferred maintenance or capex miscategorization | Yes |
| Property Management | Third-party or in-house management fees | Normalize to market rate (3-6%) if self-managed or below market | Yes |
| Landscaping & Grounds | Lawn care, snow removal, parking lot maintenance | Often bundled into CAM recoveries for NNN properties | Yes |
| Administrative | Legal, accounting, marketing, leasing commissions | Leasing costs may spike with high turnover | Yes |
| Reserves | Set-aside for future capital needs | Add $0.15-$0.30/SF if not shown—lenders require it | No |
Controllable vs Non-Controllable
Controllable expenses (management, R&M, utilities) offer value-add potential through better operations. Non-controllable expenses (taxes, insurance) are largely fixed and may increase regardless of your actions.
Calculate Key Metrics
Beyond NOI, calculate these metrics to benchmark the property against market standards and identify areas for improvement.
| Metric | Formula | Benchmark | Interpretation |
|---|---|---|---|
| Operating Expense Ratio | Operating Expenses ÷ EGI | 30-45% (varies by type) | Higher = less efficient operations |
| Management Fee % | Management Fee ÷ EGI | 3-6% typical | Below 3% may need normalization |
| R&M per SF | Repairs & Maintenance ÷ Total SF | $0.50-$2.00/SF | Low R&M may indicate deferred maintenance |
| Property Tax per SF | Property Taxes ÷ Total SF | Varies by market | Will likely increase post-sale |
| Insurance per SF | Insurance ÷ Total SF | $0.15-$0.50/SF | Check for adequate coverage |
Expense Ratios by Property Type
Why Ratios Matter
An expense ratio significantly below market suggests either exceptional management (rare) or missing expenses that will appear post-acquisition. Above-market ratios indicate operational inefficiency or deferred maintenance being expensed.
Normalize for Underwriting
Historical T12 data must be adjusted to reflect what you will experience as the new owner. This normalization process is critical for accurate valuation.
Management Fee Normalization
If the property is self-managed or shows below-market fees, add 3-6% of EGI. A $1M EGI property with no management fee needs $30,000-$60,000 added to expenses.
Property Tax Adjustment
Current taxes are based on the prior sale price. After you acquire, taxes will reassess to your purchase price. In many markets, expect a 20-50% increase.
Add Reserves
If no replacement reserves are shown, add $0.15-$0.30/SF annually. Lenders require this, and it reflects real future capital needs.
Remove One-Time Items
Back out non-recurring expenses (legal settlement, one-time repairs) and income (lease termination fees, insurance proceeds) that won't repeat.
Insurance Market Adjustment
Insurance costs have increased 20-50% in many markets. If the T12 shows a policy that's up for renewal, get quotes for what you'll actually pay.
Normalization Example
Identify Red Flags
These warning signs indicate the T12 may not reflect true operating performance. Each requires investigation and potentially deal re-pricing.
Missing Management Fee
highSelf-managed properties often show no fee. Normalize to 3-6% of EGI for true operating costs.
No Reserves Shown
highLenders require reserves ($0.15-$0.30/SF). If missing, add to expenses for accurate NOI.
R&M Below $0.50/SF
mediumUnusually low repairs suggests deferred maintenance or capex being excluded from operating expenses.
T12 Income ≠ Rent Roll
highIf annual rent roll income differs from T12 by >5%, investigate concessions, bad debt, or data errors.
Declining Monthly Trend
highIncome dropping month-over-month could indicate tenant departures, rent cuts, or collection issues.
Large One-Time Items
mediumSpikes in any expense category need explanation. May be capital items miscategorized as operating.
Property Taxes Below Market
mediumCurrent taxes based on prior sale. Expect reassessment to purchase price—often 20-50% increase.
Utility Allocation Unclear
lowFor NNN properties, verify whether utilities are truly passed through or if exposure exists.
T12 + Rent Roll: The Complete Picture
The T12 and rent roll are complementary documents. Together they tell the full story of a property's financial health. Here's how to use them together:
Rent Roll Shows
- Who is paying rent (tenant roster)
- Contract rent amounts
- Lease terms and expirations
- Current vacancy
T12 Shows
- Actual collected income
- Operating expenses by category
- Monthly trends over 12 months
- Net Operating Income (NOI)
Reconciliation Check
Rent Roll Annual Rent should approximately equal T12 Gross Potential Rent. If they differ by more than 5%, investigate the cause—it could be concessions, timing, bad debt, or errors.
Automate Your T12 Analysis
Manual T12 analysis is tedious and error-prone. Categorizing expenses, calculating metrics, comparing to benchmarks, and cross-referencing with rent rolls takes hours. Modern tools can automate much of this work.
Auto-Categorize Expenses
AI maps line items to standard categories regardless of how the seller labeled them.
Calculate All Metrics
Instantly compute NOI, expense ratios, per-SF costs, and year-over-year trends.
Rent Roll Reconciliation
Automatically compare T12 income to rent roll and flag discrepancies.
Flag Red Flags
Automatic detection of missing categories, below-benchmark expenses, and anomalies.
Analyze T12s and Rent Rolls Together
CleanRoll.ai standardizes and analyzes both T12 statements and rent rolls. Upload your files and get instant metrics, reconciliation, and red flag detection.
3 free documents, no credit card required
Frequently Asked Questions
Common questions about T12 analysis