Teck Resources Limited (TECK) DCF Valuation

Teck Resources Limited (TECK) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Teck Resources Limited (TECK) 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:

Streamline your analysis and improve precision with our (TECK) DCF Calculator! Equipped with real data from Teck Resources Limited and customizable assumptions, this tool empowers you to forecast, analyze, and evaluate (TECK) just like a seasoned investor.


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 8,283.5 6,210.9 9,357.3 12,019.2 10,419.2 11,481.3 12,651.7 13,941.4 15,362.5 16,928.5
Revenue Growth, % 0 -25.02 50.66 28.45 -13.31 10.19 10.19 10.19 10.19 10.19
EBITDA 2,793.8 1,352.1 4,272.2 5,895.1 4,077.9 4,347.7 4,790.9 5,279.3 5,817.5 6,410.5
EBITDA, % 33.73 21.77 45.66 49.05 39.14 37.87 37.87 37.87 37.87 37.87
Depreciation 1,201.5 1,127.2 1,133.5 1,257.7 1,340.3 1,563.7 1,723.1 1,898.7 2,092.2 2,305.5
Depreciation, % 14.5 18.15 12.11 10.46 12.86 13.62 13.62 13.62 13.62 13.62
EBIT 1,592.3 224.9 3,138.8 4,637.3 2,737.6 2,784.1 3,067.9 3,380.6 3,725.2 4,104.9
EBIT, % 19.22 3.62 33.54 38.58 26.27 24.25 24.25 24.25 24.25 24.25
Total Cash 712.2 312.3 990.5 1,307.0 516.4 919.5 1,013.2 1,116.5 1,230.3 1,355.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 737.1 910.7 1,375.0 1,059.9 1,454.8
Account Receivables, % 8.9 14.66 14.69 8.82 13.96
Inventories 1,375.0 1,299.4 1,658.9 1,863.7 2,044.8 2,075.4 2,286.9 2,520.1 2,776.9 3,060.0
Inventories, % 16.6 20.92 17.73 15.51 19.63 18.08 18.08 18.08 18.08 18.08
Accounts Payable 907.2 991.2 1,147.4 1,316.7 1,603.4 1,504.4 1,657.8 1,826.8 2,013.0 2,218.2
Accounts Payable, % 10.95 15.96 12.26 10.96 15.39 13.1 13.1 13.1 13.1 13.1
Capital Expenditure -2,407.2 -2,518.2 -3,271.3 -3,793.3 -4,013.3 -4,010.3 -4,419.1 -4,869.6 -5,365.9 -5,912.9
Capital Expenditure, % -29.06 -40.55 -34.96 -31.56 -38.52 -34.93 -34.93 -34.93 -34.93 -34.93
Tax Rate, % 38.92 38.92 38.92 38.92 38.92 38.92 38.92 38.92 38.92 38.92
EBITAT 2,000.6 186.9 1,986.3 2,343.0 1,672.1 1,993.3 2,196.5 2,420.4 2,667.2 2,939.0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -410.1 -1,218.0 -819.3 87.2 -1,290.3 -529.6 -700.6 -772.0 -850.7 -937.4
WACC, % 9.18 8.98 8.74 8.59 8.72 8.84 8.84 8.84 8.84 8.84
PV UFCF
SUM PV UFCF -2,896.5
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) -966
Terminal Value -16,526
Present Terminal Value -10,819
Enterprise Value -13,715
Net Debt 7,183
Equity Value -20,898
Diluted Shares Outstanding, MM 525
Equity Value Per Share -39.78

What You Will Receive

  • Comprehensive Financial Model: Teck Resources Limited’s (TECK) actual data provides an accurate DCF valuation.
  • Complete Forecasting Flexibility: Modify revenue growth, margins, WACC, and other essential factors.
  • Real-Time Calculations: Automatic updates ensure you view results immediately as you adjust inputs.
  • Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
  • Adaptable and Reusable: Designed for versatility, allowing for repeated application in detailed forecasting.

Key Features

  • Real-Life TECK Data: Pre-filled with Teck Resources Limited’s historical financials and future projections.
  • Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
  • Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
  • Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
  • User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Teck Resources Limited’s (TECK) preloaded data.
  • 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures as needed.
  • 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV for you.
  • 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
  • 5. Present with Assurance: Share professional valuation insights to back your strategic decisions.

Why Choose This Calculator for Teck Resources Limited (TECK)?

  • All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for TECK.
  • Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
  • In-Depth Analysis: Automatically computes Teck's intrinsic value and Net Present Value.
  • Ready-to-Use Data: Historical and projected data provide reliable starting metrics.
  • Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focused on TECK.

Who Should Use This Product?

  • Mining Students: Understand resource valuation methods and apply them to real-world scenarios.
  • Researchers: Integrate industry-specific models into your studies or projects.
  • Investors: Evaluate your investment strategies and analyze the valuation metrics of Teck Resources Limited (TECK).
  • Market Analysts: Enhance your analysis with a ready-to-use, customizable DCF model tailored for the mining sector.
  • Small Business Owners: Learn how major mining companies like Teck Resources Limited (TECK) are assessed in the market.

What the Template Contains

  • Historical Data: Includes Teck Resources Limited’s past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Teck Resources Limited’s 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 Teck Resources Limited’s financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

Es wurden keine passenden Produkte gefunden.