AXIS Capital Holdings Limited (AXS) DCF Valuation
- ✓ 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
AXIS Capital Holdings Limited (AXS) Bundle
Evaluate AXIS Capital Holdings Limited's financial outlook like an expert! This (AXS) DCF Calculator provides pre-filled financials along with the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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,173.4 | 4,842.0 | 5,321.7 | 5,135.4 | 5,617.2 | 5,748.9 | 5,883.8 | 6,021.8 | 6,163.0 | 6,307.6 |
| Revenue Growth, % | 0 | -6.41 | 9.91 | -3.5 | 9.38 | 2.35 | 2.35 | 2.35 | 2.35 | 2.35 |
| EBITDA | 4,134.9 | 11.7 | 778.2 | 374.6 | 542.4 | 1,284.8 | 1,314.9 | 1,345.8 | 1,377.3 | 1,409.6 |
| EBITDA, % | 79.93 | 0.24191 | 14.62 | 7.29 | 9.66 | 22.35 | 22.35 | 22.35 | 22.35 | 22.35 |
| Depreciation | 11.6 | 65.8 | 67.0 | 68.3 | 75.6 | 63.4 | 64.9 | 66.4 | 68.0 | 69.6 |
| Depreciation, % | 0.22416 | 1.36 | 1.26 | 1.33 | 1.35 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
| EBIT | 4,123.3 | -54.1 | 711.2 | 306.3 | 466.9 | 1,221.4 | 1,250.0 | 1,279.3 | 1,309.3 | 1,340.0 |
| EBIT, % | 79.7 | -1.12 | 13.36 | 5.96 | 8.31 | 21.24 | 21.24 | 21.24 | 21.24 | 21.24 |
| Total Cash | 13,747.8 | 13,106.5 | 13,188.9 | 12,148.6 | 5,305.2 | 5,685.1 | 5,818.4 | 5,954.9 | 6,094.6 | 6,237.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Inventories | -9,005.6 | -9,401.5 | -9,700.2 | -10,459.7 | .0 | -4,599.1 | -4,707.0 | -4,817.4 | -4,930.4 | -5,046.0 |
| Inventories, % | -174.07 | -194.17 | -182.27 | -203.68 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 1,349.1 | 1,092.0 | 1,324.6 | 1,609.9 | 1,792.7 | 1,572.7 | 1,609.6 | 1,647.4 | 1,686.0 | 1,725.6 |
| Accounts Payable, % | 26.08 | 22.55 | 24.89 | 31.35 | 31.91 | 27.36 | 27.36 | 27.36 | 27.36 | 27.36 |
| Capital Expenditure | -63.1 | -44.7 | -38.7 | -36.8 | -31.1 | -47.6 | -48.7 | -49.9 | -51.0 | -52.2 |
| Capital Expenditure, % | -1.22 | -0.92238 | -0.72781 | -0.71715 | -0.55444 | -0.82832 | -0.82832 | -0.82832 | -0.82832 | -0.82832 |
| Tax Rate, % | 5.56 | 5.56 | 5.56 | 5.56 | 5.56 | 5.56 | 5.56 | 5.56 | 5.56 | 5.56 |
| EBITAT | 3,952.6 | -48.9 | 678.0 | 281.0 | 440.9 | 1,142.8 | 1,169.6 | 1,197.0 | 1,225.1 | 1,253.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 14,255.8 | 111.0 | 1,237.5 | 1,357.4 | -9,791.6 | 5,537.8 | 1,330.6 | 1,361.8 | 1,393.7 | 1,426.4 |
| WACC, % | 8 | 7.96 | 8 | 7.97 | 7.99 | 7.99 | 7.99 | 7.99 | 7.99 | 7.99 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 9,347.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,455 | |||||||||
| Terminal Value | 24,305 | |||||||||
| Present Terminal Value | 16,552 | |||||||||
| Enterprise Value | 25,899 | |||||||||
| Net Debt | 569 | |||||||||
| Equity Value | 25,330 | |||||||||
| Diluted Shares Outstanding, MM | 86 | |||||||||
| Equity Value Per Share | 294.50 |
What You Will Get
- Comprehensive AXS 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 Analysis: Evaluate various scenarios to assess AXIS Capital's future prospects.
- User-Friendly Design: Designed for experts while remaining approachable for newcomers.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as underwriting performance, investment income, and loss ratios.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages AXIS Capital's actual financial data for credible valuation results.
- Effortless Scenario Analysis: Easily explore various assumptions and evaluate their impact on outcomes.
- Efficiency Booster: Avoid the hassle of creating intricate valuation models from the ground up.
How It Works
- 1. Download the Template: Obtain and open the Excel file containing AXIS Capital Holdings Limited’s (AXS) preloaded financial data.
- 2. Adjust Assumptions: Modify essential inputs such as growth projections, WACC, and capital expenditures.
- 3. Access Instant Results: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to investigate different valuation possibilities.
- 5. Present with Assurance: Deliver expert valuation analyses to reinforce your strategic decisions.
Why Choose This Calculator for AXIS Capital Holdings Limited (AXS)?
- Designed for Experts: A sophisticated tool favored by financial analysts, risk managers, and investors.
- Comprehensive Data: AXIS Capital’s historical and projected financials are preloaded for enhanced precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Intuitive Outputs: Automatically computes intrinsic value, NPV, and other essential metrics.
- User-Friendly: Clear, step-by-step guidance simplifies the calculation process.
Who Should Use AXIS Capital Holdings Limited (AXS)?
- Institutional Investors: Develop comprehensive and precise valuation models for investment strategies.
- Risk Management Teams: Assess valuation scenarios to inform risk assessment and mitigation strategies.
- Financial Advisors: Deliver clients accurate valuation analyses for AXIS Capital Holdings Limited (AXS) investments.
- Academics and Learners: Utilize real-world financial data to enhance learning in finance and investment courses.
- Market Analysts: Gain insights into how insurance and reinsurance companies like AXIS Capital Holdings Limited (AXS) are valued in the financial markets.
What the Template Contains
- Historical Data: Includes AXIS Capital Holdings Limited’s (AXS) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate AXIS Capital Holdings Limited’s (AXS) 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 AXIS Capital Holdings Limited’s (AXS) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.