Good day, ladies and gentlemen, and welcome to Red Violet's Second Quarter 2022 Earnings Conference Call. At this time all aprticipants’ are in a listen-only mode. Later, we will conduct a question-and-answer session and instructions will follow at that time. [Operator Instructions] As a reminder, this call is being recorded.
I would now like to introduce your host for today's conference, Camilo Ramirez, Vice President, Finance and Investor Relations. Please go ahead..
Good afternoon, and welcome. Thank you for joining us today to discuss our second quarter 2022 financial results. With me today is Derek Dubner, our Chairman and Chief Executive Officer; and Dan MacLachlan, our Chief Financial Officer. Our call today will begin with comments from Derek and Dan, followed by a question-and-answer session.
I would like to remind you that this call is being webcast live and recorded. A replay of the event will be available following the call on our website. To access the webcast, please visit our Investors page on our website, www.redviolet.com.
Before we begin, I would like to advise listeners that certain information discussed by management during this conference call are forward-looking statements covered under the safe harbor provisions of the Private Securities Litigation Reform Act of 1995.
Actual results could differ materially from those stated or implied by our forward-looking statements due to risks and uncertainties associated with the company's business. The company undertakes no obligation to update the information provided on this call.
For a discussion of risks and uncertainties associated with Red Violet's business, I encourage you to review the company's filings with the Securities and Exchange Commission, including the most recent annual report on Form 10-K and subsequent 10-Qs.
During the call, we may present certain non-GAAP financial information related to adjusted gross profit, adjusted gross margin, adjusted EBITDA and adjusted EBITDA margin. Reconciliations of these non-GAAP financial measures to their most directly comparable GAAP financial measures are provided in the earnings press release issued earlier today.
In addition, certain supplemental metrics that are not necessarily derived from any underlying financial statement amounts may be discussed and these metrics and their definitions can also be found in the earnings press release issued earlier today. With that, I am pleased to introduce Red Violet's Chairman and Chief Executive Officer, Derek Dubner..
identifying risk and customer acquisition. Use cases include identity verification, risk mitigation and due diligence, which are addressed through our idiCORE and FOREWARN solutions. Additionally, we provide marketing solutions in the way of consumer modeling and identification.
Not surprisingly, given the cooling housing market in the face of spiking mortgage rates, persistently high prices and low housing supply, our real estate marketing segment reduced spend.
Many of these customers expressed that it is simply a matter of rapidly changing conditions in a matter of a few months, which makes it more difficult to forecast spend against ROI. And that once conditions settle into a more stable and predictable baseline, they will have more visibility to budget and resume volumes.
Our collections vertical remained relatively flat over last quarter. As we have detailed in the past, the collections vertical was first impacted by government-imposed forbearance programs and moratoria on collection efforts, arising out of the pandemic shutdown.
Coupled with the foregoing, government subsidies and savings generated by consumers' inability to travel and shop during the pandemic period, padded consumer balance sheets, with subsidies behind us and inflation at a 40-year high impacting food, gas and other daily expenses.
While the consumer is working and presently displaying resilience, evidence is mounting that the financial health of the average consumer is deteriorating. Consumer sentiment is at an all-time low. The consumer has cut back on the purchase of goods and is now focused on services.
And at the lower end, where signs of stress occur first, the subprime lower-income consumer is experiencing an uptick in auto delinquencies and repossessions. The personal savings rate is decreasing and credit card usage is increasing. We believe collections will undoubtedly pick up from current levels.
Lastly, in the last few quarters, we have detailed our expansion plans for 2022 due to our solid cash generation and healthy balance sheet. As part of these plans, we hired additional personnel across the organization.
Specifically, as mentioned, in the first quarter of this year, we added 27 team members across various divisions, including product development, technology, infrastructure and sales, as the pace of our identifying and securing qualified candidates in a competitive job market exceeded our own expectations.
And given the current employment and economic environment, during the second quarter, we pulled back on hiring to give us time to integrate new team members most effectively and to evaluate our positioning. We are well positioned today in various departments.
And moving forward, we plan to methodically add to teams, focusing primarily on mission-critical positions directly tied to revenue and key infrastructure and product development roles. I am very pleased with the team's execution this quarter and year-to-date.
While navigating an uncertain economic environment, we are keenly focused on growing our business. We are executing upon our long-term strategic plan, which includes bolstering our teams, enhancing our leading cloud-native platform, developing and commercializing innovative products and solutions and converting a deep sales pipeline.
Our business is healthy, and we are well positioned for growth. With that, I will now turn it over to Dan to provide some additional color and to discuss the financials..
The first issue being a quarterly revenue headwind created from the loss of one of our larger strategic integration customers that we previously discussed on our fourth quarter 2021 earnings call. The second issue causing the decrease in real estate marketing revenue is the result of current market dynamics for residential housing.
As mortgage rates have continued to rise in the face of high home prices and buy-sell transaction volumes have slowed, our customers have become more cautious in their marketing spend. They have taken a more targeted approach until overall residential real estate begins to normalize at a new level.
We believe this softening is temporary in the near term and we will start to see improving revenue growth within real estate marketing as interest rates start to normalize and/or consumers address to the new norm in rates. Inflation begins to improve, and overall residential home values continue to level off.
In all other areas of the business, we are seeing strong growth, increased volume and increasing demand for our identity and fraud solutions. We are extremely excited about the number and size of customers that are in our growing pipeline as well as recent key wins of larger customers from our competition.
These larger customers have only just started moving their volumes to our platform. In addition to the excitement with our current solutions, we are thrilled with the recent release of idiTRACE and several other key product releases slated for the second half of 2022. These new solutions open new markets and revenue opportunities for us.
For example, within Commercial Property solutions, we have been working with several large potential customers and partners to develop unique fraud, valuation and risk management tools that we estimate will generate $10 million to $20 million in annual revenue for us within the next 24 to 36 months.
We have made a strong push into background screening with the recent release of our idiTRACE solution and upcoming release of IDI Crem, after the consolidation of several players in the space. This is an opportune time for us to step forward in the market.
We believe our new solutions for use in connection with background screening will generate $15 million to $25 million in annual revenue for us within the next 24 to 36 months. Our business is strong. We are generating cash. Our team is laser-focused and opportunity of balance. With that, let's review our second quarter results.
For clarity, all the comparisons I will discuss today will be against the second quarter of 2021, unless noted otherwise. Total revenue was $12.5 million, a 15% increase over prior year. Platform revenue increased 15% to $12.2 million. Services revenue was up 6% to $0.3 million.
We produced a record $9.6 million in adjusted gross profit, resulting in a record margin of 77% for the second quarter, up 2 percentage points. Adjusted EBITDA for the quarter was $2.9 million, down 6% from prior year. Adjusted EBITDA margin for the quarter was 23%, compared to 29% in prior year.
As a reminder, this was our first full quarter of compensation expense after our hiring initiative that saw 27 team members added in the first quarter of 2022. We are pleased with our strong adjusted EBITDA and healthy cash flow in the second quarter. Moving on to the details of our P&L.
As mentioned, revenue was $12.5 million for the second quarter, consisting of revenue from new customers of $0.8 million, base revenue from existing customers of $10.2 million and gross revenue from existing customers of $1.5 million.
Our IDI billable customer base grew by 225 customers sequentially from the first quarter, ending the second quarter at 6,817 customers. FOREWARN added 9,771 users during the second quarter, surpassing 100,000 users and ending the quarter at 101,261 users. 206 realtor associations are now contracted to use FOREWARN.
And as Derek stated earlier on our call, we have continued to maintain a 100% association renewal rate since we introduced the FOREWARN solution in 2018. Our contractual revenue was 80% for the quarter compared to 81% in prior year. Our revenue attrition percentage was 5% compared to 6%.
We expect our revenue attrition percentage to trend between 5% and 10% for the foreseeable future. Moving on from our revenue metrics and down the P&L. Our cost of revenue, exclusive of depreciation and amortization increased $0.2 million or 7% to $2.9 million.
This $0.2 million increase was a result of an increase in data acquisition costs and third-party infrastructure fees. Adjusted gross profit increased 17% to a record $9.6 million, producing a record adjusted gross margin of 77%, a 2 percentage point increase over second quarter 2021.
Sales and marketing expenses increased $0.5 million or 20% to $2.8 million. The increase was due primarily to an increase in salaries and benefits and sales commissions. The $2.8 million of sales and marketing expense for the quarter consisted primarily of $1.5 million in employee salaries and benefits and $0.8 million in sales commissions.
General and administrative expenses increased $0.4 million or 8% to $5.3 million. This increase was primarily the result of a $0.9 million increase in employee salaries and benefits and a $0.2 million increase in professional fees which was offset by a decrease of $0.7 million in noncash share-based compensation expense.
The $5.3 million in general and administrative expenses for the quarter consisted primarily of $2.5 million of employee salaries and benefits, $1.3 million of noncash share-based compensation expense and $0.9 million in accounting, IT and other professional fees.
This would be a good time to revisit our 2022 hiring plan we discussed during our fourth quarter 2021 call. At that time, we discussed adding an additional 50 members to our team over the course of 2022. In the first quarter of this year, we added 27 team members, a good portion of which within technology.
These first quarter adds have paid huge dividends for our product road map as evidenced by the release of idiTRACE and several key solutions slated to be released over the second half of 2022.
Based on the productivity we are seeing from these recent hires as well as our desire to maintain P&L discipline during times of economic volatility, we will be very deliberate and tactical in our hiring for the remainder of 2022. Back to the P&L. Depreciation and amortization increased $0.3 million or 21% to $1.6 million for the quarter.
This increase was primarily the result of the amortization of internally developed software. We had a net loss of $0.2 million for the second quarter compared to net income of $1.8 million in prior year.
Note, however, the net income of $1.8 million in the second quarter of 2021 included a $2.2 million onetime gain on the extinguishment of debt from the forgiveness of our CARES Act loan. Excluding that gain, we had a $0.2 million improvement over second quarter 2021.
We reported a loss of $0.01 per basic and diluted share based on a weighted average share count of 13.8 million shares. Moving on to the balance sheet. Cash and cash equivalents were $32.3 million at June 30, 2022, compared to $34.3 million at December 31, 2021.
Current assets were $37.4 million compared to $38.6 million, and current liabilities were $3.4 million compared to $3.5 million. We generated $0.7 million in free cash flow in the second quarter, compared to generating $1.9 million for the same period 2021.
We calculate our free cash flow by using adjusted EBITDA and subtracting the cash we use for capital expenses such as property, equipment and capitalized intangible asset costs found on our statement of cash flows.
We generated $5 million in cash from operating activities for the six months ended June 30, 2022, compared to generating $3.5 million in cash from operating activities for the same period 2021.
Cash used in investing activities was $4.1 million for the six months ended June 30, 2022, mainly the result of $3.9 million used for software developed for internal use. Cash used in investing activities for the same period in 2021 was $2.6 million.
Cash used in financing activities was $2.8 million for the six months ended June 30, 2022, resulting from the taxes paid for the net share settlement of 106,254 shares from restricted stock units. These shares were withheld in treasury and retired prior to the end of the second quarter. There were no financing activities for the same period in 2021.
During the second quarter of 2022, we purchased 7,031 shares of our common stock under our stock repurchase program at an average price of $19.07 per share. During the third quarter to date, we purchased an additional 2,155 shares at an average price of $18.93 per share.
We will continue to monitor prevailing market conditions and other opportunities that we have for the use or investment of our cash balances and as applicable, strategically acquire additional shares in accordance with our repurchase program.
In closing, with a solid first half of the year behind us, we are excited to accomplish much more in the second half of 2022 and beyond. With that, our operator will now open the line for Q&A..
Thank you. We will now begin the question-and-answer session. [Operator Instructions] At this time, I'd like to turn the call over to Derek Dubner for closing remarks..
:.
:.
Thank you to those who joined us today. We delivered a strong second quarter, once again demonstrating the demand for our solutions and the resilience and powerful operational leverage of our business model.
While economic volatility impacted a portion of revenue in the second quarter, the majority of our business, which is fraud and identity, continued to expand, and we are well positioned for the remainder of the year and beyond. Good day..
Thank you. Ladies and gentlemen, this concludes today's conference. Thank you for participating. You may now disconnect..