Stuart Miller
Analyst · Stifel
Thank you, Marty. Following the initial shock of COVID-19 in March, we began to see a more predictable cadence to closing deals particularly in June and into July suggesting that our customers and prospects are settling into a new normal. I want to highlight one market development related to COVID-19, the Financial Conduct Authority or FCA that the U.K. regulator has opened a consultation on whether it should delay the initial ESEF reporting deadline by a year. While the comment period lasts another month, we expect the FCA to approve the delay for U.K. companies. Of the 5,300 companies affected by the ESEF mandate, approximately 1,400 are headquartered in the U.K.. Our expectation of a delay of the mandate for the U.K. market has had no material impact on our outlook for EMEA. Now turning to our financials. As always, I will talk about our results and guidance on a non-GAAP basis. Refer to our press release for a reconciliation of our non-GAAP and GAAP results and guidance. I'll address our performance against Q2 guidance first. We beat Q2 2020 revenue guidance at the midpoint by $3.3 million. Higher subscription revenue accounted for most of the beat. We succeeded in collecting a high percentage of the receivables that we had held in reserves at the end of Q1. The pandemic had less of an impact on collections than we had anticipated in March. We beat guidance on Q2 operating income by more than $5 million. The revenue beat I just mentioned accounted for 2/3 of the swing. Lower employee travel and entertainment and medical care expenses accounted for the remaining 1/3 of the beat on operating income. Now turning to a comparison of Q2 2020 to Q2 last year. We generated total revenue in the second quarter of $83.9 million, an increase of 14.1% from Q2 2019. Breaking out revenue by reporting line item, subscription and support revenue was $70.7 million, up 16.9% from Q2 2019. New logos and new solutions helped drive strong revenue growth in Q2 2020. 53% of the increase in S&S revenue in Q2 came from new customers added in the last 12 months. The balance of the increase came from companies who have been our customers for more than a year. Professional services revenue was $13.2 million in Q2 2020, an increase of 1.2% from the same quarter last year. Growth in revenue from setup and consulting overcame a small decrease in XBRL services relative to Q2 last year. Turning to our supplemental metrics, we finished Q2 with 3,512 customers, a net increase of 91 customers from Q2 2019 and a net increase of five customers from Q1 2020. The average annual contract value of the new logos signed in Q2 2020 was 34% higher than the same value for a churn account in Q2. Our revenue retention rates remained strong. Our subscription and support revenue retention rate was 94.5% for the second quarter of 2020 compared to 95.4% for the same period last year. Almost half the attrition in the quarter came from M&A, delistings, and bankruptcies. With add-ons, our subscription and support revenue retention rate was 107.9% for the second quarter of 2020 compared to 114.5% in Q2 2019. The decline reflects winding down conversion of customer contracts to solution-based licensing as well as pandemic-related impacts on both price increases and solution churn. We continue to increase our number of larger subscription contracts. In the second quarter of 2020, we had 716 contracts valued at over $100,000 per year, up 28% from Q2 of the prior year. The number of contracts valued at over $150,000 totaled 342 customers in the second quarter, up 44% from Q2 2019 results. Moving down the P&L. Gross profit totaled $62.4 million in Q2, up 16.4% from the same quarter a year ago. Consolidated gross margin was 74.4% in the latest quarter versus 73% in Q2 2019 a net expansion of 140 basis points. Breaking out gross profit. Subscription and support gross profit totaled $59 million, equating to a gross margin of 83.5% on S&S revenue, a contraction of 30 basis points compared to Q2 2019. Additional headcount to help upgrade customers to our new platform was the primary driver of the contraction. Professional services gross profit in the second quarter was $3.4 million equating to a 25.7% gross margin compared to 22.8% in Q2 2019. Research and development expense in Q2 totaled $21.5 million, up 7.6% from Q2 2019, primarily due to higher compensation costs. R&D expense as a percentage of revenue improved 25.6% in Q2 2020 from 27.1% in Q2 2019. Sales and marketing expense for the quarter increased 23.5% from Q2 2019 to $32.3 million, primarily reflecting our investment in sales talent to drive bookings growth. General and administrative expenses totaled $10.5 million in Q2, up $3.1 million compared to Q2 2019. G&A expenses as a percentage of revenue increased 240 basis points to 12.5% due to severance costs, additional headcount and higher software expenses. We posted an operating loss of $1.9 million in Q2 2020 compared to an operating profit of $86,000 in Q2 2019. Workiva's operating margin in Q2 was better than our guidance as I discussed earlier. Turning to our balance sheet and cash flow statement. At June 30, 2020, cash, cash equivalents and marketable securities totaled $509 million an increase of $12.5 million compared to the balance at March 31, 2020. In Q2, 2020, net cash provided from operating activities totaled $7.1 million, compared with cash provided of $18.8 million in the same quarter a year ago. At the end of each quarter, we review outstanding invoices to determine which ones present a collection risk due to a variety of factors including credit risk consistent with ASC 606. We remove the invoices at risk and take the amounts out of both accounts receivable and deferred revenue until payment is collected which is when we begin to recognize that revenue. At June 30, 2020, we classified $5.6 million of receivables to this reserve account, up from $3.2 million of receivables at June 30, 2019. This reserve account reduced deferred revenue by an equal amount and therefore it reduced billings at the end of the quarter. Remaining performance obligations on subscription contracts continue to vary from deferred revenue as we implement multiyear contracts with annual billing terms for some customers. Turning to our guidance. As Marty indicated, we are reinstating guidance for full year 2020 based on improved visibility on new business both pipeline and deals closing. Our new full year guidance is close to our pre-pandemic full year guidance on revenue and substantially improved on operating loss. We are factoring in the expected impact of COVID-19 on our business and results of operations based on information available to us today. For the third quarter of 2020, we expect total revenue to range from $84.3 to $84.8 million. We expect subscription revenue to grow at a faster rate than services revenue in Q3. We expect non-GAAP operating loss to range from $5.2 million to $5.7 million. For full year 2020, we expect total revenue to range from $341.5 million to $342.5 million. We expect non-GAAP operating loss to range from $11.5 million to $10 million. We will now take your questions. Operator, we're ready to begin the Q&A session.