Trex Company, Inc. (TREX) DCF Valuation

Trex Company, Inc. (TREX) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Trex Company, Inc. (TREX) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Optimize your time and improve precision with our (TREX) DCF Calculator! Utilizing actual Trex Company data and customizable assumptions, this tool enables you to forecast, analyze, and value Trex Company, Inc. just like a seasoned investor.


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
Account Receivables, % 12.03 14.02 13.42 8.87 4.64
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.

No products were found matching.