Welcome to the CoStar Group Second Quarter 2017 Earnings Conference Call. At this time, all participants are in a listen only mode. Later, we will conduct a question and answer session. Instructions will be given at that time. As a reminder, this conference is being recorded.
I would now like to turn the conference over to your host, Richard Simonelli. Please go ahead.
Thanks, operator. It's wonderful to be here. Welcome to CoStar Group's Q2 2017 earnings call. We hope you enjoy the call. Before I turn the mic over to Andy Florence, CoStar's CEO and Founder and Scott Wheeler, our CFO, I have some very interesting and important items for you to consider.
Certain portions of our discussion today may contain forward looking statements, which involve many risks and uncertainties that could cause actual results to differ materially from such statements. Important factors that could cause actual results to differ, but are not limited to, those stated in our July 20 6, 2017 press release, on our 2nd quarter results and in CoStar's filings with the SEC, including our most recent annual report on Form 10 ks and Quarterly Report on Form 10 Q under the heading Risk Factors. All forward looking statements are based on information available to CoStar on the date of this call and CoStar assumes no obligation to update these statements whether as a result of new information, future events or otherwise. Reconciliations of the most directly comparable GAAP measure to all of the non GAAP financial measures discussed on this call, including but not limited to non GAAP net income, EBITDA, adjusted EBITDA and forward looking non GAAP guidance are shown in detail in our press release issued yesterday, which is also available on our website located at costar group.com. As a reminder, today's conference call is also being broadcast live and in color on our website, where you can also find CoStar's Investor Relations page.
Please refer to yesterday's press release on how to access the replay of this call. Remember, one question, make it a good one, and you can always requeue if we have time at the end. I'll now turn
the call over to Andy Florence. Andy? Thank you, Rich. Thank you for joining us today on our Q2 earnings call. We achieved an excellent first half of 2017 as our investments into the business along with tremendous execution on all levels by the CoStar team resulted in remarkable increases in sales and revenue growth.
We have excellent momentum heading into the second half of this year. We delivered strong performances across the board as revenue in the Q2 of 2017 accelerated to $237,000,000 which is an increase of 15% year over year. The 2nd quarter in a row, we generated our best sales quarter in our history. Company wide net bookings were $37,000,000 a 39% increase compared to the Q2 of 2016. CoStar Suite sales bookings were the strongest they've ever been with a 23% year over year increase.
Overall, CoStar Suite turned in solid revenue during Q2 with a growth rate of 13% year over year. Revenue growth in commercial property and land rose 17% year over year. Multifamily revenue was up 24% over the Q2 of last year. We are particularly pleased with that strong growth in the second quarter with mid-twenty percent growth rate of Apartments.com. Apartment.com sales climbed for the 3rd consecutive quarter as we reached our 2nd best multifamily sales quarter.
We continue to reap the rewards of our investments in our advertising campaign and strong presence at last month's National Apartment Association Conference in Atlanta. We once again set company records for both booth visits, leads captured, demos delivered and client appointments. More importantly, 1,000,000 of dollars of net new sales came from this important annual event. We had an excellent quarter in commercial property and land as the sales team turned in its 2nd best quarter of sales. We had robust sales of LoopNet premium lister, tiered advertising sales to owners and excellent sales numbers from our land and business for sale teams.
We've had a strong start to 2017 in sales as we've achieved $71,000,000 of net bookings in the first half of the year, up 26% from the same year to date period in the year prior. We are clearly benefiting from the impact of our investment into our larger sales organization, which increased in size by 40% compared to the beginning of last year. The sales management team, very well led by Max Leamington, is experienced and in place and helping its largest sales force to mature. We believe that maximum productivity levels are still ahead of us and that we have a huge runway of more than 100,000 clients to sell to. Forbes recently recognized our strong performance in growing revenue by naming CoStar Group to the Forbes Fast Tech 25 list.
The list recognizes technology companies with the highest 3 year sales averages. The 2017 list has CoStar placed at number 16 with 29% average sales growth for the past 3 years. Salespeople sell best when they have excellent services to sell. We continue to deliver new services, tools and top flight marketing websites. This includes services like CoStar Analytics, lease analysis and tools like the mobile app for iPhone and our iPad mobile app CoStar Go.
Great new marketplace sites like apartamentos.com and tiered advertising on loopnet.com are also having a positive impact. We continue to look for ways to innovate and build upon our tremendous platform. As we've spoken about on our previous earning calls, we're in the process of completing an overall CoStar Suite user interface. This will include a groundbreaking new listing manager tool that will allow our clients to for both CoStar and LoopNet from one simple to use interface. We believe this will result in faster real time data updates and overall better data quality.
This will free up our researchers' time to focus on other valuable commercial real estate research subjects ultimately delivering even more value to our subscribers. Innovation drives growth. We are dedicated to driving the technology revolution of commercial real estate that we began in the 1990s. And more recently, the multifamily by delivering world class services and solutions for our clients and the more than 37,000,000 unique visitors that came to our family of websites last month. As a proof point, I'm very pleased that in 2017, for the 4th year in a row, CoStar has been named to the Forbes World's Most Innovative Growth Companies list.
Our marketing efforts in multifamily have raised consumer awareness and driven huge numbers of unique visits and total visits. Once again, we remain the clear number one apartment Internet listing service based on a combination of traffic, SEM traffic, SEO, total advertised communities, leads delivered, brand recognition, leases signed and revenue. Our aggressive and effective advertising campaign continues. Our new consumer advertising campaign hit its peak media weight in the second quarter of 2017. We launched a total of 10 new spots and have already run 8,400 commercials this year, reaching 90% of U.
S. Households and delivering 1,000,000,000 impressions. Our goal is to reach renters at home, on the go, on mobile devices, on their computers and through social media. We also ran significant ad campaigns for partamentos.com and Westside Rentals this year. Overall, our multifamily advertising campaign has been a major success and is leading to breakaway results.
According to Hitwise, in June 2017 when compared to ApartmentGuide, Rent.com and ForRent, the Apartments dot com network was number 1 in visits in 96% of the top 210 U. S. Local markets. This includes number 1 in markets such as New York, Los Angeles, Chicago, Philadelphia, Houston, San Francisco and Washington D. C.
According to Comscore, Apartments dotcom has been number 1 in visits for 28 months and number 1 in unique visitors for 2 years. In the Q2 of 2017, visits and unique visitor traffic reached all time high for apartments as we continue to expand our lead over the competition. Adding to that success, we're pulling away from the competition according to Comscore. Apartments.comuniquevisitors increased in each month in the Q2 of 2017 and for June are up 32% year over year. ApartmentGuide and rent.comuniquevisitors declined in each month in the second quarter and are down 12% 17% 7% respectively year over year in June.
We now have 25% more unique visitors in Apartment Guide and 185% more unique visitors in rent dotcom. In visits, our advantage is even more pronounced as our network averaged 42,000,000 visits per month in the second quarter. In June, Apartments.com had 22,000,000 more visits in ApartmentGuide and 24,000,000 more visits than rent.com. Apartments.comvisits were up 29% year over year in June, while Apartment Guide was down an astonishing 37% and rent.com visits were down 11% for the same period. Interestingly, forrent.
Com has moved ahead of both Apartments Guide and Rent.com and visits in June of 2017. ForRent's progress is impressive. Clearly, our investments in the multifamily space over the past two and a half years have transformed Apartments dotcom into a very strong business with fantastic traffic and consumer engagement, but even more impressive for our paying clients is our ability to drive quality leads that result in signed leases. That's what property managers are ultimately paying for. For June, our leads on apartments.com are up 49% year over year.
On-site and Lease Hawk are 2 third party providers that provide information on leads in the apartment industry. They looked at 3 point 7,000,000 leads in the 1st 6 months of 2017. LeaseHawk found that Apartments dotcom generated more leads than our top 3 competitors combined. In that same period, On-site showed Apartments dotcom generated not only more leads, but more importantly, more leases than our top 3 competitors combined. Also, on-site show that Apartments.com is the most efficient lead source.
Their data showed that it took Apartment Guide 17 leads on average to generate one lease. It took 4 rents 16 lease to generate one lease. It took Zillow 15 lease to generate one lease. But Apartments was by far the winner requiring only 9 lease to generate one lease. Since Apartments.com needs about half as many leads to result in a lease compared to RentPath and ForRent, it follows that our clients can save a lot of time, money and hassle by using Apartments.com.
So we're delivering more leases and in a lower cost leasing process. During the first half of twenty seventeen, we delivered twice as many leases as ApartmentGuide, 5 times more leases than for rent and 5 times more leases than Zillow. Apartments.com has taken a completely different approach than our competitors have. We focus on generating informed inquiries from legitimately interested potential renters, while other companies frankly design their software to generate the most leads possible as their primary scorecard. As a result of this lead spam mentality of our competitors, many apartment leasing offices have to wade through and process thousands of unnecessary unqualified useless leads.
That cost them both real money and significant opportunity costs. Our secret shoppers contact apartment leasing offices millions of times each year. The typical apartment community we call only answers its leasing office phone about 30% of the time. The largest property management companies don't do much better only answering the phone about 40% of the time. Obviously, they're a little overwhelmed and they're missing many potentially highly qualified renters when they do not answer the phone.
In addition, they're creating a negative customer experience, which I think prevents them from building a positive brand image. I think the spend mentality of many of our competitors is directly responsible for this problem. Our clients are beginning to give us credit for driving the most efficient leasing process. We think that over the course of the next few years, we can make the apartment leasing process even more efficient for both the renters and the landlords. Renters have reported that the apartment hunting process is stressful.
Is that once they give notice to move out of their existing apartment, they must find a new apartment quickly and if their credit is not perfect or their income is not high enough, there's no guarantee that they will qualify for their next apartment. 2 things happen to renters who are rejected at 1 or more apartments they apply to. First, they typically lose more than $50 in valuable time at each community they unsuccessfully applied to, depleting their limited financial resources when they would need them most. Secondly, when they're rejected, they tend to panic a little bit and dramatically accelerate the number of inquiries they put out there. This means that poorly qualified renters tend to generate many more leads than do highly qualified renters.
This frustrates leasing offices and drives their costs up. Neither renter nor landlord likes this situation. It does not have to work this way. We intend to create a free premium renter service so that renters can confidentially establish their renter qualifications with Apartments.com at the beginning of their apartment search. We will collect their income and debt information, run a simple credit eviction criminal screen on them.
Apartment leasing offices could confidentially enter their qualification standards into Apartments.com. When renters search, they can see exactly which communities they prequalify for as they search. It will no longer cost them $50 each time just to learn they don't qualify. They would have the confidence and ability to find the apartments they're qualified for easily and quickly. When the leasing office receives leads from premium renters, they will see immediately that a renter is prequalified and has a very high chance of successfully completing their the leasing agent's limited time is best spent focusing on these higher probability leads.
A number of our clients have indicated they would extend special offers to these highly qualified and low risk renters to bring them to their communities, making our premium membership even more valuable to our highly qualified renters. If more highly qualified renters are drawn to Apartments dotcom, then we could offer our advertisers an even greater flow of highly qualified renters. Renters that failed to pre qualify are still able to apply to a community even if they initially failed to get a positive indication on Apartments.com. In the home mortgage world, mortgages are often price adjusted for risk. This is not yet happening in the apartment world, but could and perhaps should.
There could be an opportunity for us here in this area as well. To help facilitate these goals, earlier this month, we acquired a California based company called the Screening Pros. They have over 25 years of applicant screening experience and we believe that they're an excellent fit for Apartments dotcom. They have been developing a prescreen tool for some time, which we plan to enhance and incorporate into Apartments.com. Their process does a soft credit inquiry on the applicants, which does not affect the applicant's credit rating like a harder inquiry does at the time of application.
Data points such as does the applicant own a sorry, does the applicant owe a previous landlord money? Do they have past unpaid utilities? Do they have an eviction filing? Or has a judgment been rendered and can the applicant afford the rent? All are taken into consideration.
For property managers and landlords, this could make listing their apartments on Apartments dot com even more viable and allow us to win over even more apartment communities to Apartments.com. Investments in sales, technology and marketing have played an enormous role in driving top line success in CoStar, but frankly, it all begins with research. We're a research operation at our core. Our highest value proposition is the high quality and comprehensive commercial real estate information we curate. The CoStar research team collects, investigates and analyzes the in-depth market data necessary to help clients and consumers make the best decisions and drive connections between millions of properties and the hundreds of thousands of companies that need those properties to grow their In 2016, 83% of all commercial real estate transactions involved a CoStar Group user.
We believe that today CoStar prevents listings with potential deal value of about $1,500,000,000,000 As of June of 2017, our researchers and technology resources were presenting about 1,000,000 available apartment rentals, making apartments.com the most comprehensive marketing site for millions of consumers looking to find apartment. Last year, an estimated 4,000,000 people found their homes on Apartments dotcom. Back in October of 2016, we announced our intention to build a new global research center in Richmond, Virginia to support our core commercial real estate research operations. I'm really amazed at how well our team has cycled up a major and very productive research center in such a very short period of time. With 600 researchers and software developers in the Richmond Center, it's now by far our largest center.
Already, the Richmond Center is responsible for 60% of our U. S. Research activity. This time last year, we were still only visiting cities to determine where to locate our new research center. So this has gone really quickly.
Through our Richmond Center, we have proactively improved the way we do research. We're building new software tools to streamline the research process. We're better branding the company through our substantial communications with the commercial real estate community. We've rebuilt our processes to better equip our researchers to do the best job they can. We've launched a new 233 person tenant research team in the Richmond Center to enhance and improve the highly valued tenant information we provide in CoStar.
Productivity has grown in all of our research centers across the U. S. As our team of over 600 professionals in Richmond are pushing the bar even higher for excellence in research. The increased amount of information we're collecting by consistently making more frequent contacts with the commercial real estate professionals is having a huge positive impact on data quality. Last month, we achieved a major milestone research when we successfully phone interviewed representatives of 80% of the active commercial real estate players in North America and the United Kingdom during the course of just 1 month.
This is a huge accomplishment we've aspired to but have never before achieved. I want to congratulate our Vice President of Research Lisa Ruggles and the entire research team on achieving this milestone on behalf of our 100 of thousands of clients. There is no doubt in my mind that our investment in stronger research has been a significant factor in our sales booking growth in the first half of twenty seventeen. I want to give you a quick update on LoopNet and CoStar conversion. We're on track to integrate CoStar and LoopNet databases early this fall.
As an organization, after many months of hard work and preparation, we're ready to move ahead. Our data has never been better. Our software teams have integrated the LoopNet and CoStar databases into 1 unified database in the back end. We haven't deployed it yet, but the work is largely done. We've launched a B2B advertising campaign, clearly branding CoStar and LoopNet and differentiating the brands.
We expect to begin notifying some customers in September of the upcoming integration. We believe this will generate meetings and sales in the fall, but the Q4 is expected to be the 1st full quarter of sales resulting from this effort. I'm just back from visiting our offices in Spain, Germany and Scotland and England and I want to update you on what we have going on in Spain right now. We launched a completely new public commercial real estate website for Madrid in June at belbex.com. Check it out.
Belbex will be similar to loopnet.com. Belbex is a listing site that lets brokers and owners end users. It's free to list and search as we look to expand content and build traffic. We plan to initiate advertising opportunities on the site later in the year similar to those that you find on apartments.com. BelvEx continues to offer their legacy robust information solution on a subscription basis.
Once we've collected more content, we expect to launch CoStar in Spain, probably in about a year or so. We've invested this year in building up our research strength in Madrid. We quadrupled the size of the research team there and launched a major field research effort. We inspected tens of thousands of properties and discovered tens of 1,000 of new listings we've not known about. We have nearly tripled the number of listings we present there from the beginning of the year to now.
We anticipate double the number of active listings again within the year. We believe that we will be able to offer by far the most comprehensive commercial real estate marketplace ever offered in Spain. The commercial real estate markets remain healthy with occupancy rates at or near business cycle highs across the apartment, office, industrial and retail property types. That said, as new construction deliveries have ramped up, occupancies have softened a bit in many areas. As job growth is healthy, the market can easily withstand this new construction and indeed these construction jobs are part of why the economy is healthy today.
As this new supply hits the market, rent growth for the apartment office sectors has also slowed from cycle peaks, especially in segments exposed to new construction. At the same time, recent strong job growth bodes well for commercial leasing as a household formation that drives the apartment sector. These factors rising supply and steady job growth create a good situation for CoStar since we're an integral part of the leasing and marketing program for building owners and managers. In the office sector, vacancy rates were essentially stable at 10.3%, that's up slightly from 10.2% in the prior quarter, but down from 10.4% a year ago. So it's flat.
Completions are now outpacing the absorption for the first time since 2010. So vacancy rates are expected to inch up a touch in the near term, but still be in a healthy territory. Recent activity is in line with our expectations with net office absorption totaling 25,000,000 square feet over the past 2 quarters compared to 37,000,000 square feet of completions. Similarly, rent growth in the office sector has softened to 1.8 percent compared to 4.4 percent a year earlier, but basically in line with inflation. As we reported in prior quarters, the apartments market is normalizing and that means slightly softer occupancy rates.
Effective rent growth has dropped to 2.4% from 3.7 percent a year earlier and lease up on new construction slowing a bit. That stems partly from the 220 1,000 new units delivered over the past 12 months. That's a bit more than 187,000 units of net absorption. This rush of deliveries has pushed vacancy up to 5.9%, which is still right in line with historical averages. Since apartment advertising spending is highly correlated with weaker apartment markets, a more competitive apartment market with a lot of construction is actually good news for Apartments.comadsales.
Investment sales activity declined slightly in the first half of 2017, a trend that started in 2016 and annual real estate trading volumes fell about 10% from a year earlier. Investment sales are running at about 10% above historical averages though of the past 10 years. I have to say we've had an excellent first half of twenty seventeen in all aspects of our business. Our sales success that we're able to report to you today is driven by the fact that all of our core elements of our business are performing at full speed and we're really happy with the progress we're making. At this call at this point, I'm going to turn the call over to our Chief Financial Officer, Mr.
Scott Wheeler.
Thank you, Andy. You're welcome. Certainly had a strong first quarter. Thanks for those highlights. Great to see the benefit of our investments showing up really in a big way in our results this quarter.
So as Andy mentioned, the revenue in the Q2 of 2017 the acquisitions of Westside Rentals and LandWatch, both of which closed earlier this year and the Thomas Daly acquisition, which we completed in the mid second quarter of 20 16. The 2nd quarter organic revenue growth increased from 13% in the first quarter, reflecting continued strong momentum in sales, particularly in our online marketplace businesses. Looking at our revenue performances by services, CoStar Suite revenue growth was 13% in the Q2 of 2017 versus Q2 of 2016. Because of our strong sales performance, we expect CoStar Suite growth rates to continue at 13% through 2017, which is at the upper end of the 12% to 13% range we previously discussed. Revenue growth rates in information services remain negative in the Q2 of 2017 as expected.
So we continue to wind down the LoopNet information products ahead of the planned integration with CoStar Suite. The revenue decline from the LoopNet information products in the 2nd quarter was moderated a bit by strong double digit growth in our other information services areas, which includes portfolio strategies, real estate manager and our Thomas Daly operations in Europe. We've no change to our expectations that information services revenue will that information services revenue will decline at low
double digit rates in the
second half of the year. This will leave us with expected full year revenue in information services declining around 8% to 11% for the year. We had a very strong second quarter in multifamily as revenue increased 24% year over year and 22% on an organic basis, adjusting for the acquisition of Westside Rentals in January. Approximately 3 quarters of the organic revenue growth is driven by the addition of new paying properties, while the remaining 25% of the growth is a result of existing customers selecting more valuable advertising packages. Revenue contribution from Westside Rentals of approximately $1,000,000 in the quarter was not particularly material as expected.
We continue to expect this will wind down as we complete the transition of Westside Rentals to the Apartments dotcom advertising model. Based on continued strong sales performance, we expect our full year 2017 growth for multifamily revenue to be at the top end of the 21% to 23% range we communicated previously. Rounding out our services performance, commercial property and land grew 17% year over year in the 2nd quarter. Organic revenue growth adjusting for approximately $1,000,000 in revenue from our recent LandWatch acquisition was 15% in the 2nd quarter and continues to accelerate above the 11% revenue growth we reported 2016. This improved growth rate is the result of our increased focus on selling LoopNet premium lister and tiered advertising to property owners.
We expect this organic growth trajectory in the business to improve to a range of 13% to 16% for the full year of 2017, an increase from our previous guidance range of 12% to 14%. When we include the revenue from the acquisition of LandWatch, we expect commercial property and land services to grow in a range of 16% to 19%, which is an improvement from the 15% to 18 we discussed last quarter. On to gross margins, we came in at 77% in the Q2, so consistent with the Q1 of 2017. We expect gross margins to remain at approximately this level for the rest of the year. The vast majority of our cost of revenues relates to our research operation And as Andy mentioned, we're very pleased with the productivity improvements we've seen from our investment in the new research center in Richmond, Virginia.
The center now houses more than 600 employees and is ahead of schedule with regards to this year's resourcing plan. Operating expenses for the 2nd quarter of $154,000,000 were favorable to our forecast, primarily due to the timing of our marketing spend and other investment initiatives. We expect this to reverse in the 3rd and 4th quarters. Accordingly, adjusted EBITDA of $54,000,000 in the second quarter exceeded our guidance range by $11,000,000 and was only $2,000,000 lower than the Q2 of 2016. Adjusted EBITDA margin was 23% in the quarter, approximately 5% above the high end of our previous guidance range.
Net income for the quarter ended June 30th was $22,000,000 ahead of both expectations and prior year, aided by a reduction in our effective tax rate from 40% in the Q2 of 2016 to only 14% in the current quarter. This change in the effective tax rate is a result of adopting the new accounting guidance for share based payment transactions, which we implemented at the beginning of the year. Under this new guidance, the tax benefits related to stock price appreciation on share based payments are now recognized in income tax expense rather than as an adjustment to stockholders' equity on the balance sheet. This new accounting guidance is expected to result in increased volatility in our GAAP income tax rates from quarter to quarter. Cash investment balances were approximately 575,000,000 as of June 30, 17, which is down slightly from a balance of $582,000,000 after the Q1.
The reduction in the cash and investment balance is a result of the acquisition of LandWatch and timing of income tax payments. Beginning this quarter, you'll notice we included a cash flow statement in our press release for the first time ever in response to requests from our investors. Now let's take a look at some performance metrics for the quarter. As Andy mentioned, our sales force, which totals approximately 715 sales reps, delivered an all time high of $37,000,000 in net bookings in the Q2 of 2017, despite continued negative net new bookings from information services, certainly a high point for the quarter. We saw strong sales performance across all three of our growing revenue sectors.
We're making great progress towards our planned integration and cross selling efforts of CoStar to LoopNet users, which we expect to commence before we talk again in the fall. Consistent with the guidance we provided previously, the cross selling of LoopNet users to CoStar is not expected to have a material impact on our 2017 sales and revenue results. The renewal rates on annual contracts was 90.6% in the Q2 of 2017, up very slightly from the 90.5% achieved in the Q2 2016 and 30 basis points above the renewal rate we achieved in the Q1 of this year. The sequential increases the renewal rate is a result of improvements in our multifamily business. The renewal rates for CoStar Suite remains strong and in line with recent quarters.
The renewal rate for customers who've been subscribers for 5 years or longer was 97.1%. Subscription revenue on annual contracts accounts for 78% of our revenue in the quarter, up from 77% this time last year. I'll now talk through our outlook for the full year and the Q3 of 2017. Based on the strong sales and revenue performance in the second quarter, we are raising our top line outlook by $7,000,000 at the midpoint. We now expect revenue in the range of approximately 954,000,000 dollars to $960,000,000 for the year, representing an increase in the expected growth rate to 14% to 15%, up from a range of 13% to 14 percent communicated previously.
We expect revenue for the Q3 of 2017 in the range of $243,000,000 to 245,000,000 dollars representing top line year over year growth of around 15% at the midpoint. LandWatch is expected to contribute approximately $2,000,000 in revenue in each of the third and the 4th quarters of this year. In terms of earnings, we're raising our guidance range for the full year 2017 to approximately $4.42 to $4.52 per non GAAP net income per diluted share based on 32,700,000 shares. This includes an increase of 0.12 dollars per share related to the strong projected organic revenue results, substantially all of which is expected to convert to earnings. As I mentioned earlier, our 2nd quarter EBITDA results were favorable to our published guidance ranges, partially a result of the timing of expenses for marketing and various investment initiatives.
We still expect our full year 2017 investments to remain at the levels consistent with our prior outlook, although the quarterly timing has shifted somewhat. For the Q3 of 2017, we expect non GAAP net income per share in a range of $1.09 to $1.15 and adjusted EBITDA in a range of $67,000,000 to $70,000,000 Margins are expected to increase sequentially through the 3rd and the 4th quarters. Costs associated with the Exeligent litigation were approximately 3,000,000 in the Q2 and we continue to expect costs in a range of $10,000,000 to $20,000,000 for the year. Our guidance range for this litigation has not changed from what we communicated previously and includes $15,000,000 in legal costs for the year and $5,000,000 in the Q3 related to this matter. Overall, I'm very pleased with our sales performance and the success of our investment programs in the Q2 2017, and we remain on track to reach our stated goal of achieving a 40% adjusted EBITDA margin exiting 2018.
With that, we will now open the call
Your first question comes from the line of Brett Huff from Stephens. Please go ahead.
Good morning, guys. Congrats on a nice quarter. My question is on Spain. This sounds like the first sort of major ramping up of investment following,
I think you guys did
a small inorganic deal and are kind of throwing some effort behind that. It seems like it is both a LoopNet like expansion as well as a curated research type expansion. Can you kind of walk us through if that's true and if this is going to be a model, if Madrid is going to be a model for other cities across Europe and give us a tenor for that kind of investment?
Sure. So from your perspective in terms of any impact in the next 2 to 3 years, I think the impact is de minimis on our EBITDA expansion. So it might involve the addition of 20, 25 staff something like that for Madrid. But what we're doing is it's a robust and significant market. There's in our mind no material competition.
There's a huge opportunity. It's a $1,000,000,000,000 economy and the market needs information on what's happening in commercial real estate. The brokerage firms there don't have as big a presence as they do in other countries. I mean they're there, but they're not as prevalent, don't have the same market penetration. So what we've seen is that the owners there are bigger drivers of what's happening in the market and that's true in Germany as well.
So we think there's a lot of potential to sell advertising to owners who take real pride in their properties and are more motivated to spend marketing dollars to try to bring in tenants. We will we think it's also less expensive from a sales and marketing perspective. If we start with just generating a marketplace, generate a lot of eyeballs that drives content. And then as we watch the content grow and the vibrancy of the marketplace grow over the course of a couple of years, We'll build up analytic histories that are quite valuable and we'll build up those research relationships and then we'll migrate into a CoStar platform. So it's something that we'll we're going to watch it here in Spain.
And if it goes where we want it to, we'll use that model in other markets. I think it makes sense. And I think in the first 3 months or 4 months, 3 months of BelvEx, we got a quarter 1,000,000 visits to the site. So actually, it's working well. We're getting some good traffic there.
So and I also believe we're now the number one information source for we have the best information for Madrid and that will be worth something at some point.
Your next question comes from the line of Bill Warmington from Wells Fargo. Please go ahead.
Good morning, everyone.
Good morning, Bill. Hi, Bill.
So with one question, I was really trying to decide whether to ask about revenue or the safe harbor statement. So I think I'm going to go with revenue.
Well, thank you for asking about
our Safe Harbor statement, Christopher.
As you noticed, the Beatles references, Bill.
Well, the so I wanted to ask my question about the conversion upsell and how that's going to work, meaning that of the 7 15 sales reps, how many of those are actually going to be working on the leads? How many leads are they going to get each month? What kind of close rates should we think about? And how long does it take for the bookings to basically flow through?
So I
would I'll give you some general guidelines plus or minus. But the it will really be the focus of the CoStar field sales team, the customer relationship managers and the inside CoStar sales team. So that is roughly a little more than half of the sales force, 3 50, 375 something like that. And initially, we will not give them the better leads. We will target some of the unfortunately, one of the I won't name the company, but one of the best prospects I was the most excited about converting signed up last month.
And so I didn't even get to move them through the wringer. But we're not going to give them the best. I mean, I'm actually very excited about it, but it was supposed to happen during the integration process. But the we're going to initially give the salespeople about 10 leads per month per rep, 10 leads per rep. And then we'll gauge how effectively they work those.
The leads are these leads are pretty valuable and we want to give them time to work them properly. There's no rush, nothing about these 2 months versus those 6 months or this year. We want to do it properly, want to handle our communications with them well, answer their questions, move them to the process at the right pace. But right now, it feels like about $10 per month per rep and then we might pick that up a little bit. We will again start with the intermediate priority ones and then we'll later in the year we'll ramp up to the higher priority ones and into 2018, we'll approach the higher priority ones.
Was there another component of that question? Bookings effect. Bookings effect, yes. So probably more material in the Q4, 1st, 2nd, Q3 of next year.
And we haven't assumed a significant amount of bookings in this year, Bill, in our outlooks.
Your next question comes from the line of Brandon Dobell from William Blair. Please go ahead.
Thanks guys. As we think about the progression of net new through the balance of the year, maybe some color around the puts and takes versus last year as well as how some of these there's a lot of efforts going on here in a lot of different products, how those are going to flow through into it, the balance of this year? Thanks.
Yes. So when you look at the strength we've seen in the Q2, obviously, we've had a great quarter in CoStar, multifamily strong and commercial property and land is very strong as well. We expect those trends to continue into the second half of the year. We'll have a seasonality that will decline a little bit in multifamily as the rental typical every other year. When you talk about the LoopNet CoStar integration, as that thing starts to come on board, we should see more bookings move into the CoStar Suite sector of the business and decline faster in the info services component.
But that's it will be a net wash over time as those come along. And then really in commercial property and land, like I mentioned, we expect that
to continue
strong for
the rest
of the year and we're
focusing a lot on seeing that become very effective. So that mid to high double digit rate that we're going now, we still expect that to be sustainable as we go forward with commercial property and land. Any other color Andy you wanted to I think
that covers it. Your next question comes from the line of Sterling Auty from JPMorgan. Please go ahead.
Thanks. Hey guys, this is Jackson Ader on for Sterling. Good morning. Question from our side, how much of the shift in OpEx and I guess more specifically the sales and marketing expenses were directly due to the pushing out of the LoopNet integration versus maybe some other factors?
I'll take a shot at it, but I think it's nominal. I just checked with the CMO this morning and I think we pushed $1,300,000 of marketing expenses over the quarter with that CoStar Mail of $2,700,000 So it's $1,000,000 or $2,000,000 pushed into the next quarter. So it's not that much.
We also had some the launch of Belvix. We had some marketing in the Q2 for that, which we decided to actually save and spend a little later in the year. And then we also had such favorable results in apartments that some of our SEM spend, we decided to save a little bit for the next part of the year. And so those are a couple of other small components giving us about $4,000,000 favorable in total in the quarter that we'll expect to spend later in the year. You know, I always heard a wise saying from my son, Abe, says, Dad, you're a really aggressive accountant, but you got to save some stuff for the second half.
So please hold back and be ready to spend if something comes up. So
I listened to something.
Your next question comes from the line of Peter Christiansen from Citigroup. Please go ahead.
Hi guys, good morning. Thanks for the cash flow statement. I appreciate that.
I think somebody noticed.
Yes. You're welcome. So two things real quick. I think you called out 25% of the multifamily growth was attributed by existing customers. Any sense if that's pricing or listing volume, vacancy rate kind of related or not?
And then my follow-up would be, last quarter, I guess, multifamily kind of just started to break even. I was just wondering if you could comment on the trajectory of profitability there if the trend is continuing? Thanks.
I think a big part of that 25% is basically people who are looking for more lead flow are pushing their ad priority up higher. So they're going from a gold ad up to a platinum ad or a diamond ad. So that's something that's the nice thing about that business is people are the more firms that need higher lead flow need to spend more to be more prominently featured on our site. So I think that's the single biggest driver of that. And I guess and that could be related to some vacancy growth.
And then the second part of the question is
Yes. What was the second part of the question? Multifamily profitability. Yes, multifamily profitability. We mentioned in last quarter that we swung to profitability in multifamily.
And when we've moved in that business, it moves a material amount. So we're in double digit profitability is expected in the multifamily business already by the second half of this year. So it really does swing quickly once we move into that territory. So we expect that to continue. And in the second quarter when we spend the bulk our marketing, obviously that dips down, but for the rest of the year, we expect it to be pretty strong.
Your next question comes from the line of Andrew Jeffrey from SunTrust. Please go ahead.
Hey guys, good morning.
Good morning, Andrew.
Thanks for taking the question and indulging me here. So, it sounds to me like the investment you've made in research is really paying off in a meaningful way. And I wonder, Andy, if you could comment a little bit on sort of the next step as I've heard your world class IR guy, Rich, tell it, In terms of allowing brokers to perhaps begin entering some of their own data into maybe a combined CoStar LoopNet front end enhancing or maybe in some ways sourcing the research gathering function, does that provide potential scale, revenue growth opportunities? I'm wondering if you can just kind of frame that up for us.
Sure. So what's happening here is for the in the fall for the first time people will be able to brokers, owners will be able to edit some of their information listers, people that we know that's available to known listers, people that we know who they are and we know that they're legitimate. As they do that, we think there'll be a positive customer relationship benefit because very often they wanted to really make a simple quick change themselves and they don't want to have to have a conversation with the researcher. At the same time focus group after focus group, lots of market research says that the industry really wants those researchers curating that data and being aware of what is being placed out there and making sure it accurately reflects and positions their properties to their accelerate the velocity of data through our system. It will be a little bit of a learning process because we're going to have to learn how we interact with those brokers as we're doing some of the research, they're doing some of the input.
But it creates the opportunity to reduce our research costs, accelerate our update frequencies and the quality of our data. I think it but I think the biggest impact will just be improved data and faster response times. And I think that's going to be a pretty positive thing. I think it will have more positive impact that we're prepared to talk about now because we just want to know more about any unknowns before we start touting the benefits really loudly.
Your next question comes from the line of Pat Walravens from JMP Securities. Please go ahead.
Great. And congratulations on the new bookings you guys. Can I ask about this Exeligent litigation? And I know there's going to be some real limits on what you can say given that it's live, but how long will this level of spending go on? And then maybe Andy, at a high level, why is it so important that you're willing to spend this kind of money?
I am so excited to answer that question. I'm going to turn that over to John Coleman, our General Counsel.
Thank you, Andy. You're welcome, John. So the case is ongoing. It's at the relatively early stages. We're about 7 months in.
And
we don't
have beyond 2017, we don't I'm not really giving any information on the budget, but I mean we expect we don't have a trial date and we expect it to go well into 2018. So we expect the spend to continue as it's been going.
And what was the other part of the question?
So why is it important out there, why do that?
Well, I mean we think it's extremely important to protect our intellectual property and we think it's just not fair that Exelligent has we have evidence that we think demonstrates that they've been stealing our content on an industrial scale. We believe when we filed the lawsuit that we had extremely strong evidence that that was occurring and that evidence has only gotten stronger as we've gone forward. As for the counterclaims that they filed, we think that there is smoke screen and an entirely predictable reaction to our lawsuit. We think that they're extremely weak and have absolutely no merit. If anything, we think their recent filing is more of an admission of guilt that helps our case as opposed to anything else.
So the update on the Exeligent case is that we very much look forward to proving our claims in court. Thank you, John.
Your next question comes from the line of Mike Crawford from B. Riley. Please go ahead.
Hey, all. This is Sameet on for Mike. How are you?
Hey, Mike. Well, thanks.
So a quick question on the and thanks for the statement of cash flow. So a quick question on M and A. I think it looks like from your statement of cash flow that you provided, you spent about $30,000,000 on acquisitions in Q2, which I'm guessing is for LandWatch. I know it's still pretty early. Could you talk about how that acquisition has been going so far?
And part 2 of the question is, David, do you have $574,000,000 in cash on the balance sheet right now? Like what's the view on potential future M and A?
Sure. So LandWatch is still so first of all, is it just LandWatch? It's also Just LandWatch. Yes. So it's still early, but we're basically executing on the business plan we had laid out prior to the Excision LandWatch, which is integrating the 2 platforms, rationalizing where the staff is and how many folks we have.
Our goal is to eventually flow all the content of all these various sites into a new URL that we own land.com. But at this point, we think we're capturing about 57% of the search traffic on the Internet around that land and real land space of those companies that are actually engaged in that. So this gives a real strong market position. And again, it's 2 months in, but it's going well and going as expected. So it's an exciting beginning for us.
In terms of the balance sheet and other M point looking at a dozen companies and looking at potential combinations that will move our platforms forward either give us more scale in one of our core areas or a parallel area where we think we would be competitively advantaged because the assets we have in information or sales force or software. So there's a lot out there and it's good to have a strong balance sheet so we can approach those opportunities and be constantly ready to move for the right acquisition. But we're cheap. We're looking for good values.
And at this time, there are no further questions.
Well, thank you very much for joining us for the 2nd quarter earnings call and we look forward to updating you on our progress in the Q3. And again, congratulations to the sales team on fantastic acceleration in sales bookings and to our research management team for quadrupling the number of contacts with our customers year to date. Thank you.
Ladies and gentlemen, that does conclude your conference for today. Thank you for your participation and for using AT and T Executive Teleconference. You may now disconnect.