We’ve been hiding our bundles under a bushel! Find out more >>
REIA Quick Edition is a compact a very affordable quick analysis of any income-producing property.
We designed it so you can key in just a few key items and get a single-page report that can help you to decide whether you should pass or examine the property in create detail. It will calculate your NOI, Cash-on-Cash, Debt Coverage Ratio, IRR, potential resale price and more.
Get more info at https://www.realdata.com/products/reia-quick
If you’re not an all cash buyer, then when you purchase a piece of income-producing real estate you’ll probably need to secure mortgage financing to complete the deal. It’s essential for you to understand what your lender is looking at when underwriting that loan.
And — If you guessed that he or she is not admiring your millinery — ok then, stick with me here. I’m going to discuss briefly a couple of key yardsticks.
Of course, this short video blog post is just the tip of the iceberg when it comes to evaluating, financing, and acquiring a successful real estate investment.
For in-depth insight into on all the key metrics and methods, check out https://realestateeducation.net/
And you’ll find the software that will do all the heavy lifting for your analysis and presentation at https://realdata.com
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.
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. Click the image below.
If you missed Part 1, you can watch it here.
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.
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.
Now let’s move the reserves above the NOI line.
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
I had the pleasure of recording a podcast recently with real estate entrepreneur Kevin Bupp. We discussed what I feel are some of the key principles that every real estate investor ought to understand — and so, I invite you to listen to that podcast here.
One of our Facebook fans, Tony Margiotta, posed this question, which I’m happy to try my hand at answering here:
“Could you talk about refinancing an income property in order to purchase a second income property? I’m trying to understand the refinance process and how you can use it to your advantage in order to build a real estate portfolio. Thanks Frank!”
=============================================================
The Good News
Your plan – to extract some of the equity from an investment property you already own and use that cash as down payment to purchase another – is fundamentally sound. In fact, that’s exactly what I did when I started investing back in the ‘70s, so to me at least, it seems like a brilliant idea.
Of course, you need to have enough equity in your current property. How much is enough? That will depend on the Loan-to-Value Ratio required by your lender. The refi loan has to be small enough to satisfy the LTV required on the current property, but big enough to give you sufficient cash to use as the down payment on the new property.
For example, let’s say your bank will loan 70% of the value of your strip shopping center, which is appraised at $1 million. So, you expect to obtain a $700,000 mortgage. Your current loan is $550,000, which would leave you with $150,000 to use as a down payment on another property.
Given the same 70% LTV, $150,000 would be a sufficient down payment for a $500,000 property, i.e. 70% of $500,000 = $350,000 mortgage plus $150,000 cash.
But Wait… Some Issues and Considerations
Unfortunately, it’s not the ’70s or even ’07 anymore, so while the plan is sound, the execution may present a few challenges. Best to be prepared, so here are some issues to consider:
In a nutshell, refinancing an existing income property to purchase another is a time-honored and proven technique, but it in a challenging lending environment be certain you do your due diligence and run your numbers with care.
Of course I never miss an opportunity to promote my company’s software, so consider using that not only to analyze the deal and its variations, but also to build the presentations that will optimize your chances of obtaining the financing and/or the equity investors.
Frank Gallinelli
Since we released the original version of our Real Estate Investment Analysis software in 1982, our focus has been on pro forma financial analysis of real estate investments and of development properties – projecting the numbers out over time to help users gain a sense of what kind of investment performance they might expect from a particular property or project.
And for lo, these many years, our customers (and from time to time, we ourselves) have used the software to help make decisions as to whether or not to buy a property, and at what price and on what terms. Customers have used it to model how things might play out in the worst case, or in the best case, or somewhere in between. They have used it also to compare alternative investment opportunities.
This type of decision-making process has by far been the most common use of our software. More and more, however, we’ve seen an increased use of these pro formas for the purpose of making presentations to potential equity partners and to lenders.
Which brings us at last to the point of this article. When the economy is blazing away at warp speed, everything is – or at least seems – a bit easier. Forecasts are easier to meet, and partners and lenders are easier to find. But sometimes the economy is not so good, and presents us with new challenges. At this writing, we find ourselves in the middle of a bad case of credit lockjaw. Nothing lasts forever (which in this instance is a good thing), so eventually our credit markets and overall economy will rediscover their equilibrium.
This is all fine, unless you’re holding a property today with a mortgage that will balloon in the near future. In that case, you need to find a new loan, and you’re probably going to have to work for it. That means doing some homework, understanding the process, and building the most compelling case you can for approval of that new loan.
If you were trying to refinance your home, you would be dealing with recent sales of comparable houses, your personal income and debt, and your credit score. With the possible exception of working to get your credit report in order, there’s not a great deal you would do personally to build a case for your re-fi. With an income property, however, a carefully prepared presentation can go a long way in helping you convince a lender – or even a new equity partner – that you have a viable investment.
Re-enter your friend, the pro forma analysis. You may have thought he was on vacation until sales of real estate revived, but in fact he’s as busy as ever with financing and partnerships. If the numbers do indeed work for a property whose balloon is coming due – and sorry, don’t expect to transform a bad investment into a good one with just a pile of color charts – then a detailed pro forma may be that property’s best friend.
Don’t even think about starting that pro forma until you’ve done a bit of legwork and preparation. First you’re going to need some information that is external to the property itself. You need to know the prevailing market capitalization rate for properties of the same type as yours (i.e., office, retail, apartment, industrial, etc.) and in the same market. This information will be critical to estimating the current value of the property. Perhaps the best place to seek this information is from a local commercial appraiser. The bank will certainly use an appraiser, and the appraiser will certainly use a cap rate, so don’t get left out of the party. For the sake of the example we’re going to construct here, say that the commercial appraiser tells you the prevailing cap rate for properties like yours in your market is 11%.
Next you need to learn about underwriting criteria from your potential lenders. Specifically, you need to know the probable interest rate and term of the new loan; the lender’s maximum Loan-to-Value Ratio; and the lender’s minimum required Debt Coverage Ratio. Don’t assume that these criteria will be identical across all lenders or across all property types. In fact, they probably will not. It should not surprise you that different lenders quote different interest rates, but you must also recognize that the same lender may be willing to lend 80% of the value of an apartment complex, but only 65% of the value of a shopping center. Know the lender’s terms before you ask for the loan.
For the purpose of this example, let’s say you’ve called your current lender and found that their maximum Loan-to-Value Ratio for a property like yours is 75%. They require a Debt Coverage Ratio of at least 1.20, and if all looks good, they will loan at 7.75% for 15 years.
We’ll discuss these criteria in detail in a moment, but for now let’s stay focused on collecting information, this time about the property itself. You need to assemble the amount of actual current rent income from each unit and identify the market rent of currently vacant units. You need to make realistic estimates of rental income for the next several years, taking into account the terms of leases now in place. You must figure your current year’s operating expenses, keeping in mind that certain expenditures such as debt payments, capital improvements and commissions should not be included. Nor should you include depreciation or amortization of loan points, which are deductions but not operating expenses. Once again, you have to make some realistic estimates as to how these expenses may change over the next several years. Finally, of course, you have to learn the balance of your current mortgage, so you’ll know how much of a re-fi you require.
Let’s return now to the underwriting criteria you identified, and start with the Loan-to-Value Ratio (LTV):
| Loan-to-Value Ratio = Loan Amount / Lesser of Property’s Appraised Amount or Actual Selling Price |
If this is a re-fi, then there is no “selling price,” so the value here will be the amount for which the property is appraised. If your financial institution has not taken leave of its senses (in general, if it has not appeared in the headlines or before a Congressional subcommittee in the last six months), then it should be reluctant to loan you or anyone else 100% of the value of a property. They expect you to have some skin in the game, and the question is merely how much.
The lender will quote you their maximum LTV, and before you get anywhere near an application form, you are going to perform your own calculation with your particular property. How much of a loan do you need to replace the existing financing, and how does that relate to the current value of the property?
It should be clear enough that the lower your actual LTV, the more likely you are to secure the loan. The lower the LTV, the more you, the borrower have to lose and the less likely you are to walk away. A low LTV may even earn you more favorable terms. You know how much of a loan you need, so to determine the LTV of your proposed loan, you must estimate the value of the property. Find that value with the same method the lender’s appraiser is likely to use: by applying a capitalization rate to the Net Operating Income (NOI). You already called around to find the prevailing market cap rate, so now you need to calculate the NOI. The most direct way to do this is with the venerable APOD form, where you list your annual income and expenses:
The total of your scheduled rent income for this year should be $219,600, but because of vacancy and credit losses you will actually collect $210,816. Your various operating expenses total $51,050, leaving you a Net Operating Income of $159,766.
Remember that an appraiser told you the prevailing cap rate for this type of property in your market area is 11%. You have what you need to estimate the value of the property:
| Value = Net Operating Income / Capitalization Rate | |
| Value = 159,766 / 0.11 | |
| Value = 1,452,418 |
Round that off to $1.45 million.
You’re ready now to perform your first underwriting calculation. Recall that your lender’s maximum Loan-to-Value Ratio is 75%. Your current loan – the one that is about to balloon – has a balance of $975,000.
| Loan-to-Value Ratio = Loan Amount / Lesser of Property’s Appraised Amount or Actual Selling Price | |
| Loan-to-Value Ratio = 975,000 / 1,450,000 | |
| Loan-to-Value Ratio = 67.2% |
Assuming the lender’s appraiser agrees with your estimate of value, you’ve cleared your first hurdle. Being a cautious individual, however, you want to know your worst-case scenario. What is the lowest appraisal that would still allow your $975,000 re-fi to meet the lender’s LTV requirement? Simply transpose the formula to solve for a different variable:
| Property’s Appraised Amount = Loan Amount / Loan-to-Value Ratio | |
| Property’s Appraised Amount = 975,000 / 0.75 | |
| Property’s Appraised Amount = 1,300.000 |
Any appraisal over $1.3 million will be good enough to satisfy the 75% Loan-to-Value requirement.
You will want to build a pro forma that goes out a least five years, so you can demonstrate to the lender that your anticipated cash flow and debt coverage are solid and likely to stay that way. Before you do so, however, there is a formula you can use that will give you a quick estimate of the maximum loan amount that the property’s current income can support. Remember that the strength of an income property lies in the strength of its income stream. This is how the lender will look at your proposal, so it’s what you need to do as well. Here is the formula:
| Maximum Loan Amount = Net Operating Income / Minimum Debt Coverage Ratio / (Monthly Mortgage Constant x 12) |
You know that your Net Operating Income is $159,766, and the lender has told you the Minimum Debt Coverage Ratio is 1.20. But what’s this Monthly Mortgage Constant?
A mortgage constant is the periodic payment amount on a loan of $1 at a particular interest rate and term. If you know the constant for a loan of $1, you can multiply it by the actual number of dollars of the loan to find the payment amount.
Readers of my books have access to a web site with a variety of tools, including a table of mortgage constants. You can also calculate the Mortgage Constant using this formula in Microsoft Excel:
| =PMT(Periodic Rate, Number of Periods, -1) |
In the Excel formula, the amount of the loan must be entered as a negative number. In the case of a mortgage constant, we want to use a loan of $1, hence the -1. In the case of a loan at 7.75% for 15 years, the formula would look like this:
| =PMT(0.0775/12, 180, -1) = 0.00941276 |
Since this loan is going to be paid monthly, you express both the rate and the number of periods as monthly amount. Format your answer to display at least eight decimal places.
Now you have all the elements to plug into the formula for maximum loan amount: the Net Operating Income, the minimum Debt Coverage Ratio, and the Mortgage Constant.
| Maximum Loan Amount = Net Operating Income / Minimum Debt Coverage Ratio / (Monthly Mortgage Constant x 12) | |
| Maximum Loan Amount = 159,766 / 1.20/ (0.00941276 x 12) Maximum Loan Amount = 133,138.33 / (0.00941276 x 12) | |
| Maximum Loan Amount = 133,138.33 / 0.11295312 Maximum Loan Amount = 1,178,704 |
Keep in mind that rounding could alter your answer by a few dollars.
(An aside: If you’re the sort of person who does not like to play with long formulas, or who tends to tap calculator keys with a closed fist, we have a solution for you. The RealData Real Estate Calculator – Deluxe Edition, will do all of these underwriting calculations for you, as well as perform a host of other useful real estate functions, including amortization schedules for loans with a variety of terms. There are sixteen modules in the Calculator. Find more info at http://realdata.com/p/calculator.)
Your lender will surely round this result, probably down to something like $1.175 million. But you’re looking for just $975,000, so it appears that your income stream will support this loan request. You will want to verify this by calculating the property’s Debt Coverage Ratio going out five or more years. You’ll do that as part of your property pro forma, in the next installment of this article.
Up to this point, however, you’ve accomplished quite a bit: You learned what information you need to assemble about your lender’s underwriting process, about your property’s income, expenses and loan balance, and about the prevailing cap rate in your market. You’ve learned to use some of that information to estimate the current value of the property, then taken that result to determine if the property will likely satisfy the lender’s Loan-to-Value requirement.
You’ve learned about another underwriting metric, Debt Coverage Ratio, and about mortgage constants. You’ve seen how to combine those to test your property’s income stream to see if it’s strong enough to support your loan request.
Not bad for an hour or two of work.
Next time you’ll see how to assemble this information and more into the kind of professional presentation you can give to a potential lender or equity partner.