Carpenter Technology Corporation (CRS) 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
Carpenter Technology Corporation (CRS) Bundle
Designed for accuracy, our Carpenter Technology Corporation (CRS) DCF Calculator allows you to evaluate the valuation of Carpenter Technology Corporation (CRS) using real-world financial data and offers complete flexibility to modify all key parameters for more accurate projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 2,181.1 | 1,475.6 | 1,836.3 | 2,550.3 | 2,759.7 | 3,030.1 | 3,327.0 | 3,653.0 | 4,010.9 | 4,403.8 |
| Revenue Growth, % | 0 | -32.35 | 24.44 | 38.88 | 8.21 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 |
| EBITDA | 150.9 | -141.2 | 113.6 | 257.6 | 397.2 | 169.9 | 186.5 | 204.8 | 224.8 | 246.9 |
| EBITDA, % | 6.92 | -9.57 | 6.19 | 10.1 | 14.39 | 5.61 | 5.61 | 5.61 | 5.61 | 5.61 |
| Depreciation | 124.6 | 123.6 | 131.4 | 131.0 | 134.6 | 189.4 | 208.0 | 228.4 | 250.7 | 275.3 |
| Depreciation, % | 5.71 | 8.38 | 7.16 | 5.14 | 4.88 | 6.25 | 6.25 | 6.25 | 6.25 | 6.25 |
| EBIT | 26.3 | -264.8 | -17.8 | 126.6 | 262.6 | -19.6 | -21.5 | -23.6 | -25.9 | -28.4 |
| EBIT, % | 1.21 | -17.95 | -0.96934 | 4.96 | 9.52 | -0.64582 | -0.64582 | -0.64582 | -0.64582 | -0.64582 |
| Total Cash | 193.1 | 287.4 | 154.2 | 44.5 | 199.1 | 276.9 | 304.0 | 333.8 | 366.5 | 402.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 292.3 | 308.7 | 382.3 | 531.3 | 562.6 | 584.0 | 641.2 | 704.0 | 773.0 | 848.7 |
| Account Receivables, % | 13.4 | 20.92 | 20.82 | 20.83 | 20.39 | 19.27 | 19.27 | 19.27 | 19.27 | 19.27 |
| Inventories | 724.3 | 425.7 | 496.1 | 639.7 | 735.4 | 853.3 | 936.9 | 1,028.7 | 1,129.5 | 1,240.2 |
| Inventories, % | 33.21 | 28.85 | 27.02 | 25.08 | 26.65 | 28.16 | 28.16 | 28.16 | 28.16 | 28.16 |
| Accounts Payable | 124.2 | 142.4 | 242.1 | 278.1 | 263.9 | 296.9 | 326.0 | 358.0 | 393.0 | 431.5 |
| Accounts Payable, % | 5.69 | 9.65 | 13.18 | 10.9 | 9.56 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 |
| Capital Expenditure | -171.4 | -100.5 | -91.3 | -82.3 | -96.6 | -159.8 | -175.5 | -192.6 | -211.5 | -232.2 |
| Capital Expenditure, % | -7.86 | -6.81 | -4.97 | -3.23 | -3.5 | -5.27 | -5.27 | -5.27 | -5.27 | -5.27 |
| Tax Rate, % | 11.86 | 11.86 | 11.86 | 11.86 | 11.86 | 11.86 | 11.86 | 11.86 | 11.86 | 11.86 |
| EBITAT | 6.5 | -204.1 | -13.9 | 98.5 | 231.5 | -13.5 | -14.8 | -16.3 | -17.9 | -19.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -932.7 | 119.4 | -18.1 | -109.4 | 128.3 | -90.1 | -94.0 | -103.2 | -113.4 | -124.5 |
| WACC, % | 10.64 | 11.01 | 11.01 | 11.01 | 11.08 | 10.95 | 10.95 | 10.95 | 10.95 | 10.95 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -382.1 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | -129 | |||||||||
| Terminal Value | -1,729 | |||||||||
| Present Terminal Value | -1,029 | |||||||||
| Enterprise Value | -1,411 | |||||||||
| Net Debt | 542 | |||||||||
| Equity Value | -1,953 | |||||||||
| Diluted Shares Outstanding, MM | 50 | |||||||||
| Equity Value Per Share | -38.82 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real CRS financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the impact of your inputs on Carpenter Technology Corporation’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, accompanied by step-by-step instructions.
Key Features
- Customizable Financial Inputs: Adjust key metrics such as revenue projections, EBITDA margins, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and various financial outputs.
- High-Precision Accuracy: Leverages Carpenter Technology Corporation's (CRS) actual financial data for credible valuation results.
- Simplified Scenario Analysis: Easily explore different assumptions and evaluate their impacts.
- Efficiency Booster: Avoid the hassle of creating intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Carpenter Technology Corporation’s (CRS) 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 results and leverage the findings for your investment decisions.
Why Choose This Calculator for Carpenter Technology Corporation (CRS)?
- Accuracy: Utilizes real Carpenter Technology financial data to ensure precise calculations.
- Flexibility: Allows users to freely test and adjust inputs according to their needs.
- Time-Saving: Eliminates the need to create a discounted cash flow model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing Carpenter Technology Corporation (CRS) stock.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Carpenter Technology Corporation (CRS).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Manufacturing Enthusiasts: Gain insights into how manufacturing companies like Carpenter Technology Corporation (CRS) are valued in the marketplace.
What the Template Contains
- Historical Data: Includes Carpenter Technology Corporation’s (CRS) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Carpenter Technology Corporation’s (CRS) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Carpenter Technology Corporation’s (CRS) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.