Cinemark Holdings, Inc. (CNK) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Cinemark Holdings, Inc. (CNK) Bundle
Looking to assess the intrinsic value of Cinemark Holdings, Inc.? Our CNK DCF Calculator integrates real-world data with comprehensive customization features, enabling you to refine predictions and enhance your investment choices.
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,283.1 | 686.3 | 1,510.5 | 2,454.7 | 3,066.7 | 3,897.4 | 4,953.1 | 6,294.7 | 7,999.8 | 10,166.7 |
| Revenue Growth, % | 0 | -79.1 | 120.08 | 62.51 | 24.93 | 27.09 | 27.09 | 27.09 | 27.09 | 27.09 |
| EBITDA | 665.6 | -511.7 | -3.8 | 140.9 | 603.9 | -226.9 | -288.3 | -366.4 | -465.7 | -591.8 |
| EBITDA, % | 20.27 | -74.56 | -0.25098 | 5.74 | 19.69 | -5.82 | -5.82 | -5.82 | -5.82 | -5.82 |
| Depreciation | 261.2 | 262.1 | 261.9 | 227.4 | 209.5 | 620.3 | 788.4 | 1,001.9 | 1,273.3 | 1,618.2 |
| Depreciation, % | 7.95 | 38.19 | 17.34 | 9.26 | 6.83 | 15.92 | 15.92 | 15.92 | 15.92 | 15.92 |
| EBIT | 404.5 | -773.9 | -265.7 | -86.5 | 394.4 | -747.8 | -950.3 | -1,207.8 | -1,534.9 | -1,950.7 |
| EBIT, % | 12.32 | -112.76 | -17.59 | -3.52 | 12.86 | -19.19 | -19.19 | -19.19 | -19.19 | -19.19 |
| Total Cash | 488.3 | 655.3 | 707.3 | 674.5 | 849.1 | 1,655.3 | 2,103.6 | 2,673.4 | 3,397.6 | 4,317.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 87.8 | 190.4 | 115.5 | 114.7 | 137.1 | 368.0 | 467.6 | 594.3 | 755.3 | 959.9 |
| Account Receivables, % | 2.67 | 27.74 | 7.64 | 4.67 | 4.47 | 9.44 | 9.44 | 9.44 | 9.44 | 9.44 |
| Inventories | 21.7 | 12.6 | 15.5 | 23.7 | 23.3 | 40.9 | 51.9 | 66.0 | 83.9 | 106.6 |
| Inventories, % | 0.66053 | 1.83 | 1.02 | 0.96549 | 0.75977 | 1.05 | 1.05 | 1.05 | 1.05 | 1.05 |
| Accounts Payable | 91.6 | 70.6 | 76.0 | 72.2 | 53.3 | 177.7 | 225.8 | 287.0 | 364.7 | 463.5 |
| Accounts Payable, % | 2.79 | 10.29 | 5.03 | 2.94 | 1.74 | 4.56 | 4.56 | 4.56 | 4.56 | 4.56 |
| Capital Expenditure | -303.6 | -83.9 | -95.5 | -110.7 | -149.5 | -289.9 | -368.4 | -468.2 | -595.0 | -756.1 |
| Capital Expenditure, % | -9.25 | -12.23 | -6.33 | -4.51 | -4.87 | -7.44 | -7.44 | -7.44 | -7.44 | -7.44 |
| Tax Rate, % | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 |
| EBITAT | 282.8 | -515.7 | -255.5 | -87.5 | 335.3 | -624.7 | -794.0 | -1,009.0 | -1,282.3 | -1,629.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 222.4 | -452.0 | -11.7 | 17.9 | 354.4 | -418.3 | -436.6 | -554.8 | -705.1 | -896.1 |
| WACC, % | 10.37 | 10.3 | 10.92 | 11 | 10.69 | 10.66 | 10.66 | 10.66 | 10.66 | 10.66 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -2,154.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -914 | |||||||||
| Terminal Value | -10,556 | |||||||||
| Present Terminal Value | -6,362 | |||||||||
| Enterprise Value | -8,516 | |||||||||
| Net Debt | 2,704 | |||||||||
| Equity Value | -11,220 | |||||||||
| Diluted Shares Outstanding, MM | 152 | |||||||||
| Equity Value Per Share | -73.81 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to create various scenarios for Cinemark Holdings, Inc. (CNK).
- Real-World Data: Cinemark’s financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as ticket sales growth, operating margin, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and various financial metrics.
- High-Precision Results: Leverages Cinemark's actual financial data for accurate valuation insights.
- Effortless Scenario Testing: Easily evaluate different scenarios and analyze their impacts side by side.
- Efficiency Booster: Remove the hassle of creating intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Cinemark data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Cinemark’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Cinemark Holdings, Inc. (CNK)?
- Accurate Data: Authentic Cinemark financials provide dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the entertainment sector.
- User-Friendly: Easy-to-navigate layout and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Accurately estimate Cinemark’s fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis.
- Consultants: Quickly adapt the template for valuation reports for clients.
- Entrepreneurs: Gain insights into financial modeling used by leading entertainment companies.
- Educators: Use it as a teaching tool to demonstrate valuation methodologies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Cinemark Holdings, Inc. (CNK) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models that illustrate intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate thorough analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios specific to Cinemark Holdings, Inc. (CNK).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy analysis of results.