Alight, Inc. (ALIT) 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
Alight, Inc. (ALIT) Bundle
Designed for accuracy, our (ALIT) DCF Calculator enables you to evaluate Alight, Inc. valuation using real-world financial data, while offering complete flexibility to modify all essential parameters for improved 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 | 2,552.0 | 2,728.0 | 2,915.0 | 3,132.0 | 3,410.0 | 3,666.4 | 3,942.0 | 4,238.4 | 4,557.0 | 4,899.6 |
| Revenue Growth, % | 0 | 6.9 | 6.85 | 7.44 | 8.88 | 7.52 | 7.52 | 7.52 | 7.52 | 7.52 |
| EBITDA | 568.0 | 1,969.0 | 481.0 | 381.0 | 186.0 | 942.7 | 1,013.5 | 1,089.7 | 1,171.6 | 1,259.7 |
| EBITDA, % | 22.26 | 72.18 | 16.5 | 12.16 | 5.45 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 |
| Depreciation | 253.0 | 321.0 | 354.0 | 395.0 | 421.0 | 431.0 | 463.4 | 498.3 | 535.7 | 576.0 |
| Depreciation, % | 9.91 | 11.77 | 12.14 | 12.61 | 12.35 | 11.76 | 11.76 | 11.76 | 11.76 | 11.76 |
| EBIT | 315.0 | 1,648.0 | 127.0 | -14.0 | -235.0 | 511.6 | 550.1 | 591.4 | 635.9 | 683.7 |
| EBIT, % | 12.34 | 60.41 | 4.36 | -0.447 | -6.89 | 13.95 | 13.95 | 13.95 | 13.95 | 13.95 |
| Total Cash | 218.0 | 506.0 | 372.0 | 250.0 | 358.0 | 427.7 | 459.9 | 494.5 | 531.6 | 571.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 665.0 | 564.0 | 515.0 | 678.0 | 805.0 | 804.1 | 864.5 | 929.5 | 999.4 | 1,074.5 |
| Account Receivables, % | 26.06 | 20.67 | 17.67 | 21.65 | 23.61 | 21.93 | 21.93 | 21.93 | 21.93 | 21.93 |
| Inventories | 878.0 | 1,140.0 | 1,280.0 | 1,509.0 | -157.0 | 1,200.2 | 1,290.5 | 1,387.5 | 1,491.8 | 1,603.9 |
| Inventories, % | 34.4 | 41.79 | 43.91 | 48.18 | -4.6 | 32.74 | 32.74 | 32.74 | 32.74 | 32.74 |
| Accounts Payable | 405.0 | 394.0 | 406.0 | 508.0 | 444.0 | 538.8 | 579.3 | 622.9 | 669.7 | 720.1 |
| Accounts Payable, % | 15.87 | 14.44 | 13.93 | 16.22 | 13.02 | 14.7 | 14.7 | 14.7 | 14.7 | 14.7 |
| Capital Expenditure | -77.0 | -90.0 | -114.0 | -148.0 | -160.0 | -144.0 | -154.9 | -166.5 | -179.0 | -192.5 |
| Capital Expenditure, % | -3.02 | -3.3 | -3.91 | -4.73 | -4.69 | -3.93 | -3.93 | -3.93 | -3.93 | -3.93 |
| Tax Rate, % | 5.74 | 5.74 | 5.74 | 5.74 | 5.74 | 5.74 | 5.74 | 5.74 | 5.74 | 5.74 |
| EBITAT | 182.4 | 1,805.8 | 143.8 | -24.6 | -221.5 | 462.7 | 497.4 | 534.8 | 575.1 | 618.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -779.6 | 1,864.8 | 304.8 | -67.6 | 1,514.5 | -511.8 | 695.8 | 748.1 | 804.4 | 864.9 |
| WACC, % | 6.32 | 7.19 | 7.19 | 7.19 | 7.08 | 7 | 7 | 7 | 7 | 7 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,970.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 882 | |||||||||
| Terminal Value | 17,658 | |||||||||
| Present Terminal Value | 12,593 | |||||||||
| Enterprise Value | 14,563 | |||||||||
| Net Debt | 2,560 | |||||||||
| Equity Value | 12,003 | |||||||||
| Diluted Shares Outstanding, MM | 489 | |||||||||
| Equity Value Per Share | 24.52 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
- Real-World Data: Alight, Inc.’s (ALIT) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and optimizing your time.
Key Features
- 🔍 Real-Life ALIT Financials: Pre-filled historical and projected data for Alight, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Alight’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Alight’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Model: Download and open the Excel file containing Alight, Inc.'s (ALIT) financial data.
- 2. Customize Inputs: Adjust key parameters such as growth projections, WACC, and capital expenditures.
- 3. Analyze Results in Real-Time: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Various Scenarios: Evaluate different forecasts to understand a range of valuation possibilities.
- 5. Present with Assurance: Deliver expert valuation findings to enhance your strategic decisions.
Why Choose This Calculator for Alight, Inc. (ALIT)?
- Accurate Data: Utilize real Alight financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the field.
- User-Friendly: Designed with an intuitive interface and clear instructions for users of all levels.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for portfolio assessments of Alight, Inc. (ALIT).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding Alight, Inc. (ALIT) stock.
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Tech Enthusiasts: Gain insights into how technology firms like Alight, Inc. (ALIT) are appraised in the marketplace.
What the Alight, Inc. (ALIT) Template Contains
- Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
- Real-World Data: Alight, Inc.'s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Visualizations and tables for clear, actionable results.