Yahoo Finance Franklin Covey Co. (NYSE:FC) Q2 2024 Earnings Call Transcript
Franklin Covey Co. (NYSE:FC) Q2 2024 Earnings Call Transcript March 27, 2024
Franklin Covey Co. beats earnings expectations. Reported EPS is $0.06, expectations were $0.05. Franklin Covey Co. isn’t one of the 30 most popular stocks among hedge funds at the end of the third quarter (see the details here).
Operator: Good day, and thank you for standing by. Welcome to the Second Quarter 2024 Franklin Covey Earnings Conference Call. At this time, all participants are in a listen-only mode. After the speakers' presentation, there will be a question-and-answer session. [Operator Instructions] Please be advised that today's conference is being recorded. I would now like to turn the conference over to your speaker for today, Derek Hatch. Please go ahead.
Derek Hatch: Thank you. Hello, everyone. On behalf of Franklin Covey it’s my pleasure to welcome you to our conference call to discuss our second quarter fiscal 2024 financial results. We hope that you're enjoying good weather wherever you are in the world this spring or fall if you're in the Southern Hemisphere. Before we begin this presentation, we’d like to remind everybody that the presentation contains forward-looking statements within the meaning of the Private Securities Litigation Reform Act of 1995. Forward-looking statements are based upon management's current expectations and are subject to various risks and uncertainties, including but not limited to the ability of the company to grow revenues, the acceptance of and renewal rates for our subscription offerings, including the All Access Pass and Leader In Me memberships, the ability of the company to hire productive sales and other client-facing professionals, general economic conditions, competition in the company's targeted marketplace, market acceptance of new offerings or services and marketing strategies, changes in the company's market share, changes in the size of the overall market for the company's products, changes in the training and spending policies of the company's clients and other factors identified and discussed in the company's most recent Annual Report on Form 10-K and other periodic reports filed with the Securities and Exchange Commission.
Many of these conditions are beyond our control or influence, any one of which may cause future results to differ materially from the company's current expectations and there can be no assurance the company's actual future performance will meet management's expectations. These forward-looking statements are based on management's current expectations and we undertake no obligation to update or revise these forward-looking statements to reflect events or circumstances after the date of today's presentation except as required by law. With that out of the way, we'd like to turn the time over to Mr. Paul Walker, our President and Chief Executive Officer. Paul?
Paul Walker: Thank you, Derek. Hello, everyone. Thanks so much for joining us today. We're glad to have the opportunity to talk with you. Joining me today are Steve Young, our CFO; Jennifer Colosimo, the President of the Enterprise Division [ph]; Sean Covey, the President of the Enterprise Division and other members of our executive team. Our results for the second quarter came in right in line with our expectations with revenue of $61.3 million and adjusted EBITDA of $7.4 million, which was slightly stronger than expected. And our free cash flow was stronger than expected, $24.7 million in the first two quarters of this fiscal year. In addressing our performance for the quarter and year-to-date, I thought I'd start out by organizing my comments into three categories.
First, the areas that we have -- there have been a challenge in which we're not particularly pleased with. The second, the areas that are going well and that we're encouraged by. And then third, three areas of focus that we're really excited about and that we believe are going to accelerate our growth. First, let's talk about the areas that have been a challenge in which we're not particularly pleased. I'm not pleased that our services sales didn't rebound as rapidly as we thought and that as a consequence, reported revenue for both the third and fourth quarters and for the year are going to come in lighter than we expected when we reported our Q1 results. As a result, rather than achieving low double-digit revenue growth in the back half of this year, as we had expected, we now expect reported revenue to grow approximately 1% in Q3 and 6% in Q4.
I'm also not pleased that since last fall, there's been an environment in which companies decision-making has been extended longer than normal. During the late summer and early fall, as interest rates spiked, many organizations either eliminated costs or pushed off decision-making. This impacted 2024 budgets and created a more difficult selling environment for us in the first half of fiscal 2024. And finally, I'm not happy that even though we do expect adjusted EBITDA to increase significantly this year to $54.5 million in constant currency that result will be only within the low end of our guidance range of between $54.5 million and $58 million. Second, I would like to share a few things that are going well and which we are excited about and encouraged by.
The first of these, as I said a moment ago, we're now expecting reported revenue to grow approximately 1% in Q3 and 6% in Q4, which is accelerating from the first half of the year. And I just want to point out, this 1% and 6% reported revenue is largely revenue that's converting from prior period sales activities and is also muted somewhat by lower-than-anticipated services sales, and those services are recognized in the period that they are sold and delivered. In our subscription model, the majority of what we'll actually sell between now and the end of the year will not be recognized this year but would be deferred and add to our growing deferred build and unbilled subscription balances to come into revenue and be recognized next year. The volume of subscription sales we're selling today and that we expect to sell in Q3 and Q4 is actually growing at a rate faster than the 1% and 6% reported growth that we're expecting in this year.
This will put, as I mentioned, more deferred build and unbilled revenue on the balance sheet to come into revenue next year, and that's happening at the same time we're beginning to see our services sales, our booking pace and our services sales accelerate. The second thing that I'm pleased by -- pleased about is that despite the economic environment and revenue being lower than expected, we expect that both the company's overall revenue and the revenue in both the enterprise and education divisions will still reach all-time highs in the third and fourth quarters on top of all-time high comparisons from the previous year. And I'm pleased that revenue in the overall business has grown significantly over the past four years to more than $280 million.
Third, I'm pleased that in addition to generating record levels of revenue due to the strength of our business model with its high recurring revenue, strong gross margins, SG&A that declines as a percentage of revenue and low capital intensity, we expect both adjusted EBITDA and cash flow to come in strong for the year. We expect adjusted EBITDA for the year to increase to approximately $54.5 million in constant currency, up from $48.1 million last year. We also expect to generate a very significant amount of free cash flow for the year. As I mentioned, year-to-date, through this year's second quarter, free cash flow has been $24.7 million compared to $3.3 million through the second quarter of last year. As you'll recall, free cash flow in the first half of last year was reduced somewhat as a result of changes in working capital.
And what I'm really pleased with is the resilience we've been seeing in the enterprise and education businesses and with the positive direction of some of the recent trends we're seeing across key parts of the business. I thought I would just share for first a few of the points of resilience we're seeing in enterprise and education and then a comment or two about some of the trends and leading indicators. In the Enterprise division, each of our six key indicators remain strong and resilient in the second quarter and year-to-date. First, we had very strong logo retention. In fact, the second quarter was one of the best quarters we've ever had in terms of logo retention. Second, our revenue retention for the quarter and year-to-date was also very strong, continuing to be higher than 90% and with the pattern of client renewals being consistent with historical patterns.
Third, as shown on Slide 4, our subscription revenue also grew to an all-time high for the second quarter, year-to-date, and latest 12-month periods, reaching $26.3 million in the quarter, that was up 9%; $53.1 million year-to-date, up 11%; and $104.5 million for the latest 12-month period, which is up 9%. The fourth point about Enterprise is that the percentage of total All Access Pass contract value for multiyear periods increased to a historic high 62% compared to 57% at the end of Q2 last year. And in addition, the percent of total All Access Pass contracts, which are for multiyear periods, increased to a historic high of 56%, up from 50% at the end of Q2 last year. The fifth point is that our deferred revenue billed and unbilled reached an all-time second quarter high balance of $128.7 million versus $124.8 million at the end of last year's second quarter.
And finally, to round out Enterprise, our total subscription and subscription services revenue increased to record levels for the second quarter, year-to-date, and latest 12-month periods with $37.5 million of subscription and subscription services revenue in the second quarter, $79.1 million year-to-date, and $162.1 million for the latest 12-month. While this combination of subscription and subscription services sales achieved a historic high watermark, its growth rate was muted somewhat by the fact that while clients have continued to purchase, renew, and expand their All Access Pass subscriptions and purchase a substantial number of subscription services as noted, they have been purchasing a somewhat smaller amount of those services. This is a pattern we've seen and spoken about over the last couple of quarters.
In the Education division, as shown on Slide 5, Education subscription revenue grew also to an all-time high for the second quarter, year-to-date, and latest 12-month periods, reaching $9.5 million in the quarter, that was up 7%; $19.3 million year-to-date, that's up 7%; and $40.9 million for the latest 12-month, up 10%. Second, in Education, amounts invoiced also grew to an all-time high for the second quarter and for the year-to-date and latest 12-month period, reaching $9.8 million in the quarter, representing 23% growth; $18.1 million year-to-date, that's up 14%; and $79.7 million for the latest 12-month or growth of 13%. And third and finally, for Education, while it is still early in our contracting year, the number of new schools we've contracted is significantly higher than it was at the same point last year, a year in which we added a record number of schools.
In addition, the number and percent of schools retained is also up significantly year-over-year. I'm also particularly encouraged by the progress we're making on many of the important leading indicators that point toward accelerating growth and thought you might find a few of these interesting and helpful. Specifically, I'll talk about the areas of new client acquisition and then, of course, services bookings. First, related to new client acquisitions, we closely track the leading indicators related to new client revenue growth. Two important metrics in North America are the number of people participating in our marketing events were thousands of prospective clients join us throughout the year to learn more about Franklin Covey solutions. And second, the volume of new client acquisitions that actually enter into our pipelines.
As it relates to the number of people participating in our marketing events, we're very pleased with the year-over-year growth we're experiencing in that participation rate and particularly over the past 120 days. We're experiencing a meaningful increase in attendance on a year-over-year basis, and this strengthening is due in part to high interest in our new speed of trust and navigating difficult conversation solutions as well as general interest in our overall solutions to help organizations improve leadership, culture and execution. We would expect this increase in participation rates to lead to an increase in new client opportunities entering our pipeline and it is. As it relates to increases in the volume of new client opportunities that are entering our pipeline, over the same last 120-day period, our pipeline of new client acquisition opportunities has also increased steadily on a year-over-year basis.
While we, of course, don't close every opportunity that enters our pipeline, this acceleration in new client pipeline is a positive leading indicator of future new client growth, of course, that we can then add services to and expand and retain. The second area I would just talk about as it relates to these leading indicators is we closely, as you would imagine, watch our subscription services booking pace. Booking pace is important because before we can deliver services, we first need to book them and get them scheduled with the client. Just maybe a note about services. When a person buys a subscription, whether that's All Access Pass or Leader in Me, included in that purchase is access to either an implementation strategist in our enterprise division or a leader in me coach in the education division.
And they're there to help the client drive maximum impact of their subscription. In addition to those services, which are included in the subscription, clients can also purchase access to Franklin Covey delivery consultants to train and coach their employees on an as-needed basis to help deepen the impact. When we refer to subscription services, it's those services we're talking about. Prior to the pandemic, the attachment rate of services to All Access Pass subscriptions has steadily increased, reaching 55%. So 55% -- $0.55 of every dollar in every dollar of subscription was represented by subscription services. We reached that level in 2019. During and in the post-pandemic work from home environment, clients took advantage of our tremendous live online services delivery capability to engage their remote workers and this pushed our services sales above their normal attach rates all the way to 60%.
That specific pandemic and post-pandemic use case has moderated somewhat, and our return to the pre-pandemic high services attach rate is actually a primary contributor to our reduced services sales this year. We expect the services attach rate to be high, we expect it to end the year at 55%, which is about what it was pre-pandemic. However, despite the environment and despite this tougher comp, we've been encouraged from a leading indicator standpoint, that in our US and Canada Enterprise business, our services bookings, again, a leading indicator of future services revenue, which has been down to prior year, 60 days ago and in the last 60 days is now ahead of prior year. While the purchases of services over the past couple of quarters have been down slightly compared to last year's elevated levels, we expect increases in the purchase of services to be a strong contributor to our revenue growth in the second half of this year and into next year.
First, we expect to achieve strong services revenue growth in the education division, particularly in the fourth quarter when new schools and districts typically complete a meaningful portion of their onboarding training and coaching prior to the start of the new school year. And second, as I've shared, we also expect to see a rebound in -- All Access Passes clients purchase of subscription services in the enterprise division. I'm encouraged by these trends and thought you might find those insights into the business interesting and hopefully helpful. So, so far, I shared with you what I'm not pleased with and also areas that we're encouraged by. And I'd now like to transition to my third point, before I turn time to Steve, which is to talk about some areas in which I'm excited in which we believe will accelerate our growth.
I'd like to briefly share three big executable opportunities for accelerating our growth that are right in front of us, and we're executing on these key initiatives, which we expect both individually and collectively will make major contributions to not only continuing this growth but to meaningfully accelerating it. As shown on slide 6, the first of these opportunities is what I'm going to refer to as project penetration. Since the launch of All Access Pass eight years ago, the company has become quite good at retaining All Access Pass clients, expanding All Access Passes penetration levels within these clients and providing clients with best-in-class services to help them achieve their most important jobs to be done. As a result, the average revenue per All Access Pass holder has increased from approximately $54,000 in fiscal 2018 to more than $83,000 at the end of fiscal 2023.
A significant as this growth has been approximately three years ago, in an effort to see how high up might be in terms of client impact and therefore, in client expansion and penetration, we organized an increased number of client-facing resources around a subset of our client partners in North America to create client Impact Pod's. These pods included providing client partners involved in this test with access to one or more implementation strategists, the services of client success specialists and the ability to access Franklin Covey's deep bench of delivery consultants to help in the implementation of client solutions. Under the direction of the client partner, this Impact Pod's sole focus has been to help client's achieve such great results that we would earn the right to expand our solutions even further throughout the client organization and create clients for life.
This group of client partners who directed the activities of these Impact Pod's were set up to have the same number of potential accounts assigned to them as did the traditional client partner group of similarly experienced client partners. They also had essentially the same number of All Access Pass holding clients as did the traditional group. And so therefore, what have the results been. While both the Impact Pod Group and the traditional client partner group achieved very strong results, by comparison, the results of the Impact Pod Group have been truly extraordinary along several key dimensions. I'll outline four of them here. First, as shown on slide 7, the size of the average All Access Pass subscription contract where the client partners and the Impact Pod's average All Access Pass size grew to $80,000, whereas the traditional client partner groups average All Access Pass size grew to $45,000.
Second is the subscription services attach rate. Both the Impact Pod and the traditional client partner groups achieved significant growth in their services attach rate. However, the Impact Pod's subscription services attach rate now represents more than 67% of the amount of their All Access Pass subscription itself compared to a services attach rate of 50% for the traditional client partner group. Third, the combined subscription and subscription services revenue per All Access Pass holder, so the sum of those first two metrics, where the Impact Pod now achieves an average of $132,000 per All Access Pass client compared to an average of $63,000 per All Access Pass client for the traditional group. And fourth, the logo retention rate. While the All Access Pass logo retention rate is very high overall, the Impact Pod annual logo retention averages are more than 500 basis points higher than the traditional client partner group.
As a result of these -- the combined impacts of this focus, our top-performing client partners used to average approximately $1.5 million in annual revenue, now average between $2.5 million and $3 million, with several generating more than $3 million each year. This compares to average revenue for all client partners of approximately $900,000. Importantly, as significant as the penetration and increases in revenue event for the client Impact Pod group, each still has tremendous opportunities for growth. We're still only penetrated 10% to 15% of the way into these clients' total populations and potential. Project penetration's potential impact on accelerating revenue growth is quite significant. For example, if its full implementation resulted in the average client partner generating even an extra $300,000 per client partner or 20% of the increase achieved by the Impact Pod Group, this would ultimately add nearly $40 million of incremental revenue compared to the normal client partner ramp.
And as much as the Impact Pod is simply a resource pool, which can be accessed by a number of client partners, and since we already hired and trained the significant number of client-facing team members to populate additional pods, so we'd be in a position to expand the rollout of project penetration in the coming quarters, as noted several earnings calls over the past year, the incremental flow through of this increased revenue to adjusted EBITDA and cash flow is expected to be high. So we're excited about project penetration. The second of these targeted growth acceleration opportunities as shown on slide 8, is what I'll refer to as Project Speed to Ramp. New client partners primarily focus on winning new clients or new logos and then retaining and expanding our business with them.
The focus of project speed to ramp is in the name. Its focus is to significantly increase the number of new client logos, which ramping client partners add each year. This will accelerate the ramp trajectory and increase the number of clients with whom we can then continue to penetrate and continue to grow over many years. For context, in addition to increasing our penetration of existing subscription clients, another of our key strengths over many years has been our ability to hire, train and ramp up new client partners. We've generally counted on these client partners to prospect and generate their own business from a list of accounts provided to them, and we've established a strong infrastructure to support them in doing this, including things like to recruit new client partners, we've built a strong team that uses all the latest recruiting tools, has a strong social media presence and a rigorous interviewing process to ensure that new recruits to meet our established profile of a successful client partner.
Once recruited, these client partners are assigned a list of named accounts and are responsible for penetrating that list and winning new clients. Our efforts to support these new client partners as they ramp up include having them go through an extended live and live online sales school, providing sales mentorship with lots of sales presentation aids, holding many hundreds of live and live online thought leadership events to which they can invite potential and prospective clients, and assigning them to a managing director who works with them weekly, going on sales calls with them and who has them go on calls with more experienced client partners and does many other things to support them in their development. This process, which we continue to regularly refine, has been quite effective.
As a result, our number of client partners has grown significantly and their ramp up has driven significant sales growth across the world. Over the years, while primarily relying on client partners to generate their own new business from a list of qualified accounts provided to them, we've also tested and work to establish various ways to further accelerate the speed at which they ramp up, while at the same time, continuing to increase the revenue growth rate for already ramped client partners. The focus of what we're calling Project Speed to Ramp is to further accelerate client partners Speed to Ramp by focusing on both sides of the math of acquiring new clients. The first side is significantly increased the percentage of a client partner's time that has spent making sales presentations versus the time spent prospecting.
This will involve implementing a significantly expanded lead generation effort, which we've been testing, including both inside and outside lead generation activities. And second, at the same time, increasing the percentage of sales presentations that are successful in acquiring a new client. This will involve having a much higher percent of the ramping client partner sales presentation be done in partnership with somebody who's more experience, a sales coach or a partner. We've tested these two efforts in a variety of circumstances and are really excited about the results and the potential Project Speed to Ramp has to both accelerate ramp time for new client partners and increase their total revenue once ramped. As we add more than 100 net new client partners in the coming years, this powerful combination of faster ramp and higher trajectory could add tens of millions of dollars of incremental profitable growth.
Importantly, because the investments already being made and relatively modest incremental investments required to implement projects penetration and Speed to Ramp and the high gross margins generated on incremental sales, we can make the required incremental investments to accelerate revenue growth and still maintain our position as a high EBITDA, high cash flow growth company. As part of the implementation of Project Penetration and Project Speed to Ramp, we've recently completed an evaluation of the size and deployment configuration of our approximately 290 client partners and our more than 150 additional client-facing field teams of business developers, implementation strategists and leader in the coaches. Through this evaluation, we determined two things: first, that we should place a few additional resources in roles to focus on business development and account penetration.
And second, that we had approximately 8% of our client partners or 24 in total, who didn't fit within our planned future field deployment structure. As a result, we made the difficult decision to separate from these client partners. This is temporarily reducing our number of client partners from approximately 290 to approximately 265. This refinement of our client partner force is similar in nature and scope to the refinement we made in 2016 when we moved to a subscription model. And the cost is reflected in the restructuring charge on the income statement. We expect to begin aggressively hiring new client partners in fiscal 2025 and beyond as well as continue adding to our important client-facing field roles as we fully implement Project Penetration and Project Speed to Ramp.
The third growth accelerator idea or a project that we're working on that I'd like to talk about here is what we're calling Project Impact, as you can see on Slide 9. The substance of this third key growth opportunity is our ongoing investment in developing high-impact solutions to drive collective action at scale. As you know, we partner with organizations to address their most important people-related challenges, that of developing leaders at all levels, building winning cultures and creating a system of execution to achieve breakthrough results. We achieved these goals with our clients by flexibly delivering world-class solutions that seamlessly generate behavior change at scale. The solutions we implement do not simply create individual performance improvements or pockets of excellence.
We work systematically to transform performance across an organization. To that end, I'd like to provide a few product updates and the results of those products -- those product updates. In order to help our partner organizations achieve breakthrough results, we develop principal centric industry-leading solutions and technology that allow for seamless, flexible, scalable, impactful deployments. Over the past two years, we've significantly expanded the scope of our efforts. And as shown on Slide 10, in the last six months alone, we completed and launched leading and working at the speed of trust. This substantial update and refinement to our industry-leading winning culture solution, both modernize the solution, so it's increasingly relevant and applicable for contemporary work cultures and by launching a scalable working at the Speed of Trust companion solution extended the impact to individual contributor audiences.
Three months post launch, leading at the Speed of Trust has earned a Net Promoter Score of a remarkable 78, representing a 34% increase compared to our previous world renowned solution, making them among our highest performing solutions to date. And importantly, through our investments in technology, including the Impact platform, working at the Speed of Trust has been assigned on demand to more than 10 times as many learners as the previous solution. The second product-related update is that we launched an important and hard hitting new communications offering entitled, Navigating Difficult Conversations. We did -- we launched this in February. It's an extremely engaging solution that helps individuals and teams adopt the paradigms and gain the skills necessary to have the kinds of high-impact conversations that can move relationships and teams forward.
And it does so in an action-packed two-hour session that meets the time demands of modern workers while maintaining Franklin Covey's principal centric inside out, world-class quality differentiation. This solution has garnered more client interest than any new solution launch in the last three years. And within one month of launch, has already been adopted by clients twice as much as any other skill specific solution we've launched. Third, we launched a top-level solution selling offering entitled Helping Clients Succeed, Strikingly Different Selling. This leverages the intellectual property we've had in our traditional Helping Clients Succeed sales offerings. We launched this in January. The solution was designed leveraging the latest science of learning research and with the Impact platform in mind, utilizing unique blend of asynchronous and synchronous experiences that will drive improved measurable selling outcomes for business-to-business sales.
Early client reactions are overwhelmingly positive. Our Impact Platform has now become an industry-leading technology solution. The Impact Platform, our proprietary learning platform where clients can easily launch, manage and measure compelling behavior change experiences has evolved into an industry-leading technology solution. In the past six months, we've launched the Impact Platform in over 20 languages, built a robust diagnostic experience to measure behavior change over time, built one-of-a-kind functionality for clients to launch their own client facilitated courses and integrated with popular LMSs and LXPs. Over 80% of our clients are now upgraded to the Impact Platform and clients who have upgraded assigned 4 times as much content to their employee populations and participants now complete 10 times as much content as those on the Legacy All Access Pass portal.
We expect to upgrade a 100% of our clients by January 2025. Just a couple of notes about upcoming product developments. An updated 7 habit solution, we'll be launching in the fall of 2024. 7 Habits, our flagship solution for individual effectiveness is undergoing its most substantial revamp in a decade. The solution is being reimagined to engage modern workers globally. We've completed the most extensive development and beta testing we've done for any solution to date, and we're receiving rate reviews in the early pilots and beta testing, and we're eager to unveil the solution this fall. And finally, our clients are expressing delight at the increasing access, engagement and enjoyment and the impact of the learner experience we've been working on.
This spring summer and fall works, excited to unveil substantial improvements to our industry-leading Impact Platform. We'll launch our first ever native mobile apps, learner and facilitator certificates to incentivize completion and awareness, a powerful AI coach and enhancement to the admin experience will make it easier -- even easier to launch, manage and measure behavior change at scale. Stepping back, I'm very pleased about these three key projects: Project Penetrate, Project Speed to Ramp and Project Impact, and we have high expectations that they'll drive increased growth in the coming quarters and years and would now like to turn some time to Steve to talk about some of our results in the quarter more specifically.
Steve Young: Thank you very much, Paul. Good afternoon, everyone. It's a pleasure to be with you today. I'd like to briefly provide more detail on the factors underlying our performance, focusing on the overall company results for the quarter. And then on the results in three key areas of our company, specifically, our Enterprise business in North America, our Enterprise business internationally and our Education business. Since I'm focusing just on these three areas, I'd like to point out to everyone as you probably already know that in our slide deck appendix, we include the current balance sheets, income statements. And other financial information will allow you to see our complete results for the quarter and year-to-date.
So for the company. As shown on Slide 11, second quarter sales were $61.3 million, which, as we expected, was roughly even with the record $61.8 million we achieved in the second quarter of last year. Year-to-date sales were $130 million compared to $131 million in the prior year. And for the latest 12 months, sales were $279 million compared to $276 million in the prior year. These results are essentially even with the record levels achieved last year with year-to-date sales down about 1% and the latest 12-month sales up about 1%. Second quarter adjusted EBITDA was $7.4 million this year compared to $8.2 million last year. Year-to-date adjusted EBITDA was $18.4 million compared to $19.7 million in the prior year. And the latest 12 months adjusted EBITDA was about $47 million compared to about $44 million in the prior year.
Now as shown on Slide 12, results in our Enterprise business in North America continued to be strong in the second quarter in the latest 12 months. Sales in North America, which accounts for about 73% of total Enterprise Division sales was $34.1 million in the second quarter, $72.5 million year-to-date and $150 million in the latest 12 months. Revenue achieved in this period, you can see is essentially even with prior years, which were themselves up 8% in the quarter, 12% year-to-date and 15% for the latest 12 months. So even compared to last year, but last year was up seemly compared to the prior year. Subscription sales in North America were $22 million, growing 5% in the quarter or $44.5 million year-to-date, which is up 6% and $87.8 million latest 12 months, which is also up 6%.
The combination of subscription and subscription services sales in North America was $31.5 million in the second quarter, representing 4% growth on top of the 7% achieved in last year's second quarter. These sales were $66.3 million year-to-date, which is up 2%, and they are $136.4 million in the latest 12 months, which is up 4%. Our balance of deferred subscription revenue build and unbilled in North America continued to be strong, growing to $117 million in the quarter, which is up 3% on top of the 22% growth achieved in last year's second quarter, establishing, as Paul talked about, the strong foundation for next year's growth. The percent of North Americas All Access Pass' for multiyear periods increased to 56% from 50% last year, and the percentage of invoice sales represented by multiyear contracts increased to 62% from 57% last year.
Now, as shown on Slide 13, revenue from our international operations, which accounts for approximately 17% of our total Enterprise Division revenue was $7.2 million in the second quarter, which is even with last year and was $16 million year-to-date, which is down about 4% and $34.5 million in the latest 12 months, which is up about 5%. As also shown on Slide 13, our international licensee partner sales were $2.7 million in the second quarter, a decrease of 6%. There were $6.1 million year-to-date, which is even with last year and $11.6 million in the latest 12 months, which is up 3%. So if you kind of cut through all of these numbers, you can see that in the Enterprise division, our subscription business is generally up, while our other revenue is generally down, making the overall result essentially flat.
The fact that it's our subscription business that's up, like Paul talked about encourages us as we look forward to future quarters and years. Finally, as shown on Slide 14, sales in our education business, which generally accounts for about 25% of total company sales, grew to $14.6 million in the second quarter, up 3% on top of the 28% growth achieved in the second quarter of FY '23. Year-to-date sales grew to $29.3 million, up 3%, and sales for the latest 12-month period were $70.5 million, up 4% on top of the 22% growth in the previous year. Education subscription and subscription services sales grew to $12.9 million in the second quarter, up 4% on top of the 30% growth in last year's second quarter. Year-to-date, sales grew to $26.1 million, up 2% on top of the 27% in year-to-date growth achieved last year's second quarter.
In the latest 12-month, Education sales were $65.2 million, which is up 4% on top of the 23% growth achieved in the same latest 12-month period last year. Education's balance of deferred subscription revenue billed and unbilled, increased by $10 million to $30 million versus last year's balance. As you recall, not many years ago, the Education business was small and had a traditional services and materials business model. We are pleased that since the launch of the Leader in Me subscription in the Education division, revenue has grown substantially from just over $3 million in the first year to more than $70 million in the latest 12-month. And Education's business model has transformed to closely mirror that of Enterprise with approximately 90% of Education's revenue now represented by subscription, subscription services revenue.
We also expect that after years of accelerated investment, the Education division's adjusted EBITDA margins will also expand this year and beyond. Now, cash flows and the balance sheet. As shown on Slide 15, our year-to-date cash flows from operating activities was $30 million this year versus $11 million last year. Our free cash flow for the first two quarters increased to $24.7 million compared with $3.3 million for the prior year, reflecting the changes in the elements of working capital were very favorable in the first and second quarters of this year compared with last year, particularly reflecting changes in accounts receivable, accounts payable, accrued liabilities, and deferred revenue. In Q1 and Q2, we invested $18.4 million to purchase 461,000 shares and over the past four quarters, we've invested more than $49 million to purchase shares.
We ended the quarter with over $103 million in total liquidity, including $40.9 million in cash and $62.5 million available under the revolving credit facility, even after investing the $8.4 million investment in stock -- $18.4 million to repurchase stock. Compared to Q2 of FY 2023, the sum of billed and unbilled deferred subscription revenue increased 9% to $158.5 million, giving us a substantial and increased visibility into future sales results. The deferred subscription revenue increased 13% to $86 million, while the unbilled deferred revenue increased 4% to $73 million. We continue to report a very strong balance sheet. Now, guidance. In our first quarter earnings call, we communicated that we expected revenue in the back half of this fiscal year to be higher than in the first half and that we expected to finish the year with adjusted EBITDA at the bottom of our range of between $54.5 million and $58 million in constant currency.
While we expect our back half revenue growth to exceed that which we achieved in the first six months, we expect the absolute amount of that growth to be lower than the low double-digit growth that we had expected for the back half. This is in large part due to the fact that though our expected rebound in services is occurring, it began a bit later than we had anticipated. As a result, we now expect total sales for the year to be lower than previously expected, with growth of approximately 1% in the third quarter, increasing to approximately 6% in the fourth quarter. Despite this lower revenue, we still expect adjusted EBITDA to come in at the bottom end of our previously announced guidance range of $54.5 million to $58 million in constant currency.
This result reflects, one, expected high flow-through of incremental revenue to adjusted EBITDA driven primarily by our high gross margin and declining SG&A as a percentage of sales. two, the restructuring event that Paul talked about; and three, the fact that a significant portion of our compensation throughout the company is tied to growth in sales and overall financial performance. For Q3, we expect net sales to grow approximately 1% as said to approximately $72 million and adjusted EBITDA to be between $12 million and $13 million, reflecting a midpoint increase of approximately $600,000 over the prior year. Our back half projections are consistent with our current expectation that add-on sales will continue to strengthen. As we've talked about and that our education division will have a very strong Q3 and Q4.
So I'd now like to turn time back to Paul.
Paul Walker: Steve, thanks so much for that. Thanks for going through the quarter. And why don't we now invite Lisa to open the call up to the questions as she does that. I'll just say we feel very good about the building momentum we're seeing in the business and are looking forward to a good back half and a good fiscal 2025. So Lisa, let's take some questions.
See also 12 Best Places to Retire in New Hampshire and 25 Richest Billionaires in Automotive Industry.
To continue reading the Q&A session, please click here.
