|
Azul S.A. (Azul) DCF Valoración
BR | Industrials | Airlines, Airports & Air Services | 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
Azul S.A. (AZUL) Bundle
¡Descubra el verdadero valor de Azul S.A. (Azul) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los cambios influyen en la valoración de Azul S.A. (Azul), todo dentro de una plantilla de Excel integral.
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 | 1,850.6 | 929.0 | 1,613.4 | 2,579.4 | 3,000.9 | 3,751.8 | 4,690.5 | 5,864.0 | 7,331.2 | 9,165.5 |
| Revenue Growth, % | 0 | -49.8 | 73.67 | 59.87 | 16.34 | 25.02 | 25.02 | 25.02 | 25.02 | 25.02 |
| EBITDA | 27.0 | -1,059.2 | 91.6 | 843.9 | 747.1 | -264.6 | -330.7 | -413.5 | -517.0 | -646.3 |
| EBITDA, % | 1.46 | -114.01 | 5.68 | 32.72 | 24.89 | -7.05 | -7.05 | -7.05 | -7.05 | -7.05 |
| Depreciation | 593.7 | 292.0 | 249.8 | 338.7 | 388.9 | 788.5 | 985.8 | 1,232.5 | 1,540.8 | 1,926.3 |
| Depreciation, % | 32.08 | 31.43 | 15.48 | 13.13 | 12.96 | 21.02 | 21.02 | 21.02 | 21.02 | 21.02 |
| EBIT | -566.8 | -1,351.2 | -158.2 | 505.1 | 358.2 | -817.2 | -1,021.7 | -1,277.3 | -1,596.9 | -1,996.4 |
| EBIT, % | -30.63 | -145.45 | -9.8 | 19.58 | 11.94 | -21.78 | -21.78 | -21.78 | -21.78 | -21.78 |
| Total Cash | 276.6 | 510.5 | 497.4 | 108.1 | 306.9 | 864.0 | 1,080.1 | 1,350.4 | 1,688.3 | 2,110.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 223.3 | 183.2 | 191.5 | 303.1 | 217.3 | 470.0 | 587.6 | 734.7 | 918.5 | 1,148.3 |
| Account Receivables, % | 12.07 | 19.72 | 11.87 | 11.75 | 7.24 | 12.53 | 12.53 | 12.53 | 12.53 | 12.53 |
| Inventories | 42.2 | 65.1 | 92.5 | 116.7 | 165.0 | 187.9 | 235.0 | 293.7 | 367.2 | 459.1 |
| Inventories, % | 2.28 | 7.01 | 5.73 | 4.53 | 5.5 | 5.01 | 5.01 | 5.01 | 5.01 | 5.01 |
| Accounts Payable | 212.4 | 329.3 | 248.1 | 407.2 | 368.4 | 678.0 | 847.7 | 1,059.8 | 1,324.9 | 1,656.5 |
| Accounts Payable, % | 11.48 | 35.44 | 15.38 | 15.79 | 12.28 | 18.07 | 18.07 | 18.07 | 18.07 | 18.07 |
| Capital Expenditure | -231.0 | -55.5 | -101.0 | -202.6 | -129.9 | -276.8 | -346.1 | -432.7 | -541.0 | -676.3 |
| Capital Expenditure, % | -12.48 | -5.97 | -6.26 | -7.85 | -4.33 | -7.38 | -7.38 | -7.38 | -7.38 | -7.38 |
| Tax Rate, % | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 |
| EBITAT | -676.0 | -1,321.7 | -158.2 | 505.1 | 364.3 | -813.6 | -1,017.2 | -1,271.7 | -1,589.9 | -1,987.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -366.3 | -951.1 | -126.2 | 664.5 | 621.9 | -268.0 | -372.5 | -465.7 | -582.2 | -727.8 |
| WACC, % | 16.82 | 16.48 | 16.82 | 16.82 | 16.82 | 16.75 | 16.75 | 16.75 | 16.75 | 16.75 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,444.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -742 | |||||||||
| Terminal Value | -5,033 | |||||||||
| Present Terminal Value | -2,320 | |||||||||
| Enterprise Value | -3,765 | |||||||||
| Net Debt | 3,953 | |||||||||
| Equity Value | -7,718 | |||||||||
| Diluted Shares Outstanding, MM | 348 | |||||||||
| Equity Value Per Share | -22.21 |
What You Will Get
- Real AZUL 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 automatically.
- Scenario Analysis: Explore various scenarios to assess Azul S.A.'s future performance.
- User-Friendly Design: Designed for professionals while remaining accessible to newcomers.
Key Features
- Comprehensive AZUL Data: Pre-loaded with Azul S.A.'s historical performance metrics and future growth forecasts.
- Customizable Assumptions: Tailor inputs for revenue growth, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Framework: Real-time updates to Net Present Value (NPV) and intrinsic value based on user-defined parameters.
- Forecast Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive User Interface: Designed for ease of use, accommodating both seasoned professionals and newcomers.
How It Works
- Download: Obtain the pre-formatted Excel file featuring Azul S.A.'s (AZUL) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA margin, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare results.
- Make Decisions: Utilize the valuation outputs to inform your investment approach.
Why Choose This Calculator for Azul S.A. (AZUL)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and consultants.
- Accurate Historical Data: Azul's past and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience.
Who Should Use Azul S.A. (AZUL)?
- Investors: Gain insights into the airline industry with comprehensive data and analysis tools.
- Financial Analysts: Streamline your workflow with detailed reports and metrics tailored for the aviation sector.
- Consultants: Effortlessly customize presentations and proposals for clients in the travel and transportation industry.
- Airline Enthusiasts: Enhance your knowledge of airline operations and market trends through in-depth case studies.
- Educators and Students: Utilize real-world scenarios to enrich finance and business curriculum related to aviation.
What the Azul S.A. Template Contains
- Preloaded AZUL Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.