In this article, we’ll discuss three ways you can incorporate sensitivity analysis into a real estate analysis and make smarter investment decisions. Before we get started, though, let’s consider the basics of real estate investing.

Real estate investing involves acquisition, holding, and sale of rights in real property with the expectation of using cash inflows for potential future cash outflows in order to generate a favorable rate of return on that investment. In other words, the goal of real estate investing is to make a profit and acquire wealth and therefore is all about the numbers—investment real estate stands or falls based on its numbers.

It stands to reason therefore that the more data you obtain about an investment property and the more you are able to dig in to that data, the better chance you have of making a wise investment decision. That’s where sensitivity analysis comes in.

What Sensitivity Is

Sensitivity analysis involves changing one variable at a time over a possible range of outcomes to evaluate the effect of that change; thus allowing real estate analysts to review each variable’s impact upon the investment property’s present value.

To do this, you would enter an amount to “step” the variable and the corresponding returns would in turn reflect that amount.

For example, if the variable amount was $100,000 and you step it $10,000, you create a range of amounts both higher and lower than the variable such as $120,000, $110,000, $90,000, $80,000 and so on along with whatever returns are provided by the real estate investment software you’re using for your real estate analysis.

Price Sensitivity

A price sensitivity analysis changes a property’s sale price in increments over a range of outcomes so you can evaluate such things as the cash requirement, loan amount, mortgage payment, cash flow, cap rate, and cash on cash return (depending on the real estate investment evaluation software you’re using) resulting from that change.

For example, suppose the asking price for a property is $500,000 and you want to know what the cap rate becomes if the price were reduced (or raised) in increments of maybe $1,000, $5,000, or $10,000. Simply input an amount to “step” the sale price (say, $5,000), and the sensitivity analysis will display a range of prices in increments to that step, i.e., 505,000, 510,000, 515,000, etc. along with the resulting cap rate for each one of those sale prices.

Down Payment Sensitivity

Suppose you want to determine the cash on cash return based upon a range of down payment amounts. Let’s say, for instance, an income property will produce a 5.5% cash-on-cash return with a down payment of $150,000, but you want to know how much of a down payment is required to achieve a 6.5% cash-on-cash return.

As before, to create the sensitivity analysis table, you simply input an amount to “step” the down payment. Depending on what real estate investment software program you’re using, you should be able to determine the results for the cash on cash return along with your cash requirement, mortgage payment, debt coverage ratio, and annual cash flow for each down payment amount.

Loan-to-Value Sensitivity

The loan to value sensitivity is a good way for you to determine the monthly loan payment based upon a range of loan amounts and interest rates. It’s the same procedure as before but in this case, to create the sensitivity analysis, you want to step the loan amount and the interest rate.

Let’s say you want to evaluate the monthly loan payment for a range of loan amounts at various interest rates such as $300,000, 310,000, and 320,000 at 6.0%, 6.125%, and 6.25%.  In this case, you input a dollar amount to step the loan and then a percentage to step the interest rate, and Viola! Your sensitivity analysis table is created with numerous monthly loan payments based on those variations.

Why It’s Popular

Sensitivity analysis has become popular because easy-to-use real estate investment software programs can calculate and recalculate a range of variables quickly.

Moreover, real estate investment software solutions create tables and reports. What would have taken hours before, now with the computer and template-based spreadsheet software for the computer, takes just minutes. So you’re without an excuse.

If you work with investment property (or intend to), be sure to take advantage of a sensitivity analysis. It is a good way to examine variables quickly, and not surprisingly has played a significant part in selling and buying decisions.