Scorpio Tankers Inc. (STNG) 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
Scorpio Tankers Inc. (STNG) Bundle
Assess Scorpio Tankers Inc.'s (STNG) financial outlook like an expert! This (STNG) DCF Calculator comes with pre-filled financial data and offers you 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 | 704.3 | 915.9 | 540.8 | 1,562.9 | 1,341.2 | 1,402.9 | 1,467.4 | 1,534.9 | 1,605.5 | 1,679.3 |
| Revenue Growth, % | 0 | 30.04 | -40.96 | 189 | -14.18 | 4.6 | 4.6 | 4.6 | 4.6 | 4.6 |
| EBITDA | 343.2 | 490.9 | 146.3 | 1,002.4 | 916.1 | 734.6 | 768.4 | 803.8 | 840.7 | 879.4 |
| EBITDA, % | 48.73 | 53.59 | 27.06 | 64.14 | 68.3 | 52.37 | 52.37 | 52.37 | 52.37 | 52.37 |
| Depreciation | 207.0 | 245.8 | 240.3 | 206.8 | 202.5 | 361.9 | 378.5 | 396.0 | 414.2 | 433.2 |
| Depreciation, % | 29.39 | 26.84 | 44.43 | 13.23 | 15.1 | 25.8 | 25.8 | 25.8 | 25.8 | 25.8 |
| EBIT | 136.3 | 245.0 | -93.9 | 795.6 | 713.6 | 372.7 | 389.9 | 407.8 | 426.6 | 446.2 |
| EBIT, % | 19.35 | 26.75 | -17.37 | 50.91 | 53.21 | 26.57 | 26.57 | 26.57 | 26.57 | 26.57 |
| Total Cash | 202.3 | 187.5 | 230.4 | 376.9 | 355.6 | 399.6 | 418.0 | 437.2 | 457.3 | 478.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 78.2 | 33.0 | 38.1 | 276.7 | 203.5 | 153.3 | 160.3 | 167.7 | 175.4 | 183.5 |
| Account Receivables, % | 11.1 | 3.6 | 7.04 | 17.7 | 15.17 | 10.92 | 10.92 | 10.92 | 10.92 | 10.92 |
| Inventories | 8.6 | 9.3 | 8.8 | 15.6 | 7.8 | 15.3 | 16.0 | 16.7 | 17.5 | 18.3 |
| Inventories, % | 1.23 | 1.01 | 1.62 | 0.99944 | 0.58275 | 1.09 | 1.09 | 1.09 | 1.09 | 1.09 |
| Accounts Payable | 23.1 | 12.9 | 35.1 | 28.7 | 10.0 | 38.6 | 40.4 | 42.2 | 44.2 | 46.2 |
| Accounts Payable, % | 3.28 | 1.4 | 6.49 | 1.84 | 0.74589 | 2.75 | 2.75 | 2.75 | 2.75 | 2.75 |
| Capital Expenditure | -207.0 | -174.5 | -47.1 | -34.5 | -23.1 | -171.4 | -179.2 | -187.5 | -196.1 | -205.1 |
| Capital Expenditure, % | -29.39 | -19.05 | -8.71 | -2.21 | -1.72 | -12.21 | -12.21 | -12.21 | -12.21 | -12.21 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | 658.5 | -162.3 | -152.5 | 795.6 | 713.6 | 298.2 | 311.9 | 326.2 | 341.2 | 356.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 594.8 | -56.7 | 58.3 | 716.1 | 955.3 | 560.1 | 505.2 | 528.5 | 552.8 | 578.2 |
| WACC, % | 7.28 | 3.4 | 7.28 | 7.28 | 7.28 | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,260.2 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 581 | |||||||||
| Terminal Value | 9,675 | |||||||||
| Present Terminal Value | 7,059 | |||||||||
| Enterprise Value | 9,319 | |||||||||
| Net Debt | 1,233 | |||||||||
| Equity Value | 8,087 | |||||||||
| Diluted Shares Outstanding, MM | 55 | |||||||||
| Equity Value Per Share | 148.30 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real STNG financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Scorpio Tankers' valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive STNG Data: Loaded with Scorpio Tankers' historical financial performance and future projections.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures as needed.
- Dynamic Valuation Model: Automatically refreshes Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Analysis: Generate various forecasting scenarios to evaluate different valuation possibilities.
- User-Friendly Interface: Designed to be intuitive and accessible for both professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template with Scorpio Tankers Inc.'s (STNG) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Scorpio Tankers Inc.'s (STNG) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Scorpio Tankers Inc. (STNG)?
- Accurate Data: Up-to-date Scorpio Tankers financials guarantee trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the maritime industry.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Scorpio Tankers Inc. (STNG) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Scorpio Tankers Inc. (STNG).
- Consultants: Deliver professional valuation insights on Scorpio Tankers Inc. (STNG) to clients quickly and accurately.
- Business Owners: Understand how companies like Scorpio Tankers Inc. (STNG) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Scorpio Tankers Inc. (STNG).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Scorpio Tankers Inc. (STNG) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Scorpio Tankers Inc. (STNG).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.