Advertiser Disclosure

advertising disclaimer
Skip to main content
rolling dice

What Is a Monte Carlo Simulation in Real Estate Investing?


Jun 24, 2020 by Marc Rapport
Get our 43-Page Guide to Real Estate Investing Today!

Real estate has long been the go-to investment for those looking to build long-term wealth for generations. Let us help you navigate this asset class by signing up for our comprehensive real estate investing guide.

*By submitting your email you consent to us keeping you informed about updates to our website and about other products and services that we think might interest you. You can unsubscribe at any time. Please read our Privacy Statement and Terms & Conditions.

Does determining risk in your real estate investments make you queasy? It might be time to get that stochastic feeling and roll the dice with a Monte Carlo simulation.

By definition, stochastic means using random variables. The Monte Carlo reference is about how six-sided dice yield an equal chance for any number to come face up when rolled, and then asking, for example, what the chances are of two dice coming up with a winning number, like seven.

Monte Carlo simulations are used in diverse industries and businesses to help assess risk and uncertainty by running models that include multiple variables in as many combinations as you care to see.

Contending with cycles, lack of performance data

A 2018 blog post from RCLCO Real Estate Advisors explains how Monte Carlo simulations can help investors despite the inherent drawbacks of cycles and a lack of performance data in the pursuit of profits: "Due in large part to its illiquidity and the resulting limitations on performance data, the real estate industry has historically lacked quantifiable assessments of risk as a tool to improve investment decision-making."

Due to its already cyclical nature, and conventional wisdom now challenged by a pandemic, real estate investing can benefit from the running of thousands of potential outcomes "based on the expected probability distributions for each variable," the RCLCO post says.

Providers cite growing usefulness

planEASe, a provider of commercial real estate (CRE) analysis software, says this: "Perform Monte Carlo risk analysis with any assumptions you choose versus any measure, such as rate of return, net present value, etc. Risk analysis allows you to investigate how these measures vary with a change in assumptions like holding period, cap rate at sale, renewal probability, vacancy, etc."

planEASe's products are examples of software that takes those variables, crunches them, and spits out tables and graphs that show "the probability of achieving any level for the chosen measure."

RCLCO also offers that type of analysis and says Monte Carlo simulations are getting better as data and analytical tools progress.

"With the prospect of further improvements in the future, the accuracy of the analysis will only continue to improve, along with its usefulness in real estate investment decision-making," the RCLCO post says.

There are multiple providers of Monte Carlo-type simulation software and services, but the ambitious can go it alone, too.

Monte Carlo simulations, DIY-style

Here are some YouTube videos that show the Monte Carlo simulation method in action:

And, it can be done in one of the most common pieces of software out there -- Microsoft (NASDAQ: MSFT) Excel.

"So, you want to run Monte Carlo simulations in Excel, but your project isn't large enough or you don't to do this type of probabilistic analysis enough to warrant buying an expensive add-in," writes Spencer Burton of Stablewood Properties in a blog post on Adventures in CRE titled "How to Run Monte Carlo Simulations in Excel." "Well, you've come to the right place."

Burton then shows step by step how to use Excel's built-in stochastic modeling abilities, "including running as many simulations as your computer's processing power will support."

Might be a good way to develop your Excel muscles while gaining some insight into how your current and future investments might fare amidst all this new complexity.

Unfair Advantages: How Real Estate Became a Billionaire Factory

You probably know that real estate has long been the playground for the rich and well connected, and that according to recently published data it’s also been the best performing investment in modern history. And with a set of unfair advantages that are completely unheard of with other investments, it’s no surprise why.

But those barriers have come crashing down - and now it’s possible to build REAL wealth through real estate at a fraction of what it used to cost, meaning the unfair advantages are now available to individuals like you.

To get started, we’ve assembled a comprehensive guide that outlines everything you need to know about investing in real estate - and have made it available for FREE today. Simply click here to learn more and access your complimentary copy.

Teresa Kersten, an employee of LinkedIn, a Microsoft subsidiary, is a member of The Motley Fool’s board of directors. Marc Rapport has no position in any of the stocks mentioned. The Motley Fool owns shares of and recommends Microsoft and recommends the following options: long January 2021 $85 calls on Microsoft and short January 2021 $115 calls on Microsoft. The Motley Fool has a disclosure policy.