Calculating Internal Rate of Return, real estate investment evaluation software

Users of our Real Estate Investment Analysis program sometimes call us with questions that are not about the software but about the underlying analysis. If we had a “greatest hits” list for those questions the all-time winner would be this: “My cash flow goes up each year; the value of the property goes up each year; but when I look at the Internal Rate of Return, it goes down almost every year. What’s up with that?” To see how this can happen, let’s take a look at two very simple examples.

laptop with regression analysis graph, real estate investment analysis

Regression – no, it’s not what your family and friends accuse you of when you want to trade in the mini-van for a two-seater stick-shift convertible (well, maybe it is, but that’s a topic for a different article). If you’re familiar with our RealData software, my online video courses, and my other blog posts here, then you know that I’m usually talking about income-producing property like multi-family, retail, office, or the like — seldom about single-family homes. And when we estimate the value of most income properties, we typically do so by looking at their income stream.

Calculating Modified Internal Rate of Return, real estate investment calculators

From our experience, it appears that Internal Rate of Return (IRR) is the metric of choice for many, if not most, real estate investors. However, you may be aware that there are a few issues with IRR that can cause you some vexation: If you expect a negative cash flow at some point in the future, then the IRR computation may simply fail to come up with a unique result; and with your positive cash flows, IRR may be a bit too optimistic about the rate at which you can reinvest them. For these reasons, a variation on IRR, called Modified Internal Rate of Return (MIRR), can be very important. When you see how it works, then you’ll also see that it gives you the opportunity to deal with IRR’s shortcomings.

Short Term Rental Investment, real estate investments software

The rise of home-sharing platforms like Airbnb has been a boon to property owners, especially owners of smaller income properties, but it has also prompted municipalities to introduce regulations on short-term rentals (STRs). Many places impose restrictions, such as requiring permits or licensing, limiting occupancy, and restricting the number of days permitted.

Return on Equity, real estate data analytics software

Inflation, interest rates, concerns about recession, pandemic-inspired work-style changes, taxes. There are enough wild cards in the deck to give any economic forecaster vertigo.

Not all real estate markets or all sectors are created equal, so to paraphrase an old TV auto ad, your mileage may vary. Nonetheless, we think it’s possible to make at least some reasonable and general forecasts about the near-term prospects for commercial real estate. Here is some of what we’re hearing, and thinking.

Return on Equity, real estate data analytics software

One topic that often gets less attention than it deserves from real estate investors, however, is resale. Some tend be dismissive, looking at resale as speculation, but many others simply find it difficult to focus seriously on the matter of selling a property they haven’t yet purchased.It may take a little extra discipline to work a consideration of resale into your investment mindset, but it is just such discipline that often separates the successful investor from the sorry.

Cash-on-Cash Return in Real Estate, software for real estate investing

In the first part of our discussion, you looked at the simple math that underlies Cash-on-Cash Return. The short version goes like this: First you calculate your property’s first-year cash flow before taxes—essentially all the cash that comes in from operating the property minus all the cash that goes out. Then you divide that by your initial cash investment, and that percentage is your Cash-on-Cash Return. Nothing could be simpler.

Return on Equity, real estate data analytics software

Not all partnerships include a preferred return but, in those that do, its purpose is to counterbalance the risk associated with investing capital in the deal. Typically, the investor is promised that he or she will get first crack at the partnership’s profit and receive at least a X% return, to the extent that the partnership generates enough cash to pay it. In most partnership structures, the cash flow is allocated first to return the invested capital to all partners. The preferred return is paid next, before the General Partner or Managing Member receives any profit.