Intro to Multifamily Underwriting: 5 Steps to Calculate Effective Gross Income (EGI)
Quite commonly you hear this phrase “real estate is all about the numbers.” This phrase is one of the more eloquent falsehoods in real estate. I suppose we could think of this statement as truth, but we’d have to qualify the statement with:
Want more articles like this?
Create an account today to get BiggerPocket's best blog articles delivered to your inboxSign up for free
- Whose numbers?
- Which numbers?
- When numbers?
- Where numbers?
- Why numbers?
You get the point.
If Not the Numbers, What Is it About?
I want you to imagine yourself as a painter. There you are. It’s spring in Paris. Romance is in the air. Multifamily is on your mind…
You’ve got your apron and your beret on. You look the part. You are an artist. You’ve got your palette in your left hand and a brush in your right. Ready, set, go.
But what comes first—mixing of paints on the palette or establishing a vision of what you want to paint? You know that it is within your ability to mix those paints in a billion different ways. Whatever shade you need, you can create. But is that where the process begins, or is mixing paints an outcome of your vision of what is to become your painting?
It’s All About the End
I promise you that whichever facet of life you examine, you will find the same phenomenon—everything begins with the end in mind. The choices you make while raising your kids are all a function of whom you imagine your children becoming in the end. Your diet and exercise regime is all about how you see yourself 30 years from now. How you treat your friends today is all about how you see them treating you when roles are reversed tomorrow. Your marriage—don’t even get me started on that one! Your behavior around investing has to be teed-up by your vision of the final destination.
You see, you “mix your paints” only after you know which shades you need, and you will only know which shades to use once you clearly see in your mind’s eye that which is to become the painting.
Once you see the end, you can walk it back to arrive at all of the building blocks you’ll need to actually get there.
In real estate, this works the exact same way. Whether you buy a building or not is a function of being able to project what life with that building will be like. It’s the story. Now, once you understand the story, you use numbers like a painter uses paint.
An Important Distinction
Real estate is not about the numbers any more than paintings are about the paint. Real estate is about the story, and numbers are there simply to tell this story.
The important distinction to make is that people who understand storytelling in real estate are able to manipulate the numbers much the same way a painter is able to manipulate paint to tell whatever story suits them. And if you make the mistake of focusing on the numbers as your entry point to the underwriting, those numbers will tell you the story that someone else wants you to see, not the truth.
The story is the truth. Start there. The numbers are there to represent the story. But always start with the story.
In the following few articles, I’ll attempt to present to you the story, at least in the very broad strokes. Each time I sit down to underwrite a new opportunity, I methodically put numbers into a spreadsheet that contains about eight pages. Each page is there to address a specific part of the story. Today, we are going to begin with page one—Stabilized P&L.
I call this page my “back of the napkin” underwriting. The reason I refer to it as “back of the napkin” is because while it tells a complete story in many ways, this page is static in nature. Of course, all of us know that any realistic story in real estate cannot be static—things change every week, month, year. A good underwriting model has to address all of these dynamics. But we have to start somewhere, and for me, it’s the Stabilized P&L on page one of the underwriting.
There are several questions being asked at this first stage, most importantly: If this asset were operating to its best capacity, what will that look like in terms of all of the line-items in the P&L?
We are painting a picture of stabilized operations here. Naturally, we are not buying a stabilized asset, and it will take money and time for it to get there. But if it were there today, what would that picture look like?
Let’s look at some of the line items to consider.
Literally nothing is simple in this game. Even a simple concept of income is something to discuss. There are different types of income. All of them are discounted and synergized into what’s known as effective gross income (EGI). This is essentially your expected collected top-line number. But the process of arriving at the EGI involves several steps:
Step 1: GSR
GSR stands for gross scheduled rent, and this is easy enough to understand. You simply price gross rent for each of the unit types and multiply by the number of units in the type. So, if you never had a vacancy, never had an eviction, never offered any discounts, etc., this would be how much rental revenue comes in.
Now, how you price these rents is crucial for a lot of reasons. Being off by $10/month is a big deal. But that’s for another time.
Step 2: Economic Losses
It’s nice to imagine that everything is perfect all of the time, but nothing ever is. So, in our underwriting, we have to allow for imperfections. The following subsection of the underwriting is called “economic losses,” and it includes the following line-items: loss to lease (LTL), physical vacancy, concessions, credit loss (bad debt), and non-revenue units.
We could spend a long time discussing what these are exactly, and we could spend an even longer time talking about the why, when, and how of each of the above economic losses. We could represent these as percentage or per door dollar costs, and there are accepted norms which we baseline on. Remember, you are telling a story, though, so whether you use, percentage or dollars, you must first understand the story—the why, when, and how—and then boil it down to the numbers. This is an article of its own.
But understand this—even though you are not necessarily writing checks to cover these items because they manifest in the form of lost revenue, they are just as real as any other cost/expense. Economically speaking. these inhibit your bottom line by discounting your top line.
You won’t hear many people talk about these items. However, I have to tell you that not paying due respect to the economic loss items will cost you lots of money. I should also tell you that prudently, the minimum stabilized economic loss I’d recommend you use is something around 8 percent. I won’t tell you that you couldn’t outperform. But it’s not safe to underwrite anything less in my opinion.
This means, boys and girls, that even a stabilized property, one functioning at capacity, will lose 8 percent of its revenue before you pay a single bill. Let me say that again, so you get it:
Even a stable property will lose about 8 percent of its top line before you ever write a single check for a single service or cost. Internalize this!
Step 3: Effective Rental Income
Thus, you take your GSR from Step 1 and discount it by the amount of your economic loss, and this gets you to the effective rental income. Effective income is income after the economic losses.
Step 4: Auxiliary Revenues
In most income-producing assets, the income is comprised of actual rents and auxiliary revenues. One of the biggest auxiliary revenues has to do with utilities. Whether RUBS or a simple fixed bill-back is utilized, the utility income gets its own line item in our underwriting. There are accepted norms for this line item, but this is very subject to everything from asset class to location, so telling the correct story is very important here.
Aside for utility income, there may be some additional income streams—things such as pet fees and deposits, late fees, insufficient funds fees, early termination fees, laundry income, parking income, storage income, and more. We combine those into another line item in this section. And, true to form, while there are national baseline statistics for these, it’s all about your specific story.
Step 5: Effective Gross Income
By adding the auxiliary revenues from Step 4 to the effective rental income from Step 3, we arrive at the effective gross income (EGI). This is the income we would expect our asset to be capable of generating on an annual basis.
Wrapping Up for Now
So, in the beginning of this process, we sat out to answer the question, what do stable operations look like in this asset in terms of the P&L? We now have identified the story of the income, be it in very broad strokes. Once the income is coming in as it should, and once the economic losses are under control and normalized, this is what the income side of this asset’s equation looks like.
We will obviously need to make adjustments to these figures later in the underwriting process to cater to the fact the today the subject asset is not stabilized. But this comes later. First, we need to figure out the expense side of our Stabilized P&L, and we will do that in the next article.
Any questions about this process?