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

How to document a fixed-rate assumption when actual loan terms are unknown

A practical evidence checklist for sponsors preparing a financing request when the permanent loan's exact rate, amortization, and maturity are not yet known. Focuses on documenting debt-service capacity, comparing rent-roll snapshots with trailing operating history, and separating gross rent from net operating income.

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

A practical evidence checklist for sponsors preparing a financing request when the permanent loan's exact rate, amortization, and maturity are not yet known. Focuses on documenting debt-service capacity, comparing rent-roll snapshots with trailing operating history, and separating gross rent from net operating income.

When a commercial real estate sponsor approaches a lender for permanent financing, the exact loan terms—rate, amortization, maturity—are often unknown at the outset. Lenders quote on what they are given, and a well-prepared file can accelerate the underwriting conversation [2]. This guide provides a concrete evidence checklist for documenting a fixed-rate assumption, with an emphasis on debt-service coverage, cash-flow timing, and source attribution.

Identify the primary repayment source

For income-producing properties, the primary source of repayment is cash flow from rents [1]. Start by recording the property's net operating income (NOI) from the most recent trailing twelve months (T-12) of operating statements. The T-12 is a historical summary of twelve consecutive months; it is not a snapshot. Compare this with the current rent roll, which is a point-in-time list of in-place leases and rents. The rent roll shows gross rent and collected income at a single date; the T-12 shows actual income and expenses over time. Before combining these numbers, identify any timing differences—such as a lease signed mid-month or a vacancy that started after the T-12 period ended.

Distinguish gross rent, collected income, NOI, and debt service

A common confusion in underwriting is equating gross rent with the cash available for debt service. Gross rent is the total potential rent if all units were leased at market rates. Collected income is what the landlord actually received after concessions, bad debt, and vacancies. NOI is collected income minus operating expenses (property taxes, insurance, management fees, maintenance, utilities). Debt service is the scheduled principal and interest payments on the loan. Equity cash flow is NOI minus debt service. A lender will evaluate whether NOI adequately covers debt service requirements [1]. To document a fixed-rate assumption, prepare a simple workpaper that lists each of these figures side by side for the most recent T-12 period and for the projected stabilized year.

Prepare a debt-service coverage worksheet

Create a worksheet with the following columns: - Item (gross rent, vacancy allowance, collected income, operating expenses, NOI, proposed annual debt service, debt-service coverage ratio) - Actual (T-12) (fill in from historical statements) - Pro forma stabilized (fill in based on your business plan assumptions) - Source (note whether each figure comes from the rent roll, T-12, appraisal, or your projection)

Label the worksheet as a proposed organizing tool, not a required lender form. Enter the selected working rate and amortization assumptions, identify their source and date, and calculate annual debt service consistently. Keep an unquoted assumption visibly separate from a lender quote. Show how changing the assumption changes coverage, while retaining the same operating-income basis for comparison. Confirm actual sizing tests with the lender rather than treating a calculator target as policy. [1]

Reconcile the rent roll snapshot with the T-12 history

A current rent roll is a snapshot; a T-12 covers twelve historical months on its stated accounting basis. Record each cutoff date. Compare scheduled rent, actual collections, concessions, vacancy and bad debt on a consistent period before drawing conclusions. Explain whether changes reflect a different time period, collection timing or a change in the property. Do not replace historical results with the current rent-roll snapshot.

Document the fixed-rate assumption with source attribution

When terms have not been quoted, label the rate as a sponsor-selected working assumption. Record the date, the reason for selecting it, the proposed amortization, any interest-only treatment and the assumed maturity. Do not describe it as current lender pricing or an available offer. Identify which inputs remain unknown, and replace the scenario with documented lender terms if a quote is later received. Retain the earlier version so that changes in coverage and cash requirements can be traced. [2]

Include a capital expenditure and reserves line

Show recurring capital expenditures and reserve funding separately from the operating statement and from annual loan principal and interest. These cash requirements affect cash available to the sponsor; they should not be silently relabeled as operating expenses or ordinary debt service. Ask the lender how its own coverage and cash-flow tests treat reserves and capital spending, and show any adjustment explicitly rather than implying that every lender uses the same NOI definition.

Prepare a sponsor financial summary

Lenders evaluate the sponsor’s financial strength, including a schedule of real estate owned and financial statements for principals and guarantors [2]. Prepare a one-page summary listing: - Sponsor’s net worth and liquidity - Schedule of real estate owned (property name, loan balance, NOI, debt service, DSCR) - Any contingent liabilities (personal guarantees, other loans) - Source of funds for the equity contribution

The OCC handbook identifies loans with existing or recent covenant violations, modified repayment terms, or significant underwriting exceptions as items that may receive additional scrutiny [1]. If your file has any such items, disclose them upfront with an explanation.

FAQs

What is the difference between a rent roll and a T-12?

A rent roll is a snapshot of current leases and rents at a single date. A T-12 (trailing twelve months) is a historical summary of actual income and expenses over the past twelve consecutive months. The rent roll shows what is leased now; The T-12 reports historical income and expenses on its stated accounting basis and spent. Always reconcile the two before comparing totals.

Can I use a fixed-rate assumption if the lender hasn't quoted yet?

Yes, but label it clearly as a working assumption. Base it on published market data, recent quotes for similar properties, or lender rate sheets. Note the source and date. The lender will replace it with their actual quote during underwriting.

Does a debt-service coverage ratio guarantee loan approval?

No. The DSCR is one factor in underwriting. Lenders also evaluate property condition, sponsor strength, market trends, and loan structure. A strong DSCR improves the file but does not guarantee approval. Ask the actual lender for their specific underwriting criteria.

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