Clearwater Analytics - Q4 2022
February 21, 2023
Transcript
Operator (participant)
Ladies and gentlemen, thank you for standing by and welcome to the Clearwater Analytics fourth quarter and full year 2022 financial results conference call. At this time, all participants are in a listen-only mode. After the speaker presentation, there will be a question-and-answer session. Now I would like to welcome Joon Park, Head of Investor Relations, to begin the conference.
Joon Park (Head of Financial Planning and Analysis)
Thank you. Welcome everyone to Clearwater Analytics fourth quarter and full year 2022 financial results conference call. Joining me on the call today are Sandeep Sahai, Chief Executive Officer, and Jim Cox, Chief Financial Officer. After their remarks, we will open the call to a question-and-answer session. I would like to remind all participants that during this conference call, any forward-looking statements are made pursuant to the safe harbor provisions of the Private Securities Litigation Reform Act of 1995. Expressions of future goals, including business outlook, expectations for future financial performance, and similar items, including, without limitation, expressions using the terminology may, will, can, expect, and believe, and expressions which reflect something other than historical facts are intended to identify forward-looking statements. Forward-looking statements involve a number of risks and uncertainties, including those discussed in the Risk Factors section of our filings with the SEC.
Actual results may differ materially from any forward-looking statements. The company undertakes no obligation to revise or update any forward-looking statements in order to reflect events that may arise after this conference call, except as required by law. For more information, please refer to the cautionary statement included in our earnings press release. Lastly, all metrics discussed on this call are non-GAAP, unless otherwise noted. A reconciliation can be found in the earnings press release that we have posted to our investor relations website. With that, I'll turn the call over to our Chief Executive Officer, Sandeep Sahai.
Sandeep Sahai (CEO)
Thank you, Joon, and welcome everyone. Let's start with the numbers because we are delighted to share robust results for both Q4 and the full year 2022. Revenue for the full year grew 20.4%. Gross revenue retention stayed at 98% for the 16th straight quarter. Net revenue retention climbed to 106%. Gross profit was 75.7% in Q4. EBITDA margin for Q4 was 29.4%. We generated free cash flow of $16.6 million in this quarter. In the last 100 days of 2022, two more of the 20 largest insurers in North America chose to move to the Clearwater platform. That, I hope you'll agree, is very compelling execution. Looking back at the year, I could not be more proud of our team.
As all of you know, like other fintech firms, we faced headwinds throughout the year. I believe the urgency and effectiveness with which we re-reacted and executed was very strong. We didn't just address the challenges we faced. In fact, we made our business stronger and more resilient by working with our customers to craft a modified commercial model. Given what we accomplished in 2022, we have renewed confidence that our overall plan, our commitment to building disruptive technology, our product strategy, and our customer-centric approach will stand the test of time. Let's dig a little deeper into the fundamentals of the business. When we completed our IPO in September 2021, we laid out five pillars to guide us. We continued to build upon them throughout 2022. Given the new year, we want to provide an update on those pillars, which are largely unchanged.
Pillar number one is consistent, reliable, and durable growth. This is the first pillar for a very good reason. We want an ever-increasing number of clients to choose our platform, and for those who already own our platform, we want them to grow. Consistency and predictability in our growth is important to our ability to invest in the medium and long term. Our Q4 revenue was $82.7 million, and full-year revenue was $303.4 million, which represented year-over-year growth of 20.4%. This accomplishment in a turbulent and challenging time is testament to the resiliency of our business and the ability of the team to navigate challenges as they arise. With strong booking in Q4, booking for the year 2022 exceeded the budget we had laid out in the beginning of the year.
That allows us to look forward to 2023 with confidence in our plans. We expect to deliver another year of 19%-20% growth. We continue to watch the economy and the market conditions. We'll remain vigilant and agile in our response. More specifically, we will look to our booking to guide our continued investments. Pillar number two is our sizable total addressable market. We have always approached the sizing of the market opportunity with a lot of rigor because our GTM investments are determined by it. We have built a detailed view of our TAM by market, sub-markets, and geographies. We have previously communicated a market opportunity of $10 billion plus. In addition to using our own teams to validate this on a continuous basis, we work with leading consulting firms to further validate and refine this estimate.
More importantly, they help us define areas for TAM expansion. It is easy to be content with the long runway we have in our current markets, but our ongoing investments in R&D is in service of finding adjacencies that can continue to enhance the TAM on an ongoing basis. An example of actions related to this effort is our acquisition of JUMP Technology. Not only does it double our European presence, it also enhances our TAM by $1 billion by allowing us to deliver front office systems, including order and portfolio management to current and new clients. 157 new logos went live on our platform in calendar year 2022, and is proof of our ability to capture TAM.
In addition to the two large insurers we spoke about earlier, our new customer wins from Q4 include Adventist Health System, Bimini Advisors, Homestead Advisers Corp., Meeder Investment Management, Payden & Rygel, Robinson Capital Management, and WestCap Management, just to name a few. Geographically, we encouraged with our early continued successes in Asia. In Q4 we signed Avallis Investments in Singapore, MSIG Insurance in Thailand, and PT Asuransi MSIG in Indonesia. These organizations joined our growing group of clients in Asia and Australia. In a majority of these cases, we continue to replace legacy solutions and clients get a daily reconciled, comprehensive view of their portfolio across asset classes and geographies. This is where our third pillar comes in, our competitive next generation platform with deep competitive moats. Across the industry, investment operations teams face real challenges when they deliver to the businesses. That's just a fact.
They have to deal with multiple systems that are narrowly focused on a given geography, a given asset class, or a business function like risk. They have to bring all that together for the business who want to see a comprehensive view of their assets. There is data quality. They have to ingest and reconcile and keep track of ever-changing regulations and regulatory reporting requirements. Operations team need to manage all of that and deliver on time. Our single instance multi-tenant architecture is truly the next generation technology that has been proven in industry after industry. The value of the single instance architecture results in a constantly updated software platform that keeps pace with changes in accounting and regulations, obviating the need for costly and time-consuming upgrades. Clients no longer need to watch the tens of thousands of regulatory alerts that come out every year.
They simply rely on Clearwater. I was talking to a client recently who left a competitor to join us and asked them why. They said they have been following our regulation and compliance advice for years, they came to the conclusion that they would benefit from it being baked into our software. Multi-tenancy is changing the data quality landscape. Our platform fosters a network effect that allows for the highest data quality. Instead of each client having to ingest and reconcile their own data, we do it once for everyone. We are not content or complacent about our position. We continue to invest in our product to further deepen our competitive moat. In 2022, we invested 25% of revenue in R&D, plan to continue this level of investment in 2023 before moderating that in subsequent years. Moving to our fourth pillar, expanded product offering.
We believe that the continued and sustained investment in R&D allows us to bring additional products to market. When you first met us, Clearwater was predominantly a single product company. That has and will continue to evolve as we build a best-in-class commercial model. Today, we offer multiple adjacent products which can be used independently of Clearwater Core. Clearwater Prism continues to get greater market acceptance. Clearwater JUMP OMS, PMS for order and portfolio management. Clearwater JUMP for the full investment management lifecycle. We offer add-on modules which can be used alongside Clearwater Core. Clearwater LPx, Clearwater LPx Clarity, Clearwater Performance Plus, Clearwater Unit Linked Funds. Let's take them one by one, starting with Prism. We are proud to announce that in Q4, two of our largest clients, Nationwide and JPMorgan Asset Management, chose to use Clearwater Prism.
The Clearwater platform combined with Clearwater Prism aggregates data and performs a series of calculations and data validations and generates reports that allow JPMorgan Asset Management to comply with the daily regulatory reporting obligation. We're also excited to share that we have signed our first significant seven figure Prism deal in Europe, expanding our offering for one of our largest clients. This client will be able to use Prism to generate reporting for their end clients, representing over $290 billion in AUM. Next is JUMP. As you will recall, we closed the JUMP acquisition in November of 2022. In December, we sold the JUMP platform to Luxembourg-based insurance provider, Cardif Lux Vie. This key new client win in EMEA demonstrates that the combination of JUMP and Clearwater constitutes an attractive offering to the European asset management market.
We look forward to supporting Cardif Lux Vie with their investment performance, regulatory compliance, and reporting needs. We also expect additional customers in our core markets to be attracted to our combined product offering. In addition to JUMP's standalone offerings, we have integrated Clearwater and JUMP's development and product teams for defined products so that we can offer integrated solutions for unit-linked funds and an enhanced feature-rich performance module to existing Clearwater clients, which brings us back to adjacent products like Clearwater LPx. Clearwater LPx, our product focused on limited partnerships, is being well-received and gaining traction with both existing clients and net new logos in the market. We added more than 40 clients to the Clearwater LPx offering in 2022.
As you can tell by its rising popularity, the solution is being selected because it helps organizations dig deep into their private equity investments, providing them the visibility they need to understand long-term returns. Clearwater LPx Clarity takes it one step further to convert unstructured data to structured data to provide our clients' front office teams with underlying portfolio exposure and look-throughs, including investment and risk analytics. Prism was our first adjacent product, and it is now starting to deliver meaningful booking and revenue. We similarly expect our other expanded product offerings to create increasingly higher impact in 2023 and beyond. The fifth and final pillar is Clearwater's client-centric approach. The ultimate value of any tech platform rests in the value it delivers to clients, the impact it has on the business, and overall client delight.
In Q4, we once again received an NPS score in excess of 60%. That is simply the best in the industry. We work hard to ensure that our tech and our global teams are working towards a singular goal of client delight. Truly, client satisfaction is at the heart of everything that we do. In Q4, as a testament to this fact, Clearwater won numerous awards. The Tech Provider of the Year Award for Excellence from Insurance Asia News, the Best RegTech Solution from Insurance Post, and the Technology Firm of the Year from Insurance Asset Management. These honors acknowledge the profound impact Clearwater is having on our clients' investment operations in the U.S., Europe, and the Asia Pacific region. We are happy to report that Clearwater's CMO and CHRO both won awards for their leadership in marketing and HR innovation respectively.
Looking forward, many of you might ask how we expect macroeconomic conditions to impact our business. We are not reacting by laying people off. Rather, we are growing in line with our business. We are not cutting corners in R&D. Rather, we are consistently investing. We are not afraid to expand geographically or through acquisition. Rest assured, we are watchful of the economy and the markets. We will be led by bookings and not by economic forecasts about what might or might not happen in the coming quarters. We stand steadfast on our pillars: consistent, reliable, durable growth, focus on TAM, enhancing our SaaS platform, innovating our product offering, and dedication to clients. Little has changed in our philosophy, approach, or culture, except that after weathering 2022, we have proven our resiliency and therefore have even higher conviction.
Before returning with a few closing thoughts, I would now like to hand the call over to our Chief Financial Officer, Jim Cox, to provide more details on our fourth quarter and full year financial performance, as well as updated guidance for our first quarter and full year 2023.
Jim Cox (CFO)
Thanks, Sandeep, and thank all of you for joining us. It is rewarding to report our Q4 and full year 2022 results. I plan to spend our time summarizing a few items from our Q4 results and then explain the financial impact of the JUMP acquisition, which closed on November 30th, the tax receivable agreement or TRA expense, update you on the continued progress of our transition to the Base Plus model, and then conclude by providing color on our 2023 guidance. Please note that our results will be discussed on a non-GAAP or adjusted basis and include the results of JUMP since the acquisition, unless otherwise noted. Turning to Q4 and 2022 results, let me start with the top line and the metrics that drive revenue.
In 2022, we are especially proud to have delivered 20.4% year-on-year revenue growth in an otherwise challenging market environment. Q4 revenue was $82.7 million, and full year 2022 revenue was $303.4 million. Q4 revenue included $2.7 million of revenue from JUMP in December, which was roughly $1.5 million higher than we expected when we provided our Q4 guidance. JUMP's revenue included a perpetual license agreement with Cardif Lux Vie, which closed in December. We were happy to see that the combination of Clearwater's scale and JUMP's functionality achieved such success with a large European client so quickly. Annualized recurring revenue, or ARR, at the end of December 2022 was $323.5 million and included $6.4 million of ARR related to the JUMP acquisition.
The insurance vertical comprises 52% of ARR. The asset management vertical comprises 33%, with corporates, governments, and other entities comprising 15% of ARR on December 31, 2022. As of December 31, 2022, the Clearwater platform processes and reports on $6.4 trillion in assets daily, up from the $5.9 trillion at the end of 2021. This increase reflects business growth from new clients and existing clients that more than offset the market declines from lower equity and fixed income prices caused by the significant increases in interest rates throughout 2022. The bedrock of our business continues to be our client-focused approach, which has led to best-in-class customer satisfaction and an industry-leading 98% gross revenue retention for the 16th straight quarter.
In the fourth quarter, net revenue retention increased to 106%, a nice uptick from the bottom we predicted in Q3 of 103%. The 106% net revenue retention shows the positive impact our commercial model transition has had on our business. Let me highlight more in relation to our commercial model transition. As a reminder, we have historically charged our clients a fee, primarily based on the assets they manage on our platform, subject to contracted minimums. A significant majority of the assets on the platform are high-grade fixed income assets, which had historically led to very low levels of volatility and predictable revenue streams.
With the significant market volatility in both equity and fixed income in the first half of 2022, we evaluated our commercial model. We transitioned our contracting structure to a framework we now describe as Base Plus. A Base Plus contract framework includes a base fee for a prospective client's existing book of business, plus an incremental fee for increases in assets on the platform. The Base Plus model includes annual increases in the base fee and enables us to charge additional fees for supplemental services or additional products should the client subsequently select to utilize those services. This Base Plus structure has the effect of limiting the downside volatility in our asset-based fees. I am happy to share that since July, 100% of our new clients with contracts greater than $500,000 in expected annual revenue are using the Base Plus commercial model.
We also made significant progress with the commercial terms across our existing client portfolio. In 2022, clients representing 80.1% of ARR either agreed to modify contracts or price increases in their existing basis point contracts. This is precisely on target with our goals. We simply would not be able to make these changes if we did not have exceptional client servicing and a market-leading solution for these clients. Going forward, we aim to have a vast majority of new customer contracts on the Base Plus model. Additionally, we will continue to engage with the remaining clients to transition them to the Base Plus model. Within one small portion of our client base, we do plan to maintain an AUM based pricing model. Our largest asset management clients have historically relied on Clearwater to be an enabler of their growth.
For those clients, their NRR growth rates were consistently higher than our reported NRR. For those clients, we will continue to focus on growing with those clients as their assets grow. Let's turn to profitability. We reported $81.1 million in EBITDA for the full year 2022, and $24.3 million in EBITDA for Q4, which both exceeded the midpoint of our guidance by $1.6 million. EBITDA margin was 26.7% for the year, our first full year as a public company. Q4 EBITDA margins were 29.4% as our better revenue performance, combined with a more cautious hiring approach, resulted in a 60 basis point improvement over that margin from Q4 2021, which was our first full quarter as a public company.
Gross profit in the quarter was $62.6 million, gross margin came in at 75.7%. Gross margin continues to be resilient even as we continue to execute on building operations for new client growth, including our investment in international markets, where we are onboarding clients in Singapore, Thailand, Hong Kong, Australia, Japan, France, the U.K., and Netherlands, to name a few. Research and development expenses in the quarter were $20.1 million or 24.3% of revenue, an increase of $0.2 million from Q3. Sales and marketing expenses in the quarter were $10.4 million or 12.5% of revenue, an increase of $0.2 million from Q3.
General administrative expenses in the quarter were $7.8 million, or 9.4% of revenue, a decrease of $600,000 from Q3. These strong results reflect our continuing focus on execution and efficiency while also successfully integrating JUMP. Let's talk about JUMP. After closing the JUMP acquisition on November 30th, we began the process of integrating JUMP into Clearwater Analytics with the creation of joint teams to merge our development efforts and provide a single solution for a business function like performance or regulatory reporting, as Sandeep Sahai described. JUMP doubles our European presence with over 100 employees and ramps up our expansion efforts in Europe, extending our offering to our existing clients, as well as providing full investment lifecycle functionality to the investment management industry.
We already have opportunities to enhance the performance reporting for current clients and add trade order management to their existing Clearwater solution. We're also tremendously excited about a number of European prospects where JUMP will be the solution for unit-linked funds and Clearwater will be the solution for the rest of their investment book. This validates our acquisition hypothesis and shows the esprit de corps celebrated by the combined team. JUMP has historically been a perpetual license business and recorded their results under IFRS, not U.S. GAAP. Throughout 2023, in addition to merging the go-to-market teams and bringing their product to the cloud, we also plan to harmonize JUMP's offering into a recurring revenue model consistent with Clearwater. At year-end, JUMP had $6.4 million in ARR. Given the joint selling motion, the transition to U.S. GAAP, and product integration, we will generally not report JUMP results separately.
As we migrate the JUMP business to a recurring revenue model, we expect the transition will reduce our overall EBITDA margins in the first half of 2023, and then improve margins as new recurring revenues from JUMP layer into the financials. Since JUMP is less than 10% of our overall cost structure, we continue to expect consolidated EBITDA margins to increase in 2023 compared to 2022. Moving to the tax receivable agreement expense, you will see that we incurred $5.9 million in tax receivable agreement expense in Q4 and $11.6 million for the year. These expenses are incurred in lieu of tax expense when we utilize tax deductions subject to our TRA.
Although we reported a GAAP pretax loss, we would have had taxable income in 2022, primarily because of the capitalization of R&D expenses and lower stock-based compensation tax deductions. Absent the Up-C structure and tax receivable agreement, we estimate that the income tax expense would have increased by $14 million. The recording of the TRA expense did not impact operating cash flow in 2022. However, we expect to have to pay the liability related to the 2022 expense in Q4 2023. Let's turn to the balance sheet and cash flow. We ended the quarter with $255.6 million in cash equivalents, and short-term investments, and $50.5 million in total debt, resulting in net cash holdings of approximately $205 million.
Even with the JUMP acquisition in Q4, the ending cash equivalents, and short-term investments at end 2022 was still $1 million higher than at the end of 2021. Free cash flow for the fourth quarter was $16.6 million, reflecting a conversion of EBITDA to free cash flow of 68% and included $1.9 million of capital expenditures. Let's turn to guidance. For most of 2022, we hired in advance of our growth. For 2023, we plan to more tightly align our headcount growth to our new business growth. We expect modest EBITDA margin expansion in 2023. For the full year 2023, we expect revenue to be in the range of $361 million-$364 million, representing approximately 19%-20% year-over-year growth.
We expect our adjusted EBITDA to be in the range of $97 million-$98 million, which is 20 basis points better than the 2022 adjusted EBITDA margin. For 2023, equity-based compensation is expected to be approximately $80 million. After 2023, we expect equity-based compensation to decrease as a percentage of revenue. Equity-based compensation related to the JUMP acquisition is expected to be approximately $25 million. Depreciation and amortization expense is expected to be approximately $9 million, and our full-year non-GAAP effective tax rate is expected to be 25%. We project full-year diluted non-GAAP share count to be approximately 255 million shares. Focusing on guidance for the first quarter of 2023, we expect revenue to be $83 million and adjusted EBITDA to be $20 million. In Q1, we expect an adjusted EBITDA margin of 24%.
This is impacted by the JUMP transition to recurring revenue. Additionally, annual merit increases impact the Q1 EBITDA margin. As in previous years, we expect to expand margins throughout the year in 2023, resulting in an expansion of EBITDA margin for the full year. After a year of strong execution in 2022. In 2023, we look forward to more of the same. Winning new logos, expanding with existing logos, integrating JUMP into our further growth plans. With that, I'll turn it over to Sandeep to provide some closing thoughts.
Sandeep Sahai (CEO)
Thank you, Jim. We appreciate your interest in Clearwater Analytics. Despite some of the pressures that came with an uncertain market environment, 2022 was our strongest year on record. We ended with great momentum, capturing impressive client wins across the globe and demonstrating just how resilient we are as a business. We enter 2023 with renewed confidence in our ability to capture more TAM, displace legacy vendors, drive R&D and technology innovation, and deliver greater value and growth opportunities to our clients. As always, we remain relentlessly focused on our clients' long-term success and supporting them as they benefit from our technology's powerful network effect. With that, let me turn it over to the operator for questions.
Operator (participant)
Absolutely. We will now begin the Q&A session. If you would like to ask a question, please press star followed by one on your touch tone keypad. If for any reason you would like to remove that question, please press star followed by two. Again, to ask a question, press star one. As a reminder, if you are using a speakerphone, please remember to pick up your handset before asking your question. We will pause here briefly to allow questions to generate in queue. The first question is from the line of Rishi Jaluria with RBC. You may proceed.
Rishi Jaluria (Managing Director and Software Equity Research)
Oh, wonderful. Hey, Sandeep and Jim, thanks so much for taking my questions. Nice to see continued resilience in the business. I wanna start by the outlook for next year. I mean, really impressive numbers. Maybe two points on that. Number one, can you really help us understand what is giving you the confidence in what is playing out as acceleration, you know, relative to the ARR growth that you just put up in Q4? Alongside that, you know, I know, Sandeep, you had mentioned you're gonna invest based on what you see in your bookings and not on macro assumptions.
As we think about the guidance that you gave us for 2023, are you kind of assuming that macro stays the same, that it improves in the back half of the year? Any set would be helpful, and then I've got a quick follow-up.
Sandeep Sahai (CEO)
Yeah. Rishi, thank you for the question. Before I begin, I did wanna say that we sort of went on for quite a bit there, you know, like 37 minutes, but there was just so much to cover. We thought it would be helpful to get that all out there so that we can proactively answer some of that. Rishi, just to your question, I do think that when you look at our business, we have a really good sense of the ARR. You have a gross revenue retention of 98. The ability to forecast that is actually quite high. The second element is bookings we have done in the last six months. When you look at that, we have a really good understanding of what revenue will come about from that booking.
Obviously, that booking builds up through the year, but we know exactly what the project plans are and how that booking sort of translates to revenue. That's why when you hear Jim and me talk, we always say we are gonna let booking guide our investment, not revenue. Booking is really, for us, the forward indicator. That's how we think about it. I did also wanna make one other point here is, you know, Rishi, last year was hard, but if you go back to February of last year and you look at our revenue guidance from last year, it was $302 million-$304 million. Last year. With all of the challenges we faced, we delivered $303.4 million.
If you look at the EBITDA guidance we gave in the beginning of last year, it was $80million-$82 million. Go back and look where we delivered $81.1 million. I do think this model works really well. Frankly, you know, we thought we would do better than the numbers we guided to, but all of the headwinds we faced, we still delivered to guidance. We feel really strongly about what we can do, and our current plan sort of assumes that the macroeconomic condition is not going to improve very much, but it won't get a whole lot worse like it did last year. Last year, we felt the interest rate increases were dramatic. We don't expect dramatic increases, but we do expect continued increases in interest rates. We also assume that inflation is not going to abate.
If those happen, you know, those will be nice tailwinds to further our business. Jim, would you add something?
That's right. Jim?
Jim Cox (CFO)
I know you said you had a follow-up, Rishi. Did you wanna ask?
Rishi Jaluria (Managing Director and Software Equity Research)
Yeah, yeah. Sorry. My apologies. Yeah, just a very quick follow-up. When I look at the guidance, right? I appreciate that you're guiding to stock-based compensation and, you know, stripping out JUMP, it looks like actually SBC in dollar terms is gonna come down as well as a % of revenue, and you're guiding to kind of a low level of dilution, which I think is great to see in this sort of environment. Can you just speak really quickly to what are kind of the drivers of that and maybe what you've done, you know, internally and philosophically to kind of bring that level down to a more normalized level? Thank you.
Jim Cox (CFO)
Yeah. I think that, you know, the key metric to look at is when you look at the diluted share count year-over-year, it's flat, right? That non-GAAP 252 has stayed consistent. There really hasn't been any dilution through that. As we think about stock-based compensation, we've obviously isolated the JUMP portion of that. That was all considered as part of kind of that business combination. They need to earn that over time. That's why it's going through compensation. For the stock-based compensation related to Clearwater and our guide for this year, it reflects kind of the additional awards in this year that are gonna be granted across.
We feel like we're really well set across the organization to get everyone locked in and really committed to drive for the next extended period of time. Obviously, when you're growing 20%, 20%+, you continue to grow through those numbers that we're trying to keep flat and static and therefore we would have kind of increasing leverage as a percentage of revenues of our stock-based comp expense. Again, we looked, we sat down with our compensation consultants and looked to see what are all our peers doing and where do we sit, and we're incredibly comfortable with where we're landing relative to our peers. Given how we performed last year, we feel very, very good about that trade-off for shareholders.
Rishi Jaluria (Managing Director and Software Equity Research)
Wonderful. Thank you so much, guys.
Sandeep Sahai (CEO)
Thank you so much, Rishi.
Operator (participant)
Thank you. The next question is from the line of James Faucette with Morgan Stanley. You may proceed.
Speaker 10
Hi, guys. It's Michael on for James. Appreciate you taking our question. Appreciate the color you provided on the standalone modules and their relative adoption. I was hoping you could give us some incremental color on some of the Clearwater Prism wins specifically. I know you mentioned JPM as well as another seven figure deal, but is there any directional color you could provide us in terms of the ACV expansion you saw in both of those Clearwater Prism deals?
Sandeep Sahai (CEO)
Hey, Michael. Yeah, thank you for the question. Look, Prism was the first product we went out with, these wins at both JPMorgan and Nationwide are really significant. The question is: what was the primary use case, right? In the first case, the situation was there was a client reporting need which had to be done on a daily basis. They had to bring together data from many spots and bring it all together, merge it, and deliver that on a daily basis on time. This is just hard to do when you're trying to do that manually or home-written software. What Prism does is brings data from various sources, pulls it together, ingests it, does the calculations, and provides that report to the regulatory body on a daily basis.
That is one way to use Prism. The other one was really about AWOL combination. You have accounting systems of various kinds, some on Clearwater, some not. The question is: how do you get a comprehensive view of all of your assets? Prism is able to do that. I think the interesting thing for us is, Michael, that initially we were seeing Prism deals of $300,200 ARR. We have now seen deals of in excess of $1 [billion] ARR. This one in Europe we just announced, or we talked about today in the call. We feel like you have Prism, which has become more of a growing product with significant impact on both booking and ARR.
The rest of the products which you have talked about, they're more in the infancy, if you will. Those will still take time before they start to deliver in 2003 and in 2004. 2023 and 2024.
Speaker 10
Great. That's really helpful. maybe on pricing, how should we think about the difference in the economics between the customers who are adopting the Base Plus model versus those who are now commanding or, you know, those who are now adopting a higher take rate? I'm just trying to sort of understand the longer term impact of some of the potential resistance from your Wave Three customers to sort of transition to that new model fully.
Jim Cox (CFO)
Yeah. The way we think about it and the way the numbers are playing out is that the Base Plus model doesn't necessarily impact our NRR number overall. It just takes the volatility out, that downside volatility out. The adoption with all of our new clients has been fantastic. When we went, reflected and saw that 100% of all of our large contracts in the second half of the year were on the Base Plus model, it made us feel terrific about how this resonates and makes sense to all of our clients. For those larger strategic asset managers who we are growing with, as I mentioned, they typically had higher NRR rates than kind of what we had typically reported.
We also have a go-to-market model with those folks where we're actively helping them source and grow their businesses. From that perspective, it just made sense to continue to align with that. I would say that, to finally get around to answering your question, I'm not sure that the contracting model impacts that NRR or that take rate, and it's more about the use case to the customers, and as we drive that. As we think about how do we really, you know, aspirationally think about moving net revenue retention to, you know, 115%, right? Let's just throw that out as kind of an aspirational number. The Base Plus model doesn't necessarily get us there.
The Base Plus model, you know, we feel like this 106 that we were at reported in the fourth quarter is really reflective of our current business environment and, and kind of the current business. Us to move to that 115 is really about getting more leverage out of adding on additional products and increasing that take rate. Sandeep just spoke about Prism, LPx, and all of the JUMP modules are the path. That will take time. That's a multi-year project, but that's clearly a really important goal for the company. Most importantly, it's what our clients are asking for and want. They want to do more with us and so we're building the capabilities to be able to do that.
Sandeep Sahai (CEO)
Yeah, Michael, if I can just add to this. I think what happened was some of the largest asset managers, the way they allocated Clearwater costs internally to their businesses was driven by AUM in those markets, and that's how they charge their fees, right? There we did have resistance, but over time, if you look at the last two years and four years and six years, that's been the highest NRR business for us, those large asset managers. We sort of spoke with them. Was there resistance with that sub-segment? Yes, there was. We went back and said, "Okay, fine. We will live with the current model because we feel the NRR would anyway be the highest there." I don't know, I wanted to provide that detail so that you understand why Jim said that we have.
We've done this with 80.1% of ARR clients representing that much, but we're not pushing to try to get to 100%.
Speaker 10
That's great, caller. Thanks, Sandeep and Jim.
Sandeep Sahai (CEO)
Thank you.
Operator (participant)
Thank you. The next question is from the line of Alexei Gogolev with JPMorgan. You may proceed.
Alexei Gogolev (Executive Director)
Hi. Thank you for taking my question. I appreciate you breaking down the split between insurers, asset managers, and corporations. That seemed to be pretty much in line for what it's been for the past year. Moving forward, do you see any particular growth from any of the verticals, either for 2023 or beyond that, any place you're maybe getting share?
Jim Cox (CFO)
Thanks, Alexei. It's good to hear your voice. The good news is we're gaining share in all the verticals. As these percentages change, it's just about how relatively quickly we are gaining share in each of those. Insurance has been and continues to be, you know, about half of our business and is a really large and important piece of our business. With our investments in both Prism and in JUMP, we see greater opportunity as well in asset management. If you just look at our TAM at the highest level, the largest TAM is in that asset management segment.
If you were to look out to the future, you know, multiple years into the future, I think you would assume that, asset management would continue to kind of increase at, you know, kind of on the margin as far as a percentage of overall ARR. Sandeep?
Sandeep Sahai (CEO)
I think you may see some change in a quarter or two because you get a large deal. Like, we announced two very large insurers, actually two more of these insurers who are in the top 20. You may see that bubble up and down, but we don't not expect to win in every segment. We expect to win in every segment. We expect to win in the REIT market. We expect to win in, you know, traditionally which we haven't won in. We expect to continue to literally grow every industry. [Alexei], if you look at the TAM, there is runway in each one of them. There really isn't a need to say, "Hey, we're not gonna go push in that segment." Why not, right?
We have teams which are dedicated to a specific industry and to a specific size. For example, when you say insurance, there's a team dedicated to large insurers, there's a team dedicated to small insurers, and there's a team dedicated on very small insurers. We have broken up the market into the segments and sub-segments, and each one has the dedicated team going after it.
Alexei Gogolev (Executive Director)
Great. That's very helpful. Thank you. One other question from me. Digging a little deeper into your 20% revenue guidance for 2023, do you have any thoughts about how much of that would come from new logos versus higher pricing?
Jim Cox (CFO)
The vast majority would come from, you know, adding new business. Those could be both new logos as well as additional products and services to existing clients, relative to price increases. Absolutely sub 10.
Sandeep Sahai (CEO)
Yeah, just to give you a sense,[Alexei], that I think more than 90%, we don't have an exact number, but I can tell you more than 90% of the revenue would be from current clients whom we have either fully onboarded or we are onboarding. These are deals which have been won. I don't want to put a number on it, but I do know it will be in excess of 90%. Is it 92%, 93%? I don't know exactly. We're happy to sort of get back to you, but it is that order of magnitude.
Alexei Gogolev (Executive Director)
Great. Thank you so much. Appreciate it.
Sandeep Sahai (CEO)
Thank you,[Alexei].
Operator (participant)
Thank you. The next question is from the line of Gabriela Borges with Goldman Sachs. You may proceed.
Gabriela Borges (Managing Director and Head of Software Equity Research)
Good afternoon. Congrats on the quarter. Sandeep, I'd love to follow up on your comments that you've made in the past on some of the business enablement use cases that Clearwater really allows with some of the asset manager customers. Give us a little color on what you're seeing in terms of willingness to invest. Specifically, because Clearwater can be tied to a front office business name use case, is that allowing you to maybe tap into more budget or tap into more greenlit projects than if you were solely viewed as an accounting tool? Thank you.
Sandeep Sahai (CEO)
Yeah. Thank you, Gabriela, for that question. I really think it's a really important question about why asset managers who are under some pressure, you would agree, on cost, would sort of go out and sign up for Clearwater. What I'd like to tell you is that almost always it is because it is seen as a growth enabler. Clearwater helps clients get deals because the reporting and the analytics it can provide is superior. I think there are many software products which do that reporting well for a given asset class. Many. I think there are many which provide it for a given geography. I think why clients sort of continue to grow with us is we actually, Gabriela, we go into pitches with them.
We will go do joint pitches with asset management clients when they bid on a book of business with a potential client. When you start to be seen as an enabler of growth, I think that changes who we are. There is a client, obviously probably not appropriate to name, but who really lost a number of RFPs. When they did the analysis of why they lost the RFPs, they found that other asset managers just had superior reporting online. They had superior analytics. They had one aggregated reporting, you know, and accounting function. I've always thought that if you go back at 2022 and look at why we won, it is because of that. Even the big Prism deal we announced in Europe, which was, you know, in excess in $7 figures.
If you listen to the part what I was talking about was they are reporting to their clients. That's why they bought us. They have $200 billion of assets. They used to take days and days to get these reports ready and sent to their clients. They come to Clearwater, we should be able to generate that in a matter of hours. It should be available online. Again, if you think of the proposition, like you said, not as an accounting software, but as an enabler of growth, that's why I think we get traction.
Gabriela Borges (Managing Director and Head of Software Equity Research)
That makes sense. Jim, a clarification for you on the full year guide. The implied revenue acceleration in the back half, that is a function of the bookings in the pipeline that you're seeing today, plus the JUMP model transition. Just a little bit on the moving pieces that are getting you to that.
Jim Cox (CFO)
Yes. Yes. I think it's the onboarding of the assets from our Q3 and Q4 bookings flowing into our revenue line item, right? First we win the business, then we onboard the business, as those assets are being onboarded, they grow. It takes obviously some time to onboard that's the major element of the growth throughout 2023. There's some impact as well from the transition to term for JUMP but, you know, relatively speaking, it's $6.4 million in ARR.
Sandeep Sahai (CEO)
Gabriela, if I could add to that. You know, the booking in the second half of 2023 will likely have very little impact on 2023 revenue. What really impacts 2023 revenue is booking in the second half of 2022 and Q1 and Q2 of 2023. It does matter. Of course it does matter, but a very vast majority would be based on the last two quarters of booking and the pipeline in this quarter. Those three will matter the most.
Gabriela Borges (Managing Director and Head of Software Equity Research)
That makes sense. Thank you.
Sandeep Sahai (CEO)
Thank you. Thank you, Gabriela.
Operator (participant)
Thank you. The next question is from the line of Michael Turrin with Wells Fargo. You may proceed.
Michael Turrin (Managing Director and Software Equity Research Analyst)
Great. Hi. Thanks very much for taking my question. I'll keep it to one, just given the time here. We obviously all understand that you just completed the acquisition of JUMP, but you're in a good financial net cash position as you've mentioned. Sandeep, I think you said at the beginning of the, or at some point in your prepared remarks that you're not afraid to make more acquisitions. This suggests you're on the offense. Can you elaborate on what you're seeing out there as it relates to private market valuations, and your appetite to invest? I believe on the JUMP acquisition call, you mentioned that you screened over 300 companies in your due diligence process. Would love to just hear more on the due diligence process you're going through right now. Thank you.
Sandeep Sahai (CEO)
Thank you, Michael. Thank you for that question. look. We're really excited about JUMP. I think what we can do, not just for Clearwater, but for the employees of JUMP themselves, and being able to take their brand and what they've developed, sort of take it around the world, I think it's so exciting, also for our current clients. Our current clients need those modules, so we're very excited about what JUMP can bring to us. you know, I wrote down what matters. I think Jim's always telling me the bar has got to be really, really high. You know, because you have a good clean business, grows nicely profitable. Let's not do something to screw that up, right?
Feel like, hey, the bar has got to continue to be high. What are we really looking for? One is if it helps us expand geographically. For example, in the case of JUMP, it does that, right? If we found something which would help us expand geographically or in a market. This could be, you know, either something that does well with REITs or things like that. That is one. The second one would be something that makes our platform more comprehensive. If there were functionality which clients wanted, which we don't do well enough or deeply enough, well enough is probably the wrong term, but deeply enough, then that would be another area where I feel like we would look at acquisitions.
The third thing is, you know, if they were helpful in bringing more value to our current clients, for example, some form of analytics would be really helpful. Really it's more about adding value to current clients who are unhappy. All of us will acknowledge that investment accounting isn't working for many clients around the world. If we can hasten that process of them coming on to Clearwater, I think that would be really interesting. We obviously just did JUMP. It is going nicely. We'd love to see them start to deliver some results. The early sign, this Cardif, was great. Happened in December, and frankly it was brilliant that we, they got that done. We do expect that we'll continue to look aggressively for acquisition.
That's what I would say. I don't think there's a goal to do one this year or something like that. If we found the right one, we would do it. We would not wait.
Michael Turrin (Managing Director and Software Equity Research Analyst)
I appreciate that level of detail, Sandeep. Thank you.
Sandeep Sahai (CEO)
Thank you, David.
Operator (participant)
Thank you. The next question is from the line of [Matthew Barrett] with William Blair. You may proceed.
Speaker 11
Great. thanks for taking my question. I wanna follow up on some of the commentary made around the module side. I understand that it'll take time to see the full impact from portfolio upsell modules, but looking at these products today, how should we think about the ASP difference for an average core plus customer who buys just the core Clearwater platform versus someone who buys a full suite? Is that a 20%, 30% upsell? Given the strong R&D investments, how can that upsell opportunity grow over the next one-two years?
Jim Cox (CFO)
Sure. This is Jim. Let me take that. I think it's important to think about when you're on the core Clearwater platform, you're doing all of the accounting for all of these. Let's just take LPx as an example, okay? The LPx, we're doing the accounting for those LPs for you already, and that's being charged, you know, as part of your base fee and as all of that grows. Let's say that you say, "Okay, I want to step through and do LPx and add more kind of visibility into that functionality, a little bit more broader and more robust than just the accounting and reporting functionality. Or LPx Clarity. I wanna understand the underlyings in this." We would charge an incremental amount per LP for those on that. Obviously it depends on the functionality.
Sandeep spoke about how Prism in that instance was a seven-figure deal. You know, LPx could be, you know, a few thousand dollars per LP, as an example of the variability between those. It just depends on the specific circumstances of the client.
Sandeep Sahai (CEO)
[audio distortion] this is Sandeep here.
Speaker 11
Yes.
Sandeep Sahai (CEO)
The biggest value, though, is not just in the LP processing. It really is always in the. You can get a comprehensive view with the LPs and the mortgages and the derivatives and the equities and the fixed income products. That's where the real value comes from. I don't think we do LP accounting any better. Yeah, we are trying to improve the look-through so you can see your portfolio better. The value of Clearwater really comes from that whole comprehensive ability.
Speaker 11
That's very helpful. Thanks again.
Sandeep Sahai (CEO)
Thank you, [Matthew].
Operator (participant)
Thank you. The next question is from the line of Brian Schwartz with Oppenheimer. You may proceed.
Brian Schwartz (Managing Director)
Yeah. Hi. Thanks for taking my question. Congratulations on the quarter. Sandeep, just wanted to ask if you could comment on the trends you are seeing with the top of the funnel and also the pace of conversions that you saw in Q4 versus prior quarters. Thank you.
Sandeep Sahai (CEO)
You know, Brian, thank you for that question. I think we were, you know. We said always that we will follow bookings but not economic forecasts because we just have got bitten by these forecasts. Every time we hear the forecast, we think the world's gonna fall apart. Q4 was great. We were surprised. As Jim Cox said, we became a little cautious in hiring because we started to believe the forecast a little bit. We did really well. We have now decided internally to say, "No, we're just gonna follow booking," because booking is much better for us. At least a leading indicator. Do we see the funnel really continuing to grow? Absolutely. Do we continue to see very large clients wanting to come onto Clearwater Analytics? Absolutely.
Do we continue to see smaller clients? Yeah, I, we just don't see the softness quite yet. If we do, and our bookings sort of even come down just a little bit, we will reevaluate. Right now we just don't see it. We're looking, though, Brian. I mean, believe me, with every report I see on Wall Street Journal, I'm always looking for signs of it. I do think there is enough pain in the market there that people wanna continue to look at something like a Clearwater.
Jim Cox (CFO)
Thank you for the color.
Sandeep Sahai (CEO)
Thank you. Thank you, Brian.
Operator (participant)
Thank you. Again, to ask a question, you can dial star one. The next question is from the line of Yun Kim with Loop Capital Markets. You may proceed.
Yun Kim (Managing Director)
Okay, great. I'll make this quick. First off, congrats on getting to that 80% target mix for the customers on Base Plus in just two quarters, which is amazing. Do you expect that mix to change much going forward? Just curious on what your and if you have any specific target for 2023.
Jim Cox (CFO)
For all of our new clients, you know, the other metric that was really terrific was 100% of those clients that signed up kinda for larger contracts were on the Base Plus model going forward. As we continue to add customers, the Base Plus model is the de facto way that we add those customers. Obviously, as we add customers over time, that will gradually tick up.
Yun Kim (Managing Director)
Okay, great. Maybe I could just.
Jim Cox (CFO)
Sure. Go on.
Sandeep Sahai (CEO)
No, go ahead please. Sorry.
Yun Kim (Managing Director)
Maybe I could just squeeze in one more, Sandeep, you mentioned a lot about the momentum you're seeing in Asia. Can you just kind of share with us, like, what's going on there in terms of go-to-market, you know, and the momentum that you're getting in the Asian market?
Sandeep Sahai (CEO)
Yeah. I must admit I seem to speak too much about it. I think I speak about it because we get surprised by it, right? We have a big office in Europe. We have made a lot of investments in Europe. When Europe grows, we are like, "Okay, this is what we expected." I think Asia, we still have a very limited footprint, and we get surprised when we win there. What we have today, just to be clear, is we now have an operating team there. We have a sales team, we have a pre-sales team, and we have. We now have a full organization there. When you think about the problems in Asia, I think they are more acute. Every country has its own GAAP.
Every country has its own regulatory reporting need, and that's not the case if you've got an American client. If a North American client, guess what? It's all U.S. GAAP. It's quite simple. The regulatory needs are understood. When you go to Asia, you know, Thailand is different from Vietnam, which is different from China, which is different from India, which is different from every country. At an intuitive level, we believe that the need for a solution like ours should be much stronger in Asia. That's why we are somewhat more excited than the size of our business suggests.
Yun Kim (Managing Director)
Okay, great. Thank you so much, and congrats on a solid quarter.
Sandeep Sahai (CEO)
Thank you. Thank you.
Operator (participant)
Thank you. That concludes the Q&A session. I'd like to turn the call back over to the team for concluding remarks.
Sandeep Sahai (CEO)
Look, I just want to thank everybody for your interest in our company. We are trying to build something special here, and we always appreciate just your engagement. Thank you all. I'm sorry this ran over just a little bit. Thank you.
Gabriela Borges (Managing Director and Head of Software Equity Research)
Goodbye.
Operator (participant)
This concludes today's conference call. Thank you for joining. You may now disconnect.