Cooper-Standard Holdings Inc. (CPS) 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
Cooper-Standard Holdings Inc. (CPS) Bundle
Explore the financial future of Cooper-Standard Holdings Inc. (CPS) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and costs to calculate the intrinsic value of Cooper-Standard Holdings Inc. (CPS) and enhance your investment strategy.
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,108.4 | 2,375.4 | 2,330.2 | 2,525.4 | 2,815.9 | 2,776.4 | 2,737.5 | 2,699.2 | 2,661.3 | 2,624.0 |
| Revenue Growth, % | 0 | -23.58 | -1.9 | 8.38 | 11.5 | -1.4 | -1.4 | -1.4 | -1.4 | -1.4 |
| EBITDA | 191.8 | -116.8 | -77.9 | .5 | 45.6 | -2.5 | -2.5 | -2.4 | -2.4 | -2.4 |
| EBITDA, % | 6.17 | -4.92 | -3.34 | 0.01940294 | 1.62 | -0.0904173 | -0.0904173 | -0.0904173 | -0.0904173 | -0.0904173 |
| Depreciation | 152.0 | 154.2 | 139.0 | 122.5 | 109.9 | 144.9 | 142.9 | 140.9 | 138.9 | 137.0 |
| Depreciation, % | 4.89 | 6.49 | 5.97 | 4.85 | 3.9 | 5.22 | 5.22 | 5.22 | 5.22 | 5.22 |
| EBIT | 39.9 | -271.1 | -216.9 | -122.0 | -64.3 | -147.4 | -145.4 | -143.3 | -141.3 | -139.3 |
| EBIT, % | 1.28 | -11.41 | -9.31 | -4.83 | -2.28 | -5.31 | -5.31 | -5.31 | -5.31 | -5.31 |
| Total Cash | 359.5 | 438.4 | 248.0 | 186.9 | 154.8 | 297.4 | 293.3 | 289.2 | 285.1 | 281.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 571.3 | 547.7 | 489.2 | 512.7 | 541.7 | 566.2 | 558.3 | 550.5 | 542.8 | 535.1 |
| Account Receivables, % | 18.38 | 23.06 | 20.99 | 20.3 | 19.24 | 20.39 | 20.39 | 20.39 | 20.39 | 20.39 |
| Inventories | 143.4 | 143.7 | 158.1 | 157.8 | 146.8 | 160.5 | 158.3 | 156.1 | 153.9 | 151.7 |
| Inventories, % | 4.61 | 6.05 | 6.78 | 6.25 | 5.21 | 5.78 | 5.78 | 5.78 | 5.78 | 5.78 |
| Accounts Payable | 426.1 | 385.3 | 348.1 | 338.2 | 334.6 | 389.5 | 384.0 | 378.6 | 373.3 | 368.1 |
| Accounts Payable, % | 13.71 | 16.22 | 14.94 | 13.39 | 11.88 | 14.03 | 14.03 | 14.03 | 14.03 | 14.03 |
| Capital Expenditure | -164.5 | -91.8 | -96.1 | -71.2 | -80.7 | -105.3 | -103.8 | -102.4 | -100.9 | -99.5 |
| Capital Expenditure, % | -5.29 | -3.86 | -4.12 | -2.82 | -2.87 | -3.79 | -3.79 | -3.79 | -3.79 | -3.79 |
| Tax Rate, % | -3.91 | -3.91 | -3.91 | -3.91 | -3.91 | -3.91 | -3.91 | -3.91 | -3.91 | -3.91 |
| EBITAT | 27.4 | -221.1 | -246.5 | -132.5 | -66.8 | -132.8 | -130.9 | -129.1 | -127.3 | -125.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -273.8 | -176.1 | -196.5 | -114.3 | -59.3 | -76.5 | -87.1 | -85.9 | -84.7 | -83.5 |
| WACC, % | 9.17 | 10.34 | 12.02 | 12.02 | 12.02 | 11.11 | 11.11 | 11.11 | 11.11 | 11.11 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -306.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -85 | |||||||||
| Terminal Value | -935 | |||||||||
| Present Terminal Value | -552 | |||||||||
| Enterprise Value | -859 | |||||||||
| Net Debt | 1,036 | |||||||||
| Equity Value | -1,895 | |||||||||
| Diluted Shares Outstanding, MM | 17 | |||||||||
| Equity Value Per Share | -109.16 |
What You Will Get
- Real CPS Financials: Access to both 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 computed automatically.
- Scenario Analysis: Explore various scenarios to assess Cooper-Standard's future performance.
- User-Friendly Design: Designed for industry professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for Cooper-Standard Holdings Inc. (CPS).
- Adjustable Forecast Parameters: Modify highlighted cells for key inputs such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to help visualize your valuation outcomes.
- Designed for All Levels: A straightforward, user-friendly layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Cooper-Standard's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose Cooper-Standard Holdings Inc. (CPS)?
- Industry Leader: Renowned for innovation and quality in the automotive sector.
- Robust Financial Performance: Consistent revenue growth and strong profitability metrics.
- Commitment to Sustainability: Focused on environmentally-friendly practices and products.
- Diverse Product Range: Offers a wide array of solutions for various automotive applications.
- Experienced Management: Led by a team with extensive industry expertise and vision.
Who Should Use This Product?
- Investors: Evaluate Cooper-Standard Holdings Inc.'s (CPS) market position before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial projections for Cooper-Standard Holdings Inc. (CPS).
- Startup Founders: Understand the valuation strategies of established companies like Cooper-Standard Holdings Inc. (CPS).
- Consultants: Create comprehensive valuation analyses and reports for clients focused on Cooper-Standard Holdings Inc. (CPS).
- Students and Educators: Utilize real-time data from Cooper-Standard Holdings Inc. (CPS) to teach and apply valuation practices.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Cooper-Standard Holdings Inc. (CPS) 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 Cooper-Standard Holdings Inc. (CPS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.