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

Comparing comparable property evidence without claiming a guaranteed value

Learn how to prepare a concrete evidence checklist for comparable property analysis, distinguishing source facts from assumptions to support a financing discussion.

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

Learn how to prepare a concrete evidence checklist for comparable property analysis, distinguishing source facts from assumptions to support a financing discussion.

When you present a commercial real estate loan request, the lender's underwriter will compare your property to similar ones to test the value you claim. This guide explains how to assemble comparable property evidence in a way that supports the discussion without promising a specific outcome. You will prepare a single workpaper: a comparable property evidence checklist that records the facts you can control and flags the assumptions you cannot.

What comparable property evidence does in a financing discussion

The lender uses comparable properties to estimate market value, which directly affects the loan-to-value ratio. In the context of residential tract development and construction loans, the OCC handbook states that the value of CRE collateral for the calculation of the LTV ratio is the market value as defined in the interagency appraisal regulations [1]. Your evidence does not replace the appraisal, but it helps the underwriter understand why you believe the property is worth what you say. The workpaper you prepare now will also help you identify gaps before the appraiser arrives.

Build a comparable property evidence checklist

Create a simple spreadsheet or document with one row per comparable property and columns for the facts you can verify. Do not try to calculate a value yourself—your job is to record evidence, not to appraise. Below are the categories to include.

Property identification and source

Record the address, property type, and year built. Note where you found the information: a public record, a broker's opinion, a recent sale you know about, or a listing. If the source is a sale, write down the sale date and the recorded price. If it is a listing, note the asking price and how long it has been on the market. The lender will weigh sold comparables more heavily than listings.

Physical characteristics

List the gross square footage, number of units or rentable square feet, lot size, and any significant features such as parking ratio, floor count, or building class. If the comparable has a different use—for example, a retail building compared to your office property—note that difference. For construction loan appraisals in residential tract development, the OCC handbook discusses that the cost of demolition and site preparation should be considered in the analysis [1]. Your checklist should flag such a difference as an assumption that will need adjustment.

Income and expense data

If you have access to operating statements for the comparable, record the net operating income and the trailing twelve months of revenue. If you do not have that data, leave the cell blank. Do not invent numbers. The lender will expect the appraiser to obtain this information, but your evidence shows you have done your homework. The comparable checklist is separate—it is about other properties, not yours.

Market context

Write down the submarket, the occupancy rate for the area, and any recent trends you have observed, such as new supply coming online or major tenants leaving. Avoid making claims about future rent growth. Instead, state what you have observed: for example, "three new apartment buildings opened within one mile in the past 18 months." The lender can verify that.

Distinguish source facts from assumptions

When you present the checklist to the lender, you can say, "Here are the facts I have collected, and here are the assumptions I am making. I understand the appraiser will test these." That honesty builds credibility.

How the evidence affects the financing discussion

The lender will look at your checklist to see whether you understand the market and whether your value opinion is reasonable. If your checklist shows three comparables that sold within the past six months and are physically similar to your property, the underwriter will be more comfortable with your requested loan amount. If your checklist shows only one comparable that sold two years ago, or if the comparables are in a different submarket, the lender may ask for a larger equity contribution or a lower loan-to-value ratio.

Remember that the appraisal will determine market value, not your checklist. In the context of residential tract development and construction loans, the OCC handbook states that the value of CRE collateral for the LTV ratio is the market value as defined in the interagency appraisal regulations [1]. Your evidence supports the discussion but does not set the value.

Prepare the workpaper: a suggested format

Create a document titled "Comparable Property Evidence Checklist" with the following sections: 1. Subject property summary: address, type, size, your estimated value (state clearly that this is your estimate, not an appraisal). 2. Comparable property table: one row per property with columns for address, sale date or listing date, price, square footage, price per square foot, occupancy, net operating income (if available), and source. 3. Assumption log: for each comparable, list the assumptions you are making. 4. Market notes: a short paragraph describing the submarket and any observed trends. 5. Gap analysis: a list of information you could not find and how you plan to fill those gaps (for example, "I will ask the appraiser to confirm the net operating income for Comparable A").

This workpaper is for your preparation.

How many comparable properties should I include?

Include three to five comparables that are as similar to your property as possible in type, size, location, and condition. If you cannot find that many, note the limitation in your gap analysis. The lender will expect the appraiser to use a similar number, but your checklist shows you have done the preliminary work.

What if the comparable properties have different occupancy levels?

Record the occupancy level for each comparable and note the difference. Occupancy affects net operating income, which in turn affects value. The appraiser will adjust for this, but your checklist should flag it as an assumption that needs adjustment.

Can I use a comparable that is not in the same submarket?

You can, but you must explain why it is relevant. For example, if there are no recent sales in your submarket, a comparable from a nearby submarket with similar demographics may be acceptable. Note the distance and the reason you chose it. The lender will decide whether to accept it.


We will tell you how we would approach it.

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