Good afternoon, ladies and gentlemen. Thank you for standing by, and welcome to the PTC 2017 second quarter conference call. During today's presentation, all parties will be in a listen-only mode. Following the presentation, the conference will be open for questions. I would now like to turn the call over to Tim Fox, PTC's Vice President in Investor Relations. Please go ahead.
Good afternoon. Thank you, Christine, and welcome to PTC's 2017 second quarter conference call. On the call today are Jim Heppelmann, Chief Executive Officer, Andrew Miller, Chief Financial Officer, and Barry Cohen, Chief Strategy Officer. Today's conference call is being broadcast live through an audio webcast, and a replay of the call will be available later today on our investor relations website. During this call, PTC will make forward-looking statements, including guidance as to future operating results. Because such statements deal with future events, actual results may differ materially from those projected in the forward-looking statements. Information concerning factors that could cause actual results to differ materially from those in the forward-looking statements can be found in PTC's most recent annual report on Form 10-K, quarterly report on Form 10-Q, and other filings with the U.S. Securities and Exchange Commission, as well as in today's press release.
The forward-looking statements, including guidance provided during this call, are valid only as of today's date, April 19th, 2017. PTC assumes no obligation to update these forward-looking statements. During the call, PTC will discuss non-GAAP financial measures. These non-GAAP measures are not prepared in accordance with Generally Accepted Accounting Principles. A reconciliation of the non-GAAP financial measures to the most directly comparable GAAP measures can be found in today's press release made available on our investor website. With that, I'd like to turn the call over to PTC CEO, Jim Heppelmann.
Thank you, Tim. Good afternoon, everyone, and thank you for joining us. Our Q2 results represent another strong quarter for PTC, continuing the momentum we've built over the past five quarters. In Q2, we once again executed very well across our key strategic and operational objectives. Bookings of $95 million were $5 million above the high end of our guidance range, with strong IoT results paired with solid execution in our solutions business. On the subscription front, the 71% subscription mix for Q2 was well above our guidance of 60%. We will provide additional details on our subscription transition throughout the call. At this point, we feel our program has gained so much market traction that it was time to take the next step. We announced today our plan to transition to a subscription-only model in the Americas and Western Europe beginning on January 1st, 2018.
This decision represents an important milestone, as the effect of this change will be PTC driving toward 100% subscription mix in these geographies that represent about 70% of our business. Once again, the strong subscription mix had the effect of dampening our reported revenue results in the quarter. Nonetheless, before adjusting for the difference in mix relative to guidance, our Q2 revenue, operating margin, and EPS were all within our guidance ranges. Had our subscription mix been the 60% that we guided to, our revenue margins and EPS would each have been well above the high end of the respective guidance ranges. Lastly, the benefits of our recurring revenue model transition were on full display in the quarter with our build or on-balance sheet deferred revenue growing by $117 million sequentially.
With the key metrics so strong across the board, to use a baseball analogy, I'd say that PTC hit the ball out of the park in Q2. To summarize my color commentary regarding how our business is performing, I will again frame my discussion around the three key initiatives that we focus on to maximize long-term shareholder value. As a reminder, they are, first, to increase our top-line growth, second, to convert to a subscription business model, and third, to continue our margin expansion. Let me start by discussing progress against our growth ambition. As we outlined during our financial outlook webcast last November, our goal is to achieve sustainable double-digit growth by having our core business return to mid-single digit growth consistent with the more mature CAD and PLM market, while having our IoT business grow in the 30%-40% range consistent with the faster-growing IoT market.
That combination would create low double-digit overall growth for PTC. Against that goal, Q2 was another solid quarter with year-over-year total bookings growth of 11%, despite a tough compare against a strong Q2 overperformance last year, and it reflects solid execution in both parts of the business. In IoT, we had another strong quarter with bookings once again growing faster than the market, which we believe is growing at the 30%-40% rate. Expansions accounted for over half our bookings, and the number of six-figure deals grew by more than 60% year-over-year, primarily driven by these expansions. New bookings came from a variety of vertical markets and use cases, with the manufacturing operations optimization use case taking the lead, followed by service optimization for smart connected products.
During the quarter, we closed expansions with a large Japanese automotive OEM, a global electronics OEM, and a number of leading medical device companies. Even though these customers are generally still in the early days of their IoT journeys, they're clearly deriving value from their IoT initiatives, and they're relying on PTC to be their IoT partner. There's been a lot of buzz about augmented reality generated recently by Facebook and Snapchat. That technology is fun for consumers, but it'll be transformational for enterprises. You may not have thought of it this way yet, but if IoT brings data from the physical world into the digital world where it can be analyzed and understood, then augmented reality takes the resulting information from the digital world and overlays it back on the physical world to put it in context.
AR is not very interesting without a source of real-time digital content about the physical world, IoT and AR make a great combination together. As I've highlighted over the past few quarters, we're really excited about our new ThingWorx Studio offering, which allows authors to use drag-and-drop techniques to create dynamic AR experiences driven by live IoT content. This closed loop happens in real-time, so that by simply looking at a connected product through a smart device, you see everything you need to know about it. Essentially, we can put a heads-up display on anything using your phone, tablet, or HoloLens or other smart glasses. With the addition of Studio into ThingWorx, you can think of ThingWorx as being an IoT system with an AR front end, or you can think of ThingWorx as an AR system with a dynamic IoT content pipeline.
Enterprise customers are absolutely captivated by this powerful combination of integrated technologies. You can see it in their facial expressions during a demo. Only PTC has anything like this. The growing buzz from Facebook and Snapchat and Microsoft is great because it keeps driving interest up as enterprises ask us how to use this technology in their business. As they come to understand that AR is impractical for enterprise use cases without IoT, they end up talking only to PTC. Drafting behind the momentum created by our pilot program, which attracted nearly 2,000 enterprises so far in just eight months, late in Q1 we launched the commercial version of Studio. This tool democratizes AR for the enterprise, and we already have several million dollars of bookings for this new product under our belt, as early pilot customers have transitioned into production.
We look forward to sharing additional metrics around Studio in the coming quarters. Switching to the IoT partner front, in the quarter we announced an initiative with McKinsey to create a global network of Industry 4.0 digital capability centers. This is important because McKinsey has become the thought leader regarding the power of IoT to transform industries. Using solutions from PTC, the digital capability centers are designed to support companies at every stage of their digital transformation journey, incorporating a live production environment, digital showcases with demonstrations of Industry 4.0 technologies, as well as workshops to promote skills training and awareness of Industry 4.0. The first center opened to visitors in Aachen, Germany, on March 30th, with plans for openings in Singapore, Beijing, Chicago, and Venice to follow.
In addition to McKinsey, PTC is partnering with a variety of other leading companies across the technology landscape on Industry 4.0 initiatives, including Deloitte, HP Enterprise, National Instruments, and OSIsoft. To sum up on the IoT front, we believe that the clear leadership and market momentum we've established were again validated by our strong Q2 performance. We look forward to providing further insight into our IoT business at LiveWorx in May. Stay tuned for more details regarding LiveWorx at the end of the call. Turning now to the performance of our solutions business, improved operational execution again drove solid Q2 results. CAD led the way with double-digit bookings growth, driven by strength in our reseller channel, where go-to-market initiatives launched in fiscal 2016 continue to bear fruit. In the channel, our Get Active campaign showed strong results.
This program gives customers who are not on support one last chance to become active by moving on to subscription. We also recently launched a new channel conversion program to convert existing CAD channel support customers to subscription. There's a lot of exciting activity going on in our CAD business, and we look for continued positive results from this business moving forward. The core PLM business performed well again this quarter with bookings in line with market growth rates. Once again, PLM benefited from a strong quarter for Navigate sales. Navigate, you'll remember, is a combination of Windchill and ThingWorx technologies.
A great example of Navigate's growing traction in the market is the Q2 deal we signed with BAE Systems Australia, a longtime strategic Windchill customer, where the key value driver was the ability to create easy-to-use Navigate apps for a broad set of end users to enable access to information from multiple enterprise systems. We believe this value driver will continue to resonate across thousands of enterprise Windchill deployments in our customer base, creating a significant long-term opportunity to drive continued PLM growth. Lastly, in our solutions business, we saw some variability again in SLM, as we've seen in the past, with SLM bookings down year-over-year, primarily due to the lumpiness and timing of large deals. Let me summarize our progress relative to bookings growth. With a strong technology advantage in an exciting high-growth market, our IoT growth plans are on track.
With continued improvements in focus and execution as well as leverage of our new technologies, we're seeing continued improvements in our core solutions business. Building on the strength shown throughout fiscal 2016 and the first quarter of 2017, Q2 was the fifth consecutive quarter where we've exceeded our bookings growth targets. Naturally, our guidance takes a more cautious approach. Let me turn now to our second top-level initiative to drive shareholder value, which is our transition to a subscription model. The Q2 2017 mix of subscription bookings was once again well ahead of our guidance. We saw strong adoption in every segment, in every region, and in both our direct and indirect channels.
We're raising our full-year subscription mix guidance to 68% from 65%. With adoption in the Americas and Western Europe consistently in the mid to high 70s, we've decided to pivot to a subscription-only model in these regions by January 1st, 2018. I'll leave it to Andy to elaborate on how our subscription program is further evolving later in the call. Suffice it to say that I believe the finish line for our transition is now coming into view. Let's turn to our third top-level initiative to drive shareholder value, which is to further increase our operating margins. In Q2, our operating expenses were within our guidance range. Despite subscription mix coming in well above guidance, we nonetheless delivered operating margin within our guidance range, a testament to the consistent operational discipline you've come to expect from PTC over the last seven years.
As we look across the balance of the year, our expectation still holds that fiscal year 2016 was the trough for full-year operating margins, with an improvement of 100 to 200 basis points expected in fiscal 2017, and even more rapid margin expansion as the subscription model begins maturing and increasingly the revenue we've been deferring begins to contribute to each quarterly period. Andy will take you through the guidance details later in the call. Before I conclude, let me address the global macroeconomic backdrop. Recent PMI data has pointed to some modest improvements in sentiment in North America and Europe. In our view, it is too early for us to say that this translated into a change in buying behavior within our customer base. As of now, we believe that our recent performance has been primarily driven by improved execution.
Given the unpredictable nature of the current geopolitical environment, until we see signs of improving sentiment leading to a shift in customer buying behavior and budgets, our guidance continues to assume a somewhat mixed macro. To wrap up, PTC continues to focus on a program that has three levers to drive significant shareholder value: top-line growth, the subscription transition, and profit expansion. On the growth front, our momentum and market position in IoT highlight the tremendous opportunity in front of us, and we're encouraged by another quarter of solid execution in our core solutions business. On the subscription front, following exceptional performance in fiscal 2016, the first half of fiscal 2017 has been another strong step towards transforming our business model. On the margin expansion front, financial discipline remains one of our cornerstones as we drive toward non-GAAP margins in the low 30s post-transition.
All things considered, Q2 was another solid quarter of progress in PTC's transformation. With that, I'll turn the call over to Andy.
Thanks, Jim, and good afternoon, everyone. Please note that I'll be discussing non-GAAP results unless otherwise specified. Bookings of $95 million were $5 million above the high end of guidance. On a year-over-year basis, Q2 bookings increased 11%. For the first half of fiscal 2017, bookings were up 20% year-over-year constant currency, and 16% year-over-year constant currency organically. Strong execution drove the over-performance, but the timing of deal closures may also have benefited Q2 by a modest low single-digit million-dollar amount. Subscription comprised 71% of total bookings versus our guidance of 60%, and subscription ACV in the quarter was $34 million, well ahead of our guidance of $24 million-$27 million. The weighted average contract length remained approximately two years.
Once again this quarter, the strong subscription results contributed to a significant increase in our total deferred revenue, billed plus unbilled, which increased year-over-year by $223 million, or 34%, to $881 million as of the end of fiscal Q2 2017. In addition, as we outlined on our Q1 call, the timing of support billings, along with subscription renewals and strong new subscription billings in Q2, led to a $117 million, or 31% sequential increase in billed deferred revenue. Note that we believe total deferred revenue, billed and unbilled combined, is the most relevant metric, as there is seasonality to the timing of our recurring revenue billings throughout the year and due to the timing of our fiscal quarter ends. Subscription adoption trends were consistent with Q1 2017, where we saw strong performance in every segment, every geography, and in both our direct and indirect channels.
IoT had another strong quarter with subscription mix of 73%, despite Kepware being virtually all perpetual at this time. Essentially, all of the ThingWorx bookings were subscription this quarter. In our solutions business, SLM and PLM led the way with subscription mix in the high 70%-80% range, and CAD improved to the low 60% range, due in part to continued progress in our channel. In our direct business, subscription mix was 79%, and in the channel, subscription mix increased 1,200 basis points sequentially to 55%, led by the Americas and Europe, where over two-thirds of the channel bookings were subscription. Regionally, the Americas, Europe, and Japan far outpaced the Pac Rim, where adoption trends continued to lag the other geos. Q2 2017 subscription mix benefited from our support conversion program, and the incremental ACV from conversions drove a portion of our bookings over performance.
In the quarter, 35 customers, including some very large customers and about a half dozen larger channel customers, converted their support contracts to subscription at an ACV uplift that was once again over 50% above the prior annual support amount. We believe that the conversion opportunity within our customer base is substantial and will play out over many years as we introduce new incentive programs to both our direct and channel customers. However, you should expect quarterly variability as this program continues to ramp and mature. For conversions, I'll also remind that, one, we only include the incremental ACV in our bookings results, not the full contract value of the new subscription contract. Two, our current long-term business model does not include any assumption that our large support revenue base transitions to subscription, so this represents upside to that model.
Turning to the income statement, total second quarter revenue of $281 million was up $7 million year-over-year, the first year-over-year revenue growth in nine quarters, highlighting that we have exited the subscription trough. Compared to our guidance, we estimate that adjusting for the higher mix of subscription, our total revenue would've been approximately $291 million, which would've been above the high end of our guidance of $285 million. On a reported basis, software revenue was up 5% year-over-year. Adjusting for the higher subscription mix, we estimate software revenue would have increased 6% year-over-year. Approximately 88% of Q2 software revenue was recurring, up from 82% a year ago. Operating expense in the first quarter of $163 million was at the midpoint of our guidance range.
Q2 operating margin of 16% was within our guidance range of 16%-17%, despite the higher mix of subscriptions, due to strong bookings performance and cost discipline, and represented an increase of 200 basis points year-over-year. We estimate that adjusting for the higher mix compared to our guidance, operating margin would've been 19%, well above the high end of our range. EPS of $0.30 was at the higher end of guidance. We would've beaten our high-end guidance by $0.07 at our guidance mix. Moving to the balance sheet, cash and investments were up $68 million from Q1 2017, and total debt declined $20 million, driven primarily by cash flow from operations. Now turning to guidance for fiscal 2017. Let me remind you of some of the general considerations we've factored in.
First, we attribute our strong bookings performance primarily to improved execution. Our guidance assumes the global macro environment will remain somewhat mixed. Also, the timing of deal closures may have benefited Q2 modestly by a low single-digit million-dollar amount, negatively impacting Q3 by the same amount. Second, while subscription results have been very strong in recent quarters, it remains challenging to forecast the exact pace of our transition and the resulting impact to near-term reported financial results. Third, our FX assumptions in our guidance approximate current spot rates. FX changes since our guidance a quarter ago in total have been relatively minor. As such, do not significantly impact our full year guidance. With this in mind, for the full year of fiscal 2017, we are maintaining our bookings guidance range of $400 million-$420 million.
Excluding the $20 million SLM booking we closed in Q4 2016, in constant currency, this represents 7%-12% growth, ahead of our long-term business model presented last November. Also, recall that we just raised constant currency bookings guidance by $12 million last quarter. From a subscription perspective, we are raising our fiscal 2017 mix from 65%-68%. As Jim mentioned earlier on the call, we announced plans today to move to a subscription-only licensing model for our core solutions and ThingWorx platform in the Americas and Western Europe on January 1st, 2018. We will continue to assess market conditions and our license offerings in other regions and for Kepware, which is virtually all perpetual at this time. For fiscal 2017, we expect total revenue in the range of $1.162 billion-$1.172 billion, which at the midpoint represents 3% growth in constant currency.
This includes subscription revenue growth of approximately 130% and total recurring software revenue growth of 12% constant currency at the midpoint. We expect to increase our services margin by about 150 basis points to 18% and remain committed to a 20% services margin by fiscal 2018. Fiscal 2017 operating expenses are now expected to be $673 million-$683 million, a small $3 million increase from our previous guidance to account for FX, primarily in India and Israel, but remains flat year-over-year at the midpoint of guidance. With the increase in our subscription mix guidance to 68%, we are trimming our fiscal 2017 operating margin guidance by 100 basis points to a range of 16%-17%. This represents a 100-200 basis point improvement in operating margin over last year, reflecting our progress on our subscription transition.
On a mix-adjusted basis, we are targeting an operating margin improvement of about 100 basis points to about 28%. We are assuming a tax rate of 8%-10% for the full year, resulting in non-GAAP EPS of $1.13-$1.23 per share, based upon about 117 million shares outstanding. Reflecting the higher guidance subscription mix, this is a decrease of $0.07 for our previous guidance at the midpoint. With the 300 basis point increase in our subscription mix guidance for the year, we are reducing our adjusted free cash flow guidance by $12 million. We now expect adjusted free cash flow between $158 million and $168 million. Adjusted free cash flow excludes about $40 million of fiscal 2016 restructuring payments and $3 million of legal payments for matters previously approved in fiscal 2016.
For the third quarter, we expect bookings in the range of $95 million-$105 million, which represents growth of between -8% and 1% on a constant currency basis. I will remind you that we had very strong bookings in Q3 2016, where we exceeded the high end of guidance by $5 million and delivered 31% constant currency growth with very strong IoT performance, creating a tough comparison for Q3 2017. Also, Q2 2017 may have benefited modestly by the timing of deal closures, which otherwise we would have expected in Q3. We expect a 68% subscription mix with subscription ACV of $32 million-$36 million. We expect total revenue in the range of $288 million-$293 million for Q3, including $75 million of subscription revenue, an increase of approximately 130% year-over-year.
We expect OpEx in the range of $168 million-$173 million, and an operating margin of approximately 15%-16%. We are assuming a tax rate of 8%-10%, resulting in non-GAAP EPS of $0.24-$0.29 per share, based upon approximately 117 million shares outstanding. Before we move to Q&A, I want to update you on our stock repurchase plans. Because we believe that we have exited the subscription trough, and based upon our cash forecast, we intend to resume stock buybacks later this quarter at 40% of free cash flow. With that, I'll turn the call over to the operator to begin the Q&A. Operator?
Thank you. We'll now begin the Q&A portion of the call. Please limit yourself to one question and one follow-up. If you have additional questions, please return to the queue. Our first question is from Steve Koenig of Wedbush. The line is now open.
Hi, Steve.
Thank you very much. The operator got my name right. That's good. Great. Hey, let's see. Let me just start with a green eye shade type question for Andy here. The free cash flow guide looks like it was reduced. When I look at it relative to the prior guide, it looks like the reduction, at least on a percentage basis, is somewhat bigger than the reduction in your net income guidance or your operating margin guidance. Am I looking at that the right way? I'm just wondering why would the free cash flow be going down a little faster than net income?
Yeah. Fundamentally, it's because of, frankly, movements in prepaids and deferreds. The bottom line is the way to get to that free cash flow reduction, our rule of thumb is every point of subscription mix reduces revenue by $4 million. Every point of more subscription mix, we raised it 300 basis points. That's the $12 million. You really have to go into because of our timing, Q4 result. You know what I mean? That's the fundamental reason.
Okay, sounds good. Let me move to one for Jim here. Jim, you spoke about Studio and painted an interesting vision of the opportunity for manufacturers using AR in conjunction with IoT. Your guide obviously doesn't get that precise long term in terms of what products are in the guide, but I'm wondering, to what extent could that represent upside, and how do you think of the magnitude of the ultimate market opportunity?
Yeah, it's a good question, Steve. I think, on one hand, there's a classic definition of IoT that does not include augmented reality. On the other hand, there's a definition of augmented reality that, in most people's minds, doesn't include IoT. Personally, in the enterprise business, I think they belong together. I think that generally speaking, most forecasts for the AR market have even higher growth rates than the IoT market. If nothing else, this should accelerate either the market or our opportunity relative to the market. I think there's a huge amount of interest. Now, I think this is a much earlier market. AR is not quite as far along as IoT, and, in particular, one thing that would break the dam open would be better wearable smart glasses.
The HoloLens from Microsoft are a huge step forward, but I could think of a couple ways to improve them further. It's rumored, Mr. Zuckerberg fueled that rumor a little bit more yesterday, that there are much better glasses coming. For me, we want to be ready, because we think that the glasses are uninteresting without content to show in them. Getting the content ready and the engine to feed content into glasses, is its own project, and we want to make sure that by the time the glasses are ready, that we have an unbelievable engine to feed content into them. That's why we're pushing on it so hard. The day that you find a pair of glasses that looks like the one Zuckerberg was showing yesterday, I'm gonna be pretty excited.
I think if nothing else, this is just a tailwind to say, as this IoT business gets bigger and bigger, are we confident PTC can sustain our growth rate? This is something that ought to be helping us.
Great. Thanks a lot, guys.
Thank you.
Thanks, Steve.
Thank you. Our next question is from Sterling Auty of JP Morgan. Line is now open.
Hi, Sterling.
How you doing, guys? The CAD growth has been really consistent over the last several quarters. Where would you say that demand is coming from? Is it going up market, down market? Any particular industries in particular?
First, let me confirm, it has been double-digit growth for five consecutive quarters, which is nice. Andy maybe has a little bit more factual detail, but to me, it's down market. Our channel is doing exceptionally well.
Yes.
That's a combination of, I suppose on one hand, product improvements, more importantly, many go-to-market and operational improvements that have been implemented in the past couple of years that are starting to work really well.
Yeah. To add to that, we brought in new channel leadership about three years ago, from, frankly, our competitors, they have been maturing the channel every single year, as well as working with the channel to add more sales headcount. That's a big driver. At the same time, we refocused. You'll recall that we increased the segmentation of our sales force going after our enterprise customers to make sure we had people who were CAD sellers that were appropriate number of them to go after the opportunity there. That, I'd say, is the other effort that has driven results. It's very much, I think, an execution on the go-to-market side at this point.
Excellent. One follow-up question on the IoT space. You're talking about expansion deals for the last couple of quarters. Is there a sense of the pace of how frequently customers are coming back to buy? How penetrated is your biggest customer at this point?
Well, I'm not sure if the pace itself has picked up, but it's just that with every quarter, we have more seeds planted. What's happening is if all the seeds are maturing at the same speed, the portfolio of projects that we started through freemium and other techniques, through our land and expand model, is growing bigger and bigger. I think it's more that there are more projects, and if the hit rate is the same but against the larger portfolio of projects, we're gonna have more growth. Now, what I would say in terms of how penetrated our largest customers, there's only one or two that are penetrated to any appreciable degree.
Yeah.
We had a very large deal, I think it was last quarter. That one's a little bit more penetrated, but in general, penetration rates are exceptionally low.
Yeah. Even for our largest customers, I would say they're early in their IoT journeys.
Yeah.
If you think of where they want to be in five years' time.
That makes sense. Thanks, guys.
Thank you.
Thank you. Our next question is from Matthew Hedberg of RBC Capital Markets. Line is now open.
Hello, Matt.
Hey, guys. Congrats on the quarter. Wondering if I can get a little bit more color on the end-of-life of license. I guess I'm wondering, how should we think about additional incentives to drive existing license customer conversion to subscription contracts? I guess I'm wondering in the top 500, but also the next 1,000 customers. Should we expect to see a run on license purchases the closer we get to that deadline, or is it still too early to tell?
Let me address both. Jim talked about the fact that we're introducing new conversion programs. As we've been mentioning over the last couple of months, we were doing conjoint market and pricing analysis to identify, frankly, how could we provide something in our subscription offer that was of value to customers, and we did that both separately for the channel and our enterprise customers, very much focused actually on CAD for the channel. Those studies came back that there is a substantial opportunity for both. In the channel program, what we found was that there were basically four modules that we don't sell very much of, that customers would be willing to convert to subscription and pay a premium over what they've been paying for maintenance, if they had the option to get three of four of those. You're going to see a program.
We're not introducing a stick program for the channel. It's all carrot. You're going to see a program where you get the benefits of subscription, the flexibility, things like that. You get these technical capabilities, these modules that they didn't have before. You can take any three of four, for that, the study shows we should get 15%-25% more, that frankly, more than half our channel customers would be interested in that over time. In the enterprise space, where we don't have a stick, we also did some pretty sophisticated pricing studies. What we found was that customers actually want a conversion program that's a good, better, best program. In the good program, they'd be willing to pay 15% more than their maintenance.
They don't get restack, so that would be perfect if you have the perfect configuration of software today, but you get the other flexibility benefits. You get remix and things like that. In the better program, at a 25% premium, you get improved customizable e-learning. You get a higher level of support, advanced support, I think we call it, and you get restack, and that's worth 25% more for them, like for like. There's a 35% best program where you frankly get an even higher level of support and a higher level of e-learning and a few other things. You'll see us introduce a good, better, best conversion program for our enterprise customers where we don't have a stick. One thing I will share, though, in that one, just under half were interested today in a conversion.
There are still customers who are afraid that if they give up their perpetual license, then they're going to give something up. I think that'll change over time, but that's where it stands today based upon our market studies.
Can you hit the second question about whether we might see a perpetual buy
We know that others have seen a perpetual buy right at the end, so we could see one, which of course would mean in that quarter, it could mean our subscription mix is a little bit less, but frankly, that's fine.
Got it. Maybe just one quick one. Deferred revenue, I believe you said it increased by $117 million, and that's what we see on the balance sheet. On the cash flow statement, it looked like it was up $39 million sequentially. I'm wondering, am I reading that right, or why the discrepancy between cash flow and balance sheet?
Actually, number one, there's technical rules about how you do a cash flow statement, that things don't always tie to the balance sheet. The other reason there is, we disclose this in our 10-Qs, that back in, I think it was the '90s, the company, they would have a DSO metric that was reasonable. DSO is, you take your daily revenue, take your revenue, divide by the number of days, and that's your denominator, and your numerator is your AR. Because there was so much deferred revenue that was still in AR, it would make AR look like it was this ridiculous number. To get an apples to apples, what they did was they take that deferred revenue amount, and they move it out of AR into other assets.
Frankly, the bottom line is, what you see on the cash flow statement is the cash impact in deferred revenue in the quarter. There's a big piece of it that isn't collected yet. You know what I mean? It's still sitting in receivables. In this case, it's sitting in other current assets. The other option we could've done, back 20 years ago, was we could have actually added the deferred revenue to the revenue and divided by 91 days in a quarter to get a daily basis and compare that to receivables. It was all meant to get an apples to apples comparison. You get the same DSO number pretty much no matter how you do it. Anyway, we can take it offline, it's a complicated thing the company's been doing for 20 years.
20 years. Matt, I want to thank you for asking Andy that question. Not me. All right. Who's next?
Thank you. The next question is from Kenneth Wong of Citi. Line is now open.
Hello, Ken.
Hey, guys. How's it going? Building a bit on Matt's question on the end of perpetual, you mentioned maybe some pull forward on just perp licenses next year at the beginning, I guess how should we think about that 85% target for the year? Do you feel that that has kind of upward bias or downward bias because of this new program?
I'm going to punt on giving you anything. That's our current target that we laid out in November. We haven't done our business planning for next year. Kepware is the one area where we've not gotten subscription traction. Given the fact that despite our attempts, people still buy all perpetual, for the most part, we're actually recently commissioned some more studies around subscription with Kepware, how could we bundle, how could we price. Until we really understand Kepware, that's 5%, 6% of our bookings. That's one piece there.
Could I add, Ken, that January 1st, of course, is the end of the fiscal first quarter of the next year.
Right.
To the extent that it was a pre-buy, it would probably more likely happen in Q1 of 2018.
Yeah
than Q4 of 2017.
Q4. Figuring how that might impact as well. At this point, you should assume 85% clearly with an upward bias over time, over the long term, very gradually, asymptotically approaching a higher number. The thing I'll highlight this quarter, again, 88% of our software revenue was recurring in the quarter we just had.
Got it. Then a question on just the total deferred. I think we have a good history of what bill deferred trends like in Q3, give or take the client of mid-single digits. We think about total deferred, should it map to what we've seen historically on the bill deferred, or does that have-
We expect it to grow in the double digits year-over-year, every quarter moving forward.
Got it.
Thank you.
That's a good answer.
Thank you. Our next question is from Ken Talanian of Evercore ISI. Line is now open.
Hi, guys. Thanks for taking the question here. I just wanted to touch on guidance. You've held your license and subscription bookings guidance for fiscal 2017 constant, essentially since 4Q 2016, despite the beats in the first half of the year. As you look out to the second half, high end of your guidance for 3Q is flattish year-over-year. I understand it's a tough comp, and then I understand that 4Q should also be down based off the large deal. Was just curious, what are the key reasons you might exceed your guidance, and how do you view your second half pipeline versus what you're seeing in the first half of this year when you guided in 4Q?
First let me address something in your question that you might have missed. Last quarter, we held our top line bookings guidance of $400 million to $420 million against a stronger dollar. That actually was a $12 million increase we did last quarter to our guidance in constant currency, because otherwise we would've had to lower guidance. We actually held it, which means in constant currency, we effectively raised guidance by $12 million. This quarter, we didn't raise guidance. We were $5 million over our high end, but there was probably $2 million that was, by our estimate, stuff that we had expected in Q3. That's really a flip between the two. That's kind of where we are at this point, given what we've done with our guidance.
When you look at second half growth, it is going against really tough compares, even if you exclude the SLM deal. Last year we grew 31% in Q3. Just to be flat, we've guided down eight plus one, just to be roughly flat is huge against that number. In fact, if you look at last year.
If you think of it from a CAGR perspective, you're talking about 15% CAGR over the two years.
Over two years, yeah. You'll recall we had a mega deal in the third quarter, and that we sequentially grew bookings by $19 million from Q2 to Q3 last year. That's a challenging comp. When you actually get to Q4, you'll see if you exclude that SLM deal, behind of our guidance is 9% growth, and it was a really strong Q4 even excluding the SLM deal. In fact, I think the total growth in Q4 last year without that was still in the low 20% range.
Yes.
We're not saying we're a 20% growth company. We're saying we're a low double-digit bookings growth company. We think our guidance is appropriate. If you actually look at the linearity in the quarters that we're laying out here, it makes a lot of sense. The macro still seems mixed to us. We always base our guidance on our pipeline and our analytics around the pipeline. We don't get ahead of our skis there.
Okay, great. Just as a follow-up, obviously you've accelerated the transition to a greater percentage of your business coming from subscription. I'm curious, how should we think about your path towards your fiscal 2021 free cash flow targets given this accelerated plan?
Well, first off, the end result, clearly we have not come off the 85% yet, okay? I want to make sure you're clear on that. Stay tuned for as we exit this year, and we've done our business planning, and we'll give you the best guidance we can. More subscription is always better for our business model, but we also have to be realistic. You can go back to the Adobe space and still have some perpetual revenue. We're not coming off that. Clearly, though, our bookings that we're guiding to right now at 7%-12% constant currency bookings growth is more than we included in our November guidance. Or not guidance, but our November business model-
Outlook. Yeah
outlook that we gave for the long term. It's very helpful. Because this business is subscription, the compounding or stacking benefit helps the next year and the year after that. The net I would say is, this year certainly seems to give us confidence in that long-term model that we've laid out there, which certainly has an attractive free cash flow number, attractive EPS number by 2020 and 2021.
Agreed. Thank you very much. That helps.
Thanks, Ken.
Thanks, Ken.
Thank you. Our next question is from Saket Kalia of Barclays. Line is now open.
Hello, Saket.
Hey, guys. How you doing? Thanks a bunch for taking my questions here. Let's start with the end of perpetual. Since it's regionally focused, again, Americas and Western Europe, and we're excluding Kepware, can you give us a sense for maybe historically, how much perpetual revenue would essentially be rerouted from the income statement? Then what would that bookings impact be? Is that a net neutral on bookings, or could that be a smaller deal size? Just any color on those mechanics.
Okay. Those two geos are Americas and Western Europe are about 70% of our bookings historically. Is that what you were looking for?
Yep.
Okay, good. We're still assessing the other geographies. That's the key thing. Kepware is a good example. We haven't gotten traction there, but we're not giving up. We're going out there trying to figure out what is really going on in that market. The competitors don't offer subscription. Is there value customers want, and can we make sure to bundle that for them? What we did do with Kepware, since we acquired them, is now you have to buy support when you buy Kepware. They used to hardly ever sell support. Now there's 100% attach rate to support. We're basically doing our work to understand what could we do there. Frankly, what could we do to monetize the customer and grow the business more effectively? That's really what our objective is. Subscription is a way that works in the rest of the business.
We'll figure out if it works for Kepware. Other things that we are also looking at is as Kepware is integrated with other parts of ThingWorx, it's sold subscription.
Right. The corollary around that was, I guess 70% of perpetual sort of gets rerouted. Would that be a net neutral to the license and subscription bookings metric? Just any color there in terms of how that might change once you end of life perpetual?
Our customers have demonstrated they want to buy subscription, so I don't think it's going to change demand for our products in the marketplace other than the fact that what we've been hearing from our channel partners is it's actually easier to sell. The hurdle's lower. Customers tend to buy more because they're paying in monthly payments as opposed to writing a big check up front. All the reasons why subscription or cloud has done well broadly in software apply to us, and we've certainly seen, for example, in conversions, where people do a conversion, the value of that flexibility is worth something to them. On top of it, they buy some more at the same time. Often, the incremental buy is bigger than the uplift for just the conversion. I think there's a help there.
The one thing we have highlighted is, with subscription, people tend to do land and expand. Like this quarter, the amount of business from large deals was actually just below that 30%-50% metric we'd said previously as far as what percentage of our bookings come from large deals over $1 million. It was actually just below that. The strength this past quarter was just very broad business strength across geos, across products, across.
Channels
healthy channels with healthy deal sizes.
Yeah. Another way to think about it, Saket, is the % subscription in Americas and Europe already is, let's call it upper 70s. Rather than aiming from upper 70s to mid-80s, we would be aiming for, I don't know, mid-90s, let's say.
Yeah.
Right? There's not that much runway left here, actually, we're going to try to just eke out the last chunk of it and not settle at 85 but push on, because in a perfect world, if we could get to 100, I think everybody on this call would be happy with that.
Sure. If I could just ask a follow-up. Can you just talk a little bit, obviously, deferred revenue and unbilled kind of in focus. Can you talk about the mix between those two, Andy, in terms of bill deferred versus unbilled and how that might change, if at all, in your long-term model?
I'll be honest, I haven't thought about that because I don't think it's that very important, to be perfectly frank. The key thing is right now, customers, as I mentioned, the average length of a contract remains about two years. We don't want to sign contracts that are more than three years. You could see a little lift in that toward something above two. Many companies I'm aware of have something in that two, four, two, five average term. We actually made it challenging for our channel to sell more than one-year subscriptions in the past, just from an operational perspective. I would think that's going to float up a little bit, but we still bill just one year in advance. That's going to make the unbilled piece be a little bit bigger if that floats up. We basically bill annually. We're not changing that.
That's the norm.
Right. Got it. That's it for me. Thanks a bunch, guys.
Thanks.
Okay. Thank you.
Thank you. Next question is from Monika Garg of Pacific Crest. Line is now open.
Hello, Monika.
Hi.
Hi. Thanks for taking my question. First follow-up on the last question. Given your peers, and especially in the European markets, are still offering perpetual license, and you're talking about discontinuing perpetual, maybe could you give some examples? Have you talked to channel or your customers, and any risk you see losing your customers to your peers?
I don't believe we have any risk that we're going to lose customers due to peers because we sell our software from a subscription perspective. I'll give you just a few data points. One thing we did before we made this decision was we actually went out and surveyed all of our channel partners. Took that feedback to make sure they were ready, that they felt heard, that they felt their customers were ready, and it came back tremendously positive. They love the subscription model. One of the interesting things was they actually highlighted that the cash flow challenge that we all hear about, they figured that out, and they're managing it. Now, of course, our channel partners, different from some other companies, had a much bigger recurring revenue base to start with. That helps them get through that. It's very positive.
The one thing they do want, they rate themselves that they could be better at selling it. We took note of that immediately, and they're in at LiveWorx, and there'll be a whole lot more sales enablement for their people about how you actually can sell subscription more easily and sell through any perpetual objection that someone might have. I think it benefits us as opposed to hurts us. Because again, think about it. Our channel partners, you can do one thing really well. If you try to do two things well, you'll probably do both of them not very well. Here they will become expert at selling subscription, and they don't have to figure out how do I handle the. I can simply say, we don't sell perpetual, we sell subscription, and end it there.
They're not trying to be good at two things at once.
I think the key point is with technologies like CAD and PLM, which are fairly complex, mission-critical enterprise technologies. The technologies you select, particularly if you're buying more, there's no way you're going to switch based on a pricing model. The switching costs are dramatically higher than the price of buying more with a different model. I think when you look around, particularly if you go out and look at new technologies, they're all subscription anyway. I feel like Andy's right, that there's not a lot of risk here. Again, the market is telling us now that the vast majority of people, given the choice, are going to go that way. The vast majority of new products coming to market are subscription.
It feels like the snowball rolling down the hill here on subscription has gotten so big that every passing quarter, there's fewer people complaining about it.
The only other thing I'll say is I Googled. I've read some reports from some of you about one of our competitors where some of their customers are vocally not liking their change. However, I Googled Adobe and around their end of life of perpetual, the kind of noise from their customer base looks exactly like what you're seeing around Autodesk, and yet it certainly worked out well for Adobe.
Yeah, that was 2013 when you wouldn't believe how everyone said they were going to drop it and so on.
It slowed Salesforce down and some of those.
No. Yeah.
Yeah. Thanks for the details. Then just a follow-up, Andy, on revenue recognition, ASC 606.
Could you update us? Do you expect any impact on revenue recognition from that? Thanks so much.
Yeah. First off, remember it affects us for fiscal 2019, not fiscal 2018. We're nine months behind everyone else. We're continuing to do our analysis to figure out what our conclusions are around 606. We haven't finished, so I can't tell you what our conclusions are yet. When we do, probably, I would guess in our Q3 10-Q would be when we first disclose and have a conclusion around 606. The one thing I will share with you is that the SEC did open the door for at least staying ratable on an annual basis when they introduce a time element to determining how you recognize revenue. That is clearly an option for us if some of the other ways that other on-prem software companies or other software companies are trying to get there.
If those don't seem to work for us, we have that other option available as well.
Got it.
I want to remind you, we chose to be a subscription company because it's how our customers want to buy. They value it. Since they value that and we're giving them something they value, we monetize those customers more effectively. That's why we did it. Being ratable is certainly something we would like to continue, at least on an annual basis, because it makes it easier for you to understand our results. We would certainly like to stay ratable, and that's where our desire is.
Yeah, the primary benefit is a better business model for us and our customers. The secondary benefit is ratable revenue. Even if there's questions on the second part, the primary part still holds.
Yeah
we're going to do what we can to keep the ratable stuff in place. All right. Operator, do we have any more calls?
That's the last question in queue. Please stay on the line. We'll turn it over back to Jim Heppelmann to close out the call.
Yeah, great. Okay. Thanks, operator. I want to thank everybody for joining us on the call and spending a fairly long call with us here this afternoon. Again, I think if you step back and look at our results this quarter, it's pretty clear that across our three strategic missions of driving up the growth rate, driving up profitability, and converting to subscription, we're making great progress. The last thing I want to say is talk a little bit about LiveWorx. Tell you about it and encourage you to attend. LiveWorx is a unique opportunity to hear from a wide variety of industry thought leaders and to get hands-on experience with lots of technology and software applications. Then to network with more than 6,000 projected customer and partner attendees.
The focus of the event is on the convergence of physical and digital worlds and the opportunities that are unleashed by that convergence in product design, manufacturing operations, and improved service. LiveWorx will be held in Boston from May 22nd to 25th at the very large Boston Convention and Exhibition Center, not far from the airport at all. We're going to have an investor session on Tuesday, May 23rd, during the event, and we hope that you're able to join us. If you'd like to join us, of course, reach out to our IR team, and they'll help you with the registration details. We hope to see you at LiveWorx, and if not, at another investor event or on the call in about 90 days again. Thank you very much. Bye-bye.