Corporación América Airports S.A. (CAAP) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Corporación América Airports S.A. (CAAP) Bundle
Looking to evaluate the intrinsic value of Corporación América Airports S.A.? Our (CAAP) DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment strategies.
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,558.6 | 607.4 | 706.9 | 1,378.7 | 1,400.0 | 1,581.8 | 1,787.2 | 2,019.3 | 2,281.5 | 2,577.7 |
Revenue Growth, % | 0 | -61.03 | 16.39 | 95.03 | 1.55 | 12.98 | 12.98 | 12.98 | 12.98 | 12.98 |
EBITDA | 300.5 | -67.8 | 199.3 | 494.2 | 445.1 | 328.8 | 371.5 | 419.8 | 474.3 | 535.9 |
EBITDA, % | 19.28 | -11.17 | 28.19 | 35.85 | 31.79 | 20.79 | 20.79 | 20.79 | 20.79 | 20.79 |
Depreciation | 182.2 | 200.3 | 160.0 | 133.6 | 150.7 | 277.6 | 313.7 | 354.4 | 400.4 | 452.4 |
Depreciation, % | 11.69 | 32.98 | 22.63 | 9.69 | 10.76 | 17.55 | 17.55 | 17.55 | 17.55 | 17.55 |
EBIT | 118.3 | -268.1 | 39.3 | 360.7 | 294.4 | 51.2 | 57.8 | 65.3 | 73.8 | 83.4 |
EBIT, % | 7.59 | -44.15 | 5.55 | 26.16 | 21.03 | 3.24 | 3.24 | 3.24 | 3.24 | 3.24 |
Total Cash | 279.5 | 354.9 | 451.1 | 452.0 | 457.9 | 650.7 | 735.1 | 830.6 | 938.4 | 1,060.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 120.0 | 90.0 | 159.7 | 174.9 | 271.2 | 244.1 | 275.8 | 311.6 | 352.1 | 397.8 |
Account Receivables, % | 7.7 | 14.81 | 22.6 | 12.69 | 19.37 | 15.43 | 15.43 | 15.43 | 15.43 | 15.43 |
Inventories | 11.3 | 8.0 | 11.5 | 15.8 | 16.1 | 18.9 | 21.3 | 24.1 | 27.2 | 30.8 |
Inventories, % | 0.72512 | 1.32 | 1.63 | 1.14 | 1.15 | 1.19 | 1.19 | 1.19 | 1.19 | 1.19 |
Accounts Payable | 148.8 | 150.9 | 116.2 | 124.1 | 112.8 | 214.8 | 242.6 | 274.1 | 309.7 | 350.0 |
Accounts Payable, % | 9.54 | 24.84 | 16.44 | 9 | 8.05 | 13.58 | 13.58 | 13.58 | 13.58 | 13.58 |
Capital Expenditure | -18.1 | -9.5 | -8.5 | -9.8 | -10.9 | -17.2 | -19.4 | -21.9 | -24.7 | -28.0 |
Capital Expenditure, % | -1.16 | -1.57 | -1.2 | -0.71248 | -0.77726 | -1.08 | -1.08 | -1.08 | -1.08 | -1.08 |
Tax Rate, % | -18.43 | -18.43 | -18.43 | -18.43 | -18.43 | -18.43 | -18.43 | -18.43 | -18.43 | -18.43 |
EBITAT | -61.1 | -258.0 | 69.2 | 318.3 | 348.7 | 39.4 | 44.5 | 50.2 | 56.8 | 64.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 120.5 | -31.8 | 112.8 | 430.5 | 380.4 | 426.2 | 332.5 | 375.7 | 424.5 | 479.6 |
WACC, % | 9.84 | 11.93 | 12.01 | 11.76 | 12.01 | 11.51 | 11.51 | 11.51 | 11.51 | 11.51 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,473.3 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 496 | |||||||||
Terminal Value | 6,198 | |||||||||
Present Terminal Value | 3,595 | |||||||||
Enterprise Value | 5,069 | |||||||||
Net Debt | 977 | |||||||||
Equity Value | 4,091 | |||||||||
Diluted Shares Outstanding, MM | 161 | |||||||||
Equity Value Per Share | 25.43 |
What You Will Get
- Real CAAP Financial Data: Pre-filled with Corporación América Airports S.A.'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 CAAP’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 DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Corporación América Airports S.A. (CAAP).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to the airport sector.
- Customizable Forecast Assumptions: Easily modify growth projections, capital expenditures, and discount rates for accurate forecasting.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Corporación América Airports S.A. (CAAP).
- Interactive Dashboard and Charts: Visual representations provide a summary of key valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the pre-built Excel file containing Corporación América Airports S.A.'s (CAAP) financial data.
- Customize: Modify projections, including passenger growth, EBITDA margin, and capital costs.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and analyze results instantly.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for Corporación América Airports S.A. (CAAP)?
- Accurate Data: Up-to-date financial information from CAAP guarantees trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with 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 aviation sector.
- User-Friendly: An intuitive interface and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessments related to Corporación América Airports S.A. (CAAP).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Corporación América Airports S.A. (CAAP).
- Students and Educators: Utilize real-world data to enhance financial modeling skills and education.
- Aviation Industry Enthusiasts: Gain insights into how airport management companies like Corporación América Airports S.A. (CAAP) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: Corporación América Airports S.A.’s (CAAP) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate CAAP’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.