Global Ship Lease, Inc. (GSL) 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
Global Ship Lease, Inc. (GSL) Bundle
Engineered for accuracy, our (GSL) DCF Calculator enables you to assess Global Ship Lease, Inc. 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 | 261.1 | 282.8 | 402.5 | 604.5 | 666.7 | 694.3 | 723.0 | 752.9 | 784.1 | 816.5 |
| Revenue Growth, % | 0 | 8.32 | 42.33 | 50.17 | 10.29 | 4.14 | 4.14 | 4.14 | 4.14 | 4.14 |
| EBITDA | 160.7 | 153.4 | 302.3 | 449.5 | 441.5 | 460.3 | 479.3 | 499.1 | 519.8 | 541.3 |
| EBITDA, % | 61.54 | 54.24 | 75.11 | 74.36 | 66.22 | 66.29 | 66.29 | 66.29 | 66.29 | 66.29 |
| Depreciation | 45.8 | 46.4 | 61.6 | 81.3 | 91.7 | 106.2 | 110.6 | 115.2 | 119.9 | 124.9 |
| Depreciation, % | 17.56 | 16.42 | 15.29 | 13.45 | 13.76 | 15.3 | 15.3 | 15.3 | 15.3 | 15.3 |
| EBIT | 114.8 | 107.0 | 240.8 | 368.2 | 349.8 | 354.1 | 368.7 | 384.0 | 399.9 | 416.4 |
| EBIT, % | 43.98 | 37.82 | 59.82 | 60.91 | 52.46 | 51 | 51 | 51 | 51 | 51 |
| Total Cash | 138.0 | 80.8 | 75.2 | 128.7 | 209.4 | 212.2 | 220.9 | 230.1 | 239.6 | 249.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 7.9 | 4.8 | 12.4 | 19.4 | 5.4 | 16.4 | 17.1 | 17.8 | 18.5 | 19.3 |
| Account Receivables, % | 3.03 | 1.69 | 3.08 | 3.2 | 0.80499 | 2.36 | 2.36 | 2.36 | 2.36 | 2.36 |
| Inventories | 5.6 | 6.3 | 11.4 | 12.2 | 27.4 | 18.5 | 19.3 | 20.1 | 20.9 | 21.8 |
| Inventories, % | 2.14 | 2.23 | 2.83 | 2.02 | 4.11 | 2.67 | 2.67 | 2.67 | 2.67 | 2.67 |
| Accounts Payable | 8.1 | 9.4 | 7.9 | 19.1 | 14.9 | 19.1 | 19.9 | 20.8 | 21.6 | 22.5 |
| Accounts Payable, % | 3.1 | 3.33 | 1.96 | 3.16 | 2.23 | 2.76 | 2.76 | 2.76 | 2.76 | 2.76 |
| Capital Expenditure | -99.1 | -46.4 | -490.9 | -33.7 | -152.5 | -253.9 | -264.4 | -275.3 | -286.7 | -298.5 |
| Capital Expenditure, % | -37.95 | -16.42 | -121.95 | -5.57 | -22.87 | -36.56 | -36.56 | -36.56 | -36.56 | -36.56 |
| Tax Rate, % | 0.14691 | 0.14691 | 0.14691 | 0.14691 | 0.14691 | 0.14691 | 0.14691 | 0.14691 | 0.14691 | 0.14691 |
| EBITAT | 114.8 | 106.8 | 240.7 | 368.2 | 349.3 | 353.9 | 368.5 | 383.7 | 399.6 | 416.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 56.1 | 110.6 | -202.8 | 419.2 | 283.1 | 208.3 | 214.1 | 222.9 | 232.1 | 241.8 |
| WACC, % | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 871.0 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 243 | |||||||||
| Terminal Value | 2,948 | |||||||||
| Present Terminal Value | 1,939 | |||||||||
| Enterprise Value | 2,809 | |||||||||
| Net Debt | 617 | |||||||||
| Equity Value | 2,193 | |||||||||
| Diluted Shares Outstanding, MM | 36 | |||||||||
| Equity Value Per Share | 61.02 |
What You Will Get
- Pre-Filled Financial Model: Global Ship Lease, Inc. (GSL) data provides accurate DCF valuation insights.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers with ease.
- Instant Calculations: Real-time updates allow you to view results immediately as adjustments are made.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, enabling repeated application for comprehensive forecasts.
Key Features
- Customizable Shipping Metrics: Adjust essential inputs such as fleet utilization, charter rates, and operating expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other key financial outputs.
- Industry-Leading Precision: Incorporates Global Ship Lease’s (GSL) actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and analyze results with ease.
- Efficiency Enhancer: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file for Global Ship Lease, Inc. (GSL).
- Step 2: Review the pre-filled financial data and forecasts for Global Ship Lease, Inc. (GSL).
- Step 3: Modify key inputs such as charter rates, operating expenses, and capital expenditures (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the results and leverage the insights for your investment decisions regarding Global Ship Lease, Inc. (GSL).
Why Choose This Calculator for Global Ship Lease, Inc. (GSL)?
- Accuracy: Utilizes real financial data from Global Ship Lease for precise calculations.
- Flexibility: Tailored for users to easily adjust and experiment with various inputs.
- Time-Saving: Avoid the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Simple to navigate, suitable for all users, regardless of financial modeling experience.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Global Ship Lease, Inc. (GSL) stock.
- Financial Analysts: Enhance valuation processes with ready-to-use financial models tailored for Global Ship Lease, Inc. (GSL).
- Consultants: Provide clients with professional valuation insights on Global Ship Lease, Inc. (GSL) quickly and accurately.
- Business Owners: Gain insights into how shipping companies like Global Ship Lease, Inc. (GSL) are valued to inform your own business strategy.
- Finance Students: Explore valuation techniques using real-world data and scenarios related to Global Ship Lease, Inc. (GSL).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Global Ship Lease, Inc. (GSL) 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 Global Ship Lease, Inc. (GSL).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.