Lufax Holding Ltd (LU) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Lufax Holding Ltd (LU) Bundle
Evaluate Lufax Holding Ltd’s financial prospects like an expert! This (LU) DCF Calculator provides pre-filled financial data while offering you the flexibility to customize revenue growth, WACC, profit margins, and other critical assumptions to align with your predictions.
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 | 5,607.4 | 5,910.2 | 7,442.0 | 6,912.3 | 5,711.2 | 5,808.7 | 5,907.8 | 6,008.6 | 6,111.1 | 6,215.4 |
Revenue Growth, % | 0 | 5.4 | 25.92 | -7.12 | -17.38 | 1.71 | 1.71 | 1.71 | 1.71 | 1.71 |
EBITDA | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Depreciation | 112.0 | 118.2 | 113.0 | 105.7 | 83.1 | 98.7 | 100.4 | 102.1 | 103.9 | 105.6 |
Depreciation, % | 2 | 2 | 1.52 | 1.53 | 1.45 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 |
EBIT | -112.0 | -118.2 | -113.0 | -105.7 | -83.1 | -98.7 | -100.4 | -102.1 | -103.9 | -105.6 |
EBIT, % | -2 | -2 | -1.52 | -1.53 | -1.45 | -1.7 | -1.7 | -1.7 | -1.7 | -1.7 |
Total Cash | 1,007.4 | 3,310.2 | 4,760.5 | 6,012.7 | 5,479.3 | 3,727.6 | 3,791.2 | 3,855.9 | 3,921.7 | 3,988.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2,144.7 | 2,143.8 | 2,065.1 | 1,335.5 | 732.5 | 1,561.6 | 1,588.2 | 1,615.3 | 1,642.9 | 1,670.9 |
Account Receivables, % | 38.25 | 36.27 | 27.75 | 19.32 | 12.83 | 26.88 | 26.88 | 26.88 | 26.88 | 26.88 |
Inventories | -2,546.3 | -4,716.8 | -4,250.8 | -3,985.8 | 17,243.0 | -1,626.4 | -1,654.2 | -1,682.4 | -1,711.1 | -1,740.3 |
Inventories, % | -45.41 | -79.81 | -57.12 | -57.66 | 301.91 | -28 | -28 | -28 | -28 | -28 |
Accounts Payable | 72.1 | 59.4 | 55.0 | 26.5 | 19.1 | 43.5 | 44.3 | 45.0 | 45.8 | 46.6 |
Accounts Payable, % | 1.29 | 1 | 0.7387 | 0.38314 | 0.33399 | 0.74917 | 0.74917 | 0.74917 | 0.74917 | 0.74917 |
Capital Expenditure | -24.9 | -28.3 | -21.0 | -16.8 | -6.6 | -18.2 | -18.5 | -18.8 | -19.1 | -19.4 |
Capital Expenditure, % | -0.44411 | -0.47873 | -0.28179 | -0.24351 | -0.11597 | -0.31282 | -0.31282 | -0.31282 | -0.31282 | -0.31282 |
Tax Rate, % | 46.09 | 46.09 | 46.09 | 46.09 | 46.09 | 46.09 | 46.09 | 46.09 | 46.09 | 46.09 |
EBITAT | -76.8 | -81.5 | -81.1 | -70.6 | -44.8 | -65.2 | -66.3 | -67.4 | -68.6 | -69.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 483.9 | 2,167.1 | -380.8 | 454.4 | -20,601.6 | 18,080.1 | 17.5 | 17.8 | 18.1 | 18.4 |
WACC, % | 13.01 | 13.08 | 13.55 | 12.72 | 10.56 | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 |
PV UFCF | ||||||||||
SUM PV UFCF | 16,106.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 19 | |||||||||
Terminal Value | 177 | |||||||||
Present Terminal Value | 98 | |||||||||
Enterprise Value | 16,205 | |||||||||
Net Debt | 721 | |||||||||
Equity Value | 15,484 | |||||||||
Diluted Shares Outstanding, MM | 574 | |||||||||
Equity Value Per Share | 27.00 |
What You Will Get
- Real LU 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 Testing: Explore various scenarios to assess Lufax's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- 🔍 Real-Life LU Financials: Pre-filled historical and projected data for Lufax Holding Ltd (LU).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Lufax’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Lufax’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based Lufax DCF Calculator for (LU).
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other key inputs.
- Instant Calculations: The model automatically recalculates Lufax’s intrinsic value based on your inputs.
- Test Scenarios: Experiment with various assumptions to see how they impact the valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial assessments.
Why Choose This Calculator for Lufax Holding Ltd (LU)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Witness immediate updates to Lufax’s valuation as you tweak inputs.
- Pre-Configured Data: Comes equipped with Lufax’s latest financial figures for swift evaluations.
- Relied Upon by Experts: Preferred by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and precise valuation models for analyzing Lufax Holding Ltd (LU) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver clients with reliable valuation insights specific to Lufax Holding Ltd (LU).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling related to Lufax Holding Ltd (LU).
- Tech Enthusiasts: Gain insights into how fintech companies like Lufax Holding Ltd (LU) are valued in the market.
What the Template Contains
- Preloaded LU Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.