CuriosityStream Inc. (CURI) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
CuriosityStream Inc. (CURI) Bundle
Harness the power of CuriosityStream Inc. (CURI) valuation analysis with our sophisticated DCF Calculator! This Excel template comes preloaded with actual (CURI) data, enabling you to adjust forecasts and assumptions to calculate CuriosityStream Inc.'s intrinsic value with accuracy.
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 | 18.0 | 39.6 | 71.3 | 78.0 | 56.9 | 80.0 | 112.4 | 158.0 | 222.1 | 312.2 |
Revenue Growth, % | 0 | 119.8 | 79.86 | 9.52 | -27.11 | 40.57 | 40.57 | 40.57 | 40.57 | 40.57 |
EBITDA | -42.0 | -29.9 | -24.0 | -10.6 | -2.1 | -36.2 | -50.9 | -71.5 | -100.5 | -141.3 |
EBITDA, % | -233.24 | -75.39 | -33.66 | -13.53 | -3.69 | -45.26 | -45.26 | -45.26 | -45.26 | -45.26 |
Depreciation | .3 | 10.1 | 28.5 | 40.0 | 23.4 | 25.5 | 35.9 | 50.5 | 70.9 | 99.7 |
Depreciation, % | 1.84 | 25.46 | 39.98 | 51.24 | 41.13 | 31.93 | 31.93 | 31.93 | 31.93 | 31.93 |
EBIT | -42.4 | -40.0 | -52.5 | -50.6 | -25.5 | -61.3 | -86.2 | -121.1 | -170.2 | -239.3 |
EBIT, % | -235.08 | -100.85 | -73.64 | -64.77 | -44.83 | -76.65 | -76.65 | -76.65 | -76.65 | -76.65 |
Total Cash | 44.3 | 33.4 | 81.0 | 55.0 | 37.7 | 67.3 | 94.6 | 133.0 | 187.0 | 262.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1.8 | 7.2 | 23.5 | 10.9 | 4.8 | 13.3 | 18.7 | 26.4 | 37.0 | 52.1 |
Account Receivables, % | 9.86 | 18.23 | 32.97 | 13.97 | 8.37 | 16.68 | 16.68 | 16.68 | 16.68 | 16.68 |
Inventories | .0 | 6.2 | 2.3 | .5 | .0 | 3.1 | 4.4 | 6.2 | 8.7 | 12.2 |
Inventories, % | 0 | 15.6 | 3.27 | 0.64067 | 0 | 3.9 | 3.9 | 3.9 | 3.9 | 3.9 |
Accounts Payable | 5.2 | 3.6 | 3.4 | 6.1 | 4.8 | 9.4 | 13.3 | 18.7 | 26.2 | 36.9 |
Accounts Payable, % | 29.1 | 9.03 | 4.81 | 7.77 | 8.38 | 11.82 | 11.82 | 11.82 | 11.82 | 11.82 |
Capital Expenditure | -.8 | -.4 | -.4 | -.1 | .0 | -.9 | -1.3 | -1.8 | -2.6 | -3.7 |
Capital Expenditure, % | -4.25 | -0.92628 | -0.49256 | -0.16657 | -0.00878905 | -1.17 | -1.17 | -1.17 | -1.17 | -1.17 |
Tax Rate, % | -1.05 | -1.05 | -1.05 | -1.05 | -1.05 | -1.05 | -1.05 | -1.05 | -1.05 | -1.05 |
EBITAT | -42.5 | -40.1 | -53.0 | -50.9 | -25.8 | -61.3 | -86.2 | -121.1 | -170.2 | -239.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -39.5 | -43.7 | -37.4 | 6.0 | 3.0 | -43.7 | -54.4 | -76.5 | -107.5 | -151.2 |
WACC, % | 9.66 | 9.66 | 9.66 | 9.66 | 9.66 | 9.66 | 9.66 | 9.66 | 9.66 | 9.66 |
PV UFCF | ||||||||||
SUM PV UFCF | -312.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -154 | |||||||||
Terminal Value | -2,012 | |||||||||
Present Terminal Value | -1,269 | |||||||||
Enterprise Value | -1,581 | |||||||||
Net Debt | -33 | |||||||||
Equity Value | -1,548 | |||||||||
Diluted Shares Outstanding, MM | 53 | |||||||||
Equity Value Per Share | -29.18 |
What You Will Get
- Real CURI 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 calculated in real-time.
- Scenario Analysis: Explore various scenarios to assess CuriosityStream’s future performance.
- User-Friendly Design: Tailored for professionals while remaining easy for newcomers to navigate.
Key Features
- Customizable Subscription Metrics: Adjust essential parameters like user growth, churn rate, and average revenue per user.
- Instant Content Valuation: Provides real-time assessments of content library value, subscriber lifetime value, and other financial metrics.
- Industry-Leading Precision: Utilizes CuriosityStream's actual financial data for accurate valuation results.
- Effortless Scenario Planning: Explore various business models and forecast outcomes with ease.
- Efficiency-Boosting Solution: Streamline the valuation process without the hassle of creating complex financial models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review CuriosityStream Inc.'s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as subscriber growth, content costs, and marketing expenses (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Evaluate the results and leverage the insights for investment decisions.
Why Choose This Calculator for CuriosityStream Inc. (CURI)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for CuriosityStream.
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes CuriosityStream’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable starting points for analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focusing on media and streaming sectors.
Who Should Use CuriosityStream Inc. (CURI)?
- Documentary Lovers: Explore a vast library of high-quality documentaries and series.
- Educators: Enhance classroom learning with engaging educational content.
- Parents: Provide children with safe and enriching viewing options.
- Curious Minds: Satisfy your thirst for knowledge across a range of topics.
- Content Creators: Use the platform for inspiration and research in your projects.
What the Template Contains
- Pre-Filled DCF Model: CuriosityStream Inc.’s (CURI) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to CuriosityStream Inc. (CURI).
- Financial Ratios: Evaluate CuriosityStream Inc.’s (CURI) profitability, leverage, and efficiency metrics.
- Editable Inputs: Adjust assumptions such as growth, margins, and CAPEX to align with your scenarios.
- Financial Statements: Annual and quarterly reports for CuriosityStream Inc. (CURI) to support in-depth analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results for CuriosityStream Inc. (CURI).