Real Estate Asset Management Part 2: Financial Analysis
Being an asset manager is being
in control of the assets for
your real estate syndication or
real estate investment fund. The
job itself is like property
management. But you can think of
it as the higher level decisions
that go on to in making sure
that the asset performs the way
it's supposed to. We talked in
the last video about property
analysis, this video talks about
the financial analysis that
takes place. Again, the purpose
here is to set a baseline for
the existing for the existing
performance, so we can measure
against it identify issues
before they become problems.
This is also where you may start
to see oh, this is timing to
exit the VAT exit the property,
either in here, or it's going to
be in the market analysis, which
is our third video. I hope you
find these videos helpful.
We're talking about operations,
we're talking about custody. And
in this video, we're talking
about financial benchmarking.
Now, why are we talking about
this here? Well, we're talking
about it, because what we're
trying to do is under the
custody portion, we're setting a
benchmark. And this is something
you'll regularly do either every
month or every quarter, in order
to keep track of where you're at
with your property. So what
we're trying to do is we're
trying to set a benchmark, in
order to make sure that we're on
basically the right track, it
lets us know where we've come
from, and where we're going. And
it gives us a good idea of that.
So there's a few ideas that we
need to go through. First off,
this is not your underwriting
portion of the core, the
underwriting portion actually
comes under rally and undefined
is where you'll be mostly doing
your underwriting, as well as in
the finance section. Also in
rally, that's where we'll be
talking about more underwriting.
But I'm gonna go through this in
some level of detail. And it's
gonna be a repetition to some
extent, because what I want to
make sure we're doing is we're
getting this in this is the
basis of all real estate, this
is one of the most important
issues. By far and understanding
how the money works, you
understand how the money works,
you can start understanding how
a syndication works, and then
ultimately, you can talk to an
investor. So we need a few
things. In order to get started
with this, we need a rent roll.
This you may have already done
in your lease analysis. Also
under this section, if it's not
done yet, you will need to
generate a rent roll. Because
basically, what you're trying to
find out is who all your tenants
are, what the rent is, what the
operating expenses they pay is,
in order to be able to put this
into your financial benchmark.
It also is very, very helpful to
have three or more years of
operating history. Now, you may
or may not have this, but it
certainly helps in order to be
able to figure out what what
some costs would be, or what
income looks like, or what our
vacancy rates look like things
like that, in order to
accurately predict it. So then
we've got our Loan Summary.
Because what we're trying to
find out here is just the cost
of the money that we're using
the cost of the debt that we're
applying to this indication. So
let's get started. Now what
we're going to do is we're going
to be taking a snapshot. And
what we'll be doing is this is a
snapshot that can take place
over a month to month basis. And
I encourage you to do it that
way in order to make sure that
you're on top of your finances
at any point. And this feeds
directly into the information
that's super valuable for when
you're giving your investors
their updates, which will either
be a monthly or quarterly and
we'll talk about that in our
update in the communication
section under updates. But it's
will be very important
information to make it very
simple for you. So let's start
with income. Actually, let's
start with these two ideas. And
we talked about this in our
underwriting as well. We have
our above the line costs, and we
have our below the line costs.
That line is drawn at noi. So
everything above the line is
goes into calculate noi,
everything below the line is
just used to take that NOI and
figure out what our cash flow
is. So let's say, let's start
with all of our above the line
costs. So first, we start with
income. Now, since you've
already got your rent roll, what
we're trying to project is for
that past month, what is our or
what was our rental income? What
was that rental income, so you
know how much money you took in.
And then I would do it based on
the total income, that is
potential, you don't have to do
it this way. This is an advanced
technique that's really, really
useful.
And what we're saying is, of the
leases that are in place, what's
the total amount that we could
then that we could have turned
in. So if somebody hasn't paid
their rent, we're still counting
that. But we're not taking into
account. But we're putting, so
we're putting that as $1 amount,
and then we're going to subtract
it out later. Same thing with if
you have a vacancy, we would
actually put the market value of
that in and then subtract out
that the that vacancy cost. And
here's where we do that is here,
this next line, we're going to
subtract out vacancy and credit.
And we do that because then it's
very simple for us to see a
historical basis for what our
costs are for vacancy. And what
is also been our costs for
nonpayment. And then when you
take those you take rental
income minus the vacancy, you
get the effective rental income.
But that's not the end of the
story is it because not all of
your all of your buildings
sometimes have additional
sources of income. If you think
about an apartment building, for
example, you may have laundry in
the apartment building, and they
play, they pay for laundry, so
that becomes other income. And
so we add other income
to that to the effect of rental
income, and we get our gross
operating income. So that's how
we get our gross operating
income. Now, that's not the only
thing that goes into the
financial benchmark is there,
there is also your expenses.
Now, I like to do my expenses in
a very specific order, you may
change the order as you will, I
like it in a specific order,
because it's what most
commercial real estate brokers
are used to seeing it in this
order. Because it's also the
same order that's used by
organizations like CCI M. So I
follow the same order. And I
think it makes sense. I always
know where to look when it's
there. And it makes it very
efficient. So I want to know
what my taxes expense is. So
this could be your property tax,
this could be your this could be
your personal property tax. It
sometimes there is that personal
property tax, and I would just
add them together or you can
break them out on different
lines. Now you may be in a place
and probably are where property
taxes are not paid monthly.
They're paid maybe two times a
year. And if that's the case,
you have to do you have a choice
to make either to build an
account in order to allocate for
that, say you amortize it over
that that period of time, or you
can and kind of segregate your
account money that way or you
can just do it on a month basis.
But then you're going to have
some months where you get
clobbered and then you have some
months where you're going to be
doing great. So I would rather
you amortize it out. And maybe
just make a note that it's an
amount that's amortized over
over that 12 years or 12 months.
Then we have our insurance. And
here we really mean our property
insurance. And then management
fees. Now, management fees,
typically can be broken down
into more portions, if you more
different categories, depending
on how extensive your management
is, if you're doing payroll,
things like that, we do put line
items, we'll go through those in
a minute. But maybe it's just a
straight management cost. If you
have a third party manager, then
you probably just have a
straight management cost rather
than breaking it down like this,
but there are some other
categories like payroll and then
man expenses of the management
company, so that may be your
postage or things like that.
Taxes and workman's comp
so these all kind of go under
management. And if I'm doing
this in a spreadsheet, I'm
probably kind of compressing it
and making it look neat so that
they all kind of go together and
it makes it a little bit more
clear. Then I want to know I do
repairs and maintenance. Now I
like to break these down into
three different categories to
make it simple for me to
understand. So I like to do non
capital repairs
and then capital repairs and the
difference between these really
is more as more to do with how
you're going to depreciate it
for our purposes than anything
else. But I like to break it
down this way because typically
a non capital repair is
something that comes very you
know that I'm not going to
amortize over the course of a
year where a capital repair is
something I might very well so,
after capital repairs, I do my
maintenance and this is really
everything else
and then I because it's so
closely related to maintenance I
like to put my janitorial
Portage there then we start
talking about utilities I should
back up a little bit so there
are a lot of buildings where the
tenants are paying part of their
utilities but the bill is coming
to the to the landlord and so I
count cam reimbursements here
cams so I put my cams in my
other income you could I suppose
put it as part of your your
rental income and then also you
also have a calculation for your
vacancy and credit but it may
not balance out if you did it
that way. So under Utilities,
we've got our electricity water
gas, trash. I like to put all
those I like to put trash
underneath utilities you may
have sewage may be separate well
however it works best for your
property. Then we've got
accounting
and legal and now here's
something I like to point out.
These are things that are affect
the property. This is not items
that are for your syndication.
So I would not include things in
accounting and legal things like
lawyer fees to get your your PPM
done. I would not look put in
there things for you are taxes
for your que ones specifically?
It is not what I would include
in there, what I would include
in there is any kind of
accounting and legal that
pertains to that property
itself. So you have a slip and
fall on the property, you get
brought into a lawsuit, I would
put that in there, you have an
investor suing you because
they're not happy, I would not
include this in their licenses
and permits.
This can be everything from your
business license if required, or
your elevator license, things
like that. Advertising. A lot of
places will advertise to make
themselves kind of known in the
community and increase
themselves. It's not super
necessary, but I would certainly
include things like your
vacancies, I would include my
advertisements for vacancies
that I am paying a in there as
well. Now if you're if you have
a real estate agent who is doing
the leasing for you would not
include that unless it was was
something that was completely
separate from their brokerage
fees. And then their supplies,
this is everything from toilet
paper to cleaning fluid to
things like that things every
building needs. And then we put
other contract labor
and here we're talking about
pest control your H fax service
contracts, your roofing service
contracts, snow removal items
like that. Now, at the end, we
add all of those up we get our
total operating expense expenses
so now what we've done is now
we've got our we can go all the
way back up here and we can say
our our gross operating income
minus our total operating
expenses equals your net
operating income
so now we've got our bills are
everything done in that above
the line area, right, this is
everything above the line. So
let's begin even
Okay, so now that's our above
the lines. Now let's do our
below the line. So let's start
first, both by putting in a y
over here. And now let's
subtract out a few things. So
now let's subtract out our debt
service. interest. And here I
really like separating this out
and separate out my debt service
principle I separate this out
because it makes my calculations
about different ways of doing
our my ROI better and easier to
see. And it also sets me up for
seeing what my after tax
situation is. Now I don't think
that the that the financial
benchmark is the proper place
for calculating your after tax.
So I don't I don't include that
in my benchmarking when I do it.
So I subtract out the debt
service interest debt service
principle if I have multiple
loans, obviously I have more
items than just two. And then I
calculate anything I subtract
out anything I put away towards
my funded reserves because that
moves off your income statement
over to the assets statement.
And then ultimately, and then I
subtract out any leasing
commissions I paid
And then, and that includes if
you are a syndicator, and you
did your own leasing, but you're
getting paid a leasing
commission that includes money
that was paid to you as the
syndicator. And that equals our
cash flow. before taxes.
So, how often do I do this?
Well, at the end, I do this, I
tend to do this on a monthly
basis, sometimes I'll do it on a
quarterly basis, but then I will
backtrack to make it a monthly
thing. And so typically, when I
Syndicate, I generally don't do
my own property management, I
tend to hire a property manager,
because I have other things that
I would rather be doing. But I
mean, not that there's anything
wrong with property management,
but I it's my use, my skills are
much better at left not doing
the property management and
having somebody do it. And then
I get them to basically fill all
this out on the income on the
expenses, I just finish up the
the other expenses as well make
sure it's lined up. And then at
the end of the day habit. So I
like to do it on either an on a
quarterly basis, or monthly. So
I basically am building out this
as we go along this running
spreadsheet that just goes down
the line. And then what I can do
with that is I can really
quickly get different
performance measures out of it
and see how I've been doing. Now
at the very outset of this, you
probably will be doing a one
year snapshot. Now that one year
snapshot will be dated at the
time of purchase and the year
previous to it. So it's sort of
like leading up to it plus that,
but I would add any changes in
taxes on the front end. So I
would kind of do it's kind of a
pro forma. But I'm not doing a
pro forma based on changes in
rents or any sort of add value I
want. Basically what I'm trying
to see is what it would look
like for the for a year where I
owned the property, but I did
absolutely nothing and I didn't
as it so I can kind of set a
benchmark on that. They
certainly can do at the time of
purchase. That's okay, too. But
I would caution you, when you're
looking at your measures on
things, especially like taxes,
there's going to be a
substantial change in taxes in
most jurisdictions within that
one within that year, or within
two years, when they have set
the reassessment time. So that
said, that's when I do that. And
this is a below the line. So the
cash flow before taxes
ultimately is what your investor
cares about. In your particular
investment. You're above the
line cost is what what a buyer
cares about. Not that your
investor doesn't care about it.
But your true performance for
the investor is that cash flow
before taxes. That was financial
benchmarking as the monthly or
quarterly time periods. So I
hope you found that video that
blast from the past video
helpful. Now why did I say blast
from the past? Again, this was
made for my High Level
Mastermind, top real estate
professionals that I helped
coach to help them become
investment managers, real estate
syndicators themselves and go
from working very at a high
level either as high level
brokers, high level property
managers, even members of REITs
so that they could then take on
the mantle themselves and
establish their own investment
company. So my name is Tilden
Moschetti. I am a syndication
attorney for the Moschetti
syndication Law Group. If we can
help you be successful by doing
the legal work necessary to help
you become a do your first
syndication, put together an
investment fund, we'd be happy
to help. Not only do we help you
with the compliance piece, we
also obviously have a background
and expertise in the business
side as well. And we can help
use our expertise to help you
and make sure that you're
successful.