|
CIGNA Corporation (CI) DCF Valoración
US | Healthcare | Medical - Healthcare Plans | NYSE
|
- ✓ 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
Cigna Corporation (CI) Bundle
¡Ahorre tiempo y mejore la precisión con nuestra calculadora DCF de Cigna Corporation (CI)! Utilizando datos reales de CIGNA y supuestos personalizables, esta herramienta le permite pronosticar, analizar y valorar Cigna Corporation (CI) como un inversor experimentado.
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 | 153,743.0 | 160,577.0 | 174,272.0 | 180,642.0 | 195,187.0 | 207,230.4 | 220,016.9 | 233,592.4 | 248,005.4 | 263,307.8 |
| Revenue Growth, % | 0 | 4.45 | 8.53 | 3.66 | 8.05 | 6.17 | 6.17 | 6.17 | 6.17 | 6.17 |
| EBITDA | 11,903.0 | 15,108.0 | 10,913.0 | 12,550.0 | 9,987.0 | 14,703.8 | 15,611.0 | 16,574.2 | 17,596.9 | 18,682.7 |
| EBITDA, % | 7.74 | 9.41 | 6.26 | 6.95 | 5.12 | 7.1 | 7.1 | 7.1 | 7.1 | 7.1 |
| Depreciation | 3,651.0 | 2,802.0 | 2,923.0 | 2,925.0 | 3,028.0 | 3,716.7 | 3,946.0 | 4,189.5 | 4,448.0 | 4,722.4 |
| Depreciation, % | 2.37 | 1.74 | 1.68 | 1.62 | 1.55 | 1.79 | 1.79 | 1.79 | 1.79 | 1.79 |
| EBIT | 8,252.0 | 12,306.0 | 7,990.0 | 9,625.0 | 6,959.0 | 10,987.1 | 11,665.0 | 12,384.7 | 13,148.9 | 13,960.2 |
| EBIT, % | 5.37 | 7.66 | 4.58 | 5.33 | 3.57 | 5.3 | 5.3 | 5.3 | 5.3 | 5.3 |
| Total Cash | 5,556.0 | 11,513.0 | 6,001.0 | 6,829.0 | 7,822.0 | 9,124.3 | 9,687.3 | 10,285.0 | 10,919.6 | 11,593.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 15,816.0 | 12,191.0 | 15,071.0 | 21,961.0 | 17,722.0 | 19,796.3 | 21,017.8 | 22,314.6 | 23,691.4 | 25,153.3 |
| Account Receivables, % | 10.29 | 7.59 | 8.65 | 12.16 | 9.08 | 9.55 | 9.55 | 9.55 | 9.55 | 9.55 |
| Inventories | 2,661.0 | 3,165.0 | 3,722.0 | 4,777.0 | 5,645.0 | 4,714.1 | 5,005.0 | 5,313.8 | 5,641.7 | 5,989.8 |
| Inventories, % | 1.73 | 1.97 | 2.14 | 2.64 | 2.89 | 2.27 | 2.27 | 2.27 | 2.27 | 2.27 |
| Accounts Payable | 15,544.0 | 18,825.0 | 6,655.0 | 7,775.0 | 8,553.0 | 14,232.0 | 15,110.1 | 16,042.4 | 17,032.3 | 18,083.2 |
| Accounts Payable, % | 10.11 | 11.72 | 3.82 | 4.3 | 4.38 | 6.87 | 6.87 | 6.87 | 6.87 | 6.87 |
| Capital Expenditure | -1,050.0 | -1,094.0 | -1,154.0 | -1,295.0 | -1,573.0 | -1,471.0 | -1,561.8 | -1,658.1 | -1,760.4 | -1,869.1 |
| Capital Expenditure, % | -0.68296 | -0.68129 | -0.66218 | -0.71689 | -0.80589 | -0.70984 | -0.70984 | -0.70984 | -0.70984 | -0.70984 |
| Tax Rate, % | 6.33 | 6.33 | 6.33 | 6.33 | 6.33 | 6.33 | 6.33 | 6.33 | 6.33 | 6.33 |
| EBITAT | 6,410.7 | 9,577.1 | 6,326.5 | 7,724.9 | 6,518.5 | 8,979.1 | 9,533.1 | 10,121.3 | 10,745.8 | 11,408.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 6,078.7 | 17,687.1 | -7,511.5 | 2,529.9 | 12,122.5 | 15,760.3 | 11,283.1 | 11,979.3 | 12,718.5 | 13,503.2 |
| WACC, % | 5.98 | 5.98 | 6 | 6.02 | 6.19 | 6.03 | 6.03 | 6.03 | 6.03 | 6.03 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 55,082.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 13,773 | |||||||||
| Terminal Value | 341,395 | |||||||||
| Present Terminal Value | 254,697 | |||||||||
| Enterprise Value | 309,779 | |||||||||
| Net Debt | 23,108 | |||||||||
| Equity Value | 286,671 | |||||||||
| Diluted Shares Outstanding, MM | 297 | |||||||||
| Equity Value Per Share | 965.61 |
What You Will Get
- Real CI Financial Data: Pre-filled with Cigna’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Cigna’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Cigna Data: Pre-loaded with Cigna’s historical financial performance and future outlook.
- Customizable Financial Inputs: Modify revenue growth rates, profit margins, discount rates, tax assumptions, and capital expenditures.
- Adaptive Valuation Framework: Real-time updates to Net Present Value (NPV) and intrinsic value based on user adjustments.
- Scenario Analysis: Develop various forecasting scenarios to evaluate distinct valuation results.
- Intuitive User Interface: Clean, organized design suitable for both experienced professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Cigna data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Cigna’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Cigna Corporation (CI)?
- Accuracy: Utilizes real Cigna financial data to ensure precision.
- Flexibility: Tailored for users to easily adjust and test various inputs.
- Time-Saving: Avoid the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive interface, accessible for users with no advanced financial modeling skills.
Who Should Use This Product?
- Investors: Evaluate Cigna Corporation's (CI) valuation prior to making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation processes of established companies like Cigna Corporation.
- Consultants: Provide comprehensive valuation analyses and reports for clients.
- Students and Educators: Utilize current data to learn and teach valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Cigna Corporation (CI) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Cigna Corporation (CI).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.