Viad Corp (VVI) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Viad Corp (VVI) Bundle
Explore Viad Corp's (VVI) financial potential with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to determine Viad Corp's (VVI) intrinsic value and shape your investment strategy.
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 | 90.2 | 415.4 | 507.3 | 1,127.3 | 1,238.7 | 1,957.1 | 3,092.3 | 4,885.8 | 7,719.6 | 12,196.9 |
Revenue Growth, % | 0 | 360.35 | 22.12 | 122.2 | 9.88 | 58 | 58 | 58 | 58 | 58 |
EBITDA | 77.9 | -286.0 | -12.9 | 122.0 | 142.1 | 145.5 | 229.9 | 363.3 | 574.0 | 906.9 |
EBITDA, % | 86.28 | -68.85 | -2.54 | 10.82 | 11.47 | 7.44 | 7.44 | 7.44 | 7.44 | 7.44 |
Depreciation | 59.0 | 56.6 | 53.8 | 52.5 | 51.0 | 384.9 | 608.1 | 960.8 | 1,518.1 | 2,398.5 |
Depreciation, % | 65.34 | 13.62 | 10.59 | 4.66 | 4.12 | 19.67 | 19.67 | 19.67 | 19.67 | 19.67 |
EBIT | 18.9 | -342.6 | -66.6 | 69.5 | 91.1 | -239.3 | -378.2 | -597.5 | -944.1 | -1,491.6 |
EBIT, % | 20.94 | -82.47 | -13.14 | 6.17 | 7.35 | -12.23 | -12.23 | -12.23 | -12.23 | -12.23 |
Total Cash | 62.0 | 39.5 | 61.6 | 59.7 | 52.7 | 391.1 | 617.9 | 976.3 | 1,542.6 | 2,437.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 139.5 | 18.2 | 93.9 | 122.7 | 128.7 | 564.2 | 891.5 | 1,408.6 | 2,225.5 | 3,516.4 |
Account Receivables, % | 154.58 | 4.37 | 18.5 | 10.88 | 10.39 | 28.83 | 28.83 | 28.83 | 28.83 | 28.83 |
Inventories | 17.3 | 8.7 | 8.6 | 10.8 | 10.2 | 96.7 | 152.8 | 241.4 | 381.4 | 602.6 |
Inventories, % | 19.14 | 2.1 | 1.69 | 0.9567 | 0.81966 | 4.94 | 4.94 | 4.94 | 4.94 | 4.94 |
Accounts Payable | 86.7 | 21.0 | 69.7 | 73.0 | 77.4 | 499.3 | 788.8 | 1,246.4 | 1,969.3 | 3,111.4 |
Accounts Payable, % | 96.03 | 5.06 | 13.73 | 6.48 | 6.25 | 25.51 | 25.51 | 25.51 | 25.51 | 25.51 |
Capital Expenditure | -76.1 | -53.6 | -57.9 | -67.2 | -76.1 | -472.8 | -747.1 | -1,180.4 | -1,865.0 | -2,946.7 |
Capital Expenditure, % | -84.38 | -12.89 | -11.42 | -5.96 | -6.14 | -24.16 | -24.16 | -24.16 | -24.16 | -24.16 |
Tax Rate, % | 62.81 | 62.81 | 62.81 | 62.81 | 62.81 | 62.81 | 62.81 | 62.81 | 62.81 | 62.81 |
EBITAT | 15.9 | -356.1 | -65.4 | 46.6 | 33.9 | -185.1 | -292.5 | -462.2 | -730.3 | -1,153.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -71.3 | -288.9 | -96.5 | 4.3 | 7.8 | -373.3 | -525.3 | -829.9 | -1,311.3 | -2,071.8 |
WACC, % | 11.34 | 11.84 | 11.78 | 10.77 | 9.81 | 11.11 | 11.11 | 11.11 | 11.11 | 11.11 |
PV UFCF | ||||||||||
SUM PV UFCF | -3,450.4 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | -2,144 | |||||||||
Terminal Value | -28,183 | |||||||||
Present Terminal Value | -16,644 | |||||||||
Enterprise Value | -20,094 | |||||||||
Net Debt | 523 | |||||||||
Equity Value | -20,617 | |||||||||
Diluted Shares Outstanding, MM | 21 | |||||||||
Equity Value Per Share | -977.27 |
What You Will Get
- Real VVI Financial Data: Pre-filled with Viad Corp’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Viad Corp’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Financial Data: Viad Corp’s historical financial reports and pre-filled projections.
- Customizable Assumptions: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Monitor Viad Corp’s intrinsic value recalculating instantly.
- Intuitive Visual Representations: Dashboard graphs showcase valuation results and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Viad Corp (VVI) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Viad Corp’s (VVI) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Viad Corp (VVI)?
- Designed for Experts: A sophisticated tool favored by financial analysts, CFOs, and industry consultants.
- Accurate Financial Data: Viad Corp’s historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Easily simulate various forecasts and assumptions for better decision-making.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth and intuitive experience.
Who Should Use This Product?
- Investors: Assess Viad Corp's (VVI) intrinsic value to inform your investment choices.
- CFOs: Utilize a high-quality DCF model for accurate financial reporting and analysis.
- Consultants: Easily customize the template for client valuation reports.
- Entrepreneurs: Discover financial modeling techniques employed by leading corporations.
- Educators: Apply it as a resource to illustrate valuation methods in the classroom.
What the Template Contains
- Pre-Filled DCF Model: Viad Corp’s (VVI) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Viad Corp’s (VVI) 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.