Two tools in the IntellCRE analysis suite help you pressure test a deal and model more complex capital structures: sensitivity analysis for stress testing your key assumptions, and refinancing for modeling a refi partway through the hold. This article covers both.
Part 1: Sensitivity Analysis
Why It Matters
A handful of assumptions drive almost all of your returns:
Proforma rents and rent growth
Hold term
Purchase price
Exit cap rate, which combined with the NOI in the final year of the hold determines your exit value and therefore most of the profit
Market cycles and shifts in demand move these numbers. A small variation can turn a great deal into an average one, which is why it's worth running sensitivities on every underwriting.
Running a Sensitivity Analysis
Open the analysis form for the property.
Scroll below the property value estimates and financing to the Sensitivity Analysis button.
Enable the sensitivities you want:
Exit cap rate
Purchase price
Proforma rent growth
Hold term
Set the number of steps (how many scenarios to show) and the increment for each.
Open the Sensitivity Analysis tab at the bottom of the screen and expand the panel to view the tables.
Reading the Table
The middle column is your current underwriting assumption.
Columns to the left step down by your chosen increment. Columns to the right step up.
Each column shows the resulting exit value, IRR, and equity multiple.
Examples:
Sensitivity | Example step | What it shows |
Exit cap rate | 0.10% | Lower cap rate produces higher exit value and stronger returns |
Purchase price | $150,000 | Buying cheaper improves every return metric |
Proforma rent growth | 0.5% | Higher growth lifts returns meaningfully |
Hold term | 1 year | How the deal performs at shorter and longer holds |
Important: Hold Term and Loan Term
If you're using financing, never run a hold term sensitivity longer than the loan term set in your acquisition financing. If the hold extends past the loan term, the model has to pay off the loan before the end of the hold, which registers as a very large negative cash flow and skews the results.
Using Sensitivities in Your Marketing
You can include sensitivity analysis in deal reports, websites, and brochures. It's an effective way to justify pricing to clients, partners, sellers, and buyers, whether you're defending a higher price or explaining a lower one.
Part 2: Modeling Refinancing
Start With Property Value
Your property value drives everything downstream. Choose your source:
Comps based price estimates, or
Minimum cap rate estimate
Acquisition Financing
Set up your traditional acquisition loan first.
Enter LTV, loan amount, and down payment, or
Let the system size the loan automatically to hold your DSCR at a target (1.25 by default, or another number you set)
Adjust the loan terms manually at any point
Adding a Refinance
Click Refi to open the refinancing model.
Loan terms
Interest rate
Amortization
Refinance month: when the refi triggers, for example 60 months for a year five refi or 120 months for year 10
Loan fee
Interest rate spread
Interest only period
Valuation parameters
Cap rate used for valuation: applied to the NOI in the refinance year to determine the property's value at that point. For example, a year five NOI of $237,000 at a 4.0% cap rate values the property at roughly $6.2 million.
LTV: controls the size of the new loan, and therefore how much cash you pull out of the deal.
How It Flows Through the Model
At the refinance month, the new loan proceeds are used to pay off the remaining balance on the acquisition loan.
Anything left over is your cash out, available for other projects, property improvements, or distributions to yourself, investors, or partners.
From that point forward, the model applies the refi terms for interest and principal payments.
At the end of the hold period, the sale proceeds cover the payoff of the refinance loan.
You can verify all of this in the cash flow preview panel at the bottom of the screen. Open the debt financing view to see the acquisition loan balance at the refi date, the new loan amount, and the payoff.
Questions about sensitivity analysis or refinancing? Reach out to [email protected].