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

Documenting lender sizing targets separately from borrower assumptions

Lenders size debt service capacity from their own underwriting criteria, not the sponsor's pro forma. This guide provides a concrete evidence checklist to document how a lender's debt service coverage test works, what financial data supports it, and where borrower assumptions must be kept separate from that analysis.

Source: CodexTopic: Debt service and coverage1242 wordsUpdated 2026-11-19

Lenders size debt service capacity from their own underwriting criteria, not the sponsor's pro forma. This guide provides a concrete evidence checklist to document how a lender's debt service coverage test works, what financial data supports it, and where borrower assumptions must be kept separate from that analysis.

When a sponsor prepares a financing request, the temptation is to lead with the borrower's own projected debt service coverage. Lenders, however, apply their own sizing tests, often using different income figures, expense loads, and reserve assumptions. This guide explains how to document a lender's debt service coverage analysis separately from the sponsor's internal projections, and provides a concrete evidence checklist to prepare.

Understanding the lender's debt service coverage test

Lenders size a permanent loan by applying a debt service coverage ratio (DSCR) to the property's net operating income (NOI). Underwriting includes determining whether the borrower demonstrates the capacity to meet a realistic repayment plan from available cash flow. [1] The lender's DSCR is not the same as the sponsor's cash-on-cash return or equity dividend rate. The lender typically requires NOI to exceed annual debt service by a minimum multiple, but the specific ratio varies by lender, property type, and market. The sponsor's task is to document how the lender's test is applied, not to assume the lender will accept the sponsor's own coverage ratio.

Separating lender underwriting income from borrower pro forma

Borrower pro formas often project gross potential rent, then deduct vacancy and collection loss at a market average, and apply operating expenses based on the sponsor's experience. Lenders often review the trailing twelve months (T-12) of actual operating statements as part of underwriting, rather than relying solely on the pro forma. [1] The T-12 is a historical record of twelve consecutive months of income and expenses. The current rent roll is a snapshot of in-place leases. Lenders compare the T-12 to the rent roll to identify trends, rent concessions, and expense anomalies. The sponsor should prepare a reconciliation that shows how the T-12 actual NOI compares to the pro forma NOI, and identify any differences caused by one-time items, capital expenditures, or management fees.

Evidence checklist for debt service coverage

Prepare a single workpaper that documents the following for the lender's debt service coverage test:

  • Gross rental income: from the T-12, adjusted for known rent steps, lease expirations, and vacancy changes.
  • Other income: parking, storage, laundry, signage, and any other recurring revenue, with evidence of historical collection.
  • Vacancy and collection loss: the lender's assumed rate, which may be higher than the property's actual experience, especially for properties with short lease terms or single-tenant exposure.
  • Operating expenses: property taxes, insurance, utilities, repairs and maintenance, management fees, and replacement reserves. Lenders often use a stabilized expense load, not the actual year's expenses if they were unusually low.
  • Net operating income: the resulting NOI after the lender's adjustments.
  • Annual debt service: principal and interest payments on the proposed loan, calculated at the lender's qualifying rate, not the sponsor's expected rate.
  • Debt service coverage ratio: NOI divided by annual debt service. If the ratio is below the lender's minimum, the loan amount must be reduced, or the sponsor must contribute more equity.
  • Global cash flow: cash flows should be assessed on a global basis, integrating cash flows from business financial statements, tax returns, and Schedule K-1 forms for multiple entities. [1] The lender may require a global cash flow summary that shows all sources of income and all debt obligations, including personal debt, property taxes, and living expenses.

Reconciling the T-12 with the rent roll

The T-12 and the current rent roll cover different time periods. The T-12 shows what actually happened over the past twelve months. The rent roll shows what is in place today. To reconcile them, identify:

  • Units or spaces that turned over during the T-12 period, and how the rent roll reflects the current rent.
  • Rent concessions or free rent that reduced T-12 income but are not present on the current rent roll.
  • Expense timing differences, such as a large property tax bill paid in one month that distorts the T-12 average.
  • Capital expenditures that were expensed in the T-12 but should be capitalized for underwriting.

Document each adjustment in a simple table: line item, T-12 amount, adjustment, and adjusted amount for underwriting.

Distinguishing NOI, debt service, and equity cash flow

Lenders focus on NOI and debt service. Sponsors focus on equity cash flow, which is the cash remaining after debt service, taxes, and capital reserves. The two are not the same. NOI is before debt service. Debt service is the loan payment. Equity cash flow is what is left for the sponsor. The sponsor should prepare a separate waterfall that shows:

  • Gross rent
  • Less vacancy and collection loss
  • Equals effective gross income
  • Less operating expenses
  • Equals NOI
  • Less annual debt service
  • Equals cash flow before reserves
  • Less replacement reserves and capital expenditures
  • Equals equity cash flow

This waterfall helps the lender see where the sponsor's assumptions differ from the lender's underwriting.

Documenting lender sizing targets separately from sponsor assumptions

Create a two-column workpaper. In the left column, list the lender's underwriting inputs: income, expenses, vacancy, cap rate, debt service constant, and DSCR minimum. In the right column, list the sponsor's assumptions. For each line, note the source of the lender's input (e.g., "lender's standard vacancy assumption for this property type") and the source of the sponsor's assumption (e.g., "sponsor's actual experience over past three years"). This separation allows the sponsor to negotiate from a position of knowledge, not guesswork.

Preparing for the lender's global cash flow analysis

Global cash-flow analyses can be complex and may require integrating cash flows from business financial statements, tax returns, and Schedule K-1 forms for multiple partnerships, limited liability companies, and corporations. [1] The lender may require a global cash flow summary that lists:

  • All entities in which the sponsor has an ownership interest
  • Each entity's annual cash flow (positive or negative)
  • The sponsor's share of that cash flow
  • All personal debt payments, property taxes, and living expenses
  • The net cash flow available to support the proposed loan

This summary should be prepared separately from the property-level underwriting and should not include the sponsor's projected returns from the proposed loan, as those are not yet realized.

FAQs

How do I know what vacancy rate the lender will use?

Ask the lender directly. Lenders have standard assumptions for each property type and market. If the lender does not disclose a specific rate, use the market average from a reputable third-party source, such as a local market report or appraisal, and document that source.

Should I include the sponsor's personal tax returns in the loan request?

Yes, if the sponsor is a guarantor or if the lender requires a global cash flow analysis. The lender's review may consider the borrower's overall financial condition and resources. [1] Tax returns provide a verified record of income and expenses that supports the sponsor's ability to support the loan.

What if the T-12 shows lower income than the rent roll?

Reconcile the difference. Common reasons include rent concessions, lease-up periods, or one-time vacancies. If the rent roll reflects higher rents that have not yet been collected for twelve months, the lender may use the T-12 as the base and phase in the higher rents over a lease-up period. Document the expected timeline for the higher rents to materialize.


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. OCC Commercial Real Estate Lending handbook
  2. Wraith commercial real estate debt