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

16.07
 
USD
  
0.40
  
(2.55%)
Optionable: Yes  Market Cap: 2,162 M  90-day average vol: 2,618,306

Previous close: 15.67  Open: 15.75  Bid: 16.05  Ask: 16.2
52 week range    
14.39   
   27.30
Peers   
EXPE / 
MMYT / 
YELP / 
Last updated: Thursday 28th September 2023
56
MarketXLS Rank
60
Value
46
Technical
63
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

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

EXPE

29 B-27187.35

MMYT

3 B-78.527.7

NFLX

203 B38402.1

YELP

3 B70.534.01
Financials

TRIP Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AccruedPreferredStockDividends148 M-21 M
Amortization6 M18 M36 M32 M32 M34 M-42 M-36 M-30 M-23 M
Amortization of intangibles6 M18 M36 M32 M32 M34 M-33 M-26 M-20 M-13 M
Basic EPS from continuing operations-2.14-1.080.14
Basic EPS total1.441.581.380.83-0.140.820.91-2.14-1.080.14
Basic weighted shares outstanding143 M143 M144 M145 M140 M138 M139 M135 M137 M140 M
Cost of sales18 M40 M58 M71 M72 M86 M55 M74 M116 M
Depreciation30 M47 M57 M69 M79 M82 M126 M125 M111 M97 M
Depreciation unreconciled36 M65 M93 M101 M111 M116 M126 M125 M111 M97 M
DepreciationAndAmortization36 M65 M93 M101 M111 M116 M126 M125 M111 M97 M
Diluted EPS total1.411.551.360.82-0.140.810.89-2.14-1.080.14
Diluted normalized net income/share-2.14-1.080.14
Diluted weighted shares outstanding145 M146 M146 M147 M140 M140 M141 M135 M137 M146 M
Dividends paid per share3.5
Earnings from equity interest-1000000.0-3 M-3 M-2 M
EarningsFromEquityInterestNetOfTax-1000000.0-3 M-3 M-2 M
GainOnSaleOfBusiness20 M-6 M
GainOnSaleOfSecurity-2 M-10 M2 M
GeneralAndAdministrativeExpense229 M299 M417 M386 M400 M452 M574 M393 M379 M394 M
Gross operating profit927 M1,206 M1,434 M1,409 M1,484 M1,615 M1,560 M549 M828 M1,376 M
ImpairmentOfCapitalAssets3 M
Income before tax284 M322 M239 M151 M110 M173 M194 M-369 M-185 M67 M
Income restructuring and M&A-1000000.01000000.041 M-1000000.0-1000000.0
Income taxes79 M96 M41 M31 M129 M60 M68 M-80 M-37 M47 M
InsuranceAndClaims94 M
Interest income-10 M-18 M7 M-15 M-14 M7 M17 M3 M1000000.015 M
InterestExpenseNonOperating10 M9 M10 M12 M15 M12 M7 M35 M45 M44 M
MiscOtherSpecialCharges2 M-9 M17 M-3 M1000000.0-5 M-3 M-8 M-10 M-5 M
Net income from total operations205 M226 M198 M120 M-19 M113 M126 M-289 M-148 M20 M
NetIncomeCommonStockholders205 M226 M198 M120 M-19 M113 M126 M-289 M-296 M41 M
NetIncomeContinuousOperations205 M226 M198 M120 M-19 M113 M126 M-289 M-148 M20 M
NetNonOperatingInterestIncomeExpense-10 M-9 M-10 M-12 M-15 M-5 M10 M-32 M-44 M-29 M
NonRecurringOperationExpense-2 M-5 M-8 M
Operating income294 M340 M232 M166 M124 M269 M188 M-285 M-131 M101 M
Operating income before depreciation (EBITDA)336 M396 M342 M264 M236 M301 M327 M-209 M-29 M208 M
OperatingExpense633 M866 M1,202 M1,243 M1,360 M1,346 M1,372 M834 M959 M1,275 M
Other income net2 M9 M-17 M3 M-1000000.05 M3 M8 M10 M5 M
OtherGandA229 M299 M417 M386 M400 M452 M574 M393 M379 M394 M
OtherOperatingExpenses-12 M-13 M-15 M-16 M-17 M-21 M-24 M-28 M-21 M-19 M
OtherunderPreferredStockDividend148 M-21 M
PreferredStockDividends148 M-21 M
PromotionAndAdvertising-237 M-341 M-507 M-543 M-629 M-544 M-423 M-118 M-282 M-572 M
RentAndLandingFees229 M299 M417 M386 M400 M452 M480 M220 M212 M222 M
RestructringAndMnAIncome-1000000.01000000.041 M-1000000.0-1000000.0
SalariesAndWages-49 M-63 M-72 M-85 M-96 M-118 M-124 M-109 M-120 M-88 M
SecuritiesAmortization94 M
Selling Gen & administrative expense597 M801 M1,109 M1,142 M1,249 M1,230 M1,246 M709 M848 M1,178 M
SellingAndMarketingExpense368 M502 M692 M756 M849 M778 M672 M316 M469 M784 M
SellingExpense368 M502 M692 M756 M849 M778 M672 M316 M469 M784 M
Special income/charges3 M1000000.05 M-1000000.0-44 M1000000.09 M
Total Income available for interest expense (EBIT)294 M331 M249 M163 M125 M185 M201 M-334 M-140 M111 M
Total common shares outstanding284 M286 M291 M288 M278 M276 M272 M135 M139 M141 M
Total net income205 M226 M198 M120 M-19 M113 M126 M-289 M-148 M20 M
Total ordinary shares125 M125 M125 M125 M125 M125 M125 M125 M125 M125 M
Total revenues945 M1,246 M1,492 M1,480 M1,556 M1,615 M1,560 M604 M902 M1,492 M
TotalExpenses651 M906 M1,260 M1,314 M1,432 M1,346 M1,372 M889 M1,033 M1,391 M
TotalRevenue945 M1,246 M1,492 M1,480 M1,556 M1,615 M1,560 M604 M902 M1,492 M
WriteDown-1000000.0
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today