We’ve been hiding our bundles under a bushel! Find out more >>

800-899-6060

New Lease Renewal Assumptions feature for REIA Professional

Making assumptions and entering data about commercial lease revenue — especially rollovers — was often a tedious undertaking. Until now.

Enter our latest game changer: REIA Professional’s Lease Rollover Assumptions

What is it?

Our new Lease Rollover Assumptions feature (LRA) is a way for you to store sets of parameters about different commercial lease rollover scenarios, parameters which you can use over and over when entering tenant information in REIA Professional. What is the probability that a current tenant will renew? How long do you think the space will be vacant if a tenant chooses not to renew?

Build your assumptions sets, add your tenants, and apply the LRAs. Done.

You rely on our products to crunch the numbers quickly and accurately so you can make the best and most profitable commercial investment decisions. LRA brings you a whole new level of power and speed.

How it works

First, create a set of assumptions on the new LRA worksheet.  Enter values for months vacant, rollover probability, new and market rent, etc.

lra4

Then apply those assumptions to a tenant just by selecting the option on the Commercial Income worksheet:

lra5

How to get it

If you already own a license of REIA Professional version 18, then you just need to download the latest build from your customer account at realdata.com

If you have a previous version, consider upgrading.  Upgrade costs can be found here.

Learn More

We have a knowledgebase article which walks you through the setup and configuration of the LRA feature.


Real Estate Expense Recoveries—What are they, how do they work? (part 3)

In Part 2 of our discussion of real estate expense recoveries, we looked at several different methods that property owners use to recover some of their operating costs from tenants:

  • Simple pass-throughs — These typically work well in single-tenant properties, or in properties with no common area. The expenses chosen for reimbursement are billed to the single tenant; or if there are multiple tenants, then the charge is divided according to each tenant’s share of the total space.
  • Expense-stop pass-throughs — Some pass-through arrangements require the tenants to pay a just portion of the recoverable expenses. The landlord pays up to a certain amount, called an “expense stop,” and the rest is passed through to the tenants. The “stop” can be a dollar amount defined in the lease, or it can be a “base-year stop,” where the landlord pays whatever amount comes due in the first year of the lease and the tenants pay any increase in subsequent years.
  • CAM — In larger properties, where there is common space for the benefit of all tenants as well as for the public, the landlord my collect CAM (Common Area Maintenance) charges—expenses related to the maintenance of these common areas.

We left off at sticking point, however, regarding larger properties. If there is a significant amount common area, then the landlord will surely be thinking about the fact that this space accrues to the benefit of the tenants but doesn’t earn anything for the landlord. There must be a way to remedy this apparent inequity.

 

The Load Factor

Enter the “load factor.”

Fotolia_42618982_XSload factor

Recall two definitions near the end of the previous article:

usable square feet (usf): The amount of space physically occupied by a tenant.

rentable square feet (rsf): The amount of space on which the tenant pays rent.

The load factor represents a percentage of the common area, which is then added onto a tenant’s usable square footage to determine the tenant’s rentable square footage.

Let’s say a shopping center has a total area of 100,000 square feet. 90,000 is the usable area, occupied by tenants, and 10,000 is common area.

Load Factor = total area / usable area

Load Factor = 100,000 / 90,000

Load Factor = 1.11

What this means is that each tenant’s usable square footage will be multiplied by 1.11—in other words, bumped up by 11%—to determine its rentable square footage, the amount on which it pays rent.

Say for example that you operate a 2,000 square foot boutique in this 100,000 center, and have contracted to pay $40 per rentable square foot.

2,000 usable sf x 1.11 load factor = 2,220 rentable sf

2,220 rsf x $40 = $88,800 per year rent

Unlike what you did in the earlier pass-through models, you’re not paying an additional charge on top of your base rent here. Your base rental rate remains the same, but now it is applied to a greater number of square feet—the space you actually occupy plus a proportional share of the common area. This combination of your private space plus a pro-rata portion of the common space is what we now call your rentable square feet.

You and the other tenants are paying rent for your proportional shares of the common area from which you all benefit, and the landlord is receiving rent for all the space in the property. Cosmic equilibrium is restored.

 

 

Is It More Income or Less Expense?

Regardless of the name we give it—reimbursement, recovery, or pass-through—the end result is the same. The bottom line of our Annual Property Operating Data (APOD) form, Net Operating Income, is increased. The final issue to confront is how do we account for this additional money when we assemble a presentation or analysis?

more lessOne way that I see often, and which I believe to be incorrect, is to treat the reimbursement as if it were a negative expense—in other words, to show the expense reduced by the amount reimbursed. For example, if the actual property tax bill were $10,000 and the amount reimbursed were $9,000, then by this method the property tax expense would be shown as $1,000. Why do I say this is incorrect?

The purpose of an APOD, or of any income-and-expense statement, is to convey information that is both accurate and useful. The taxes for this property are $10,000. If you were a broker or property owner and handed me a report that showed taxes of $1,000, I would…

a) suspect you were trying to con me

b) doubt all of the rest of the numbers on your report

c) be denied essential information I need to evaluate the property (e.g., the true cost of property taxes and the lease terms regarding expense reimbursement)

d) find another broker or owner to work with

e) all of the above

The correct answer, of course, is “e.” You’ve missed a key ingredient of successful business discourse: clarity. You should convey your analysis of a property in terms that are unambiguous, accurate, and relevant to your audience.

If you don’t treat the reimbursement as a negative expense, then how should you handle it?

You should treat it as revenue, the same as rent.

  • It is rent. The amount may be based on a calculation involving one or more operating expenses, but it is still money paid by a tenant to a landlord under a lease agreement. If it walks like a duck, etc.
  • Many lease agreements will in fact describe the reimbursement as additional rent.
  • You can then apply a vacancy allowance to the total of base rent plus recoveries to account for the loss of both from a vacant unit. The top portion of your APOD might look like this:

(One side note on the interplay of vacancy on expense recoveries: Some leases will contain a gross-up clause. In such a lease, if there is less than full occupancy (which is defined in the lease, and is often pegged at 90 or 95%), then the landlord may take certain variable expenses that would be directly affected by the level of occupancy, such as janitorial cost, and “gross them up” to the amount they would be at full occupancy.)

In these three articles I’ve given you the abridged version of simple, single-tenant pass-throughs; pro-rated multi-tenant pass-throughs; expense stops; base-year stops; CAM charges; load factors; and even presentation issues. But there is no limit to the creativity of landlords and tenants in their pursuit of successful dealmaking. If you’ve been part of novel expense-recovery design, please share it with us.

—-Frank Gallinelli

Want to learn more? Visit learn.realdata.com

####

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. Find out more at www.realdata.com.

Copyright 2016-2023,  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.

Real Estate Expense Recoveries—What are they, how do they work? (part 2)

Expense recoveries (aka reimbursements or pass-throughs) serve as a customary ingredient in leases for non-residential property. In part 1 of this article, I discussed some of the typical ways such an arrangement might play out.


The Simple Pass-Through

Fotolia_84790892_XS_split_costsIn a single-tenant property the tenant may be expected to pay all or a portion of certain operating expenses, such as property taxes and insurance, in addition to its base rent. If the tenant is obliged to pay just a portion of the expense, that amount is the excess over what is called an “expense stop.” Let’s say the property taxes are $12,000 and the lease requires the tenant to pay the excess over an expense stop of $4,000. The tenant would have to pay $8,000.

property tax expense — expense stop = expense reimbursement

$12,000 — $4,000 = $8,000 expense reimbursement

If this were a multi-tenant property, the recoverable amount would typically be pro-rated among the tenants—that is, it would be divided up according to the square footage of each tenant’s space in relation to the whole.


Base-Year Expense Stop

A variation on the expense-stop theme is the “base year expense stop.” In this scenario, the parties agree that the landlord will pay the full amount of the recoverable expenses for the first year, and in future years the tenant will pay any increase over that base.

An arrangement like this certainly seems straightforward enough, but prospective tenants sometimes view it with a jaundiced eye. What if the landlord tries to maneuver the timing of base year expenses in order to minimize them? Then the excess in subsequent years would be artificially inflated. If that’s a concern, then perhaps the tenant would prefer a pre-defined expense stop, as in the earlier example.

Keep in mind that the tenant does not pay these expenses directly to the original source of the bill. The landlord pays the tab and passes the appropriate charge through to the tenant, hence the term “expense recovery” or “reimbursement.”


Common Area Maintenance

furniture in small spaceNot every property will fit into a nice, neat, divisible mold. Take, for example, an office building or a larger shopping center. Properties like these may include areas such as lobbies, hallways, elevators, escalators, rest rooms, and parking lots—areas provided for the benefit of all the tenants, as well as for the public served by those tenants (i.e., their customers or clients). In addition, there may be services that the landlord provides for everyone’s benefit, such as security, trash removal, and janitorial. How does the property owner pass these costs through to tenants?

One approach is to bundle up the cost of common services into an item called CAM— Common Area Maintenance charges— and to pass that charge through based on square footage, just as one might pass through a property’s tax expense. Let’s take a tenant who occupies 2,000 square feet out of a total of 10,000; and let’s also say that we have identified $1,000 in total CAM charges for a given time period.

pro rata share of space x CAM charge
= expense reimbursement

20% x $1,000 = expense reimbursement

= $200 expense reimbursement

This method may be fine in situations where the CAM charges are based mainly on services, but the property owner might be less than satisfied with this approach if the property has a significant amount of physical area devoted to common use. Why?


Usable vs. Rentable

Perhaps the answer lies in that we mean by “space.” Let’s pause for two definitions:

usable square feet (usf): The amount of space physically occupied by a tenant.

rentable square feet (rsf): The amount of space on which the tenant pays rent.

The common area represents space from which the tenants benefit, but that space is not part of their private, usable square footage. The common space is being used for lobbies and hallways and rest rooms, so it’s not available to lease out and earn rental income. This would not appear to be an ideal business plan for the landlord. Should the landlord absorb the loss? Is there an alternative?

The answer, and more, in our final installment about expense reimbursements.

—-Frank Gallinelli

Want to learn more? Visit learn.realdata.com

####

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. Find out more at www.realdata.com.

Copyright 2016,  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 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, which collectively rate the book at 4.7 out of 5 stars.

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

 

 


Real Estate Expense Recoveries—What are they, how do they work? (part 1)

If you’ve gotten involved as a landlord or tenant with non-residential real estate, such as retail or office buildings, then you have probably encountered a phenomenon that may go by any of several names: expense recoveries, expense reimbursements, pass-throughs, or common area maintenance (CAM) charges. What exactly is this phenomenon and how does it work?

The typical commercial lease will specify a base rent, sometimes as a dollar amount per month or year, but more often as an annual number of dollars per rentable square foot of space occupied by the tenant. Many leases also call for additional rent over the base amount in the form of expense reimbursements.

How it Works—The Math

cash handoffLet’s take a simple example. Say that you own a single-tenant property with 10,000 rentable square feet. The lease specifies a base rent of $30 per square foot. It also says that the tenant is obligated to reimburse you, the landlord, for all property taxes in excess of $4,000 per year. The $4,000 cut-off is called an expense stop.

In the first year of the lease, the total property tax bill is $12,000. How much will the tenant pay during the first year? Start with the base rent:

area x rate = base rent

10,000 square feet x $30 per sf = $300,000 base rent

Now calculate the reimbursement:

property tax expense — expense stop = expense reimbursement

$12,000 — $4,000 = $8,000 expense reimbursement

So the tenant is going to pay a total of $308,000 in the first year.

What happens if the space is divided among multiple tenants? While the leases for these tenants could be structured in any way to which the parties agree, the most common arrangement would be to allocate the reimbursements according to each tenant’s pro-rata share of the total rentable square footage.

Let’s say now that instead of occupying the entire rentable area, the tenant we’ve been discussing takes up only 2,000 square feet and the remainder is rented to other businesses. The calculation of the base rent works just as it did before (area x rate = base rent), but the reimbursement involves an additional factor, the tenant’s pro rata share. Since the tenant occupies 2,000 of the 10,000 square feet total, its share is 20%

pro rata share x (property tax expense — expense stop)
= expense reimbursement

20% x ($12,000 — $4,000) = expense reimbursement

20% x $8,000 = $1,600 expense reimbursement

As before, we add that to the tenant’s base rent

2,000 square feet x $30 per sf = $60,000 base rent

to get a total of $61,600.

In this example, we have been passing through just one expense, but the landlord and tenant can agree to pass through as many or as few as they like. Property tax is probably the most common, and a lease that has just that single reimbursement is called a net lease. If the lease passes through both taxes and insurance, it is called a net-net lease. And if it adds tenant responsibility for repairs and maintenance into the deal, it is called a triple-net lease.

 


How it Works—The Practical Issues

All this is nice in theory, but how does it work in practice? Does the property owner let the tenant pay the bills?

building collapsingHardly ever. If you as a property owner pass property taxes or insurance cost–or any other expense for which you are responsible–on to a tenant, what you should do is pay those expenses directly yourself and send your tenant a bill for the reimbursable amount. A moment’s reflection will make the reason for this immediately obvious. Do you really want to rely on a third party to pay your tax or insurance bill on time? What if they don’t? You’re probably already picturing the nightmare scenario, where the insurance bill was left unpaid by the tenant, and then a catastrophic uninsured loss occurred. Or the tax bill was ignored, and you end up with a lien against your property and a black mark on your credit. If it’s your bill, pay it yourself and then collect from the tenant.

More…

Now that we’ve nailed down the basic mechanics of expense reimbursements, we want to go a bit further. There are some variations we should look at, like base-year reimbursements and CAM charges; there are some accounting and presentation issues worth considering; and there is the fundamental question as to why commercial landlords and tenants follow this pass-through practice at all. Come back for Part 2 to find out more.

—-Frank Gallinelli

 

six real estate investment courses

Unlock Your Real Estate Potential with Our Comprehensive, Expert-Led Video Courses.

Learn How to Analyze Properties, Forecast Cash Flows, and Make Data-Driven Investment Decisions. Enroll Now and Start Maximizing Your Returns!


flipbook format

####

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 2015-2023,  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 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.


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.

How to Look at Reserves for Replacement When You Invest in Income-Property

It may sound like a nit-picking detail: Where and how do you account for “reserves for replacement” when you try to value – and evaluate – a potential income-property investment? Isn’t this something your accountant sorts out when it’s time to do your tax return? Not really, and how you choose to handle it may have a meaningful impact on your investment decision-making process.


What are “Reserves for Replacement?”

Nothing lasts forever. While that observation may seem to be better suited to a discourse in philosophy, it also has practical application in regard to your property. Think HVAC system, roof, paving, elevator, etc. The question is simply when, not if, these and similar items will wear out.

A prudent investor may wish to put money away for the eventual rainy day (again, the roof comes to mind) when he or she will have to incur a significant capital expense. That investor may plan to move a certain amount of the property’s cash flow into a reserve account each year. Also, a lender may require the buyer of a property to fund a reserve account at the time of acquisition, particularly if there is an obvious need for capital improvements in the near future.

Such an account may go by a variety of names, the most common being “reserves for replacement,” “funded reserves,” or “capex (i.e., capital expenditures) reserves.”


Where do “Reserves for Replacement” Fit into Your Property Analysis?

This apparently simple concept gets tricky when we raise the question, “Where do we put these reserves in our property’s financial analysis?” More specifically, should these reserves be a part of the Net Operating Income calculation, or do they belong below the NOI line? Let’s take a look at examples of these two scenarios.

reserves for replacement, after NOI

Now let’s move the reserves above the NOI line.

reserves for replacement, befeore NOI

The math here is pretty basic. Clearly, the NOI is lower in the second case because we are subtracting an extra item. Notice that the cash flow stays the same because the reserves are above the cash flow line in both cases.


Which Approach is Correct?

There is, for want of a better term, a standard approach to the handling capital reserves, although it may not be the preferred choice in every situation.

That approach, which you will find in most real estate finance texts (including mine), in the CCIM courses on commercial real estate, and in our Real Estate Investment Analysis software, is to put the reserves below the NOI – in other words, not to treat reserves as having any effect on the Net Operating Income.

This makes sense, I believe, for a number of reasons. First, NOI by definition is equal to revenue minus operating expenses, and it would be a stretch to classify reserves as an operating expense. Operating expenses are costs incurred in the day-to-day operation of a property, costs such as property taxes, insurance, and maintenance. Reserves don’t fit that description, and in fact would not be treated as a deductible expense on your taxes.

Perhaps even more telling is the fact that we expect the money spent on an expense to leave our possession and be delivered to a third party who is providing some product or service. Funds placed in reserve are not money spent, but rather funds taken out of one pocket and put into another. It is still our money, unspent.


What Difference Does It Make?

Why do we care about the NOI at all? One reason is that it is common to apply a capitalization rate to the NOI in order to estimate the property’s value at a given point in time. The formula is familiar to most investors:

Value = Net Operating Income / Cap Rate

Let’s assume that we’re going to use a 7% market capitalization rate and apply it to the NOI. If reserves are below the NOI line, as in the first example above, then this is what we get:

Value = 55,000 / 0.07

Value = 785,712

Now let’s move the reserves above the NOI line, as in the second example.

Value = 45,000 / 0.07

Value = 642,855

With this presumably non-standard approach, we have a lower NOI, and when we capitalize it at the same 7% our estimate of value drops to $642,855. Changing how we account for these reserves has reduced our estimate of value by a significant amount, $142,857.


Is Correct Always Right?

I invite you now to go out and get an appraisal on a piece of commercial property. Examine it, and there is a very good chance you will find the property’s NOI has been reduced by a reserves-for-replacement allowance. Haven’t these people read my books?

The reality, of course, is that diminishing the NOI by an allowance for reserves is a more conservative approach to valuation. Given the financial meltdown of 2008 and its connection to real estate lending, it is not at all surprising that lenders and appraisers prefer an abundance of caution. Constraining the NOI not only has the potential to reduce valuation, but also makes it more difficult to satisfy a lender’s required Debt Coverage Ratio. Recall the formula:

Debt Coverage Ratio = Net Operating Income / Annual Debt Service

In the first case, with a NOI of $55,000, the DCR would equal 1.41. In the second, it would equal 1.15. If the lender required a DCR no less than 1.25 (a fairly common benchmark), the property would qualify in the first case, but not in the second.

It is worth keeping in mind that the estimate of value that is achieved by capitalizing the NOI depends, of course, on the cap rate that is used. Typically it is the so-called “market cap rate,” i.e., the rate at which similar properties in the same market have sold. It is essential to know the source of this cap rate data. Has it been based on NOIs that incorporate an allowance for reserves, or on the more standard approach, where the NOI is independent of reserves?

Obviously, there has to be consistency. If one chooses to reduce the NOI by the reserves, then one must use a market cap rate that is based on that same approach. If the source of market cap rate data is the community of brokers handling commercial transactions, then the odds are strong that the NOI used to build that market data did not incorporate reserves. It is likely that the brokers were trained to put reserves below the NOI line; in addition, they would have little incentive to look for ways to diminish the NOI and hence the estimate of market value.


The Bottom Line – One Investor’s Opinion

What I have described as the standard approach – where reserves are not a part of NOI – has stood for a very long time, and I would be loath to discard it. Doing so would seem to unravel the basic concept that Net Operating Income equals revenue net of operating expenses. It would also leave unanswered the question of what happens to the money placed in reserves. If it wasn’t spent then it still belongs to us, so how do we account for it?

At the same time, it would be foolish to ignore the reality that capital expenditures are likely to occur in the future, whether for improvements, replacement of equipment, or leasing costs.

For investors, perhaps the resolution is to recognize that, unlike an appraiser, we are not strictly concerned with nailing down a market valuation at a single point in time. Our interests extend beyond the closing and so perhaps we should broaden our field of vision. We should be more focused on the long term, the entire expected holding period of our investment – how will it perform, and does the price we pay justify the overall return we achieve?

Rather than a simple cap rate calculation, we may be better served by a Discounted Cash Flow analysis, where we can view that longer term, taking into account our financing costs, our funding of reserves, our utilization of those funds when needed, and the eventual recovery of unused reserves upon sale of the property.

In short, as investors, we may want not just to ask, “What is the market value today, based on capitalized NOI?” but rather, “What price makes sense in order to achieve the kind of return over time that we’re seeking?”

How do you treat reserves when you evaluate an income-property investment?

—-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.

Using Cap Rate to Estimate the Value of an Investment Property

In recent posts I’ve been revisiting some key real estate investment metrics. Last time I discussed the finer points of Net Operating Income, and that topic should serve as an appropriate run-up to the subject of capitalization rates (aka cap rates). What are they and how do you use them?

Income capitalization is the technique typically used by commercial appraisers, and is a part of the decision-making process for most real estate investors as well. I invite you to jog over to an article I’ve written on the subject:

Estimating the Value of a Real Estate Investment Using Cap Rate

In addition, you can download Chapter 10 of my book, Mastering Real Estate Investment, which discusses cap rates and gives you several examples you can work through.

—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.

Understanding Net Operating Income

My recent discussions here of cash flow, DCF, pro formas and the like have prompted some readers to ask for a review of the key metrics that underlie a good and thorough income-property analysis.

One of the downsides of hanging around in business too long — we’re closing in on our 33rd anniversary — is that some of our best material is now lurking off in the archives.  So, after digging around in our virtual attic, I’ve found several topics that go to the heart of the matter, and that attracted quite a few readers when they first appeared.

Topping that list is our article about Net Operating Income. Here is a trailer of sorts, with a link to the complete article:

Understanding Net Operating Income

In a recent article, we discussed the use of capitalization rates to estimate the value of a piece of income-producing real estate. Our discussion concerned the relationship among three variables: Capitalization Rate, Present Value and Net Operating Income.

We may have gotten a bit ahead of ourselves, since some of our readers were unclear on the precise meaning of Net Operating Income. NOI, as it is often called, is a concept that is critical to the understanding of investment real estate, so we are going to backtrack a bit and review that subject here.

Everyone in business or finance has encountered the term, “net income” and understands its general meaning, i.e., what is left over after expenses are deducted from revenue.

With regard to investment real estate, however, the term, “Net Operating Income” is a minor variation on this theme and has a very specific meaning. …

read the rest of the article here—>>

—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.

Start Evaluating Investment Properties Today

Get Free Demo