CONCERT PHARMACEUTICALS, INC. CNCE Cash Flow

Concert pharmaceuticals, inc. (CNCE)

CashFlow / 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	Sep'13	Jun'13	Mar'13
Operating activities
Operating activities
Net Income (Loss) Attributable to Parent
-76,817	-78,166	-78,528	-78,730	-73,387	-56,024	-41,241	104,211	104,509	95,639	89,662	-49,759	-50,173	-50,720	-37,993	-35,191	19,296	24,174	14,563	15,285	-33,751	-31,699	-28,687	-27,982	-11,227	-6,056	0	0	0
Adjustments to reconcile net loss to net cash used in operating activities:
Depreciation and amortization
1,628	1,664	1,581	1,540	1,391	1,200	1,126	1,016	1,005	1,000	994	963	938	900	863	847	812	785	647	770	909	1,052	1,322	1,324	1,334	1,346	0	0	0
Stock-based compensation expense
9,874	10,326	10,377	10,688	11,130	11,500	11,621	11,387	10,156	8,500	6,949	5,714	5,428	5,067	4,657	4,239	3,617	2,981	2,757	2,499	2,129	1,693	1,301	947	987	1,003	0	0	0
Accretion of premiums and discounts on investments
799	1,013	1,134	952	710	469	250	133	30	-90	-209	-339	-437	-504	-563	-589	-668	-715	-777	-872	-930	-833	-688	-519	-319	-302	0	0	0
Unrealized loss on marketable equity securities
-2,240	-2,150	-3,657	-4,724	-3,929	-2,926	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Unrealized loss on marketable equity securities
-2,240	-2,150	-3,657	-4,724	-3,929	-2,926	-1,359	-627	-1,296	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loss on disposal of asset
0	-4	-4	-56	-56	-52	0	0	0	-	-	-	-	-2	-2	-2	-6	-4	0	0	0	-	-	-	-	-	-	-	-
Amortization of discount on loan payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	74	100	99	99	98	96	96	97	97	0	0	0
Amortization of deferred financing costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	29	38	39	38	38	38	37	38	38	0	0	0
Re-measurement of warrant to purchase redeemable securities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	117	91	-302	-90	4	0	0	0
Amortization of deferred lease incentive
-	-	-	-	-	703	671	556	440	324	322	320	317	315	313	311	310	308	273	263	315	367	0	0	0	-	-	-	-
Non-cash license consideration (Note 12)
-	-	-	-	-	10,451	10,452	10,452	10,452	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Non-cash lease expense
245	226	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of deferred lease incentive
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Changes in operating assets and liabilities:
Accounts receivable
-10	57	32	34	-117	-119	-29	-269	115	107	-5	140	-139	-43	-122	40	29	-951	-1,110	-3	55	851	1,081	-89	-1,945	157	0	0	0
Interest receivable
46	-296	-222	-75	-198	-72	-122	293	404	464	312	7	-203	-17	92	-70	181	-81	-60	-55	-119	170	177	240	222	-10	0	0	0
Prepaid expenses and other current assets
1,670	1,828	2,040	818	-239	953	-132	-32	264	433	489	999	28	-314	425	6	84	491	-799	-842	56	137	580	643	870	-32	0	0	0
Contract asset
0	-16,000	-16,000	-16,000	-16,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other assets
59	96	8	3	-1	-34	-33	-32	-34	-33	22	27	-34	-11	-57	-63	-1	-23	-34	9	8	-82	-1,245	-120	-120	-69	0	0	0
Accounts payable
-133	-217	185	-256	678	435	634	-159	-634	113	-974	-1,402	757	44	-64	1,476	-264	-90	35	-97	91	-32	889	772	38	158	0	0	0
Accrued expenses and other liabilities
440	2,984	538	2,387	2,147	1,265	843	-761	-167	436	-686	434	-1,265	-957	206	271	1,016	-223	-425	-159	223	2,863	1,435	257	-411	-15	0	0	0
Income taxes receivable
0	36	35	112	112	76	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Income taxes payable
-2	-392	-418	-276	4	344	-1,759	276	-4	46	2,177	0	0	-75	-86	-509	0	75	0	0	0	-	-	-	-	-	-	-	-
Deferred rent
-	-	-	-	-	2,746	1,998	1,298	598	-102	-89	-76	-64	-51	-39	-49	-57	-68	-69	-48	-87	-126	-173	-213	-199	-181	0	0	0
Deferred revenue
-	-	-	-	-	-16	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Operating lease liability
0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred revenue
-	-	-	-	-	-	-	-	-	-	-	-	-102	-	-274	-1,935	-4,933	-5,651	-6,553	-5,671	-3,623	-3,810	-3,653	-3,160	15,666	16,881	0	0	0
Net cash used in operating activities
-	-	-	-	-	-	-	-	-	-	-	0	-44,020	-	-32,815	-30,449	19,627	23,061	14,040	15,386	-32,701	-29,760	0	0	0	-	-	-	-
Net cash used in operating activities
-65,257	-48,761	-49,299	-44,849	-36,882	-48,029	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0
Investing activities
Investing activities
Purchases of property and equipment
482	685	984	1,820	2,859	2,869	2,699	2,239	1,122	947	1,128	768	828	770	436	679	810	868	1,287	1,036	854	804	464	444	387	363	0	0	0
Purchases of investments
177,923	97,837	146,641	139,214	104,825	99,435	71,341	150,717	184,524	206,207	186,545	121,357	90,070	132,344	146,507	131,844	229,347	163,025	155,303	121,386	43,332	89,188	78,464	100,192	78,835	29,929	0	0	0
Maturities of investments
159,284	181,105	188,769	169,639	167,814	140,207	117,534	104,408	84,628	85,847	89,432	109,871	123,639	125,901	189,038	195,675	188,057	178,462	99,745	71,770	61,540	45,540	35,260	24,102	21,905	26,655	0	0	0
Net cash provided by (used in) investing activities
-	-	-	-	-	-	-	-	-	-	-	0	32,741	-	42,095	63,152	-42,100	14,569	-56,845	-50,652	17,354	-44,452	0	0	0	-	-	-	-
Net cash (used in) provided by investing activities
-19,121	82,583	41,144	28,605	60,130	37,903	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0
Repayments of Long-term Debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	7,175	8,445	8,264	8,086	7,916	0	0	0	-	-	-	-
Financing activities
Proceeds from exercises of stock options
706	1,076	1,109	1,096	1,173	1,037	5,114	6,031	6,106	6,576	2,704	1,818	1,564	601	553	1,263	1,710	1,844	0	0	0	-	0	0	0	-	-	-	-
Financing activities
Repayment of leasehold improvement loan
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	332	0	0	0
Proceeds from exercise of warrants
0	1,000	1,000	1,000	1,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayment of leasehold improvement loan
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-
Proceeds from common stock and pre-funded warrants sold, net of underwriters' discount and costs
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-38,575	-38,575	-38,575	1,009	0	0	0	-	-	-	-
Payment of public offering costs
-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-	310	310	310	428	1,436	0	0	0	-	-	-	-
Net cash provided by financing activities
70,195	1,451	1,542	1,199	917	-169	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0
Net increase in cash and cash equivalents and restricted cash
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash (used in) provided by financing activities
-	-	-	-	-	-	-	-	-	-	-	0	1,564	-	-187	-1,619	-3,522	41,484	40,079	39,917	39,512	77,970	0	0	0	-	-	-	-
Net increase in cash and cash equivalents and restricted cash
-	-	-	-	-	-	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net (decrease) increase in cash and cash equivalents
-	-	-	-	-	-	-	-	-	-	-	-	-	-	9,093	31,084	-25,995	79,114	-2,726	4,651	24,165	3,758	4,824	-29,898	26,185	2,148	0	0	0
Supplemental cash flow information:
Cash paid for income taxes
34	459	526	517	498	123	1,950	1,950	1,950	1,900	-10	-10	-10	75	85	310	310	225	0	0	0	-	-	-	-	-	-	-	-
Cash paid for interest
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	287	465	645	822	992	1,160	1,326	1,484	1,601	0	0	0
Purchases of property and equipment unpaid at period end
-12	4	89	-108	-502	188	160	379	738	65	-211	3	-11	20	174	-34	14	42	0	0	0	-	-	-	-	-	-	-	-
Tenant improvements paid by landlord (Note 11)
-	-	-	-	-	4,996	4,996	4,202	1,414	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Public offering costs unpaid at period end
-13	143	50	50	156	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash paid included in measurement of lease liabilities
0	-	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Pre-funded stock warrants issued
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Public offering costs incurred but unpaid at period end
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	0	-	-	-	-