|
Xpeng Inc. (XPEV) DCF Valoración
CN | Consumer Cyclical | Auto - Manufacturers | 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
XPeng Inc. (XPEV) Bundle
¡Descubra el verdadero potencial de Xpeng Inc. (XPEV) con nuestra calculadora DCF avanzada! Ajuste los supuestos esenciales, explore varios escenarios y evalúe cómo los diferentes factores influyen en la valoración de Xpeng Inc. (XPEV), todo dentro de una plantilla integral de Excel.
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 | 318.0 | 800.7 | 2,875.6 | 3,679.4 | 4,202.9 | 6,747.6 | 10,833.0 | 17,391.9 | 27,922.0 | 44,827.5 |
Revenue Growth, % | 0 | 151.78 | 259.12 | 27.95 | 14.23 | 60.55 | 60.55 | 60.55 | 60.55 | 60.55 |
EBITDA | -474.1 | -311.1 | -747.1 | -1,037.9 | -1,098.5 | -2,957.8 | -4,748.6 | -7,623.7 | -12,239.4 | -19,649.9 |
EBITDA, % | -149.09 | -38.85 | -25.98 | -28.21 | -26.14 | -43.83 | -43.83 | -43.83 | -43.83 | -43.83 |
Depreciation | 31.1 | 60.0 | 114.8 | 193.3 | 288.7 | 450.4 | 723.1 | 1,160.8 | 1,863.7 | 2,992.0 |
Depreciation, % | 9.76 | 7.49 | 3.99 | 5.25 | 6.87 | 6.67 | 6.67 | 6.67 | 6.67 | 6.67 |
EBIT | -505.2 | -371.1 | -861.8 | -1,231.2 | -1,387.2 | -3,276.4 | -5,260.1 | -8,444.8 | -13,557.8 | -21,766.4 |
EBIT, % | -158.85 | -46.34 | -29.97 | -33.46 | -33.01 | -48.56 | -48.56 | -48.56 | -48.56 | -48.56 |
Total Cash | 322.6 | 4,522.7 | 5,441.6 | 4,218.8 | 4,338.5 | 6,747.6 | 10,833.0 | 17,391.9 | 27,922.0 | 44,827.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 80.2 | 176.1 | 569.5 | 714.5 | 631.5 | 1,368.9 | 2,197.7 | 3,528.3 | 5,664.6 | 9,094.3 |
Account Receivables, % | 25.2 | 21.99 | 19.8 | 19.42 | 15.02 | 20.29 | 20.29 | 20.29 | 20.29 | 20.29 |
Inventories | 62.2 | 184.0 | 364.7 | 619.5 | 757.2 | 1,215.6 | 1,951.6 | 3,133.2 | 5,030.3 | 8,075.9 |
Inventories, % | 19.56 | 22.98 | 12.68 | 16.84 | 18.01 | 18.02 | 18.02 | 18.02 | 18.02 | 18.02 |
Accounts Payable | 130.7 | 700.4 | 1,693.8 | 1,948.7 | 3,043.1 | 4,221.7 | 6,777.7 | 10,881.4 | 17,469.5 | 28,046.5 |
Accounts Payable, % | 41.1 | 87.47 | 58.9 | 52.96 | 72.4 | 62.57 | 62.57 | 62.57 | 62.57 | 62.57 |
Capital Expenditure | -261.5 | -186.7 | -591.6 | -641.2 | -316.7 | -2,038.6 | -3,272.9 | -5,254.5 | -8,435.8 | -13,543.3 |
Capital Expenditure, % | -82.21 | -23.31 | -20.57 | -17.43 | -7.54 | -30.21 | -30.21 | -30.21 | -30.21 | -30.21 |
Tax Rate, % | -0.35603 | -0.35603 | -0.35603 | -0.35603 | -0.35603 | -0.35603 | -0.35603 | -0.35603 | -0.35603 | -0.35603 |
EBITAT | -505.2 | -371.2 | -866.5 | -1,234.5 | -1,392.2 | -3,276.4 | -5,260.1 | -8,444.8 | -13,557.8 | -21,766.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -747.3 | -145.9 | -924.0 | -1,827.3 | -380.5 | -4,881.9 | -6,818.7 | -10,947.1 | -17,575.1 | -28,216.0 |
WACC, % | 13.97 | 13.97 | 13.97 | 13.97 | 13.97 | 13.97 | 13.97 | 13.97 | 13.97 | 13.97 |
PV UFCF | ||||||||||
SUM PV UFCF | -42,021.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -28,780 | |||||||||
Terminal Value | -240,483 | |||||||||
Present Terminal Value | -125,077 | |||||||||
Enterprise Value | -167,098 | |||||||||
Net Debt | -786 | |||||||||
Equity Value | -166,312 | |||||||||
Diluted Shares Outstanding, MM | 435 | |||||||||
Equity Value Per Share | -382.12 |
What You Will Receive
- Pre-Filled Financial Model: XPeng Inc.’s actual data facilitates accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Real-Time Calculations: Automatic updates provide immediate results as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, allowing repeated use for comprehensive forecasts.
Key Features
- Pre-Loaded Data: XPeng Inc.'s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Customize WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: View XPeng Inc.'s intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and key metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Step 1: Download the prebuilt Excel template featuring XPeng Inc. (XPEV) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including XPeng Inc.'s intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the results.
Why Choose This Calculator for XPeng Inc. (XPEV)?
- User-Friendly Interface: Perfectly tailored for both novice users and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to XPeng’s valuation as you change inputs.
- Preloaded Data: Comes equipped with XPeng’s latest financial information for swift evaluations.
- Relied Upon by Experts: Widely utilized by investors and analysts for informed decision-making.
Who Should Use This Product?
- Professional Investors: Construct precise and dependable valuation models for analyzing portfolios involving XPeng Inc. (XPEV).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver clients accurate valuation insights related to XPeng Inc. (XPEV) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Automotive Enthusiasts: Gain insights into how electric vehicle companies like XPeng Inc. (XPEV) are valued in the financial market.
What the Template Contains
- Historical Data: Includes XPeng Inc.’s (XPEV) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate XPeng Inc.’s (XPEV) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of XPeng Inc.’s (XPEV) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.