Documenting a downside scenario without changing the reviewed base case
A practical guide for commercial real estate sponsors on how to prepare a separate, credible downside scenario that tests a project's resilience without altering the base-case assumptions already submitted to lenders.
A practical guide for commercial real estate sponsors on how to prepare a separate, credible downside scenario that tests a project's resilience without altering the base-case assumptions already submitted to lenders.
Why a separate downside scenario matters to lenders
When you present a financing request, the base case shows expected performance. Lenders also want to see how the property would hold up under stress — falling rents, rising vacancies, cost overruns — without you changing the original numbers. A separate downside scenario demonstrates that you have thought through risks and that the deal can absorb shocks. The OCC handbook notes that credit analysis may not appropriately identify key risks in many cases; a prepared downside file helps you show that you have considered risks [1].
What to include in your downside scenario document
Prepare a single spreadsheet or PDF that contains three sections: (1) a clear label that this is a downside test, not a revised base case; (2) a list of the specific assumptions you are changing and by how much; and (3) a new set of projected financial results. Do not overwrite your original base-case file. Keep them separate so a lender can compare the two side by side.
A concrete worksheet you can prepare: the downside scenario checklist
Create a simple table with these columns:
- Assumption (e.g., stabilized vacancy, average rent per unit, annual expense growth, exit cap rate)
- Base-case value (from your original submission)
- Downside value (your stress assumption)
- Reason for change (e.g., "local market absorption data shows 6-month delay")
- Effect on NOI (calculate the resulting net operating income)
- Effect on debt-service coverage (show the ratio after stress)
Fill in each row for every assumption you are testing. This worksheet gives a lender a clear, itemized view of what changed and why.
How to reconcile the downside scenario with the base case
Your base case uses a current rent roll (a snapshot of today's leases) and a trailing twelve-month operating statement, or T-12, which shows actual historical income and expenses. A downside scenario is a forward-looking test. Make sure you explain the timing difference: the base case reflects recent performance, while the downside projects what could happen if conditions worsen. When comparing totals, distinguish gross rent (scheduled rent before concessions), collected income (what you actually received), net operating income (NOI), capital expenditures, debt service, and equity cash flow.
How to present the downside scenario in your financing package
Attach your separate downside scenario document alongside these. In the business plan section, note that you have prepared a downside test and are including it for reference. This shows you have done the analysis without asking the lender to change the base case.
What to avoid when documenting a downside scenario
Do not present the downside as a revised base case. Keep the original numbers intact. Do not claim that the downside scenario is a guarantee of performance or that it will automatically satisfy lender requirements. Lenders will underwrite independently. Do not include unsupported claims that a specific gap causes a particular loan-size change. Instead, record what you assumed and let the lender draw conclusions.
Should I use the same format for the downside scenario as the base case?
Yes, use the same financial structure so a lender can compare line by line. Label the file clearly as "Downside Scenario" and include a date. Do not overwrite your original base-case file.
How many stress factors should I test?
Test two to four factors that are most relevant to your property. Testing too many can dilute the analysis. Focus on the variables that would most directly affect net operating income and debt-service coverage.
Can I submit the downside scenario after I have already sent the base case?
Yes. Just upload the downside document and note in the business plan section that you have added a stress test for reference.
Your submission is a preliminary request, not an engagement or lender submission.
Model this deal and request financing
Run a multifamily acquisition or value-add 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).