|
Albertsons Companies, Inc. (ACI) Valoración de DCF
US | Consumer Defensive | Grocery Stores | 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
Albertsons Companies, Inc. (ACI) Bundle
¡Descubra el verdadero potencial de Albertsons Companies, Inc. (ACI) con nuestra calculadora DCF premium! Ajuste los supuestos esenciales, explore varios escenarios y evalúe cómo los cambios afectan la valoración de Albertsons Companies, Inc. (ACI), todo dentro de una plantilla de Excel conveniente.
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 | 62,455.1 | 69,690.4 | 71,887.0 | 77,649.7 | 79,237.7 | 84,150.1 | 89,367.0 | 94,907.3 | 100,791.1 | 107,039.7 |
| Revenue Growth, % | 0 | 11.58 | 3.15 | 8.02 | 2.05 | 6.2 | 6.2 | 6.2 | 6.2 | 6.2 |
| EBITDA | 3,185.4 | 3,785.3 | 4,886.6 | 4,799.9 | 4,541.2 | 4,921.4 | 5,226.6 | 5,550.6 | 5,894.7 | 6,260.1 |
| EBITDA, % | 5.1 | 5.43 | 6.8 | 6.18 | 5.73 | 5.85 | 5.85 | 5.85 | 5.85 | 5.85 |
| Depreciation | 2,261.6 | 2,214.3 | 2,438.4 | 2,345.3 | 2,444.2 | 2,742.5 | 2,912.6 | 3,093.1 | 3,284.9 | 3,488.5 |
| Depreciation, % | 3.62 | 3.18 | 3.39 | 3.02 | 3.08 | 3.26 | 3.26 | 3.26 | 3.26 | 3.26 |
| EBIT | 923.8 | 1,571.0 | 2,448.2 | 2,454.6 | 2,097.0 | 2,178.9 | 2,314.0 | 2,457.5 | 2,609.8 | 2,771.6 |
| EBIT, % | 1.48 | 2.25 | 3.41 | 3.16 | 2.65 | 2.59 | 2.59 | 2.59 | 2.59 | 2.59 |
| Total Cash | 470.7 | 1,717.0 | 2,902.0 | 455.8 | 188.7 | 1,359.8 | 1,444.1 | 1,533.6 | 1,628.7 | 1,729.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 502.8 | 550.9 | 560.6 | 687.6 | 724.4 | 702.7 | 746.2 | 792.5 | 841.6 | 893.8 |
| Account Receivables, % | 0.80506 | 0.7905 | 0.77984 | 0.88552 | 0.91421 | 0.83502 | 0.83502 | 0.83502 | 0.83502 | 0.83502 |
| Inventories | 4,352.5 | 4,301.3 | 4,500.8 | 4,782.0 | 4,945.2 | 5,352.2 | 5,684.0 | 6,036.4 | 6,410.6 | 6,808.0 |
| Inventories, % | 6.97 | 6.17 | 6.26 | 6.16 | 6.24 | 6.36 | 6.36 | 6.36 | 6.36 | 6.36 |
| Accounts Payable | 2,891.1 | 3,487.3 | 4,236.8 | 4,173.1 | 4,218.2 | 4,413.6 | 4,687.2 | 4,977.8 | 5,286.4 | 5,614.1 |
| Accounts Payable, % | 4.63 | 5 | 5.89 | 5.37 | 5.32 | 5.24 | 5.24 | 5.24 | 5.24 | 5.24 |
| Capital Expenditure | -1,475.1 | -1,630.2 | -1,606.5 | -2,153.9 | -2,031.3 | -2,065.6 | -2,193.6 | -2,329.6 | -2,474.1 | -2,627.4 |
| Capital Expenditure, % | -2.36 | -2.34 | -2.23 | -2.77 | -2.56 | -2.45 | -2.45 | -2.45 | -2.45 | -2.45 |
| Tax Rate, % | 18.44 | 18.44 | 18.44 | 18.44 | 18.44 | 18.44 | 18.44 | 18.44 | 18.44 | 18.44 |
| EBITAT | 719.1 | 1,183.4 | 1,888.6 | 1,919.4 | 1,710.3 | 1,699.8 | 1,805.2 | 1,917.1 | 2,036.0 | 2,162.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -458.6 | 2,366.8 | 3,260.8 | 1,638.9 | 1,968.3 | 2,186.9 | 2,422.4 | 2,572.5 | 2,732.0 | 2,901.4 |
| WACC, % | 4.61 | 4.54 | 4.59 | 4.62 | 4.7 | 4.61 | 4.61 | 4.61 | 4.61 | 4.61 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 11,148.4 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 2,916 | |||||||||
| Terminal Value | 70,932 | |||||||||
| Present Terminal Value | 56,619 | |||||||||
| Enterprise Value | 67,767 | |||||||||
| Net Debt | 14,051 | |||||||||
| Equity Value | 53,716 | |||||||||
| Diluted Shares Outstanding, MM | 581 | |||||||||
| Equity Value Per Share | 92.44 |
What You Will Get
- Real ACI Financial Data: Pre-filled with Albertsons’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Albertsons’ 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 Financial Data: Albertsons Companies, Inc.'s (ACI) historical financial records and pre-filled projections.
- Customizable Variables: Adjust inputs for WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Analysis: Monitor the intrinsic value of Albertsons Companies, Inc. (ACI) as it recalculates instantly.
- Intuitive Visualizations: Dashboard graphs present valuation outcomes and essential metrics clearly.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template featuring Albertsons Companies, Inc. (ACI) data.
- Step 2: Navigate through 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 Albertsons' intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Albertsons Companies, Inc. (ACI)?
- Accuracy: Utilizes real Albertsons financials to guarantee data reliability.
- Flexibility: Tailored for users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Investors: Assess Albertsons Companies, Inc. (ACI) valuation before making stock transactions.
- CFOs and Financial Analysts: Optimize valuation workflows and evaluate financial forecasts.
- Startup Founders: Understand the valuation methodologies of major retail companies like Albertsons.
- Consultants: Provide expert valuation analyses and reports for clients in the retail sector.
- Students and Educators: Utilize real market data to learn and teach valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Albertsons Companies, Inc. (ACI) 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 Albertsons Companies, Inc. (ACI).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.