Trinseo PLC (TSE) DCF Valuation

Trinseo PLC (TSE) DCF Valuation
  • ✓ 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

Trinseo PLC (TSE) 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:

Designed for accuracy, our (TSE) DCF Calculator enables you to evaluate Trinseo PLC's valuation using real-time financial data and offers complete flexibility to modify all key parameters for improved projections.


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,775.8 3,035.5 4,827.5 4,965.5 3,675.4 3,825.2 3,981.2 4,143.4 4,312.3 4,488.1
Revenue Growth, % 0 -19.61 59.03 2.86 -25.98 4.08 4.08 4.08 4.08 4.08
EBITDA 160.0 239.2 593.9 -118.6 -223.3 122.1 127.0 132.2 137.6 143.2
EBITDA, % 4.24 7.88 12.3 -2.39 -6.08 3.19 3.19 3.19 3.19 3.19
Depreciation 136.0 92.6 167.5 236.9 221.2 160.0 166.5 173.3 180.4 187.7
Depreciation, % 3.6 3.05 3.47 4.77 6.02 4.18 4.18 4.18 4.18 4.18
EBIT 24.0 146.6 426.4 -355.5 -444.5 -37.9 -39.5 -41.1 -42.7 -44.5
EBIT, % 0.63563 4.83 8.83 -7.16 -12.09 -0.99109 -0.99109 -0.99109 -0.99109 -0.99109
Total Cash 456.2 588.7 573.0 211.7 259.1 418.2 435.2 452.9 471.4 490.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 570.8 529.2 740.2 586.0 490.8
Account Receivables, % 15.12 17.43 15.33 11.8 13.35
Inventories 438.2 384.1 621.0 553.6 404.7 453.5 472.0 491.3 511.3 532.1
Inventories, % 11.61 12.65 12.86 11.15 11.01 11.86 11.86 11.86 11.86 11.86
Accounts Payable 304.6 355.4 590.3 438.1 449.7 405.9 422.5 439.7 457.6 476.3
Accounts Payable, % 8.07 11.71 12.23 8.82 12.24 10.61 10.61 10.61 10.61 10.61
Capital Expenditure -110.1 -82.3 -117.7 -148.2 -69.7 -99.0 -103.1 -107.3 -111.7 -116.2
Capital Expenditure, % -2.92 -2.71 -2.44 -2.98 -1.9 -2.59 -2.59 -2.59 -2.59 -2.59
Tax Rate, % -10.81 -10.81 -10.81 -10.81 -10.81 -10.81 -10.81 -10.81 -10.81 -10.81
EBITAT 21.1 25.3 340.1 -324.0 -492.5 -28.5 -29.7 -30.9 -32.2 -33.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -657.4 182.1 176.9 -165.9 -85.3 -128.2 9.0 9.4 9.8 10.2
WACC, % 7.37 2.14 6.76 7.6 8.26 6.43 6.43 6.43 6.43 6.43
PV UFCF
SUM PV UFCF -89.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 10
Terminal Value 234
Present Terminal Value 172
Enterprise Value 82
Net Debt 2,107
Equity Value -2,025
Diluted Shares Outstanding, MM 35
Equity Value Per Share -57.38

What You Will Receive

  • Pre-Filled Financial Model: Trinseo PLC’s (TSE) actual data provides accurate DCF valuation.
  • Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
  • Real-Time Calculations: Automatic updates allow you to view outcomes instantly as adjustments are made.
  • Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
  • Flexible and Reusable: Designed for adaptability, enabling multiple uses for thorough forecasts.

Key Features

  • Comprehensive Financial Data: Trinseo PLC’s historical financial records and pre-populated forecasts.
  • Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Real-Time Calculations: Monitor Trinseo PLC’s intrinsic value updates instantly.
  • Visual Data Representation: Interactive dashboard charts showcase valuation outcomes and essential metrics.
  • Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file for Trinseo PLC (TSE).
  2. Step 2: Review Trinseo’s pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
  5. Step 5: Analyze the outputs and leverage the results for your investment decisions.

Why Choose This Calculator for Trinseo PLC (TSE)?

  • Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and industry consultants.
  • Accurate Financial Data: Trinseo's historical and projected financials are preloaded for precise calculations.
  • Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
  • Transparent Results: Automatically computes intrinsic value, NPV, and essential financial metrics.
  • User-Friendly: Comprehensive step-by-step guidance simplifies the process.

Who Should Use This Product?

  • Investors: Assess Trinseo PLC’s (TSE) valuation prior to making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and validate forecasts for Trinseo PLC (TSE).
  • Startup Founders: Understand how established companies like Trinseo PLC (TSE) are appraised in the market.
  • Consultants: Create detailed valuation reports for clients focusing on Trinseo PLC (TSE).
  • Students and Educators: Utilize real-time data from Trinseo PLC (TSE) to teach and practice valuation strategies.

What the Template Contains

  • Pre-Filled DCF Model: Trinseo PLC’s (TSE) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Trinseo PLC’s (TSE) profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.

No products were found matching.