Sensitivity Analysis for Real Estate Deals: A 2026 Stress Test

A sensitivity analysis answers one question: how far can my assumptions be wrong before this deal stops working? You change one or two inputs at a time (rate, vacancy, rent, price, expenses), recompute the return for every combination, and read the grid for the line where cash flow or DSCR turns against you. On the example duplex in this post, a base case of +$358 a month becomes -$134 a month at a 7.75% rate and 15% vacancy, the deal breaks even at 14.2% vacancy, and it stops covering its mortgage at a rate of about 8.96%. Those three numbers tell you more than the base case ever will.

Every acquisition model has a base case, and the base case is almost never what you experience. You lock in a rate, pencil a 5% vacancy assumption, and project 3% annual rent growth. Then the market hands you a 7.3% national vacancy rate, rent concessions in a third of listings, and an investor mortgage that prices at 7.1% to 7.6% on a good day. The base case was a coin flip, not analysis.

This is not a theoretical concern, and the mid-2026 snapshot shows why. As of June 26, 2026, the 30-year conforming rate sat at about 6.53% for owner-occupied loans. [Source: Mortgage News Daily] Add the standard investor premium and you land at 7.1% to 7.6% on a conventional investment property loan. [Source: Rent to Retirement / Mortgage News Daily] Meanwhile, the U.S. Census Bureau's Q1 2026 Housing Vacancy Survey put the national rental vacancy rate at 7.3%, up from 7.1% a year prior. [Source: U.S. Census Bureau] Single-family rent growth decelerated to 1.3% year-over-year in January 2026, less than half the pace of a year earlier, while the broader multifamily market saw rent fall modestly at the national level. [Source: Multi-Housing News / Cotality] Those figures are dated snapshots, so look up the current rate and vacancy numbers before you model your own deal. The lesson holds either way: underwriting one number for each variable and calling it a deal is not analysis. It is optimism.

The Three Variables That Drive Most Acquisition Outcomes

Before building any table, you need to understand which inputs actually move the result on a leveraged single-family or small multifamily deal. Most variables matter at the margin. Three variables move cash-on-cash return by enough to change your go/no-go decision.

1. Interest rate on the acquisition loan. At 25% down on a $400,000 duplex, the loan is $300,000. The difference between 7.0% and 7.75%, a 75-basis-point spread that existed within the quoted investor rate range in mid 2026, is about $153 per month in debt service, or $1,840 a year. On $108,000 of cash invested, that spread alone costs about 1.7 percentage points of annual cash-on-cash return. Rate is the single largest lever on leveraged returns, and it is also the most volatile. The Fed held rates in June 2026 but the dot plot signaled a possible hike, and markets were pricing only a small chance of rate cuts in 2026 or into 2027. [Source: AHlend.com / Norada Real Estate]

2. Vacancy (effective gross income). The national rental vacancy rate hit 7.3% in Q1 2026, and in supply-heavy Sun Belt metros such as Austin, San Antonio, and Atlanta, actual submarket vacancy was running 10% to 14%. [Source: Norada Real Estate / Apartments.com] About 39.8% of rental listings offered concessions such as waived fees or a free month's rent as of spring 2026, equivalent to roughly $1,930 in forgone income per unit annually. [Source: Zillow / Yahoo Finance] A 5% vacancy assumption in a market where actual vacancy is 10% overstates effective gross income by $2,340 per year on $3,900 of monthly rent. That gap is enough to erase more than half the cash flow on a tight deal. For realistic assumptions by market type, see vacancy rates by market type.

3. Rent growth (or decline) over the hold period. Rent trends in 2026 are splitting by market in a way that makes a single national assumption dangerous. Single-family rents in Chicago gained 4.6% year-over-year in January 2026. Miami was down 1.3%. Dallas was down 1.0%. [Source: Multi-Housing News / Cotality] The National Apartment Association projects Sun Belt rent growth at 1% to 2% for 2026, Northeast at 4% to 5%, and Midwest at 3% to 4.5%. [Source: National Apartment Association] A deal that pencils at 3% annual rent growth breaks decisively if that market delivers 0% or negative. Running at least three rent scenarios (bear, base, and bull) is not conservatism. It is competent underwriting.

Building the 2D Sensitivity Table: A $400K Duplex Example

The deal, with labeled example figures: a $400,000 duplex, 25% down ($100,000), $8,000 of closing costs, so $108,000 of cash invested. The loan is $300,000 on a 30-year fixed at a base rate of 7.25%, which is a payment of $2,047 a month. Gross scheduled rent is $3,900 a month ($1,950 per unit). Operating expenses (taxes, insurance, repairs, management at market) are $1,300 a month. Vacancy is the variable that runs through the table, with 5% as the base case.

Base assumptions before the table:

• NOI at 5% vacancy: $3,900 - $195 - $1,300 = $2,405 a month, or $28,860 a year
• Going-in cap rate at a $400,000 purchase: $28,860 / $400,000 = 7.2%, just above the 5.5% to 7.0% range quoted for Class B multifamily in secondary markets, which is plausible for a small duplex in a Midwest cash flow market. [Source: rentana.io / CBRE data]
• Base monthly cash flow: $2,405 - $2,047 = $358, or $4,302 a year
• Base cash-on-cash return: $4,302 / $108,000 = 4.0%
• Base DSCR: $2,405 / $2,047 = 1.18

Now stress-test the two biggest levers: interest rate and effective vacancy.

The table below shows monthly cash flow at five rate scenarios (rows) and five vacancy scenarios (columns). All figures use the $300,000 loan, 30-year fixed, and $1,300 a month of fixed operating expenses.

Monthly debt service is calculated at each rate on a $300,000, 30-year fixed-rate loan. Vacancy is applied to $3,900 of gross scheduled rent.

The math behind the rows: a $300,000 loan at 6.75% carries $1,946 a month of debt service, and at 7.75% that rises to $2,149. The $203 monthly difference is not trivial. It represents $2,441 per year of cash flow, or about 2.3% of the cash invested. At 10% vacancy and 7.75%, the deal still cash-flows at $61 a month, but the cash-on-cash return falls to 0.7% annually, well below what most investors need to justify the execution risk of landlording.

The critical threshold this table reveals: the 15% vacancy column is where the deal runs out of room. It clears by $69 a month at 6.75% and by $19 at 7.0%, and from 7.25% up it is negative. A 15% vacancy year is one slow turnover plus one eviction on a two-unit building, and mid-2026 submarket vacancy in places like Austin or Atlanta was already in the 10% to 14% range. One unexpected capex event (a water heater, an HVAC service call, a month of overlap between leases) turns even the 10% column negative for the year. That is the break-even line. Knowing it before you close, rather than discovering it at year-end, is the whole point.

When to Add a Third Variable: Rent Level, CapEx or Exit Cap

A 2D table handles two variables at once. For most small-balance SFR and duplex deals, rate vs. vacancy is the right starting pair because both are uncertain at acquisition and both move the return by enough to change the outcome within a realistic range.

Add a third variable when:

The property has deferred maintenance or is value-add. CapEx spending is lumpy. A furnace replacement or roof repair on a $400K duplex can run $8,000 to $15,000. Model three CapEx scenarios ($0, $6,000, and $12,000) against your base rate and vacancy combination and you will immediately see whether the deal survives a major repair in year one without a capital call. On this example, a $6,000 repair is about 1.4 years of base-case cash flow. The capex reserve comparison for 1950s vs. 1990s rentals helps you size that reserve by building age.

You are buying in a high-supply Sun Belt submarket. In a market like Austin, where rent fell 3.3% year-over-year as of March 2026 [Source: Hello Landing / Zillow], the third variable to model is rent level, not rent growth. Run the base case with rent at $3,900 (the asking level), $3,600 (moderate decline), and $3,300 (stress case). At 7.25% and 5% vacancy, monthly cash flow goes from +$358 to +$73 to -$212. This tells you at what rent level the deal stops working entirely.

The hold is short (under 3 years). A refinance or exit scenario requires you to model exit cap rate as the third variable. CBRE data shows multifamily cap rates averaged 5.6% across all classes in Q1 2026. [Source: rentana.io / CBRE] Cap rates move, and they move against you when rates stay elevated. This duplex was bought at a 7.2% cap on $28,860 of NOI. If the exit cap expands 50 basis points to 7.7% with NOI unchanged, the value drops from $400,000 to about $374,000. That is roughly $26,000 of equity erosion, a quarter of the $100,000 down payment. Knowing this number is not pessimism. It is position sizing. The cap rate compression post covers where exit caps have been heading.

Threshold Testing: What Variable Combination Breaks the Deal?

"Breaking the deal" means different things to different investors. A common threshold for a conventional leveraged rental: cash-on-cash return below 4%, or monthly cash flow below $0. For a DSCR lender, the hard floor is a debt service coverage ratio of 1.0, meaning income no longer covers the mortgage, and many lenders want 1.25 for their best terms.

On the $400K duplex with a $300,000 loan at 7.25%, monthly debt service is about $2,047. NOI at 5% vacancy is $2,405 a month. That is a DSCR of 1.18. The deal cash-flows, and it still misses a 1.25 requirement. To pass 1.25, the property needs NOI of at least $2,558 a month, which at the same expenses and 5% vacancy requires gross rent of about $4,061, or $2,031 per door against $1,950 in place. Whether that is achievable depends entirely on the submarket. Lenders also calculate DSCR in different ways (many 1 to 4 unit programs use gross rent divided by the full housing payment), so ask for the formula. The DSCR explainer covers the variations.

This is the deal-breaker calculation most investors skip. They model cash-on-cash return, confirm it is positive, and move on. But with investor rates at 7.1% to 7.6% in the mid-2026 snapshot, many deals that pencil on cash flow still fall short of lender DSCR thresholds, limiting refinance options and constraining future borrowing capacity. Running the DSCR at each rate scenario, not just the base case, exposes that constraint before you are three months into ownership and trying to refinance.

The same four break-even questions are worth answering on every deal. For this example:

For a 5+ unit deal, this exact analysis runs through the multifamily calculator at RentalCalcs.com, which models DSCR, NOI, and cash-on-cash across your actual inputs. For SFR and BRRRR acquisitions, the single-family and BRRRR calculator handles the same rate, vacancy, and rent variables in the same workflow.

The Rate Environment Makes Conservative Underwriting Non-Optional

The mid-2026 rate context deserves its own emphasis, because it shows how wrong a "rates will fall" assumption can be. Rates for investment property were not on a predictable glide path lower. The Fed held in June 2026 with a hawkish tilt in the dot plot. [Source: AHlend.com] The 10-year Treasury sat at 4.45% as of mid-June 2026, and the spread between the 10-year and the 30-year conforming mortgage was running about 2.02%, above the long-run historical norm of 1.5%, which means investor premiums were not about to compress on their own. [Source: firsttuesday Journal] Mortgage rates were expected to stay in the low-to-mid 6% range through the summer for conforming loans, which translates to 7.0% to 7.5% or more for investment property. [Source: Norada Real Estate]

The most dangerous assumption in deals underwritten in 2024 and 2025 was the refinance escape hatch: the idea that a deal that does not quite work at acquisition will be rescued by refinancing into a lower rate within 12 to 24 months. The June 2026 dot plot pushed the next plausible cutting cycle into 2027 at the earliest. Deals need to work at the financing cost you can actually get, not a hoped-for future cost. [Source: AHlend.com]

That means the stress test is not a nice-to-have after you have already decided to buy. It is the filter that decides whether to bid in the first place. A deal that only works if rates drop 75 basis points is not a deal. It is a rate bet wearing a real estate costume.

On the rent side, the gap between markets is wide enough that national averages provide almost no guidance. Overall rent in March 2026 was 3.6% higher than a year prior, but that aggregate masks Providence at +8.2% year-over-year and Austin at -3.3%. [Source: Hello Landing / Zillow] Your submarket rent trajectory, not the national headline, is what goes into the model.

How the RentalCalcs Sensitivity Grids Handle This in One Step

Building a hand-calculated 2D table like the one above takes time and creates version-control risk: different tabs, different formulas, different assumptions. The logic is sound, but the execution is fragile. Add a third variable and a hand-built table quickly becomes a spreadsheet archaeology project.

The single-family calculator has a sensitivity tab that builds three grids from the deal you have already entered, plus a set of break-even cards. Here is what each grid shows, computed for the same example duplex so you can see how to read them. These tables hold operating expenses at $1,300 a month and closing costs at $8,000 to keep the math visible. The calculator reruns your full input set for every cell, so its numbers will differ slightly from a simplified hand version.

Grid 1: cash-on-cash return by purchase price and vacancy. Price runs from 10% below to 10% above your offer, against vacancy from 5% to 15%. This is the negotiation grid: it shows what a lower price buys you in resilience.

Read it diagonally. Paying $380,000 instead of $400,000 lets you absorb 8% vacancy and still earn the 4.0% you were expecting at 5%. A 5% price cut buys about three points of vacancy cushion on this deal.

Grid 2: DSCR by purchase price and interest rate. Same price range, against rates from 6% to 8.5%. This is the financing grid: it shows which price and rate combinations clear a lender's minimum.

At the $400,000 price, this deal only clears 1.25 at a rate of 6.5% or lower. At 7.5%, the price would have to come down to $360,000 to get there.

Grid 3: monthly cash flow by rent and expenses. Rent and operating expenses each move from 10% below to 10% above your inputs. This is the operations grid: it shows what a rent miss and an expense overrun do together.

A 10% rent miss alone takes the deal to -$12 a month. Rent is worth about three times as much as expenses here: each 5% of rent moves cash flow by roughly $185, and each 5% of expenses moves it by $65.

In the calculator, cells are color coded so the pattern is visible at a glance: green where the deal works, yellow where it is marginal, red where it fails (for example, DSCR under 1.0 or negative cash-on-cash). Below the grids, the break-even cards show the vacancy, interest rate, and rent decline at which cash flow reaches zero, along with the maximum purchase price the deal can support. Those are the same four tests in the break-even table above.

This is not a minor convenience. When you are evaluating a deal under time pressure (an offer deadline, a competitive market, a seller who wants an answer), having the grids pre-built against your actual inputs changes the quality of the decision you make. Instead of committing to a number and defending it, you are committing to a range of outcomes and knowing exactly where the floor is.

Sensitivity analysis is a Pro feature, and your first analysis on the site includes every Pro feature so you can see the grids on a real deal. The Pro plan at RentalCalcs.com/pricing also includes professional PDF export for lender and partner presentations and unlimited saved deals. If you are running more than one acquisition per quarter, or presenting deals to partners or lenders who expect to see scenario analysis, the manual approach does not scale.

Start with the single-family and BRRRR calculator or the multifamily calculator to build your base case, then open the sensitivity view. If the deal is a BRRRR, stress the refinance too, using the approach in BRRRR refinance modeling. The deal you stress-test before closing is the deal you understand. The one you do not is the one that surprises you.