Workhorse Group Inc. (WKHS) 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
Workhorse Group Inc. (WKHS) Bundle
Looking to determine the intrinsic value of Workhorse Group Inc.? Our WKHS DCF Calculator integrates real-world data with extensive customization features, enabling you to adjust forecasts and enhance your investment choices.
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 | .4 | 1.4 | -.9 | 5.0 | 13.1 | 13.1 | 13.1 | 13.1 | 13.1 | 13.1 |
| Revenue Growth, % | 0 | 269.8 | -161.18 | -689.62 | 160.69 | 0 | 0 | 0 | 0 | 0 |
| EBITDA | -30.1 | -40.2 | -414.6 | -113.9 | -111.2 | -7.9 | -7.9 | -7.9 | -7.9 | -7.9 |
| EBITDA, % | -7982.41 | -2884.81 | 48660.83 | -2267.61 | -849.46 | -60 | -60 | -60 | -60 | -60 |
| Depreciation | .4 | .8 | 1.9 | 3.0 | 4.1 | 3.9 | 3.9 | 3.9 | 3.9 | 3.9 |
| Depreciation, % | 103.14 | 58.14 | -224.01 | 60.47 | 31.03 | 29.93 | 29.93 | 29.93 | 29.93 | 29.93 |
| EBIT | -30.4 | -41.0 | -416.5 | -116.9 | -115.3 | -7.9 | -7.9 | -7.9 | -7.9 | -7.9 |
| EBIT, % | -8085.55 | -2942.95 | 48884.85 | -2328.09 | -880.49 | -60 | -60 | -60 | -60 | -60 |
| Total Cash | 23.9 | 46.8 | 201.6 | 99.3 | 25.8 | 7.9 | 7.9 | 7.9 | 7.9 | 7.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | 1.0 | .1 | 17.1 | 4.5 | 5.3 | 5.3 | 5.3 | 5.3 | 5.3 |
| Account Receivables, % | 10.89 | 74.5 | -17.58 | 340.02 | 34.14 | 40.39 | 40.39 | 40.39 | 40.39 | 40.39 |
| Inventories | 1.8 | 15.5 | 10.1 | 8.9 | 45.4 | 7.9 | 7.9 | 7.9 | 7.9 | 7.9 |
| Inventories, % | 477.52 | 1110.72 | -1181.72 | 176.19 | 346.77 | 60 | 60 | 60 | 60 | 60 |
| Accounts Payable | 1.7 | 4.8 | 7.8 | 10.2 | 12.5 | 7.7 | 7.7 | 7.7 | 7.7 | 7.7 |
| Accounts Payable, % | 445.87 | 344.04 | -921.4 | 203.77 | 95.12 | 59.02 | 59.02 | 59.02 | 59.02 | 59.02 |
| Capital Expenditure | -2.0 | -5.7 | -5.3 | -17.5 | -18.7 | -10.5 | -10.5 | -10.5 | -10.5 | -10.5 |
| Capital Expenditure, % | -532.58 | -411.35 | 623.79 | -348.33 | -142.71 | -80 | -80 | -80 | -80 | -80 |
| Tax Rate, % | 0.08911091 | 0.08911091 | 0.08911091 | 0.08911091 | 0.08911091 | 0.08911091 | 0.08911091 | 0.08911091 | 0.08911091 | 0.08911091 |
| EBITAT | -54.0 | -31.2 | -395.0 | -105.2 | -115.2 | -7.2 | -7.2 | -7.2 | -7.2 | -7.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -55.8 | -47.7 | -389.0 | -133.0 | -151.5 | 18.2 | -13.8 | -13.8 | -13.8 | -13.8 |
| WACC, % | 27.1 | 21.51 | 25.89 | 24.74 | 27.08 | 25.26 | 25.26 | 25.26 | 25.26 | 25.26 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -11.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -14 | |||||||||
| Terminal Value | -61 | |||||||||
| Present Terminal Value | -20 | |||||||||
| Enterprise Value | -31 | |||||||||
| Net Debt | 3 | |||||||||
| Equity Value | -34 | |||||||||
| Diluted Shares Outstanding, MM | 10 | |||||||||
| Equity Value Per Share | -3.29 |
What You Will Receive
- Pre-Filled Financial Model: Workhorse Group Inc.’s (WKHS) real data allows for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate results as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Workhorse Group Inc. (WKHS).
- WACC Calculator: Includes a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to WKHS.
- Customizable Forecast Assumptions: Alter growth rates, capital expenditures, and discount rates to fit Workhorse's financial projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Workhorse Group Inc. (WKHS).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Workhorse Group Inc. (WKHS) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Workhorse Group Inc.'s (WKHS) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Workhorse Group Inc. (WKHS)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and consultants in the automotive sector.
- Comprehensive Financial Data: Workhorse Group's historical and projected financials preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions to explore potential outcomes.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Clear, step-by-step guidance to help you navigate the calculation process.
Who Should Use This Product?
- Investors: Accurately assess Workhorse Group Inc.'s (WKHS) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Effortlessly modify the template for client valuation reports.
- Entrepreneurs: Gain valuable insights into financial modeling practices employed by leading companies.
- Educators: Employ it as an educational resource to illustrate valuation methodologies.
What the Template Contains
- Pre-Filled Data: Includes Workhorse Group Inc.'s (WKHS) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Workhorse Group Inc.'s (WKHS) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.