Kosmos Energy Ltd. (KOS) 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
Kosmos Energy Ltd. (KOS) Bundle
Evaluate Kosmos Energy Ltd.'s financial outlook like an expert! This (KOS) DCF Calculator provides pre-filled financial data and allows you the freedom 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 | 1,499.4 | 804.0 | 1,332.0 | 2,245.4 | 1,701.6 | 1,972.3 | 2,286.1 | 2,649.9 | 3,071.5 | 3,560.2 |
| Revenue Growth, % | 0 | -46.38 | 65.67 | 68.57 | -24.22 | 15.91 | 15.91 | 15.91 | 15.91 | 15.91 |
| EBITDA | 717.6 | 175.7 | 531.6 | 938.1 | 898.7 | 805.5 | 933.7 | 1,082.3 | 1,254.5 | 1,454.0 |
| EBITDA, % | 47.86 | 21.85 | 39.91 | 41.78 | 52.81 | 40.84 | 40.84 | 40.84 | 40.84 | 40.84 |
| Depreciation | 563.9 | 485.9 | 467.2 | 498.3 | 444.9 | 715.8 | 829.6 | 961.6 | 1,114.6 | 1,292.0 |
| Depreciation, % | 37.61 | 60.43 | 35.08 | 22.19 | 26.15 | 36.29 | 36.29 | 36.29 | 36.29 | 36.29 |
| EBIT | 153.7 | -310.2 | 64.4 | 439.9 | 453.7 | 89.8 | 104.1 | 120.6 | 139.8 | 162.1 |
| EBIT, % | 10.25 | -38.58 | 4.84 | 19.59 | 26.66 | 4.55 | 4.55 | 4.55 | 4.55 | 4.55 |
| Total Cash | 224.5 | 149.0 | 131.6 | 183.4 | 95.3 | 225.5 | 261.4 | 302.9 | 351.1 | 407.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 174.3 | 78.8 | 177.5 | 119.7 | 120.7 | 186.1 | 215.7 | 250.1 | 289.8 | 336.0 |
| Account Receivables, % | 11.62 | 9.8 | 13.33 | 5.33 | 7.1 | 9.44 | 9.44 | 9.44 | 9.44 | 9.44 |
| Inventories | 114.4 | 129.0 | 165.2 | 133.5 | 152.1 | 201.0 | 233.0 | 270.1 | 313.0 | 362.8 |
| Inventories, % | 7.63 | 16.04 | 12.41 | 5.95 | 8.94 | 10.19 | 10.19 | 10.19 | 10.19 | 10.19 |
| Accounts Payable | 149.5 | 221.4 | 184.4 | 212.3 | 248.9 | 297.6 | 344.9 | 399.8 | 463.4 | 537.1 |
| Accounts Payable, % | 9.97 | 27.54 | 13.84 | 9.45 | 14.63 | 15.09 | 15.09 | 15.09 | 15.09 | 15.09 |
| Capital Expenditure | -352.0 | -379.6 | -938.0 | -809.4 | -932.6 | -915.0 | -1,060.6 | -1,229.3 | -1,424.9 | -1,651.6 |
| Capital Expenditure, % | -23.48 | -47.21 | -70.42 | -36.05 | -54.81 | -46.39 | -46.39 | -46.39 | -46.39 | -46.39 |
| Tax Rate, % | 42.56 | 42.56 | 42.56 | 42.56 | 42.56 | 42.56 | 42.56 | 42.56 | 42.56 | 42.56 |
| EBITAT | -341.4 | -306.3 | 115.6 | 295.6 | 260.6 | 58.1 | 67.3 | 78.0 | 90.4 | 104.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -268.7 | -47.2 | -527.2 | 101.9 | -210.0 | -206.9 | -177.9 | -206.2 | -239.0 | -277.0 |
| WACC, % | 6.31 | 8.97 | 9 | 8.12 | 7.86 | 8.05 | 8.05 | 8.05 | 8.05 | 8.05 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -870.7 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -288 | |||||||||
| Terminal Value | -7,111 | |||||||||
| Present Terminal Value | -4,828 | |||||||||
| Enterprise Value | -5,699 | |||||||||
| Net Debt | 2,296 | |||||||||
| Equity Value | -7,995 | |||||||||
| Diluted Shares Outstanding, MM | 481 | |||||||||
| Equity Value Per Share | -16.62 |
What You Will Receive
- Comprehensive Financial Model: Kosmos Energy Ltd.’s actual data provides accurate DCF valuation.
- Full Control Over Forecasts: Modify revenue growth, profit margins, WACC, and other critical factors.
- Real-Time Calculations: Instant updates allow you to view results as you adjust inputs.
- Professional-Grade Template: An expertly crafted Excel file tailored for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Real-Life KOS Data: Pre-filled with Kosmos Energy’s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, margins, WACC, tax rates, and capital expenditures as needed.
- Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop multiple forecast scenarios to evaluate various valuation possibilities.
- User-Friendly Design: Intuitive, organized, and suitable for both professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Kosmos Energy Ltd. (KOS) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Kosmos Energy Ltd. (KOS)'s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Kosmos Energy Ltd. (KOS)?
- User-Friendly Interface: Tailored for both novices and seasoned analysts.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Adjustments: Observe immediate changes in Kosmos Energy’s valuation as you modify inputs.
- Preloaded Data: Comes with Kosmos Energy’s actual financial figures for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing Kosmos Energy Ltd. (KOS) portfolios.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Kosmos Energy Ltd. (KOS).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Energy Sector Enthusiasts: Gain insights into how energy companies like Kosmos Energy Ltd. (KOS) are valued in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Kosmos Energy Ltd. (KOS) 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 illustrating 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 Kosmos Energy Ltd. (KOS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.