Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
TripAdvisor Inc. logo

TripAdvisor Inc.

Sector: Consumer Cyclical   

Industry: Leisure

26.55
 
USD
  
0.23
  
(0.87%)
Optionable: Yes  Market Cap: 3,631 M  90-day average vol: 2,382,474

Previous close: 26.32  Open: 26.54  Bid: 25.2  Ask: 26.58
52 week range    
14.15   
   28.76
Peers   
EXPE / 
MMYT / 
YELP / 
Last updated: Friday 3rd May 2024
63
MarketXLS Rank
55
Value
69
Technical
65
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

TRIP Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in other current liabilities22 M22 M-5 M5 M-2 M-34 M8 M10 M4 M
(Increase) Decrease in payables60 M32 M17 M-81 M1000000.0107 M-1000000.0
(Increase) Decrease in receivables32 M20 M38 M5 M23 M92 M-73 M-87 M6 M
Acquisitions-331 M-29 M-24 M-110 M-4 M
Amortization of intangibles18 M36 M32 M32 M34 M33 M
AssetImpairmentCharge11 M20 M3 M6 M6 M
CapitalExpenditureReported81 M109 M72 M64 M61 M83 M55 M54 M56 M63 M
Cash at beginning of period351 M455 M614 M612 M673 M655 M319 M418 M723 M1,021 M
Cash at end of period445 M754 M642 M609 M893 M319 M319 M418 M1,021 M1,067 M
Cash flow387 M418 M321 M238 M405 M424 M-194 M108 M400 M235 M
CashFlowFromContinuingInvestingActivities-234 M-58 M-163 M6 M-49 M-176 M-56 M-54 M-52 M-63 M
ChangeInAccruedExpense18 M13 M7 M22 M-1000000.0-28 M30 M72 M11 M
ChangeInIncomeTaxPayable17 M-81 M1000000.0107 M-1000000.0
ChangeInInterestPayable18 M13 M7 M22 M
ChangeInPayablesAndAccruedExpense78 M13 M7 M22 M16 M-109 M31 M179 M10 M
ChangeInPrepaidAssets-26 M-31 M-24 M-36 M-8 M
ChangeInTaxPayable60 M32 M17 M-81 M1000000.0107 M-1000000.0
ChangeInWorkingCapital52 M36 M25 M-3 M32 M37 M-51 M-34 M102 M20 M
ChangesInAccountReceivables-8 M23 M92 M-73 M-87 M6 M
CommonStockDividendPaid-488 M
CommonStockPayments-105 M-250 M-100 M-60 M-115 M-100 M
Current deferred income taxes-17 M-37 M-20 M39 M12 M6 M-1000000.0-44 M-19 M-25 M
Deferred income taxes-17 M-37 M-20 M39 M12 M6 M-1000000.0-44 M-19 M-25 M
Depreciation47 M57 M69 M79 M82 M126 M125 M111 M97 M87 M
Depreciation unreconciled65 M93 M101 M111 M116 M126 M125 M111 M97 M87 M
DepreciationAndAmortization65 M93 M101 M111 M116 M126 M125 M111 M97 M87 M
Effect of exchange rate changes-8 M-12 M-17 M17 M-16 M-4 M8 M-12 M-23 M1000000.0
ExcessTaxBenefitFromStockBasedCompensation-20 M-36 M
FinancingCashFlow-51 M-49 M-113 M-264 M-120 M-580 M341 M263 M-27 M-127 M
Free cash flow306 M309 M249 M174 M344 M341 M-249 M54 M344 M172 M
GainLossOnSaleOfBusiness-20 M6 M
IncomeTaxPaidSupplementalData54 M43 M29 M62 M53 M47 M3 M5 M-40 M140 M
InterestPaidSupplementalData7 M7 M10 M13 M8 M6 M13 M43 M40 M39 M
Issuance of capital stock3 M12 M7 M3 M6 M2 M8 M
Issuance of debt10 M-90 M
IssuanceOfCapitalStock3 M12 M7 M3 M6 M2 M8 M
IssuanceOfDebt-40 M-103 M-5 M-6 M-6 M
Net cash from financing activities-51 M-49 M-113 M-264 M-120 M-580 M-152 M-77 M-27 M-124 M
Net cash from investing activities-234 M-58 M-163 M6 M-49 M-176 M-56 M-54 M-52 M-63 M
Net cash from operating activities387 M418 M321 M238 M405 M424 M-194 M108 M400 M235 M
Net change in cash & cash equivalents94 M299 M28 M-3 M220 M-340 M107 M317 M321 M45 M
Net income from continuing operations226 M198 M120 M-19 M113 M126 M-289 M-148 M20 M10 M
NetBusinessPurchaseAndSale-331 M25 M-24 M-110 M-4 M
NetCommonStockIssuance3 M12 M-98 M-247 M-94 M-58 M-115 M8 M-100 M
NetInvestmentPropertiesPurchaseAndSale178 M26 M-91 M70 M36 M17 M3 M4 M
NetInvestmentPurchaseAndSale178 M26 M-91 M70 M36 M17 M3 M4 M
NetIssuancePaymentsOfDebt-40 M-103 M-5 M-6 M-6 M
NetLongTermDebtIssuance-40 M-300 M-5 M-6 M-6 M
NetPPEPurchaseAndSale-81 M-109 M-72 M-64 M-61 M-83 M-55 M-54 M-56 M-63 M
Operating (gains) losses-20 M6 M
Other financing charges net-14 M-61 M-15 M-17 M-26 M-29 M-31 M-85 M-27 M-24 M
Other investing changes net-27 M-41 M-12 M3 M4 M
Other non-cash items61 M148 M95 M110 M132 M129 M16 M223 M200 M143 M
Payment of cash dividends488 M
Purchase of Float term investments-133 M
Purchase of property plant & equipment-81 M-109 M-72 M-64 M-61 M-83 M-55 M-54 M-56 M-63 M
Purchase of short term investments500 M
PurchaseOfInvestment-251 M-205 M-166 M-63 M-16 M-133 M
PurchaseOfLongTermInvestments-251 M-205 M-166 M-63 M-16 M
PurchaseOfPPE-81 M-109 M-72 M-64 M-61 M-83 M-55 M-54 M-56 M-63 M
Repayment of debt-40 M-300 M-5 M-6 M-6 M
RepaymentOfDebt-40 M-390 M-5 M-6 M-6 M
Repurchase of capital stock-105 M-250 M-100 M-60 M-115 M-100 M
Revenue per share18 M36 M32 M32 M34 M33 M
Sale of short term investments429 M258 M116 M133 M64 M150 M
SaleOfBusiness25 M
SaleOfInvestment429 M258 M116 M133 M64 M150 M
ShortTermDebtIssuance13 M
ShortTermDebtPayments-3 M-90 M
StockBasedCompensation63 M72 M85 M96 M118 M124 M109 M120 M88 M96 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University