Coforge Ltd
NSE:COFORGE

Watchlist Manager
Coforge Ltd Logo
Coforge Ltd
NSE:COFORGE
Watchlist
Price: 7 624.1 INR -1.53% Market Closed
Market Cap: 508.5B INR
Have any thoughts about
Coforge Ltd?
Write Note

Earnings Call Transcript

Earnings Call Transcript
2023-Q3

from 0
Operator

Ladies and gentlemen, good day, and welcome to the Q3 FY '23 Earnings Conference Call of Coforge Limited. [Operator Instructions] Please note that this conference is being recorded.

I now hand the conference over to Mr. Ankur Agrawal, Head, Investor Relations and M&A at Coforge Limited. Thank you, and over to you, sir.

A
Ankur Agrawal
executive

Thank you, Faizan. A very warm welcome to all of you, and thank you for joining us today for Coforge Q3 FY '23 Earnings Conference Call.

As you are aware, we announced our Q3 results today. These have been filed with the stock exchanges, and they are also available on the Investors section of our website, www.coforge.com.

I have with me today our CEO, Mr. Sudhir Singh; our CFO, Mr. Ajay Kalra; and our Chief Customer Success Officer, Mr. John Speight. As always, we'll start with the opening remarks from our CEO, and post that, we'll open the floor for your comments and questions.

With that, I would now like to hand it over to our CEO, Mr. Sudhir Singh. Sudhir, all yours.

S
Sudhir Singh
executive

Thank you, Ankur. A very good morning, good afternoon, and a very good evening to all of you across the world, folks. At the outset, let me wish all of you a very healthy, happy and a meaningful New Year.

With that, I shall now share our quarter 3 fiscal year '23 performance and the business outlook. Q3 this year has been a very strong quarter for the firm despite the fact that it was the shortest quarter and a furlough-ridden quarter.

In this quarter, we signed 5 large deals, which is the highest number of large deals signed in any quarter in the history of our firm. Our quarterly order intake for the firm, again, has been the highest recorded ever in our history. Our utilization this quarter jumped 300 bps sequentially. Our attrition levels came down further to 15.8%, and they are probably now one of the lowest or the lowest across the industry.

And finally, this quarter, our 12-month executable signed order book stands at $841 million, and that, again, is the highest ever. With that overall context, I shall now talk you through the results, the quarterly performance and our assessment of the outlook.

Moving on with the quarterly performance, revenue analysis. I'm pleased -- very pleased to report that during the quarter, the firm registered a sequential revenue growth of 3.7% in constant currency terms. In USD and INR terms, the growth was 2% and 4.9%, respectively. That 170 bps difference between the constant currency and dollar growth was on account of 70 bps of hedge losses and 100 bps came from cross currency headwinds.

On a YTD basis, at the end of the first 9 months of the current fiscal, the firm has grown 22.9% in CC terms, 24.6% in INR terms and 16.3% in USD terms. On a Y-o-Y basis, the firm has grown 20.7% in CC terms, 24% in INR terms and 13.6% in USD terms. I shall now detail vertical-wise growth for the quarter under review. During this quarter, the BFS vertical grew by 39.3% year-on-year in CC terms and contributed 31.1% to the total revenue.

The strong growth came despite the impact of very considerable softness in our BPS mortgage portfolio. Our travel vertical grew 25.6% year-on-year in CC terms, and it contributed 19.3% to the revenue mix. The insurance vertical revenue declined by 6.8% Y-o-Y in CC terms and contributed 22.1% to the Q3 revenue. The others vertical grew by 24.1% Y-o-Y in CC terms and contributed 27.4% to the revenue mix.

Within the others vertical, retail and health care now stand at about 8% of global company revenue, and the public sector outside India stands at around 7%. These 2 verticals are the probable next 2 global verticals that the firm will carve out over time.

Within the geographies, Americas contributed 49.2%. EMEA contributed 40.3% and the rest of the world contributed 10.5% to the revenue. The farming engine of the firm continues to drive the growth of our top customer relationships. We continue to very successfully mine our key client relationships under a structured enterprise-wide key accounts program.

In quarter 3, our top 5 customers grew 5.4% sequentially and top 10 customers grew 3.5% sequentially in U.S. dollar terms. Our top 5 clients contribute now 23.9% to our aggregate revenues, while the top 10 contribute 36.3%.

We see the current state of our top 10 client relationships, offering 2 distinct advantages to us. First, as you would have noticed, we are not overly reliant on or overly concentrated in any single client relationship. Second, we expect to significantly expand our wallet share in the top 10 clients given the clear success that our key accounts program has driven for us in the recent quarters.

The offshore revenue saw a further pickup and crossed the 50% mark representing 50.5% of the total revenue in quarter 3. You will recall that just 9 quarters ago in quarter 2 FY '21 offshore revenue was only 36% of the firm's revenue. This has been a structural shift in the firm's operating profile and an important and sustainable margin lever.

With that, I shall now move on to the margins and the operating profits discussion. Talking about quarterly performance margins and operating profits. Our Q3 gross margin sequentially increased by 133 bps to 33.4%. This significant increase in gross margin in Q3 came about because of; one, offshore revenue contribution increase; two, a 300 bps improvement in utilization; and three, continued increase in billing of graduate engineer trainees hired directly from college.

We believe that the structural shift in the gross margin profile of the firm augurs well for an increased margin gradient in the years to come. It takes considerable effort to effect a 14% swing in offshore revenue contribution, which we have done. Again, it takes considerable effort to build a campus hiring engine at scale, which is now in full play at Coforge, and it took considerable effort to move the needle on utilization by 300 bps in a seasonally short furlough-ridden quarter, which is what we've achieved.

Today, as we speak, we have another 1,000 graduate engineer trainees who are undergoing training. And as they become billable over the next 4 quarters, that should provide a further gross margin fit. It is important to note that our gross margin increase has been driven by these 3 efficiency levers that I've noted above and not, I repeat, not by currency tailwinds.

The entire tailwind on margins on account of rupee depreciation was wiped away by the hedge losses sustained during the quarter. That hedge loss of INR 129 million during the quarter created a headwind of 60 bps on the margins. As we've shared in the last 2 quarterly calls, we are investing aggressively and I mean aggressively in the front-end leadership and capability build to further drive accelerated growth. As a result of those investments, SG&A as a percentage of the revenue for the quarter was 14.9%. That's almost 121 bps increase over Q2 FY '23.

Despite these very significant investments, adjusted EBITDA margin increased to 18.5% for the quarter. The consolidated profit after tax for the quarter stood at INR 2,282 million, which reflected an Y-o-Y increase of 24.2% in INR terms.

Moving on to order intake, interesting story, order intake. The shortest quarter of the year has proved to be the most productive for the firm, both in terms of the number of large deals and the order intake registered. We closed 5 large deals during the quarter, which is the highest number ever recorded in the history of our firm. One of these was a $50 million-plus deal within the insurance vertical. Our order intake of $345 million during the quarter was again the highest quarterly intake for the firm. The $50 million plus TCV deal was structured with the specialty insurance carrier to support its core systems upgrade as well as servicing and building capabilities in newer areas of operations.

Another $30 million TCV deal was signed with the banking major. This deal was anchored by our data and analytics service line and involves advanced analytics in financial crime and fraud management, BI reporting and platform modernization for the next 3 years.

Americas contributed $208 million, EMEA $113 million, and the rest of the world, $24 million to the overall order intake. Our executable order book, which reflects the total value of locked orders over the next 12 months stands at a record high of $841 million compared to $802 million in the previous quarter. This metric, which we tracked closely and have reported quarterly over the last 5-plus years, is also indicative of strong expected growth beyond just the current fiscal year.

We also signed 11 new logos during the quarter. Moving on to the people metrics. At the end of quarter 3, total head count stood at 22,505. The quarter saw an increase in utilization by 300 bps. And as a consequence, we were able to deliver the volumes with a marginal decrease of 138 people in tech services.

Attrition during the quarter further declined to 15.8% in Q3 from 16.4% in Q2. Employee attrition at Coforge, and I've said this often, continues to remain amongst the lowest and probably is the lowest across the IT services industry.

I will now hand over the call to John Speight, Chief Customer Success Officer for providing insights into our operations and capability creation. John joined the firm around 5 years back, shortly after I and I've had the pleasure of having him as my colleague over the past 12 years across organizations. He currently drives our customer success function and overseas key accounts growth and consulting capability build agenda. Over to you, John.

J
John Speight
executive

Thank you, Sudhir. I will now touch briefly on our key delivery operation highlights. As you are aware, effective delivery execution has and continues to be a core part of our customer value proposition. In our insurance business, we successfully implemented an automated underwriting solution for a large U.S.-based customer.

This resulted in significant reduction in time taken to issue policies and the corresponding reduction in their cost base. Our global specialty insurance group with offices across U.S., South America, U.K. and Europe, we've been chosen as their global strategic partner to work with them in their digital transformation programs.

This encompasses the run, the build and transformation across all of their systems, and will leverage our end-to-end services spanning capabilities such as consulting, digital, data analytics, cloud and automation.

Before I move on from Insurance, I just want to let you know that we were recognized for the first time in the recent Everest PEAK Matrix for Application and Digital Services in both P&C and L&A Insurance segments. We were classified as a star performer in the Major Contenders segment, a significant achievement for us.

Moving on to Banking and Financial Services. We have successfully completed a very large transition from the incumbent provider at a Tier 1 bank. With the transition completed, we have now embarked on transforming the delivery to outcome-based service models. The partnership with this bank has grown on the back of our delivery excellence, and we are moving up the value chain. One such example is the modernization of their business intelligence platforms that provide advanced analytics services in areas such as financial crime and fraud protection.

In Travel, Transport and Hospitality business, we've successfully partnered with one of the global airlines to improve their customer experience when using kiosks. We have now rolled out the new kiosk platform at 25 airports worldwide and are currently planning to roll up for further 20 airports. The new kiosks support 12 different languages and have helped improve the customer experience by significantly reducing the self-service check-in time.

We continue to explore and invest in emerging technologies. Our Metaverse CoE is now operational. The Coforge Metaverse experience Center is a virtual reality space that is being used to demonstrate use cases in the industries. We've also embarked on a program to use the Metaverse for our leadership simulation programs and employee onboarding here at Coforge. It's a great way to deliver value while we build up our Metaverse capabilities.

Finally, we recently announced partnership with the Mack Institute for Innovation Management at the Wharton Business School. The Mack Institute supports both industry and academic communities, helping to apply innovation research into real-world deployable solutions. This partnership will help reinforce our efforts to enhance our technology capabilities and to help us deliver value-added to our customers.

I would now like to hand over to Ajay for further details on financials.

A
Ajay Kalra
executive

Thank you, John. A very happy New Year to everyone. Let me briefly touch upon the key balance sheet and tax metrics. Our cash and bank balances at the end of Q3 financial year '23 stood at $49.5 million compared to previous quarter -- sorry about that. There's some audio issues. Let me begin again.

Let me briefly touch upon the key balance sheet and tax metrics. Our cash and bank balances at the end of Q3 financial year '23 stood at $49.5 million compared to previous quarter of $50.3 million. CapEx spend during the quarter was $5 million. The days sales outstanding were 73 days in Q3 versus 70 days in Q2 in INR terms.

In USD terms, the DSO were 68 days compared to 66 days in Q2. The effective tax rate for Q3 financial year '23 was at 23.3% as compared to 17.7% in Q2. You may recollect that we had onetime benefit last quarter that we got from one of our foreign subsidiaries where we were able to take the benefit of net operating losses.

Our normalized tax rate for Q3 is around 21.5%, and our ETR will continue to be in the range of 21% to 22%. The operating cash flow for the 3 months ended 31st December 2022 was at $30.4 million, which is about 69% of EBITDA. The OCF and DSO were impacted due to collection of one of our large clients coming in the first week of January and impacted the DSO by 5 days.

In addition, I just wanted to give an update also on the company's proposed ADR offering. The current market conditions are not favorable, and hence, ADR listing has been delayed. Though the company remains fully committed to the ADR listing. The company continues to monitor market conditions closely.

With that, I will hand over the call back to Sudhir for his comments on outlook.

S
Sudhir Singh
executive

Thank you very much, Ajay. Let me move on with the summing up in the outlook section, ladies and gentlemen. The 5 large deals signed during the quarter. The highest order intake, and I said this earlier in the history in any quarter in the history of the firm, and finally, the highest 12-month signed order book in the history of the firm at the current point in time gives us confidence in our ability to drive sustained robust growth in the coming quarter and in the coming year despite the uncertain macros.

The fact that the farming engine across the accounts is delivering sustained derisked robust growth. The change in our client portfolio mix where we today have 60-plus Forbes Global 1000 client relationships to form further, the aggressive, very aggressive investments in sales, marketing, tech and functional capability build that we are making aligned with an improving margin gradient that allows us to invest further, gives us further confidence in that assertion that I just made.

As a consequence, we are now upgrading our full year revenue guidance to 22% organic CC growth, and we maintain our adjusted EBITDA annual margin guidance. With those words, and with that, ladies and gentlemen, I conclude my prepared remarks, and I look forward to hearing your comments and to addressing your questions. Back to you, folks.

Operator

We will now begin the question and answer session. [Operator Instructions] The first question is from the line of Ravi Menon from Macquarie.

R
Ravi Menon
analyst

Congrats on a pretty good quarter. Sudhir, you said that there were significant headwinds in BPM, but despite that you seem to have grown there. So this mortgage as a headwind, what are other parts of BPO that actually did grow?

S
Sudhir Singh
executive

No, I said that there were significant headwinds in BPS mortgage, BPO Mortgage, Ravi. And the numbers that I called out were for the BFS portfolio, which includes the BFS, BPS portfolio. So the mortgage business saw a considerable decline. But given the very significant momentum that we have ongoing across our broader BFS portfolio, it continues to power ahead with the speed that it has been over the past few quarters.

R
Ravi Menon
analyst

But I was saying that specifically BPM itself seems to have grown from like $25.7 million to $28.8 million. So are there parts of BPM that is still growing or that's...

S
Sudhir Singh
executive

BPM is growing, but it's -- I mean, as pieces -- the aspects of BPM, the parts of the business across BPM, which are not on the market side are doing very well. We've talked about this in earlier calls as well, Ravi. The cross-sell is moving very well. We've been able to make forays into the travel BPO space. We've been able to very aggressively start getting into the analytics space, which is an allied area.

We've been able to cross-sell very effectively in the insurance space with the BPS offerings, which for the acquired entity, SLK were initially only on the BFS side. Interestingly, in this quarter, the BPM business, also signed a $20 million-plus deal. So 1 of the 5 large deals that I talked about was a BPM-led deal that we closed. Did I answer your question?

R
Ravi Menon
analyst

Yes. Great. And one more follow-up on this service line, data integration that seemed to have done really well over the last year or so. But this particular quarter, we've seen a decline there. I mean is there furloughs or some projects coming to an end, how should we see this?

S
Sudhir Singh
executive

Most of the business right now on the data side is with BFS. There are very significant furloughs in the BFS clients that we saw. That's why you see a temporary blip. Data analytics, we feel very, very good about it. It's really scaled up multiples over the last 2 or 3 years, and we see that growth continuing, hopefully, accelerating here.

Operator

The next question is from the line of Vibhor Singhal from [ Nuvama Equities. ]

U
Unknown Analyst

Congrats on the very strong deal flow from the previous quarter to this quarter. So sir, on the deal flow itself, if I could get some color on -- as you mentioned, there was a $50 million deal that we booked in the insurance segment. Would it be possible to provide some breakup of the $345 million? I mean, how was it -- in terms of vertical, what would be the number from banking, from travel and from the other verticals ?

S
Sudhir Singh
executive

Vibhor, I provided numbers around the [ geos ]. I can give you some more color around the 5 deals and where they came from. 2 out of the 5 deals were from the insurance vertical, which we suspect starting Q4 is going to rebound smartly. One of them was a D&A, data analytics-led deal from the BFS space. The fourth came in from the BPM profile that I talked about. So that's broadly where 4 out of those 5 deals came from. The GOI split is what I've given you.

If I look at the current quarter, the quarter that got over, most of the large deals were centered around the BFSI space became almost evenly from insurance and from the banking.

U
Unknown Analyst

Got it. Got it. That's really helpful. Also I just wanted to [indiscernible] from the guidance part. So we've upgraded our guidance in this quarter and maintained the guidance for the margins also and if -- I mean, in this quarter, of course, the growth was impacted because of a seasonally soft quarter.

Given the numbers that we have that [indiscernible] Q4, both in terms of growth and margins. Margins, I know you mentioned that we decided to spend more on [indiscernible] This time. which can be recovered next quarter in itself. But I think on the growth part, the required rate for the next quarter comes out to be quite steep.

So I mean, is this the deal flow that we got in this quarter that's giving us the confidence or the overall momentum that you are seeing. And a related question to that is slightly a little bit of a longer term. I mean how do you see, again, the next couple of quarters play out in terms of, I mean, the U.S. possibly heading into a slowdown, how the client conversations have been around that? And how do you see the deal mix changing because of that?

S
Sudhir Singh
executive

Let me take the questions in order. The first one was a question around the growth that we anticipate in Q4. The guidance that we give Vibhor and we've always given consistently is in organic constant currency growth. At the end of the first 9 months YTD the firm is already growing 22.9%. So the 22% at least 22% constant currency growth guidance by our estimates is a relatively conservative guidance.

We believe that we only need to grow in CC terms, 3.5% to get there. And clearly, given the momentum that we have, given the 5 deals that we've signed, given that we've just grown 3.7% in a shorter, seasonally weak, furlough-ridden quarter where mortgage industry was also seeing a very significant drawdown gives us confidence that we should be able to meet and exceed the annual 22% CC guidance that we talked about.

So that's answer one to question one that came from you. The second question from you was, how do we see the somewhat longer-term play out? And I did call that out in the commentary that I talked about towards the end. This is a good time in the year and I -- we actually at Coforge believe it's also a good time in the industry when the world is looking at uncertain macros to actually lean into growth, that has underpinned our very strong, very committed, very aggressive investments in sales, marketing, capability build and you've seen that in the current quarter itself.

So given the 5 deals, which will now start ramping up, I suspect we'll start seeing the impact effectively from Q1 of next year. This quarter is likely to be a transition. We feel that despite the uncertain macros despite the fact that -- there is a lot of ambient noise around what may or may not happen. We've been able to start insulating ourselves from a lot of that conversation.

The order executable, I told you, is the highest ever. The order intake was the highest ever. The number of large deals have been the highest ever. So clearly, there's a good ramp for the next few quarters, which hopefully will insulate us even if some of the worst-case scenarios start playing out, and we should continue to be on what we've always called out as robust growth. And I think it's going to be a very good time for us to prove that we can deliver sustained growth even if the market turns. So we're looking forward to it. We'll see what happens, but we feel good about the future.

Operator

The next question is from the line of Shradha Agrawal from Asian Markets Securities.

S
Shradha Agrawal
analyst

A couple of questions, our deals in insurance has been pretty strong, but somehow that has not reflected in growth for the last few quarters. Insurance has been on a soft trajectory. So do you see there is a delay in deal getting converted into revenue? Or is there something else which is holding back growth rates in insurance is question #1. And then I'll ask the other question.

S
Sudhir Singh
executive

Insurance, Shradha, quarter 4, which is the quarter that we're already in, we should see the clear turnaround and that vertical, that business for us get back onto a part that it should be. You're absolutely right. This quarter, we closed 2 large deals. We had a large deal closure, if I remember correctly, in the previous quarter as well. It takes a little bit of time to transition these deals to lean into these deals.

But Q4, the quarter we are in, insurance should be exactly where it's been for us over the last 4, 4.5 years. Do you have a follow-up, Shradha?

Operator

The line for Ms. Shradha Agrawal has got disconnected. We'll move on to the next question from the line of Rahul Jain from Dolat Capital. Rahul Jain from Dolat Capital, please unmute audio from your side and proceed with your question.

R
Rahul Jain
analyst

Congrats on strong performance. Sudhir, I'm sure you would share the precise guidance for FY '24 in April. But just to understand the math now, based on your 12-month order book, that is up 20% and also based on multiple conversations with the client and potential pipeline that the company is chasing. Is it safe to assume that we may be able to replicate the current growth momentum at least for next 2, 3 quarters, if not beyond?

S
Sudhir Singh
executive

It's a tricky question, and I think you'll know that yourself how did we posed it. We feel good. And I'm saying this again, and I wouldn't say this if we did not really feel good about where things stand, right? It's always a very sweet spot to be in when you can get into quarter 4. The new year is about to start and you have tailwind of 5 large deals, which will really start delivering from quarter 1 of next year. Clearly, there is a buffer. You talked about it, the order executable being at $845 million, the order intake being at $345 odd million that we booked at.

So -- the way I would characterize it is, I mean, one doesn't know the future, but everything that we could have done to insulate ourselves from a deteriorating or a significantly deteriorated macro in the quarters to come, we seem to have done a fair bit of it.

We feel, given our size, we're certainly not a large-scale IT player, we should be $1 billion IT services firm. Growth is as much a function of the ability of the firm to rest wallet share especially when things are slowing down by leaning into that opportunity as it is about what is the rate at which the broader market is growing.

Broad market is way too big. We still have a very small piece in that sand box. We think as things change, we should be able to expand wallet share, and we should be able to drive what I will for now characterize as robust growth. Hopefully, robust growth despite the macro is going up or not. And I'll leave it there, Rahul. I know it doesn't answer the question completely, but that's how I would present it.

R
Rahul Jain
analyst

Maybe, Sudhir, just a suggestion, which may help a lot of us is that I really appreciate that you came out with your first ever guidance at the most uncertain time -- and which somewhere says that you have some slight as an important word you always keep at least in your guidance, which is also a rare thing to see, which clearly says you have a certain grip or understanding or visibility on the kind of an outlook that you share?

So what if we could -- can think of giving guidance on a 12-month forward rolling basis rather than giving an annual guidance because that guidance at the beginning of the year is far more supportive of the thought. But as the year progressed, I mean having a guidance for Q4 now is not helping as much as it was helping me earlier. So maybe that's a different aspect, which we could work it over a period of time. Just a small suggestion.

S
Sudhir Singh
executive

No, I think it's a great -- it's a fantastic suggestion, Rahul. Thank you very much for that. And you're absolutely right. The first time we started giving guidance was around the time that COVID struck and we had very significant exposure to the travel industry. And which is why we thought it was imperative that -- we like to think we have a very strong execution engine and a very strong grip on the business that we step up to the plate and offer that guidance. I take your point.

The only response I will have to you is over the last 5 years, if you look at us, every quarter, we call out the next 12 months order book, right, which is what we call out as order executable. And if you look at our growth over the last 5 years, over the last 20 quarters, there's been a very strong correlation between the graph -- the order executable graph and the actual revenue recorded over the next 12 months.

So while we can't -- and you will appreciate this, while we can't keep on giving a 12-month forecast, we do try to give some comfort, some indication around how much is already locked in. And I think we have not just a fairly, I'd like to say a very good record in terms of a very strong correlation between the [ OE ] movement and the actual revenue that comes over the next 12 months. So I'll leave you with that part. But, when I will take your suggestion, and I think it's a fantastic suggestion.

Operator

The next question is from the line of Shradha Agrawal from Asian Market Securities. .

S
Shradha Agrawal
analyst

Sorry, I got dropped off. Just another question on BFS some larger IT names have expressed some concerns on capital markets. So from that perspective, what is our positioning in capital market in overall BFS? And how do we see macros playing out in that segment?

S
Sudhir Singh
executive

So capital markets buy side, especially Asset and Wealth Management, from our advantage, Shradha, has always been a good, happy hunting area. The big change that's happened within our BFS portfolio, what's actually driven growth for us really stemmed from that $105 million 4-year 8-month deal that we've announced about 1.5 years back, a very significant ramp-up in that bank. A very, very significant ramp-up in some of the other top 10 relationships that we have. So if I were to look at it, if I were to start characterizing how we look at BFS, we still see spend even on the capital markets buy side, when it comes to enterprise-wide modernization.

We see a lot of interest coming in around low code, no code, and we see data solutions still in demand. So as we see it, and if I were a betting person, we would still like to say that for the next few quarters, irrespective of the macros, irrespective of what we're already picking up, irrespective of the fact that BFS, we've seen very significant furloughs in the quarter that closed. That momentum from a Coforge BFS business perspective should sustain.

We've seen nothing as a leading indicator, given the pipeline that we have, the locked orders that we have to indicate that it will go down. That's how I would put it. There are issues, there are headwinds, but then given the momentum we have getting into that, we feel good about where we are, and we think it is likely to sustain.

S
Shradha Agrawal
analyst

That's good to hear. Another thing is of the 5 large deals that we closed this quarter was any deal driven by any vendor consolidation exercise taken by any large account? And were we on the favorable side of it or any cost takeout deal in the pipeline, the increasing intensity of cost takeout deals versus transformation deals? Anything on the deal pipeline and the deal closure with respect to vendor consolidations you can talk about?

S
Sudhir Singh
executive

Yes. I'm just reflecting on it as you speak. The $50 million deal was a clear vendor consolidation. And that came in, if I remember right, at about 55% over 3 years, and that was a win. That was a clear win.

The BPM deal was, again, interesting, smallest deal, but very material for us, $24 million deal. That again was a vendor consolidation. Cost is increasingly at play, John, you might want to add some perspective here. But in almost all of these 5 cost and transportation seem to be going hand-in-hand and transformation [indiscernible]. John, over to you for your comments.

J
John Speight
executive

Thank you, Sudhir. Yes, I mean, we are seeing an increased interest in cost optimization programs. Obviously, vendor consolidation is one of those levers that can be applied. I expect to see more and more use cases around costs coming through. We also see an awful lot of interest around process efficiency, again, looking to drive down -- to automate and reduce cost through efficiencies.

S
Shradha Agrawal
analyst

All right. If I can squeeze in one last question. So your margin guidance according to my calculation, still implies a 200 bps plus sequential improvement that is required in 4Q to even get to the lower end of the guidance band. So what do you think are the levers available to us to bring -- to have such a sharp margin improvement exercise to happen in 4Q ?

S
Sudhir Singh
executive

Yes, Shradha, if you reflect back on the first 2 quarters of this year, our margins were higher than the first 2 quarters of the previous year. Last year, our quarter 4 margin always has a variant last year, our quarter 4 margin was 20.4%. We need to add 170 bps over quarter 3 in quarter 4 to get to the lower end of the guidance. At the current point in time, we feel good about it, and I'll tell you why we feel good about it. A, because there was 100 bps impact in the current quarter because of the mortgage draw down.

A lot of our mortgage business is transaction linked. There is a lag between the volumes going down and the cost being taken out. The cost is now nearly up corresponding to the lower volumes. So that 100 bps is a natural flow that we will getting into next quarter. The other pieces, again, are the specific around the GDP numbers that we have.

I talked during my commentary around the fact that we have 1,000 GTs who are now getting billed, which is the second lever that comes in. And the third lever, of course, will continue to be a modicum of operating leverage that we've always got around margin. So our calculation shows we need to go up by about 170 bps.

And we feel that we should be able to do it. We need to deliver about 19.7%. Last year, we delivered 20.4% in quarter 4 given the fact that the offshore engine has scaled up far more than it was at the same time Q4 last year, we feel we will deliver, and that's why we made the discussion that we will deliver.

S
Shradha Agrawal
analyst

Just to add here, somehow my calculation shows that you need to get to 20.8% margin in 4Q, which is a 230 bps improvement. So is this discrepancy because of your guidance being in constant currency and we looking at dollar term -- sorry, we looking at reported EBITDA margin. I just want to get a confirmation on the margin guidance.

S
Sudhir Singh
executive

Ajay, do you want to address that?

A
Ajay Kalra
executive

Yes, Sudhir. Thank you, Sudhir. Shradha, basis our calculation, the margin uptake that is required is 170 basis points. It's between actually between 150 to 170 basis points, depending upon where our revenues will go. Since there is an uptick of the revenues from quarter 3 to quarter 4, that will also help us improve the margin from a peer perspective as well. So you need to factor that as well while calculating the margin uptick. We can talk about this offline...

S
Sudhir Singh
executive

We can have a follow-up with you on the exact calculations and...

Operator

The next question is from the line of Rishi Jhunjhunwala from IIFL Institutional Equities.

R
Rishi Jhunjhunwala
analyst

Sudhir, a couple of questions. Firstly, on the margin side, right? So if you really look at it over the past 5, 6 years, our gross margins have continuously trended down even if -- even though we have delivered industry-leading growth -- and you have recently talked about the expansion on the gross margin side in the near term as well.

I know -- to some extent, it was also in the last 2 years because of the pain on the travel and hospitality side. But just wanted to understand if you really look at us going up in terms of the margin band. Where do you think the gross margin profile ideally should be? And do we have those levers? Or is it structurally that we are going to remain around these levels?

S
Sudhir Singh
executive

So Rishi, if you look at this quarter, we walk the talk, right? The talk that you heard from us over the last 2 or 3 quarters, we walked at our gross margin and jumped sequentially by 133 bps. And we believe very strongly it's going to jump again sequentially in quarter 4 over quarter 3. So your question is valid, but I would point you to our numbers for the current quarter.

This quarter, gross margin has jumped very significantly. It's now at 33.4% from 32% last quarter. And we believe we're going to be certainly north of 33.4 million, and if I were a bidding man, I'd say more than 34% for sure in quarter 4. So I hear you. All I'd say is just look at current quarter, we walk the talk.

R
Rishi Jhunjhunwala
analyst

Understood. The other question is if we look at the trajectory of your year-on-year growth in executable order book for the last 3 quarters, we have seen some bit of acceleration from 16% to from 20%, from 1Q to 3Q. And this is despite the fact that during this period, the overall macro has continued to become worse or at least sentimentally worse. And if I look at it from the perspective of where your next 12 months or FY '24 growth could be even at 15% growth, it would imply that your executable order book as a proportion is probably one of the highest that we have seen in the past 4, 5 years.

So just wanted to understand in terms of conversion of this order book into revenues, how much of it would be dependent on macro not becoming significantly worse? Or the other way to put it is, what could be the risk to this revenue conversion, if at all?

S
Sudhir Singh
executive

There's no risk to the revenue conversion. This is locked in orders, Rishi. What we call out every quarter, 12-month locked-in orders, right? This is not a pipeline. This is what's already locked in. The risk really remains between the revenue that we're going for versus what we already have locked in. So very rarely do we find that what's already locked in kind of washes away.

If you were to go back and look at the order executable that we end in year with and the actual revenue that we recognize, I would disagree with the assertion that getting to 15% means that we have to significantly up what we already have. I think the order executable that we are at currently mathematically nobody knows how it's going to pan out in the future. It should make 15% of slam down for the future.

R
Rishi Jhunjhunwala
analyst

Yes. No, I was actually asking the other way around that it looks like you will definitely do at least that much. So -- was there a risk to that, that's was I was referring to. So okay..

S
Sudhir Singh
executive

Maybe that was a compliment that I did not grasp.

R
Rishi Jhunjhunwala
analyst

Yes, yes absolutely.

S
Sudhir Singh
executive

No, we -- we like to hope that we will. And I obviously think kind of wordsmith my way out of here by talking about robust growth, sustained growth. We've always had robust growth, sustained growth for the last 2 or 3 years. You can -- and I know that you know our revenue growth numbers over the last 3 years.

We still think despite the ambient noise, despite macros, which even in the best case, are likely to deteriorate somewhat. We've got enough of a tailwind to be able to push into the storm, if a storm does arise, and do -- and still deliver that robust growth trajectory. That's what all I can say, and I know you understand that. But we feel good about it. There's just a lot of good tailwind. There's momentum building up at the right time right now as we see for next year.

R
Rishi Jhunjhunwala
analyst

Yes. Yes. Fair enough. And one last question. Can you give some color on AdvantageGo? I mean it's clearly has been a differentiated product on the insurance side historically has done really well. Just wanted to understand where it is, how do you think about it progressing over the next couple of years? Are there any changes required in terms of growth or positioning of that product?

S
Sudhir Singh
executive

Yes. We realized about 6 months to 9 months, 2 to 3 quarters back, Rishi, that we definitely needed change within that business. That business has not been growing at the pace that the rest of the organization has -- to the extent that now it's likely just about 1 -- maybe 1.2%, 1.3%. Ajay keep me honest on this of our aggregate revenues, right? So this quarter, when I say this quarter, I mean quarter 3, we on-boarded Ian Summers, who was the CEO of Sequel, our biggest competitor -- our principal competitor in that same London Lloyd's Reinsurance Market. He's now become the business leader.

He is the person who's going to be driving this now in the London Lloyd's Reinsurance, the Bermuda and the U.S. market going forward. So long story short, abbreviating my answer, we recognize the fact that we needed a fresh pair of eyes to look at the business. We recognize the fact that, that business was actually pulling the firm down. And I'm not talking down in absolute towns, but in relative terms, and that we needed to relook at it.

Last quarter, I talked about the fact that we relaunched our underwriting platform and Ian and team are reconstructing the overall front end. Next year, not quarter 4. Next year, we think we should see in percentage terms -- it's a small business, in percentage terms growth from that business, it should be materially higher than what the firm will record. But again, absolute terms, given the size is not very material.

Operator

The next question is from the line of Rajiv from Citi.

R
Rajiv Berlia
analyst

Thank you for the opportunity. Just one question. If we look at your executable order book for order intake, it looks really good, robust, but at the same time, if I look at the head count, it is only up 2% Y-o-Y and the utilization is almost at its peak level. How do we connect all these 3 data points?

S
Sudhir Singh
executive

This is the first quarter, Rajiv, where you would have seen us not adding to the head count and that's largely because in the last 4 to 7 quarters, we very consciously kept our utilization low because there was a lot of supply side disruption. So we were operating at about 77%. Today, with the attrition rate having come down, in our case, to only about 15.6%, 15.8%. Today, given the fact that where the market is joining ratio, joining ratio is the number of people who are actually join you versus the offer has been rolled out gone up almost 20% to 25% over the last 3 to 4 months. We felt confident enough to be able to take that utilization up by 300 bps within a quarter, which both you and I know is a furlough-ridden shorter quarter, right? So that released a people that we could get into the billing pieces. For us, starting Q4, once again, you will see the same cycle which has been going on for the last 8 to 10 quarters continuing. Net head count will go up.

The second thing I want to point you to is when we talk about head count reduction, most of it in the current quarter was led by the mortgage BPS business. It's not a very material business, but it's a business that we do largely linked to volumes and we have to react very, very quickly to volumes going down.

So last 2 quarters has been [indiscernible]. Otherwise, where we stand today. I talked about this in my commentary as well. We have 1,000 GETs, graduate engineer trainees, who have either completed training or are undergoing training and it's a 6-month training in our case and are available to bill anytime, right? So we're not short of people who will be needed to staff the large deal that would be one, and starting Q4, you will start seeing the net head count back on the trajectory it's been in.

This was a utilization correction quarter. It's been a very significant jump in utilization in a seasonally weak furlough-ridden quarter. Next quarter onwards, we'll try to keep utilization at around 80%, 81%, possibly take it a little bit more and the rest is obviously going to come in by head count...

Operator

The next question is from the line of [ Ashish Das ] from Mirae Asset Capital Markets.

U
Unknown Analyst

So Sudhir you've spoken in your initial remarks, you talked about retail and public...

Operator

Sorry to interrupt Mr. Das, the audio is not clear from your line. Please use the handset mode.

U
Unknown Analyst

Hello, is it audible? Better now?

Operator

Yes, sir.

U
Unknown Analyst

Okay. So Sudhir, in your initial remarks, you talked about 2 subverticals, retail and public and you expect that to perform well going ahead. So I just want to know what type of -- what growth you reported in those subverticals in Q4? And what is the outlook going ahead?

S
Sudhir Singh
executive

So [ Ashish ] this is the first time you're right, when we called out the contribution. We are not calling out the growth numbers on a quarterly basis in this quarter or in the quarters to come. We will scale up a little bit more. Outlook, we think, is positive for both of them. We'd like to think very positive, which is why we're planning to carve them out at some stage of stand-alone verticals to become vertical #4 and #5 for the organization. John, do you want to add anything else to that or Ajay?

J
John Speight
executive

Nothing for me, Sudhir. I think you covered it well.

A
Ajay Kalra
executive

So for me, Sudhir, as well.

U
Unknown Analyst

So my second question is on your TTH vertical. So you reported a large deal in Q1 FY '23. So the last 2 quarters, you have not talked about any deals on TTH vertical. So we have good quality -- good competencies in TTH segment as well as client base also looks strong. So -- again, I just want to understand like are we winning deals -- how is the deal momentum in the TTH vertical and what kind of growth you are expecting in FY '24?

S
Sudhir Singh
executive

No. TTH this quarter -- this year should be -- and I'm talking TTH more from a North America and Europe perspective. We are anticipating pretty robust growth, 25% plus, and I'm talking broad at the current point in time, Ashish, from that piece itself. What's working very well for us, you're right, last 2 quarters, we haven't declared a material large deal, but the farming engine, something that John drives for the organization, right, has continued to chip away very, very efficiently. Travel, transportation, obviously, has rebounded, both the passenger side and the cargo side. There seems to be a lot of confidence and a lot of commitment around spend going up.

So spends are going up. We've been riding that wave. We've been farming. We had used the COVID period to rest wallet share, in many cases, become the only partner in a client situation. So we've been riding that wave. We've been growing through the farming engine on the travel side. It's not as if there are no large deals that we are pursuing, we are, but we had none to report over the last 2 quarters.

Operator

The next question is from the line of Hiten Jain from Invesco.

H
Hiten Jain
analyst

Sudhir, one question. So how do you think about the margins over the medium term in the next 2 to 3 years. Now given that there are definitely tailwinds on the supply side, we've got one of the lowest attrition in the industry. At the same time, the growth is looking quite strong.

So it depends on how do you think about investments in your business? Do you think investments will accelerate from here on? Or do you think operating leverage will be good enough for you to continuously report margin expansion going forward, given growth continues to be strong.

S
Sudhir Singh
executive

I think, we are very committed to margin expansion. We don't believe that growth for the sake of growth is the only goal that we should be going after. There are 3 things that give us a lot of confidence and which have allowed us to keep investing even in time like this when macros are uncertain on the margin front.

First, is what I called out. Our offshore revenue as a percentage of overall revenue is now 15.5%, the offshore factory has grown very significantly. Our CQGR in the last 6 or 7 quarters for offshore revenue has been almost 8%. So that structural tailwind needs along with the increased utilization, along with the fresher factory, the GET factory that is working, we think we should be able to move the margin needle materially.

The only call -- the execution call that Ajay and I have to take is when does one actually start letting the -- when does one start moderating investment and letting the -- some of these margin levers start impacting the bottom line. This quarter, and I talked about this earlier in response to a question, which had come from the IIFL team.

Gross margin has already gone up very significantly. So it's more a question of margin. At what point in time do we stop this very aggressive investment in sales, marketing and capability. We believe -- I'm just trying to make sure that I characterize this correctly. We believe that -- even as we stand as a firm, there are enough levers for us in the short term if we wanted to do a material uptick -- drive a material uptick around margins.

So a year -- 2 years down the line margins should be up. We have done a planning exercise where we planned around what we should look like at $1 billion, roughly where we are versus $2 billion. And we would expect the margin profile to be superior significantly superior at $2 million given the operating leverage that will come in.

Ajay, would you like to take this and add some more color around data...

A
Ajay Kalra
executive

Sure, Sudhir. As we have seen in this quarter, our gross margins have improved, but we have also done an investment. And as we go ahead in the near future, at least we will accelerate those investments and keep investing for future growth. However, as Sudhir mentioned, we will take the call on when to rain in those investments and start expanding the margins, and that should happen in a couple of -- in 1 year or from 1 year onwards.

S
Sudhir Singh
executive

I'm sure we've answered question but if you have a follow-up feel free to say.

H
Hiten Jain
analyst

No, no, it does give me a lot of color.

A
Ankur Agrawal
executive

Operator, just giving a time check here. We have time for one last question, please. And then, of course, we can individually follow up with everyone who has any questions. Over to you operator.

Operator

We'll take the next question from the line of Abhishek Shindadkar from InCred Capital.

A
Abhishek Shindadkar
analyst

Thank you for accommodating me and congrats on a good quarter. Sir, just one question. It seems that broadly for the quarterly earnings, we are hearing that the vendors have been able to defend when the consolidation deal is better. Any color in terms of who's losing right now in the market? And any particular mechanisms in terms of pricing, delivery or what's working for generally are -- any color would be really helpful.

S
Sudhir Singh
executive

I request John to step in as well. The only thing I can tell you is we certainly are not losing as you would have figured out. But John, would you like to talk about some of the levers that we're seeing in play?

J
John Speight
executive

Yes. No problem, Sudhir. I think one of the biggest things that we've been very, very successful at over the last few quarters -- years, it's actually been translating IT into business outcomes. We -- it's really resonated well with our customers. Obviously, it's all based on a very, very strong execution bias on delivery. But what we have actually accelerated has been the use of consulting, consulting-led solutioning and this has actually paid significant dividends in the positioning of our customers and also the types of conversations we're having with the customers and actually how we can then take that to closure on deals.

Operator

Ladies and gentlemen, that was the last question for today. I now hand the conference over to Mr. Sudhir Singh, CEO and Executive Director, Coforge Limited, for closing comments. Over to you, sir.

S
Sudhir Singh
executive

Thank you very much, ladies and gentlemen. I know it's -- it was early morning for most of you in India and for -- and possibly late evening for anyone who joined over from the states. Thank you very much for your questions. Thank you very much for your suggestions and your comments. We've always said this, and we've always meant it. The insights that you offer mean a lot to us. They help us significantly. Once again, thank you very much for it. And once again, a very, very happy New Year to you and yours. Thank you. Good night.

A
Ajay Kalra
executive

Thank you everyone.

Operator

Thank you. Ladies and gentlemen, on behalf of Coforge Limited, that concludes this conference call. Thank you for joining us, and you may now disconnect your lines.