Creative Media & Community Trust Corporation (CMCT) 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
Creative Media & Community Trust Corporation (CMCT) Bundle
Simplify Creative Media & Community Trust Corporation (CMCT) valuation with this customizable DCF Calculator! Featuring real Creative Media & Community Trust Corporation (CMCT) financials and adjustable forecast inputs, you can test scenarios and uncover Creative Media & Community Trust Corporation (CMCT) fair value in minutes.
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 | 140.0 | 77.2 | 90.9 | 101.9 | 119.3 | 119.9 | 120.5 | 121.1 | 121.7 | 122.3 |
| Revenue Growth, % | 0 | -44.85 | 17.77 | 12.08 | 17.03 | 0.50593 | 0.50593 | 0.50593 | 0.50593 | 0.50593 |
| EBITDA | 52.4 | 17.4 | 30.6 | 37.3 | 36.7 | 38.6 | 38.8 | 39.0 | 39.2 | 39.4 |
| EBITDA, % | 37.43 | 22.49 | 33.67 | 36.55 | 30.75 | 32.18 | 32.18 | 32.18 | 32.18 | 32.18 |
| Depreciation | 112.8 | 79.9 | 78.3 | 85.4 | 52.7 | 94.6 | 95.1 | 95.6 | 96.1 | 96.5 |
| Depreciation, % | 80.61 | 103.47 | 86.14 | 83.79 | 44.16 | 78.94 | 78.94 | 78.94 | 78.94 | 78.94 |
| EBIT | -60.4 | -62.5 | -47.7 | -48.1 | -16.0 | -56.9 | -57.2 | -57.5 | -57.7 | -58.0 |
| EBIT, % | -43.18 | -80.98 | -52.47 | -47.24 | -13.41 | -47.45 | -47.45 | -47.45 | -47.45 | -47.45 |
| Total Cash | 23.8 | 33.6 | 22.3 | 46.2 | 19.3 | 35.1 | 35.3 | 35.5 | 35.7 | 35.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 23.5 | 22.2 | 24.3 | 24.7 | 20.1 | 27.2 | 27.3 | 27.5 | 27.6 | 27.7 |
| Account Receivables, % | 16.79 | 28.76 | 26.69 | 24.27 | 16.86 | 22.67 | 22.67 | 22.67 | 22.67 | 22.67 |
| Inventories | 51.6 | 55.4 | 69.3 | 93.5 | .0 | 66.3 | 66.6 | 67.0 | 67.3 | 67.6 |
| Inventories, % | 36.87 | 71.75 | 76.17 | 91.75 | 0 | 55.31 | 55.31 | 55.31 | 55.31 | 55.31 |
| Accounts Payable | 24.3 | 20.3 | 26.8 | 107.2 | 26.4 | 46.8 | 47.0 | 47.3 | 47.5 | 47.8 |
| Accounts Payable, % | 17.36 | 26.33 | 29.42 | 105.21 | 22.16 | 39.05 | 39.05 | 39.05 | 39.05 | 39.05 |
| Capital Expenditure | -24.6 | -14.7 | -4.0 | -8.8 | -13.3 | -14.6 | -14.7 | -14.8 | -14.8 | -14.9 |
| Capital Expenditure, % | -17.57 | -19.08 | -4.45 | -8.65 | -11.17 | -12.19 | -12.19 | -12.19 | -12.19 | -12.19 |
| Tax Rate, % | 3.47 | 3.47 | 3.47 | 3.47 | 3.47 | 3.47 | 3.47 | 3.47 | 3.47 | 3.47 |
| EBITAT | -60.3 | -59.7 | 19.0 | -40.3 | -15.4 | -42.7 | -42.9 | -43.1 | -43.4 | -43.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -22.9 | -1.0 | 83.7 | 92.1 | 41.2 | -15.7 | 37.3 | 37.5 | 37.6 | 37.8 |
| WACC, % | 7.43 | 7.1 | 0.05956896 | 6.23 | 7.18 | 5.6 | 5.6 | 5.6 | 5.6 | 5.6 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 109.5 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 39 | |||||||||
| Terminal Value | 1,864 | |||||||||
| Present Terminal Value | 1,419 | |||||||||
| Enterprise Value | 1,529 | |||||||||
| Net Debt | 452 | |||||||||
| Equity Value | 1,076 | |||||||||
| Diluted Shares Outstanding, MM | 23 | |||||||||
| Equity Value Per Share | 47.37 |
What You Will Get
- Real CMCT Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Creative Media & Community Trust Corporation (CMCT).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to suit your analysis.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on CMCT’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to Creative Media & Community Trust Corporation (CMCT).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility in your financial assessments.
Key Features
- 🔍 Real-Life CMCT Financials: Pre-filled historical and projected data for Creative Media & Community Trust Corporation (CMCT).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate CMCT’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize CMCT’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-built Excel file containing Creative Media & Community Trust Corporation’s (CMCT) financial information.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC as per your analysis needs.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
- Test Scenarios: Develop various projections and instantly compare different outcomes.
- Make Decisions: Utilize the valuation insights to inform your investment strategy.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by media analysts, investment managers, and community developers.
- Up-to-Date Information: CMCT’s (CMCT) historical and projected financials integrated for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance simplifies the entire process.
Who Should Use This Product?
- Real Estate Investors: Gain insights into investment opportunities in the media and community sectors with CMCT's data.
- Market Analysts: Enhance your analysis with comprehensive reports and metrics related to CMCT's performance.
- Advisors: Provide clients with informed recommendations based on CMCT's market positioning and growth potential.
- Community Leaders: Understand the financial health and impact of CMCT to better advocate for local initiatives.
- Students of Finance: Explore practical applications of real estate investment strategies through CMCT's case studies.
What the Template Contains
- Pre-Filled Data: Includes Creative Media & Community Trust Corporation’s (CMCT) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for (CMCT).
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs relevant to (CMCT).
- Key Financial Ratios: Analyze (CMCT)’s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily edit revenue growth, margins, and tax rates specific to (CMCT).
- Clear Dashboard: Visual representations through charts and tables summarizing key valuation results for (CMCT).