|
Valoración de DCF Borr Drilling Limited (Borr)
BM | Energy | Oil & Gas Drilling | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Borr Drilling Limited (BORR) Bundle
¡Simplifique la valoración de Borr Drilling Limited (Borr) con esta calculadora DCF personalizable! Con las finanzas de Real Borr Drilling Limited (Borr) y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Borr Drilling Limited (Borr) en minutos.
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 | 334.1 | 307.5 | 245.3 | 443.8 | 771.6 | 1,015.8 | 1,337.3 | 1,760.5 | 2,317.7 | 3,051.2 |
| Revenue Growth, % | 0 | -7.96 | -20.23 | 80.92 | 73.86 | 31.65 | 31.65 | 31.65 | 31.65 | 31.65 |
| EBITDA | -72.2 | -105.3 | 29.2 | -2.0 | 361.2 | 4.9 | 6.4 | 8.5 | 11.1 | 14.6 |
| EBITDA, % | -21.62 | -34.25 | 11.9 | -0.45065 | 46.82 | 0.48005 | 0.48005 | 0.48005 | 0.48005 | 0.48005 |
| Depreciation | 121.8 | 129.6 | 116.5 | 114.3 | 121.8 | 340.6 | 448.3 | 590.2 | 777.0 | 1,023.0 |
| Depreciation, % | 36.46 | 42.15 | 47.48 | 25.75 | 15.79 | 33.53 | 33.53 | 33.53 | 33.53 | 33.53 |
| EBIT | -194.0 | -235.0 | -87.3 | -116.3 | 239.4 | -335.7 | -441.9 | -581.8 | -765.9 | -1,008.3 |
| EBIT, % | -58.08 | -76.41 | -35.58 | -26.2 | 31.03 | -33.05 | -33.05 | -33.05 | -33.05 | -33.05 |
| Total Cash | 59.1 | 19.2 | 34.9 | 108.0 | 102.5 | 154.0 | 202.7 | 266.8 | 351.3 | 462.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 116.1 | 82.3 | 99.9 | 170.6 | 255.9 | 353.2 | 465.0 | 612.1 | 805.8 | 1,060.9 |
| Account Receivables, % | 34.75 | 26.76 | 40.73 | 38.44 | 33.16 | 34.77 | 34.77 | 34.77 | 34.77 | 34.77 |
| Inventories | 102.2 | 18.1 | 27.1 | 50.5 | .0 | 119.7 | 157.5 | 207.4 | 273.0 | 359.4 |
| Inventories, % | 30.59 | 5.89 | 11.05 | 11.38 | 0 | 11.78 | 11.78 | 11.78 | 11.78 | 11.78 |
| Accounts Payable | 14.1 | 20.4 | 34.7 | 47.7 | 35.5 | 82.0 | 107.9 | 142.1 | 187.0 | 246.2 |
| Accounts Payable, % | 4.22 | 6.63 | 14.15 | 10.75 | 4.6 | 8.07 | 8.07 | 8.07 | 8.07 | 8.07 |
| Capital Expenditure | -271.6 | -42.4 | -18.9 | -83.3 | -114.0 | -277.0 | -364.6 | -480.0 | -631.9 | -831.9 |
| Capital Expenditure, % | -81.29 | -13.79 | -7.7 | -18.77 | -14.77 | -27.27 | -27.27 | -27.27 | -27.27 | -27.27 |
| Tax Rate, % | 60.61 | 60.61 | 60.61 | 60.61 | 60.61 | 60.61 | 60.61 | 60.61 | 60.61 | 60.61 |
| EBITAT | -201.4 | -248.1 | -91.9 | -124.1 | 94.3 | -295.0 | -388.4 | -511.3 | -673.1 | -886.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -555.3 | -36.7 | -6.6 | -174.2 | 55.1 | -401.9 | -428.3 | -563.9 | -742.4 | -977.3 |
| WACC, % | 12.76 | 12.76 | 12.76 | 12.76 | 8.41 | 11.89 | 11.89 | 11.89 | 11.89 | 11.89 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -2,134.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -997 | |||||||||
| Terminal Value | -10,076 | |||||||||
| Present Terminal Value | -5,745 | |||||||||
| Enterprise Value | -7,879 | |||||||||
| Net Debt | 1,600 | |||||||||
| Equity Value | -9,479 | |||||||||
| Diluted Shares Outstanding, MM | 248 | |||||||||
| Equity Value Per Share | -38.20 |
What You Will Get
- Authentic Borr Drilling Data: Preloaded financials – including revenue and EBIT – derived from actual and projected figures.
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to evaluate the effects of changes on Borr Drilling’s fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and detailed forecasts.
- Efficient and Precise: Avoid the hassle of building models from the ground up while ensuring accuracy and adaptability.
Key Features
- Comprehensive BORR Data: Pre-loaded with Borr Drilling's historical performance and future projections.
- Customizable Parameters: Modify drilling rates, operational costs, revenue forecasts, and investment strategies.
- Interactive Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation results.
- User-Centric Interface: Intuitive, well-structured, catering to both industry experts and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based BORR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Borr Drilling's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the findings to inform your investment or financial analysis.
Why Choose Borr Drilling Limited (BORR) Calculator?
- Accuracy: Utilizes real Borr Drilling financials for precise data representation.
- Flexibility: Tailored for users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Finance Students: Master valuation methods and practice with real market data for Borr Drilling Limited (BORR).
- Academics: Integrate industry-standard models into your research or teaching materials.
- Investors: Validate your investment hypotheses and evaluate valuation results for Borr Drilling Limited (BORR).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for Borr Drilling Limited (BORR).
- Small Business Owners: Understand the valuation techniques used for larger public entities like Borr Drilling Limited (BORR).
What the Template Contains
- Preloaded BORR Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.