Azul S.A. (AZUL) DCF Valuation

Azul S.A. (AZUL) DCF Valuation
  • Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • Professional Design: Trusted, Industry-Standard Templates
  • Pre-Built For Quick And Efficient Use
  • No Expertise Is Needed; Easy To Follow

Azul S.A. (AZUL) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Discover the true value of Azul S.A. (AZUL) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how changes influence Azul S.A. (AZUL) valuation – all within a comprehensive Excel template.


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
Account Receivables, % 12.07 19.72 11.87 11.75 7.24
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.