Sasol Limited (SSL) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Sasol Limited (SSL) Bundle
Looking to assess the intrinsic value of Sasol Limited? Our (SSL) DCF Calculator integrates real-world data with extensive customization options, enabling you to adjust forecasts and enhance your investment decisions.
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.