Trilogy Metals Inc. (TMQ) 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
Trilogy Metals Inc. (TMQ) Bundle
Evaluate Trilogy Metals Inc.’s (TMQ) financial prospects like an expert! This (TMQ) DCF Calculator comes with pre-filled financial data and offers you the flexibility to tweak revenue growth, WACC, margins, and other crucial 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 | 16.5 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Revenue Growth, % | 0 | -100 | 0 | 0 | 0 | -25 | -25 | -25 | -25 | -25 |
EBITDA | -27.7 | -11.5 | -8.0 | -6.9 | -7.1 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | -168.04 | 100 | 100 | 100 | 100 | 60 | 60 | 60 | 60 | 60 |
Depreciation | .2 | .3 | .0 | .0 | -.1 | .0 | .0 | .0 | .0 | .0 |
Depreciation, % | 1.28 | 100 | 100 | 100 | 100 | 80.26 | 80.26 | 80.26 | 80.26 | 80.26 |
EBIT | -27.9 | -11.8 | -8.0 | -7.0 | -7.0 | .0 | .0 | .0 | .0 | .0 |
EBIT, % | -169.32 | 100 | 100 | 100 | 100 | 60 | 60 | 60 | 60 | 60 |
Total Cash | 19.2 | 11.1 | 6.3 | 2.6 | 2.8 | .0 | .0 | .0 | .0 | .0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .3 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 1.6 | 100 | 100 | 100 | 100 | 80.32 | 80.32 | 80.32 | 80.32 | 80.32 |
Inventories | .0 | -.4 | .0 | -.5 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 100 | 100 | 100 | 100 | 80 | 80 | 80 | 80 | 80 |
Accounts Payable | .9 | .2 | .2 | .2 | .1 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 5.47 | 100 | 100 | 100 | 100 | 81.09 | 81.09 | 81.09 | 81.09 | 81.09 |
Capital Expenditure | -.6 | .0 | -.1 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | -3.91 | 100 | 100 | 100 | 100 | -0.78229 | -0.78229 | -0.78229 | -0.78229 | -0.78229 |
Tax Rate, % | -0.42862 | -0.42862 | -0.42862 | -0.42862 | -0.42862 | -0.42862 | -0.42862 | -0.42862 | -0.42862 | -0.42862 |
EBITAT | -27.4 | -24.5 | -8.0 | -13.9 | -7.0 | .0 | .0 | .0 | .0 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -27.2 | -24.3 | -8.5 | -13.4 | -7.7 | -.1 | .0 | .0 | .0 | .0 |
WACC, % | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 |
PV UFCF | ||||||||||
SUM PV UFCF | -.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 0 | |||||||||
Present Terminal Value | 0 | |||||||||
Enterprise Value | 0 | |||||||||
Net Debt | -3 | |||||||||
Equity Value | 2 | |||||||||
Diluted Shares Outstanding, MM | 153 | |||||||||
Equity Value Per Share | 0.02 |
What You Will Receive
- Genuine Trilogy Metals Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Updates: Automatic recalculations to assess the impact of changes on Trilogy Metals’ fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and in-depth projections.
- Efficient and Precise: Avoid the hassle of building models from scratch while ensuring accuracy and adaptability.
Key Features
- Comprehensive Financial Data: Trilogy Metals Inc.'s historical financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Valuation: Observe Trilogy Metals Inc.'s intrinsic value update instantly.
- Intuitive Visual Displays: Dashboard graphs present valuation outcomes and essential metrics clearly.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Trilogy Metals Inc. (TMQ) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Trilogy Metals Inc. (TMQ)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Trilogy Metals Inc. (TMQ)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Trilogy Metals Inc. (TMQ).
- Flexible Inputs: Modify yellow-highlighted cells to explore different investment scenarios.
- In-Depth Analysis: Automatically computes Trilogy Metals Inc. (TMQ)’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable starting points for analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focused on Trilogy Metals Inc. (TMQ).
Who Should Use Trilogy Metals Inc. (TMQ)?
- Investors: Gain insights and make informed investment choices in the mining sector.
- Financial Analysts: Utilize comprehensive data to streamline your analysis of mining stocks.
- Consultants: Easily tailor reports for clients focusing on the mining and metals industry.
- Mining Enthusiasts: Enhance your knowledge of mining operations and market trends.
- Educators and Students: Use it as a resource for practical applications in mining finance courses.
What the Template Contains
- Historical Data: Includes Trilogy Metals Inc.’s (TMQ) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Trilogy Metals Inc.’s (TMQ) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Trilogy Metals Inc.’s (TMQ) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.