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

Preparing separate downside cases before aggregating a portfolio model

Before combining property-level projections into a portfolio model, a sponsor should build distinct downside scenarios for each asset. This guide provides an evidence checklist and a workpaper template to help prepare those cases, clarify how refinance risk affects the financing discussion, and distinguish source facts from assumptions.

Source: CodexTopic: Portfolio and repayment planning736 wordsUpdated 2026-11-19

Before combining property-level projections into a portfolio model, a sponsor should build distinct downside scenarios for each asset. This guide provides an evidence checklist and a workpaper template to help prepare those cases, clarify how refinance risk affects the financing discussion, and distinguish source facts from assumptions.

Why separate downside cases matter for a portfolio model

A portfolio model that averages property performance can mask the risk that one or two assets will struggle to refinance. The OCC's guidance on refinance risk explains that banks should evaluate a borrower's ability to meet refinancing requirements if the borrower's financial condition declines or market conditions deteriorate . When a sponsor aggregates pro formas without isolating downside cases, the lender cannot see which property might break the portfolio's debt service coverage. Preparing separate downside cases for each asset gives the lender a clearer picture of where the risk sits and whether the portfolio as a whole can absorb it.

What refinance risk means for your financing request

Refinance risk is the risk that a borrower will not be able to replace existing debt at a future date under reasonable terms and prevailing market conditions . For a portfolio of commercial real estate loans, refinance risk increases in rising interest rate environments and can be amplified by large volumes of loans set to mature in underperforming markets . Lenders assess this risk at both the transaction and portfolio level, and they may require stress testing to see how a borrower's financial condition holds up if interest rates increase, market terms tighten, expenses increase, or collateral values fall . When you present a portfolio model, the lender will want to see that you have considered these scenarios for each property, not just the base case.

The workpaper: a downside case worksheet

Prepare a one-page workpaper for each property with the following columns: - Line item: gross rent, vacancy/collection loss, effective gross income, operating expenses, NOI, capex, debt service (interest and principal), equity cash flow - Base case (from T-12 or current pro forma) - Downside case (adjusted by stress factors) - Variance (downside minus base) - Debt service coverage ratio for both cases - Key assumptions: list each stress factor and its source (e.g., market rent decline, expense inflation)

This workpaper is not a mandatory lender form; it is a suggested way to organize information so that you can show the lender how each property performs under stress and where the portfolio's risk concentration lies.

How the downside case affects the financing discussion

When a lender reviews a portfolio model that includes separate downside cases, they can see which properties are most vulnerable to refinance risk. The OCC notes that refinance risk can be driven by borrower-specific factors such as high leverage, constrained liquidity, a significant volume of near-term maturities, poor financial performance, or unpopular market sentiment . If one property in your portfolio has a low debt service coverage ratio in the downside case, the lender may ask about your plan to address that risk—for example, by injecting equity, negotiating a longer term, or selling the property before maturity. The workpaper helps you answer those questions with specific numbers rather than general assurances.

Do I need a downside case for every property in the portfolio?

Yes, because refinance risk can be concentrated in a single property that has high leverage, near-term maturity, or poor performance . If you only prepare a portfolio average, you might miss that one asset is dragging down the whole group. The lender will appreciate seeing the individual downside cases because it shows you have thought through the risk at the asset level.

Can I use the same stress factors for all properties?

Not necessarily. Each property has its own market, tenant profile, and expense structure. A retail property may be more sensitive to vacancy changes than a multifamily property. It is better to tailor the stress factors to each asset's specific risks. For example, a property with a single tenant may need a higher vacancy stress factor than a property with many small tenants. Document why you chose each factor so the lender can follow your reasoning.


We do not make loans or commitments; all financing is subject to the lender's underwriting and approval. If you would like to discuss how to prepare a portfolio model with downside cases for your financing request, send us the property, the business plan, and the capital you need. 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. Wraith commercial real estate debt