TotalEnergies SE (TTE) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
TotalEnergies SE (TTE) Bundle
Explore TotalEnergies SE's (TTE) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate TotalEnergies SE's (TTE) intrinsic value and shape your investment approach.
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 | 176,249.0 | 119,704.0 | 184,634.0 | 263,310.0 | 218,945.0 | 245,176.0 | 274,549.7 | 307,442.5 | 344,276.1 | 385,522.6 |
Revenue Growth, % | 0 | -32.08 | 54.24 | 42.61 | -16.85 | 11.98 | 11.98 | 11.98 | 11.98 | 11.98 |
EBITDA | 31,832.0 | 8,847.0 | 37,842.0 | 59,133.0 | 50,782.0 | 44,915.6 | 50,296.8 | 56,322.7 | 63,070.5 | 70,626.8 |
EBITDA, % | 18.06 | 7.39 | 20.5 | 22.46 | 23.19 | 18.32 | 18.32 | 18.32 | 18.32 | 18.32 |
Depreciation | 15,716.0 | 14,262.0 | 13,585.0 | 11,892.0 | 13,818.0 | 19,131.9 | 21,424.0 | 23,990.8 | 26,865.0 | 30,083.6 |
Depreciation, % | 8.92 | 11.91 | 7.36 | 4.52 | 6.31 | 7.8 | 7.8 | 7.8 | 7.8 | 7.8 |
EBIT | 16,116.0 | -5,415.0 | 24,257.0 | 47,241.0 | 36,964.0 | 25,783.7 | 28,872.8 | 32,331.9 | 36,205.5 | 40,543.2 |
EBIT, % | 9.14 | -4.52 | 13.14 | 17.94 | 16.88 | 10.52 | 10.52 | 10.52 | 10.52 | 10.52 |
Total Cash | 31,344.0 | 35,898.0 | 33,657.0 | 41,772.0 | 33,428.0 | 47,629.8 | 53,336.2 | 59,726.2 | 66,881.8 | 74,894.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 34,253.0 | 25,753.0 | 55,327.0 | 59,120.0 | 42,801.0 | 55,368.3 | 62,001.8 | 69,430.0 | 77,748.2 | 87,062.9 |
Account Receivables, % | 19.43 | 21.51 | 29.97 | 22.45 | 19.55 | 22.58 | 22.58 | 22.58 | 22.58 | 22.58 |
Inventories | 17,132.0 | 14,730.0 | 19,952.0 | 22,936.0 | 19,317.0 | 24,696.8 | 27,655.6 | 30,968.9 | 34,679.2 | 38,834.0 |
Inventories, % | 9.72 | 12.31 | 10.81 | 8.71 | 8.82 | 10.07 | 10.07 | 10.07 | 10.07 | 10.07 |
Accounts Payable | 28,394.0 | 23,574.0 | 36,837.0 | 41,346.0 | 41,335.0 | 44,296.8 | 49,603.8 | 55,546.7 | 62,201.5 | 69,653.7 |
Accounts Payable, % | 16.11 | 19.69 | 19.95 | 15.7 | 18.88 | 18.07 | 18.07 | 18.07 | 18.07 | 18.07 |
Capital Expenditure | -11,810.0 | -10,764.0 | -12,343.0 | -15,690.0 | -17,722.0 | -17,864.1 | -20,004.3 | -22,400.9 | -25,084.7 | -28,090.0 |
Capital Expenditure, % | -6.7 | -8.99 | -6.69 | -5.96 | -8.09 | -7.29 | -7.29 | -7.29 | -7.29 | -7.29 |
Tax Rate, % | 38.57 | 38.57 | 38.57 | 38.57 | 38.57 | 38.57 | 38.57 | 38.57 | 38.57 | 38.57 |
EBITAT | 10,489.8 | -5,660.4 | 14,984.3 | 22,401.4 | 22,706.6 | 17,311.8 | 19,385.8 | 21,708.4 | 24,309.2 | 27,221.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -8,595.2 | 3,919.6 | -5,306.7 | 16,335.4 | 38,729.6 | 3,594.3 | 16,520.3 | 18,499.5 | 20,715.9 | 23,197.8 |
WACC, % | 6.61 | 7.03 | 6.57 | 6.4 | 6.57 | 6.63 | 6.63 | 6.63 | 6.63 | 6.63 |
PV UFCF | ||||||||||
SUM PV UFCF | 66,003.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 23,662 | |||||||||
Terminal Value | 510,597 | |||||||||
Present Terminal Value | 370,337 | |||||||||
Enterprise Value | 436,341 | |||||||||
Net Debt | 22,805 | |||||||||
Equity Value | 413,536 | |||||||||
Diluted Shares Outstanding, MM | 2,434 | |||||||||
Equity Value Per Share | 169.92 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real TotalEnergies SE (TTE) financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on TotalEnergies SE (TTE)’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Data: TotalEnergies’ historical financial reports and pre-filled projections.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: View TotalEnergies’ intrinsic value recalculating instantly.
- Visual Insights: Dashboard graphs showcase valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance specialists.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered TotalEnergies SE (TTE) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for TotalEnergies SE’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for TotalEnergies SE (TTE)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned users.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Feedback: Observe immediate updates to TotalEnergies' valuation as you tweak the inputs.
- Pre-Loaded Data: Comes with TotalEnergies' actual financial figures for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use TotalEnergies SE (TTE)?
- Investors: Make informed decisions with a comprehensive analysis of energy market trends.
- Energy Analysts: Streamline your research with detailed reports on TotalEnergies SE (TTE) performance.
- Consultants: Easily modify presentations and reports tailored to your clients' energy needs.
- Energy Enthusiasts: Enhance your knowledge of the energy sector through insightful case studies.
- Educators and Students: Utilize it as a valuable resource in energy-related academic programs.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled TotalEnergies SE (TTE) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for TotalEnergies SE (TTE).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.