Trinity Industries, Inc. (TRN) 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
Trinity Industries, Inc. (TRN) Bundle
Evaluate Trinity Industries, Inc. (TRN) financial outlook like an expert! This (TRN) DCF Calculator provides pre-filled financials and full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your 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,005.1 | 1,999.4 | 1,516.0 | 1,977.3 | 2,983.3 | 3,159.8 | 3,346.7 | 3,544.7 | 3,754.4 | 3,976.5 |
| Revenue Growth, % | 0 | -33.47 | -24.18 | 30.43 | 50.88 | 5.92 | 5.92 | 5.92 | 5.92 | 5.92 |
| EBITDA | 711.3 | -68.3 | 439.9 | 458.0 | 707.7 | 607.7 | 643.6 | 681.7 | 722.0 | 764.7 |
| EBITDA, % | 23.67 | -3.42 | 29.02 | 23.16 | 23.72 | 19.23 | 19.23 | 19.23 | 19.23 | 19.23 |
| Depreciation | 283.6 | 258.5 | 265.7 | 276.4 | 293.2 | 402.6 | 426.4 | 451.6 | 478.3 | 506.6 |
| Depreciation, % | 9.44 | 12.93 | 17.53 | 13.98 | 9.83 | 12.74 | 12.74 | 12.74 | 12.74 | 12.74 |
| EBIT | 427.7 | -326.8 | 174.2 | 181.6 | 414.5 | 205.1 | 217.2 | 230.1 | 243.7 | 258.1 |
| EBIT, % | 14.23 | -16.34 | 11.49 | 9.18 | 13.89 | 6.49 | 6.49 | 6.49 | 6.49 | 6.49 |
| Total Cash | 166.2 | 132.0 | 167.3 | 79.6 | 105.7 | 194.2 | 205.7 | 217.9 | 230.8 | 244.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 274.8 | 610.2 | 233.0 | 331.3 | 368.7 | 531.8 | 563.2 | 596.5 | 631.8 | 669.2 |
| Account Receivables, % | 9.14 | 30.52 | 15.37 | 16.76 | 12.36 | 16.83 | 16.83 | 16.83 | 16.83 | 16.83 |
| Inventories | 433.4 | 321.2 | 432.9 | 629.4 | 684.3 | 719.2 | 761.8 | 806.8 | 854.6 | 905.1 |
| Inventories, % | 14.42 | 16.06 | 28.56 | 31.83 | 22.94 | 22.76 | 22.76 | 22.76 | 22.76 | 22.76 |
| Accounts Payable | 203.9 | 146.1 | 206.4 | 287.5 | 305.3 | 331.7 | 351.3 | 372.1 | 394.1 | 417.4 |
| Accounts Payable, % | 6.79 | 7.31 | 13.61 | 14.54 | 10.23 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 |
| Capital Expenditure | -1,219.2 | -704.5 | -570.8 | -966.8 | -710.1 | -1,176.4 | -1,246.0 | -1,319.7 | -1,397.8 | -1,480.5 |
| Capital Expenditure, % | -40.57 | -35.24 | -37.65 | -48.89 | -23.8 | -37.23 | -37.23 | -37.23 | -37.23 | -37.23 |
| Tax Rate, % | 28.86 | 28.86 | 28.86 | 28.86 | 28.86 | 28.86 | 28.86 | 28.86 | 28.86 | 28.86 |
| EBITAT | 293.2 | -149.4 | 124.0 | 142.0 | 294.9 | 137.3 | 145.5 | 154.1 | 163.2 | 172.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,146.7 | -876.4 | 144.7 | -762.1 | -196.5 | -808.2 | -728.6 | -771.7 | -817.3 | -865.7 |
| WACC, % | 5.82 | 5.12 | 5.9 | 6.11 | 5.89 | 5.77 | 5.77 | 5.77 | 5.77 | 5.77 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -3,374.8 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | -896 | |||||||||
| Terminal Value | -39,525 | |||||||||
| Present Terminal Value | -29,863 | |||||||||
| Enterprise Value | -33,237 | |||||||||
| Net Debt | 5,649 | |||||||||
| Equity Value | -38,886 | |||||||||
| Diluted Shares Outstanding, MM | 83 | |||||||||
| Equity Value Per Share | -466.26 |
What You Will Receive
- Authentic TRN Financial Data: Pre-populated with Trinity Industries' historical and projected figures for accurate assessment.
- Completely Customizable Template: Easily adjust critical inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch Trinity Industries' intrinsic value refresh immediately based on your modifications.
- Expert Valuation Tool: Crafted for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Interface: Streamlined layout and straightforward instructions suitable for all skill levels.
Key Features
- Comprehensive Financial Data: Trinity Industries' historical financial statements and projected forecasts.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Observe Trinity Industries' intrinsic value update instantly.
- Intuitive Visualizations: Dashboard graphs present valuation outcomes and essential metrics clearly.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template featuring Trinity Industries, Inc. (TRN) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the key performance indicators.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including the intrinsic value of Trinity Industries, Inc. (TRN).
- Step 5: Utilize the outputs to make informed investment decisions or create comprehensive reports.
Why Choose This Calculator for Trinity Industries, Inc. (TRN)?
- Designed for Experts: A sophisticated tool utilized by analysts, CFOs, and industry consultants.
- Accurate Financial Data: Trinity’s historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth calculation process.
Who Should Use This Product?
- Professional Investors: Create comprehensive and accurate valuation models for assessing Trinity Industries, Inc. (TRN).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Trinity Industries, Inc. (TRN).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Industry Analysts: Gain insights into how transportation and logistics companies like Trinity Industries, Inc. (TRN) are valued in the market.
What the Template Contains
- Pre-Filled Data: Contains Trinity Industries’ historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on tailored inputs.
- Key Financial Ratios: Assess Trinity Industries’ profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.