Categories
Acquisitions Asset Management Finance

12 Questions To Understand NOI

NOI is one of the most common requests by institutional and family office investors. What does NOI mean? It means “net operating income”.

Most real estate firms use NOI to value properties. NOI gives a true sense of the cash flow at the property by using operating revenues and operating expenses. Anything below the line, meaning below NOI, is not in the normal course of operating the property and therefore, not used in the property’s valuation.

Let’s take a hypothetical situation to better understand what NOI means.

New Investor Requests NOI Details from Real Estate Firm

Perhaps you landed a job at CALPERs. You go, Glen Coco! That’s a huge win.

As part of your job, you need to assess GPs, aka real estate firms, to understand potential investment opportunities in their funds or other vehicles. You will want to understand the investment vehicle’s overall returns as well as individual real estate investments’ performance. That’s because different funds or vehicles will have unique waterfall structures that impact how much you, the investor, get paid. 

These waterfall structures are up for renegotiation anytime you invest in a new vehicle. As such, it’s important to understand how well the actual real estate performs, as that could potentially result in higher returns for you. It’s also easier to compare across other real estate firms’ vehicles, as the waterfall structures will vary. 

Most new institutional investors (such as yourself in this scenario) make a HUGE mistake here. They know that NOI is important, but they fail to specify what kind of NOI they want. Instead, they send an Excel table with column headers for “Property Name” and “NOI”.

As a GP, I’m freaking out! Here’s what runs through my head: 

12 Questions to Understand NOI

  1. Did you mean NOI at acquisition? 
  2. Or NOI at exit? 
  3. Maybe you meant current NOI? 
  4. Or maybe base case underwritten? 
  5. Current projected? 
  6. What about the time frame? Did you mean trailing 12-months? 
  7. Current month (T1) annualized? 
  8. T6 annualized? 
  9. Or projected 12-months? 
  10. If trailing or projected, do I include the current month or start with the month prior or after?
  11. What GL accounts should be included per their definition of NOI? 
  12. Is that consistent across all of my property types?

Trust me, these questions could go on and on. Most new institutional investors don’t know what they’re looking for, and many a real estate firm throws darts at a dive-bar decades-old dartboard blindfolded and milk-drunk from the fact that they finally landed an institutional investor. 

How Real Estate Firms *Should* Present NOI

As a GP, I recommend presenting the version of each metric that shines your firm in the best light, as long as you’re consistent across all investments or properties. Then, leave your investor with a list of footnotes explaining what you did. You’ll want this anyway to document and train someone else to help you someday.

How Investors *Should* Request NOI

As an investor, you’ll want to clarify at least some of the 12 questions above. Otherwise, the data that you receive back won’t be comparable across GPs. And if that’s the case, what’s the point of requesting that data anyway?

What Actually Happens...

Now, let me let you in on a dirty little secret… most institutional investors rarely scrutinize these reports in detail. They will check to make sure that GPs filled them out at least partially. And that’s about it. That said, an investor will – perhaps a new one who read this article – review these reports line by line. They will ask detailed questions and send the report back to the GP, redlined and asking for explanations. 

As a GP, you should complete these reports in the same way you do for your regular performance updates; provide just enough information that doesn’t beg additional questions. That may mean filling out all required information, or that may mean filling out what you feel most confident in. I’ll leave that up to you.

Now you know the 12 questions to ask about NOI as a GP and as an institutional investor. I hope you use this knowledge to make improved investment decisions and sharpen your portfolio’s performance. Let me know if you have any questions or edits. I always love hearing from you.

Categories
Acquisitions Power BI

How to Build Your Real Estate Investment Pipeline in Power BI

Do you have Monday morning meetings to review your investment pipeline? If so, you’re in good company. And if not, I bet that you still review your investment (aka deal) pipeline on a regular schedule. It’s imperative to know who’s working on what investments, how those opportunities fit into your firm or fund portfolio, and what stage each of those opportunities are in. Here’s how to build your real estate pipeline in Power BI.

Psst.. for a jumpstart, you can purchase my easy-to-use Power BI report at the below link. And I included a video below so you’ll know exactly what you’re getting.

Why Should You Use Power BI?

Power BI enables real estate professionals to seamlessly integrate and analyze large volumes of data. The interactive dashboards and reports generated by Power BI provide a comprehensive and visually appealing overview of key metrics, allowing decision-makers to gain valuable insights quickly and make informed strategic choices. With the ability to create customized reports and drill down into specific details, real estate professionals can identify patterns, assess risks, and capitalize on emerging opportunities. Every acquisition team knows that time is of the essence, and Power BI lets you see emerging trends faster than you would in a spreadsheet.

Moreover, Power BI’s user-friendly interface facilitates collaboration within the team, fostering a data-driven culture that ultimately enhances efficiency and competitiveness in the dynamic real estate market.

If you don’t have Power BI yet, click the button below to get started. I highly recommend checking out Guy in a Cube for Power BI tips.

4 Key Elements for Real Estate Investment Pipeline in Power BI

With Power BI, you can quickly and easily plug your investment pipeline from Salesforce, Excel, or whatever database you use. Then, you can visualize your pipeline across whatever categories are important to you. The top 4 key elements for your real estate investment pipeline in Power BI are:

  1. Stage (i.e. pre-screen, under contract, LOI, due diligence, etc.)
  2. Property type (i.e. market-rate multifamily, retail, etc.)
  3. Geography
  4. Fund (if applicable)

Real estate firms who primarily finance investments via syndications will want to view their pipeline and existing portfolio by investor.

The great news is that you have a myriad of options with a tool like Power BI. 

Accelerate Your Power BI

Want to get a jumpstart on your Power BI development? Download the real estate investment pipeline report in Power BI below.

In this report, I show you how to visualize your pipeline across geography, property type, and fund. This report is based on a deal pipeline in Excel.

Hope you enjoyed this post on how to build your real estate investment pipeline in Power BI. Good luck and happy data modeling!

Become the best commercial real estate and tech professional you can be.

You know what to do…