Bakkt Holdings, Inc. (BKKT) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Bakkt Holdings, Inc. (BKKT) Bundle
Looking to calculate the intrinsic value of Bakkt Holdings, Inc.? Our BKKT DCF Calculator integrates real-world data with comprehensive customization features, allowing you to adjust forecasts and enhance your investment decisions.
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 | -.9 | 28.5 | 37.3 | 54.6 | 780.1 | 930.7 | 1,110.3 | 1,324.7 | 1,580.3 | 1,885.3 |
| Revenue Growth, % | 0 | -3398.03 | 30.81 | 46.4 | 1329.68 | 19.3 | 19.3 | 19.3 | 19.3 | 19.3 |
| EBITDA | -35.9 | -42.3 | -134.7 | -153.7 | -116.1 | -400.0 | -477.2 | -569.3 | -679.2 | -810.2 |
| EBITDA, % | 4150.58 | -148.43 | -361.52 | -281.62 | -14.88 | -42.98 | -42.98 | -42.98 | -42.98 | -42.98 |
| Depreciation | .1 | 8.0 | 16.2 | 25.4 | 13.9 | 204.2 | 243.6 | 290.7 | 346.8 | 413.7 |
| Depreciation, % | -10.07 | 27.98 | 43.56 | 46.46 | 1.79 | 21.94 | 21.94 | 21.94 | 21.94 | 21.94 |
| EBIT | -35.9 | -50.3 | -151.0 | -179.0 | -130.0 | -403.3 | -481.1 | -574.0 | -684.8 | -817.0 |
| EBIT, % | 4160.65 | -176.41 | -405.08 | -328.07 | -16.67 | -43.33 | -43.33 | -43.33 | -43.33 | -43.33 |
| Total Cash | 78.6 | 77.2 | 391.4 | 239.4 | 70.3 | 389.1 | 464.1 | 553.7 | 660.6 | 788.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | 10.4 | 18.1 | 25.3 | 29.7 | 252.0 | 300.6 | 358.7 | 427.9 | 510.5 |
| Account Receivables, % | 0 | 36.53 | 48.67 | 46.38 | 3.8 | 27.08 | 27.08 | 27.08 | 27.08 | 27.08 |
| Inventories | .0 | 42.1 | -18.1 | 39.9 | .0 | 231.7 | 276.4 | 329.8 | 393.4 | 469.3 |
| Inventories, % | 0 | 147.91 | -48.67 | 73.14 | 0 | 24.89 | 24.89 | 24.89 | 24.89 | 24.89 |
| Accounts Payable | 1.6 | 7.2 | 10.6 | 26.0 | 14.9 | 6.0 | 7.2 | 8.5 | 10.2 | 12.1 |
| Accounts Payable, % | -186.69 | 25.14 | 28.56 | 47.6 | 1.91 | 0.64443 | 0.64443 | 0.64443 | 0.64443 | 0.64443 |
| Capital Expenditure | -9.2 | -20.6 | -15.7 | -30.5 | -9.4 | -319.1 | -380.7 | -454.2 | -541.9 | -646.5 |
| Capital Expenditure, % | 1062.62 | -72.18 | -42.09 | -55.97 | -1.21 | -34.29 | -34.29 | -34.29 | -34.29 | -34.29 |
| Tax Rate, % | 66.79 | 66.79 | 66.79 | 66.79 | 66.79 | 66.79 | 66.79 | 66.79 | 66.79 | 66.79 |
| EBITAT | -35.7 | -50.5 | -151.2 | -51.7 | -43.2 | -291.6 | -347.9 | -415.0 | -495.1 | -590.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -43.2 | -110.1 | -94.6 | -106.8 | -14.2 | -869.5 | -577.2 | -688.6 | -821.5 | -980.0 |
| WACC, % | 21.27 | 21.28 | 21.28 | 20.59 | 20.63 | 21.01 | 21.01 | 21.01 | 21.01 | 21.01 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -2,262.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1,000 | |||||||||
| Terminal Value | -5,258 | |||||||||
| Present Terminal Value | -2,026 | |||||||||
| Enterprise Value | -4,288 | |||||||||
| Net Debt | -26 | |||||||||
| Equity Value | -4,263 | |||||||||
| Diluted Shares Outstanding, MM | 4 | |||||||||
| Equity Value Per Share | -1,196.22 |
What You Will Get
- Real Bakkt Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Bakkt Holdings’ fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive Financial Data: Bakkt Holdings, Inc.’s historical financial statements and pre-filled forecasts.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Valuation: Instantly see Bakkt’s intrinsic value update as you adjust inputs.
- Intuitive Visualizations: Dashboard graphs showcase valuation results and essential metrics.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based BKKT DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically refreshes Bakkt Holdings’ intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial strategy.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Accurate Data: Bakkt’s historical and projected financials preloaded for precision.
- Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience.
Who Should Use Bakkt Holdings, Inc. (BKKT)?
- Investors: Make informed decisions with a cutting-edge platform designed for digital asset management.
- Financial Analysts: Enhance your analysis with integrated tools for cryptocurrency valuation and forecasting.
- Consultants: Easily customize reports and presentations tailored to client needs in the digital asset space.
- Finance Enthusiasts: Expand your knowledge of blockchain and digital assets through hands-on experience.
- Educators and Students: Utilize it as a comprehensive resource for courses focused on finance and emerging technologies.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for Bakkt Holdings, Inc. (BKKT).
- Real-World Data: Bakkt’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into Bakkt's performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Bakkt Holdings, Inc. (BKKT).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results tailored to Bakkt's financial data.