Nikola Corporation (NKLA) 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
Nikola Corporation (NKLA) Bundle
Designed for accuracy, our Nikola Corporation (NKLA) DCF Calculator enables you to evaluate Nikola’s valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved 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 | .5 | .1 | .1 | 50.8 | 35.8 | 35.0 | 34.1 | 33.3 | 32.5 | 31.7 |
Revenue Growth, % | 0 | -80.29 | 0 | 53400 | -29.49 | -2.44 | -2.44 | -2.44 | -2.44 | -2.44 |
EBITDA | -85.7 | -362.3 | -685.3 | -677.0 | -736.3 | -35.0 | -34.1 | -33.3 | -32.5 | -31.7 |
EBITDA, % | -17774.27 | -381381.05 | -721363.16 | -1332 | -2054.4 | -100 | -100 | -100 | -100 | -100 |
Depreciation | 2.3 | 6.0 | 8.2 | 22.8 | 35.9 | 31.1 | 30.3 | 29.6 | 28.9 | 28.2 |
Depreciation, % | 481.95 | 6324.21 | 8664.21 | 44.79 | 100.14 | 88.96 | 88.96 | 88.96 | 88.96 | 88.96 |
EBIT | -88.0 | -368.3 | -693.5 | -699.8 | -772.2 | -35.0 | -34.1 | -33.3 | -32.5 | -31.7 |
EBIT, % | -18256.22 | -387705.26 | -730027.37 | -1376.79 | -2154.55 | -100 | -100 | -100 | -100 | -100 |
Total Cash | 85.7 | 840.9 | 497.2 | 233.4 | 465.9 | 35.0 | 34.1 | 33.3 | 32.5 | 31.7 |
Total Cash, percent | .0 | .9 | .5 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .7 | .0 | .0 | 31.6 | 27.2 | 16.7 | 16.2 | 15.8 | 15.5 | 15.1 |
Account Receivables, % | 136.51 | 0 | 0 | 62.25 | 75.89 | 47.63 | 47.63 | 47.63 | 47.63 | 47.63 |
Inventories | 1.9 | .0 | 11.6 | 123.2 | 62.6 | 28.0 | 27.3 | 26.6 | 26.0 | 25.3 |
Inventories, % | 388.38 | 0 | 12207.37 | 242.39 | 174.64 | 80 | 80 | 80 | 80 | 80 |
Accounts Payable | 5.1 | 29.4 | 87.0 | 93.2 | 44.1 | 35.0 | 34.1 | 33.3 | 32.5 | 31.7 |
Accounts Payable, % | 1060.79 | 30909.47 | 91560 | 183.46 | 123.14 | 100 | 100 | 100 | 100 | 100 |
Capital Expenditure | -39.3 | -22.3 | -179.3 | -170.7 | -120.5 | -35.0 | -34.1 | -33.3 | -32.5 | -31.7 |
Capital Expenditure, % | -8153.94 | -23498.95 | -188704.21 | -335.91 | -336.27 | -100 | -100 | -100 | -100 | -100 |
Tax Rate, % | -13.92 | -13.92 | -13.92 | -13.92 | -13.92 | -13.92 | -13.92 | -13.92 | -13.92 | -13.92 |
EBITAT | -88.1 | -367.3 | -693.5 | -699.8 | -879.7 | -34.9 | -34.1 | -33.3 | -32.4 | -31.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -122.5 | -356.9 | -818.5 | -984.7 | -948.4 | -2.8 | -37.6 | -36.7 | -35.8 | -34.9 |
WACC, % | 25.48 | 25.41 | 25.48 | 25.48 | 25.48 | 25.47 | 25.47 | 25.47 | 25.47 | 25.47 |
PV UFCF | ||||||||||
SUM PV UFCF | -70.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -36 | |||||||||
Terminal Value | -152 | |||||||||
Present Terminal Value | -49 | |||||||||
Enterprise Value | -119 | |||||||||
Net Debt | -180 | |||||||||
Equity Value | 61 | |||||||||
Diluted Shares Outstanding, MM | 27 | |||||||||
Equity Value Per Share | 2.27 |
What You Will Get
- Real NKLA Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Automated Calculations: Dynamic computation of intrinsic value and NPV.
- Scenario Analysis: Explore various scenarios to assess Nikola's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Model: Features detailed unlevered and levered DCF valuation frameworks.
- WACC Analysis Tool: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Inputs: Adjust growth projections, capital investments, and discount rates as needed.
- Integrated Financial Ratios: Assess profitability, leverage, and operational efficiency ratios for Nikola Corporation (NKLA).
- Interactive Dashboard and Visuals: Graphical representations highlight essential valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the pre-formatted Excel file containing Nikola Corporation's (NKLA) financial data.
- Customize: Modify projections, including sales growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and analyze results instantly.
- Make Decisions: Leverage the valuation outcomes to inform your investment approach.
Why Choose Nikola Corporation (NKLA)?
- Innovative Technology: Pioneering advancements in electric and hydrogen fuel cell vehicles.
- Sustainable Practices: Commitment to eco-friendly solutions and reducing carbon footprints.
- Strong Partnerships: Collaborations with industry leaders to enhance product offerings and market reach.
- Market Potential: Positioned in a rapidly growing sector with significant future demand.
- Expert Leadership: Guided by a team with extensive experience in automotive and energy sectors.
Who Should Use Nikola Corporation (NKLA)?
- Investors: Make informed investment choices with insights from a leading electric vehicle manufacturer.
- Financial Analysts: Streamline your analysis with comprehensive data on Nikola's market performance.
- Consultants: Easily tailor presentations and reports to showcase Nikola's innovative solutions.
- Automotive Enthusiasts: Enhance your knowledge of cutting-edge technology in the electric vehicle sector.
- Educators and Students: Utilize Nikola's business model as a case study in sustainability and innovation.
What the Template Contains
- Pre-Filled DCF Model: Nikola Corporation’s (NKLA) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Nikola Corporation’s (NKLA) 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.