|
Valoración DCF de IBEX Limited (IBEX)
US | Technology | Information Technology Services | NASDAQ
|
- ✓ 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
IBEX Limited (IBEX) Bundle
¡Simplifique la valoración de IBEX Limited (IBEX) con esta calculadora DCF personalizable! Con las finanzas de Real IBEX Limited (IBEX) y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de IBEX Limited (IBEX) en minutos.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 405.1 | 443.7 | 493.6 | 523.1 | 508.6 | 539.0 | 571.3 | 605.6 | 641.8 | 680.3 |
Revenue Growth, % | 0 | 9.51 | 11.25 | 5.99 | -2.78 | 5.99 | 5.99 | 5.99 | 5.99 | 5.99 |
EBITDA | 47.2 | 51.5 | 52.8 | 74.0 | 61.0 | 64.8 | 68.7 | 72.8 | 77.1 | 81.7 |
EBITDA, % | 11.64 | 11.61 | 10.7 | 14.14 | 11.99 | 12.02 | 12.02 | 12.02 | 12.02 | 12.02 |
Depreciation | 24.5 | 28.2 | 32.2 | 33.4 | 19.5 | 31.4 | 33.3 | 35.3 | 37.4 | 39.6 |
Depreciation, % | 6.04 | 6.36 | 6.52 | 6.39 | 3.83 | 5.83 | 5.83 | 5.83 | 5.83 | 5.83 |
EBIT | 22.7 | 23.3 | 20.6 | 40.5 | 41.5 | 33.4 | 35.4 | 37.5 | 39.7 | 42.1 |
EBIT, % | 5.6 | 5.26 | 4.18 | 7.75 | 8.16 | 6.19 | 6.19 | 6.19 | 6.19 | 6.19 |
Total Cash | 21.9 | 57.8 | 48.8 | 57.4 | 62.7 | 55.7 | 59.0 | 62.5 | 66.3 | 70.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 57.6 | 68.1 | 81.8 | 92.4 | 107.6 | 91.6 | 97.1 | 102.9 | 109.1 | 115.6 |
Account Receivables, % | 14.22 | 15.36 | 16.58 | 17.66 | 21.16 | 16.99 | 16.99 | 16.99 | 16.99 | 16.99 |
Inventories | -64.2 | .7 | .0 | 6.6 | .0 | -15.5 | -16.5 | -17.5 | -18.5 | -19.6 |
Inventories, % | -15.84 | 0.16477 | 0.000000203 | 1.26 | 0 | -2.88 | -2.88 | -2.88 | -2.88 | -2.88 |
Accounts Payable | 10.4 | 6.0 | 21.3 | 18.7 | 16.4 | 16.2 | 17.2 | 18.2 | 19.3 | 20.4 |
Accounts Payable, % | 2.56 | 1.35 | 4.31 | 3.58 | 3.22 | 3 | 3 | 3 | 3 | 3 |
Capital Expenditure | -5.3 | -20.8 | -25.9 | -19.0 | -8.9 | -17.9 | -19.0 | -20.1 | -21.3 | -22.6 |
Capital Expenditure, % | -1.3 | -4.69 | -5.25 | -3.62 | -1.74 | -3.32 | -3.32 | -3.32 | -3.32 | -3.32 |
Tax Rate, % | 17.89 | 17.89 | 17.89 | 17.89 | 17.89 | 17.89 | 17.89 | 17.89 | 17.89 | 17.89 |
EBITAT | 17.5 | 13.9 | 21.1 | 31.7 | 34.1 | 26.5 | 28.1 | 29.8 | 31.6 | 33.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 53.6 | -58.5 | 29.7 | 26.5 | 33.7 | 71.4 | 38.8 | 41.1 | 43.6 | 46.2 |
WACC, % | 7.36 | 7.25 | 7.51 | 7.37 | 7.39 | 7.37 | 7.37 | 7.37 | 7.37 | 7.37 |
PV UFCF | ||||||||||
SUM PV UFCF | 198.6 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 46 | |||||||||
Terminal Value | 676 | |||||||||
Present Terminal Value | 473 | |||||||||
Enterprise Value | 672 | |||||||||
Net Debt | 4 | |||||||||
Equity Value | 668 | |||||||||
Diluted Shares Outstanding, MM | 18 | |||||||||
Equity Value Per Share | 36.57 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-populated financials for IBEX Limited (IBEX).
- Actual Market Data: Access to historical performance data and forward-looking projections (highlighted in the yellow cells).
- Assumption Flexibility: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Real-Time Calculations: Instantly observe how your inputs influence the valuation of IBEX Limited (IBEX).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for easy navigation and usability, complete with step-by-step guidance.
Key Features
- Comprehensive Data: IBEX Limited’s (IBEX) historical financial data and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: View IBEX Limited’s intrinsic value recalculating instantly.
- Intuitive Visual Outputs: Dashboard charts showcase valuation results and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template featuring IBEX Limited’s (IBEX) 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 IBEX Limited’s (IBEX) intrinsic value.
- Step 5: Make well-informed investment choices or create reports based on the outputs.
Why Choose IBEX Limited (IBEX) Calculator?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Comprehensive Data: IBEX's historical and projected financials are preloaded for enhanced precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance simplifies your experience throughout the process.
Who Should Use IBEX Limited (IBEX)?
- Investors: Make informed investment choices with our innovative financial insights.
- Financial Analysts: Enhance your analysis with our comprehensive data and reporting tools.
- Consultants: Efficiently tailor our resources for impactful client strategies and presentations.
- Finance Enthusiasts: Expand your knowledge of market trends and investment strategies with our expert content.
- Educators and Students: Utilize our platform as a valuable resource for finance education and research.
What the Template Contains
- Historical Data: Includes IBEX Limited’s (IBEX) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate IBEX Limited’s (IBEX) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital specific to IBEX Limited (IBEX).
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions for IBEX Limited (IBEX).
- Quarterly and Annual Statements: A complete breakdown of IBEX Limited’s (IBEX) financials.
- Interactive Dashboard: Visualize valuation results and projections for IBEX Limited (IBEX) dynamically.