Documenting the valuation date used in a commercial refinance model
A practical guide for sponsors to prepare a valuation date workpaper that aligns the appraisal or evaluation date with the refinance model, supporting lender underwriting and reducing back-and-forth.
A practical guide for sponsors to prepare a valuation date workpaper that aligns the appraisal or evaluation date with the refinance model, supporting lender underwriting and reducing back-and-forth.
Why the valuation date matters in a refinance model
A refinance model projects the loan amount a lender might offer based on the property's value. That value is tied to a specific date—the effective date of the appraisal or evaluation. If the model uses a value from a different date, the lender cannot rely on it for underwriting. Bank supervisory guidance from the OCC notes that lenders should assess whether an existing appraisal remains valid by considering factors such as the passage of time, volatility of the local market, and changes in underlying economic assumptions like capitalization rates and lease terms [1]. An arbitrary period, such as 12 months, should not be the sole criterion; the lender must document the facts and analysis supporting the conclusion that the value is still current [1].
Your task is to prepare a single workpaper that identifies the valuation date used in your model, compares it to the appraisal or evaluation date, and flags any gaps or changes that might affect value. This document helps the lender quickly see whether your model is based on a supportable value.
What to include in your valuation date workpaper
Create a one-page document (or spreadsheet) with these elements:
- Property name and address.
- Appraisal or evaluation reference. Include the report date, the effective date of value, the preparer's name, and the report type (appraisal or evaluation).
- Model valuation date. The date you used for the property value in your refinance model. This may be the same as the appraisal effective date or a different date if you adjusted for market changes.
- Time gap. The number of months between the appraisal effective date and your model valuation date.
- Market conditions checklist. A brief list of factors you considered, such as changes in local market rents, vacancy rates, capitalization rates, lease terms, or property improvements. Reference any data sources you used (e.g., market reports, broker opinions).
- Conclusion. State whether you believe the existing value remains supportable or whether a new appraisal or evaluation is needed. If supportable, note the key reasons.
This workpaper is not a formal appraisal review but a practical tool to organize information for the lender's underwriting team.
How to reconcile the appraisal date with your model
A suggested approach is to record the current rent roll and trailing 12 months of operating statements (T-12) for the property. Compare the current rent roll (a snapshot) to the historical data in the T-12 to identify trends. If the property's net operating income (NOI) has changed materially, the value may have shifted. Distinguish between gross rent, collected income, NOI, capital expenditures, debt service, and equity cash flow in your analysis. Do not equate a cap rate with a debt constant; they measure different things.
Preparing the evidence checklist
Include the following items in your workpaper as a checklist. For each, note whether it is attached or available:
- [ ] Copy of the appraisal or evaluation report, with effective date clearly marked.
- [ ] Current rent roll (dated within 30 days of your model date).
- [ ] Trailing 12 months of operating statements (T-12) for the property.
- [ ] Summary of any material changes in the property or market since the appraisal effective date (e.g., new leases, capital improvements, changes in local market conditions).
- [ ] If applicable, a broker's opinion of value or market update from a qualified professional.
- [ ] If using an evaluation instead of an appraisal, confirm that it includes the property's location, description, market value estimate as of the evaluation date, and the methods used to confirm physical condition [1].
This checklist is not a mandatory lender requirement but a suggested way to prepare information for the financing discussion.
Distinguishing source facts from assumptions
In your workpaper, clearly label each piece of information as a fact or an assumption. For example:
Lenders will test your assumptions. If you assume a higher value than the appraisal supports, be prepared to justify it with data. The OCC handbook reminds that lenders should maintain documentation supporting the conclusion that an existing appraisal remains valid [1]. Your workpaper serves that purpose.
Avoiding common pitfalls
- Do not use a value from an appraisal that is clearly outdated without analysis. The OCC handbook states that passage of time is only one factor; lenders must consider others [1]. But ignoring a significant time gap without explanation will raise questions.
- Do not confuse the appraisal report date with the effective date. The effective date is the date as of which the value opinion applies. The report date is when the appraiser signed. Use the effective date in your model.
- Do not assume that a cap rate from the appraisal can be directly compared to a debt constant. They serve different purposes: cap rates value the property, while debt constants measure loan payments.
- Do not claim that your workpaper guarantees lender approval. All financing is subject to the lender's underwriting and approval [2].
Can I use an appraisal that is 18 months old for my refinance model?
Possibly, but you must document why the value remains supportable. The OCC handbook warns against using an arbitrary time limit like 12 months as the decisive criterion [1]. You should consider factors such as market volatility, changes in the property or competition, and shifts in economic assumptions. Prepare a workpaper that explains your reasoning and attach current rent roll and operating statements.
What if the property's NOI has changed since the appraisal?
If NOI has changed, the value may have changed as well. You should adjust the value in your model accordingly and document the new NOI, the cap rate used, and the source of the cap rate. Distinguish between gross rent, collected income, NOI, capital expenditures, debt service, and equity cash flow. The lender will review your adjustments for reasonableness.
Is an evaluation acceptable instead of an appraisal?
Some lenders accept evaluations for certain transactions. The OCC handbook notes that evaluations should include the property's location, description, market value estimate as of the evaluation date, and the methods used to confirm physical condition [1]. Check with your lender whether an evaluation is acceptable for your loan size and type.
Next steps
Prepare your valuation date workpaper and evidence checklist before submitting your loan request. We will help you assemble the request and take it to the lenders suited to your property and plan [2].
Run the numbers on your deal
Estimate what a new loan could size to against your current balance and whether there is a gap to fill at maturity.
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).