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

Preparing a valuation sensitivity table without presenting a new appraisal

An actionable guide for commercial real estate sponsors to build a valuation sensitivity table that supports a financing discussion, using existing evidence and distinguishing source facts from assumptions.

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

An actionable guide for commercial real estate sponsors to build a valuation sensitivity table that supports a financing discussion, using existing evidence and distinguishing source facts from assumptions.

This guide helps a commercial real estate sponsor prepare a valuation sensitivity table that informs the lender's underwriting without requiring a new appraisal. The table uses existing evidence—such as the current appraisal, rent roll, and operating statements—to test how changes in key assumptions affect the property's estimated value. The purpose is to show the lender that you have considered a range of plausible outcomes, not to replace the appraisal itself.

Understanding the lender's reliance on appraisals

For certain transactions, such as residential tract developments, banks may use appraisals to determine market value for calculating the loan-to-value (LTV) ratio [1]. The OCC's Commercial Real Estate Lending handbook states that appraisals for residential tract developments must reflect appropriate deductions and discounts [1]. This means the lender will anchor on the appraiser's opinion of value, not your own. A sensitivity table does not override that opinion, but it can show how changes in assumptions affect estimated value.

How to build the table: a suggested workpaper

Create a simple spreadsheet with the following columns: - Assumption being tested (e.g., cap rate, NOI, rent growth rate) - Base case value (from the current appraisal) - Adjusted value (your estimate under the changed assumption) - Change from base case (dollar and percentage) - Implied LTV (based on your requested loan amount)

Distinguishing source facts from assumptions

In your sensitivity table, clearly label which inputs come from the current appraisal (source facts) and which are your own projections (assumptions). For example, the current NOI from the trailing twelve months (T-12) of operating statements is a source fact; the projected NOI after lease-up is an assumption. For raw land, lot development, or lot acquisition as part of a residential tract development, the market value should reflect the property's actual physical condition, use, and zoning designation (the "as is" value) as of the effective date of the appraisal [1]. Your sensitivity table should show both the "as is" value from the appraisal and the "as stabilized" value under your assumptions, so the lender can see the gap.

How to present the table to the lender

When you share the sensitivity table, provide a brief narrative that explains each assumption and why you chose that range. The OCC's appraisal regulations require that appraisals contain sufficient information and analysis on which to base a sound credit decision [1]. Your table supports that analysis by showing the lender how the property's value might perform under different scenarios. It is a suggested way to prepare information, not a mandatory lender process. Ask the actual lender whether they would like to see additional scenarios or a narrower range of assumptions.

Using the table to inform the financing discussion

The sensitivity table can help you identify which assumptions have the greatest impact on value. For example, if a small change in the cap rate significantly changes the implied LTV, you may want to discuss with the lender how they view current market cap rates for your property type. The OCC handbook emphasizes that banks should implement a risk-based approach for determining the depth of review needed [1]. Your table demonstrates that you have considered risk, which can support a more productive conversation about leverage, recourse, or covenants.

What to do if the table reveals a valuation gap

If your sensitivity table shows that the property's value under your business plan assumptions is lower than the loan amount you need, that is useful information to address early. You can discuss with the lender whether additional equity, a different loan structure, or a phased draw schedule could close the gap. The appraisal regulations permit the use of evaluations in lieu of appraisals for certain transactions [1]. Your table gives you a concrete basis for that conversation, rather than relying on a single point estimate.

Frequently asked questions

How often should I update the sensitivity table? Update the table whenever you receive a new appraisal, a significant change in operating performance, or a material shift in market conditions. The OCC expects banks to monitor collateral values and assess whether an existing appraisal remains valid [1]. Your table supports that monitoring by showing how value changes with new information.

Can the sensitivity table replace an appraisal for underwriting? No. The sensitivity table is a planning tool, not a formal valuation. The OCC's appraisal regulations require a market value opinion from a qualified appraiser for most transactions [1]. The table helps you prepare for the underwriting discussion, but the lender will still require an appraisal or evaluation that meets regulatory standards.

What if the lender asks for a different range of assumptions? Be prepared to adjust your table. The lender may have a different view of market cap rates, rent growth, or expense trends. The OCC expects banks to establish criteria for appraisals and evaluations that support a sound credit decision [1]. Your willingness to adapt the table shows you are engaged in the process and open to the lender's perspective.


To start the conversation, send us the property, the business plan, the amount you need, and your timing. 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