|
Valoración de DCF Sasol Limited (SSL)
ZA | Basic Materials | Chemicals - Specialty | 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
Sasol Limited (SSL) Bundle
¿Busca evaluar el valor intrínseco de Sasol Limited? Nuestra calculadora DCF (SSL) integra datos del mundo real con amplias opciones de personalización, lo que le permite ajustar los pronósticos y mejorar sus decisiones de inversión.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 10,197.8 | 10,816.1 | 14,610.7 | 15,518.7 | 14,737.4 | 16,296.9 | 18,021.4 | 19,928.3 | 22,037.1 | 24,368.9 |
| Revenue Growth, % | 0 | 6.06 | 35.08 | 6.21 | -5.03 | 10.58 | 10.58 | 10.58 | 10.58 | 10.58 |
| EBITDA | 1,907.1 | 2,319.0 | 2,319.0 | 3,453.7 | 3,100.5 | 3,236.8 | 3,579.3 | 3,958.0 | 4,376.9 | 4,840.0 |
| EBITDA, % | 18.7 | 21.44 | 15.87 | 22.26 | 21.04 | 19.86 | 19.86 | 19.86 | 19.86 | 19.86 |
| Depreciation | 962.5 | 1,209.3 | 945.2 | 753.9 | 707.9 | 1,197.8 | 1,324.5 | 1,464.7 | 1,619.7 | 1,791.1 |
| Depreciation, % | 9.44 | 11.18 | 6.47 | 4.86 | 4.8 | 7.35 | 7.35 | 7.35 | 7.35 | 7.35 |
| EBIT | 944.6 | 1,109.7 | 1,373.8 | 2,699.8 | 2,392.7 | 2,039.0 | 2,254.7 | 2,493.3 | 2,757.2 | 3,048.9 |
| EBIT, % | 9.26 | 10.26 | 9.4 | 17.4 | 16.24 | 12.51 | 12.51 | 12.51 | 12.51 | 12.51 |
| Total Cash | 1,860.9 | 1,673.0 | 2,311.0 | 2,888.8 | 2,547.5 | 2,784.6 | 3,079.3 | 3,405.1 | 3,765.4 | 4,163.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,530.9 | 959.3 | 1,255.7 | 1,731.1 | 1,470.1 | 1,747.2 | 1,932.1 | 2,136.5 | 2,362.6 | 2,612.6 |
| Account Receivables, % | 15.01 | 8.87 | 8.59 | 11.16 | 9.98 | 10.72 | 10.72 | 10.72 | 10.72 | 10.72 |
| Inventories | 1,489.3 | 1,593.3 | 2,202.2 | 2,260.9 | 2,181.3 | 2,404.7 | 2,659.1 | 2,940.5 | 3,251.6 | 3,595.7 |
| Inventories, % | 14.6 | 14.73 | 15.07 | 14.57 | 14.8 | 14.76 | 14.76 | 14.76 | 14.76 | 14.76 |
| Accounts Payable | 725.1 | 725.1 | 921.2 | 1,409.5 | 1,337.7 | 1,247.6 | 1,379.6 | 1,525.6 | 1,687.1 | 1,865.6 |
| Accounts Payable, % | 7.11 | 6.7 | 6.31 | 9.08 | 9.08 | 7.66 | 7.66 | 7.66 | 7.66 | 7.66 |
| Capital Expenditure | -1,882.7 | -877.0 | -1,239.7 | -1,646.0 | -1,615.6 | -1,845.6 | -2,040.9 | -2,256.8 | -2,495.6 | -2,759.7 |
| Capital Expenditure, % | -18.46 | -8.11 | -8.48 | -10.61 | -10.96 | -11.32 | -11.32 | -11.32 | -11.32 | -11.32 |
| Tax Rate, % | -28.3 | -28.3 | -28.3 | -28.3 | -28.3 | -28.3 | -28.3 | -28.3 | -28.3 | -28.3 |
| EBITAT | 732.6 | 935.2 | 963.6 | 1,636.7 | 3,069.8 | 1,601.0 | 1,770.4 | 1,957.7 | 2,164.9 | 2,394.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -2,482.7 | 1,735.2 | -40.1 | 698.8 | 2,431.0 | 362.6 | 746.8 | 825.8 | 913.2 | 1,009.8 |
| WACC, % | 8.36 | 8.72 | 7.95 | 7.43 | 9.58 | 8.41 | 8.41 | 8.41 | 8.41 | 8.41 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,953.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,030 | |||||||||
| Terminal Value | 16,072 | |||||||||
| Present Terminal Value | 10,734 | |||||||||
| Enterprise Value | 13,687 | |||||||||
| Net Debt | 4,809 | |||||||||
| Equity Value | 8,878 | |||||||||
| Diluted Shares Outstanding, MM | 633 | |||||||||
| Equity Value Per Share | 14.03 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled financial data for Sasol Limited (SSL).
- Accurate Financial Data: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect the valuation of Sasol Limited (SSL).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Interface: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- 🔍 Real-Life SSL Financials: Pre-filled historical and projected data for Sasol Limited (SSL).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Sasol’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Sasol’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Model: Download and open the Excel template featuring Sasol Limited's (SSL) financial data.
- 2. Adjust Variables: Modify essential parameters such as production rates, operating costs, and capital investments.
- 3. Analyze Results Immediately: The DCF model automatically computes the intrinsic value and NPV for Sasol Limited (SSL).
- 4. Explore Scenarios: Evaluate various projections to understand different valuation results for Sasol Limited (SSL).
- 5. Present with Assurance: Deliver expert valuation analysis to bolster your strategic decisions regarding Sasol Limited (SSL).
Why Choose This Calculator for Sasol Limited (SSL)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Sasol’s valuation as you change inputs.
- Preloaded Data: Comes equipped with Sasol’s latest financial information for swift evaluations.
- Relied Upon by Experts: Endorsed by investors and analysts for making strategic choices.
Who Should Use This Product?
- Finance Students: Explore valuation methodologies and apply them to real-world data for Sasol Limited (SSL).
- Academics: Integrate industry-standard models into your teaching or research involving Sasol Limited (SSL).
- Investors: Validate your investment hypotheses and evaluate valuation scenarios for Sasol Limited (SSL) stock.
- Analysts: Enhance your analysis process with a customizable DCF model tailored for Sasol Limited (SSL).
- Small Business Owners: Understand the analytical approaches used for large corporations like Sasol Limited (SSL).
What the Template Contains
- Pre-Filled DCF Model: Sasol Limited’s (SSL) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Sasol Limited’s (SSL) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.