THE CHICAGO COMMERCIAL REAL ESTATE FIELD GUIDEAn educational publication backed by Jaken Finance Group
Underwriting & valuation

Reading trailing-twelve-month statements for timing distortions

A T12 is a reporting window, not a stabilized forecast. Reconcile cash timing, accruals, seasonality, nonrecurring items, and lease changes before annualizing it.

Source-checked editorial resource · See cited sources and assumptions below.
Detailed limestone commercial building facade — AI-generated conceptual illustration
AI-generated architectural illustration · Not an actual financed property

Read a trailing-twelve-month statement as a record of a particular period under a particular accounting basis. It is not automatically the property’s recurring income or the buyer’s first-year cash flow. Late payments, prepayments, annual invoices, concessions, lease changes, and one-time transactions can distort the apparent run rate.

The useful method is to reconcile monthly revenue and expenses to leases, receivables, invoices, and bank activity. Identify whether each variance reflects timing, collectibility, seasonality, a permanent change, or a nonrecurring event. Preserve those categories instead of using one unexplained normalization adjustment.

Establish what the T 12 actually contains

Record the beginning and ending months, whether the current month is complete, cash or accrual basis, property coverage, and any accounting changes. A statement ending midmonth should not be compared casually with twelve complete months.

Request the underlying general ledger and a multi-year monthly history where available. The annual total may look reasonable while individual months reveal duplicate expenses, missing invoices, arrears collections, or rent commencing late in the period.

Determine whether the report combines owner-level financing and property operations. Interest, principal, capital expenditures, distributions, and income taxes can appear in a general accounting report but require separate treatment in an investment NOI model. Do not assume the manager’s subtotal matches the buyer’s convention.

A hypothetical cash-basis revenue reconciliation

Assume a T 12 shows $600,000 of cash receipts. Further review identifies $60,000 of prior-period rent arrears, a $40,000 lease termination payment, and $24,000 of prepaid rent attributable to the next period. Removing those specific items leaves $476,000 of receipts attributable to recurring rent in the analyzed period under the stated assumptions.

Revenue review Amount
Reported receipts $600,000
Prior-period arrears collected ($60,000)
One-time termination payment ($40,000)
Next-period prepaid rent ($24,000)
Remaining period-related recurring receipts $476,000

This is not automatically normalized future revenue. The future must still reflect current leases, concessions, vacancy, and collection expectations. The reconciliation only explains why the $600,000 total should not be annualized as recurring rent.

The arrears collection is real cash. Its removal from a recurring run-rate estimate does not erase the deposit. Preserve cash reporting and the analytical adjustment as separate views so the investor can understand both.

Timing differences are not necessarily losses

A tenant paying January rent in February can create a monthly variance without changing annual collections. A tenant that has not paid for six months presents a different question. Receivables aging and subsequent receipts help distinguish delay from impairment.

Avoid assuming all outstanding rent will be recovered or all arrears are worthless. Investigate the tenant’s payment history, dispute, deposit, guarantee, and current circumstances. Record uncertainty rather than substitute a blanket percentage without evidence.

A prepaid amount also requires care. It may improve closing cash while creating an obligation to provide occupancy or credit rent later. The settlement treatment and lease determine allocation between seller and buyer. Do not count it as both new buyer revenue and a separate available cash asset.

Assume reported cash operating expenses are $200,000, including $36,000 of insurance payments. Of that insurance amount, $12,000 settles a prior-period invoice and $24,000 relates to the current year. If all other expenses are appropriately period-matched, adjusting out the prior-period item gives $188,000 of period-related expense.

A cash-basis NOI of $400,000 from $600,000 receipts less $200,000 expenses therefore tells a different story from the adjusted $288,000 using $476,000 revenue less $188,000 expenses. Neither is yet a complete future underwriting conclusion.

This illustrates why a buyer cannot correct revenue timing while ignoring expense timing. Apply the same period-matching discipline to both sides. Keep the original reported result intact and present the adjustment bridge.

Distinguish seasonality from a changed run rate

Heating, snow-related work, landscape services, tourism, storage demand, or other activity can vary by month depending on the property. A single strong or weak quarter should not automatically be multiplied by four.

Compare the same months across years and investigate actual operational causes. An unusually severe event can be nonrecurring without proving that the long-term average is zero. Conversely, repeating an old annual average can understate a newly signed contract or an actual increase in required services.

For Chicago-area property, obtain actual bills and the correct jurisdictional information rather than assume a generic payment calendar. Accruing tax expense monthly and paying a bill on its due date are different events. The operating statement and liquidity forecast should reflect their respective purposes.

New leases make the trailing year backward-looking

A tenant beginning paid rent in the final quarter contributes only part of its annual rate to the T 12. That can understate future contracted revenue if the tenant is performing. A tenant that left shortly before the period ended can have the opposite effect.

Build an in-place rent schedule as of the underwriting date. Reconcile it to the T 12 and show a first-year forecast with actual commencement, expiration, and concession dates. Do not simply replace every historical rent with full market rent.

Tenant improvements and commissions can also occur before rent appears. A report with strong NOI might exclude those capital payments. A report with weak cash might include a funded transition that supports later revenue. Both require a separate capital and funding schedule.

Recoveries can be billed after the cost period

Commercial CAM reconciliations can create large receipts or credits outside the period of the underlying expense. Inspect the lease terms, reconciliation calculation, tenant billings, collections, and unresolved objections.

A late annual recovery receipt should not be treated as a new recurring monthly revenue level. Similarly, an expense increase does not mean the landlord absorbs all of it if the actual leases permit and support recovery. Calculate the economics rather than annualize the latest net number.

Kimco’s annual filing offers a public example of commercial lease income and expense disclosure. Its accounting conventions and portfolio are not evidence that a subject property’s CAM receivable is collectible. Kimco 2025 Form 10-K

Keep one-time items symmetrical

A lease termination payment, insurance recovery, unusual legal cost, or major repair requires an explanation. Determine whether the event changes future operations or only the current period. An insurance recovery may offset a loss with associated repair obligations rather than represent unencumbered earnings.

Do not remove unusual expenses while retaining unusual revenue. Also avoid calling every recurring repair a one-time cost merely because the specific component differs each year. Aging buildings can have a pattern of lumpy but economically recurring capital needs.

Where a cost is reclassified from operating expense to capital, retain it in the cash-flow model. Fannie Mae’s NCF definition provides one example of explicitly separating a reserve adjustment from NOI; the investor must state the convention actually used. Fannie Mae NCF definition

Maintain the reported historical T 12, an analytically adjusted historical view, and a forward cash-flow forecast. The first preserves the record. The second explains period and classification issues. The third projects the buyer’s economics using current evidence and assumptions.

A lender may calculate another underwritten view. Reconcile it separately. The OCC handbook provides lending-analysis context, while the lender’s accepted inputs and transaction documents determine the actual financing analysis. OCC CRE handbook

Include a short open-items register with amounts, documents requested, and deadlines. If a large favorable adjustment remains unsupported, show a case excluding it. That is more decision-useful than hiding uncertainty inside a single “normalized NOI” cell.

Monitoring after acquisition

Retain the same definitions over time and explain changes. Compare actual collections, accruals, recoveries, expenses, capital, and cash with the acquisition forecast. Investigate both favorable and unfavorable variances.

A T 12 becomes most useful when investors understand why it changed. The goal is not to make a trailing statement look stabilized. It is to identify what the property actually earned, what cash moved, and what those facts support about the coming ownership period.

Understand the rolling-window effect

A T 12 changes by adding the newest month and removing the oldest. A large improvement can therefore arise because a weak month drops out, not because current performance suddenly improved. Reconcile the change in total to those two months before attributing it to management or market conditions.

For example, replacing a month with $20,000 receipts with a month containing $50,000 increases the T 12 by $30,000. If the new month includes a $25,000 arrears collection, only $5,000 of that change may reflect other receipt differences under the stated facts. The cash is real, but the inference about recurring growth requires more analysis.

Preserve the original files received from the seller and record subsequent revisions. If a revised statement changes an earlier month, ask for the accounting explanation and supporting entry. Comparing a revised T 12 with an unrevised older report can create false trends. Version control and a simple adjustment log are particularly useful when a transaction spans several monthly reporting cycles.

Keep the corrected accrual presentation and the actual bank-payment calendar. The former helps compare recurring economics; the latter identifies when the owner needs cash.

The cited Fannie Mae glossary is the version effective April 30, 2026; its terminology is program-specific and should be reconciled with the applicable product and current loan documents.