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

800-899-6060

New Program from RealData: “REIA Quick Edition”

 

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


The Cash-on-Cash Conundrum – a Postscript

A while back, I posted a two-part series called “The Cash-on-Cash Conundrum.” In the first installment I explained the calculation and underlying logic of CoC, and in the second I discussed some of the pitfalls of overreliance on this particular measure.

big pile of dollars

I try to keep my ear to the ground by reading and sometimes contributing to investor forums, where I continue to see a good deal of discussion on the question of what is or what should be the metric of choice for real estate investors. My unofficial and unscientific gauge of the general sentiment is that most investors agree that cash flow is king. Although I would be reluctant to crown any single measure as the absolute be-all and end-all for property analysis, I agree that cash flow is indeed a critical measure of the health of an investment property.

So what’s the big deal? What concerns me is that I see a kind of tunnel vision on this topic. I frequently hear some variation of these two statements bundled together: “Cash-on-cash return is the only reliable metric and the only one I really need,” and “IRR and Discounted Cash Flow analysis are bogus – they’re a waste of time because you just can’t predict the future.” To put it simply, these folks are saying that they trust CoC because it looks at the here and now, and they distrust IRR/DCF because it tries to look into the future.

On the surface, that argument might seem reasonable enough. Cash-on-Cash return is the property’s expected first-year cash flow before taxes, divided by the amount of cash invested to make the purchase; it’s quick and easy to calculate, and it does indeed focus on a more-or-less tangible present. A strong CoC unarguably provides a good sign that your investment is off on the right foot.

Is that the end of the story – or should it be? I think this narrow focus can cause an investor to miss some vital issues.

By adopting the “can’t predict the future” argument, aren’t you ignoring what investing is all about? You don’t have a crystal ball, but still — isn’t investing about the future, and isn’t the ability to make sensible choices in an uncertain environment a key trait of the successful investor?

I find it difficult to accept the argument that I should make a decision to buy or not to buy an investment property based on its first-year cash flow alone and without regard to projections of future performance. Ironically, there is a hidden message in this point of view: If the first year performance data is sufficient, then apparently I should believe that such data will be representative of how well the property will perform all the time. In other words, it really is OK to predict the future, so long as I believe the future will always be like the present.

I would argue that it is in fact less speculative to make the kind of projections that you typically see in a Discounted Cash Flow analysis, where you look at the anticipated cash flow over a period of time and use those projections to estimate an Internal Rate of Return over the entire holding period.

With any given property, there may be items that you can forecast with a reasonable degree of confidence. For example, on the revenue side you may have commercial leases that specify the rent for five years, ten, or even more. You may even be able to anticipate a potential loss of revenue at a point in the future when a commercial lease expires and you need to deal with rollover vacancy, tenant improvements, and leasing commissions.

You could be looking at a double- or triple-net property where you are insulated from many or most of the uncertainties about future operating expenses like taxes, insurance and maintenance.

Or, with residential property, you may have a history of occupancy percentage and rent increases that permit a credible forecast of future revenue.

Then there is the more basic question, why are you analyzing this property at all? Why are you running the numbers and making this CoC calculation? Are you trying to establish a current market value, as a commercial appraiser might? Or are you trying to make a more personal decision, i.e., will this particular property possibly meet your investment goals? And what are those goals?

Seems like I just took a nice simple metric and wove it into a more complicated story. Sorry, but in your heart of hearts you know if investing really were that simple, then everyone with a pulse would be a huge success. At the same time, it doesn’t have to be so complicated either, so long as you approach it in a reasonable and orderly way.

That orderly approach begins with deciding what you are looking to get out of this investment. Maybe you want to hold it for a few years to get strong cash flow and then sell it, hopefully for a profit. Perhaps you intend to hold it long term, less concerned with immediate cash flow (so long it as it positive), and then sell the property much later to fund your children’s college costs or your own retirement. In either case, if your plan is to buy and hold then there is one thing you can’t ignore: the future.

This approach continues with projection of the revenue, expenses, potential resale, and rate-of-return metrics, running out to your intended investment horizon. Perhaps key here is the realization that you shouldn’t really expect to nail your projections with a single try. Consider several variations upon future performance: best-case, worst-case and somewhere in-between scenarios to give yourself a sense of the range of possible outcomes.

All this brings us back to the duel between the Cash-on-Cash metric and DCF/IRR. I believe if you rely only on the former, then you are not just saying, “You can’t predict the future.” You’re saying, “If the first year looks good, then that’s all I need to know.” This is, quite literally, a short-sighted investment strategy. The takeaway here is that there should be no duel between metrics at all; that prudent investors can use Cash-on-Cash to get an initial reading of the property’s immediate performance, but they should then extend their analysis to encompass the entire lifecycle of the investment. To quote the folks at NASA (who, after all, really are rocket scientists), “It takes more than one kind of telescope to see the light.”

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

Podcast: “Learn the key principles to effectively analyzing and evaluating your real estate deals”

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.


The Cash-on-Cash Conundrum, Part 2

In the first part of our discussion, you looked at the simple math that underlies Cash-on-Cash Return. The short version goes like this:  First you calculate your property’s first-year cash flow before taxes—essentially all the cash that comes in from operating the property minus all the cash that goes out. Then you divide that by your initial cash investment, and that percentage is your Cash-on-Cash Return. Nothing could be simpler.

Simplicity is a good part of CoC’s appeal. Unfortunately, that is also part of its weakness. If you are using this metric to help you decide whether a potential income-property purchase is a promising investment or not, then you need to look carefully at the story—or stories—that may lurk behind these numbers. In keeping with our literary metaphor, let’s call them our subplots.

Subplot #1: A Point in Time

Clearly, when you take the first-year’s cash flow and divide it by the cash used to purchase, you are looking at a property’s performance essentially at a point in time, a single year. To be sure, the reliability of your cash flow projection is likely to be greatest in that one, immediate time frame. I often hear investors say that they are not comfortable trying to predict the future, that they would rather just look at what is happening now; and they are quite justified in saying that if the return looks grim or perhaps negative right out of the box, then they have no interest in looking further.

Understandable, but potentially shortsighted—literally. By looking at a single year, you are looking at what may be an improbable investment horizon.  Will you keep this property for just one year? If not, if you plan to hold on to it longer, then you’re not taking into account anything having to do with its possible future performance.  Do you believe each future year will be exactly like this year, or could reasonably anticipated changes in cash flow (such as schedule increases in commercial lease rents, or large expenditures for needed repairs) push the needle far to one end or the other?

Subplot #2: The Time Value of Money

“All right,” you say, “then I’ll estimate the Cash-on-Cash Return for each of the next several years.” That may look like a step in the right direction, and I talk to a lot of folks who insist on doing just that, but it won’t take into account the time value of money.  You’ll be looking at the face value (undiscounted) of expected future cash flows, and weighing them against the present value of your cash investment today. Go back to that original example, where you invested $100,000. If you predict a $20,000 cash flow ten years from now, does that really mean your investment is returning 20%?

To be fair, future-year Cash-on-Cash can impart some useful information. For example, if the metric is both positive and increasing, then you can infer that your cash flow is improving each year. The trend can help inform your decision, but the actual percentage return may not have a great deal of meaning.

Subplot #3: Smoke and Mirrors

You retreat and say, “OK, let’s go back to thinking about just the first year of operation. Surely the Cash-on-Cash should give me a good sense of initial performance.” Do you remember the old computer chestnut, “Garbage in, garbage out?” Your results are only as good as the assumptions and data that you put in the dispose-all, and perhaps things aren’t always (or ever) what they seem.

Consider:

You are looking at in income-and-expense statement (what we call an APOD in real estate investing—Annual Property Operating Data) provided by the seller of the property. The cash flow is based, in part, on operating expenses, one of which is Maintenance and Repairs. The figure in the example above is $6,000; you secure the owner’s tax return and confirm that this is indeed the figure he declared.

That is how much he actually spent, but the figure seems a bit low to you. Does it mean the owner performed as little maintenance as he could get away with and never fixed anything until it was absolutely necessary?  Perhaps the owner did this to prop up the property’s cash flow in anticipation of selling. Despite the fact that the expense disclosed is technically correct, you decide you shouldn’t use it as a forward-looking assumption. Instead, you will probably have to project spending more once you take ownership, resulting in a diminished cash flow and a lower Cash-on-Cash Return. In addition, the property may actually be worth less than you assumed, since it does not throw off as much net income as you were led to believe.

Now take a different point of view. Based on your experience, you think the maintenance and repair expenditure shown is surprisingly high. Could there be an explanation for that? Perhaps the owner used the past year to catch up on deferred maintenance so the property would look more presentable when he put it up for sale.  You might be tempted (but only in your most private thoughts) to test the impact of lower maintenance costs on your cash flow and CoC return.  Once again, the amount that was disclosed, although correct, may not be the amount that gives you the best estimate of future cash flow or Cash-on-Cash Return.

Subplot #4: The Forecast—Cloudy, with a Chance of Cash Flow

Finally, there is the larger issue of the structure of the cash flow statement itself. What you decide to include or exclude in your forecast of future cash flow will almost certainly be driven by your personal agenda in creating that cash flow statement.  Are you the seller of the property, looking to make its income stream appear as strong as possible? Are you the buyer, trying to make a realistic projection of how this property will really perform, and perhaps also conveying that stark realism back to the seller as part of your price negotiation?

In either case—as well as in any of several others, such as buyer looking for financing, general partner looking for equity investors, etc.—you might be putting a bit of a spin on the data, the better to support your point of view and the message you want to deliver.

If you’re the seller, then a bit of topspin seems like a good idea to you. In the example shown in Part 1 of this discussion, you might argue that, not only did you provide accurate and verifiable income and expense data, but that you were being exceptionally open and above-board by suggesting an allowance for vacancy and credit loss even though you experienced no such loss.  Group hug.

But if you’re the buyer, you might return this with some backspin. You thank the seller for being so forthright, but add that you believe the vacancy and credit loss allowance should be closer to 5%, not 3%. In addition, you point out that routine maintenance is great, but will not prevent big-ticket items from wearing out eventually. For example, the heating boiler is barely hanging on, and the flat roof has less than 10 years of life left in it. Hence you propose reconstructing the cash flow statement to reflect the higher vacancy allowance, as well as need for an immediate capital improvement and an ongoing set-aside of cash flow into a reserve account to deal with future replacements, such as the roof.

coc2-1

What previously was a robust 10.4% return now becomes an anemic 2.1%.

coc2-2

The seller objects that this isn’t entirely fair, since the boiler repair is a one-off event, and removing that cost would bring us up to 6.1%.

coc2-3

The seller’s argument cycles you right back to Subplot #1 about the hazards of relying on a rate-of-return metric that looks only at a point in time in what is probably going to be a long-term investment.

Is There a Bottom Line?

What should you conclude about Cash-on-Cash Return? Is it, as some contend, the only metric worth looking at?  Is it of no use at all? The best answer probably lies somewhere in between, that you need to recognize both CoC’s strengths and its limitations, and not rely on it as your sole investment decision-making tool.

On the plus side:

  • It is quick and easy to calculate.
  • It can give an immediate comparison to the return on other short-term investments.
  • It focuses on the most current performance of the property; the more recent the data, the more likely it is to be reliable.

Among the negatives:

  • It focuses on single point in time; you may be intending to buy and hold for an extended period, and the future performance of the property can differ greatly from the short term.
  • It does not take into account the time value of money; if you use it beyond the current period, you may be comparing a future, undiscounted cash flow to the amount invested today.
  • It is easy to manipulate the results; hence, a novice investor who relies on this metric alone can be misled by what a third party chooses to include or exclude from a property’s cash flow statement.

So are there some bottom-line recommendations here?  Of course.

Start off by trying to develop a CoC calculation in which you can have reasonable confidence.

To do so, remember that there is no substitute for due diligence. At the most basic level, you need to confirm whether the data you see on the cash flow statement for a particular property is reasonable and accurate. Then you need to go further and examine the physical property and the market to see if there are issues that may affect your confidence in those numbers. Is there any reason to doubt that the current revenue stream will continue as it is now? Is the demand for space in this market changing, for good or ill? Is there deferred maintenance that you will have to deal with? Based on what you find, you may have to reconstruct that cash flow statement.

Don’t just look at what is on the cash flow statement; look for what might be missing. A seller may not volunteer an allowance for vacancy or a need to fund a reserve account, but such items are going to be part of your reality as an owner.

So long as you approach it with sufficient care and due diligence, the Cash-on-Cash Return can give you a useful first look at how a property might perform; but before you commit your investment dollars, you need to do more.

If you plan to operate this property for several years, then you need to take the long view. You should identify your likely investment horizon, and then build a series of pro formas to forecast how the property might perform over time.

A series? Yes. Don’t try to nail your projections of future performance in one pass. Do a best-case, worst-case, and in-between forecast of future cash flows and ultimate resale of the property. Look at the ongoing Debt Coverage Ratio in each case. Examine the IRR or MIRR. Even compare this property to others you might be able to acquire.

Be thorough. Be wary of shortcuts. You’re buying a future income stream; do your homework and run your numbers so you can understand just what it is that you’re buying.  Your investment success depends on it.

read my postscript

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

The Cash-on-Cash Conundrum, Part 1

Life is too complicated; we have too many choices, too many options, too many channels on cable TV. It’s not surprising that sometimes we crave simple answers to complex questions.

I see that mindset very often in my interactions with real estate investors. They yearn to embrace the “50% rule” or the “2% rule” or some other shortcut that will help them cut to the chase and decide if a particular property is a good deal or not.

One metric that is relatively simple and historically very popular is the Cash-on-Cash Return (CoC). I encounter many real estate investors (more than a few of whom have a net worth significantly greater than that of this writer) who zero in on that metric like a heat-seeking missile whenever they consider buying a property.  What exactly is Cash-on-Cash Return? How do you calculate it? What are its strengths and weaknesses? Is it a good metric, and perhaps more important, is it good enough?

Cash-on-Cash Return may be one of the few bits of financial terminology whose name could almost serve as its definition. You’re expecting to get a cash return on your cash invested, i.e., to earn cash on your cash. If you express the return as a percentage of the amount invested, then you have the Cash-on-Cash metric.

Let’s see this with some actual numbers.  You are considering the purchase of a particular income property. For this discussion, the purchase price of the property is not the number you want to focus on. Rather, it’s the amount of your own money—the cash you actually put on the table—that you’ll be looking at. You need $100,000 to close the deal.

You’ve obtained information about the rental income, the operating expenses and the expense reimbursements paid by the tenants. To that information you’ve added your own allowance for vacancy and credit loss, as well as your expected annual debt service on the mortgage that you’ll need to complete the purchase. You put this all together into a cash flow statement that looks like this:

coc1-1

Now you do the cash-on-cash math:

coc1-2

So now you see your Cash-on-Cash Return is apparently 10.4%. What are you to make of this?

First, you recognize that this was a very quick and easy calculation to perform. You needed just the amount of your cash investment and some basic information about anticipated revenues and expenditures. No heavy lifting here.

Second, you observe that your cash-on-cash (and therefore your cash flow) is a positive number. That’s really important, because it means you don’t expect to reach into your own pocket to pay the bills. You have more coming in than going out.

Third, you recognize that this really quick calculation allows you to compare the first-year return on this investment to that of other short-term opportunities like CDs or T-Bills. You look at 10.4% and that strikes you as a fairly good rate of return.

In short, your initial take here is that this metric was really easy to calculate; that it told you that the property seemed likely to enjoy a positive cash flow in the first year; and that the rate of return on your cash investment appeared to be significantly better than you might get from a bank or a bond.

Are you satisfied that you can make an informed decision to buy or not to buy this property based on your calculations here? You shouldn’t be. Yes, you believe the rent and expense figures are accurate, and you did the math correctly, but are you confident that you’re seeing the complete picture? My continual mantra to my finance students is, “Look beyond the numbers, look for the story that’s behind what you see on the surface.”

It’s tempting to think that this calculation of cash-on-cash has given you an adequate perspective on how this investment will perform, but there is really a great deal more to look at and to think about here. That’s what we’ll do in the next installment.

(to be continued  part 2)

— 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 2013,  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