Frontier Group Holdings, Inc. (ULCC) DCF Valuation

Frontier Group Holdings, Inc. (ULCC) 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

Frontier Group Holdings, Inc. (ULCC) 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:

Assess the financial outlook of Frontier Group Holdings, Inc. (ULCC) like a seasoned expert! This (ULCC) DCF Calculator comes with pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your projections.


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 2,508.0 1,250.0 2,060.0 3,326.0 3,589.0 4,342.7 5,254.7 6,358.3 7,693.6 9,309.3
Revenue Growth, % 0 -50.16 64.8 61.46 7.91 21 21 21 21 21
EBITDA 371.0 -327.0 -99.0 3.0 83.0 -119.6 -144.7 -175.1 -211.9 -256.4
EBITDA, % 14.79 -26.16 -4.81 0.09019844 2.31 -2.75 -2.75 -2.75 -2.75 -2.75
Depreciation 46.0 33.0 38.0 45.0 50.0 78.7 95.3 115.3 139.5 168.8
Depreciation, % 1.83 2.64 1.84 1.35 1.39 1.81 1.81 1.81 1.81 1.81
EBIT 325.0 -360.0 -137.0 -42.0 33.0 -198.3 -240.0 -290.4 -351.4 -425.2
EBIT, % 12.96 -28.8 -6.65 -1.26 0.91948 -4.57 -4.57 -4.57 -4.57 -4.57
Total Cash 768.0 378.0 918.0 761.0 609.0 1,261.8 1,526.8 1,847.4 2,235.4 2,704.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 101.0 215.0 62.0 98.0 96.0
Account Receivables, % 4.03 17.2 3.01 2.95 2.67
Inventories 20.0 18.0 29.0 55.0 79.0 65.1 78.8 95.4 115.4 139.6
Inventories, % 0.79745 1.44 1.41 1.65 2.2 1.5 1.5 1.5 1.5 1.5
Accounts Payable 71.0 71.0 86.0 89.0 134.0 165.9 200.7 242.8 293.8 355.5
Accounts Payable, % 2.83 5.68 4.17 2.68 3.73 3.82 3.82 3.82 3.82 3.82
Capital Expenditure -62.0 -16.0 -63.0 -152.0 -87.0 -119.9 -145.1 -175.5 -212.4 -257.0
Capital Expenditure, % -2.47 -1.28 -3.06 -4.57 -2.42 -2.76 -2.76 -2.76 -2.76 -2.76
Tax Rate, % 134.38 134.38 134.38 134.38 134.38 134.38 134.38 134.38 134.38 134.38
EBITAT 251.0 -217.7 -97.0 -34.5 -11.3 -115.3 -139.6 -168.9 -204.3 -247.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 185.0 -312.7 35.0 -200.5 -25.3 -274.1 -222.7 -269.5 -326.0 -394.5
WACC, % 7.47 6.96 7.27 7.62 5.11 6.89 6.89 6.89 6.89 6.89
PV UFCF
SUM PV UFCF -1,204.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -402
Terminal Value -8,233
Present Terminal Value -5,901
Enterprise Value -7,106
Net Debt 2,850
Equity Value -9,956
Diluted Shares Outstanding, MM 220
Equity Value Per Share -45.23

What You Will Receive

  • Pre-Filled Financial Model: Frontier Group Holdings, Inc.'s (ULCC) actual data facilitates accurate DCF valuation.
  • Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
  • Immediate Calculations: Real-time updates ensure you see the outcomes as you make adjustments.
  • Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
  • Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.

Key Features

  • Pre-Loaded Data: Frontier Group Holdings, Inc.'s (ULCC) historical financial statements and pre-filled forecasts.
  • Fully Adjustable Inputs: Edit WACC, tax rates, revenue growth, and EBITDA margins tailored for (ULCC).
  • Instant Results: Observe (ULCC)'s intrinsic value recalculating in real time.
  • Clear Visual Outputs: Dashboard charts illustrate valuation results and key metrics for (ULCC).
  • Built for Accuracy: A professional tool designed for analysts, investors, and finance experts focusing on (ULCC).

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review Frontier Group Holdings, Inc.'s pre-filled financial data and forecasts.
  3. Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Watch the DCF model update instantly as you tweak assumptions.
  5. Step 5: Analyze the outputs and use the results for investment decisions regarding Frontier Group Holdings, Inc. (ULCC).

Why Choose This Calculator for Frontier Group Holdings, Inc. (ULCC)?

  • Accurate Data: Access real financials from Frontier Group Holdings for dependable valuation outcomes.
  • Customizable: Tailor essential variables such as growth rates, WACC, and tax rates to fit your forecasts.
  • Time-Saving: Built-in 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: Easy-to-navigate layout and comprehensive instructions ensure accessibility for all users.

Who Should Use Frontier Group Holdings, Inc. (ULCC)?

  • Investors: Gain insights and make informed decisions with a reliable analysis of Frontier Group Holdings, Inc. (ULCC).
  • Financial Analysts: Enhance efficiency with tailored financial models specific to Frontier Group Holdings, Inc. (ULCC).
  • Consultants: Easily modify reports and presentations to reflect the unique aspects of Frontier Group Holdings, Inc. (ULCC).
  • Finance Enthusiasts: Explore the aviation industry's valuation strategies through the lens of Frontier Group Holdings, Inc. (ULCC).
  • Educators and Students: Utilize as a hands-on resource for learning about the airline sector in finance courses.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Frontier Group Holdings 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 Frontier Group Holdings, Inc. (ULCC).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.