|
Valuación de DCF de Teekay Tankers Ltd. (TNK)
CA | Energy | Oil & Gas Midstream | NYSE
|
- ✓ 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
Teekay Tankers Ltd. (TNK) Bundle
¡Simplifique la valoración de Teekay Tankers Ltd. (TNK) con esta calculadora DCF personalizable! Con Real Teekay Tankers Ltd. (TNK) financieras y entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Teekay Tankers Ltd. (TNK) en minutos.
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 | 921.0 | 886.4 | 542.4 | 1,063.1 | 1,364.5 | 1,404.4 | 1,445.6 | 1,488.0 | 1,531.6 | 1,576.5 |
| Revenue Growth, % | 0 | -3.75 | -38.81 | 96.01 | 28.35 | 2.93 | 2.93 | 2.93 | 2.93 | 2.93 |
| EBITDA | 248.5 | 258.2 | -103.2 | 364.4 | 648.4 | 333.9 | 343.7 | 353.8 | 364.2 | 374.8 |
| EBITDA, % | 26.98 | 29.13 | -19.03 | 34.28 | 47.52 | 23.78 | 23.78 | 23.78 | 23.78 | 23.78 |
| Depreciation | 124.0 | 117.2 | 106.1 | 99.0 | 97.6 | 176.1 | 181.3 | 186.6 | 192.1 | 197.7 |
| Depreciation, % | 13.46 | 13.22 | 19.56 | 9.32 | 7.15 | 12.54 | 12.54 | 12.54 | 12.54 | 12.54 |
| EBIT | 124.5 | 141.0 | -209.3 | 265.4 | 550.9 | 157.8 | 162.4 | 167.2 | 172.1 | 177.1 |
| EBIT, % | 13.52 | 15.91 | -38.58 | 24.96 | 40.37 | 11.23 | 11.23 | 11.23 | 11.23 | 11.23 |
| Total Cash | 88.8 | 97.2 | 50.6 | 180.5 | 365.9 | 207.1 | 213.2 | 219.4 | 225.9 | 232.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 203.2 | 68.1 | 89.8 | 202.1 | 170.1 | 218.5 | 224.9 | 231.5 | 238.3 | 245.2 |
| Account Receivables, % | 22.07 | 7.68 | 16.56 | 19.01 | 12.47 | 15.56 | 15.56 | 15.56 | 15.56 | 15.56 |
| Inventories | 49.8 | 34.6 | 49.0 | 60.8 | 53.2 | 78.6 | 80.9 | 83.2 | 85.7 | 88.2 |
| Inventories, % | 5.41 | 3.9 | 9.04 | 5.72 | 3.9 | 5.59 | 5.59 | 5.59 | 5.59 | 5.59 |
| Accounts Payable | 71.0 | 31.1 | 34.8 | 42.4 | 29.9 | 66.9 | 68.8 | 70.8 | 72.9 | 75.1 |
| Accounts Payable, % | 7.71 | 3.5 | 6.42 | 3.98 | 2.19 | 4.76 | 4.76 | 4.76 | 4.76 | 4.76 |
| Capital Expenditure | -11.6 | -16.0 | -21.4 | -15.4 | -10.2 | -25.9 | -26.7 | -27.4 | -28.3 | -29.1 |
| Capital Expenditure, % | -1.26 | -1.81 | -3.95 | -1.45 | -0.74741 | -1.84 | -1.84 | -1.84 | -1.84 | -1.84 |
| Tax Rate, % | 1.81 | 1.81 | 1.81 | 1.81 | 1.81 | 1.81 | 1.81 | 1.81 | 1.81 | 1.81 |
| EBITAT | 64.0 | 130.2 | -207.6 | 264.7 | 540.9 | 139.1 | 143.2 | 147.4 | 151.7 | 156.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -5.7 | 341.8 | -155.4 | 231.8 | 655.4 | 252.6 | 291.1 | 299.6 | 308.4 | 317.5 |
| WACC, % | 5.56 | 6.29 | 6.41 | 6.42 | 6.39 | 6.21 | 6.21 | 6.21 | 6.21 | 6.21 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,223.2 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 319 | |||||||||
| Terminal Value | 5,585 | |||||||||
| Present Terminal Value | 4,132 | |||||||||
| Enterprise Value | 5,355 | |||||||||
| Net Debt | -150 | |||||||||
| Equity Value | 5,505 | |||||||||
| Diluted Shares Outstanding, MM | 35 | |||||||||
| Equity Value Per Share | 159.24 |
What You Will Get
- Real Teekay Tankers Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Teekay Tankers Ltd. (TNK).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Teekay Tankers Ltd. (TNK).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Teekay Tankers Ltd. (TNK)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Teekay Tankers Ltd. (TNK).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Teekay Tankers Ltd. (TNK).
Key Features
- Real-Time TNK Data: Pre-loaded with Teekay Tankers' historical performance metrics and future forecasts.
- Comprehensive Customization Options: Tailor revenue growth, profit margins, WACC, tax rates, and capital investments to your needs.
- Adaptive Valuation Framework: Instant updates to Net Present Value (NPV) and intrinsic value based on user-defined parameters.
- Scenario Analysis: Generate various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive Interface: User-friendly layout designed for both industry experts and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based TNK DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh to show Teekay Tankers Ltd.'s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Teekay Tankers Ltd. (TNK)?
- Accurate Data: Up-to-date Teekay Tankers financials provide trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations allow you to avoid starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focusing on the maritime sector.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use Teekay Tankers Ltd. (TNK)?
- Investors: Evaluate Teekay Tankers' performance and market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial projections for shipping companies.
- Startup Founders: Gain insights into the valuation practices of established maritime firms like Teekay Tankers.
- Consultants: Create comprehensive valuation reports tailored for clients in the shipping industry.
- Students and Educators: Utilize real-time data to enhance the understanding of valuation strategies in the maritime sector.
What the Template Contains
- Pre-Filled DCF Model: Teekay Tankers Ltd.'s (TNK) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Teekay Tankers Ltd.'s (TNK) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.