|
Valoración de DCF de shell plc (shel)
GB | Energy | Oil & Gas Integrated | 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
Shell plc (SHEL) Bundle
¡Descubra el verdadero potencial de Shell PLC (Shel) con nuestra calculadora DCF avanzada! Ajuste los supuestos cruciales, explore varios escenarios y evalúe cómo los diferentes factores influyen en la valoración del plc (shel), todo dentro de una plantilla integral de Excel.
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 | 344,877.0 | 180,543.0 | 261,504.0 | 381,314.0 | 316,620.0 | 337,234.1 | 359,190.3 | 382,576.0 | 407,484.3 | 434,014.3 |
| Revenue Growth, % | 0 | -47.65 | 44.84 | 45.82 | -16.97 | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 |
| EBITDA | 58,744.0 | 29,534.0 | 54,362.0 | 86,596.0 | 68,545.0 | 66,461.3 | 70,788.4 | 75,397.2 | 80,306.1 | 85,534.5 |
| EBITDA, % | 17.03 | 16.36 | 20.79 | 22.71 | 21.65 | 19.71 | 19.71 | 19.71 | 19.71 | 19.71 |
| Depreciation | 28,701.0 | 52,444.0 | 26,921.0 | 18,529.0 | 31,290.0 | 42,091.2 | 44,831.6 | 47,750.4 | 50,859.3 | 54,170.6 |
| Depreciation, % | 8.32 | 29.05 | 10.29 | 4.86 | 9.88 | 12.48 | 12.48 | 12.48 | 12.48 | 12.48 |
| EBIT | 30,043.0 | -22,910.0 | 27,441.0 | 68,067.0 | 37,255.0 | 24,370.1 | 25,956.8 | 27,646.8 | 29,446.7 | 31,363.9 |
| EBIT, % | 8.71 | -12.69 | 10.49 | 17.85 | 11.77 | 7.23 | 7.23 | 7.23 | 7.23 | 7.23 |
| Total Cash | 18,054.0 | 31,830.0 | 36,971.0 | 40,246.0 | 38,774.0 | 40,335.7 | 42,961.8 | 45,758.9 | 48,738.1 | 51,911.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 50,563.0 | 39,408.0 | 34,945.0 | 39,540.0 | .0 | 40,617.2 | 43,261.7 | 46,078.3 | 49,078.3 | 52,273.7 |
| Account Receivables, % | 14.66 | 21.83 | 13.36 | 10.37 | 0 | 12.04 | 12.04 | 12.04 | 12.04 | 12.04 |
| Inventories | 24,071.0 | 19,457.0 | 25,258.0 | 31,894.0 | 26,019.0 | 29,674.7 | 31,606.8 | 33,664.6 | 35,856.4 | 38,190.9 |
| Inventories, % | 6.98 | 10.78 | 9.66 | 8.36 | 8.22 | 8.8 | 8.8 | 8.8 | 8.8 | 8.8 |
| Accounts Payable | 29,497.0 | 22,664.0 | 34,136.0 | 42,632.0 | 34,591.0 | 37,949.1 | 40,419.9 | 43,051.5 | 45,854.4 | 48,839.8 |
| Accounts Payable, % | 8.55 | 12.55 | 13.05 | 11.18 | 10.93 | 11.25 | 11.25 | 11.25 | 11.25 | 11.25 |
| Capital Expenditure | -22,971.0 | -16,585.0 | -19,000.0 | -22,600.0 | -22,993.0 | -24,484.1 | -26,078.2 | -27,776.1 | -29,584.5 | -31,510.6 |
| Capital Expenditure, % | -6.66 | -9.19 | -7.27 | -5.93 | -7.26 | -7.26 | -7.26 | -7.26 | -7.26 | -7.26 |
| Tax Rate, % | 40.67 | 40.67 | 40.67 | 40.67 | 40.67 | 40.67 | 40.67 | 40.67 | 40.67 | 40.67 |
| EBITAT | 18,675.8 | -18,294.2 | 18,491.8 | 44,432.5 | 22,105.0 | 16,280.0 | 17,339.9 | 18,468.9 | 19,671.3 | 20,952.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -20,731.2 | 26,500.8 | 36,546.8 | 37,626.5 | 67,776.0 | -7,027.8 | 33,987.6 | 36,200.4 | 38,557.3 | 41,067.6 |
| WACC, % | 6.23 | 6.39 | 6.28 | 6.26 | 6.2 | 6.27 | 6.27 | 6.27 | 6.27 | 6.27 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 114,172.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 41,889 | |||||||||
| Terminal Value | 980,703 | |||||||||
| Present Terminal Value | 723,531 | |||||||||
| Enterprise Value | 837,704 | |||||||||
| Net Debt | 42,767 | |||||||||
| Equity Value | 794,937 | |||||||||
| Diluted Shares Outstanding, MM | 6,800 | |||||||||
| Equity Value Per Share | 116.91 |
What You Will Get
- Real SHEL Financial Data: Pre-filled with Shell plc’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Shell plc’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Shell Financials: Gain access to reliable pre-loaded historical data and future forecasts for Shell plc (SHEL).
- Adjustable Forecast Inputs: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: Intuitive charts and summaries to help visualize your valuation findings.
- Suitable for All Skill Levels: A user-friendly layout designed for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Shell plc’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- Step 5: Evaluate the outputs and utilize the findings for investment decisions.
Why Choose This Calculator for Shell plc (SHEL)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust variables easily to suit your financial analysis.
- Real-Time Feedback: Observe immediate changes to Shell’s valuation as you modify inputs.
- Preloaded Data: Comes with Shell’s current financial figures for swift assessments.
- Relied Upon by Experts: Utilized by investors and analysts to guide strategic decisions.
Who Should Use This Product?
- Investors: Evaluate Shell plc’s (SHEL) market performance prior to making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Gain insights into how leading energy companies like Shell plc are valued.
- Consultants: Provide detailed valuation reports to enhance client offerings.
- Students and Educators: Utilize current market data to learn and teach valuation practices.
What the Template Contains
- Historical Data: Includes Shell plc’s (SHEL) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Shell plc’s (SHEL) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Shell plc’s (SHEL) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.