Operating statement red flags

The main warning signs in a seller operating statement are revenue that cannot be tied to trailing actuals and leases, expenses supported only by estimates, and normalized figures with no bridge showing each adjustment. Coverage ratios add a second layer of risk, because a ratio built on NOI answers a different question from one built on net cash flow after capital items. A statement is credible when every line of the seller NOI can be rebuilt from trailing actuals plus a named, quantified adjustment.

Why seller figures drift in one direction

Sellers often overestimate revenue and underestimate expense. The first test is to lay every claimed line against trailing actuals, because a proforma is a forecast and trailing actuals are history.

The arithmetic explains why the two tilts matter together. NOI is revenue minus operating expenses, so an inflated revenue line and a deflated expense line both push NOI up. The errors add. A package can look only modestly optimistic on each line and still carry a large NOI gap in total.

Revenue support has two layers. Leases establish the contractual amount a tenant owes. Tenant credit review addresses whether that tenant can keep paying it. A rent roll that ties to the leases has answered the first question and left the second open.

Expense lines need the same treatment. A broker estimate of operating costs becomes usable only after it has been qualified against actual revenue and actual costs for the property. An estimate with no matching trailing line cannot be tested, and an estimate that sits below its trailing line needs a documented cause, such as a contract change or a one-time item in the base period.

The decision test is whether the seller NOI can be rebuilt from the trailing statement plus a short list of named adjustments. When the rebuild requires an unexplained plug, the plug is the red flag.

How a normalization bridge shows what moved

A normalized statement starts from the actual operating statement and adjusts it. The useful version reports each adjustment, explains it, and shows the difference between the actual and normalized results.

That difference is the control total. The adjustments listed in the bridge must sum to the gap between actual NOI and normalized NOI. If they fall short, an unlisted change is sitting somewhere in the statement.

An adjustment can calculate correctly and still lack support. A cost taken out of the expense base raises NOI by exactly that amount, which settles the arithmetic. Whether the cost belongs outside the base is a separate question that only the stated reason can answer.

Offsetting adjustments deserve their own lines. A revenue reduction paired with an equal expense reduction leaves NOI unchanged, yet both statement lines have moved. A bridge that nets them to zero hides two changes that each need support.

A full bridge also narrows disagreements. Two reviewers who accept the actual statement can isolate the one disputed adjustment, price its effect, and move on without reopening every line.

NOI, net cash flow and DSCR: where a capital item hides

NOI is revenues less operating expenses before capital items and debt service. Net cash flow is revenues less operating expenses and capital items, still before debt service. DSCR is net cash flow divided by debt service. The three definitions tie together, and a statement that blurs them can move a ratio without moving a dollar of cash.

Classification decides where a deduction lands. An operating expense reduces NOI. A capital item sits below NOI and reduces net cash flow. If the same expenditure is deducted once in either place, reclassifying it changes NOI and leaves net cash flow unchanged.

Higher NOI can therefore coexist with identical cash flow. A seller who moves an expenditure out of operating costs shows a better NOI and a better cap rate, which is one year of NOI over price, while the cash left after capital items is the same.

Coverage needs the same precision. If NOI replaces net cash flow in the numerator, the ratio changes whenever capital items are present. Two statements that both report coverage are comparable only when the numerator definition and the debt service period match.

Period matters as well. The most recent figures in a normalized reporting convention come from the latest trailing twelve month statement, so a seller statement built on a shorter or partly projected window is on a different basis.

Worked example: pricing an asset on seller proforma versus trailing actuals

This hypothetical uses one property and one set of terms in both cases. The price is $20,000,000 and the loan is 65 percent of price, which is $13,000,000. Capital items are $100,000 and annual debt service is $1,000,000, and both are identical in each case. Only the operating figures change.

The seller case uses the package figures: revenue of $2,000,000 and operating expenses of $700,000. NOI is $2,000,000 minus $700,000, which is $1,300,000. The cap rate is $1,300,000 divided by $20,000,000, which is 6.5 percent. Net cash flow is $1,300,000 minus $100,000, which is $1,200,000, and DSCR is $1,200,000 divided by $1,000,000, which is 1.2x.

The trailing case uses the actual statement: revenue of $1,880,000 and operating expenses of $790,000. NOI is $1,880,000 minus $790,000, which is $1,090,000. The cap rate is $1,090,000 divided by $20,000,000, which is 5.45 percent. Net cash flow is $1,090,000 minus $100,000, which is $990,000, and DSCR is $990,000 divided by $1,000,000, which is 0.99x.

The bridge between the two cases has two pieces. Revenue is overstated by $2,000,000 minus $1,880,000, which is $120,000. Expenses are understated by $790,000 minus $700,000, which is $90,000. The two pieces add to $210,000, and the NOI gap is $1,300,000 minus $1,090,000, which is also $210,000. The bridge closes.

At the same price, the yield on the trailing NOI is 1.05 percentage points lower than the seller yield, since 6.5 percent minus 5.45 percent is 1.05. Coverage drops below one times, and the shortfall against debt service is $1,000,000 minus $990,000, which is $10,000.

A labeling shift can soften that result. The trailing NOI of $1,090,000 divided by debt service of $1,000,000 gives 1.09x, which looks like coverage with room to spare. The net cash flow definition gives 0.99x. Neither figure is a pass or fail line, because lender thresholds vary, but the two ratios describe different cash.

Category formats differ by property type

Operating information is reported on four property type formats: commercial, multifamily, healthcare, lodging. Each format carries its own revenue and expense categories, customized to that property type.

The consequence is that two statements with similar-looking totals can mean different things. A line that exists in one format may have no home in another, and a combined line can swallow a component that the analysis format treats separately.

A category mapping from the seller statement to the analysis format keeps each amount traceable to its original line. When a total matches but the components do not, the mapping shows where the classification differs.

A blank category is ambiguous on its face. The amount may be absent, or it may sit in a neighboring line. The blank alone cannot say which.

A reformat and a normalization are separate operations. A reformatted statement can contain no economic adjustment, and a normalized statement can change revenue or costs without touching a single category name. Folding both into one reconciliation makes each harder to read.

Reading the statement inside an offering package

When the operating statement arrives through a syndication, it usually sits in a marketing deck first. The private placement memorandum that follows summarizes the deal and lists risks. The figures in the deck deserve a tie-out to the underlying statement, because a summary can carry a number the statement does not.

Warning lists for private offerings flag a refusal to provide written materials. They also flag sloppy documents. In an operating statement, sloppy shows up as periods that do not match across pages and totals that do not foot.

Lender asset management gives a useful reference point. Verification of operating-statement accuracy sits alongside early identification of underperforming assets and continuous risk rating. Verification is a standing step in that process, and the same step applies to a buyer reading a seller package.

Mistakes that make a seller statement look stronger

Projected revenue treated as trailing revenue erases the line between an assumption and reported performance. The arithmetic can still foot. The resulting NOI answers a forward question, and placing actual and projected columns side by side keeps each result tied to its basis.

A signed lease taken as complete revenue verification leaves the tenant out of the analysis. The lease sets the contractual claim, and credit review addresses the party behind it. A revenue conclusion built on only one of the two leaves the other question open.

A normalized total accepted without its bridge confuses the endpoint with its explanation. The total cannot say which changes produced it, and a correct sum can still rest on an adjustment with no stated reason. In the worked example, the bridge pieces of $120,000 and $90,000 are what make the $210,000 gap explainable.

An operating expense reclassified as a capital item, with capital items then ignored, hands the reclassification a cash flow effect it does not have. NOI rises when the expense leaves operating costs. Net cash flow still carries the deduction, so the improvement vanishes at that line.

One coverage label used for two numerators produces a false comparison. In the example, the same debt service yields 1.09x on NOI and 0.99x on net cash flow. A ratio quoted without its numerator definition cannot be compared with a lender figure or with another deal.

Statements for different property types forced into one shared category set, with no mapping, hide differences inside a matching label. Each property type format has its own categories, and the mapping is what shows how a seller amount entered the analysis.

Questions for reconciling a seller operating statement

Does the statement name one reporting period for operating results and debt service? A single period lets the operating result and the coverage ratio describe the same activity.

Can every revenue line be reconciled to trailing actuals? The reconciliation separates reported history from assumption.

Do the leases support the contractual revenue in the model? The lease terms are the documented basis for the modeled rent.

Is tenant credit addressed apart from the lease amount? The obligation and the capacity to pay answer different questions.

Can each expense estimate be explained against its trailing actual line? The explanation shows how much of the NOI result depends on the estimate.

Does every normalization adjustment carry an amount and a reason? The amount sizes the change and the reason supports it.

Do the bridge adjustments sum to the gap between actual and normalized NOI? A shortfall in the sum points to an unlisted change.

Are capital items deducted between NOI and net cash flow, and is the same expenditure deducted only once? A single deduction keeps a reclassification from changing cash flow.

Does the coverage figure state its numerator and its debt service period? Both inputs make the ratio reproducible.

Does the category mapping keep the components needed for this property type? A matching total can hide an unresolved classification difference.