How to Run a Sensitivity Analysis on a Rental Property Before You Buy

A rental property can look profitable in one spreadsheet and fail under modest changes in rent, vacancy, financing, or renovation cost.

That’s why you shouldn’t make an acquisition decision from one projected return. You should test the range.

A sensitivity analysis shows how your deal changes when you move one assumption at a time or combine several adverse conditions. It helps you identify the variables that actually drive the outcome, define your breakpoints, and document the range before you commit capital.

This is where real estate investment analysis software can replace scattered spreadsheets with a repeatable process.

Start with a clean base case

You can’t stress-test a model that’s already mixing assumptions, estimates, and missing costs. Build the base case first.

Record:

• Purchase price
• Closing costs
• Initial rehab and capital expenditures
• Financing structure and lender quote
• Rent by unit
• Vacancy and collection loss
• Property taxes and insurance
• Repairs and maintenance
• Property management
• Utilities paid by the owner
• Holding period
• Exit value or exit cap rate
• Selling costs

Keep assumptions separate from calculations. When you change rent or vacancy, you should see the downstream effect without rebuilding the model.

At minimum, review these outputs:

• Net operating income
• Annual cash flow
• Cash-on-cash return
• Debt service coverage ratio
• Equity multiple
• Net sale proceeds
• Total cash required

Your base case isn’t a promise. It’s the reference point you’ll use to compare other scenarios.

For a broader workflow, you can review WGREI’s deal analysis tools, which model acquisition costs, rehab, holding costs, financing, and exit options in one analysis.

Test the variables that can change the deal

Not every assumption deserves equal attention. Focus first on the inputs that can materially move cash flow, financing coverage, or your exit proceeds.

1. Rent

Test the rent you can support with current comparable listings and signed leases, not the highest asking rent you found online.

Useful ranges include:

• Base rent
• Rent 5% below base
• Rent 10% below base
• Rent at the lower end of the comparable range
• No rent growth during the first year or two

If the deal only works at the highest projected rent, you don’t have much operating margin.

2. Vacancy and collection loss

Vacancy affects revenue immediately. It can also compound when turnover creates repairs, leasing costs, and additional downtime.

Test:

• Your base vacancy assumption
• Base vacancy plus 2 percentage points
• Base vacancy plus 5 percentage points
• A longer lease-up period after renovation
• Collection loss separate from physical vacancy

Don’t hide turnover costs inside a general expense percentage. Record them where they occur so you can see the effect clearly.

3. Interest rate and financing terms

You don’t need to predict the market. You need to understand how your deal responds to a financing change.

Run the lender’s current quote as your base, then flex:

• The quoted rate plus 1 percentage point
• The quoted rate plus 2 percentage points
• A shorter amortization period
• A lower loan amount
• A refinance that takes longer than expected
• A floating-rate structure, if applicable

Use percentage-point changes rather than vague statements such as “rates could rise.” Your model should show exactly what happens when the financing assumption moves.

4. Rehab overrun

Your initial budget is not the same as your final cost. Test the effect of:

• The approved budget
• Budget plus 10%
• Budget plus 20%
• Budget plus 30%
• A longer renovation timeline
• A second round of repairs after opening walls

You should also test whether the overrun requires additional cash or additional borrowing. Those are different outcomes.

5. Hold period

A longer hold can increase total rent collected, but it can also increase maintenance, insurance, financing, and capital expenditure exposure.

Test your expected hold period against:

• A sale two years earlier
• Your base hold period
• A sale two years later
• A delayed refinance
• A delayed sale
• A period with no assumed appreciation

A deal that depends on selling at exactly the planned time has timing risk. Your model should show it.

6. Exit assumptions

Your exit is often where an attractive model becomes fragile.

Test:

• A higher exit cap rate
• A lower sale price
• Higher selling costs
• No market appreciation
• A longer marketing period
• Additional repairs before sale

Use conservative, clearly documented assumptions. Don’t treat a favorable exit as guaranteed simply because the property is expected to improve.

Use a base, downside, and severe downside case

One-variable tests show which assumptions matter. Combined scenarios show whether the deal can absorb several problems at once.

Create three versions:

Base case

Use your most supportable current assumptions. This should include documented rent evidence, a realistic rehab budget, current financing terms, and a clearly stated exit method.

Downside case

Combine moderate changes:

• Rent below your base assumption
• Higher vacancy
• Rehab cost overrun
• Financing flexed upward
• A longer hold
• A less favorable exit assumption

Severe downside case

Use adverse but plausible conditions. This isn’t a prediction. It’s a boundary test.

For example, you might combine lower rent, higher vacancy, a larger rehab overrun, delayed stabilization, and a less favorable exit. The purpose is to see whether the property requires perfect execution to avoid a loss.

Work through an illustrative example

The following figures are illustrative only. They aren’t a forecast, recommendation, or representation of market performance.

Assume you’re reviewing a rental property with:

• Illustrative purchase price: $210,000
• Illustrative rehab budget: $32,000
• Illustrative market rent: $2,350 per month
• Illustrative base vacancy: 6%
• Illustrative hold period: 7 years
• Financing based on an illustrative lender quote
• No assumed rent growth in the first year

You then flex the main assumptions:

Illustrative scenario	Rent change	Vacancy	Rehab change	Financing change	Hold period	Illustrative annual cash flow	Illustrative equity multiple
Base case	0%	6%	0%	Quoted terms	7 years	$4,800	1.62x
Moderate downside	-5%	9%	+15%	+1 percentage point	7 years	$1,900	1.29x
Severe downside	-10%	12%	+30%	+2 percentage points	9 years	-$1,700	0.91x

Again, every figure in this table is illustrative.

The table gives you more useful information than the base case alone. The property may still produce positive cash flow under moderate stress, but the severe downside creates negative operating cash flow and an illustrative equity multiple below the original cash invested.

That doesn’t automatically mean you should reject the deal. It means you need to decide whether the severe scenario is plausible, whether your reserves can cover it, and whether the purchase price gives you enough margin.

Find the breakpoint, not just the average result

A sensitivity analysis becomes more useful when you identify the exact point where the deal stops meeting your standards.

Ask:

• At what rent does annual cash flow turn negative?
• At what vacancy level does debt coverage fall below your requirement?
• How much rehab overrun can your available cash absorb?
• How long can the property remain vacant before the model fails?
• How much can the exit value decline before your equity is impaired?
• Does the deal still work if appreciation is zero?
• Does the deal still work if you sell later than planned?

This is the difference between saying, “The property should work,” and saying, “The property works until vacancy reaches this level or rehab exceeds this amount.”

Set your own thresholds. A lender may have one coverage requirement, while you may require more room because you’re managing several properties or preserving cash for the next acquisition.

Recognize a deal that only works under perfect assumptions

A fragile deal usually has a familiar pattern:

• The base case uses the highest supported rent
• Vacancy is minimal
• Rehab finishes on budget and on time
• Financing stays unchanged
• Operating expenses grow slowly
• The property sells on schedule
• The exit value depends on appreciation
• Small changes cause a major drop in cash flow or equity

If every assumption needs to land correctly, the deal isn’t resilient. You may be underwriting execution rather than the property.

That doesn’t mean every downside case must produce a positive return. It means you should understand the exposure before you decide. You may respond by lowering your offer, increasing reserves, reducing leverage, narrowing the renovation scope, or declining the acquisition.

Document the range before you commit

Save the analysis with the property record. Don’t leave it in a temporary spreadsheet or email thread.

Record:

1. The source of each base assumption.
   Note the comparable rents, contractor bids, tax records, insurance quote, lender terms, and exit method.

2. The tested range.
   Write down how far you flexed rent, vacancy, financing, rehab, hold period, and exit value.

3. The pass/fail thresholds.
   State the minimum cash flow, coverage, return, or equity protection you require.

4. The deal’s primary drivers.
   Identify whether the outcome depends most on rent, leverage, rehab execution, or the exit.

5. The decision and reason.
   Record whether you’re offering, renegotiating, requesting more diligence, or moving on.

When you later own the property, compare actual performance with the original range. Portfolio tracking can keep current rent, expenses, debt, cash flow, and equity in one property record. For forward-looking planning, you can also connect the analysis to cash-flow forecasting and asset management workflows.

Keep the analysis connected to operations

Sensitivity analysis doesn’t end when you close.

If the rehab budget changes, update the model. If lease-up takes longer, record the delay. If insurance or taxes increase, adjust the operating assumptions. If the property reaches stabilization, compare actual results with your base and downside cases.

A connected process prevents the original underwriting from becoming irrelevant after acquisition. WGREI’s renovation workflow keeps project stages, line-item budgets, and progress records tied to the deal, so you can see when actual costs move outside the assumptions you approved.

The mindset shift is straightforward: you’re not buying another software tool. You’re replacing scattered decisions and disconnected spreadsheets with a repeatable operating system.

Frequently asked questions

What is sensitivity analysis in real estate?

Sensitivity analysis tests how a property’s projected results change when you adjust key assumptions. You can flex rent, vacancy, financing, rehab cost, hold period, expenses, or exit value and review the effect on cash flow, coverage, and equity.

How far should you stress-test a rental property?

Use ranges that reflect your market, financing structure, property condition, and operating plan. A practical starting point is rent 5% to 10% below base, vacancy 2 to 5 percentage points above base, rehab 10% to 30% above budget, financing 1 to 2 percentage points above the quoted terms, and a hold period two years shorter or longer. These figures are starting points, not universal requirements.

Should I change one variable at a time or several together?

Use both. One-variable tests show which assumption moves the result most. Combined scenarios show whether several moderate problems can occur together without breaking the deal.

Does sensitivity analysis predict my return?

No. It models the figures and assumptions you enter. It can show a range of outcomes and identify breakpoints, but it can’t predict market conditions, tenant behavior, contractor performance, financing availability, or sale timing.

Can WGREI provide investment advice?

No. WGREI provides configurable software and workflow tools for investors to manage their own deals. The calculations use the information you enter. WGREI doesn’t raise capital, act as a broker, provide securities or financial advice, offer investment, tax, or legal advice, or guarantee investor returns.

Run the range before you make the offer

A single return projection tells you what happens if your assumptions are right. A sensitivity analysis tells you what happens when they move.

Use the range to set your offer, financing structure, reserve requirement, rehab contingency, and decision boundary. Then keep the analysis connected to the property after closing.

Start with WGREI’s Deal Analysis workspace, compare the available membership tiers, and choose the operating setup that matches your portfolio and deal volume.