Sensitivity Analysis That Lenders Actually Want to See

DSCR Stress Testing

The cornerstone of lender sensitivity analysis is DSCR under stress. Lenders want to see: the base case DSCR for each year of the projection (demonstrating comfortable coverage above covenant minimums), a rent decline scenario showing DSCR at 5%, 10%, and 15% revenue reductions, a vacancy increase scenario showing DSCR at 3, 5, and 8 percentage points above the base case vacancy assumption, a combined stress scenario with moderate revenue decline and vacancy increase simultaneously, and the exact breakeven point — the specific revenue decline or vacancy increase that pushes DSCR below the covenant minimum. For multi-loan structures, this analysis must be performed at each loan level and at the aggregate level. A deal that maintains 1.25x DSCR on the senior loan but falls below 1.10x on combined debt service will face scrutiny.

LTV Sensitivity and Collateral Analysis

Lenders care about their collateral value — the property's market value relative to the outstanding loan balance. LTV sensitivity analysis should show: the current LTV based on the acquisition appraisal, projected LTV at each year of the hold period (as the loan amortizes and property value changes), LTV under different cap rate scenarios at each year, and the specific cap rate at which LTV exceeds the lender's maximum (typically 75-80%). This analysis is particularly important for interest-only loans where the loan balance does not decrease during the I/O period. If property values decline during an I/O period, LTV increases — potentially triggering covenant violations or refinance difficulties at maturity.

Rate Sensitivity for Floating Rate Debt

If your capital structure includes any floating-rate debt (bridge loans, lines of credit, variable-rate mezzanine), the lender needs to see rate sensitivity analysis showing: debt service at current rates, debt service at +100, +200, and +300 basis point increases, the impact on DSCR at each rate scenario, the rate at which DSCR falls below the covenant minimum, and the effectiveness of any rate cap or hedge in limiting exposure. For bridge-to-perm strategies, also show the impact of rate changes on permanent loan sizing at refinance — higher rates at refinance mean lower loan proceeds, potentially creating a capital gap.

Operating Expense Sensitivity

While revenue risk gets the most attention, lenders also evaluate expense risk — particularly for items with high volatility. Show expense sensitivity for: insurance premium increases (model 10%, 20%, and 30% annual increases — realistic in many markets), property tax reassessment scenarios (model the assessed value at purchase price, at 10% below, and at 10% above), and labor cost inflation above your base assumption. For each expense scenario, show the resulting impact on NOI and DSCR. This analysis demonstrates to the lender that you understand the specific expense risks in your market and have planned for them.

Presentation Format for Loan Committees

Lender credit committees review dozens of loan applications. Your sensitivity analysis should be formatted for rapid comprehension: a one-page summary showing base case DSCR, stress case DSCR, and breakeven points for the key variables. Use color coding (green for comfortable coverage, yellow for adequate, red for below covenant) to make the risk profile immediately visible. Include a brief narrative for each stress scenario explaining why you believe the base case is achievable and what mitigants exist for the downside scenarios. The goal is to demonstrate that you have rigorously tested your own assumptions and that the property can service its debt even when things do not go as planned.

Related Glossary Terms

Related Articles