|
Outfront Media Inc. (Out) DCF Valoración
US | Real Estate | REIT - Specialty | NYSE
|
- ✓ 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
Outfront Media Inc. (OUT) Bundle
¡Simplifique la valoración de Outfront Media Inc. (Out) con esta calculadora DCF personalizable! Con Real Outfront Media Inc. (Out) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Outfront Media Inc. (Out) en minutos.
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 | 1,782.2 | 1,236.3 | 1,463.9 | 1,772.1 | 1,820.6 | 1,873.3 | 1,927.4 | 1,983.2 | 2,040.5 | 2,099.6 |
| Revenue Growth, % | 0 | -30.63 | 18.41 | 21.05 | 2.74 | 2.89 | 2.89 | 2.89 | 2.89 | 2.89 |
| EBITDA | 427.0 | 218.4 | 307.4 | 438.2 | -105.7 | 305.5 | 314.3 | 323.4 | 332.8 | 342.4 |
| EBITDA, % | 23.96 | 17.67 | 21 | 24.73 | -5.81 | 16.31 | 16.31 | 16.31 | 16.31 | 16.31 |
| Depreciation | 1,476.6 | 1,171.7 | 1,297.6 | 1,484.2 | 152.7 | 1,342.8 | 1,381.6 | 1,421.6 | 1,462.7 | 1,505.0 |
| Depreciation, % | 82.85 | 94.77 | 88.64 | 83.75 | 8.39 | 71.68 | 71.68 | 71.68 | 71.68 | 71.68 |
| EBIT | -1,049.6 | -953.3 | -990.2 | -1,046.0 | -258.4 | -1,037.3 | -1,067.3 | -1,098.1 | -1,129.9 | -1,162.6 |
| EBIT, % | -58.89 | -77.11 | -67.64 | -59.03 | -14.19 | -55.37 | -55.37 | -55.37 | -55.37 | -55.37 |
| Total Cash | 59.1 | 710.4 | 424.8 | 40.4 | 36.0 | 352.4 | 362.6 | 373.1 | 383.8 | 394.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 290.0 | 209.2 | 310.5 | 315.5 | 287.6 | 329.7 | 339.2 | 349.1 | 359.2 | 369.5 |
| Account Receivables, % | 16.27 | 16.92 | 21.21 | 17.8 | 15.8 | 17.6 | 17.6 | 17.6 | 17.6 | 17.6 |
| Inventories | 81.6 | 21.4 | 30.3 | 28.9 | .0 | 37.5 | 38.6 | 39.7 | 40.9 | 42.0 |
| Inventories, % | 4.58 | 1.73 | 2.07 | 1.63 | 0 | 2 | 2 | 2 | 2 | 2 |
| Accounts Payable | 67.9 | 64.9 | 64.9 | 65.4 | 55.5 | 75.8 | 78.0 | 80.2 | 82.6 | 85.0 |
| Accounts Payable, % | 3.81 | 5.25 | 4.43 | 3.69 | 3.05 | 4.05 | 4.05 | 4.05 | 4.05 | 4.05 |
| Capital Expenditure | -113.9 | -77.1 | -90.3 | -96.6 | -86.8 | -108.7 | -111.8 | -115.1 | -118.4 | -121.8 |
| Capital Expenditure, % | -6.39 | -6.24 | -6.17 | -5.45 | -4.77 | -5.8 | -5.8 | -5.8 | -5.8 | -5.8 |
| Tax Rate, % | -1.37 | -1.37 | -1.37 | -1.37 | -1.37 | -1.37 | -1.37 | -1.37 | -1.37 | -1.37 |
| EBITAT | -1,008.6 | -971.2 | -1,115.5 | -993.6 | -261.9 | -1,018.8 | -1,048.2 | -1,078.6 | -1,109.7 | -1,141.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 50.4 | 261.4 | -18.4 | 390.9 | -149.1 | 156.0 | 213.1 | 219.3 | 225.6 | 232.1 |
| WACC, % | 8.06 | 8.16 | 8.16 | 8.03 | 8.16 | 8.11 | 8.11 | 8.11 | 8.11 | 8.11 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 822.4 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 239 | |||||||||
| Terminal Value | 4,676 | |||||||||
| Present Terminal Value | 3,166 | |||||||||
| Enterprise Value | 3,988 | |||||||||
| Net Debt | 4,304 | |||||||||
| Equity Value | -316 | |||||||||
| Diluted Shares Outstanding, MM | 165 | |||||||||
| Equity Value Per Share | -1.92 |
What You Will Get
- Pre-Filled Financial Model: Outfront Media Inc.'s (OUT) actual data facilitates accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Instant Calculations: Automatic updates provide immediate results as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.
Key Features
- Real-Life OUT Data: Pre-filled with Outfront Media's historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Generate multiple forecasting scenarios to evaluate various valuation outcomes.
- User-Friendly Design: Intuitive, structured, and suitable for both professionals and beginners.
How It Works
- Download the Template: Get instant access to the Excel-based OUT DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates Outfront Media's intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator for Outfront Media Inc. (OUT)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and industry consultants.
- Accurate Data: Outfront Media’s historical and projected financials are preloaded for precision.
- Forecast Simulation: Effortlessly test various scenarios and assumptions.
- Comprehensive Outputs: Automatically generates intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Marketing Professionals: Understand advertising strategies and analyze their effectiveness using real data from Outfront Media Inc. (OUT).
- Students: Integrate industry case studies into projects and academic research.
- Investors: Evaluate your investment strategies and assess valuation metrics for Outfront Media Inc. (OUT).
- Analysts: Enhance your analysis with a customizable advertising revenue model tailored for Outfront Media Inc. (OUT).
- Entrepreneurs: Discover how large-scale media companies like Outfront Media Inc. (OUT) approach market analysis.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Outfront Media Inc. (OUT) 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 Outfront Media Inc. (OUT).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.