|
Sendas Distribuidora S.A. (ASAI) Valoración de DCF
BR | 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
Sendas Distribuidora S.A. (ASAI) Bundle
¡Streamline Sendas Distribuidora S.A. (ASAI) Valoración con nuestra calculadora DCF personalizable! Equipado con datos financieros reales de Sendas Distribuidora S.A. (ASAI) y entradas de pronóstico ajustable, puede explorar rápidamente diferentes escenarios y determinar el valor razonable de Sendas distribuidora S.A. (ASAI) en solo minutos.
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 | 4,891.3 | 5,831.4 | 6,778.7 | 8,820.9 | 10,759.6 | 13,115.2 | 15,986.4 | 19,486.3 | 23,752.3 | 28,952.3 |
Revenue Growth, % | 0 | 19.22 | 16.24 | 30.13 | 21.98 | 21.89 | 21.89 | 21.89 | 21.89 | 21.89 |
EBITDA | 389.9 | 600.2 | 518.9 | 597.3 | 748.3 | 1,039.9 | 1,267.6 | 1,545.1 | 1,883.4 | 2,295.7 |
EBITDA, % | 7.97 | 10.29 | 7.65 | 6.77 | 6.95 | 7.93 | 7.93 | 7.93 | 7.93 | 7.93 |
Depreciation | 77.7 | 211.9 | 111.2 | 160.2 | 238.8 | 285.8 | 348.4 | 424.7 | 517.7 | 631.0 |
Depreciation, % | 1.59 | 3.63 | 1.64 | 1.82 | 2.22 | 2.18 | 2.18 | 2.18 | 2.18 | 2.18 |
EBIT | 312.3 | 388.3 | 407.7 | 437.2 | 509.5 | 754.1 | 919.2 | 1,120.4 | 1,365.7 | 1,664.7 |
EBIT, % | 6.38 | 6.66 | 6.01 | 4.96 | 4.74 | 5.75 | 5.75 | 5.75 | 5.75 | 5.75 |
Total Cash | 813.2 | 571.4 | 412.6 | 945.2 | 891.0 | 1,351.0 | 1,646.8 | 2,007.3 | 2,446.8 | 2,982.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 293.8 | 159.2 | 196.7 | 92.2 | 395.6 | 429.2 | 523.1 | 637.6 | 777.2 | 947.4 |
Account Receivables, % | 6.01 | 2.73 | 2.9 | 1.05 | 3.68 | 3.27 | 3.27 | 3.27 | 3.27 | 3.27 |
Inventories | 839.7 | 604.9 | 708.6 | 1,046.3 | 1,078.2 | 1,570.6 | 1,914.4 | 2,333.6 | 2,844.4 | 3,467.2 |
Inventories, % | 17.17 | 10.37 | 10.45 | 11.86 | 10.02 | 11.98 | 11.98 | 11.98 | 11.98 | 11.98 |
Accounts Payable | 1,580.7 | 818.3 | 961.4 | 1,711.3 | 1,959.3 | 2,574.3 | 3,137.9 | 3,824.8 | 4,662.2 | 5,682.9 |
Accounts Payable, % | 32.32 | 14.03 | 14.18 | 19.4 | 18.21 | 19.63 | 19.63 | 19.63 | 19.63 | 19.63 |
Capital Expenditure | -228.0 | -266.0 | -499.1 | -673.1 | -531.5 | -764.7 | -932.2 | -1,136.2 | -1,385.0 | -1,688.2 |
Capital Expenditure, % | -4.66 | -4.56 | -7.36 | -7.63 | -4.94 | -5.83 | -5.83 | -5.83 | -5.83 | -5.83 |
Tax Rate, % | -28.16 | -28.16 | -28.16 | -28.16 | -28.16 | -28.16 | -28.16 | -28.16 | -28.16 | -28.16 |
EBITAT | 222.3 | 334.1 | 355.0 | 399.5 | 652.9 | 657.1 | 800.9 | 976.2 | 1,190.0 | 1,450.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 519.1 | -113.0 | -31.2 | 403.4 | 273.1 | 267.2 | 342.9 | 418.0 | 509.5 | 621.1 |
WACC, % | 6.65 | 7.26 | 7.31 | 7.49 | 7.85 | 7.31 | 7.31 | 7.31 | 7.31 | 7.31 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,705.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 633 | |||||||||
Terminal Value | 11,929 | |||||||||
Present Terminal Value | 8,383 | |||||||||
Enterprise Value | 10,088 | |||||||||
Net Debt | 3,059 | |||||||||
Equity Value | 7,029 | |||||||||
Diluted Shares Outstanding, MM | 1,354 | |||||||||
Equity Value Per Share | 5.19 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Sendas Distribuidora S.A.'s (ASAI) financial data pre-filled to enhance your analysis.
- Automatic DCF Outputs: The template automatically computes Net Present Value (NPV) and intrinsic value for your convenience.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and optimizing your time.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as sales growth, operating margin, and capital investments.
- Instant DCF Valuation: Quickly calculates intrinsic value, net present value (NPV), and additional financial metrics.
- High-Precision Accuracy: Leverages Sendas Distribuidora S.A.'s (ASAI) actual financial data for credible valuation results.
- Effortless Scenario Analysis: Easily evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Streamline the valuation process without the hassle of constructing intricate models from the ground up.
How It Works
- 1. Download the Model: Obtain and open the Excel template containing Sendas Distribuidora S.A.'s (ASAI) financial data.
- 2. Modify Key Inputs: Adjust essential parameters such as revenue growth, discount rates, and capital investments.
- 3. Analyze Results Immediately: The DCF model automatically computes the intrinsic value and net present value (NPV).
- 4. Explore Different Scenarios: Evaluate various projections to understand the impact on valuation results.
- 5. Present with Assurance: Deliver expert valuation analyses to back your strategic decisions.
Why Choose This Calculator for Sendas Distribuidora S.A. (ASAI)?
- Accurate Data: Access to real Sendas Distribuidora financials ensures dependable valuation outcomes.
- Customizable: Tailor key metrics such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the industry.
- User-Friendly: An intuitive design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately estimate Sendas Distribuidora S.A.'s (ASAI) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis specific to Sendas Distribuidora S.A. (ASAI).
- Consultants: Quickly adapt the template for valuation reports tailored to Sendas Distribuidora S.A. (ASAI) clients.
- Entrepreneurs: Gain insights into financial modeling practices used by leading companies, including Sendas Distribuidora S.A. (ASAI).
- Educators: Use it as a teaching tool to illustrate valuation methodologies relevant to Sendas Distribuidora S.A. (ASAI).
What the Template Contains
- Pre-Filled Data: Includes Sendas Distribuidora S.A.'s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Sendas Distribuidora S.A.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.