WISeKey International Holding AG (WKEY) 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
WISeKey International Holding AG (WKEY) Bundle
Looking to assess the intrinsic value of WISeKey International Holding AG? Our WKEY DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your forecasts and enhance your investment strategies.
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 | 22.7 | 14.8 | 22.3 | 23.2 | 30.9 | 35.0 | 39.7 | 45.0 | 51.0 | 57.8 |
Revenue Growth, % | 0 | -34.76 | 50.61 | 4.22 | 33.28 | 13.34 | 13.34 | 13.34 | 13.34 | 13.34 |
EBITDA | -19.9 | -26.1 | -20.4 | -11.7 | -13.0 | -26.1 | -29.5 | -33.5 | -37.9 | -43.0 |
EBITDA, % | -88.01 | -176.32 | -91.46 | -50.24 | -42.07 | -74.36 | -74.36 | -74.36 | -74.36 | -74.36 |
Depreciation | 1.4 | 1.6 | 1.0 | .6 | .6 | 1.8 | 2.1 | 2.3 | 2.6 | 3.0 |
Depreciation, % | 5.98 | 10.77 | 4.47 | 2.6 | 2.02 | 5.17 | 5.17 | 5.17 | 5.17 | 5.17 |
EBIT | -21.3 | -27.7 | -21.4 | -12.3 | -13.6 | -27.1 | -30.7 | -34.8 | -39.5 | -44.7 |
EBIT, % | -93.99 | -187.1 | -95.93 | -52.83 | -44.09 | -77.37 | -77.37 | -77.37 | -77.37 | -77.37 |
Total Cash | 12.1 | 28.8 | 34.2 | 4.1 | 15.3 | 22.5 | 25.5 | 28.9 | 32.7 | 37.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 5.2 | 3.7 | 3.0 | 2.4 | 5.3 | 6.3 | 7.1 | 8.0 | 9.1 | 10.3 |
Account Receivables, % | 23.11 | 25.03 | 13.69 | 10.34 | 17.03 | 17.84 | 17.84 | 17.84 | 17.84 | 17.84 |
Inventories | 2.8 | 2.5 | 2.7 | 7.5 | 5.2 | 6.3 | 7.2 | 8.1 | 9.2 | 10.5 |
Inventories, % | 12.3 | 16.74 | 12.18 | 32.37 | 16.92 | 18.1 | 18.1 | 18.1 | 18.1 | 18.1 |
Accounts Payable | 5.5 | 4.6 | 8.9 | 9.1 | 12.9 | 12.3 | 14.0 | 15.9 | 18.0 | 20.4 |
Accounts Payable, % | 24.2 | 31.18 | 40.09 | 39.06 | 41.6 | 35.23 | 35.23 | 35.23 | 35.23 | 35.23 |
Capital Expenditure | -.3 | -.1 | .0 | -.3 | -3.0 | -.9 | -1.0 | -1.2 | -1.3 | -1.5 |
Capital Expenditure, % | -1.29 | -0.35185 | -0.16174 | -1.31 | -9.77 | -2.58 | -2.58 | -2.58 | -2.58 | -2.58 |
Tax Rate, % | -0.92647 | -0.92647 | -0.92647 | -0.92647 | -0.92647 | -0.92647 | -0.92647 | -0.92647 | -0.92647 | -0.92647 |
EBITAT | -21.3 | -27.7 | -21.3 | -28.0 | -13.8 | -27.1 | -30.7 | -34.8 | -39.4 | -44.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -22.8 | -25.1 | -15.6 | -31.7 | -12.9 | -28.8 | -29.7 | -33.7 | -38.2 | -43.3 |
WACC, % | 13.46 | 13.46 | 13.46 | 13.46 | 13.46 | 13.46 | 13.46 | 13.46 | 13.46 | 13.46 |
PV UFCF | ||||||||||
SUM PV UFCF | -117.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -44 | |||||||||
Terminal Value | -385 | |||||||||
Present Terminal Value | -205 | |||||||||
Enterprise Value | -322 | |||||||||
Net Debt | -6 | |||||||||
Equity Value | -317 | |||||||||
Diluted Shares Outstanding, MM | 9 | |||||||||
Equity Value Per Share | -35.35 |
What You Will Get
- Accurate WKEY Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures to fit your analysis.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically as you make changes.
- Comprehensive Scenario Analysis: Evaluate various scenarios to assess WISeKey’s future performance.
- User-Friendly Interface: Designed for industry professionals while remaining easy to navigate for newcomers.
Key Features
- 🔍 Real-Life WKEY Financials: Pre-filled historical and projected data for WISeKey International Holding AG (WKEY).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate WISeKey’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize WISeKey’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered WISeKey data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for WISeKey’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for WISeKey International Holding AG (WKEY)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Adjustments: Observe immediate updates to WISeKey’s valuation as you change inputs.
- Pre-Configured Data: Comes with WISeKey’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: A preferred tool for investors and analysts for making well-informed choices.
Who Should Use This Product?
- Finance Students: Master valuation methods and implement them with actual market data.
- Academics: Integrate industry-standard models into your teaching or scholarly research.
- Investors: Validate your investment hypotheses and assess valuation results for WISeKey International Holding AG (WKEY).
- Analysts: Enhance your efficiency with a customizable DCF model designed for ease of use.
- Entrepreneurs: Understand the analytical approaches used for evaluating large public firms like WISeKey International Holding AG (WKEY).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled WISeKey International Holding AG (WKEY) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for WISeKey International Holding AG (WKEY).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.