Equitable Holdings, Inc. (EQH) 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
Equitable Holdings, Inc. (EQH) Bundle
Designed for accuracy, our (EQH) DCF Calculator enables you to evaluate Equitable Holdings, Inc. valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved projections.
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 | 9,591.0 | 12,415.0 | 11,036.0 | 12,644.0 | 10,528.0 | 10,953.6 | 11,396.5 | 11,857.3 | 12,336.7 | 12,835.4 |
Revenue Growth, % | 0 | 29.44 | -11.11 | 14.57 | -16.74 | 4.04 | 4.04 | 4.04 | 4.04 | 4.04 |
EBITDA | -1,164.0 | 864.0 | 572.0 | 3,829.0 | 1,778.0 | 1,033.5 | 1,075.3 | 1,118.8 | 1,164.0 | 1,211.1 |
EBITDA, % | -12.14 | 6.96 | 5.18 | 30.28 | 16.89 | 9.44 | 9.44 | 9.44 | 9.44 | 9.44 |
Depreciation | 675.0 | 1,757.0 | 497.0 | 636.0 | 812.0 | 842.0 | 876.1 | 911.5 | 948.4 | 986.7 |
Depreciation, % | 7.04 | 14.15 | 4.5 | 5.03 | 7.71 | 7.69 | 7.69 | 7.69 | 7.69 | 7.69 |
EBIT | -1,839.0 | -893.0 | 75.0 | 3,193.0 | 966.0 | 191.5 | 199.2 | 207.3 | 215.7 | 224.4 |
EBIT, % | -19.17 | -7.19 | 0.67959 | 25.25 | 9.18 | 1.75 | 1.75 | 1.75 | 1.75 | 1.75 |
Total Cash | 4,405.0 | 88,206.0 | 5,188.0 | 4,281.0 | 9,412.0 | 6,927.0 | 7,207.1 | 7,498.4 | 7,801.6 | 8,117.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | 11,590.0 | .0 | 2,008.1 | 2,089.3 | 2,173.8 | 2,261.7 | 2,353.1 |
Account Receivables, % | 0 | 0 | 0 | 91.66 | 0 | 18.33 | 18.33 | 18.33 | 18.33 | 18.33 |
Inventories | -14,218.0 | -21,337.0 | -27,639.0 | 51,797.0 | .0 | -4,381.5 | -4,558.6 | -4,742.9 | -4,934.7 | -5,134.2 |
Inventories, % | -148.24 | -171.86 | -250.44 | 409.66 | 0 | -40 | -40 | -40 | -40 | -40 |
Accounts Payable | 2,126.0 | 2,824.0 | 2,664.0 | 2,248.0 | 2,682.0 | 2,460.3 | 2,559.8 | 2,663.3 | 2,771.0 | 2,883.0 |
Accounts Payable, % | 22.17 | 22.75 | 24.14 | 17.78 | 25.47 | 22.46 | 22.46 | 22.46 | 22.46 | 22.46 |
Capital Expenditure | -93.0 | -107.0 | -120.0 | -167.0 | -117.0 | -117.2 | -122.0 | -126.9 | -132.0 | -137.4 |
Capital Expenditure, % | -0.96966 | -0.86186 | -1.09 | -1.32 | -1.11 | -1.07 | -1.07 | -1.07 | -1.07 | -1.07 |
Tax Rate, % | -76.42 | -76.42 | -76.42 | -76.42 | -76.42 | -76.42 | -76.42 | -76.42 | -76.42 | -76.42 |
EBITAT | -1,297.7 | -285.1 | 10.7 | 2,297.6 | 1,704.2 | 110.6 | 115.0 | 119.7 | 124.5 | 129.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 15,628.3 | 9,181.9 | 6,529.7 | -88,675.4 | 66,220.2 | 2,987.0 | 1,064.6 | 1,107.6 | 1,152.4 | 1,199.0 |
WACC, % | 9.39 | 8.98 | 8.79 | 9.41 | 9.71 | 9.25 | 9.25 | 9.25 | 9.25 | 9.25 |
PV UFCF | ||||||||||
SUM PV UFCF | 6,054.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,223 | |||||||||
Terminal Value | 16,859 | |||||||||
Present Terminal Value | 10,831 | |||||||||
Enterprise Value | 16,885 | |||||||||
Net Debt | -4,454 | |||||||||
Equity Value | 21,339 | |||||||||
Diluted Shares Outstanding, MM | 352 | |||||||||
Equity Value Per Share | 60.69 |
What You Will Get
- Real EQH Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Equitable Holdings' future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- 🔍 Real-Life EQH Financials: Pre-filled historical and projected data for Equitable Holdings, Inc. (EQH).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Equitable's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Equitable'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 Template: Download and open the Excel file containing Equitable Holdings, Inc.'s preloaded data.
- 2. Adjust Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV for Equitable Holdings, Inc. (EQH).
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation outcomes for Equitable Holdings, Inc. (EQH).
- 5. Utilize with Assurance: Present professional valuation insights to bolster your decision-making for Equitable Holdings, Inc. (EQH).
Why Choose This Calculator for Equitable Holdings, Inc. (EQH)?
- User-Friendly Interface: Perfect for both novice and seasoned users.
- Customizable Inputs: Adjust parameters to tailor your financial analysis.
- Real-Time Insights: Observe immediate impacts on Equitable Holdings' valuation with input changes.
- Pre-Configured Data: Comes with Equitable Holdings' current financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by analysts and investors for making strategic decisions.
Who Should Use Equitable Holdings, Inc. (EQH)?
- Investors: Make informed investment choices with a robust analysis of Equitable's performance.
- Financial Analysts: Streamline your workflow with comprehensive data and insights on EQH.
- Consultants: Easily customize reports and presentations tailored to client needs using EQH's metrics.
- Finance Enthusiasts: Enhance your knowledge of the financial sector through detailed case studies on EQH.
- Educators and Students: Utilize it as an effective resource for finance education and practical applications.
What the Template Contains
- Pre-Filled Data: Includes Equitable Holdings, Inc. (EQH) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Equitable Holdings, Inc. (EQH) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.