|
Valoración de DCF de Trex Company, Inc. (Trex)
US | Industrials | Construction | 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
Trex Company, Inc. (TREX) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (Trex)! Utilizando datos reales de la compañía Trex y supuestos personalizables, esta herramienta le permite pronosticar, analizar y valorar Trex Company, Inc. al igual que un inversor experimentado.
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 | 745.3 | 880.8 | 1,197.0 | 1,106.0 | 1,094.8 | 1,219.3 | 1,357.8 | 1,512.1 | 1,684.0 | 1,875.4 |
Revenue Growth, % | 0 | 18.18 | 35.89 | -7.6 | -1.01 | 11.36 | 11.36 | 11.36 | 11.36 | 11.36 |
EBITDA | 202.2 | 251.6 | 356.8 | 306.5 | 326.4 | 348.8 | 388.4 | 432.5 | 481.7 | 536.4 |
EBITDA, % | 27.13 | 28.56 | 29.81 | 27.71 | 29.81 | 28.6 | 28.6 | 28.6 | 28.6 | 28.6 |
Depreciation | 14.0 | 17.9 | 35.9 | 44.3 | 50.2 | 37.8 | 42.1 | 46.9 | 52.2 | 58.2 |
Depreciation, % | 1.88 | 2.04 | 3 | 4.01 | 4.58 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 |
EBIT | 188.2 | 233.6 | 320.9 | 262.2 | 276.2 | 310.9 | 346.3 | 385.6 | 429.5 | 478.3 |
EBIT, % | 25.25 | 26.52 | 26.81 | 23.7 | 25.23 | 25.5 | 25.5 | 25.5 | 25.5 | 25.5 |
Total Cash | 148.8 | 121.7 | 141.1 | 12.3 | 2.0 | 114.3 | 127.3 | 141.7 | 157.8 | 175.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 89.6 | 123.5 | 160.6 | 98.1 | 50.7 | 129.1 | 143.8 | 160.2 | 178.4 | 198.6 |
Account Receivables, % | 12.03 | 14.02 | 13.42 | 8.87 | 4.64 | 10.59 | 10.59 | 10.59 | 10.59 | 10.59 |
Inventories | 56.1 | 68.2 | 83.8 | 141.4 | 107.1 | 109.3 | 121.8 | 135.6 | 151.0 | 168.2 |
Inventories, % | 7.53 | 7.75 | 7 | 12.78 | 9.78 | 8.97 | 8.97 | 8.97 | 8.97 | 8.97 |
Accounts Payable | 15.2 | 38.6 | 24.9 | 19.9 | 24.0 | 30.5 | 33.9 | 37.8 | 42.1 | 46.9 |
Accounts Payable, % | 2.04 | 4.38 | 2.08 | 1.8 | 2.19 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 |
Capital Expenditure | -67.3 | -172.8 | -159.4 | -176.2 | -166.1 | -178.2 | -198.4 | -221.0 | -246.1 | -274.0 |
Capital Expenditure, % | -9.02 | -19.62 | -13.32 | -15.93 | -15.17 | -14.61 | -14.61 | -14.61 | -14.61 | -14.61 |
Tax Rate, % | 25.64 | 25.64 | 25.64 | 25.64 | 25.64 | 25.64 | 25.64 | 25.64 | 25.64 | 25.64 |
EBITAT | 143.6 | 174.9 | 243.2 | 196.1 | 205.4 | 233.9 | 260.5 | 290.1 | 323.0 | 359.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -40.2 | -2.6 | 53.3 | 64.2 | 175.1 | 19.4 | 80.5 | 89.7 | 99.9 | 111.2 |
WACC, % | 11.45 | 11.45 | 11.45 | 11.45 | 11.45 | 11.45 | 11.45 | 11.45 | 11.45 | 11.45 |
PV UFCF | ||||||||||
SUM PV UFCF | 276.5 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 116 | |||||||||
Terminal Value | 1,553 | |||||||||
Present Terminal Value | 903 | |||||||||
Enterprise Value | 1,180 | |||||||||
Net Debt | 30 | |||||||||
Equity Value | 1,150 | |||||||||
Diluted Shares Outstanding, MM | 109 | |||||||||
Equity Value Per Share | 10.57 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Trex Company, Inc.'s (TREX) financial data pre-filled to accelerate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you effortlessly.
- Customizable and Professional: A sleek Excel model that can be tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and optimizing efficiency.
Key Features
- Comprehensive Trex Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify yellow-highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Suitable for All Levels: A straightforward, intuitive design tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring Trex Company, Inc.'s (TREX) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Immediately see recalculated results, including Trex Company, Inc.'s (TREX) intrinsic value.
- Step 5: Utilize the outputs to make well-informed investment choices or create reports.
Why Choose This Calculator for Trex Company, Inc. (TREX)?
- Accurate Data: Up-to-date Trex financials provide trustworthy valuation outcomes.
- Customizable: Modify essential parameters like growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the industry.
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Environmental Students: Explore sustainable building practices and analyze Trex's eco-friendly products.
- Researchers: Utilize Trex's innovative materials in studies related to sustainability and construction.
- Investors: Evaluate your investment strategies and assess the market performance of Trex Company, Inc. (TREX).
- Construction Professionals: Enhance your projects with a reliable source of high-performance composite materials.
- Homeowners: Discover how Trex’s products can improve your outdoor living spaces with durability and style.
What the Template Contains
- Pre-Filled Data: Includes Trex Company, Inc.’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 Trex’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.