Projected Income Statement: Tripadvisor, Inc.

Forecast Balance Sheet: Tripadvisor, Inc.

Forecast Balance Sheet - Tripadvisor, Inc.
Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 175 -185 -228 -185 173 -55.8 -108 -233
Change - -205.71% -23.24% 18.86% 193.51% -132.25% -93.55% -115.74%
Announcement Date 2/16/22 2/14/23 2/14/24 2/20/25 2/12/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Tripadvisor, Inc.

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 54 56 63 74 82 45.95 52.53 58.25
Change - 3.7% 12.5% 17.46% 10.81% -43.97% 14.32% 10.89%
Free Cash Flow (FCF) 1 54 344 172 70 163 193.1 167 194.5
Change - 537.04% -50% -59.3% 132.86% 18.48% -13.55% 16.48%
Announcement Date 2/16/22 2/14/23 2/14/24 2/20/25 2/12/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Tripadvisor, Inc.

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 11.09% 19.77% 18.68% 18.47% 16.87% 11.91% 13.7% 13.93%
EBIT Margin (%) -14.52% 6.77% 7.05% 5.01% 4.23% -19.73% 4.42% 5.46%
EBT Margin (%) -20.51% 4.49% 6.99% 4.74% 2.38% -22.27% 1.95% 3.63%
Net margin (%) -16.41% 1.34% 0.56% 0.27% 2.12% -20.38% 1.12% 2.44%
FCF margin (%) 5.99% 23.06% 9.62% 3.81% 8.62% 12.52% 11.06% 12.44%
FCF / Net Income (%) -36.49% 1,720% 1,720% 1,400% 407.5% -61.41% 990.37% 509.67%

Profitability

        
ROA -1.93% 4.49% 7.29% 7.38% 6.4% 1.85% 3.12% 3.16%
ROE -4.9% 13.21% 21.48% 20.73% 20.91% 37.39% 19.63% 20.87%

Financial Health

        
Leverage (Debt/EBITDA) 1.75x - - - 0.54x - - -
Debt / Free cash flow 3.24x - - - 1.06x - - -

Capital Intensity

        
CAPEX / Current Assets (%) 5.99% 3.75% 3.52% 4.03% 4.34% 2.98% 3.48% 3.72%
CAPEX / EBITDA (%) 54% 18.98% 18.86% 21.83% 25.71% 25.01% 25.41% 26.74%
CAPEX / FCF (%) 100% 16.28% 36.63% 105.71% 50.31% 23.79% 31.46% 29.95%

Items per share

        
Cash flow per share 1 0.7883 2.74 - - 1.87 1.927 1.41 -
Change - 247.58% - - - 3.02% -26.83% -
Dividend per Share 1 - - - - - - - -
Change - - - - - - - -
Book Value Per Share 1 5.717 5.897 6.007 6.726 5.635 2.839 3.044 3.587
Change - 3.14% 1.86% 11.98% -16.23% -49.61% 7.21% 17.83%
EPS 1 -1.08 0.14 0.08 0.04 0.31 -2.708 0.1997 0.3051
Change - 112.96% -42.86% -50% 675% -973.48% 107.37% 52.77%
Nbr of stocks (in thousands) 138,181 140,586 138,515 139,336 116,803 117,826 117,826 117,826
Announcement Date 2/16/22 2/14/23 2/14/24 2/20/25 2/12/26 - - -
1USD
Estimates
2026 *2027 *
P/E -2.67x 36.3x
PBR 2.55x 2.38x
EV / Sales 0.52x 0.49x
Yield - -

EPS & Dividend

EPS & Dividend - Tripadvisor, Inc.


Y-o-Y evolution of P/E

Valuation ratios - P/E - Tripadvisor, Inc.
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - Tripadvisor, Inc.
Trader
Investor
Global
Quality
ESG MSCI
BB
MarketScreener Ratings - Tripadvisor, Inc.
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
16
Last Close Price
7.240USD
Average target price
11.57USD
Spread / Average Target
+59.83%
  1. Stock Market
  2. Stocks
  3. TRIP Stock
  4. Financials Tripadvisor, Inc.