X Financial (XYF) 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
X Financial (XYF) Bundle
Simplify X Financial (XYF) valuation with this customizable DCF Calculator! Featuring real X Financial (XYF) financials and adjustable forecast inputs, you can test scenarios and uncover X Financial (XYF) fair value in minutes.
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 | 175.2 | -8.4 | 207.2 | 210.7 | 258.4 | 144.9 | 81.3 | 45.6 | 25.6 | 14.3 |
Revenue Growth, % | 0 | -104.81 | -2558.43 | 1.69 | 22.67 | -43.91 | -43.91 | -43.91 | -43.91 | -43.91 |
EBITDA | 114.0 | .0 | 179.4 | 147.4 | .0 | 64.2 | 36.0 | 20.2 | 11.3 | 6.4 |
EBITDA, % | 65.05 | 0 | 86.62 | 69.95 | 0 | 44.33 | 44.33 | 44.33 | 44.33 | 44.33 |
Depreciation | 1.6 | 1.6 | 1.1 | .9 | .7 | -5.0 | -2.8 | -1.6 | -.9 | -.5 |
Depreciation, % | 0.89009 | -19.37 | 0.53809 | 0.43231 | 0.27893 | -3.45 | -3.45 | -3.45 | -3.45 | -3.45 |
EBIT | 112.4 | -1.6 | 178.3 | 146.4 | -.7 | 69.2 | 38.8 | 21.8 | 12.2 | 6.9 |
EBIT, % | 64.16 | 19.37 | 86.08 | 69.52 | -0.27893 | 47.77 | 47.77 | 47.77 | 47.77 | 47.77 |
Total Cash | 137.8 | 227.5 | 297.1 | 325.1 | 163.8 | 70.2 | 39.4 | 22.1 | 12.4 | 6.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 121.5 | 67.0 | 114.3 | 164.3 | 230.8 | 55.6 | 31.2 | 17.5 | 9.8 | 5.5 |
Account Receivables, % | 69.38 | -795.18 | 55.18 | 78.02 | 89.3 | 38.37 | 38.37 | 38.37 | 38.37 | 38.37 |
Inventories | .0 | -728.9 | -686.5 | -847.5 | -3.4 | -29.4 | -16.5 | -9.2 | -5.2 | -2.9 |
Inventories, % | 0.0000000782 | 8649.84 | -331.4 | -402.3 | -1.31 | -20.26 | -20.26 | -20.26 | -20.26 | -20.26 |
Accounts Payable | 14.2 | 17.3 | 11.4 | 26.7 | 24.6 | -18.6 | -10.4 | -5.9 | -3.3 | -1.8 |
Accounts Payable, % | 8.09 | -205.86 | 5.5 | 12.69 | 9.53 | -12.84 | -12.84 | -12.84 | -12.84 | -12.84 |
Capital Expenditure | -54.1 | -.7 | -.4 | -.8 | -1.2 | -9.3 | -5.2 | -2.9 | -1.6 | -.9 |
Capital Expenditure, % | -30.91 | 8.72 | -0.17329 | -0.39385 | -0.44901 | -6.38 | -6.38 | -6.38 | -6.38 | -6.38 |
Tax Rate, % | 17.37 | 17.37 | 17.37 | 17.37 | 17.37 | 17.37 | 17.37 | 17.37 | 17.37 | 17.37 |
EBITAT | 131.1 | -1.3 | 123.6 | 97.2 | -.6 | 55.3 | 31.0 | 17.4 | 9.8 | 5.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -28.9 | 786.2 | 28.8 | 223.5 | -913.6 | 199.0 | 42.7 | 24.0 | 13.4 | 7.5 |
WACC, % | 5.7 | 5.56 | 5.48 | 5.46 | 5.57 | 5.55 | 5.55 | 5.55 | 5.55 | 5.55 |
PV UFCF | ||||||||||
SUM PV UFCF | 263.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 8 | |||||||||
Terminal Value | 216 | |||||||||
Present Terminal Value | 165 | |||||||||
Enterprise Value | 429 | |||||||||
Net Debt | -318 | |||||||||
Equity Value | 747 | |||||||||
Diluted Shares Outstanding, MM | 48 | |||||||||
Equity Value Per Share | 15.41 |
What You Will Get
- Authentic XYF Financials: Access to historical and projected data for precise valuation.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Explore various scenarios to assess X Financial’s future performance.
- User-Friendly Interface: Designed for experts while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for X Financial (XYF).
- WACC Calculator: A pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for X Financial (XYF).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file featuring X Financial’s preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate multiple forecasts to assess various valuation outcomes.
- 5. Present with Assurance: Showcase professional valuation insights to bolster your decisions.
Why Choose the X Financial (XYF) Calculator?
- Accuracy: Utilizes real X Financial (XYF) data for precise calculations.
- Flexibility: Allows users to easily adjust and test various inputs.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected by CFOs.
- User-Friendly: Intuitive interface suitable for users with any level of financial modeling expertise.
Who Should Use This Product?
- Investors: Accurately assess X Financial’s fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis.
- Consultants: Easily customize the template for valuation reports tailored to clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading firms.
- Educators: Implement it as a teaching resource to illustrate valuation techniques.
What the Template Contains
- Pre-Filled Data: Includes X Financial's historical financials and projections.
- 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 X Financial's profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.