|
36Kr Holdings Inc. (KRKR) DCF Valuation
CN | Communication Services | Internet Content & Information | NASDAQ
|
- ✓ 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
36Kr Holdings Inc. (KRKR) Bundle
Explore the financial future of 36Kr Holdings Inc. (KRKR) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of 36Kr Holdings Inc. (KRKR) and refine your investment approach.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2018 |
AY2 2019 |
AY3 2020 |
AY4 2021 |
AY5 2022 |
FY1 2023 |
FY2 2024 |
FY3 2025 |
FY4 2026 |
FY5 2027 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 89.8 | 53.0 | 43.4 | 44.2 | 46.6 | 40.6 | 35.3 | 30.7 | 26.8 | 23.3 |
| Revenue Growth, % | 0 | -41.01 | -18.1 | 1.81 | 5.48 | -12.95 | -12.95 | -12.95 | -12.95 | -12.95 |
| EBITDA | -2.5 | -34.6 | -10.0 | -3.5 | -10.9 | -9.9 | -8.6 | -7.5 | -6.5 | -5.7 |
| EBITDA, % | -2.77 | -65.24 | -22.94 | -7.93 | -23.47 | -24.47 | -24.47 | -24.47 | -24.47 | -24.47 |
| Depreciation | .6 | .8 | 2.5 | 2.1 | 1.8 | 1.3 | 1.2 | 1.0 | .9 | .8 |
| Depreciation, % | 0.64536 | 1.45 | 5.73 | 4.81 | 3.89 | 3.31 | 3.31 | 3.31 | 3.31 | 3.31 |
| EBIT | -3.1 | -35.3 | -12.4 | -5.6 | -12.8 | -11.3 | -9.8 | -8.5 | -7.4 | -6.5 |
| EBIT, % | -3.41 | -66.69 | -28.66 | -12.74 | -27.36 | -27.77 | -27.77 | -27.77 | -27.77 | -27.77 |
| Total Cash | 36.1 | 28.7 | 29.6 | 25.3 | 16.0 | 20.6 | 18.0 | 15.6 | 13.6 | 11.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 74.4 | 41.8 | 25.2 | 27.2 | 19.1 | 26.1 | 22.8 | 19.8 | 17.2 | 15.0 |
| Account Receivables, % | 82.85 | 78.84 | 58.02 | 61.52 | 40.98 | 64.44 | 64.44 | 64.44 | 64.44 | 64.44 |
| Inventories | 5.6 | 2.1 | 5.4 | .0 | .0 | 1.8 | 1.6 | 1.4 | 1.2 | 1.1 |
| Inventories, % | 6.21 | 3.98 | 12.47 | 0.03100804 | 0.02028308 | 4.54 | 4.54 | 4.54 | 4.54 | 4.54 |
| Accounts Payable | 19.1 | 8.9 | 7.7 | 7.3 | 8.3 | 7.3 | 6.4 | 5.5 | 4.8 | 4.2 |
| Accounts Payable, % | 21.25 | 16.71 | 17.76 | 16.58 | 17.75 | 18.01 | 18.01 | 18.01 | 18.01 | 18.01 |
| Capital Expenditure | -.7 | -.3 | -.3 | -.2 | -.7 | -.3 | -.3 | -.3 | -.2 | -.2 |
| Capital Expenditure, % | -0.72849 | -0.60761 | -0.68818 | -0.51349 | -1.59 | -0.82491 | -0.82491 | -0.82491 | -0.82491 | -0.82491 |
| Tax Rate, % | -0.77389 | -0.77389 | -0.77389 | -0.77389 | -0.77389 | -0.77389 | -0.77389 | -0.77389 | -0.77389 | -0.77389 |
| EBITAT | -13.2 | -35.8 | -12.5 | -5.4 | -12.9 | -11.2 | -9.7 | -8.5 | -7.4 | -6.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -74.2 | -9.5 | 1.9 | -.5 | -2.7 | -20.0 | -6.2 | -5.4 | -4.7 | -4.1 |
| WACC, % | 7.33 | 7.33 | 7.33 | 7.32 | 7.33 | 7.33 | 7.33 | 7.33 | 7.33 | 7.33 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -34.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -4 | |||||||||
| Terminal Value | -78 | |||||||||
| Present Terminal Value | -55 | |||||||||
| Enterprise Value | -89 | |||||||||
| Net Debt | 1 | |||||||||
| Equity Value | -90 | |||||||||
| Diluted Shares Outstanding, MM | 42 | |||||||||
| Equity Value Per Share | -2.16 |
What You Will Get
- Real KRKR Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess 36Kr Holdings Inc.'s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Customizable Financial Metrics: Adjust essential inputs such as revenue growth rates, EBITDA margins, and investment expenditures.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value (NPV), and additional financial outputs.
- High-Precision Accuracy: Leverages 36Kr Holdings Inc.'s (KRKR) actual financial data for dependable valuation results.
- Simplified Scenario Analysis: Easily evaluate various assumptions and analyze their impacts on outcomes.
- Efficiency Booster: Remove the complexity of creating intricate valuation models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based KRKR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates 36Kr Holdings Inc.'s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation variations.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for 36Kr Holdings Inc. (KRKR)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses for comprehensive evaluations.
- Flexible Inputs: Modify yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically determines 36Kr Holdings Inc.’s intrinsic value and Net Present Value.
- Integrated Data: Features historical and projected data for reliable analysis foundations.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focused on KRKR.
Who Should Use This Product?
- Investors: Evaluate 36Kr Holdings Inc.'s (KRKR) market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess future financial forecasts.
- Startup Founders: Understand the valuation strategies employed by established companies like 36Kr Holdings Inc. (KRKR).
- Consultants: Provide comprehensive valuation analyses and reports for clients in need.
- Students and Educators: Utilize current data to enhance learning and teaching of valuation practices.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled 36Kr Holdings Inc. (KRKR) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for 36Kr Holdings Inc. (KRKR).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.