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

18.00
 
USD
  
-0.09
  
(-0.50%)
Optionable: Yes  Market Cap: 2,557 M  90-day average vol: 2,534,258

Previous close: 18.09  Open: 18.11  Bid: 17.82  Ask: 18.2
52 week range    
14.15   
   28.76
Last updated: Wednesday 19th June 2024

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 ($)
Financials

TRIP Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AccruedPreferredStockDividends148 M-21 M-11 M
Amortization of intangibles18 M36 M32 M32 M34 M840 M862 M843 M822 M829 M
Basic EPS from continuing operations0.91-2.14-1.080.140.07
Basic EPS total1.581.380.83-0.140.820.91-2.14-1.080.140.07
Basic weighted shares outstanding143 M144 M145 M140 M138 M139 M135 M137 M140 M139 M
Cost of sales40 M58 M71 M72 M86 M94 M55 M74 M116 M149 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
Diluted EPS total1.551.360.82-0.140.810.89-2.14-1.080.140.08
Diluted normalized net income/share0.89-2.14-1.080.140.08
Diluted weighted shares outstanding146 M146 M147 M140 M140 M141 M135 M137 M146 M145 M
Dividends paid per share3.5
Earnings from equity interest-1000000.0-3 M-3 M-2 M-2 M
EarningsFromEquityInterestNetOfTax-1000000.0-3 M-3 M-2 M-2 M
GainOnSaleOfBusiness20 M-6 M
GainOnSaleOfSecurity-10 M2 M1000000.01000000.02 M4 M
GeneralAndAdministrativeExpense299 M417 M386 M400 M452 M480 M393 M379 M394 M464 M
Gross operating profit1,206 M1,434 M1,409 M1,484 M1,615 M1,466 M549 M828 M1,376 M1,639 M
ImpairmentOfCapitalAssets3 M
Income before tax322 M239 M151 M110 M173 M194 M-369 M-185 M67 M125 M
Income restructuring and M&A-1000000.01000000.041 M1000000.022 M
Income taxes96 M41 M31 M129 M60 M68 M-80 M-37 M47 M115 M
Interest income-18 M7 M-15 M-14 M7 M17 M3 M1000000.015 M47 M
InterestExpenseNonOperating9 M10 M12 M15 M12 M7 M35 M45 M44 M44 M
MiscOtherSpecialCharges-9 M17 M-3 M1000000.0-5 M-3 M-8 M-10 M-5 M-4 M
Net income from total operations226 M198 M120 M-19 M113 M126 M-289 M-148 M20 M10 M
NetIncomeCommonStockholders226 M198 M120 M-19 M113 M126 M-289 M-148 M20 M10 M
NetIncomeContinuousOperations226 M198 M120 M-19 M113 M126 M-289 M-148 M20 M10 M
NetNonOperatingInterestIncomeExpense-9 M-10 M-12 M-15 M-5 M10 M-32 M-44 M-29 M3 M
NonRecurringOperationExpense-2 M-5 M8 M3 M
Normalized income124 M
Operating income340 M232 M166 M124 M269 M187 M-329 M-131 M101 M126 M
Operating income before depreciation (EBITDA)396 M342 M264 M236 M301 M327 M-209 M-29 M208 M256 M
OperatingExpense866 M1,202 M1,243 M1,360 M1,346 M1,278 M834 M959 M1,275 M1,491 M
Other income net9 M-17 M3 M-1000000.05 M3 M8 M10 M5 M4 M
OtherGandA299 M417 M386 M400 M452 M480 M393 M379 M394 M464 M
OtherOperatingExpenses-13 M-15 M-16 M-17 M-21 M-11 M-3 M-5 M-5 M-8 M
OtherunderPreferredStockDividend148 M-21 M-11 M
PreferredStockDividends148 M-21 M-11 M
PromotionAndAdvertising-341 M-507 M-543 M-629 M-544 M423 M118 M282 M572 M706 M
RentAndLandingFees299 M417 M386 M400 M452 M
RestructringAndMnAIncome-1000000.01000000.041 M1000000.022 M
Revenue per share18 M36 M32 M32 M34 M849 M932 M853 M832 M839 M
SalariesAndWages-63 M-72 M-85 M-96 M-118 M-28 M-23 M-23 M-18 M-21 M
Selling Gen & administrative expense801 M1,109 M1,142 M1,249 M1,230 M1,152 M709 M848 M1,178 M1,404 M
SellingAndMarketingExpense502 M692 M756 M849 M778 M672 M316 M469 M784 M940 M
SellingExpense502 M692 M756 M849 M778 M
Special income/charges3 M1000000.05 M-1000000.0-44 M-1000000.0-8 M-22 M
Total Income available for interest expense (EBIT)331 M249 M163 M125 M185 M201 M-334 M-140 M111 M169 M
Total common shares outstanding286 M291 M288 M278 M276 M272 M135 M139 M141 M138 M
Total net income226 M198 M120 M-19 M113 M126 M-289 M-148 M20 M10 M
Total ordinary shares126 M126 M126 M126 M126 M126 M126 M126 M126 M126 M
Total revenues1,246 M1,492 M1,480 M1,556 M1,615 M1,560 M604 M902 M1,492 M1,788 M
TotalExpenses906 M1,260 M1,314 M1,432 M1,346 M1,372 M889 M1,033 M1,391 M1,640 M
TotalRevenue1,246 M1,492 M1,480 M1,556 M1,615 M1,560 M604 M902 M1,492 M1,788 M
WriteDown-1000000.0
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