Welcome to the CoStar Group's Third Quarter 2010 Conference Call.
At this
time, all lines are in a listen only mode. Later, we will conduct a question and answer session and instructions will be given at that time. As a reminder, today's conference is being recorded. Speaking on today's call, CoStar Group Founder and Chief Executive Officer, Andrew Florence Chief Financial Officer, Brian Radecki and Communications Director, Tim Trainor. At this time, I'll turn the conference over to Mr.
Trainor. Please go ahead.
Thank you, and good morning, everyone. Welcome to CoStar Group's Q3 2010 conference call. Before I turn the call over to our CEO, Andrew Florence, let me state that certain portions of this discussion contain forward looking statements, which involve many risks and uncertainties that can cause actual results to differ materially from such statements. Important factors that can cause actual results to differ include, but are not limited to, those stated in our press release on CoStar's Q3 2010 results and in CoStar's filings with the SEC, including its Form 10 ks for the year ended December 31, 2009 and its Form 10 Q for the period ended June 30, 2010, 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.
As a reminder, today's conference call is also being broadcast live over the Internet at www.coStar.com slash corporate slash investor. And a replay will be available on our website 1 hour after this call concludes. Thank you for joining us. I will now turn the call over to Andy.
Thank you very much, Tim, and welcome to CoStar Group's Q3 2010 conference call. I'm pleased to report to you that during this past quarter CoStar observed improving commercial real estate market conditions and in that environment we achieved raising sales and extremely high renewal rates. 1 of the key headlines for CoStar Group this quarter is that we can now report that both the U. S. Office vacancy and availability rates have clearly stopped climbing and are now improving.
These key fundamental industry indicators historically are highly correlated with our sales growth and renewal rates. During the Q3 of 2010, CoStar Group posted $57,100,000 in quarterly revenue, an increase of 2.3% or 1,300,000 dollars over our Q2 2010 revenue of $55,800,000 Revenues increased $3,600,000 or over Q3 2009 revenues of $53,600,000 57,100,000 dollars is the highest quarterly revenue level that CoStar Group has yet achieved. Net new sales during the past quarter reached the highest level seen since Q2 of 2008. This is the 4th consecutive quarter in which we are reporting increasing sales productivity. For the Q3 of 2010, company wide quarterly net new sales totaled 4,600,000 dollars a nearly $1,000,000 improvement over 2nd quarter new sales of approximately $3,700,000 The 3rd quarter net new sales of $4,600,000 is a $3,000,000 improvement over the Q1 of 2010 net new sales figure of 1,600,000 dollars We're obviously very pleased to be able to report that net new sales in the Q3 of 2010 nearly tripled over net new sales in the Q1 of 2010.
Our core product, the U. S. CoStar Property Professional Information Suite was the biggest driver of our strengthening 3rd quarter organic revenue growth. Our great progress in sales this past quarter was only possible because of the company's continued success in retaining customers. Our 12 month trailing renewal rate for subscription based services increased approximately 2% quarter over quarter, climbing to a very impressive level of approximately 90%.
The end quarter renewal rate increased 7% year over year. A 90% renewal rate is the highest level we have enjoyed since the Q2 of 2,008. During the Q3, the renewal rate for clients that have been our customers for 5 years or more remained very strong at 96%. The Q3 2010 renewal rate for firms that have been our clients for less than 5 years also remained very high at 87% and very much improved from the 74% we were experiencing 1 year ago. I believe the great improvements we see in our renewal rates are the direct result of the hard work and talent of CoStar's sales force and a clear indication that our core customer base is returning to financial health.
Commercial brokerage firms in particular have been very active recently and we continue to see strong demand from one of our largest client segments as tenants return to the market and leasing activity increases. Many brokerage firms have added users or subscribed to additional services and markets recently, including one of our largest clients Grub and Ellis, which recently signed a major contract extension for additional services during the Q3. We believe that a 90% 12 month trailing renewal rate for our subscription based services combined with the fact that subscription based revenue accounted for 94% approximately 94% of the company's total revenue in the 3rd quarter makes CoStar Group an exceptionally solid and attractive company. Our company's solid balance sheet with $232,000,000 in cash, cash equivalents and investments on hand at the end of the 3rd quarter with no long term debt and a mortgage REIT Class A office building to boot, all served to enhance CoStar Group's sterling financial position. The total number of subscription client sites increased by 211 during the quarter to 16,508 company wide, and that's in comparison to 16,297 in the 2nd quarter.
The total number of individual subscribers also increased by 486 during the Q3 to 86,803. CoStar continues to see strong demand from investors, banks and other financial services firms. We also continue to take advantage of cross selling opportunities with our subsidiary Property Portfolio Research or PPR. One example of successful cross selling to institutional clients was our 3rd quarter subscription sale to Wells Real Estate Funds. 1 of the largest private REITs in the U.
S, Wells agreed to purchase CoStar Suite and PPR's performance service. I understand our combined solution was chosen over several other good competitors. Allstate Investments, an affiliate of the Good Hands People was also a major combined CoStar PPR effort this past quarter. Banks have also continued to be another good major source of sales. Our sales force has made a concerted effort to target banking firms and we've been tremendously successful in introducing and expanding CoStar services to this sector.
So far this year, 66 banks have become new subscribing clients. A strong regional bank called BB and T became a subscriber in February of this year, initially purchasing just a 2 user license. By the Q3 of this year, BB and T had increased its subscription to a 40 user license. Partially reflecting the increase in sales to larger clients, our Q3 2010 average new contract value increased 18% to $8,292 of the 2nd quarter 20 10 average new contract value of $7,031 Our sales organization and our sales management has performed exceptionally well throughout this downturn in driving usage, retaining clients and winning new business. They are now a better trained and more experienced team than ever and they're looking forward to winning more new business as the economy recovers.
At the end of the Q3, we had a total of 181 sales reps, down slightly from 194 on stat at the end of the Q2 2010. This includes 118 U. S. Subscription sales reps, 7 U. S.
Advertising sales reps, 34 in house sales reps, 16 U. K. Field sales reps and 6 sales reps for PPR and Resolve. We expect sales headcount to return to mid year levels as a new sales training class moves into production. Given the continued strong demand we are seeing in almost all areas of our business, I am very excited about our current position.
With the initial recovery underway in the commercial real estate economy, I believe that CoStar's tremendous research advantage and expanding platform will continue to drive strong sales growth in our sales and revenue. I would like to take a moment to discuss current improving commercial estate market conditions in a bit more detail. In our last call, I stated that our research had confirmed that office vacancy rates had stabilized in the Q2 of 2010 after nearly 3 years of steep increases. In the Q3, we confirmed the major news that U. S.
Office vacancy rate and availability rate has now reversed course and begun to decline and improve. This important market inflection point comes after 2 consecutive quarters of positive net absorption of commercial office space and an almost complete shutoff of new supply. We believe this improvement is the first in a series of steps towards overall improvement in the commercial real estate market. While this is certainly welcome news, we are still very early in the recovery phase. It will take time before the recovery gains momentum and becomes widespread throughout the market.
We will know that recovery has occurred when no one is talking about recovery anymore. Job growth is a key driver of commercial real estate recovery and the job growth we're seeing now is painfully slow. Although job growth has remained sluggish, there continue to be strong leading indicators of future job growth, including positive GDP, increasing corporate profits, strong productivity gains and a lot of temporary hiring. The U. S.
Has posted 2 consecutive quarters of positive office employment growth. Economy.com and others are continuing to forecast strong job growth over the next several years. Although weak, the job growth we have seen was strong enough to allow the U. S. Office market to post 2 quarters of positive net absorption with 7,000,000 square feet of office space absorbed during the Q3.
This is a 2,000,000 square feet increase over the 5,000,000 square feet of office space absorbed in the 2nd quarter. While this is not a large amount of absorption given the total size of the U. S. Office market, it is significant because new commercial real estate construction, as I mentioned, remains an all time low. So the positive absorption activity we're seeing is effectively working away at the excess space in the market.
Recovery in the capital markets tends to lag recovery in the leasing market, it's always been so. This is certainly the case in the market now as the capital markets and commercial real estate sales remain unsettled. Sales volumes remain well off their overheated peaks, but have nearly returned to historical averages for commercial estate before the bubble of 2,004,000 and 7. Reflecting a market transition, we're seeing different trends occurring in different segments of the market. Cap rates are up, while sales volumes and prices are down across most second and third tier markets.
In contrast, cap rates are declining while sales volumes and prices are up in 1st tier markets or leading cities such as New York, Washington DC, Boston, San Francisco and Los Angeles. Institutional grade properties are beginning to show value appreciation after they may have perhaps overcorrected in response to the collapse of CMBS market and the complete lack of debt or funding for that kind of high end asset. This is driven by the current flight to quality investment strategy among commercial real estate investors, especially among REITs and other large institutional investors with access to equity. What's interesting is that they all appear to be targeting the same core high quality buildings and CBDs that are well leased to credit tenants. The competition for these buildings is phenomenal with actual bidding wars breaking out in some cases.
Last week, I made a presentation at the recent Urban Land Institute Conference here in Washington DC and CoStar also sponsored the keynote panel where the discussion centered on this very issue. 1 panelist described the current investment sales market as an inch wide and a mile deep with all the major potential buyers targeting the same select group of assets. Another panelist agreed, adding that this is part of a global search for yield among large investors. In the current market with debt being relatively inexpensive, high quality core real estate assets stack up quite well in terms of yield compared with the equity and fixed income markets. We believe the path to market recovery is clear but modest.
Our forecast for the office market calls for continued positive net absorption with the national average vacancy rate declining to under 12% in 2012. We believe that this renewed market activity great news for our clients and also supports CoStar's revenue growth prospects over the next several years. There is one downside to the emerging recovery. Each time the commercial real estate market crashes, CoStar tends to pick up countercyclical crash related businesses, much of it focused on loan default workouts. And I have to say, this is a great attribute of the CoStar business, The fact that we generate new business in down cycles makes us a little less cyclical.
In due course though, when the market recovers that business goes away or at a minimum maybe reduced. Fortunately, the loss of any workout business we pick up during a downturn to pale in comparison to the new business generated in a recovering market. I believe I previously provided the example of CoStar picking up the Resolution Trust Corporation as a major client in the 1990s. The RTC's mission was completed and it wound down its operations once all the SNL assets had successfully been divested. Once they closed up shop, we lost that contract and there was not much to be done about that.
This recent cycle has been no different and won't be different in the future. Last year, PPR was selected as a subcontractor under the term asset backed securities loan facility or TALF to provide analytics and forecasting services in support of this important program, which was under the operation of the Federal Reserve Bank of New York. Roughly a year later, the legacy CMBS portion of the TALF program is considered a success by almost any measure, which is certainly good news for the market as a whole. We were pleased to win the contract and assist the TALF program. Now having largely served the purpose it was set up to do, the program is no longer issuing new loans.
Therefore, our services are no longer needed and our contract has ended. Our experience supporting TALF over the past year has been invaluable as we continue to develop our products and market position in the area of credit risk analytics. We are now seeing strong sales momentum in this area, which is helping to offset the loss of this business. In the Q3 of 2010, CoStar's research team remained focused and effective adding more than 160,000 new listings. For the year to date, our research team has added nearly 500,000 new listings.
Not only do these listings represent 500,000 new opportunities for our customers today, They also provide the added value of 500,000 new comparable sale and lease transactions that provide our customers such tremendous value. We now have approximately 1,500,000 listings offered in our service. That's a lot of listings. And for the first time, our for sales listing count grew to more than 500,000 listings during the Q3 of 2010. We now track 3,900,000 properties combined in the U.
S, U. K. And France. It won't be long before we reach a 4,000,000 property milestone. We believe this is the largest proactively researched or proprietary commercial real estate database ever built and that it represents a huge competitive advantage in the marketplace.
Showcase continued to perform well during the Q3. Our online marketing service now has 10,000 889 subscribers in both the U. S. And UK, which is a 53% year over year increase compared to the Q3 of 2,009. Showcase is now generating approximately $6,000,000 in annualized revenue.
The introduction of Showcase to the United Kingdom this year has gone exceptionally well as we already had 510 paying UK subscribers successfully capturing significant market share in a very short period of time. As I hope you recall, CoStar Purchased a Class A office building in Downtown Washington DC in the Q1 of 2010 for $41,250,000 This building will serve as our new headquarters and today the earnings call is being broadcast from that new headquarters. This headquarters has replaced our leased headquarters in the past 11 years in nearby Bethesda, Maryland. The City of Washington invested considerable effort in crafting mutually beneficial tax incentive legislation enabling CoStar to move into the District of Columbia. That legislation requires CoStar among other things to increase by net 100 the number of district residents CoStar Group employees before we will be eligible for 1,000,000 of dollars of potential tax abatement incentives.
I'm pleased to report that CoStar Group has both completed the move to our new Washington headquarters and we have reached the important milestone of 100 net new district residents employed. This achievement should clear the path for us to pursue our significant potential tax abatements from the city. In fact, we now have 4 58 employees working at our Washington headquarters. I believe morale is extremely high in this new HQ. We are exceeding our recruiting goals in our new facility and we appear to have improved employee retention.
50 of the 4.58 employees working in our new HQ transferred from our Columbia and White Marsh, Maryland Research Offices. I think that these transfers bring an influx of talent and great energy into our new HQ. The company did offer move allowances to dozens of employees in order to quickly staff the new HQ and retain talent. We have incurred a number of non reoccurring expenses associated with our move to the new HQ, including move costs, double rent, employee incentives and recruiting expenses. We are no longer paying rent on our Bethesda HQ, thank God, and most of these one time expenses should slow going forward.
In a related development, we are pleased to receive an award this month in the Washington Downtown DC Business Improvement District for strengthening and diversifying the city's employment base. According to the Downtown DC Business Improvement District, CoStar's relocation from Bethesda, Maryland is the largest move into the district by a public or private company in 2010 and ranks among the largest such moves by a private employer in the past decade. We couldn't be happier with our decision to move to this new HQ. This is a fantastic building and a great location that is capable of accommodating our expected growth for many years to come. We intend to invest in completing the build out of our new HQ over the next 9 months, so that we could eventually house close to 7 20 staff in the HQ facility.
As if our facility and IT staff was not busy enough during the Q3, we also consolidated our 3 Boston offices into one facility at 33 Arch Street. With Resolve, PPR and CoStar all literally right under one nice roof, you can see progress picking up speed towards building some amazingly powerful fully integrated software tools between these companies. I think some of the most valuable and impactful commercial real estate information analytic and forecasting tools ever built will be built in our new laboratory at 33 Art Street. We expect that both our new headquarters and the new Boston office will be LEED Platinum. I believe that both of these new facilities are bringing our human capital together into a more productive consolidated facilities.
I expect that these moves will increase retention, increase productivity and ultimately reduce our long term costs. Let me close my remarks by saying that I am very pleased with our company's performance during the Q3. Increasing sales, high renewal rates and accelerated revenue growth clearly demonstrate renewed strength in our business. With commercial real estate markets now in initial recovery mode, we fully expect to achieve additional high margin revenue growth through the Q4 and well into 2011 and beyond. Thank you.
I will now turn the call over to Brian Radecki, our CFO, so that he can discuss our quarter's financial results in more detail. Thank you, Andy. Welcome. As Andy mentioned, we're very pleased with the Q3 2010 results. We achieved accelerating organic revenue growth for the 4th consecutive quarter and saw positive momentum continue in almost all areas of our business.
Today, I'm going to principally focus on the sequential results for the Q3 of 2010 compared to the Q2 of 2010 and also on our outlook for the Q4 and full year 2010. We believe the sequential trends offer the most insight into the performance of our business as we continue to progress through the current economic and commercial real estate cycle. Our Q3 revenues came in stronger than anticipated at $57,100,000 an increase of $1,300,000 over the Q2 of 20 10, an increase of $3,600,000 compared to the Q3 of 2,009. Our record revenue performance during the quarter was primarily driven by strong net new subscription sales for our core CoStar Suite service offerings as well as the high renewal rates for our subscription services. International revenue on a functional currency basis was approximately £3,100,000 in the Q3 of 2010, essentially flat compared to the Q2 of 2010.
International revenues were approximately 8.4% of the company's total revenues in the 3rd quarter. Subscription revenues for the Q3 accounted for approximately 94% of our total revenues with our 12 month trailing renewal rate, which as everyone knows is a measure of renewing subscription revenue was approximately 90%. We believe this is a very important measure for let me remind everybody, this is 2 to 3 quarters ahead of where we originally projected. As I publicly stated on earnings calls for over 2 years now, we expected that 12 month trailing renewal rate to decrease into the mid-80s during the downturn and then begin to recover in 2010. Our in quarter renewal rate for the 3rd quarter was again high in the low 90s and I'm pleased to report that the renewal rates continue to trend in the right direction.
Please note that the in quarter renewal rate, which is a measure of subscription dollars renewing will fluctuate from quarter to quarter by plus or minus approximately 2 percentage points. Therefore, the overall trends on the 12 month trailing renewal rate are very important. We believe that moving from the low 80s into the 90s all within a year is extremely positive news. Over the next few quarters, we continue to expect that 12 month trailing renewal rate to be in the high 80s and low 90% range. Now turning to gross margin.
Gross margin was $36,400,000 in the Q3 of 2010 and was up approximately $900,000 compared to Q2 of 2010. In addition, gross margin percentage increased from 63.7 percent to 63.5 percent from the Q2 of 2010 due to higher revenue and leverage in our model. Moving down the income statement, total operating expenses in the Q3 of 2010 decreased by $800,000 to $30,200,000 compared to $31,000,000 in the Q2 of 2010. Q3 2010 does include expenses of $1,300,000 associated with the consolidation of the former PPR resolve and CoStar offices in Boston into a single facility, which ran through the G and A line. We believe having those teams together in a new Boston office will facilitate the integration, product development and cross selling initiatives we've been discussing with you for the past several quarters.
Selling and marketing expenses was essentially flat in the Q3. Looking at profitability, net income for the Q3 of 2010 was $3,400,000 or $0.16 per diluted share and our non GAAP net income was $6,900,000 or $0.33 per diluted share, both above our previously guidance range. Quite simply, we're very happy with the results on both a GAAP and a non GAAP basis, which basically reflects our stronger revenue and stronger operating results. 3rd quarter 2010 headquarter transition charges, which Andy spoke of earlier, were approximately $1,300,000 We now expect those costs to be in the $2,700,000 to $3,000,000 range, which is slightly lower than what we originally expected for the year. EBITDA for the Q3 of 2010 was $9,400,000 an increase of $1,600,000 compared to the Q2 of 2010 and adjusted EBITDA for the Q3 was $13,800,000 or approximately 24% of revenue.
Reconciliation of non GAAP net income, EBITDA and all non GAAP financial measures discussed on this call so their GAAP basis results are shown in detail along with definitions for those terms in our press release issued yesterday, which is available on our website on the Internet at www.coastar.com. Turning to the balance sheet, we ended the Q3 of 2010 with approximately $232,000,000 in cash, cash equivalents and investments, no long term debt and a shiny new building. I will now discuss our outlook the Q4 and full year 2010. Our guidance takes into account recent trends, revenue growth rates, renewal rates, which all may be impacted by the economic conditions in commercial real estate or by the overall global economy. Our forward looking guidance reflects our current expectations as of October 21, 2010.
We expect revenue for the Q4 2010 to be in the range of $57,100,000 to $58,100,000 And for the full year 2010, we are once again raising the high end of our annual guidance range by $2,000,000 as we did last quarter to approximately $225,100,000 to $226,100,000 Continued strong demand for our services demonstrated by our 12 month trailing renewal rate moving back to the historic 90% average combined with consistent accelerating revenue growth in 2010 gives us a lot of confidence in our higher annual revenue outlook. Our guidance on the impact of foreign currency exchange fluctuations and our top line results remain consistent. We do not attempt to predict the foreign exchange rate fluctuations and our guidance assumes little to no volatility in the current rate. The average exchange rate for the Q3 of 2010 was US1.55 dollars to 1 British pound and the remainder of our 20 10 guidance assumes a rate of 1.5. In terms of earnings, we expect the 4th quarter 20 10 fully diluted net income per share of approximately $0.15 to $0.18 and non GAAP net income of $0.28 to $0.32 For the Q4 outlook for GAAP net income per diluted share, we expect about $300,000 to $500,000 of remaining costs related to the transition of our new corporate headquarters in Washington DC in October and approximately $2,500,000 to $2,700,000 in equity compensation charges.
We expect the 4th quarter tax rate to be approximately 49%, while again our annual rate we still expect to be 44%. For the full year 2010, we expect GAAP net income per diluted share of approximately $0.61 to $0.64 and non GAAP net income per diluted share of approximately $1.20 to $1.24 We expect to achieve our annual earnings outlook even with the short term dilution in net income resulting from the legal settlements, costs associated with our ongoing efforts to reduce our facilities by moving our headquarters into a corporate owned facility and consolidating and moving our Boston and UK offices. For our annual guidance range, we are increasing the earnings projections based on the expectations for the increased revenues we discussed above. For the full year 2010, we expect approximately $2,700,000 to $2,900,000 of costs related to the transition of our new corporate headquarters and that is approximately $300,000 lower than what we provided last quarter. Additionally, we expect to close 2010 with approximately $1,300,000 of the lease restructuring charge and $8,300,000 to $8,400,000 of equity comp expense.
Costs in 20 related to the acquisition and transition of the corporate headquarters, as Andy said, was primarily overlapping costs incurred through the end of the Bethesda lease term and the carrying cost with the building prior to our move. The Bethesda headquarters lease expired on October 15 and we completed the move to that facility last week. We continue to believe we have created significant long term value with the move to our new headquarters facility in Washington, D. C. In closing, we're very pleased with our record revenue results and momentum we're seeing in our business.
Our business model remains strong based on the 94% subscription based business model with a 90% renewal rate, our unique proprietary database, market leading position, strong balance sheet, no debt and very high operating cash flow. Based on the results we've seen in the past few quarters, we believe we are well back on our way to a more normalized organic revenue rates and expanding margins that we've enjoyed over the past decade in the near future. Now that we are essentially through the majority of the consolidation of office space and operations in 2010, we believe we're well positioned to enjoy the revenue and earnings growth similar to what we enjoyed in the period of the Q2 of 2007 to the Q3 of 2008, which was the last completion of our expansion investment phase. CoStar's management team believes there is significant opportunity for addition high margin revenue found in the investments we have made and believe in our long term goal of $1,000,000,000 of commercial real estate information revenue at a 40% to 50% margin. We continue to look forward to reporting that progress to you.
And with that, I open it up the call for questions.
Our first question is going to come from the line of John Maeda with Needham and Company. Please go ahead.
Hi, thank you. The first question I had was around your expectation for growth. And Andy, maybe you could talk a little bit about where you would expect it to come from. So obviously, you'd have a portion from the existing client base who will start to add seats as their business improves. You'll see a piece from new services, incremental services and then you'll have a piece obviously that comes from brand new client logos.
And I'm just hoping you could help me think about that mix.
Sure. Thank you. I actually look at this and I think the greatest driver for the next 5 years, 4 to 5 years will be new logos. There is an awful lot of customer base to go, prospect base to go after here in the United States. So we still have north of 10 1,000 meaningful brokerage firms to sell our products and service to here in the United States.
We've got thousands of retailers to sell our products and services to. There's 7,000 plus banks with commercial real estate assets in their portfolio. Our successful Compass product has only sold about 25 some units. We've got several 100 on the CoStar property side, but you still have thousands to go there. And I think the institutional space is one of the biggest opportunities for our business over the next 5 years.
So big picture, as the economy recovers and these prospects are more open to considering new effective investments, we think we'll be able to pick up traction in new logos organic growth. There certainly is a lot of opportunity for cross selling in the existing customer base. That's always been half of our sales activity. And I expect that to continue to be the case. As you know, we have begun to institute some minor price increases that keep us abreast or keep us apace with any CPI activities going on.
But the main thing we're focused on is that we know that there are thousands of good companies out there that would benefit from our products and it's a penetration story. It's a story of going after those names in those companies.
Got it. Okay. And then could you just remind us where you are in terms of you had talked about the lower end bundling on the quarterly call last quarter, just maybe where we are in that cycle and what you're kind of seeing there early days?
Sure. The program began last quarter focusing on bundling our suite of services to these like the 4th tier markets into some of the smaller firms out there. So provide them with a tremendous value proposition for relatively low cost and not doing that through our field sales force, but instead using our centralized lower cost headquarter based sales force. That has gone well. It is I know that we're picking up, I believe, hundreds of people at that lower level and that group is that internal sales group is a strong contributor to our sales growth right now.
But that is sort of a blocking and tackling thing, something we're doing. But our real focus is probably at the middle to upper end of the marketplace, the institutional marketplace, the banks, the leading brokerage firms. That's where the most of the revenue dial is going to be pushed.
Okay. That's helpful. And Brian, just last question for me, if you could I don't know if you have the number, but operating cash flow in the quarter and if you have the CapEx number as well.
Sure. Yes, the CapEx number was about $6,000,000 for the quarter. It's about $10,000,000 for the year. Obviously, we have a lot of CapEx related to our new facilities. And I believe the operating cash flow is about 20 $7,000,000 for the year.
I think it was around the $7,000,000 mark for the quarter.
Got it. Thanks very much.
Okay. Thanks, John. Thank you.
Next question comes from the line of Tim Connor with William Blair. Please go ahead.
Hi, guys. Couple of questions. First off, just wanted to ask about the price impact on renewals and on new business.
The best of my knowledge, there's been zero impact. I've not heard a single comment from anyone in our sales organization about any pushback whatsoever on any of these price increases. I think the CoStar Group took a very, very client focused conservative stance going into the downturn when we proactively immediately stopped any price increases anywhere even ones that we could contractually take. So I think the customers are sort of comfortable with our pricing policies and for us to reinstitute price increases that just get us back to CPI from the last year or so, I think there's 0 pushback. I haven't heard a single thing.
I don't think Brian has heard anything either. No pushback on. No, no. It's going well.
Would you say that's a function of just their improving business or
is it something else?
I think it's a function of I think it's definitely a function of their improving business and the fact that CoStar Group is CoStar Group services are really, really important tool for them to be able to productively go do what they do and make money. So, what they pay for our services is relatively small compared to the value they're getting from it. And as long as they as long as we have a reputation of being fair in the marketplace, you're not getting pushed back. And we've been doing this for a long time now. So I think that we certainly have a good sense of when the customers are going to feel they're getting pushed and they're not feeling they're being pushed right now.
Okay. Thanks. And then one more customer question. So DSO trends, how
far do
you think those can continue? And anecdotally, what are you seeing?
I'm sorry, repeat that again.
So customer payment behavior, DSO trends have been improving. How far do you think you see those coming? And do you have any anecdotal sort of stores on that?
Sure. I think that the payment trends continue to improve. DSOs continue to improve. Our aging has just I mean, I compare it to last year, it's like night and day. And it really just goes to the overall health of the clients in the business.
And really sort of, as we talked about in prior calls, sort of the clients that were unhealthy, we really lost them in the past year. And I think now that's why you see the renewal rates going up, you see improved collections, our bad debt is half of what it was last year. So I would continue to expect that to move in a positive direction. I don't see anything on the radar screen right now unless some significant changes in the global economy to really move the dial there over the next few quarters there. So very positive.
Okay. I think he's sandbagging. Any CFO worth his salt can get DSOs to 4 days.
Yes. And then staffing levels, are you comfortable with these and then plans for the future on this?
Right now, we are comfortable with our staffing levels. I think we're reasonably stable in our research staffing levels. We might have 1 or 2 relatively minor initiatives, which would represent single digit percentage increases in research staff in order to pursue a few new initiatives. Over 2011, we might become a little bit more aggressive with some software development initiatives. But we're by and large fairly comfortable with where we are right now and there's some big trends towards some cost efficiencies as we get rid of these multiple facilities and so on and so forth.
And I think on the sales side, Andy mentioned this before, we have training classes in the 10% to 20% range. So we happen to be at the end of the quarter, actually as we moved, we actually pushed the training class into the next quarter. So that's why you saw that dip a little bit. So I think you'll see that go back up and we'll see that continue to be around the 200 mark plus or minus a little bit pretty consistently moving forward.
Okay. Thanks. And then one final one, analytics programs, TBR integration and putting that on top of the database. Just could you discuss just generally what the plans are for that going forward?
Sure. Someday, I want to be more like Steve Jobs and only talk about new products when I'm on the stage and we actually have them and they're shipping tomorrow. But it's going well. Again, getting everyone under one roof in Boston is great because you've got a great technology team over at Resolve. You've got a very innovative group at PPR.
And then being able to pull our 1 to 1 facility, it's much easier to work on this product integration. So we're pursuing a deeply integrated set of products between everything we're doing from Compass to Portfolio Maximizer to Request to DCF to analytics and forecasting and then granular property data. We envision something that is highly integrated, one interface for the customer, one look and feel, one login and that's what we're going to be pursuing and we're not we're probably not going to give a lot of color on specifically what we're doing until we actually are delivering the product to our clients.
Okay. Thank you.
Just for competitive reasons.
Sure. Thanks.
Next question comes from the line of Jim Wilson, JMP Securities. Please go ahead.
Thanks. Good morning, guys. Hi, Jim. Andy, I was wondering if you could give a little more color on the Wells Fargo deal, mainly what I know you won't tell a dollar amount probably, but what changed and what was added from the last contract you had with them? Well, this is actually Wells Real Estate, I think Wells Fargo, I believe is a client.
But the one we specifically mentioned was Wells Real Estate and that was just been that would have been a new customer acquisition. That would be something where they would have been, I believe, using a different competing service for their analytics information, their market forecast. And when they looked at being able to get the highly granular detailed data that CoStar provides coupled with the great market analytics and write ups and forecasting the PPR provides, they felt that was a more effective soup to nuts solution. So they basically are a new logo add for us. Okay, I see.
All right. And then maybe the other one would be, you're one would be, you're working to both cross sell the analytics and then what you will produce on the combined desktop. Could you maybe describe a little or highlight the couple, 2, 3 main things that customers tell you, boy, this is what we really want from you. Can you do this? Will you do this?
Or when will you be able to do this? Okay. So I think 2 things I would focus on 3 things. One is the customer who is attending our PPR conference in the Cape and getting high level overviews of forecasted vacancy rates and rental rates and discussions of which matrix to be investing in commercial real estate. Want to be able to access that information and online be able to customize that information, very high level analytics on macro, macro trends in U.
S. Commercial real estate, but they want to be able to go from there down to the asset level and see what's actually happening in specific assets. So these people have assets, they like to look at how directly competing assets are performing compared to their assets. And they want that to all be in the same system where their macroeconomics resides and they want to be able to go back and forth between the 2. The other thing is they want to get to more granular analytics and economic forecast.
They want to be able to get very specific analytics and breakouts on how one submarket or micro market is likely to perform compared to another micro market. So it's not good enough to talk about what's happening in office space in Midtown Manhattan. You need to be talking about what's happening in the Plaza District distinctly different from what's happening in the Grand Central area. So that getting into greater granularity and that's part of our initiative to put economists in each local market and really get into the detail there. We think there's a huge market there.
There are more than 100, 200, 300 developers and owners who have multibillion dollar portfolios only at the local level and that appeals to them in particular. The other thing I think is very interesting is being able to take the customers' information. The customers have a wealth of information about their portfolios from accounting information to lease management systems to forecasting systems. Being able to take that information, help them organize it, but then present and mine the relevant information in our databases analytics and forecast and set against what's relevant and important to them based upon their data and help them sort through this billions of pieces of data to find out which 10 pieces of data is important to them. So those are the 3 big trends we're going at.
We're having a blast doing it. It's a fun project. It's very ambitious, but that's what the customers are saying and we're very happy to pursue a solution that sort of matches what the customers are asking for. I guess we're nerds. Okay, great.
Thanks a lot. You're welcome.
Our next question comes from the line of Chris Limon, Deutsche Bank.
This is Asu Gogol for Chris. Can you talk about what excess capacity or installed base of clients might have currently in terms of unused subscription IDs and how that may impact any incremental spend within your client base as we move towards a recovery?
Sort of like the CoStar shadow vacancy rate or something. It's actually relatively low. Our sales force is compensated fairly heavily and we actually shifted our compensation structure at the beginning of the downturn to incentivize our sales force to proactively pursue inactive user IDs and try to make them active. We call it going creating green bar users. So, in our internal tracking system, if you're using our products heavily, you're a green bar user.
They have earned 100 of 1,000 of dollars, if not 1,000,000 of dollars in commissions over the last 2 years. Going after these dormant IDs, these people who have legal who are subscribers, but don't use our product and getting them to use the product. So we're probably in the history of our company at one of the better places we've ever been in terms of having these high percentage of user IDs active. And they actually the salespeople actually get lose commissions on new sales as they have a high ratio of dormant ID. So they're right on top of it.
And the empirical positive evidence of that effort is the fact that these new customers, these customers that have been our customers less than 5 years right now, they jumped from 74% renewal rate to what was the number 87% in the course of 1 year and that's because we chase down those dormant ideas. So I think the company is the strongest place it's ever been in terms of the percentage of active user IDs.
Thanks. And just as a clarification, if there's a headcount reduction at any of your broker clients, does that ID go away? Or are they still paying for it and they might have a backlog of that which they might need to use before they start buying new IDs from CoStar?
Well, that was really sort of a story from last year and the year before when people were reducing brokerage headcount. So, as we went into the downturn like Q3 of 'seven, 'eight, 'nine, brokerage terms were reducing headcount. There were many of the brokers' rooms are actually probably a little bit over their authorized allotment. So there was a lot of what do we call it write downs in 2008 and 2009 associated with downsizing them to the right number of IDs. I don't expect that to be a major factor going forward.
I think we're now moving into an expansion phase in brokerage and I think that we're probably as I understand it from our sales management team, we're seeing a lot of seat adds right now, not a lot of seat reductions.
Great. Thanks very much.
Our next question comes from the line of Bill Warmington, Raymond James. Please go ahead.
Good morning.
Good morning. How are you doing?
All right. Thank you. A question for you on the adjusted EBITDA margins. You saw some improvement quarter to quarter and year over year there. From time to time, the number of 30% achievable target has come up.
And my question for you would be, how should we think about that margin going forward? What kind of a timeframe should we have for getting to a 30% type number? And how should we think about the incremental operating margin between now and there?
Sure. Hey, Bill, it's Brian. I think that we obviously aren't giving guidance on next year this call, but I think we're very, very well positioned to see expansion in that number. I think I kind of point people back to the 2,007 all the way through the end of the Q3 2008 time period, which that time period was right after we completed a major expansion. And pretty much every quarter, you saw revenue dropping from the top line to the bottom line, sometimes at 50%, sometimes at 70%, sometimes at 100%.
So I think we're starting to move back into that phase. We've had a lot of things we've done this year with the acquisition of PPR and Resolve, the integration of those businesses, the moving of the headquarters. We still have some of that noise coming through in the Q4 and maybe just a tiny bit in the Q1. But I believe as you sort of get to the middle of next year to the end of next year, I think you'll see that number expand. And I think it will look a lot more similar to that 2,007, 2008 time period.
I think if we continue at the rates that we're at, we can get to a 30% margin, I believe, fairly quickly. And I guess I'll just point everybody back to that time period and you can sort of figure it out based on your own revenue growth projections.
Right. The other question for you is how the acquisition pipeline is looking?
The acquisition pipeline is robust. There are a number of potential things out there. We are at any given time dialoguing with half a dozen different companies and there's no lack of potential deals out there. I think realistically, the consolidation of the headquarters, all the Boston offices resolved PPR has kept us a little busy as well as software planning. So probably we're moving into a season with a little bit of accelerated operational activity.
Okay. And the I wanted to also ask about that what you think that shiny new building is worth today versus what you paid for it and whether you had any plans to unlock that value?
Yes. It's always difficult. I think it's always difficult unless you actually have a transaction, you don't really know you're just speculating. I guess we paid $41,250,000 for it or $230 per square foot. It does not it's got a long term land lease out of the property.
There has been a trend towards institutional investors really wanting to find yield and they look at Class A assets in 1st tier cities as being good alternatives to low yielding debt instruments because you're pretty much picking up a bond from a company backed by high quality real estate. So we've seen some deals. We've picked up this building at 230 something a foot, 240 something a foot. We've seen some deals within a couple of blocks of here the $600,000 $700,000 range. We are not long term investors in commercial real estate.
We provide services to people that do that. So we're always open to unlocking the value in that and deploying the capital and other probably other uses that are more core to our business. So was that a good non answer?
I don't know. I figured it's
at least worth a couple
of bucks for share in cash. But anyway, thank you very much.
Thank you very much.
Our next question comes from the line of Toni Kaplan, Morgan Stanley. Please go ahead.
Hi, guys. Thanks for taking my question. Just a quick question on your traction in the retail market, how it's progressing and any initiatives you have to sort of up the customer base in that market? Thanks a lot.
Thank you for the question, Tani. We have had some good traction there. So we now have a lot of recognizable retailers as customers using our services for both valuing their properties and also opening new stores. We now have, I believe, in the relatively short period that we've been in the retail information. So I believe we have 10 of the top 10 retail, 9 of the top 10 retail owner developers now as customers.
So that's been very successful. To be honest with you, I think we're overdue for some price enhancements and upgrades. So we've been extraordinarily successful in this space. We have been successful in gaining the trust of the industry and they are using our platform to communicate their offerings, listings, properties for sale and they're doing it. I mean, I guess we've seen multi 100 percent growth in the number of listings moving through our system.
So, I think we're at the early stages of developing a product for the retail community. And as we get to Version 2, 3 and 4, I think we'll be able to get some really solid growth in that space. So we want to get to next year's ICSC with I think some product upgrades responsible for what we now know about the industry and what we can do for them. These are not really expensive upgrades by the way, I should say. This does not involve hiring hundreds of people, it involves a couple of software developers.
Great. Thanks a lot.
Thank you. Thanks, Tony.
Speakers, at this time, we have no further questions in queue.
Okay. And at this point, I'd like to thank you all for joining us for the Q3 call. And we look forward to, I guess, next call will be year end results and numbers. And we're really glad to be in a strong market with some traction in sales. And we hope all your other earnings calls go as well.
Thank you.