Hello, everyone, and welcome to today's Tyler Technologies 4th Quarter and Year End 2017 Conference Call. Your host for today's call is John Marr, Chairman and CEO of Tower Technologies. At this time, all participants are in a listen only mode. Later, we will conduct a question and answer session and instructions will follow at that time. As a reminder, today's conference call is being recorded today, February 22, 2018.
At this time, I'd like to turn the conference call over to Mr. Maher. Sir, please go ahead.
Thank you, Jamie, and welcome to our Q4 2017 earnings call. With me on the call today are Lynn Moore, our President and Brian Miller, our Chief Financial Officer. First, I'd like for Brian to give the Safe Harbor statement. Next, Lynn will have some preliminary comments. Then Brian will review the details of our 4th quarter results and 2018 guidance.
Then I'll have some final comments and we'll take your questions.
Thanks, John. During the course of this conference call, management may make statements that provide information other than historical information and may include projections concerning the company's future prospects, revenues, expenses and profits. Such statements are considered forward looking statements under the Safe Harbor provision of the Private Securities Litigation Reform Act of 1995 and are subject to certain risks and uncertainties, which could cause actual results to differ materially from these projections. We would refer you to our Form 10 ks and other SEC filings for more information on those risks. Please note that all growth comparisons we make on the call today will relate to the corresponding period of last year unless we specify otherwise.
Lynn?
Thanks, Brian. We are pleased with our results for the quarter, which provided a strong finish to 2017. We returned to double digit revenue growth for the quarter with total GAAP revenue growth of 13% and non GAAP revenue growth of 12%. We also achieved solid margin improvement as our non GAAP operating margin rose 120 basis points to a new high. License and royalties revenues also reached a new high and exceeded $20,000,000 for the first time ever.
Subscription revenue was once again strong, growing 26%. Total recurring revenues from maintenance and subscriptions grew 14% and comprised 64% of total revenue. Bookings for the quarter were very strong, up 37%. For the year, bookings grew 15% compared to 2016 and our quarter end backlog grew 18% to just over 1,100,000,000 dollars Bookings were robust under both our license and subscription models, but as expected, our new business mix in the 4th quarter shifted back toward a higher proportion of license deals than in the second and third quarters. Subscriptions represented about a third of the total new software contract value in the 4th quarter.
The mix was impacted somewhat by a large statewide ODiSI contract as well as seasonally strong bookings for our public safety solutions, which are typically on premises license deals. Our largest new license deal of the quarter was the statewide Odyssey Courts and Justice Software contract with the State of Kansas Judicial Branch valued at approximately $21,000,000 including a multiyear maintenance agreement. This represents our 14th statewide Odysee arrangement. Other significant on premises license deals signed during the quarter, each with a total contract value of $1,000,000 or more, included multi product arrangements with Marion County, Florida for our Munis, EnerGov and Executime solutions, Norman, Oklahoma for our Munis and ENCODE solutions, Fredericksburg, Virginia for our Munis, IS World, EnerGov and Executime solutions and Henry County, Georgia in the Atlanta metropolitan area, which signed contracts valued at $3,600,000 for our New World Public Safety, Brazos and SoftCoat solutions as well as our Munis and Enerdev solutions. We had a very active quarter in the public safety market with the highest quarterly total contract signing since we acquired New World in 2015.
Significant New World public safety license deals included the cities of Orlando and Tallahassee, Florida Elk County, Pennsylvania and Clayton County, Georgia located in the Atlanta area. Clayton County also signed a significant license contract for our EnerGov solution and the Visalia Unified Schools District in California signed a major new contract for our Munis ERP solution. Significant new SaaS contracts in the quarter included multi product deals for our Munis and EnerGov solutions with the cities of Wilmington, North Carolina and Wellington and Riviera Beach in Florida. We also signed notable SaaS arrangements with Fontana, California and Muskogee Creek Nation in Oklahoma for our Munis ERP solution and with Addison, Illinois for our New World ERP solution. Finally, we signed a 5 year $13,000,000 extension of our statewide e filing contract with the State of Oregon, which is converting to a fixed fee arrangement.
Now, I'd like for Brian to provide more detail on the results for the quarter and provide our annual guidance for 2018.
Thanks, Lynn. Yesterday, Tyler Technologies reported its results for the Q4 ended December 31, 2017. I'm going to provide some additional data on the quarter's performance and provide our annual guidance for 2018, then John will have some additional comments. In our earnings release, we've included non GAAP measures that we believe facilitate understanding of our results and comparisons with peers in the software industry. These measures exclude write downs of acquisition related deferred revenue and acquired leases, share based compensation expense, employer portion of payroll taxes on employee stock transactions and amortization of acquired intangibles.
A reconciliation of GAAP to non GAAP measures is provided in our earnings release. We've also posted on the Investor Relations section of our website under the Financials and Annual Report tab schedules with supplemental information provided on this call, including information about quarterly bookings, backlog and recurring revenues. GAAP revenues for the Q4 were $217,900,000 up 12.7%. On a non GAAP basis, revenues were $218,100,000 up 11.8%. Subscription revenues for the quarter increased 26.1%.
We added 83 new subscription based arrangements and converted 19 existing on premises clients, representing approximately $44,400,000 in total contract value. In Q4 of last year, we added 61 new subscription based arrangements and had 6 on premises conversions, representing approximately $18,400,000 in total contract value. Subscription clients represented approximately 42% of the number of new software contracts in the quarter compared to 30% in the prior year quarter, while subscription contract value comprised 33% of total new software contract value signed this quarter compared to 19% in Q4 of last year. The value weighted average term of new SaaS contracts this quarter was 5.8 years compared to 5.6 years in last year's Q4. Transaction based revenues from e filing and online payments, which are included in subscriptions, increased 28.2 percent to $16,300,000 from $12,700,000 last year.
That amount includes e filing revenue of $12,500,000 up 29.8% over last year. The growth in e filing revenues was primarily driven by the ramp up of e filing and research solutions in Illinois. Annualized total non GAAP recurring revenues for the Q4 were $563,000,000 up 14.2% from last year. Our GAAP effective tax rate was significantly impacted by the enactment of the Tax Cuts and Jobs Act signed in December, mainly due to the remeasurement of our deferred tax assets and liabilities at the new corporate tax rate, which reduced our tax provision for the year and the quarter by approximately $21,600,000 and reduced our full year tax rate by 13.4%. In addition, our GAAP tax rate includes significant excess tax benefit from stock option exercises, which reduced our tax provision for the year company with nearly all of our operations in the U.
S, we expect that our effective tax rate going forward will reflect a significant reduction as a result of the new lower federal tax rate. Cash flow from operations was $53,400,000 compared to $51,800,000 last year, up 3%. Free cash flow, which is calculated as cash from operations less CapEx, was $48,100,000 up 10.2%. Our CapEx for the quarter was $5,300,000 including $4,900,000 related to real estate compared to total CapEx of $8,200,000 in Q4 of last year. Cash flow for the quarter was negatively impacted by the timing of milestone billings associated with certain large contracts, which resulted in a higher than normal level of unbilled receivables as well as by higher federal tax payments that resulted in a higher prepaid tax position at year end.
We ended the quarter with $249,700,000 in cash and investments and no outstanding debt. Days sales outstanding in accounts receivable was 94 days at December 31, 2017 compared to 93 days at December 31, 2016. In Q4, we repurchased 2,600 shares of our common stock at an average of $169.93 per share. For the full year 2017, we repurchased 44,496 shares of our common stock at an average of $148.62 per share. Our backlog at the end of the quarter was a record $1,100,000,000 up 17.6%.
Software related backlog, which excludes backlog from appraisal services contracts, was 1,100,000,000 dollars an 18.4 percent increase. Backlog included $279,900,000 of maintenance compared to $242,700,000 a year ago. Subscription backlog was $459,200,000 compared to $364,100,000 last year and includes approximately $148,000,000 related to fixed fee e filing contracts. Our bookings for the quarter, which are calculated from the change in backlog plus non GAAP revenues, were approximately $290,000,000 an increase of 36.8%. For the trailing 12 months, bookings were approximately $1,000,000,000 a 14.8% increase, which is a new annual high.
A new metric that we're now providing is the annual recurring revenues of new software subscriptions. Our software subscription bookings in the 4th quarter added a total of $7,100,000 in new annual recurring revenue, up 155.5 percent from $2,800,000 last year. For the full year, we added $24,900,000 of annual recurring revenue from software subscriptions, up 61.1 percent. For comparison, if all of our new subscription contracts had been under license arrangements, we estimate that they would have represented additional license bookings of approximately $7,800,000 for the 4th quarter and $33,000,000 for the full year. We signed 48 new contracts in the 4th quarter that included software licenses greater than $100,000 and those contracts had an average license of $468,000 compared to 57 new contracts with an average license value of 406,000 in the Q4 of 2016.
Our guidance for the full year of 2018, which reflects the preliminary estimated impact of the adoption of ASC 606 effective January 1, 2018 is as follows. We expect 2018 GAAP revenues will be between 912,000,000 dollars $928,000,000 and non GAAP revenues will be between $913,000,000 $929,000,000 We expect 2018 GAAP diluted EPS will be approximately between $3.65 $3.75 and may vary significantly due to the impact of stock option exercises on the GAAP effective tax rate. We expect 2018 18 non GAAP diluted EPS will be approximately $4.73 to $4.83 For the year, estimated pretax non cash share based compensation expense is expected to be approximately $49,000,000 We expect R and D expense for the year will be approximately $58,000,000 to $60,000,000 Fully diluted shares for the year are expected to be between 40.040.5000000 shares. GAAP earnings per share assumes an estimated annual effective tax rate of 11 percent after discrete tax items and includes approximately $26,000,000 of discrete tax benefits related to share based compensation, which may vary significantly based on the timing and volume of stock option exercises. We estimate the non GAAP effective tax rate for 2018 will be approximately 24%.
This rate was reduced from 35% for 2017 to reflect the enactment of the Tax Cuts and Jobs Act. This rate is based on Tyler's estimated annual GAAP income tax forecast adjusted to account for items excluded from GAAP income in calculating Tyler's non GAAP income as well as significant non recurring tax adjustments. The non GAAP tax rate used in future periods will be reviewed periodically to determine whether it remains appropriate in consideration of factors, including Tyler's periodic effective tax rate calculated in accordance with GAAP, changes resulting from tax legislation, changes in the geographic mix of revenues and expenses and other factors deemed significant. We expect our total capital expenditures will be approximately $22,000,000 to $25,000,000 for the year. Total depreciation and amortization expected to be approximately $59,000,000 including approximately $35,000,000 of amortization of acquired intangibles.
The actual impact of ASC 606 is obviously subject to a number of variables and uncertainties, including the mix and timing of new contracts and specific terms contained in individual contracts. For comparison purposes, under the prior ASC 605 basis, our guidance for 2018 would be as follows. GAAP total revenues would be expected to be in the range of $918,000,000 to $934,000,000 Non GAAP total revenues would be expected to be in the range of $919,000,000 to $935,000,000 GAAP diluted earnings per share would be expected to be between $3.75 $3.85 and non GAAP diluted earnings per share would be expected to be between $4.81 $4.91 Now, I'd like to turn the call back over to John for his further comments.
Thank you, Brian. This was another very strong quarter for Tyler and we're pleased that we reached the high end of our earnings guidance with our highest quarterly non GAAP operating margin ever. For the year, we exceeded the upper end of our initial guidance earnings guidance even as we faced a significant revenue headwind with a higher than expected level of subscription in our new contract mix. Looking back at 2017, we're particularly pleased with the progress we made in the public safety area. We significantly expanded our presence in the market with the New World acquisition in late 2015.
In 2016, we laid the groundwork for that business, investing in the client support organization, developing a strong roadmap for Tyler Alliance in our integrated public safety and courts and justice solution and strengthening our sales organization and processes. Those efforts showed tangible results in the market in 2017. We are progressing very well with major development projects that are adding features and functionality to strengthen our competitive position and enable us to compete effectively at the upper end of the public safety market. The market is viewing our strategy prop positively. Although growth in our public safety division was well below our blended company rate in 2017, our public safety win rates and the number of new clients added during the year more than doubled.
We also have had success in selling additional Tyler solutions, such as our Brazos eCitation solutions into the New World client base. The public safety space has a number of good competitors, but we have a focused long term strategy and we believe Tyler has unique advantages that will enable us to continue to build momentum and accelerate growth in the coming years. Public safety is certainly not the only area of our business where we're investing at a high level in product development initiatives. As we outlined at the beginning of last year, we ramped up our R and D spend on a number of projects company wide in 2017 and R and D expense increased approximately 10% to $47,300,000 in 2017. As we've previously discussed, we have an ongoing white space analysis through which we identify gaps in our product suites and prioritize opportunities to improve the competitiveness of our products, broaden our offerings and expand our addressable market.
In many of these cases, we consider versus buy scenarios. While we continue to pursue strategic acquisitions in many M and A processes, especially those that are banker led, we're seeing transactions take place at valuations that are often well in excess of the levels we consider reasonable. We always expect to pay fair prices for acquisitions, but over the years, we believe we've exercised discipline and patience when it to making the right decisions on acquisitions. Our cash flow is robust and growing and will be enhanced by the reduction of our tax rate starting this year. In addition, with the completion of the expansion of our Yarmouth office, our 2018 capital expenditures will be approximately half of the 2017 level.
Our balance sheet is extremely strong with $249,700,000 in cash and potential to help drive growth and achieve our product objectives and we've made the decision to incrementally increase our discretionary investments in internal product development. As Brian noted in our guidance, we plan to increase our R and D expense by 23% to 27% in 2018 to a total of between $58,000,000 $60,000,000 While the incremental spend is small relative to our cash flow, all of our software development is expensed, so the short term earnings effect is more meaningful. These discretionary investments span our product suites, including ERP, planning, regulatory and maintenance, courts and public safety. Some of these projects will add features, functionality and technology to enhance our current products and improve our competitive position. Other projects will broaden our offering with new products that will drive new revenue streams.
In addition, we are adding resources to our enterprise development group, which focuses on Tyler wide development initiatives that further our Connected Communities vision. Our singular focus on the public sector help having a deep understanding of our market, anticipating client needs and innovating through long term vision such as Connected Communities have been Tyler's strength for many years and we're confident in our ability to continue to make both organic and external investments that will further our strategy and drive long term success. We have a solid plan for 2018. There is some noise around the numbers with accounting changes from ASC 606. Looking at our 2018 guidance under ASC 605 accounting comparable to 2017, our non GAAP revenue growth is just over 10% at the midpoint of our range and our GAAP EPS growth at the midpoint under 605 is 24%.
We look forward to building on our 4th quarter with an acceleration in revenues and earnings growth, while ramping our R and D investments to drive future growth. Now, Jamie, we'll take questions.
And our first question today comes from Kirk from Evercore ISI. Please go ahead with your question.
Thanks very much. John, I guess the first question I had is for you just on the R and D increase. It seems like it's somewhat opportunistic for you guys to sort of try to take advantage of your position in the market and the fact that things are going well. But I'm just kind of curious, is this the new sort of norm, this level of spend on an absolute dollar basis? And should after we up level this year, should that sort of should the incremental growth in R and D sort of normalize back to be in line with revenue or potentially slower than revenue growth as we think about 2019?
It's a great question, Kirk. And it's kind of hard to answer just because we don't want to handcuff ourselves going forward. I appreciate that now for a couple of years, we've talked about incremental R and D spend that's discretionary and widens the moat in terms of our leadership position and at the same time identify some new opportunities and broadens our addressable market. That happened last year and we're reinforcing and maybe even raising the bar a little bit this year. I generally believe what we're doing is moving investments that could happen over a longer period of time forward and adding heads.
We certainly added a lot of heads last year of public safety that could have been done over a longer period of time, but we felt we were in a position to make those investments and we felt they were important to do. In this year, we've identified similar opportunities across the suite of applications that we think are very good investments for us to make. You combine that with looking at the market today and as you said being opportunistic and we're not buying a lot of our stock back. We're not doing a lot of M and A. That certainly could change at any time.
But we're in a very strong position to make these investments and we think it's the right thing to do. It'd be my expectation that again these are moving headcount and investments forward and will create some lumpiness in the R and D spend and that we'll grow into it and we'll achieve the same margins that we've always expected to. But I'd be cautious because if we see great opportunities in the future that we believe deserve funding, then we'll fund them. So again, it's a very good question and we'll certainly be as transparent as we can be going forward. We certainly see higher margins and we believe they're completely available to us today, but we think these are the right investment levels for Tyler to have at this point in time.
Okay. And then thanks for that answer, John. And then for Brian, just how should we think about the tax, the lower tax rates against sort of your cash flow, meaning are there any obviously the EPS is going up based on a lower sort of non GAAP tax rate. Does that flow directly through to the cash flow number? I guess, I'm just trying to get a sense on how you should think about sort of operating cash flow growth next year.
Yes, the reduction in the tax rate generally does flow through the cash taxes. So that starting point of going down from roughly 35% 24% before the discrete items from stock option exercises, which is a less predictable number, but it's also a cash number, should flow right down to our cash tax provision as well.
Okay. So should I think about operating cash flow growing roughly in the same range as EPS year, is that a fair way or a decent starting point?
Yes, I'd say that's a pretty decent starting point.
Okay, great. Thanks guys. Our next question comes from Brian Kinstlinger from Maxim Group. Please go ahead with your question.
Great, thanks so much. Good morning. Can you talk about your top 2 or 3 priorities in terms of product set that you plan to deploy the increased R and D budget?
Well, this year, Brian, different than last year, I would have answered public safety obviously that we elevated that specifically and the elevation there was disproportionate to other areas, although there were again a number of discretionary heads added across the other areas as well. This year, it's broader. So I can't give you 2 or 3 that stand out. It's definitely spread out across most of our primary applications. Fair amount happening at Munis and those are across the board, features functions, technology and innovation really all across the board.
So there aren't 1 or 2 lead projects. It's really a distribution ahead across the different applications that we think all makes sense.
Great. And then my second question is, you mentioned bookings for Public Safety were the strongest since acquiring New World and that I think you doubled the number of client wins and your win rate. So how far along are you in the process of improving the competitive positioning, being able to bid on larger contracts and having a more consistent win rate as opposed to maybe this is 1 quarter, maybe 2 quarters of solid wins?
The first result is improved win rates in the traditional market and we've already seen that. They actually are pretty consistent win rates. It's really been about 3 quarters now that we're seeing something in 50% to 100% improvement in their win rates. And so that's we're cautious to believe whether or not that's sustainable, but certainly those results are very encouraging. The second phase of that is to broaden the addressable market space, namely moving up into larger jurisdictions and that's a process.
We don't all of a sudden set the bar at jurisdictions that are several times the size we've traditionally been competitive. We'll gradually grow into that space and that's happening. I think we'll see you'll never know for certain which deals you would have or not wouldn't have not would have won historically, but I think we'll see deals in the first half of this year that will reflect a more competitive position in the larger jurisdictions.
Great. Thanks so much.
Our next question comes from Alex Zukin from Piper Jaffray. Please go ahead with your question.
Hey, guys. Thanks for taking my questions. First, a couple questions just on the guidance. Kind of on the same track as the previous question for public safety, can you talk about what your guidance for 2018 implies for growth in that business versus the corporate average and kind of compare that to 2017 as well?
It will again be modestly below the blended Tyler rate. So the win rates, the experience in the marketplace are still somewhat leading indicators, but those manifesting themselves in the P and L to back it up are still a little ways out. So we anticipate that Public Safety's actual recognized revenue this year will again be modestly below the overall pilot blended rate.
And Alex, this is Lynn. And just to supplement that, I think there were still some headwinds coming out of the acquisition that are being overcome by that have been overcome by our Public Safety division. And I think when you see that sort of has an impact as well on the slightly below Tyler rate. But we expect that in the future to catch up and accelerate and be in line or actually help drive the growth rate going forward.
And I guess what type of indicators are you guys looking for? Because you're talking about over the next couple of years for this rate to be well potentially the corporate average. So what do you need to see or has anything changed over the last 3 or 6 months to kind of influence that opinion?
Well, it takes a while. It's taking probably we're probably looking at 3 years by the time we're done from the beginning, so through this year, but things to kind of settle out. So when we got the company, churn rates were higher and they don't stop overnight, they're coming down. Tyler generally experiences almost 0, very, very low churn. So that's an initiative that has to settle out and is improved on.
Winning this business and improving backlog to work from is happening. Again, that leading indicator is reinforced by their experience in the marketplace. And the last thing to happen is it actually shows up in the financial results. And I think we're looking at later this year and early next year, we'll start to see their overall top line growth rate accelerate to and then beyond Tyler's overall rate. And I think that'll drive higher margins.
Their margins are lower now than when we acquired them based on these discretionary investments that we're making and we think they'll go back to where they were over the next 12 to 18 months certainly.
Got it. And then the other item around guidance, could you give us a sense for given the mix shift to subscription in 2017, was a bit ahead of your expectations. Can you talk about how you're handicapping that for 2018? Do you feel like you need to take a more conservative approach to this given just the dynamics in the industry of the drive to cloud and kind of help us get a sense for how you're thinking about that?
Yes. I think our we definitely have taken that account in our planning process. The mix doesn't impact each of our business lines equally. We have lines of businesses that are on POC, so that doesn't impact it. But in our larger areas in Munis, we've certainly budgeted in a higher than traditional adoption rate.
I wouldn't say it's meaningfully higher, but it's certainly higher. And that's to add a little more conservatism to our plan.
And Alex, this is Brian. Clearly, as we've talked about a number of times, the mix is lumpy and it varies quite a bit from quarter to quarter and year to year. It's also interesting to note that for 2017, the mix between licenses and subscription and new deals based on dollar volume, 63% license, 37% subscription was exactly the same as it was in 2015. So over that 3 year period, it's shaken out to be the same. We do expect that over the long term, there'll be more of a shift, but our maybe the midpoint of our guidance assumes a fairly similar mix to what we saw in 2017.
And as you've seen, we've widened the range a bit on our guidance, which also gives us a little more room to accommodate the various outcomes that we could see.
Got it. And then just the last one for me and this is a bigger picture question. But John, given the breadth of the portfolio increasing, given the incremental investments you're making in R and D, could you I mean, we're not looking for a long term guide here, but just giving kind of your comfort level for a time horizon that you anticipate being able to maintain double digit revenue. Growth. Is this something you think you can do over the next 5 to 10 years?
Is this something that could start to dip a little bit over the next couple of years? Just trying to get a sense of that long term durability.
Well, certainly all those things could happen. We dipped down here this past year just below the double digit level for the year. We're pleased that in the Q4, we comfortably got back into double digits. As we said on the call, at the midpoint of our guidance for this year is a little bit above 10%. We believe that the investments we're making and the things we're doing are helping to curve that back up.
And everything we're doing, these investments we're making and everything we do in the marketplace is to bend that curve back up and get it comfortably above 10% again. And all indications to us are that that's very reasonable. I don't know for certain where the growth rate will be 3 years from now, But we think we kind of have this core growth rate just the way the company works. If you take nearly 0 attrition and you take price increases
and you take the tail of the on premise sales
we sell and the the deals we know about on the e file horizon, there are the deals we know about on the e file horizon that are already customers, you look at the SaaS business and those run rates, that kind of puts out about an 8% or 9% growth rate for the overall company. And so I think that's absent any major change in the industry or in our position in the industry is kind of our core growth rate is the way we look at it. And so these incremental investments and these things we're doing, which are a big focus of ours and where we're spending a lot of the discretionary money we're spending are all about adding that other 2%, 3%, 4%. It gets you to the traditional growth levels where we know our model works very, very well. We believe those that we're doing those things that will make that happen.
And so we think, I don't know about 10 years, but I think as you look over the next 5 years that we have a very reasonable likelihood to perform in that area.
Perfect. Thank you, guys. Sure.
Our next question comes from Jonathan Ho from William Blair and Company. Please go ahead with your question. Hi, good morning and congratulations on the strong results. Just wanted to start out with maybe some thoughts around what you're seeing in the pipeline of opportunity for 2018 and just your general feel for the environment and whether that is maybe having an impact in terms of your desire to make those additional investments?
Sure, Jonathan. The pipeline on the markets behave very, very well. The deals are robust. And yes, we certainly believe that making these investments will be received well by a good marketplace that has the capacity to reward us for that. Having said that, we've invested through challenging times before.
I mean, some of the best investments we've made historically were during the 2,009, 2010 weakness in the market because a lot of our competitors didn't and they looked at it the other way and said this is a soft market, why would we want to be investing at this level? And when we came out of that time, we experienced a couple of very high double digit growth years catching up on the business that had been deferred. So I do think the market is strong right now and I do think we won't have to be patient to get a return on these investments. But really Tyler historically has invested in these products throughout up and down markets and I think that's worked well for us.
Got it. And then just as a follow-up, can you talk a little bit about sort of the competitive landscape and are you seeing any shifts there, particularly around the public safety markets?
There aren't any significant shifts. We said in the prepared remarks that that's a good marketplace. There are strong competitors there. No markets are easy and I think sometimes when we achieve high market share, people think it might be a little less challenging than it is. There are certainly good competitors across the board in this marketplace.
And while we get good results, we fight pretty hard to get them and nothing is to be taken for granted. Public safety though, I would say, what happened in tax, what happened in courts where we really became a dominant leader in a pretty short period of time is less likely to happen there in that shorter period of time. As we said, we believe Tyler has some unique advantages. We know we'll invest and execute over the long term and ultimately we'll be rewarded with a strong leadership position. But there are strong players in that space and they're not just going to turn away.
So I think this will be a long process to continue to improve our position in that marketplace.
Thank you. Our next question comes from Scott Berg from Needham and Company. Please go ahead with your question.
Hi, John, Lynn and Brian. Congrats on a fantastic bookings quarter.
My first question, Brian, is
for you around cash flows. If you look at your operating cash flow margins, they're actually down a little bit year over year versus 2016 and looks like it's all working capital related. But does some of that kind of unwind here in 2018 or will these be maybe slightly compressed from what we could start to see?
I think the factors that we pointed to earlier, the increase in the receivables, much of that unbilled related to billings, milestone based billings on some large projects we have going on, the timing of those and the prepayment in taxes before we really knew what the level of option benefit we would get in Q4 was. Both of those really turnaround in 2018. And as we've also stated, clearly much lower CapEx in 2018, roughly half the level they were this year. So I think the cash flow margins do improve in 2018.
Got it. Then my follow-up for either John or Lynn is, you guys kind of talked all year about the success you've had in the public safety area and there's been plenty of questions asked about it today. But you guys enrolled a new theme around Connected Communities at your conference last year. I've been enamored with it because I get the long term vision of how the products come together. I get the R and D investments and how that will drive that.
But are customers understanding what that vision looks like and is that actually impacting the better win rates across your products last year?
Yes, Scott. I think customers definitely do see the value in that. We've certainly rolled it out at our user conferences. There's a lot of excitement around it. As we said before, it's a long term process.
I don't know that that specifically has impacted win rates to date. I do expect that it's going to impact win rates going forward. Whether or not one jurisdiction and its neighboring jurisdiction and their options are between Tyler and another product and we're in the next jurisdiction and the benefits that those two will bring if they go with Tyler and they can be connected, both through public safety and then through their court systems, that's value that we can bring that nobody else can. Specifically seen that as the driver in the win rates. I think the driver in our win rates really has been the focus we've done so far as we talked about in the prepared comments of shoring up the customer references, doing things on the customer side, as John mentioned, to eliminate some of the churn, all the product investment, the new features and functionality.
I think that coupled with the strength of Tyler behind it, the vision of Tyler Alliance is it's creating excitement around public safety. And I do think that over the next few years that's going to help be the deciding factor in
a number of deals is this Tyler Alliance vision that you're also excited about. It's also always a number of things that affect a decision. So it will always be hard to isolate the primary reason. So we certainly think that contributes to our position in the marketplace. But I would say tangibly, what we're seeing are a lot of multi Tyler suite applications.
A lot of the names that Lynn referred to in the remarks were multi suite applications, Munisyn Intergov, Munisyn Municord and then starting to see public safety in audit deals. And no question, people see the incremental value to 1 Tyler next question comes
from Brent Bracklin from KeyBanc Capital Markets.
Next question comes from Brent Bracklin from KeyBanc Capital Markets. Please go ahead with your question.
Thank you. And appreciate taking the call here. Question I had was wanted to circle back to the subscription business. If I just look at kind of revenue mix, it's biggest 1 year increase in revenue mix from 19% to 20% of the mix now since 2014. I think it's now 42% of software backlog.
So as you think about that mix shift this year, is there a preference within local government where you're starting to see the shift slowly increase more? Or is there a dynamic here where you're including e filing revenue in that subscription mix that just e filing growth is the bigger factor driving a mix shift on subscription side? And I have one follow-up.
It's definitely broader than e filing. Munis this past year had a much higher mix. Not only a higher mix in names, the average value of SaaS deals was up significantly. So it's pretty broad and it's crept up into the higher size deals. That may be the biggest change from previous years as the average deal size was significantly higher.
So, I think it's fair to say that it's not surprising. Government is a little later to adopt this type of delivery than other industries. And I think it's moved for real and to stay. I'm not sure it didn't get a little ahead of itself in the middle of this past year and maybe it'll settle down a little bit before it accelerates again. But I think what we've expected a long term gradual shift is exactly what we're experiencing.
Got it. So there's still some volatility around the mix trends, but net net, it does sound like that large deal shift seems to be the biggest kind of change you're seeing now versus maybe a couple of years ago, you weren't seeing that. As a follow-up to that on the maintenance side, Brian, we saw maintenance growth slow to 9% year over year. I think that's the lowest growth rate in maintenance since we've seen at the end of '13, early 'fourteen. What are the drivers there to reaccelerate maintenance?
Are there some price increases you can kind of flow through? Obviously, as you see the mix shift to subscription, you no longer get the incremental benefit of maintenance. So just trying to think about how we should level set the maintenance growth profile over the next couple of years in an environment where you are seeing a mix shift to cloud?
Sure. Well, clearly, that mix shift does affect the maintenance line. It certainly more than offset on the subscription line, but it's a combination of more of the new business coming in, in the cloud. And so again, more of that on the subscription line and less new maintenance, as well as the flips or the conversions that we have. And those continue at a steady, but pretty strong pace of the number of customers each quarter that are currently on premises paying maintenance that move to our subscription model and move to the subscription line, typically at 2x what they were paying in maintenance.
But it does have a negative effect on the maintenance line. So those two things together really would have slowed the maintenance growth. And I think, again, based on the kind of current mix, that 7.5%, 8% growth in maintenance is sort of what you should expect. We do get annual maintenance increases and we work very hard to be very consistent with those and to provide significant value associated with those annual maintenance increases through our evergreen model. And that hasn't really changed.
So we're not seeing really a difference in the way we're pricing maintenance increases and our attrition remains very, very low on the maintenance side. So no real changes there. It's really more just the mix of new business that's driving the lower maintenance growth.
Got it. So as we think about maybe some downward pressure on the maintenance growth profile over the next few years, maybe the metric we need to look at is maintenance plus subscription growth rate. I think you referenced that as what growing 14%. So that's probably the better proxy to look at on a blended basis going forward?
Yes, I would say so. And we are you've always been able to add the numbers up, but we're kind of pointing towards that metric and giving the annualized referring to the annualized recurring revenues of those 2 combined is something you ought to look at.
Okay, great. Very helpful. Thank you.
Our next question comes from Mark Schappel from Benchmark. Please go ahead with your question.
Hi, good morning. Thanks for taking my question. Brian, first question for you. I have another question on the product mix in Q4. The shift to subscriptions, was this driven by just market preferences in your view?
Or were there some internal policy or sales incentives that were being offered?
It's really market driven. Generally, sales reps are compensated very similarly for the same deal, whether it's a subscription or a license deal. And our pricing structure has not changed. So we haven't really changed the pricing to try to drive new customers to one model or the other. I'd say that to the extent we are able to do that, we would have a preference towards the subscription model.
But we do believe that in most cases, we have a fairly limited ability to push that new customer one way or the other. So it's really primarily market driven.
Great. Thank you. And then John as a follow-up, any update on the success you're having with respect to the relatively new online dispute resolution solution?
Let me close with that. I'll let him take that.
Yes, Mark. It's as you know, it's pretty small acquisition, but it's an acquisition that we think has a lot of interest around the country and we've already had significant interest in our client base. We've had a number of jurisdictions who have agreed to sign up for some pilot court systems. We've agreed to some pricing on that. I do think it's something that's it does have excitement.
Like a lot of things that we do, it's going to take some time. It's going to take some time for those revenues to build and grow. But we're looking at something that could as part of transforming the way justice is done certainly at certain levels of justice. I think it's a new efficient way and I think some of them particularly some of our larger more progressive clients are ready to embrace this and roll it out. So it's going well, but like everything else, it's slow.
I don't expect significant or meaningful revenues in the near term, but over the long term, like a lot of our growth initiatives, we expect that it's going to add significant revenues at a little higher rate and add incremental growth to Tyler.
Thank you.
Our next question comes from Peter Heckmann from D. A. Davidson. Please go ahead with your question.
Good morning, everyone. Brian, could you just give us a quick update? I know it's a small number, but Microsoft royalties in revenue this year and then any anticipation of a material change in that relationship in 2018?
Sure. Revenues were relatively flat this year. And as we've seen, it's not really a material number, but our total royalties for the year, not including our direct channel, were $3,700,000 Last year, they were $3,400,000 So not big movement there. I think I'll let Lynn speak to the relationship and any changes there, although there haven't really been any significant ones lately.
Yes, there's no real significant change. Royalties, I think they've increased in the Q4. Our relationship with Microsoft is still good. And I'd say there's no material change at this point.
Okay. And then if we
could maybe shift gears to the statewide deals for e filing. Congratulations on Kansas. It looks like there's some others in the queue. Can you talk about how many states have now made an award for an e filing project? How many of those has Tyler won?
And in the few cases where you've lost, whether there may be some particular issue around technology or anything else that may have pushed the decision away from Tyler?
Well, there really there's a lot of different categories there. So, there's not a short answer. There are mandatory statewide deals. Those are obviously the ones that are fully up to scale and we can see there's good visibility on the numbers, whether they're click based or fixed contract based on click. And then there's others that it's part of the contract, but they're not fully online yet.
But generally, our expectation is that all of our existing significant clients will have e file and some of them will come up with mandatory and we'll see the spike right off the bat and we like those obviously and some will take time as we have to drive adoption rates over the long term. I think we've really only lost one significant deal at that level, say, in the last 5 years. So our position is very strong and you're going to occasionally lose a deal based on relationships or pricing or things that we can't change our model to embrace without jeopardizing our overall strategy. So, very few losses. Again, only one comes to mind that would have been significant.
And we have a presence in e filing in 16 states and I believe all but 4 of those are statewide systems, California, Georgia, Ohio. We do not have statewide. It's a county by county presence we have there.
Right. That's right. Okay. And then just last follow-up on e filing. You see any increase in a tendency or preference on the part of states or counties to move towards fixed fee rather than a transaction fee prepiling?
I guess so. We've seen a few of them. We've done it, so people know it's an option. I would stress that you don't want to overemphasize the difference because they're just looking for better visibility and something we know the governments have to budget and that's what they're looking for. So it really though is just doing the math and putting a number to it that is within the mid range of what would occur.
So we're a subscription based and pretty much a click based organization on that and that's our model. But if somebody says, hey, look, we've got a lot of history here, we see, we know the range is this, let's negotiate something that's fair to both sides. Obviously, we'll be a good partner and do that. But yes, we've seen more people take us up on that and it gives better visibility to the client and to us.
Okay, fair enough. Thanks for the update.
Our next question comes from Kevin Liu from B. Riley FBR. Please go ahead with your question.
Hi, good morning. Just a quick follow-up to that last question. So for the deals on EFL that you have seen move more to fixed fee, has that generally been with your annual terms fairly flattish relative to what you were doing on a click basis? Or do you see any sort of increase or decrease in that rate?
Generally, it's very, very close. Yes. Right. Unless their experience changes dramatically, it's relatively flat. Now renewals are good for us because we have a lot of cost bringing up the initial engagement and a lot of that's been recovered.
So flat renewals are not necessarily a bad thing for us.
Great. And then just one other question, you talked about the research product you introduced last quarter. Any sense for how traction for that is building within the marketplace?
Yes.
Yes. I think it's I don't think we have enough data points yet to sort of point to where that uplift is going to go. We're still at the stage where we're rolling this out and there's excitement in terms of, for example, Illinois where we announced it in terms of being fully turned on and fully utilized, we haven't hit that yet. So that's something that we're going to watch over time. And there is some interest.
We've talked before about other states are interested in this product and we think it's a good driver, but we don't have an updated point yet to sort
of give you more guidance on that.
Thanks for taking the questions.
Our next question comes from Tim Klasell from Northland Securities. Please go ahead with your question.
Hey, this is Tyler Wood on for Tim. Thanks for taking our question. How does the backlog duration look? And then going into 2018, will this be converting into revenue at a different rate than what we've seen previously? Thanks.
Yes. As we've pointed out over the years, the percentage of our backlog, although our backlog continues to grow significantly, there is more and more long term backlog in that number with more subscription arrangements, which are typically, I think we said 5.8 years in duration and the new bookings this year and the multi year e filing arrangements, all of those things and as well as some of the large software deals that are multi year implementations. So that percentage of backlog to be delivered even though the dollars to be delivered in the next year coming out of backlog are larger. The percentage is smaller. So at year end, it's right at 52% of our backlog of that $1,100,000,000 is expected to be delivered in the next 12 months and the balance to be delivered over as long as the next 7 years in some cases.
And that's come down over the last few years. So last year going into 2017, it was 61% of our backlog Log was expected to be delivered in the next 12 months. And so there is much more long term visibility in the existing backlog.
Thank you.
Ladies and gentlemen, at this time, there appear to be no further questions. Mr. Marr, I'll turn the call back over to you for closing remarks.
Well, thank you, Jamie, and thank you all for joining us on the call today. If you do have any additional questions, feel free to reach out to Brian, Lynn or myself.
Have a great day. And ladies and gentlemen, with that, we'll conclude today's conference call. We do thank you for attending. You may now disconnect your line.