Tag: real estate investing software

Video post: Understanding Net Operating Income, Part 2

In Part 1 this post, we looked at the revenue side of our NOI calculation. Now let’s look at the expense side, and how the end result – the NOI itself, is typically used when evaluating a potential real estate investment.

 

If you missed Part 1, you can watch it here.

Copyright 2021,  Frank Gallinelli and RealData® Inc. All Rights Reserved

The information presented in this article represents the opinions of the author and does not necessarily reflect the opinions of RealData® Inc. The material contained in articles that appear on realdata.com is not intended to provide legal, tax or other professional advice or to substitute for proper professional advice and/or due diligence. We urge you to consult an attorney, CPA or other appropriate professional before taking any action in regard to matters discussed in any article or posting. The posting of any article and of any link back to the author and/or the author’s company does not constitute an endorsement or recommendation of the author’s products or services.

Video post: Understanding Net Operating Income, Part 1

One topic that seems to generate a lot of interest and questions among investors I speak with is the subject of net operating income. Those who are new to real estate investing and even those with some experience are often unclear as to exactly what it is, what it means, and how to use it.

To shed some light on this topic, I’m going to try something new here – new for me at least – a video blog post. I’ll try to answer those questions by giving you a basic roadmap of how Net Operating Income is calculated, and how it’s used in real investment situations. So —  here we go with Part 1 of 2.

net operating income

 

Part 2 is now available here.

 

Copyright 2021,  Frank Gallinelli and RealData® Inc. All Rights Reserved

The information presented in this article represents the opinions of the author and does not necessarily reflect the opinions of RealData® Inc. The material contained in articles that appear on realdata.com is not intended to provide legal, tax or other professional advice or to substitute for proper professional advice and/or due diligence. We urge you to consult an attorney, CPA or other appropriate professional before taking any action in regard to matters discussed in any article or posting. The posting of any article and of any link back to the author and/or the author’s company does not constitute an endorsement or recommendation of the author’s products or services.

 

NEW Version 20 of Real Estate Investment Analysis Pro Edition Software

We’re very excited to announce the release of new Version 20 of our Real Estate Investment Analysis software. This application has been the go-to solution for thousands of income-property investors since its first release in 1982.

(No, that’s not a typo. We’re proud to report almost four decades of enhancements based on users’ feedback.)

Version 20 has big new features and a whole new outlook on both development and investment properties. It has you covered on all fronts — buy and hold, build and hold, fix and flip, value-add — now you can model them all with one software program.

At its core, Real Estate Investment Analysis (REIA) is income-property investment analysis software for all who deal with commercial or residential income properties: individual and institutional investors, developers, brokers, lenders, accountants, portfolio managers, financial planners, builders, and architects.

It helps you make detailed income and expense projections, before- and after-tax cash flow calculations, key ROI measurements, partnership analyses, and a great deal more.

New functionality in v20 brings you month-by-month development cash flow planning, with drawdown construction loan for value-add, renovation, even construction from the ground up. Evaluate the development phase, then see how holding the property produces returns over time.

Get the full scoop here about new version 20.

Copyright 2020, RealData® Inc. All Rights Reserved

The information presented in this article represents the opinions of the author and does not necessarily reflect the opinions of RealData® Inc. The material contained in articles that appear on realdata.com is not intended to provide legal, tax or other professional advice or to substitute for proper professional advice and/or due diligence. We urge you to consult an attorney, CPA or other appropriate professional before taking any action in regard to matters discussed in any article or posting. The posting of any article and of any link back to the author and/or the author’s company does not constitute an endorsement or recommendation of the author’s products or services.

RealData’s Commercial Income Worksheet

The Commercial Income worksheet in RealData’s REIA Pro software is one of its leading power features that makes it a stand-out tool for investment analysis.

It’s designed to allow you to enter income from any number of tenants with great flexibility, and to model a lease scenario of any size or shape.

In this video we’ll have a quick overview of how this feature works, and how it can help you when you’re evaluating a commercial income property.

Click here to watch

####

Copyright 2020,  Frank Gallinelli and RealData® Inc. All Rights Reserved

The information presented in this article represents the opinions of the author and does not necessarily reflect the opinions of RealData® Inc. The material contained in articles that appear on realdata.com is not intended to provide legal, tax or other professional advice or to substitute for proper professional advice and/or due diligence. We urge you to consult an attorney, CPA or other appropriate professional before taking any action in regard to matters discussed in any article or posting. The posting of any article and of any link back to the author and/or the author’s company does not constitute an endorsement or recommendation of the author’s products or services.

New REIA v18 Releases for the New Year – Mac and Windows

With the new year comes the release of REIA version 18 for Mac. This release has all the same features, calculations and reports that are found in the Windows release. Like all of our Mac  products, it will run under Mac Excel/Office 2011 only. We continue to wait for Microsoft to make fixes and improvements to Excel 2016 so that our software will run correctly in that version. REIA v18 on the Mac runs on Excel 2011, Excel 2016 and Excel/Office 365.

Also available for immediate download is a maintenance update for REIA v18 Windows. This update fixes minor issues in the Cover Sheet and Cash Flow / Resale Assumptions reports. Customers who own a license of the software can download the latest build 1.07 from either the Welcome worksheet of their product or via their customer account at realdata.com

Keep track of all latest releases on our builds page.

 

New Podcast: Investing in Income-Producing Real Estate

I had the privilege recently of recording a video podcast with REICLub, where we discussed investing in income-producing real estate: deciding what kind of property you should buy, how to begin the analysis process, understanding the income stream, estimating value or worth, dealing with long-term projections, recognizing common pitfalls, investing with partners.

I invite you to view it here:

http://www.REIClub.com/FrankGallinelli

—Frank Gallinelli

New Edition of Frank Gallinelli’s “What Every Real Estate Investor Needs to Know..”

book1 ed3Frank Gallinelli’s popular book, “What Every Real Estate Investor Needs to Know about Cash Flow…” is now available in a new third edition. Frank has added detailed case studies while maintaining the essentials that have made his book a staple among investors. The new cases show how to evaluate an apartment building, a mixed-use, and a triple-net leased property — not just running the numbers, but also looking beyond the surface data to see how you might discern what’s really going on with a potential investment.

See the new edition at Amazon here.

McGraw-Hill first published Frank’s book in 2003 and has since sold over 100,000 copies. For more than a decade it has been a top title in the real estate section at Amazon.

For those seeking reviews from readers, look to the 100+ reviews of the second edition at Amazon, which collectively rate the book at 4.6 out of 5 stars.

And finally, a visual clue: Second edition has a blue cover, new third edition has a green cover.

 

 

New Short-Term Analysis Mode in REIA Pro

Today we are releasing build 1.07 for Windows and build 1.13 for Macintosh of our REIA Professional product to add a third “short term” analysis mode.  This is a free update for all those who have a license for REIA Pro v17.

Select the mode on the General Settings worksheet:

By making this selection, the software reveals a set of worksheets that are specific to a 24 month analysis.  In a typical short-term scenario, you plan to purchase a property, do some renovations, and then resell within two years.

With the addition of this feature, we can now say that REIA Pro has all the features that REIA Express has, plus many more.  See a feature comparison of the two REIA Products for more information.

The Cash-on-Cash Conundrum – a Postscript

A while back, I posted a two-part series called “The Cash-on-Cash Conundrum.” In the first installment I explained the calculation and underlying logic of CoC, and in the second I discussed some of the pitfalls of overreliance on this particular measure.

big pile of dollars

I try to keep my ear to the ground by reading and sometimes contributing to investor forums, where I continue to see a good deal of discussion on the question of what is or what should be the metric of choice for real estate investors. My unofficial and unscientific gauge of the general sentiment is that most investors agree that cash flow is king. Although I would be reluctant to crown any single measure as the absolute be-all and end-all for property analysis, I agree that cash flow is indeed a critical measure of the health of an investment property.

So what’s the big deal? What concerns me is that I see a kind of tunnel vision on this topic. I frequently hear some variation of these two statements bundled together: “Cash-on-cash return is the only reliable metric and the only one I really need,” and “IRR and Discounted Cash Flow analysis are bogus – they’re a waste of time because you just can’t predict the future.” To put it simply, these folks are saying that they trust CoC because it looks at the here and now, and they distrust IRR/DCF because it tries to look into the future.

On the surface, that argument might seem reasonable enough. Cash-on-Cash return is the property’s expected first-year cash flow before taxes, divided by the amount of cash invested to make the purchase; it’s quick and easy to calculate, and it does indeed focus on a more-or-less tangible present. A strong CoC unarguably provides a good sign that your investment is off on the right foot.

Is that the end of the story – or should it be? I think this narrow focus can cause an investor to miss some vital issues.

By adopting the “can’t predict the future” argument, aren’t you ignoring what investing is all about? You don’t have a crystal ball, but still — isn’t investing about the future, and isn’t the ability to make sensible choices in an uncertain environment a key trait of the successful investor?

I find it difficult to accept the argument that I should make a decision to buy or not to buy an investment property based on its first-year cash flow alone and without regard to projections of future performance. Ironically, there is a hidden message in this point of view: If the first year performance data is sufficient, then apparently I should believe that such data will be representative of how well the property will perform all the time. In other words, it really is OK to predict the future, so long as I believe the future will always be like the present.

I would argue that it is in fact less speculative to make the kind of projections that you typically see in a Discounted Cash Flow analysis, where you look at the anticipated cash flow over a period of time and use those projections to estimate an Internal Rate of Return over the entire holding period.

With any given property, there may be items that you can forecast with a reasonable degree of confidence. For example, on the revenue side you may have commercial leases that specify the rent for five years, ten, or even more. You may even be able to anticipate a potential loss of revenue at a point in the future when a commercial lease expires and you need to deal with rollover vacancy, tenant improvements, and leasing commissions.

You could be looking at a double- or triple-net property where you are insulated from many or most of the uncertainties about future operating expenses like taxes, insurance and maintenance.

Or, with residential property, you may have a history of occupancy percentage and rent increases that permit a credible forecast of future revenue.

Then there is the more basic question, why are you analyzing this property at all? Why are you running the numbers and making this CoC calculation? Are you trying to establish a current market value, as a commercial appraiser might? Or are you trying to make a more personal decision, i.e., will this particular property possibly meet your investment goals? And what are those goals?

Seems like I just took a nice simple metric and wove it into a more complicated story. Sorry, but in your heart of hearts you know if investing really were that simple, then everyone with a pulse would be a huge success. At the same time, it doesn’t have to be so complicated either, so long as you approach it in a reasonable and orderly way.

That orderly approach begins with deciding what you are looking to get out of this investment. Maybe you want to hold it for a few years to get strong cash flow and then sell it, hopefully for a profit. Perhaps you intend to hold it long term, less concerned with immediate cash flow (so long it as it positive), and then sell the property much later to fund your children’s college costs or your own retirement. In either case, if your plan is to buy and hold then there is one thing you can’t ignore: the future.

This approach continues with projection of the revenue, expenses, potential resale, and rate-of-return metrics, running out to your intended investment horizon. Perhaps key here is the realization that you shouldn’t really expect to nail your projections with a single try. Consider several variations upon future performance: best-case, worst-case and somewhere in-between scenarios to give yourself a sense of the range of possible outcomes.

All this brings us back to the duel between the Cash-on-Cash metric and DCF/IRR. I believe if you rely only on the former, then you are not just saying, “You can’t predict the future.” You’re saying, “If the first year looks good, then that’s all I need to know.” This is, quite literally, a short-sighted investment strategy. The takeaway here is that there should be no duel between metrics at all; that prudent investors can use Cash-on-Cash to get an initial reading of the property’s immediate performance, but they should then extend their analysis to encompass the entire lifecycle of the investment. To quote the folks at NASA (who, after all, really are rocket scientists), “It takes more than one kind of telescope to see the light.”

—-Frank Gallinelli

####

Your time and your investment capital are too valuable to risk on a do-it-yourself investment spreadsheet. For more than 30 years, RealData has provided the best and most reliable real estate investment software to help you make intelligent investment decisions and to create presentations you can confidently show to lenders, clients, and equity partners. Learn more at www.realdata.com.

Copyright 2014,  Frank Gallinelli and RealData® Inc. All Rights Reserved

The information presented in this article represents the opinions of the author and does not necessarily reflect the opinions of RealData® Inc. The material contained in articles that appear on realdata.com is not intended to provide legal, tax or other professional advice or to substitute for proper professional advice and/or due diligence. We urge you to consult an attorney, CPA or other appropriate professional before taking any action in regard to matters discussed in any article or posting. The posting of any article and of any link back to the author and/or the author’s company does not constitute an endorsement or recommendation of the author’s products or services.

Crowdfunding Real Estate Investments

Pooling of resources, passing the hat — call it what you will, but collaborative underwriting has probably been around for a couple of centuries. Never one to leave well enough alone, the internet has again risen to the role of game-changer, extending a global reach to individuals and companies looking for backers.

You have probably heard of the crowdfunder Kickstarter, which is a popular donation-based site, aimed primarily at creative projects. Backers who donate to such projects don’t become shareholders or expect any financial return. They may be more akin to patrons than to investors.

But investment-based crowdfunding sites have also emerged. I can’t say that I knew much about them, but I recently attended the annual Yale Alumni Real Estate Association’s National Conference where one of the sessions was devoted to this subject, with presentations by two of the top players in this field: Daniel Miller of Fundrise and Rodrigo Nino of Prodigy Network.

Although this method of funding real estate projects may be just a blip on the radar at present, it does appear that more and more real estate crowdfunding sites like these are cropping up and deals actually are getting funded. So just what is this all about and how is it supposed to work? I’ve tried to take what I learned at the Yale conference and have expanded on it a bit; and so, the following are a few observations from an interested outsider.

For the Project Developer Seeking Financing

Among the top arguments for crowdfunding a real estate project are these:

  • It offers an opportunity to get a project financed more quickly and easily than it would through more conventional channels.
  • By eliminating some of the middlemen usually involved, it can lower transaction costs.

The arguments seem credible, since most bank and institutional financing has become a test of endurance. Some crowdfunding sites offer both debt and equity investments, and most are quite specific as to the types of properties with which they deal. The process may not be entirely a walk in the park, because the typical site screens developers by taking them through a rigorous application and evaluation process.

For the Investor

One attraction for investors is that they typically don’t have to pony up a huge commitment to participate in a single project. Hence, they could spread smaller chunks of cash among several properties or even several developers, thus spreading their risk.

There would appear to be a few murky areas, however. Successful commercial real estate investors generally apply a laser focus on their due diligence. In a crowdfunded scenario one should expect that the developer will be doing that, carefully vetting the property and supplying detailed financial information and projections to the potential investor; but how much detail will they provide and can the investor independently verify that information? With the proliferation of crowdfunding sites, will there be consistency among them in the amount and quality of data they provide? A prudent investor must be certain at least to take a very careful look at the track record of the developer.

Investing through crowdfunding may have particular appeal to inexperienced investors. They should be particularly cautious, understanding that there is not likely to be any liquidity, that their cash could be tied up for a considerable time, and of course that there is no guarantee of an acceptable return or of recovering the initial investment. Sometimes deals simply fail.

How is Crowdfunding Even Possible?

It should come as no surprise that there are plenty of regulations that govern these investment offerings. It appears that most of the crowdfunding sites have been operating under SEC Regulation D, which limits general solicitation and restricts participation to “accredited investors.” These generally include investors with a net worth of at least $1 million (not including the value of their home) and income of $200,000 for the past two years, or $300,000 together with spouse.

One site, which at present seems to be unique, is Fundrise. They have been able to use an obscure SEC Regulation A that allows non-accredited investors to participate in community-based deals with investments as little as $100. There is apparently plenty of hoop-jumping for them to deal with, since this regulation also involves state approvals as well as a limit on capital that can be raised in a 12-month period.

In 2012, Congress passed the JOBS Act (Jumpstart Our Business Startups)  and in September 2013, Title II of that act became effective. Title II allows general solicitation, but only to accredited investors.

Title III of the JOBS Act is called the “Crowdfunding Exemption.” Expected to work its way through the SEC rule-making process sometime later this year, it would allow non-accredited investors to participate in equity offerings. The proponents of investment crowdfunding see this as the real game-changer.

Conclusion

Crowdfunding could revolutionize how real estate investments are financed, but not everyone is convinced that it is the Next Big Thing. A recent BusinessWire article cites a number of concerns, including one that this writer has seen elsewhere:  “Will crowdfunding expose innocent, small-time investors to fraudsters and scam artists?”

Both real estate crowdfunding itself and the regulatory environment that will govern it are in their infancy, so how this will all play out must be a matter of conjecture for now. On the one hand, the real estate industry — to put it as politely as possible — has a long history of being resistant to change. On the other, technology in the 21st century has had a habit of sweeping away things that we confidently viewed as permanent cultural fixtures. To be convinced, I need only to rummage in my basement to dig out my old rotary-dial wall phone and my case of incandescent lightbulbs.

Time will tell the story.

—- Frank Gallinelli

Read more in the recent press about real estate crowdfunding:

Crowdfunding’s Latest Invasion: Real Estate

How Crowdfunding Could Reshape Real Estate Investing

The Big Five in Real Estate Crowdfunding

####

Your time and your investment capital are too valuable to risk on a do-it-yourself investment spreadsheet. For more than 30 years, RealData has provided the best and most reliable real estate investment software to help you make intelligent investment decisions and to create presentations you can confidently show to lenders, clients, and equity partners. Learn more at www.realdata.com.

Copyright 2014,  Frank Gallinelli and RealData® Inc. All Rights Reserved

The information presented in this article represents the opinions of the author and does not necessarily reflect the opinions of RealData® Inc. The material contained in articles that appear on realdata.com is not intended to provide legal, tax or other professional advice or to substitute for proper professional advice and/or due diligence. We urge you to consult an attorney, CPA or other appropriate professional before taking any action in regard to matters discussed in any article or posting. The posting of any article and of any link back to the author and/or the author’s company does not constitute an endorsement or recommendation of the author’s products or services.