Vivakor, Inc. (VIVK) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Vivakor, Inc. (VIVK) Bundle
Evaluate Vivakor, Inc.'s (VIVK) financial outlook like an expert! This (VIVK) DCF Calculator provides pre-filled financial data while allowing you the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | .0 | 1.5 | 1.1 | 28.1 | 59.3 | 85.2 | 122.4 | 175.9 | 252.7 | 363.1 |
Revenue Growth, % | 0 | 0 | -25.34 | 2482.37 | 111.06 | 43.67 | 43.67 | 43.67 | 43.67 | 43.67 |
EBITDA | -.9 | -.8 | -6.3 | -20.2 | -2.8 | -21.9 | -31.5 | -45.2 | -64.9 | -93.3 |
EBITDA, % | 100 | -51.83 | -582.66 | -71.91 | -4.69 | -25.69 | -25.69 | -25.69 | -25.69 | -25.69 |
Depreciation | 1.5 | 1.6 | 1.5 | 3.0 | 3.9 | 54.1 | 77.7 | 111.6 | 160.3 | 230.3 |
Depreciation, % | 100 | 107.19 | 134.37 | 10.51 | 6.63 | 63.43 | 63.43 | 63.43 | 63.43 | 63.43 |
EBIT | -2.4 | -2.3 | -7.8 | -23.2 | -6.7 | -33.0 | -47.4 | -68.2 | -97.9 | -140.7 |
EBIT, % | 100 | -159.03 | -717.03 | -82.42 | -11.32 | -38.75 | -38.75 | -38.75 | -38.75 | -38.75 |
Total Cash | .6 | 4.4 | 3.7 | 4.8 | 1.2 | 54.4 | 78.2 | 112.3 | 161.4 | 231.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | -.1 | .0 | .0 | 3.6 | 2.6 | 20.1 | 28.8 | 41.4 | 59.5 | 85.5 |
Account Receivables, % | 100 | 0.5306 | 0.0776349 | 12.68 | 4.44 | 23.55 | 23.55 | 23.55 | 23.55 | 23.55 |
Inventories | 1.7 | 1.7 | 1.4 | .0 | .0 | 51.2 | 73.5 | 105.6 | 151.8 | 218.0 |
Inventories, % | 100 | 116.1 | 124.83 | 0.16786 | 0.07523716 | 60.05 | 60.05 | 60.05 | 60.05 | 60.05 |
Accounts Payable | .6 | 1.0 | 1.5 | 5.0 | 7.2 | 50.9 | 73.2 | 105.1 | 151.0 | 217.0 |
Accounts Payable, % | 100 | 68.87 | 133.27 | 17.87 | 12.07 | 59.76 | 59.76 | 59.76 | 59.76 | 59.76 |
Capital Expenditure | -1.9 | -1.2 | -4.5 | -2.5 | -3.3 | -33.7 | -48.5 | -69.6 | -100.0 | -143.7 |
Capital Expenditure, % | 100 | -83.47 | -414.79 | -8.86 | -5.6 | -39.59 | -39.59 | -39.59 | -39.59 | -39.59 |
Tax Rate, % | 0.03674167 | 0.03674167 | 0.03674167 | 0.03674167 | 0.03674167 | 0.03674167 | 0.03674167 | 0.03674167 | 0.03674167 | 0.03674167 |
EBITAT | -3.1 | -2.3 | -5.2 | -18.2 | -6.7 | -29.3 | -42.1 | -60.4 | -86.8 | -124.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -4.5 | -1.6 | -7.5 | -16.5 | -3.0 | -33.7 | -21.7 | -31.2 | -44.9 | -64.5 |
WACC, % | 10.09 | 9.96 | 7.78 | 8.63 | 10.09 | 9.31 | 9.31 | 9.31 | 9.31 | 9.31 |
PV UFCF | ||||||||||
SUM PV UFCF | -145.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -66 | |||||||||
Terminal Value | -899 | |||||||||
Present Terminal Value | -576 | |||||||||
Enterprise Value | -722 | |||||||||
Net Debt | 33 | |||||||||
Equity Value | -755 | |||||||||
Diluted Shares Outstanding, MM | 19 | |||||||||
Equity Value Per Share | -39.18 |
What You Will Get
- Real VIVK Financial Data: Pre-populated with Vivakor's historical and projected data for thorough analysis.
- Fully Editable Template: Easily adjust key inputs like revenue growth, WACC, and EBITDA %.
- Automatic Calculations: Watch Vivakor’s intrinsic value update in real-time as you make changes.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF results.
- User-Friendly Design: Intuitive layout and straightforward instructions suitable for all experience levels.
Key Features
- Pre-Loaded Data: Vivakor's historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: View Vivakor's intrinsic value recalculated in real time.
- Clear Visual Outputs: Dashboard charts showcase valuation results and key metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Vivakor, Inc. (VIVK) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Vivakor, Inc. (VIVK)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Vivakor, Inc. (VIVK)?
- Innovative Solutions: Cutting-edge technology that sets us apart in the industry.
- Sustainable Practices: Commitment to environmentally friendly operations and products.
- Expert Team: Experienced professionals dedicated to delivering exceptional results.
- Proven Track Record: A history of success and reliability in our services and products.
- Customer-Centric Approach: Focused on meeting the unique needs of our clients.
Who Should Use This Product?
- Investors: Accurately assess Vivakor, Inc.'s (VIVK) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for financial analysis and reporting.
- Consultants: Easily customize the template for client valuation reports.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading companies.
- Educators: Implement it as a resource for teaching valuation techniques.
What the Template Contains
- Pre-Filled Data: Contains Vivakor, Inc.’s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on user-defined inputs.
- Key Financial Ratios: Evaluate Vivakor, Inc.’s profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visualizations and tables summarizing essential valuation outcomes.