IHS Holding Limited (IHS) 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
IHS Holding Limited (IHS) Bundle
Looking to calculate the intrinsic value of IHS Holding Limited? Our IHS (IHS) DCF Calculator integrates real-world data with extensive customization features, allowing 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 | 1,231.1 | 1,403.1 | 1,579.7 | 1,961.3 | 2,125.5 | 2,439.5 | 2,799.9 | 3,213.6 | 3,688.3 | 4,233.2 |
| Revenue Growth, % | 0 | 13.98 | 12.58 | 24.15 | 8.37 | 14.77 | 14.77 | 14.77 | 14.77 | 14.77 |
| EBITDA | 186.1 | 468.1 | 591.5 | 252.6 | -998.5 | 252.9 | 290.2 | 333.1 | 382.3 | 438.8 |
| EBITDA, % | 15.12 | 33.36 | 37.44 | 12.88 | -46.97 | 10.37 | 10.37 | 10.37 | 10.37 | 10.37 |
| Depreciation | 386.2 | 411.3 | 387.5 | 476.0 | 435.6 | 634.2 | 727.9 | 835.4 | 958.8 | 1,100.5 |
| Depreciation, % | 31.37 | 29.31 | 24.53 | 24.27 | 20.49 | 26 | 26 | 26 | 26 | 26 |
| EBIT | -200.1 | 56.8 | 204.0 | -223.3 | -1,434.1 | -381.3 | -437.7 | -502.3 | -576.5 | -661.7 |
| EBIT, % | -16.26 | 4.05 | 12.91 | -11.39 | -67.47 | -15.63 | -15.63 | -15.63 | -15.63 | -15.63 |
| Total Cash | 898.8 | 585.4 | 916.5 | 514.1 | 293.8 | 1,038.2 | 1,191.6 | 1,367.6 | 1,569.6 | 1,801.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 175.7 | 200.7 | 222.8 | 211.0 | 580.6 | 394.0 | 452.2 | 519.0 | 595.7 | 683.7 |
| Account Receivables, % | 14.28 | 14.3 | 14.1 | 10.76 | 27.32 | 16.15 | 16.15 | 16.15 | 16.15 | 16.15 |
| Inventories | 48.7 | 49.2 | 42.0 | 74.2 | 40.6 | 77.2 | 88.6 | 101.7 | 116.7 | 133.9 |
| Inventories, % | 3.96 | 3.51 | 2.66 | 3.78 | 1.91 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 |
| Accounts Payable | 338.4 | 301.8 | 342.8 | 443.0 | 330.6 | 531.0 | 609.5 | 699.5 | 802.9 | 921.5 |
| Accounts Payable, % | 27.49 | 21.51 | 21.7 | 22.58 | 15.55 | 21.77 | 21.77 | 21.77 | 21.77 | 21.77 |
| Capital Expenditure | -258.3 | -229.2 | -402.5 | -559.4 | -598.8 | -583.0 | -669.1 | -767.9 | -881.4 | -1,011.6 |
| Capital Expenditure, % | -20.98 | -16.33 | -25.48 | -28.52 | -28.17 | -23.9 | -23.9 | -23.9 | -23.9 | -23.9 |
| Tax Rate, % | -5.1 | -5.1 | -5.1 | -5.1 | -5.1 | -5.1 | -5.1 | -5.1 | -5.1 | -5.1 |
| EBITAT | -206.7 | 119.9 | 654.4 | -193.2 | -1,507.2 | -371.0 | -425.8 | -488.7 | -560.9 | -643.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 35.2 | 240.0 | 665.6 | -196.9 | -2,118.7 | 30.6 | -358.2 | -411.1 | -471.9 | -541.6 |
| WACC, % | 10.63 | 10.63 | 10.63 | 9.45 | 10.63 | 10.39 | 10.39 | 10.39 | 10.39 | 10.39 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,219.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -552 | |||||||||
| Terminal Value | -6,581 | |||||||||
| Present Terminal Value | -4,014 | |||||||||
| Enterprise Value | -5,234 | |||||||||
| Net Debt | 3,819 | |||||||||
| Equity Value | -9,053 | |||||||||
| Diluted Shares Outstanding, MM | 333 | |||||||||
| Equity Value Per Share | -27.17 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real IHS financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on IHS’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for IHS Holding Limited (IHS).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable inputs specific to IHS.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit IHS's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to IHS Holding Limited (IHS).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of IHS.
How It Works
- Download: Get the pre-built Excel file containing IHS Holding Limited’s (IHS) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and evaluate outcomes instantly.
- Make Decisions: Leverage the valuation results to inform your investment strategy.
Why Choose This Calculator for IHS Holding Limited (IHS)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Watch IHS's valuation change instantly as you modify the inputs.
- Pre-Loaded Data: Comes with IHS's actual financial metrics for swift evaluations.
- Preferred by Experts: Utilized by analysts and investors for making strategic decisions.
Who Should Use This Product?
- Investors: Assess IHS Holding Limited’s (IHS) valuation prior to making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and validate financial forecasts.
- Startup Founders: Gain insights into how large public entities like IHS Holding Limited are appraised.
- Consultants: Provide comprehensive valuation reports for your clientele.
- Students and Educators: Utilize current data to learn and instruct on valuation strategies.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for IHS Holding Limited (IHS).
- Real-World Data: IHS's historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into IHS's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to IHS Holding Limited (IHS).
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for informed decision-making.