Knightscope, Inc. (KSCP) 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
Knightscope, Inc. (KSCP) Bundle
Explore Knightscope, Inc.'s (KSCP) financial potential with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine Knightscope, Inc.'s (KSCP) intrinsic value and shape your investment approach.
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 | 3.0 | 3.3 | 3.4 | 5.6 | 12.8 | 18.5 | 26.7 | 38.5 | 55.7 | 80.4 |
Revenue Growth, % | 0 | 10.22 | 2.17 | 65.28 | 127.26 | 44.42 | 44.42 | 44.42 | 44.42 | 44.42 |
EBITDA | -8.4 | -15.7 | -38.0 | -14.7 | -19.2 | -18.5 | -26.7 | -38.5 | -55.7 | -80.4 |
EBITDA, % | -277.32 | -471.53 | -1114.12 | -261.02 | -150.06 | -100 | -100 | -100 | -100 | -100 |
Depreciation | 1.5 | 1.4 | 1.6 | 1.7 | 2.4 | 6.8 | 9.8 | 14.1 | 20.4 | 29.5 |
Depreciation, % | 48.39 | 40.6 | 45.55 | 30.37 | 18.47 | 36.68 | 36.68 | 36.68 | 36.68 | 36.68 |
EBIT | -9.9 | -17.1 | -39.5 | -16.4 | -21.6 | -18.5 | -26.7 | -38.5 | -55.7 | -80.4 |
EBIT, % | -325.71 | -512.13 | -1159.67 | -291.39 | -168.53 | -100 | -100 | -100 | -100 | -100 |
Total Cash | .6 | 7.1 | 10.7 | 4.8 | 2.3 | 12.0 | 17.3 | 24.9 | 36.0 | 52.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .7 | .9 | 1.2 | 1.4 | 2.5 | 4.7 | 6.7 | 9.7 | 14.1 | 20.3 |
Account Receivables, % | 21.67 | 26.21 | 34.9 | 24.33 | 19.16 | 25.25 | 25.25 | 25.25 | 25.25 | 25.25 |
Inventories | .1 | .1 | .1 | 2.6 | 2.3 | 2.7 | 3.9 | 5.6 | 8.1 | 11.7 |
Inventories, % | 3.31 | 3 | 2.94 | 45.46 | 18.13 | 14.57 | 14.57 | 14.57 | 14.57 | 14.57 |
Accounts Payable | 1.0 | .2 | 1.5 | 2.5 | 1.9 | 5.2 | 7.6 | 10.9 | 15.8 | 22.8 |
Accounts Payable, % | 31.99 | 6.96 | 44.44 | 43.63 | 14.52 | 28.31 | 28.31 | 28.31 | 28.31 | 28.31 |
Capital Expenditure | .0 | -.6 | -.1 | -.1 | -5.1 | -2.4 | -3.5 | -5.0 | -7.2 | -10.4 |
Capital Expenditure, % | -0.55604 | -18.97 | -3.43 | -1.97 | -40.03 | -12.99 | -12.99 | -12.99 | -12.99 | -12.99 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -9.9 | -17.1 | -44.1 | -3.1 | -21.6 | -15.5 | -22.3 | -32.3 | -46.6 | -67.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -8.2 | -17.3 | -41.7 | -3.2 | -25.8 | -10.3 | -17.0 | -24.5 | -35.4 | -51.1 |
WACC, % | 10.58 | 10.58 | 10.58 | 10.08 | 10.58 | 10.48 | 10.48 | 10.48 | 10.48 | 10.48 |
PV UFCF | ||||||||||
SUM PV UFCF | -96.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -52 | |||||||||
Terminal Value | -615 | |||||||||
Present Terminal Value | -373 | |||||||||
Enterprise Value | -470 | |||||||||
Net Debt | 1 | |||||||||
Equity Value | -470 | |||||||||
Diluted Shares Outstanding, MM | 1 | |||||||||
Equity Value Per Share | -356.57 |
What You Will Get
- Real KSCP Financial Data: Pre-filled with Knightscope’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Knightscope’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life KSCP Financials: Pre-filled historical and projected data for Knightscope, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Knightscope’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Knightscope’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file for Knightscope, Inc. (KSCP).
- Step 2: Review Knightscope’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- Step 5: Analyze the outputs and utilize the results for your investment decisions.
Why Choose This Calculator for Knightscope, Inc. (KSCP)?
- Accuracy: Utilizes real Knightscope financials to ensure precise data.
- Flexibility: Tailored for users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexity of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Accurately assess Knightscope, Inc.'s (KSCP) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for financial reporting and analysis specific to Knightscope, Inc. (KSCP).
- Consultants: Efficiently customize the template for valuation reports tailored to Knightscope, Inc. (KSCP) clients.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by industry leaders like Knightscope, Inc. (KSCP).
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to Knightscope, Inc. (KSCP).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Knightscope, Inc. (KSCP).
- Real-World Data: Knightscope’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns to gain deeper insights into performance.
- Key Ratios: Integrated analysis for assessing profitability, efficiency, and leverage.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results specific to Knightscope, Inc. (KSCP).