|
Clearwater Paper Corporation (CLW) DCF Valoración
US | Basic Materials | Paper, Lumber & Forest Products | 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
Clearwater Paper Corporation (CLW) Bundle
¡Simplifique la valoración de Clearwater Paper Corporation (CLW) con esta calculadora DCF personalizable! Con Real Clearwater Paper Corporation (CLW) financieras y entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Clearwater Paper Corporation (CLW) 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,761.5 | 1,868.6 | 1,772.6 | 2,080.1 | 2,082.8 | 2,075.1 | 2,067.5 | 2,059.9 | 2,052.3 | 2,044.7 |
| Revenue Growth, % | 0 | 6.08 | -5.14 | 17.35 | 0.1298 | -0.36847 | -0.36847 | -0.36847 | -0.36847 | -0.36847 |
| EBITDA | 153.6 | 258.2 | 106.4 | 219.7 | 275.3 | 217.1 | 216.3 | 215.5 | 214.7 | 214.0 |
| EBITDA, % | 8.72 | 13.82 | 6 | 10.56 | 13.22 | 10.46 | 10.46 | 10.46 | 10.46 | 10.46 |
| Depreciation | 116.6 | 113.5 | 105.1 | 103.3 | 98.6 | 117.5 | 117.1 | 116.7 | 116.3 | 115.8 |
| Depreciation, % | 6.62 | 6.07 | 5.93 | 4.97 | 4.73 | 5.66 | 5.66 | 5.66 | 5.66 | 5.66 |
| EBIT | 37.0 | 144.7 | 1.3 | 116.4 | 176.7 | 99.6 | 99.2 | 98.9 | 98.5 | 98.1 |
| EBIT, % | 2.1 | 7.74 | 0.07333854 | 5.6 | 8.48 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 |
| Total Cash | 20.0 | 35.9 | 25.2 | 53.7 | 42.0 | 37.7 | 37.5 | 37.4 | 37.3 | 37.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 159.4 | 160.6 | 167.4 | 188.8 | 184.5 | 186.9 | 186.2 | 185.5 | 184.8 | 184.1 |
| Account Receivables, % | 9.05 | 8.59 | 9.44 | 9.08 | 8.86 | 9 | 9 | 9 | 9 | 9 |
| Inventories | 281.4 | 263.3 | 277.7 | 324.0 | 319.8 | 318.2 | 317.0 | 315.8 | 314.7 | 313.5 |
| Inventories, % | 15.98 | 14.09 | 15.67 | 15.58 | 15.35 | 15.33 | 15.33 | 15.33 | 15.33 | 15.33 |
| Accounts Payable | 159.5 | 143.4 | 156.2 | 213.0 | 163.9 | 181.2 | 180.5 | 179.8 | 179.2 | 178.5 |
| Accounts Payable, % | 9.05 | 7.67 | 8.81 | 10.24 | 7.87 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 |
| Capital Expenditure | -140.1 | -39.6 | -38.4 | -33.5 | -73.7 | -72.2 | -71.9 | -71.6 | -71.4 | -71.1 |
| Capital Expenditure, % | -7.95 | -2.12 | -2.17 | -1.61 | -3.54 | -3.48 | -3.48 | -3.48 | -3.48 | -3.48 |
| Tax Rate, % | 25.31 | 25.31 | 25.31 | 25.31 | 25.31 | 25.31 | 25.31 | 25.31 | 25.31 | 25.31 |
| EBITAT | 26.2 | 113.6 | 1.0 | 73.2 | 132.0 | 72.8 | 72.5 | 72.3 | 72.0 | 71.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -278.6 | 188.3 | 59.3 | 132.1 | 116.3 | 134.7 | 118.9 | 118.5 | 118.1 | 117.6 |
| WACC, % | 5.46 | 5.71 | 5.7 | 5.2 | 5.58 | 5.53 | 5.53 | 5.53 | 5.53 | 5.53 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 520.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 120 | |||||||||
| Terminal Value | 3,399 | |||||||||
| Present Terminal Value | 2,597 | |||||||||
| Enterprise Value | 3,118 | |||||||||
| Net Debt | 437 | |||||||||
| Equity Value | 2,681 | |||||||||
| Diluted Shares Outstanding, MM | 17 | |||||||||
| Equity Value Per Share | 156.88 |
What You Will Get
- Real Clearwater Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Clearwater Paper Corporation (CLW).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Clearwater's fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Clearwater Paper Corporation (CLW).
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility in your financial analysis.
Key Features
- 🔍 Real-Life CLW Financials: Pre-filled historical and projected data for Clearwater Paper Corporation (CLW).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Clearwater Paper’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Clearwater Paper’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 ready-to-use Excel file containing Clearwater Paper Corporation’s (CLW) financial data.
- Customize: Modify forecasts, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop multiple projections and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Clearwater Paper Corporation (CLW)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Feedback: Observe immediate adjustments to Clearwater Paper’s valuation as you modify inputs.
- Pre-Configured Data: Comes with Clearwater Paper’s actual financial metrics for swift evaluations.
- Preferred by Experts: Utilized by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Accurately estimate Clearwater Paper Corporation’s (CLW) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to Clearwater Paper Corporation (CLW).
- Consultants: Quickly adapt the template for valuation reports for clients involving Clearwater Paper Corporation (CLW).
- Entrepreneurs: Gain insights into financial modeling practices utilized by leading companies like Clearwater Paper Corporation (CLW).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies applicable to Clearwater Paper Corporation (CLW).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Clearwater Paper Corporation (CLW).
- Real-World Data: Clearwater Paper’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for decision-making.