|
Valoración de DCF de Trimas Corporation (TRS)
US | Consumer Cyclical | Packaging & Containers | NASDAQ
|
- ✓ 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
TriMas Corporation (TRS) Bundle
¡Mejore su estrategia de inversión con la calculadora DCF de Trimas Corporation (TRS)! Explore datos financieros reales de Trimas, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estos cambios afectan el valor intrínseco de Trimas Corporation (TRS).
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 | 723.5 | 770.0 | 857.1 | 883.8 | 893.6 | 942.6 | 994.3 | 1,048.9 | 1,106.5 | 1,167.2 |
Revenue Growth, % | 0 | 6.42 | 11.32 | 3.12 | 1.1 | 5.49 | 5.49 | 5.49 | 5.49 | 5.49 |
EBITDA | 134.6 | -38.3 | 158.2 | 140.9 | 124.1 | 116.7 | 123.1 | 129.9 | 137.0 | 144.5 |
EBITDA, % | 18.61 | -4.97 | 18.46 | 15.94 | 13.89 | 12.38 | 12.38 | 12.38 | 12.38 | 12.38 |
Depreciation | 43.5 | 49.8 | 53.5 | 53.2 | 57.6 | 58.8 | 62.0 | 65.4 | 69.0 | 72.8 |
Depreciation, % | 6.01 | 6.46 | 6.24 | 6.02 | 6.45 | 6.24 | 6.24 | 6.24 | 6.24 | 6.24 |
EBIT | 91.1 | -88.1 | 104.7 | 87.6 | 66.5 | 57.9 | 61.1 | 64.5 | 68.0 | 71.8 |
EBIT, % | 12.59 | -11.44 | 12.22 | 9.92 | 7.44 | 6.15 | 6.15 | 6.15 | 6.15 | 6.15 |
Total Cash | 172.5 | 74.0 | 140.7 | 112.1 | 34.9 | 125.3 | 132.1 | 139.4 | 147.0 | 155.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 108.9 | 113.4 | 125.6 | 132.4 | 148.0 | 143.2 | 151.1 | 159.4 | 168.1 | 177.4 |
Account Receivables, % | 15.05 | 14.73 | 14.66 | 14.98 | 16.57 | 15.2 | 15.2 | 15.2 | 15.2 | 15.2 |
Inventories | 132.7 | 149.4 | 152.5 | 163.4 | 192.5 | 180.1 | 190.0 | 200.4 | 211.4 | 223.0 |
Inventories, % | 18.34 | 19.4 | 17.79 | 18.48 | 21.54 | 19.11 | 19.11 | 19.11 | 19.11 | 19.11 |
Accounts Payable | 72.7 | 69.9 | 87.8 | 85.2 | 91.9 | 92.9 | 98.0 | 103.4 | 109.1 | 115.1 |
Accounts Payable, % | 10.04 | 9.08 | 10.24 | 9.64 | 10.29 | 9.86 | 9.86 | 9.86 | 9.86 | 9.86 |
Capital Expenditure | -29.7 | -40.5 | -45.1 | -46.0 | -54.2 | -48.8 | -51.5 | -54.3 | -57.3 | -60.4 |
Capital Expenditure, % | -4.1 | -5.26 | -5.26 | -5.2 | -6.06 | -5.18 | -5.18 | -5.18 | -5.18 | -5.18 |
Tax Rate, % | 20.22 | 20.22 | 20.22 | 20.22 | 20.22 | 20.22 | 20.22 | 20.22 | 20.22 | 20.22 |
EBITAT | 72.1 | -68.4 | 86.9 | 66.1 | 53.1 | 45.8 | 48.3 | 50.9 | 53.7 | 56.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -82.9 | -83.1 | 97.8 | 53.2 | 18.4 | 73.9 | 46.2 | 48.7 | 51.4 | 54.2 |
WACC, % | 6.35 | 6.33 | 6.4 | 6.3 | 6.36 | 6.35 | 6.35 | 6.35 | 6.35 | 6.35 |
PV UFCF | ||||||||||
SUM PV UFCF | 230.9 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 56 | |||||||||
Terminal Value | 1,668 | |||||||||
Present Terminal Value | 1,226 | |||||||||
Enterprise Value | 1,457 | |||||||||
Net Debt | 408 | |||||||||
Equity Value | 1,048 | |||||||||
Diluted Shares Outstanding, MM | 42 | |||||||||
Equity Value Per Share | 25.15 |
What You Will Get
- Real TriMas Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on TriMas Corporation’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Customizable Financial Inputs: Adjust essential variables such as revenue growth, EBITDA %, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Leverages TriMas Corporation's (TRS) actual financial data for reliable valuation results.
- Effortless Scenario Analysis: Easily explore various assumptions and evaluate different outcomes.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file for TriMas Corporation (TRS).
- Step 2: Review TriMas’s pre-filled financial data and projections.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify assumptions.
- Step 5: Evaluate the outputs and leverage the results for investment strategies.
Why Choose TriMas Corporation (TRS)?
- Innovative Solutions: We provide cutting-edge products that meet diverse industry needs.
- Commitment to Quality: Our rigorous quality control ensures reliable performance and durability.
- Sustainable Practices: We prioritize eco-friendly processes and materials in our operations.
- Expert Team: Our skilled professionals are dedicated to delivering exceptional customer service.
- Proven Track Record: Trusted by clients worldwide for our consistent excellence and reliability.
Who Should Use TriMas Corporation (TRS)?
- Finance Students: Explore valuation methods and apply them to real-world data from TriMas Corporation (TRS).
- Academics: Integrate industry-standard models into your coursework or research focused on TriMas Corporation (TRS).
- Investors: Validate your investment hypotheses and evaluate the valuation results for TriMas Corporation (TRS).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for TriMas Corporation (TRS).
- Small Business Owners: Discover how large public firms like TriMas Corporation (TRS) are assessed and valued.
What the Template Contains
- Pre-Filled Data: Includes TriMas Corporation's historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze TriMas Corporation's profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.