TRIPADVISOR, INC. TRIP Cash Flow

Tripadvisor, inc. (TRIP)

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	Dec'12	Sep'12	Jun'12	Mar'12	Dec'11	Sep'11	Jun'11	Mar'11
Operating activities:
Net income
84,000	126,000	118,000	137,000	134,000	113,000	21,000	-23,000	-27,000	-19,000	66,000	96,000	104,000	120,000	122,000	141,000	164,000	198,000	231,000	211,000	221,000	226,000	210,000	212,000	211,000	205,000	219,129	222,664	208,829	195,000	182,888	177,646	178,591	177,791	0	0	0
Adjustments to reconcile net income (loss) to net cash provided by (used in) operating activities:
Depreciation of property and equipment, including amortization of internal-use software and website development
95,000	93,000	90,000	87,000	85,000	82,000	83,000	82,000	80,000	79,000	75,000	74,000	72,000	69,000	66,000	62,000	59,000	57,000	56,000	54,000	51,000	47,000	42,000	38,000	34,000	30,000	26,967	24,004	21,719	20,000	19,149	18,742	18,541	18,362	0	0	0
Amortization of intangible assets
32,000	33,000	33,000	33,000	34,000	34,000	31,000	32,000	32,000	32,000	34,000	33,000	32,000	32,000	33,000	35,000	37,000	36,000	33,000	29,000	23,000	18,000	13,000	8,000	7,000	6,000	5,091	5,401	5,161	6,000	6,789	7,873	7,245	7,523	0	0	0
Stock-based compensation expense
123,000	124,000	119,000	117,000	116,000	118,000	114,000	110,000	106,000	96,000	93,000	89,000	85,000	85,000	84,000	81,000	75,000	72,000	69,000	68,000	65,000	63,000	60,000	54,000	49,000	49,000	45,077	42,540	39,308	30,000	30,788	24,362	19,562	17,344	0	0	0
Deferred income tax expense (benefit) and other, net
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of deferred financing costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,000	0	0	0	-	-	-	-
Amortization of discounts and premiums on marketable securities, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-
Deferred tax expense (benefit)
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-54,000	-51,000	-38,000	-37,000	-6,000	-5,000	-15,000	-17,000	0	0	0	-	-	-8,926	-7,971	-5,000	-344	-831	-786	-931	0	0	0
Provision (recovery) for doubtful accounts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,000	-1,276	-972	263	909	0	0	0
Foreign currency transaction (gains) losses, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-2,004	-3,150	-77	-209	0	0	0
Other, net
-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-18,000	-18,000	-19,000	-8,000	-8,000	-8,000	-2,979	-3,491	-2,963	-1,000	325	-1,600	-893	131	0	0	0
Excess tax benefits from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	23,000	21,000	22,000	12,000	9,811	5,989	2,317	3,000	2,109	2,151	2,325	1,571	0	0	0
Changes in operating assets and liabilities, net of effects from acquisitions and other investments:
Accounts receivable and contract assets, prepaid expenses and other assets
-64,000	-23,000	10,000	-13,000	-20,000	8,000	-6,000	67,000	56,000	36,000	42,000	24,000	-6,000	24,000	-4,000	-10,000	25,000	31,000	56,000	53,000	59,000	26,000	0	0	3,000	-	-	-	-	-	-	-	-	-	-	-	-
Accounts receivable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	49,360	-	26,891	18,214	26,098	15,910	0	0	0
Receivable from Expedia, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-
Prepaid expenses and other assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	1,932	2,175	2,600	1,821	0	0	0
Accounts payable, accrued expenses and other liabilities
-4,000	-1,000	0	0	0	-	-	-	-	-	3,000	-7,000	-15,000	7,000	-9,000	23,000	23,000	13,000	-5,000	16,000	27,000	18,000	45,000	53,000	29,000	17,000	30,553	15,060	13,037	32,000	0	0	0	-	-	-	-
Deferred merchant payables
-188,000	-3,000	-3,000	-4,000	3,000	14,000	5,000	7,000	36,000	14,000	41,000	50,000	37,000	21,000	5,000	45,000	27,000	15,000	30,000	61,000	17,000	-9,000	17,000	80,000	46,000	17,000	0	0	0	-	-	-	-	-	-	-	-
Accounts payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-10,440	-828	14,549	4,133	0	0	0
Income tax receivables/payables, net
-5,000	17,000	16,000	11,000	-10,000	13,000	0	0	0	-	-	-	-	20,000	0	0	0	-	-	-	29,000	60,000	26,000	34,000	26,000	27,000	18,528	-3,128	-6,766	-17,000	-3,892	2,828	-5,085	3,244	0	0	0
Deferred revenue
-41,000	-2,000	0	-5,000	1,000	5,000	0	0	0	-	-	-8,000	-5,000	1,000	3,000	10,000	16,000	7,000	7,000	24,000	16,000	9,000	12,000	17,000	19,000	9,000	10,617	12,432	8,538	12,000	10,158	7,519	9,907	6,876	0	0	0
Accrued expenses and other liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
Net cash provided by operating activities
172,000	424,000	395,000	408,000	413,000	405,000	392,000	243,000	278,000	238,000	265,000	313,000	331,000	321,000	355,000	482,000	443,000	418,000	420,000	439,000	397,000	407,000	397,000	483,000	414,000	349,000	349,071	280,523	253,281	239,000	194,090	195,488	194,285	217,882	0	0	0
Investing activities:
Capital expenditures, including internal-use software and website development
86,000	83,000	76,000	68,000	63,000	61,000	59,000	60,000	61,000	64,000	65,000	71,000	73,000	72,000	73,000	91,000	95,000	109,000	119,000	93,000	92,000	81,000	71,000	73,000	66,000	55,000	47,413	39,751	30,661	29,000	25,881	24,148	23,669	21,323	0	0	0
Acquisitions and other investments, net of cash acquired (Note 3)
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	29,000	0	0	0	-	-	-	-	35,000	0	0	0	-	-	-	-	7,894	0	0	0
Purchases of marketable securities
-	133,000	133,000	84,000	55,000	16,000	0	0	0	-	-	-	-	166,000	200,000	211,000	189,000	205,000	182,000	124,000	80,000	251,000	276,000	305,000	421,000	432,000	0	0	0	-	-	-	-	-	-	-	-
Sales of marketable securities
-	-	-	-	-	59,000	59,000	47,000	44,000	105,000	127,000	147,000	153,000	84,000	177,000	181,000	195,000	187,000	83,000	58,000	309,000	336,000	376,000	431,000	213,000	175,000	0	0	0	-	-	-	-	-	-	-	-
Maturities of marketable securities
-	70,000	40,000	20,000	17,000	5,000	8,000	16,000	17,000	28,000	35,000	32,000	35,000	32,000	41,000	66,000	73,000	71,000	57,000	36,000	58,000	93,000	133,000	153,000	164,000	151,000	0	0	0	-	-	-	-	-	-	-	-
Transfers to Expedia, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	95,967	0	0	0
Proceeds from Expedia, Inc. related to Spin-Off
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-
Net cash provided by investing activities
-154,000	-176,000	-171,000	-131,000	-119,000	-49,000	-76,000	-77,000	-64,000	6,000	41,000	-9,000	-76,000	-163,000	-72,000	-27,000	-13,000	-58,000	-214,000	-330,000	-140,000	-233,000	-125,000	50,000	-144,000	-196,000	-446,441	-493,779	-422,689	-244,000	-444,841	-439,641	-467,145	-538,862	0	0	0
Repurchase of common stock (Note 12)
0	-	-	-	-	100,000	100,000	100,000	104,000	250,000	334,000	343,000	254,000	105,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Principal payments on credit facilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	40,000	40,000	40,000	40,000	35,000	30,000	25,000	20,000	0	0	0	-	-	-	-
Payments to credit facility
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	15,000	15,000	15,000	10,000	0	0	0	-	-	-	-
Proceeds from credit facility
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-	-	0	-	10,202	14,373	16,107	15,000	26,635	23,003	19,547	18,158	0	0	0
Proceeds from exercise of stock options
-	-	-	-	-	-	-	-	-	3,000	4,000	7,000	8,000	7,000	8,000	6,000	6,000	12,000	11,000	10,000	9,000	3,000	5,000	6,000	20,000	24,000	25,749	25,231	228,074	231,000	0	0	0	-	-	-	-
Payment of withholding taxes on net share settlements of equity awards
20,000	29,000	35,000	34,000	37,000	26,000	21,000	21,000	16,000	17,000	17,000	18,000	19,000	15,000	20,000	22,000	69,000	73,000	67,000	72,000	28,000	33,000	36,000	31,000	27,000	14,000	13,311	9,965	9,041	7,000	0	0	0	-	-	-	-
Payments of finance lease obligation
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Excess tax benefits from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	23,000	21,000	22,000	12,000	9,811	5,989	2,317	3,000	2,109	2,151	2,325	1,571	0	0	0
Other financing activities, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	12,000	0	0	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-
Acquisitions funded by Expedia
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	5,135	0	0	0
Net cash used in financing activities
14,000	-580,000	-34,000	-33,000	-136,000	-358,000	-391,000	-386,000	-332,000	-200,000	-173,000	-181,000	-159,000	-143,000	-229,000	-257,000	-284,000	-189,000	-119,000	-98,000	-50,000	-61,000	-50,000	-151,000	-165,000	-170,000	-177,549	-65,372	175,457	190,000	613,276	614,858	399,809	411,834	0	0	0
Effect of exchange rate changes on cash, cash equivalents and restricted cash
0	-	-	-	-	-16,000	-12,000	-1,000	22,000	17,000	6,000	-2,000	-18,000	-17,000	-10,000	-15,000	2,000	-12,000	0	0	0	-	-	-	-	1,000	2,079	-81	-3,142	-1,000	-2,533	-4,188	-241	-455	0	0	0
Net increase in cash, cash equivalents and restricted cash
27,000	-336,000	175,000	235,000	136,000	-18,000	-87,000	-221,000	-96,000	61,000	139,000	121,000	78,000	-2,000	44,000	183,000	148,000	159,000	76,000	-4,000	186,000	104,000	216,000	388,000	108,000	-16,000	-272,840	-278,709	2,907	184,000	359,992	366,517	126,708	90,399	0	0	0
Supplemental disclosure of non-cash investing and financing activities:
Stock-based compensation capitalized with internal-use software and website development costs
-	-	-	-	-	-	-	-	-	13,000	13,000	12,000	12,000	12,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Capitalization of construction in-process related to build to suit lease
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	6,000	16,000	30,000	42,000	52,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Capital expenditures incurred but not yet paid related to build to suit lease
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2015 Credit Facility
Payments to credit facility
-	-	-	-	-	235,000	290,000	325,000	380,000	296,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from credit facility
0	-	-	-	-	-	0	0	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2016 Credit Facility
Payments to credit facility
-	-	-	-	-	-	-	-	-	73,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-