How to document an estimated property value in a refinance scenario
A practical evidence checklist for commercial real estate sponsors preparing to document estimated property value for a refinance, with guidance on how lenders use this information and how to distinguish source facts from assumptions.
A practical evidence checklist for commercial real estate sponsors preparing to document estimated property value for a refinance, with guidance on how lenders use this information and how to distinguish source facts from assumptions.
When a property's value has changed since the last appraisal, or when the loan balance is close to the original value, a sponsor needs to document an estimated current value for the lender's refinance analysis. This guide explains what information to prepare, how lenders typically use it, and what distinguishes a supported estimate from an unsupported assumption.
How lenders assess refinance risk with property value
The OCC's supervisory guidance explains that refinance risk includes the possibility that a borrower cannot replace existing debt at a future date under reasonable terms and prevailing market conditions . One factor lenders evaluate is whether collateral values have fallen, which could affect the borrower's ability to qualify for a new loan . When a sponsor provides an estimated property value, the lender will compare it to the original underwriting assumptions, current market data, and the loan balance. The OCC advises that analysis should include determining whether a borrower can meet current underwriting standards, including prevailing interest rates, for similar loans . A documented estimate helps the lender assess whether the property still supports the requested loan amount.
What to include in an estimated value workpaper
Prepare a single document that records the following information in a clear, organized format. Label it as a workpaper, not an appraisal, and note that it is prepared for lender discussion purposes.
- Property address and type
- Date of the most recent appraisal and the appraised value
- Date of the estimated value analysis
- The estimated current value and the date as of which it applies
- The source of each data point used (for example, a specific comparable sale, a broker opinion, or a market report)
- Adjustments made to comparable properties for differences in size, condition, location, or lease terms
- Any assumptions about market conditions or property performance that affect the estimate
This workpaper is not a substitute for a formal appraisal, but it gives the lender a starting point for discussion.
How to select and adjust comparable sales
Identify at least three recent sales of similar properties in the same market. Record the sale price, sale date, property size, occupancy, and condition for each. Compare each comparable to the subject property and note adjustments for differences. For example, if a comparable sold six months ago and the market has changed, note the direction and approximate size of the adjustment. If a comparable has higher occupancy, adjust downward to reflect the subject's occupancy. The workpaper should show each adjustment and the resulting adjusted value for each comparable, then a range or single estimated value.
How to incorporate current rent roll and operating income
Lenders underwrite permanent loans based on in-place net operating income, adjusted for vacancy, expenses, and reserves [1]. The estimated value should be consistent with the property's current income. If the rent roll shows higher rents than the appraisal assumed, that may support a higher value. If vacancy has increased, the value may be lower. Prepare a current rent roll (a snapshot of all leases and rents in place today) and a trailing twelve-month operating statement (T-12) that shows actual income and expenses for the past twelve months. The rent roll and T-12 cover different periods: the rent roll shows current occupancy, while the T-12 shows historical performance. Compare the two to see whether current income is higher or lower than the trailing average. If the rent roll shows higher income than the T-12 average, note that the property may be improving. If the rent roll is lower, the estimate should reflect that decline.
How to distinguish NOI, debt service, and equity cash flow
Net operating income (NOI) is the property's income after operating expenses but before debt service. Debt service is the annual loan payment (principal and interest). Equity cash flow is NOI minus debt service. A lender typically tests whether NOI covers debt service by a minimum ratio [1]. The estimated value should be based on NOI, not on equity cash flow. A common mistake is to use collected income (after tenant defaults or concessions) instead of gross potential rent adjusted for market vacancy. Use the lender's definition: NOI equals gross potential rent minus vacancy allowance minus operating expenses, before debt service.
How to document the estimate for different refinance scenarios
If the refinance is for a permanent loan on a stabilized property, the lender will focus on the in-place NOI and occupancy [1]. The estimated value should be supported by the current rent roll and T-12. If the property is still leasing up, a permanent loan may not fit, and a bridge loan may be more appropriate [1]. If the refinance is for a loan near maturity, the OCC guidance advises that banks should evaluate refinance risk when approving and structuring loans, during ongoing monitoring, and near maturity . The estimated value workpaper should show how the property would perform under those standards.
What to ask the actual lender
Every lender has its own requirements for how it accepts an estimated value. Before preparing the workpaper, ask the lender:
- Will you accept an estimated value from the sponsor, or do you require a broker opinion of value or a formal appraisal?
- What is your maximum loan-to-value ratio for this property type and market?
- Do you require a minimum debt yield, and if so, what is it?
- How do you define NOI for the debt service coverage test?
These questions help the sponsor prepare the right information and avoid assumptions about what the lender will accept.
Three common questions about documenting estimated property value
Can I use an online valuation tool instead of preparing a workpaper?
Online tools provide a starting point, but lenders typically require a property-specific analysis that accounts for local market conditions, lease terms, and property condition. A workpaper with comparable sales and adjustments is more useful for the lender's refinance risk assessment .
How often should I update the estimated value workpaper?
Update the workpaper when market conditions change significantly, when a new lease is signed that affects income, or when the lender asks for a current estimate. The OCC guidance notes that banks should evaluate refinance risk when approving and structuring loans, during ongoing monitoring, and near maturity .
Does the estimated value replace an appraisal?
No. The estimated value workpaper is a tool for discussion and preliminary analysis. Most lenders will require a formal appraisal before closing a refinance. The workpaper helps the sponsor and lender agree on whether the property likely supports the requested loan amount before ordering the appraisal.
Closing invitation
The website supplies the call to action.
Model this deal and request financing
Run a refinance model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.
Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.
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.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).