Reconciling borrower NOI with lender net cash flow

An owner's net operating income and a lender's underwritten net cash flow can describe different things without either arithmetic calculation being wrong. The owner may report a historical accounting result. The lender may estimate sustainable income, normalize expenses and deduct a recurring replacement allowance. The financing decision depends on understanding that bridge, not on choosing the larger label.

The OCC explains that underwriting income may reflect market vacancy, management expense and replacement provisions that differ from actual immediate cash payments. It also distinguishes covenant definitions from underwriting calculations.^[1] Therefore, ask for the lender's line-by-line calculation and preserve the original operating statement alongside it. A renamed subtotal is not an explanation.

Identify the accounting starting point

Specify whether the statement uses cash or accrual accounting, the period covered and the treatment of unpaid bills, receivables, concessions and capital work. A cash-basis year with an unpaid tax installment can look unusually profitable even though the obligation still exists. The OCC identifies that kind of cash-versus-accrual mismatch in its income analysis.^[1]

Reconcile general-ledger categories before making underwriting adjustments. A maintenance invoice coded to capital work can affect the reported operating result; a roof replacement coded entirely to repairs can depress it. The financing team needs the underlying scope and invoice, not just the account name, to decide whether an adjustment is supportable.

Keep entity expenses separate from property expenses where appropriate, but disclose the distinction. Partnership administration, investor distributions, mortgage interest and the property's recurring operations should not be mixed without a clear presentation. The particular lender's accepted definition determines the sizing subtotal; the owner's full cash budget still needs every actual cash obligation.

Make revenue changes visible

Create separate rows for contractual rent, vacancy, concessions, collection loss, other income and any proposed annualization. Label adjustments as historical corrections, current documented changes or forecast assumptions. Those categories require different evidence. A signed renewal can support a contractual change; an anticipated future renewal is a forecast.

Freddie Mac's appraisal chapter calls for historical and current rental evidence, explanations of differences from market rent, and analysis of concessions and vacancy.^[2] Those requirements apply to the cited appraisal process. They do not mean every lender uses the same revenue haircut, but they identify the evidence needed to assess a sustainable income claim.

Exclude a receipt from sustainable revenue when its recurrence has not been established under the relevant underwriting. An insurance recovery or a one-time vendor credit may belong in the actual cash history without belonging in a recurring forecast. Explain its source and classification rather than silently remove or retain it. That gives the lender a defensible comparison and preserves the owner's accounting record.

Normalize expenses without concealing deterioration

Request support for each changed expense: management contract, payroll plan, utility history, insurance renewal, tax analysis or service agreement. A projected reduction should identify the action that causes it and any offsetting cost. A saving dependent on doing less necessary maintenance should be examined as a physical-condition risk, rather than assumed to be an operating efficiency.

Freddie's appraisal chapter requires comparison of forecast expenses and replacement reserves with property history and verified market data, including consideration of future changes.^[2] This is more informative than applying a single percentage to every building. Age, amenities, metering and condition can explain expense differences that remain relevant after refinance.

A nonrecurring expense adjustment requires the same discipline. Record what happened, why it is not expected to recur, and whether any replacement obligation remains. If a $120,000 legal expense ended but an ongoing compliance consultant now costs $60,000 annually, adding back the full $120,000 without the replacement cost misstates the future benefit.

Follow an illustrative bridge into debt capacity

Consider an original hypothetical property with $7.8 million of reported annual NOI before a separate recurring replacement allowance. The lender proposes $180,000 less recurring revenue, $160,000 more management expense, $220,000 more taxes, $90,000 more insurance, and a $240,000 replacement allowance. It accepts a $120,000 nonrecurring expense addback with no assumed replacement expense.

Accepted net cash flow becomes $7.03 million. Each adjustment is an invented example of a documented disagreement, not a required agency haircut. The aggregate $770,000 difference should be explained by evidence for each row. It should not appear only as an unexplained change from “NOI” to “NCF.”

Suppose the sponsor requests $82 million and the lender tests a 7.1% annual debt constant with 1.30 coverage. Annual debt service is $5.822 million. Reported NOI implies approximately 1.34 coverage; accepted cash flow implies approximately 1.21. The same loan and payment produce different results because the income basis changes.

Coverage capacity using accepted cash flow is approximately $76.165 million. Using reported NOI would imply approximately $84.507 million under the same assumptions. The approximately $8.342 million difference is larger than the annual adjustment because each dollar of sustainable income supports several dollars of principal. Other credit constraints can still reduce either result.

Distinguish recurring allowance from restricted cash

An underwriting replacement allowance is not automatically identical to the monthly reserve deposit, a repair escrow or the entire capital plan. Identify the purpose and amount of each. A one-time closing repair need can consume financing cash without becoming the recurring expense deduction used in a valuation model.

Freddie's reserve chapter addresses recurring reserve sufficiency and separate repair administration, including conditions for release.^[3] Its rules apply to the covered mortgage and servicing arrangement. An owner should not count a lender-held balance as unrestricted liquidity merely because the money supports work at the same property.

In the example, assume a $73 million payoff, $900,000 of transaction costs, a $700,000 repair escrow and $800,000 retained operating liquidity. The $76.165 million gross loan leaves approximately $765,000 after those uses. The originally requested $82 million would have left $6.6 million. These closing uses do not repeat the annual $240,000 allowance; they are separately defined cash requirements.

Preserve three reconciliations after closing

Maintain reported operations, the underwriting bridge and actual unrestricted cash as separate but connected records. An expense normalization can affect debt capacity without being the cash paid in a particular month. A reserve deposit can affect cash while receiving different treatment in the applicable income definition.

Freddie's financial-reporting chapter illustrates that reporting treatment can be specific: its covered floating-rate assessments separate derivative receipts from other property income and reflect them through debt-service reporting.^[4] A hedge receipt should not be inserted into property NOI merely to improve an owner's ratio when the applicable definition excludes it.

The same chapter requires certified operating statements and rent rolls for relevant assessments.^[4] Reconcile those submissions to the owner records and preserve the exact version delivered. If an annual reported result differs from the closing underwriting, explain whether the change reflects operations, timing, an accepted forecast that did not occur or a definition difference.

Resolve disagreements through evidence and sensitivity

Ask which bridge items are binding, what evidence could change them and whether the lender has accepted the correction. Separate an arithmetic error from a credit judgment. A lender using a higher future tax expense may be making an underwriting decision; a duplicated tax deduction is a reconciliation error.

Prioritize changes with a credible operational basis. Under the example's assumptions, recovering $100,000 of accepted recurring cash flow supports approximately $1.083 million of principal. That sensitivity helps identify meaningful issues, but it cannot justify inventing revenue or deferring work. The OCC's framework calls for supported income and stress testing.^[1]

The useful output is a signed-off income bridge with source evidence, a debt-capacity calculation and a separate closing cash schedule. It allows ownership to understand both the lender's accepted repayment case and the money actually available after the financing. Those are related decisions, and each needs its own clear calculation.