Tredegar Corporation (TG) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Tredegar Corporation (TG) Bundle
Evaluate Tredegar Corporation's financial outlook like an expert! This (TG) DCF Calculator provides you with pre-filled financial data and the freedom to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2018 |
AY2 2019 |
AY3 2020 |
AY4 2021 |
AY5 2022 |
FY1 2023 |
FY2 2024 |
FY3 2025 |
FY4 2026 |
FY5 2027 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 972.4 | 755.3 | 826.5 | 938.6 | 704.8 | 688.0 | 671.5 | 655.5 | 639.8 | 624.5 |
| Revenue Growth, % | 0 | -22.32 | 9.42 | 13.57 | -24.9 | -2.39 | -2.39 | -2.39 | -2.39 | -2.39 |
| EBITDA | 122.9 | 12.3 | 96.5 | 66.3 | -118.5 | 22.3 | 21.7 | 21.2 | 20.7 | 20.2 |
| EBITDA, % | 12.64 | 1.62 | 11.67 | 7.07 | -16.82 | 3.24 | 3.24 | 3.24 | 3.24 | 3.24 |
| Depreciation | 46.9 | 34.7 | 25.9 | 28.5 | -102.6 | 1.4 | 1.4 | 1.3 | 1.3 | 1.3 |
| Depreciation, % | 4.82 | 4.6 | 3.13 | 3.04 | -14.56 | 0.2054 | 0.2054 | 0.2054 | 0.2054 | 0.2054 |
| EBIT | 76.1 | -22.5 | 70.6 | 37.8 | -15.9 | 20.9 | 20.4 | 19.9 | 19.4 | 18.9 |
| EBIT, % | 7.82 | -2.97 | 8.54 | 4.03 | -2.26 | 3.03 | 3.03 | 3.03 | 3.03 | 3.03 |
| Total Cash | 31.4 | 11.8 | 30.5 | 19.2 | 9.7 | 16.4 | 16.0 | 15.6 | 15.2 | 14.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 91.8 | 89.1 | 105.9 | 85.3 | 69.1 | 72.8 | 71.1 | 69.4 | 67.7 | 66.1 |
| Account Receivables, % | 9.44 | 11.8 | 12.81 | 9.09 | 9.81 | 10.59 | 10.59 | 10.59 | 10.59 | 10.59 |
| Inventories | 81.4 | 66.4 | 88.6 | 127.8 | 82.0 | 73.1 | 71.4 | 69.7 | 68.0 | 66.4 |
| Inventories, % | 8.37 | 8.8 | 10.72 | 13.61 | 11.64 | 10.63 | 10.63 | 10.63 | 10.63 | 10.63 |
| Accounts Payable | 87.3 | 89.7 | 123.8 | 114.9 | 95.0 | 84.7 | 82.7 | 80.7 | 78.8 | 76.9 |
| Accounts Payable, % | 8.98 | 11.88 | 14.97 | 12.25 | 13.48 | 12.31 | 12.31 | 12.31 | 12.31 | 12.31 |
| Capital Expenditure | -50.9 | -23.4 | -27.4 | -36.9 | -26.4 | -26.6 | -25.9 | -25.3 | -24.7 | -24.1 |
| Capital Expenditure, % | -5.23 | -3.09 | -3.31 | -3.93 | -3.75 | -3.86 | -3.86 | -3.86 | -3.86 | -3.86 |
| Tax Rate, % | 33.82 | 33.82 | 33.82 | 33.82 | 33.82 | 33.82 | 33.82 | 33.82 | 33.82 | 33.82 |
| EBITAT | 63.1 | -15.1 | 60.7 | 32.9 | -10.5 | 16.2 | 15.9 | 15.5 | 15.1 | 14.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -26.8 | 16.3 | 54.4 | -3.0 | -97.6 | -14.0 | -7.2 | -7.1 | -6.9 | -6.7 |
| WACC, % | 7.52 | 7.09 | 7.61 | 7.63 | 7.06 | 7.38 | 7.38 | 7.38 | 7.38 | 7.38 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -35.0 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | -7 | |||||||||
| Terminal Value | -98 | |||||||||
| Present Terminal Value | -69 | |||||||||
| Enterprise Value | -104 | |||||||||
| Net Debt | 150 | |||||||||
| Equity Value | -254 | |||||||||
| Diluted Shares Outstanding, MM | 34 | |||||||||
| Equity Value Per Share | -7.43 |
What You Will Get
- Real TG Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Tredegar Corporation's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Customizable Financial Inputs: Adjust essential factors such as revenue projections, operating margin %, and capital investments.
- Instant DCF Valuation: Automatically computes intrinsic value, net present value (NPV), and additional metrics in real-time.
- High-Precision Accuracy: Leverages Tredegar Corporation’s (TG) actual financial data for credible valuation results.
- Effortless Scenario Testing: Easily explore various assumptions and analyze their impacts on outcomes.
- Efficiency Booster: Streamlines the valuation process, removing the necessity for intricate model construction from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based TG DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Tredegar Corporation’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Tredegar Corporation (TG)?
- Accurate Data: Up-to-date Tredegar financials provide dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and financial consultants.
- User-Friendly: Easy-to-navigate design and clear instructions facilitate use for everyone.
Who Should Use Tredegar Corporation (TG)?
- Investors: Gain insights into investment opportunities with our comprehensive analysis tools.
- Financial Analysts: Streamline your workflow with our customizable financial models tailored for Tredegar Corporation (TG).
- Consultants: Effortlessly modify reports and presentations to meet client needs using our resources.
- Finance Enthusiasts: Enhance your knowledge of the industry through detailed case studies and data from Tredegar Corporation (TG).
- Educators and Students: Utilize our materials as a hands-on resource for finance education and research projects.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Tredegar Corporation (TG) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), encompassing parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Incorporates profitability, leverage, and efficiency ratios for Tredegar Corporation (TG).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for straightforward result analysis.