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

Documenting a property's current use and proposed future use for financing

A concrete evidence checklist to help sponsors prepare the market analysis and use documentation lenders need to underwrite a commercial real estate loan, distinguishing current conditions from proposed plans.

Source: CodexTopic: Valuation and collateral evidence1396 wordsUpdated 2026-11-19

A concrete evidence checklist to help sponsors prepare the market analysis and use documentation lenders need to underwrite a commercial real estate loan, distinguishing current conditions from proposed plans.

When a sponsor approaches a lender for commercial real estate financing, the lender must understand both what the property is today and what it is expected to become. The gap between current use and proposed future use is where underwriting risk lives. This guide provides an actionable evidence checklist to document both states, explains how each piece of information affects the financing discussion, and distinguishes source facts from assumptions.

Current use documentation: the property as it stands today

The lender starts with the property's actual physical condition, use, and zoning designation as of the current effective date. [1] This means the appraisal must include the "as is" market value reflecting the property's existing state. To document current use, prepare a single workpaper that records:

  • The property's current occupancy and use (e.g., fully leased office building, partially vacant retail center, operating industrial facility).
  • Current rent roll as a snapshot: list each tenant, unit, lease start and end dates, base rent, any concessions, and security deposits. Current rent roll is a point-in-time document.
  • Trailing twelve months (T-12) of operating statements: this is historical, not a snapshot. The T-12 covers the prior twelve months of income and expenses. Because the rent roll is a snapshot and the T-12 is historical, the totals will differ. For example, a tenant who moved in three months ago appears on the current rent roll but only for three months in the T-12. Reconcile the difference by noting which tenants were present for the full twelve months and which were not.
  • Actual collected income, not just gross rent. Identify any vacancies, bad debt, or concessions that reduced collected income below gross potential.
  • Net operating income (NOI) calculated from the T-12: gross potential rent minus vacancy loss plus other income, minus operating expenses. Do not include debt service or capital expenditures in NOI.
  • Capital expenditures (capex) incurred in the trailing period, listed separately from operating expenses.
  • Current zoning and any existing environmental reports or Phase I assessments.

A suggested way to organize this information is a single spreadsheet with three sections: (1) current rent roll, (2) T-12 income and expense summary, and (3) reconciliation notes explaining differences between the two.

Proposed future use: the business plan and the pro forma

The lender evaluates the proposed future use through the business plan and pro forma. The market analysis must support the revenue assumptions in the pro forma. [1] This analysis typically includes a review of supply and demand characteristics, effective rental rates, sales prices, vacancy rates, building starts, and absorption. [1] The analysis should compare the subject property's amenities and physical characteristics with those of competitive properties. [1]

For a proposed future use that differs from current use, document:

  • The specific proposed use (e.g., conversion from office to multifamily, ground-up development, renovation and lease-up).
  • If the highest and best use is redevelopment to a different use, include the cost of demolition and site preparation in the analysis. [1]
  • A pro forma showing projected stabilized NOI, the capitalization rate used to estimate value, and the debt service coverage ratio (DSCR). The discount and cap rates used in estimating property income and values should reflect reasonable expectations for the rate of return that investors and lenders would require. [1]
  • For construction projects, a development budget and schedule. Because commercial real estate has a long production cycle, speculatively developed properties should meet demand that exists at a point in the future rather than the demand that exists when development begins. [1] This means the market analysis must project future demand and supply, not just current conditions.
  • For properties in transition (e.g., lease-up after renovation), the discounted cash-flow method is useful to estimate as-is market value when the property has not reached stabilized occupancy. [1] Direct capitalization is appropriate only when applied to a stabilized NOI. [1]

Distinguishing current facts from future assumptions

A clean workpaper should separate factual evidence from projections. Create two columns: one for "current documented facts" and one for "proposed assumptions." For example:

Lenders will test whether the assumptions are reasonable. The market analysis should include information on local building permits and construction starts, which is usually available from data services or local government offices. [1] Projecting future supply is difficult and cannot accurately account for future permits and construction that may begin after development of the subject property has commenced. [1] Because of this, supply often overestimates expected demand, resulting in prolonged lease-up and sales periods and declines in rental rates and sales prices. [1]

Debt service and equity cash flow

Separate NOI from debt service and equity cash flow. NOI is the income available to service debt and provide a return to equity, but it is not the same as either. To show the lender how the proposed financing will be repaid, prepare a debt service schedule that shows:

  • Projected annual NOI from the pro forma.
  • Annual debt service (principal and interest payments) under the proposed loan terms.
  • DSCR: NOI divided by annual debt service. Lenders will evaluate whether the DSCR and LTV ratios are prudent for the proposed loan amount. [1]
  • Residual cash flow to equity after debt service.

Do not equate a cap rate with a debt constant. The cap rate is used to estimate property value by capitalizing NOI. The debt constant is the annual debt service divided by the loan amount. They measure different things and are not interchangeable.

Guarantor financial capacity and contingent liabilities

If a guarantor is involved, the lender will assess the guarantor's willingness and ability to fulfill obligations. Examiners consider whether a guarantor has demonstrated willingness and ability to fulfill obligations, including whether previously required performance under guarantees was voluntary or the result of legal or other actions to enforce the guarantee. [1] The assessment for the guarantor should include consideration of the total number and amount of guarantees currently extended to all lenders, to evaluate whether the guarantor has the financial capacity to fulfill contingent claims. [1] The lender will need sufficient information on the guarantor's global financial condition, income, verified liquidity, cash flow, contingent liabilities, and other relevant factors to support the assessment. [1]

Environmental risk and other third-party reports

While this guide focuses on use documentation, note that environmental risk management is part of the underwriting process. [1] Obtain a Phase I environmental site assessment early, especially if the proposed use changes from the current use (e.g., industrial to residential). The lender may require it before issuing a term sheet.

What is the difference between a current rent roll and a T-12, and why does it matter?

The current rent roll is a snapshot of the property's occupancy and rent at a single point in time. The T-12 is a historical summary of income and expenses over the prior twelve months. They will not match because the T-12 includes periods when some current tenants were not yet in place and may include tenants who have since left. Reconcile the two by noting which tenants contributed income for the full twelve months and which contributed only part of the period. Lenders use the T-12 to see actual historical performance and the rent roll to understand current and near-term income.

How do I document proposed future use for a construction loan?

For a construction loan, the lender needs the current "as is" value of the property, which reflects its actual physical condition, use, and zoning as of the appraisal effective date. [1] Then document the proposed future use with a development budget and schedule, a pro forma showing projected stabilized NOI, and a market analysis that projects future demand and supply. Include information on local building permits and construction starts. [1] The market analysis should support the revenue assumptions in the pro forma. [1]

Does the lender require a market analysis for every loan?

Yes, a thorough market analysis is a critical component of the underwriting process for commercial real estate loans. [1] It typically includes a review of supply and demand characteristics, project desirability, and comparable properties. [1] For construction loans, it is especially critical because of the long production cycle and the risk that supply will overestimate demand. [1]


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