Q2 Holdings, Inc. QTWO Balance Sheet

Q2 holdings, inc. (QTWO)

Balance Sheet / TTM

Mar'20	Dec'19	Sep'19	Jun'19	Mar'19	Dec'18	Sep'18	Jun'18	Mar'18	Dec'17	Sep'17	Jun'17	Mar'17	Dec'16	Sep'16	Jun'16	Mar'16	Dec'15	Sep'15	Jun'15	Mar'15	Dec'14	Sep'14	Jun'14	Mar'14	Dec'13
Assets
Current assets:
Cash and Cash Equivalents, at Carrying Value
83,078	100,094	601,156	582,889	110,542	108,341	211,779	176,738	255,411	57,961	40,140	34,471	42,756	54,873	51,623	52,526	55,259	67,049	75,169	69,369	94,170	67,979	72,340	94,906	86,673	18,675
Restricted cash
3,450	3,468	2,152	2,158	1,815	1,815	2,315	2,315	2,315	2,315	2,915	2,915	1,315	1,315	2,159	2,203	1,867	2,123	1,315	713	829	829	829	116	116	116
Investments
29,752	32,325	35,696	34,810	53,971	68,979	86,236	101,974	38,704	41,685	48,717	44,185	39,409	42,249	40,708	43,114	49,740	43,571	44,720	49,150	25,525	20,956	18,028	-	-	0
Accounts receivable, net
26,582	22,442	24,349	26,591	19,549	19,668	23,121	26,996	16,897	13,203	15,768	15,012	8,449	12,240	16,246	10,576	8,735	9,009	8,986	6,987	7,225	5,007	6,505	5,468	5,735	9,063
Contract assets, current portion, net
993	872	826	771	654	598	487	1,196	336	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Prepaid expenses and other current assets
9,315	6,354	6,114	5,526	6,464	3,983	4,795	4,691	4,699	3,115	5,093	4,074	6,017	3,215	5,335	6,858	5,153	3,058	2,412	2,614	3,282	2,695	2,321	1,971	1,775	1,079
Deferred solution and other costs, current portion
17,256	15,609	13,902	12,726	11,169	10,501	10,456	10,402	8,392	9,246	9,416	8,182	8,422	8,839	8,304	6,061	5,200	5,968	6,077	4,512	4,070	5,060	4,324	3,127	3,277	3,124
Deferred implementation costs, current portion
8,388	5,171	4,638	4,400	5,011	4,427	3,599	3,066	3,740	3,562	3,590	3,400	3,275	2,938	3,038	2,747	2,485	2,440	2,378	2,331	2,054	1,996	2,037	1,945	1,767	1,814
Total current assets
178,814	186,335	688,833	669,871	209,175	218,312	342,788	327,378	330,494	131,087	125,639	112,239	109,643	125,669	127,413	124,085	128,439	133,218	141,057	135,676	137,155	104,522	106,384	107,533	99,343	33,871
Property and equipment, net
48,681	39,252	39,917	39,732	40,715	34,994	35,132	36,727	36,592	34,544	32,140	31,565	31,701	27,480	28,994	27,802	27,491	24,440	21,426	18,718	19,001	18,521	14,251	14,026	14,295	14,831
Right of use assets
33,211	35,388	29,159	24,444	25,410	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred solution and other costs, net of current portion
32,621	29,220	25,384	22,618	22,004	16,761	16,273	15,966	16,333	12,973	12,411	13,213	12,853	11,125	12,106	11,828	10,973	10,146	9,480	8,590	8,192	7,159	6,503	6,291	6,358	5,358
Deferred implementation costs, net of current portion
14,586	15,848	14,884	13,238	11,055	9,948	10,215	9,492	8,374	8,295	8,387	8,276	8,110	8,096	7,622	7,061	6,606	6,045	5,753	5,523	5,554	5,378	5,344	4,932	4,791	4,560
Intangible assets, net
213,998	223,861	54,167	57,213	60,254	63,296	7,720	9,079	10,556	12,034	13,512	14,718	15,907	15,208	15,631	16,054	16,591	17,192	11,267	-	-	0	-	-	-	-
Goodwill
462,300	462,000	107,900	107,900	107,900	107,900	12,876	12,876	12,876	12,876	12,876	12,876	12,876	12,876	12,876	12,900	12,900	12,876	8,776	-	-	0	-	-	-	-
Contract assets, net of current portion and allowance
16,988	15,189	13,981	13,277	11,228	10,272	8,346	6,074	5,539	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other long-term assets
1,325	2,318	3,502	3,532	2,709	2,230	1,751	1,171	1,090	1,006	502	513	496	526	642	539	615	551	956	1,187	1,141	1,226	815	740	751	2,488
Total assets
1,002,498	1,009,434	977,684	951,782	490,407	463,720	435,101	418,763	421,854	212,815	205,467	193,400	191,586	200,980	205,284	200,245	203,591	204,468	198,715	169,694	171,043	136,806	133,297	133,522	125,538	61,108
Liabilities and stockholders' equity
Current liabilities:
Accounts payable
12,819	10,967	8,612	8,357	10,254	9,169	7,884	6,639	6,375	7,621	6,347	5,306	5,769	4,231	5,082	5,513	4,872	3,450	3,663	3,527	3,444	1,986	2,641	1,939	4,501	4,085
Accrued liabilities
19,132	16,341	12,358	10,149	11,425	9,329	7,614	7,688	10,847	10,562	5,901	5,863	9,583	8,822	9,069	10,754	10,152	11,319	6,787	6,870	10,338	8,785	7,089	6,703	5,855	7,288
Accrued compensation
35,425	38,668	35,689	28,427	26,602	12,652	10,658	7,100	6,229	11,511	11,501	8,731	7,484	16,035	14,037	10,392	8,063	7,712	6,458	4,251	2,781	3,936	-	-	-	4,376
Deferred revenues, current portion
64,192	57,850	52,047	46,023	45,246	42,531	34,799	33,159	38,344	38,379	40,505	32,057	28,781	30,123	32,290	25,759	25,497	23,051	22,114	17,542	18,576	17,289	18,031	14,351	13,226	12,728
Operating Lease, Liability, Current
8,960	9,140	7,472	6,725	6,898	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Capital lease obligations, current portion
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	74	161	253	344	338	408	453	513	636	714
Total current liabilities
140,528	132,966	116,178	99,681	100,425	73,681	60,955	54,586	61,795	68,073	64,254	51,957	51,617	59,211	60,478	52,418	48,658	45,693	39,275	32,534	35,477	32,404	28,214	23,506	24,218	29,191
Convertible notes, net of current portion
430,272	424,784	419,326	413,890	185,266	182,723	180,122	177,562	175,170	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred revenues, net of current portion
33,406	32,954	25,391	25,317	24,202	23,063	25,428	19,238	20,599	28,289	28,286	30,500	29,935	31,707	32,266	30,988	30,767	29,188	27,795	25,846	21,025	19,436	18,616	17,947	15,236	14,773
Capital lease obligations, net of current portion
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	1	105	167	259	351	443	575
Long-term debt, net of current portion
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	46	2,054	6,323	6,288
Deferred rent, net of current portion
-	-	0	0	0	8,151	8,017	8,248	9,075	9,393	9,711	10,010	9,181	9,466	9,750	9,766	9,684	7,359	7,578	4,307	4,504	4,694	4,888	4,892	4,668	4,444
Operating Lease, Liability, Noncurrent
33,717	36,079	30,309	26,533	27,644	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other long-term liabilities
3,665	3,239	4,639	499	477	17,202	590	823	360	438	579	586	473	361	292	222	2,710	4,254	686	720	709	1,165	7	7	69	101
Total liabilities
641,588	630,022	595,843	565,920	338,014	304,820	275,112	260,457	266,999	106,193	102,830	93,053	91,206	100,745	102,786	93,394	91,819	86,494	75,334	63,408	61,820	57,866	52,030	48,757	50,957	55,372
Commitments and contingencies (Note 7)
-	-	-	-	-	-	0	0	0	-	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Stockholders' equity:
Preferred stock: $0.0001 par value; 5,000 shares authorized; no shares issued or outstanding as of March 31, 2020 and December 31, 2019
0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Common stock: $0.0001 par value; 150,000 shares authorized; 48,963 issued and outstanding as of March 31, 2020 and 48,386 shares issued and outstanding as of December 31, 2019
5	5	5	5	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	3	3	3	3	1
Treasury stock at cost; Zero and 27 shares at December 31, 2018 and 2017, respectively
-	-	-	-	-	-	0	0	0	855	597	597	455	417	264	200	44	41	41	27	27	20	-	-	-	0
Additional paid-in capital
638,743	622,692	609,327	594,757	344,033	331,355	320,627	310,163	298,087	259,726	249,892	241,835	233,876	226,485	221,041	215,832	210,905	207,541	204,452	180,352	178,262	143,337	140,890	139,743	124,876	6,675
Accumulated other comprehensive income/(loss)
-163	14	142	164	89	-37	-83	-161	-163	-139	-69	-84	-55	-54	-13	4	-12	-101	-25	-50	-5	-14	-20	-	-	0
Accumulated deficit
-277,675	-243,299	-227,633	-209,064	-191,733	-172,422	-160,559	-151,700	-143,073	-152,114	-146,593	-140,811	-132,990	-125,783	-118,270	-108,789	-99,081	-89,429	-81,009	-73,993	-69,011	-64,366	-59,606	-54,981	-50,298	-44,732
Total stockholders' equity
360,910	379,412	381,841	385,862	152,393	158,900	159,989	158,306	154,855	106,622	102,637	100,347	100,380	100,235	102,498	106,851	111,772	117,974	123,381	106,286	109,223	78,940	81,267	84,765	74,581	-36,316
Total liabilities and stockholders' equity
1,002,498	1,009,434	977,684	951,782	490,407	463,720	435,101	418,763	421,854	212,815	205,467	193,400	191,586	200,980	205,284	200,245	203,591	204,468	198,715	169,694	171,043	136,806	133,297	133,522	125,538	61,108