International Seaways, Inc. (INSW) 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
International Seaways, Inc. (INSW) Bundle
Discover the true value of International Seaways, Inc. (INSW) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and examine how changes affect International Seaways, Inc. (INSW) valuation – all within one easy-to-use Excel template.
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 | 366.2 | 421.6 | 272.5 | 864.7 | 1,071.8 | 1,349.7 | 1,699.8 | 2,140.6 | 2,695.8 | 3,394.9 |
Revenue Growth, % | 0 | 15.15 | -35.36 | 217.25 | 23.95 | 25.93 | 25.93 | 25.93 | 25.93 | 25.93 |
EBITDA | 138.7 | 100.9 | -17.5 | 558.2 | 744.4 | 511.2 | 643.8 | 810.7 | 1,021.0 | 1,285.8 |
EBITDA, % | 37.87 | 23.92 | -6.43 | 64.56 | 69.45 | 37.87 | 37.87 | 37.87 | 37.87 | 37.87 |
Depreciation | 75.7 | 74.3 | 89.1 | 111.2 | 129.0 | 258.8 | 326.0 | 410.5 | 517.0 | 651.1 |
Depreciation, % | 20.66 | 17.63 | 32.69 | 12.86 | 12.04 | 19.18 | 19.18 | 19.18 | 19.18 | 19.18 |
EBIT | 63.0 | 26.5 | -106.6 | 447.0 | 615.3 | 252.4 | 317.8 | 400.2 | 504.0 | 634.7 |
EBIT, % | 17.21 | 6.29 | -39.12 | 51.69 | 57.41 | 18.7 | 18.7 | 18.7 | 18.7 | 18.7 |
Total Cash | 89.7 | 199.4 | 97.9 | 323.7 | 186.8 | 438.8 | 552.6 | 695.9 | 876.4 | 1,103.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 87.8 | 47.8 | 112.7 | 302.4 | 261.5 | 367.3 | 462.5 | 582.5 | 733.5 | 923.8 |
Account Receivables, % | 23.97 | 11.35 | 41.37 | 34.97 | 24.4 | 27.21 | 27.21 | 27.21 | 27.21 | 27.21 |
Inventories | 3.9 | 3.6 | 2.1 | .5 | 1.3 | 7.8 | 9.8 | 12.3 | 15.5 | 19.5 |
Inventories, % | 1.06 | 0.85403 | 0.77418 | 0.06141107 | 0.124 | 0.57551 | 0.57551 | 0.57551 | 0.57551 | 0.57551 |
Accounts Payable | 5.0 | 2.6 | 1.6 | 1.8 | 6.6 | 9.2 | 11.5 | 14.5 | 18.3 | 23.0 |
Accounts Payable, % | 1.36 | 0.61876 | 0.58963 | 0.21118 | 0.613 | 0.67895 | 0.67895 | 0.67895 | 0.67895 | 0.67895 |
Capital Expenditure | -37.2 | -50.6 | -79.0 | -116.7 | -206.6 | -226.5 | -285.3 | -359.2 | -452.4 | -569.7 |
Capital Expenditure, % | -10.15 | -11.99 | -28.99 | -13.49 | -19.28 | -16.78 | -16.78 | -16.78 | -16.78 | -16.78 |
Tax Rate, % | 0.6921 | 0.6921 | 0.6921 | 0.6921 | 0.6921 | 0.6921 | 0.6921 | 0.6921 | 0.6921 | 0.6921 |
EBITAT | 63.1 | 26.5 | -107.9 | 446.9 | 611.1 | 252.0 | 317.3 | 399.7 | 503.3 | 633.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 14.9 | 88.2 | -162.2 | 253.6 | 578.3 | 174.7 | 263.2 | 331.4 | 417.4 | 525.6 |
WACC, % | 6.41 | 6.41 | 6.41 | 6.41 | 6.39 | 6.41 | 6.41 | 6.41 | 6.41 | 6.41 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,382.6 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 528 | |||||||||
Terminal Value | 8,941 | |||||||||
Present Terminal Value | 6,554 | |||||||||
Enterprise Value | 7,936 | |||||||||
Net Debt | 618 | |||||||||
Equity Value | 7,318 | |||||||||
Diluted Shares Outstanding, MM | 49 | |||||||||
Equity Value Per Share | 148.06 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real INSW 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 the impact of your inputs on International Seaways, Inc.'s 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
- Real-Time INSW Data: Pre-loaded with International Seaways’ historical performance metrics and future outlooks.
- Comprehensive Customization Options: Modify revenue growth rates, profit margins, discount rates, tax considerations, and capital investments.
- Interactive Valuation Framework: Automatically refreshes Net Present Value (NPV) and intrinsic value in response to your adjustments.
- Scenario Analysis: Generate various forecasting scenarios to explore different valuation possibilities.
- Intuitive User Interface: Designed for ease of use, catering to both seasoned professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template featuring International Seaways, Inc. (INSW) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view updated results, including the intrinsic value of International Seaways, Inc. (INSW).
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for International Seaways, Inc. (INSW)?
- User-Friendly Interface: Crafted for both novice users and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis needs.
- Real-Time Valuation: Observe immediate updates to International Seaways’ valuation as you modify inputs.
- Preloaded Data: Comes with International Seaways’ actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making strategic decisions.
Who Should Use International Seaways, Inc. (INSW)?
- Investors: Gain insights into the maritime transportation sector with a reliable investment tool.
- Financial Analysts: Streamline your analysis with comprehensive data and metrics specific to the shipping industry.
- Consultants: Effortlessly tailor reports and presentations for clients in the logistics and shipping fields.
- Maritime Enthusiasts: Enhance your knowledge of the shipping market through detailed performance analysis.
- Educators and Students: Utilize it as a resource for understanding maritime economics in academic settings.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled International Seaways, Inc. (INSW) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models displaying intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for International Seaways, Inc. (INSW).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify result analysis.