Portfolio Stress Testing and Scenario Modeling

A comprehensive stress test models three severity levels. Mild Stress (-10% scenario): property values decline 10%, vacancy increases 3 percentage points (e.g., from 5% to 8%), rents decline 5%, and interest rates on variable-rate debt increase 100 basis points. This approximates a normal cyclical downturn. Moderate Stress (-20% scenario): property values decline 20%, vacancy increases 7 percentage points, rents decline 10%, and variable rates increase 200 basis points. This approximates a significant recession. Severe Stress (-30% scenario): property values decline 30%, vacancy increases 12 percentage points, rents decline 15%, and variable rates increase 300 basis points. This approximates a GFC-level crisis. For each scenario, calculate the impact on: monthly cash flow (NOI minus debt service), debt service coverage ratio (DSCR), loan-to-value ratio (LTV), and cash reserves runway (months of expenses coverable by reserves).

For each property in the portfolio, apply the three stress scenarios systematically. Start with current actual figures: current appraised value, current rent roll, current vacancy rate, current operating expenses, current debt service, and current cash reserves. Then adjust each figure according to the scenario parameters. The critical output metrics are: DSCR (must remain above 1.0 to cover debt payments—below 1.0 means the investor is feeding the property from other income), LTV (must remain below the lender's threshold, typically 80%—exceeding it may trigger a margin call or prevent refinancing), and Cash Runway (months of total expenses coverable by available reserves—fewer than 6 months is a red flag). Properties that breach any critical threshold in the mild stress scenario are immediate action items. Properties that breach thresholds only in the severe scenario are adequate for most conditions but may need attention as indicators turn yellow.

After testing each property individually, aggregate the results to assess portfolio-level risk. Key portfolio-level metrics include: total portfolio value decline across scenarios, total monthly cash flow (identifying whether some properties subsidize others), concentration of risk (are multiple vulnerable properties in the same market or financed by the same lender?), and total cash reserves relative to total portfolio debt service. Use the stress test results to create an action priority list: (1) reduce leverage on properties with thin DSCR margins, (2) build cash reserves for properties with short cash runways, (3) diversify holdings that create market or lender concentration, and (4) establish lines of credit while credit conditions are favorable. The stress test should be run annually during stable markets and quarterly when early warning indicators enter Yellow status.