Can I Afford This Property?Commercial real estate financing, worked out

How to separate portfolio cash flow from a single property's debt coverage

A concrete evidence checklist and workpaper to isolate one property's net operating income from a portfolio's combined cash flow, so lenders can evaluate debt service coverage on the asset alone.

Source: CodexTopic: Portfolio and repayment planning983 wordsUpdated 2026-11-19

A concrete evidence checklist and workpaper to isolate one property's net operating income from a portfolio's combined cash flow, so lenders can evaluate debt service coverage on the asset alone.

When a sponsor owns multiple properties, lenders need to see whether the single property being financed can support its own debt payments, not whether the entire portfolio can. This guide gives you a document you can prepare—a property-level debt coverage workpaper—and explains how each line item affects the financing discussion.

Identify the property's gross rent and collected income

Start with the current rent roll, which is a snapshot of all leases in place as of a specific date. Record the gross potential rent (total rent if every unit or space were leased at market rates) and the actual scheduled rent (what tenants have agreed to pay). Then compare this to the trailing twelve months (T-12) of operating statements. The T-12 shows historical collected income—what actually arrived in the bank account—over the past year. The difference between scheduled rent and collected rent reveals collection loss, vacancy, and concessions. Lenders will look at both the snapshot and the history to assess income stability. OCC guidance notes that banks evaluate refinance risk by analyzing a loan's performance compared with expectations at underwriting, so having this comparison ready helps demonstrate whether the property is meeting its income projections.

Isolate the property's operating expenses

Pull the T-12 operating statements for this property only. Do not include expenses from other properties in your portfolio. Common line items include property management, utilities, insurance, repairs and maintenance, real estate taxes, and marketing. Add them to get total operating expenses. Then subtract total operating expenses from the property's effective gross income (gross potential rent minus vacancy and collection loss) to arrive at net operating income (NOI). This NOI is the cash flow available to pay debt service. If your portfolio uses a centralized management company that allocates costs across properties, ask the actual lender how they prefer to see those allocations documented. Some lenders may ask for a narrative or a separate schedule showing the allocation method.

Build a property-level debt coverage workpaper

Create a simple spreadsheet or document with these rows: - Gross potential rent - Vacancy and collection loss (as a percentage or dollar amount) - Effective gross income - Operating expenses (itemized) - Net operating income (NOI) - Annual debt service (principal and interest on the proposed loan, plus any existing debt on the property) - Debt service coverage ratio (NOI divided by annual debt service)

This workpaper separates the property from the portfolio. Lenders use the debt service coverage ratio as a key underwriting metric. The OCC states that underwriting standards may include debt service coverage requirements that provide a cushion if a borrower's financial condition declines or market conditions deteriorate. Ask the actual lender for their specific threshold.

Distinguish NOI from portfolio cash flow

Portfolio cash flow includes income and expenses from all properties, plus any corporate-level items like overhead, partner distributions, or intercompany loans. The property's NOI is only what this single asset generates. Do not add portfolio-level reserves, management fees paid to your own entity, or depreciation. Lenders want to see that the property can stand alone. OCC guidance on refinance risk emphasizes that collateral value alone is not sufficient to preclude adverse classification when well-defined weaknesses are present; loans that rely on cash flow generating collateral as the primary source of repayment would need to generate sufficient cash flow to repay the debt under reasonable terms.

Account for capital expenditures and reserves

Capital expenditures (roof replacement, HVAC, parking lot resurfacing) are not operating expenses. They come out of NOI before cash flow reaches the equity. On your workpaper, add a line for annual capital reserves (ask the actual lender for their preferred method). This adjusted NOI is sometimes called cash flow after reserves. Lenders may use this figure to test whether the property can handle both debt service and future capital needs. The OCC mentions that banks may require covenants that preserve the borrower's ability to refinance, such as leverage covenants or limits on incremental debt. Showing that you budget for capital needs demonstrates prudent management.

Prepare a debt service coverage summary

On a single page, list: - Property name and address - Date of rent roll - Period covered by T-12 - Gross potential rent - Effective gross income - NOI - Proposed loan amount, term, and estimated interest rate - Annual debt service - Debt service coverage ratio - Capital reserve amount (if applicable) - Cash flow after reserves

This summary gives the lender a clear, property-specific picture. The OCC advises that banks should have processes to identify, measure, monitor, and control refinance risk at both the transaction and portfolio levels. Your workpaper helps them do that for this transaction.

Frequently asked questions

Why can't I just show my portfolio's total cash flow?

Lenders underwrite the specific property that secures the loan. Portfolio cash flow may include income from other assets that could change or be sold. The lender needs to see that this property alone can service its debt. OCC guidance on refinance risk emphasizes evaluating borrower-specific factors, including the performance of the underlying project or asset.

What if the property has negative cash flow after debt service?

That signals a coverage problem. Lenders may still consider the loan if you can demonstrate a credible plan to improve income or reduce expenses, or if you have sufficient liquidity or guarantor strength to cover shortfalls. The OCC notes that banks may structure loans to mitigate refinance risk, such as requiring debt service coverage or loan-to-value requirements that provide a cushion.

Do I need to include my other properties in the workpaper?

Not for the debt coverage calculation itself. However, lenders may ask for a schedule of real estate owned to assess your overall financial strength and concentration risk. Keep that separate from the property-level workpaper.


Submission is a preliminary request, not an engagement or lender submission.

Run the numbers on your deal

Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.

Open the loan sizing calculator

Talk through your financing

Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. Wraith commercial real estate debt