Star Bulk Carriers Corp. (SBLK) 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
Star Bulk Carriers Corp. (SBLK) Bundle
Engineered for accuracy, our [SBLK] DCF Calculator empowers you to evaluate Star Bulk Carriers Corp. valuation using real-world financial data, while offering complete flexibility to modify all key parameters for enhanced 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 | 821.4 | 693.2 | 1,427.4 | 1,437.2 | 949.3 | 1,070.6 | 1,207.5 | 1,361.8 | 1,535.9 | 1,732.3 |
| Revenue Growth, % | 0 | -15.6 | 105.91 | 0.68186 | -33.95 | 12.78 | 12.78 | 12.78 | 12.78 | 12.78 |
| EBITDA | 193.7 | 211.3 | 888.9 | 785.5 | 405.2 | 457.5 | 516.0 | 582.0 | 656.4 | 740.3 |
| EBITDA, % | 23.59 | 30.48 | 62.27 | 54.66 | 42.69 | 42.74 | 42.74 | 42.74 | 42.74 | 42.74 |
| Depreciation | 122.3 | 141.1 | 152.5 | 156.7 | 138.4 | 152.9 | 172.5 | 194.5 | 219.4 | 247.4 |
| Depreciation, % | 14.89 | 20.35 | 10.68 | 10.91 | 14.58 | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 |
| EBIT | 71.5 | 70.2 | 736.5 | 628.8 | 266.8 | 304.6 | 343.6 | 387.5 | 437.0 | 492.9 |
| EBIT, % | 8.7 | 10.12 | 51.59 | 43.75 | 28.1 | 28.45 | 28.45 | 28.45 | 28.45 | 28.45 |
| Total Cash | 117.8 | 190.5 | 450.3 | 284.3 | 259.7 | 258.1 | 291.0 | 328.2 | 370.2 | 417.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 78.0 | 56.6 | 119.4 | 84.4 | 68.6 | 83.8 | 94.5 | 106.6 | 120.2 | 135.6 |
| Account Receivables, % | 9.5 | 8.17 | 8.36 | 5.88 | 7.23 | 7.83 | 7.83 | 7.83 | 7.83 | 7.83 |
| Inventories | 51.2 | 47.3 | 75.1 | 67.2 | 62.4 | 63.3 | 71.4 | 80.5 | 90.8 | 102.4 |
| Inventories, % | 6.23 | 6.82 | 5.26 | 4.67 | 6.57 | 5.91 | 5.91 | 5.91 | 5.91 | 5.91 |
| Accounts Payable | 42.8 | 32.9 | 21.8 | 32.1 | 39.3 | 38.2 | 43.1 | 48.6 | 54.8 | 61.9 |
| Accounts Payable, % | 5.21 | 4.74 | 1.53 | 2.24 | 4.14 | 3.57 | 3.57 | 3.57 | 3.57 | 3.57 |
| Capital Expenditure | -347.1 | -72.1 | -130.1 | -25.4 | -18.1 | -140.1 | -158.1 | -178.3 | -201.1 | -226.8 |
| Capital Expenditure, % | -42.26 | -10.39 | -9.12 | -1.77 | -1.91 | -13.09 | -13.09 | -13.09 | -13.09 | -13.09 |
| Tax Rate, % | 0.07082031 | 0.07082031 | 0.07082031 | 0.07082031 | 0.07082031 | 0.07082031 | 0.07082031 | 0.07082031 | 0.07082031 | 0.07082031 |
| EBITAT | 72.0 | 69.4 | 736.6 | 628.5 | 266.6 | 303.9 | 342.7 | 386.5 | 435.9 | 491.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -239.3 | 153.7 | 657.3 | 813.0 | 414.7 | 299.4 | 343.2 | 387.0 | 436.5 | 492.3 |
| WACC, % | 8.16 | 8.13 | 8.16 | 8.16 | 8.16 | 8.16 | 8.16 | 8.16 | 8.16 | 8.16 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,527.8 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 495 | |||||||||
| Terminal Value | 6,463 | |||||||||
| Present Terminal Value | 4,367 | |||||||||
| Enterprise Value | 5,895 | |||||||||
| Net Debt | 1,037 | |||||||||
| Equity Value | 4,858 | |||||||||
| Diluted Shares Outstanding, MM | 99 | |||||||||
| Equity Value Per Share | 49.10 |
What You Will Get
- Real SBLK Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Star Bulk Carriers' future performance.
- User-Friendly Design: Designed for industry professionals while remaining approachable for newcomers.
Key Features
- 🔍 Real-Life SBLK Financials: Pre-filled historical and projected data for Star Bulk Carriers Corp. (SBLK).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Star Bulk Carriers' intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Star Bulk Carriers' valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file containing Star Bulk Carriers Corp.'s (SBLK) financial data.
- 2. Modify Assumptions: Adjust key parameters such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Instantly: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
- 5. Present with Confidence: Share professional valuation insights to inform your strategic decisions.
Why Choose This Calculator for Star Bulk Carriers Corp. (SBLK)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for shipping industry assessments.
- Flexible Inputs: Modify yellow-highlighted cells to explore different operational scenarios.
- In-Depth Analysis: Automatically computes Star Bulk Carriers' intrinsic value and Net Present Value.
- Preloaded Information: Access to historical and projected data for accurate evaluations.
- High-Quality Standards: Perfect for maritime analysts, investors, and shipping consultants.
Who Should Use Star Bulk Carriers Corp. (SBLK)?
- Investors: Enhance your investment strategies with insights from a leading dry bulk shipping company.
- Financial Analysts: Streamline your analysis using comprehensive data on fleet performance and market trends.
- Consultants: Tailor your recommendations with detailed reports on the shipping sector and SBLK's position within it.
- Shipping Industry Enthusiasts: Expand your knowledge of maritime logistics and trading through real-time data and case studies.
- Educators and Students: Utilize SBLK's operational insights as a valuable resource in maritime economics and finance courses.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Star Bulk Carriers Corp. (SBLK).
- Real-World Data: Star Bulk Carriers' historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for in-depth insights.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Star Bulk Carriers Corp. (SBLK).
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for informed decision-making.