Worksport Ltd. (WKSP) 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
Worksport Ltd. (WKSP) Bundle
As an investor or analyst, the Worksport Ltd. (WKSP) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from Worksport Ltd., you can adjust forecasts and observe the results in real-time.
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 | 1.9 | .3 | .3 | .1 | 1.5 | 1.3 | 1.1 | 1.0 | .8 | .7 |
| Revenue Growth, % | 0 | -82.03 | -12.25 | -61.65 | 1212.97 | -13.98 | -13.98 | -13.98 | -13.98 | -13.98 |
| EBITDA | -.3 | -.8 | -7.4 | -11.6 | -13.2 | -1.1 | -.9 | -.8 | -.7 | -.6 |
| EBITDA, % | -14.31 | -223.73 | -2433.06 | -9921.83 | -863.15 | -82.86 | -82.86 | -82.86 | -82.86 | -82.86 |
| Depreciation | .0 | .0 | .2 | .5 | 1.1 | .7 | .6 | .5 | .4 | .4 |
| Depreciation, % | 0.59375 | 7.79 | 69.71 | 417.66 | 72.55 | 50.13 | 50.13 | 50.13 | 50.13 | 50.13 |
| EBIT | -.3 | -.8 | -7.6 | -12.0 | -14.3 | -1.1 | -.9 | -.8 | -.7 | -.6 |
| EBIT, % | -14.9 | -231.51 | -2502.77 | -10339.49 | -935.7 | -82.98 | -82.98 | -82.98 | -82.98 | -82.98 |
| Total Cash | .0 | 1.1 | 28.6 | 14.2 | 3.4 | 1.1 | .9 | .8 | .7 | .6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .1 | .3 | .2 | .3 | .6 | .8 | .7 | .6 | .5 | .4 |
| Account Receivables, % | 3.52 | 83.96 | 81.45 | 283.8 | 41.12 | 62.01 | 62.01 | 62.01 | 62.01 | 62.01 |
| Inventories | .1 | .0 | .5 | 1.3 | 3.6 | .8 | .7 | .6 | .5 | .5 |
| Inventories, % | 5.87 | 11.79 | 165.19 | 1155.66 | 237.41 | 63.53 | 63.53 | 63.53 | 63.53 | 63.53 |
| Accounts Payable | 1.0 | 1.0 | 1.1 | 2.0 | 1.5 | 1.2 | 1.0 | .9 | .7 | .6 |
| Accounts Payable, % | 50.32 | 280.71 | 376.8 | 1741 | 94.87 | 89.04 | 89.04 | 89.04 | 89.04 | 89.04 |
| Capital Expenditure | -.1 | .0 | -1.1 | -11.2 | -3.7 | -.8 | -.7 | -.6 | -.5 | -.4 |
| Capital Expenditure, % | -5.11 | -2.3 | -372.59 | -9571.32 | -241.24 | -61.48 | -61.48 | -61.48 | -61.48 | -61.48 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -.3 | -1.1 | -7.9 | -11.7 | -14.3 | -1.1 | -.9 | -.8 | -.7 | -.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | .4 | -1.2 | -9.1 | -22.5 | -20.1 | 1.1 | -1.0 | -.9 | -.7 | -.6 |
| WACC, % | 8.14 | 8.14 | 8.14 | 8.07 | 8.14 | 8.13 | 8.13 | 8.13 | 8.13 | 8.13 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1 | |||||||||
| Terminal Value | -11 | |||||||||
| Present Terminal Value | -7 | |||||||||
| Enterprise Value | -9 | |||||||||
| Net Debt | 4 | |||||||||
| Equity Value | -12 | |||||||||
| Diluted Shares Outstanding, MM | 18 | |||||||||
| Equity Value Per Share | -0.69 |
What You Will Get
- Comprehensive WKSP Financial Data: Pre-loaded with Worksport Ltd.'s historical and projected data for thorough analysis.
- Fully Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch Worksport's intrinsic value update in real-time as you make changes.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- User-Friendly Interface: Intuitive layout and clear guidance suitable for all skill levels.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation frameworks tailored for Worksport Ltd. (WKSP).
- WACC Calculator: Features a pre-constructed Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Easily adjust growth projections, capital investments, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Worksport Ltd. (WKSP).
- Interactive Dashboard and Charts: Visual representations present essential valuation metrics for straightforward analysis.
How It Works
- Download: Get the comprehensive Excel file featuring Worksport Ltd.’s (WKSP) financial data.
- Customize: Modify projections, including sales growth, EBITDA %, and discount rates.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and analyze results immediately.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for Worksport Ltd. (WKSP)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for Worksport Ltd.
- Flexible Inputs: Modify yellow-highlighted cells to explore different scenarios specific to WKSP.
- In-Depth Analysis: Automatically computes Worksport Ltd.'s intrinsic value and Net Present Value.
- Preloaded Information: Access historical and projected data for reliable baseline assessments.
- High-Quality Standards: Perfect for financial analysts, investors, and business consultants focusing on WKSP.
Who Should Use This Product?
- Investors: Evaluate Worksport Ltd.'s (WKSP) market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for Worksport Ltd. (WKSP).
- Startup Founders: Gain insights into how innovative companies like Worksport Ltd. (WKSP) are appraised.
- Consultants: Provide comprehensive valuation assessments for clients interested in Worksport Ltd. (WKSP).
- Students and Educators: Utilize real-time data from Worksport Ltd. (WKSP) to enhance learning and teaching of valuation principles.
What the Template Contains
- Historical Data: Includes Worksport Ltd.'s (WKSP) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Worksport Ltd.'s (WKSP) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Worksport Ltd.'s (WKSP) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.