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 124 50 -58.3
Change - -205.71% -23.24% 18.86% 193.51% -28.32% -59.68% -216.6%
Announcement Date 17/02/22 15/02/23 15/02/24 20/02/25 12/02/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.73 48.07 52.85
Change - 3.7% 12.5% 17.46% 10.81% -44.23% 5.12% 9.93%
Free Cash Flow (FCF) 1 54 344 172 70 163 207.3 167 194.5
Change - 537.04% -50% -59.3% 132.86% 27.2% -19.48% 16.48%
Announcement Date 17/02/22 15/02/23 15/02/24 20/02/25 12/02/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.51% 12.59% 13.63%
EBIT Margin (%) -14.52% 6.77% 7.05% 5.01% 4.23% -23.05% 4.15% 5.63%
EBT Margin (%) -20.51% 4.49% 6.99% 4.74% 2.38% -25.81% 1.3% 3.45%
Net margin (%) -16.41% 1.34% 0.56% 0.27% 2.12% -23.13% 0.61% 1.98%
FCF margin (%) 5.99% 23.06% 9.62% 3.81% 8.62% 13.47% 11.12% 12.52%
FCF / Net Income (%) -36.49% 1,720% 1,720% 1,400% 407.5% -58.22% 1,823.12% 631.78%

Profitability

        
ROA -1.93% 4.49% 7.29% 7.38% 6.4% 2.7% 4.03% 3.71%
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 0.7x 0.26x -
Debt / Free cash flow 3.24x - - - 1.06x 0.6x 0.3x -

Capital Intensity

        
CAPEX / Current Assets (%) 5.99% 3.75% 3.52% 4.03% 4.34% 2.97% 3.2% 3.4%
CAPEX / EBITDA (%) 54% 18.98% 18.86% 21.83% 25.71% 25.82% 25.43% 24.97%
CAPEX / FCF (%) 100% 16.28% 36.63% 105.71% 50.31% 22.06% 28.79% 27.18%

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 -3.046 0.1333 0.2406
Change - 112.96% -42.86% -50% 675% -1,082.52% 104.38% 80.46%
Nbr of stocks (in thousands) 138,181 140,586 138,515 139,336 116,803 117,826 117,826 117,826
Announcement Date 17/02/22 15/02/23 15/02/24 20/02/25 12/02/26 - - -
1USD
Estimates
2026 *2027 *
P/E -2.3x 52.6x
PBR 2.47x 2.3x
EV / Sales 0.62x 0.58x
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.010USD
Average target price
11.46USD
Spread / Average Target
+63.54%
  1. Stock Market
  2. Stocks
  3. TRIP Stock
  4. Financials Tripadvisor, Inc.