Travelzoo (TZOO) DCF Valuation

Travelzoo (TZOO) DCF Valuation
  • ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • ✓ Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • ✓ Pré-Construídos Para Uso Rápido E Eficiente
  • ✓ Não É Necessária Experiência; Fácil De Seguir

Travelzoo (TZOO) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Gain insight into your Travelzoo (TZOO) valuation analysis with our sophisticated DCF Calculator! This Excel template comes preloaded with real (TZOO) data, enabling you to adjust forecasts and assumptions for an accurate calculation of Travelzoo's intrinsic value.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2019		 AY2
2020		 AY3
2021		 AY4
2022		 AY5
2023		 FY1
2024		 FY2
2025		 FY3
2026		 FY4
2027		 FY5
2028
Revenue 111.4 53.6 63.2 70.6 84.5 83.9 83.4 82.8 82.3 81.7
Revenue Growth, % 0 -51.89 17.89 11.72 19.66 -0.65433 -0.65433 -0.65433 -0.65433 -0.65433
EBITDA 18.4 -8.9 .5 9.7 17.5 5.9 5.8 5.8 5.8 5.7
EBITDA, % 16.48 -16.69 0.80234 13.8 20.67 7.01 7.01 7.01 7.01 7.01
Depreciation 1.3 2.3 1.8 2.2 1.9 2.3 2.3 2.3 2.3 2.2
Depreciation, % 1.18 4.32 2.88 3.1 2.24 2.74 2.74 2.74 2.74 2.74
EBIT 17.0 -11.3 -1.3 7.6 15.6 3.6 3.6 3.5 3.5 3.5
EBIT, % 15.3 -21.01 -2.08 10.7 18.43 4.27 4.27 4.27 4.27 4.27
Total Cash 19.5 63.1 43.8 18.7 15.7 38.9 38.7 38.4 38.2 37.9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 11.2 4.5 14.9 13.8 13.0
Account Receivables, % 10.06 8.43 23.53 19.58 15.35
Inventories 1.1 1.3 3.5 2.9 .0 2.2 2.2 2.2 2.2 2.1
Inventories, % 0.99002 2.42 5.54 4.16 0 2.62 2.62 2.62 2.62 2.62
Accounts Payable 19.3 7.0 72.1 4.3 25.2 27.9 27.7 27.5 27.4 27.2
Accounts Payable, % 17.37 13.05 114.08 6.05 29.79 33.25 33.25 33.25 33.25 33.25
Capital Expenditure -.5 -.3 .0 -1.5 -.3 -.6 -.6 -.6 -.6 -.6
Capital Expenditure, % -0.42545 -0.47201 -0.04589334 -2.14 -0.30186 -0.67709 -0.67709 -0.67709 -0.67709 -0.67709
Tax Rate, % 27.74 27.74 27.74 27.74 27.74 27.74 27.74 27.74 27.74 27.74
EBITAT 7.9 -9.2 -.4 5.0 11.3 2.1 2.1 2.1 2.1 2.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 15.8 -13.0 53.9 -60.5 37.6 4.5 3.8 3.7 3.7 3.7
WACC, % 12.12 12.16 12.09 12.14 12.15 12.13 12.13 12.13 12.13 12.13
PV UFCF
SUM PV UFCF 14.0
Long Term Growth Rate, % 1.00
Free cash flow (T + 1) 4
Terminal Value 33
Present Terminal Value 19
Enterprise Value 33
Net Debt -6
Equity Value 39
Diluted Shares Outstanding, MM 15
Equity Value Per Share 2.63

What You Will Get

  • Real TZOO Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
  • Scenario Analysis: Explore various scenarios to assess Travelzoo's future performance.
  • User-Friendly Design: Designed for professionals while remaining approachable for newcomers.

Key Features

  • Customizable Travel Metrics: Adjust essential inputs such as booking rates, average revenue per user, and operational costs.
  • Instant Trip Valuation: Quickly calculates intrinsic value, net present value, and other financial metrics.
  • High-Precision Accuracy: Utilizes Travelzoo’s actual financial data for reliable valuation results.
  • Effortless Scenario Testing: Easily explore various assumptions and analyze different outcomes.
  • Efficiency Booster: Avoid the hassle of creating intricate valuation models from the ground up.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Travelzoo (TZOO) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Travelzoo’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Travelzoo Calculator?

  • Accuracy: Real Travelzoo financials ensure data accuracy.
  • Flexibility: Designed for users to test and modify inputs freely.
  • Time-Saving: Skip the hassle of building a travel cost model from scratch.
  • Professional-Grade: Developed with CFO-level precision and usability in mind.
  • User-Friendly: Easy to use, even for those without advanced financial modeling experience.

Who Should Use This Product?

  • Travel Industry Professionals: Develop comprehensive and accurate travel package valuations for market analysis.
  • Corporate Strategy Teams: Evaluate travel trends and scenarios to inform business decisions.
  • Travel Consultants and Advisors: Offer clients precise insights into the valuation of Travelzoo (TZOO) services.
  • Students and Educators: Utilize real-time data to learn and teach about travel industry financial modeling.
  • Travel Enthusiasts: Gain insights into how travel companies like Travelzoo (TZOO) are assessed in the market.

What the Template Contains

  • Pre-Filled DCF Model: Travelzoo’s financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Travelzoo’s profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.

No products were found matching.