TMC the metals company Inc. (TMC) 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
TMC the metals company Inc. (TMC) Bundle
Evaluate TMC the Metals Company Inc.'s financial outlook like an expert! This (TMC) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, margins, and other critical 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 | .0 | .0 | .0 | .0 | 72.0 | 72.0 | 72.0 | 72.0 | 72.0 | 72.0 |
Revenue Growth, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITDA | -41.7 | -56.1 | -139.8 | -173.7 | -73.4 | 43.2 | 43.2 | 43.2 | 43.2 | 43.2 |
EBITDA, % | 100 | 100 | 100 | 100 | -101.88 | 60 | 60 | 60 | 60 | 60 |
Depreciation | .3 | .6 | .5 | .4 | -1.0 | 57.4 | 57.4 | 57.4 | 57.4 | 57.4 |
Depreciation, % | 100 | 100 | 100 | 100 | -1.38 | 79.72 | 79.72 | 79.72 | 79.72 | 79.72 |
EBIT | -42.1 | -56.6 | -140.3 | -174.1 | -72.4 | 43.2 | 43.2 | 43.2 | 43.2 | 43.2 |
EBIT, % | 100 | 100 | 100 | 100 | -100.5 | 60 | 60 | 60 | 60 | 60 |
Total Cash | 16.0 | 10.1 | 84.9 | 46.8 | 6.8 | 59.0 | 59.0 | 59.0 | 59.0 | 59.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .1 | .1 | .5 | 57.7 | 57.7 | 57.7 | 57.7 | 57.7 |
Account Receivables, % | 100 | 100 | 100 | 100 | 0.64835 | 80.13 | 80.13 | 80.13 | 80.13 | 80.13 |
Inventories | .0 | -.1 | -3.7 | -2.6 | .0 | 57.6 | 57.6 | 57.6 | 57.6 | 57.6 |
Inventories, % | 100 | 100 | 100 | 100 | 0 | 80 | 80 | 80 | 80 | 80 |
Accounts Payable | 1.8 | .0 | .0 | .0 | .0 | 57.6 | 57.6 | 57.6 | 57.6 | 57.6 |
Accounts Payable, % | 100 | 100 | 100 | 100 | 0 | 80 | 80 | 80 | 80 | 80 |
Capital Expenditure | .0 | -.6 | -.4 | -1.2 | -.6 | -.1 | -.1 | -.1 | -.1 | -.1 |
Capital Expenditure, % | 100 | 100 | 100 | 100 | -0.80245 | -0.16049 | -0.16049 | -0.16049 | -0.16049 | -0.16049 |
Tax Rate, % | -0.05560076 | -0.05560076 | -0.05560076 | -0.05560076 | -0.05560076 | -0.05560076 | -0.05560076 | -0.05560076 | -0.05560076 | -0.05560076 |
EBITAT | -42.1 | -56.7 | -132.1 | -174.2 | -72.4 | 42.7 | 42.7 | 42.7 | 42.7 | 42.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -39.9 | -58.4 | -128.5 | -176.0 | -77.0 | 42.8 | 100.0 | 100.0 | 100.0 | 100.0 |
WACC, % | 12.09 | 12.09 | 12.08 | 12.09 | 12.09 | 12.09 | 12.09 | 12.09 | 12.09 | 12.09 |
PV UFCF | ||||||||||
SUM PV UFCF | 308.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 102 | |||||||||
Terminal Value | 1,011 | |||||||||
Present Terminal Value | 572 | |||||||||
Enterprise Value | 880 | |||||||||
Net Debt | -7 | |||||||||
Equity Value | 887 | |||||||||
Diluted Shares Outstanding, MM | 289 | |||||||||
Equity Value Per Share | 3.07 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: TMC's financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and saving time.
Key Features
- 🔍 Real-Life TMC Financials: Pre-filled historical and projected data for TMC the metals company Inc. (TMC).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate TMC’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize TMC’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file for TMC the metals company Inc. (TMC).
- Step 2: Review TMC’s pre-filled financial data and projections.
- Step 3: Adjust key inputs such as metal prices, production rates, and operational costs (highlighted cells).
- Step 4: Observe the DCF model refresh in real-time as you modify your assumptions.
- Step 5: Evaluate the outcomes and leverage the findings for your investment strategies.
Why Choose This Calculator for TMC (TMC)?
- User-Friendly Interface: Perfectly tailored for both novices and seasoned professionals.
- Customizable Inputs: Easily adjust parameters to suit your specific analysis needs.
- Real-Time Valuation: Observe immediate updates to TMC’s valuation as you modify inputs.
- Pre-Loaded Data: Comes equipped with TMC’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Accurately assess TMC the Metals Company Inc.'s (TMC) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and strategic analysis at TMC.
- Consultants: Efficiently customize the template for valuation reports tailored to TMC's clients.
- Entrepreneurs: Acquire insights into the financial modeling practices of leading metals companies.
- Educators: Employ it as a teaching resource to illustrate valuation techniques within the metals industry.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for TMC the metals company Inc. (TMC).
- Real-World Data: TMC’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into TMC's performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to TMC.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for TMC's financial data.