Sensitivity Analysis for Real Estate Deals: Stress-Test Your 2026 Acquisition

Every acquisition model has a base case. The problem is that the base case is almost never what you actually 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%–7.6% on a good day. The base case was a coin flip, not analysis.

This is not a theoretical concern. As of June 26, 2026, the 30-year conforming rate sits at about 6.53% for owner-occupied loans. [Source: Mortgage News Daily] Add the standard investor premium and you land at 7.1%–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] In that environment, underwriting one number for each variable and calling it a deal is not analysis. It is optimism. Sensitivity analysis is what separates investors who close confidently from investors who close and hope.

---

The Three Variables That Drive Most Acquisition Outcomes

Before building any table, you need to understand which inputs actually move the needle on a leveraged single-family or small multifamily deal. Most variables matter at the margin. Three variables move cash-on-cash return and cap rate 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 currently exists within the quoted investor rate range, is about $142 per month in debt service. On a deal generating $2,400 in gross monthly rent, that spread costs you nearly 6 full percentage points of annual cash-on-cash return. Rate is the single largest lever on leveraged returns, and right now it is also the most volatile. The Fed held rates in June 2026 but the dot plot signaled a possible hike, and markets are 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 is running 10%–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 $1,440 per year on a $2,400/month rent. That gap is enough to erase most of the cash flow on a tight deal.

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%–2% for 2026, Northeast at 4%–5%, and Midwest at 3%–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: a $400,000 duplex, 25% down ($100,000 equity), $300,000 loan on a 30-year fixed. Gross scheduled rent: $2,400/month ($1,200 per unit). Operating expenses (taxes, insurance, repairs, management at market): $800/month. No vacancy or credit loss yet. That variable runs through the table.

Base assumptions before the table:

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, $800/month fixed operating expenses.

*Monthly debt service calculated at each rate on a $300,000, 30-year fixed-rate loan. Vacancy applied to $2,400 gross scheduled rent.*

The math behind the rows: a $300,000 loan at 6.75% carries $1,946/month debt service; at 7.75% that rises to $2,148. The $202/month difference is not trivial. It represents $2,424 per year of cash flow, or about 2.4% of equity deployed. At 10% vacancy and 7.75%, the deal still cash-flows at $226/month, but the cash-on-cash return falls to 2.7% annually, well below what most investors need to justify the execution risk of landlording.

The critical threshold this table reveals: at 7.75% and 15% vacancy, a combination entirely plausible in Austin or Atlanta today, monthly cash flow falls to $106. One unexpected capex event, a water heater, an HVAC service call, or one month of tenant overlap between leases, turns this deal cash-flow 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: Vacancy or CapEx

A 2D table handles two variables simultaneously. 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–$15,000. Model three CapEx scenarios, $0, $6,000, and $12,000, against your base rate/vacancy combination and you will immediately see whether the deal survives a major repair in year one without a capital call.

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 a table where rent is $2,400 (current market), $2,200 (moderate decline), and $2,000 (stress case), against your rate range. 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] If exit cap rates expand 50 basis points, a realistic possibility if rates stay elevated, a 5.6% going-in cap on a $400K property implies an exit value of roughly $343,000 at a 5.6% cap on stabilized NOI of $19,200. Expand that exit cap to 6.1% and exit value drops to $315,000. That is $25,000 of equity erosion on a 25% down acquisition. Knowing this number is not pessimism. It is position sizing.

---

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 threshold is a debt service coverage ratio below 1.0x, meaning rent no longer covers the mortgage.

On the $400K duplex with a $300,000 loan at 7.25%, monthly debt service is about $2,047. Monthly income at 0% vacancy is $2,400. Operating expenses are $800. That leaves $1,600 in NOI, a DSCR of 0.78x. This deal already fails the DSCR test at face value. To pass 1.25x DSCR (the common lender minimum), the property needs NOI of at least $2,559/month, which would require gross rent of $3,359 at 0% vacancy. On a $400K duplex, that means $1,680 per door. Whether that is achievable depends entirely on the submarket.

This is the deal-breaker calculation most investors skip. They model cash-on-cash return, confirm it is positive, and move on. But in 2026, with investor rates at 7.1%–7.6%, many deals that pencil on cash flow still fail institutional 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.

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/rent-growth variables in the same workflow.

---

The Rate Environment Makes Conservative Underwriting Non-Optional

The June 2026 rate context deserves its own emphasis. Rates for investment property are 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 is running about 2.02%, above the long-run historical norm of 1.5%, which means investor premiums are not about to compress on their own. [Source: firsttuesday Journal] Mortgage rates are expected to stay in the low-to-mid 6% range through the summer for conforming loans, which translates to 7.0%–7.5%+ 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–24 months. The June 2026 dot plot pushes the next plausible cutting cycle into 2027 at the earliest. Deals need to work at current financing costs, not hoped-for future costs. [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 bifurcation 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 Pro Sensitivity Grid Handles 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 RentalCalcs Pro plan includes a built-in sensitivity analysis feature designed for exactly this type of multi-variable stress-test. You enter your deal, purchase price, rate, rent, vacancy, expenses, and with one click the tool generates a full grid of cap rate and cash-on-cash outcomes across simultaneous combinations of purchase price, interest rate, and rent. You can see the complete outcome matrix in one view: which cells are green (the deal works), which are yellow (marginal), and which are red (deal-breaker territory).

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 full sensitivity grid 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.

The Pro plan at RentalCalcs.com/pricing also includes sensitivity tables across multiple variables, 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.

The sensitivity table in this post is intentionally simplified to make the math visible. The Pro tool runs the same logic across a full grid of inputs in seconds, with no formula errors, no copy-paste risk, and no version-control headaches. For any 2026 acquisition where the rate, the vacancy, or the rent growth assumption could move your return by more than 2 percentage points, which describes most deals right now, that grid is the analysis you want before you close.

Start with the single-family and BRRRR calculator or the multifamily calculator to build your base case, then upgrade to Pro to run the full sensitivity grid. The deal you stress-test before closing is the deal you understand. The one you do not is the one that surprises you.