EHang Holdings Limited (EH) 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
EHang Holdings Limited (EH) Bundle
Looking to determine the intrinsic value of EHang Holdings Limited? Our (EH) DCF Calculator integrates real-world data with extensive customization features, enabling you to adjust forecasts and enhance your investment strategies.
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 | 16.7 | 24.7 | 7.8 | 6.1 | 16.1 | 18.4 | 21.0 | 24.1 | 27.5 | 31.5 |
Revenue Growth, % | 0 | 47.84 | -68.46 | -21.99 | 164.97 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 |
EBITDA | -5.6 | -11.7 | -42.9 | -41.8 | -36.2 | -14.0 | -16.0 | -18.3 | -20.9 | -24.0 |
EBITDA, % | -33.39 | -47.26 | -550.57 | -687.63 | -225.05 | -76.13 | -76.13 | -76.13 | -76.13 | -76.13 |
Depreciation | .8 | .8 | 1.1 | 2.9 | 2.9 | 3.2 | 3.7 | 4.2 | 4.8 | 5.5 |
Depreciation, % | 4.66 | 3.44 | 13.68 | 47.14 | 18.19 | 17.42 | 17.42 | 17.42 | 17.42 | 17.42 |
EBIT | -6.4 | -12.5 | -43.9 | -44.6 | -39.1 | -14.3 | -16.4 | -18.7 | -21.4 | -24.5 |
EBIT, % | -38.05 | -50.69 | -564.25 | -734.77 | -243.24 | -77.75 | -77.75 | -77.75 | -77.75 | -77.75 |
Total Cash | 45.1 | 25.6 | 42.8 | 34.2 | 41.1 | 18.4 | 21.0 | 24.1 | 27.5 | 31.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 8.2 | 22.5 | 7.9 | 4.3 | 6.3 | 12.9 | 14.7 | 16.8 | 19.2 | 22.0 |
Account Receivables, % | 49.36 | 90.99 | 101.31 | 70.17 | 39.15 | 69.93 | 69.93 | 69.93 | 69.93 | 69.93 |
Inventories | 2.5 | 6.5 | 10.7 | 9.9 | 8.2 | 10.7 | 12.3 | 14.1 | 16.1 | 18.4 |
Inventories, % | 15.18 | 26.15 | 137.44 | 163.29 | 50.66 | 58.4 | 58.4 | 58.4 | 58.4 | 58.4 |
Accounts Payable | 4.1 | 8.3 | 6.2 | 4.9 | 4.8 | 9.1 | 10.5 | 11.9 | 13.7 | 15.6 |
Accounts Payable, % | 24.69 | 33.54 | 80.2 | 80.01 | 29.89 | 49.67 | 49.67 | 49.67 | 49.67 | 49.67 |
Capital Expenditure | -.5 | -1.2 | -2.2 | -1.9 | -1.2 | -2.7 | -3.1 | -3.6 | -4.1 | -4.7 |
Capital Expenditure, % | -3.07 | -5.04 | -27.63 | -31.18 | -7.74 | -14.93 | -14.93 | -14.93 | -14.93 | -14.93 |
Tax Rate, % | 0.14398 | 0.14398 | 0.14398 | 0.14398 | 0.14398 | 0.14398 | 0.14398 | 0.14398 | 0.14398 | 0.14398 |
EBITAT | -6.5 | -12.5 | -43.9 | -44.6 | -39.1 | -14.3 | -16.4 | -18.7 | -21.4 | -24.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -12.8 | -26.9 | -36.7 | -40.6 | -37.7 | -18.7 | -17.9 | -20.5 | -23.4 | -26.8 |
WACC, % | 9.14 | 9.14 | 9.14 | 9.14 | 9.14 | 9.14 | 9.14 | 9.14 | 9.14 | 9.14 |
PV UFCF | ||||||||||
SUM PV UFCF | -81.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -27 | |||||||||
Terminal Value | -383 | |||||||||
Present Terminal Value | -247 | |||||||||
Enterprise Value | -329 | |||||||||
Net Debt | -9 | |||||||||
Equity Value | -320 | |||||||||
Diluted Shares Outstanding, MM | 61 | |||||||||
Equity Value Per Share | -5.27 |
What You Will Receive
- Comprehensive Financial Model: EHang Holdings Limited's actual data facilitates accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Real-Time Calculations: Instant updates allow you to view results as you make adjustments.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Adaptable and Reusable: Designed for versatility, enabling repeated utilization for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for EHang Holdings Limited (EH).
- WACC Calculation Tool: Comes with a pre-configured Weighted Average Cost of Capital sheet that allows for custom inputs.
- Customizable Forecast Inputs: Adjust growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to EHang Holdings Limited (EH).
- Interactive Dashboard and Visuals: Visual representations provide a summary of essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file containing EHang Holdings Limited’s (EH) preloaded data.
- 2. Modify Assumptions: Adjust key variables such as growth rates, WACC, and capital expenditures.
- 3. View Results Immediately: The DCF model automatically calculates the intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation results.
- 5. Present with Assurance: Share professional valuation insights to enhance your decision-making process.
Why Choose the EHang Holdings Limited (EH) Calculator?
- Accuracy: Utilizes authentic EHang financial data to guarantee precision.
- Flexibility: Allows users to easily experiment and adjust inputs as needed.
- Time-Saving: Avoid the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Designed for simplicity, making it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Professional Investors: Create in-depth and trustworthy valuation models for analyzing the portfolio of EHang Holdings Limited (EH).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding EHang Holdings Limited (EH).
- Students and Educators: Utilize real-world data to practice and teach financial modeling techniques.
- Aerospace Enthusiasts: Gain insights into how innovative companies like EHang Holdings Limited (EH) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: EHang Holdings Limited's (EH) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate EHang's (EH) 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.