Sun Country Airlines Holdings, Inc. (SNCY) DCF Valuation

Sun Country Airlines Holdings, Inc. (SNCY) DCF Valuation
  • ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • ✓ Aucune Expertise N'Est Requise; Facile À Suivre

Sun Country Airlines Holdings, Inc. (SNCY) 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:

Whether you're an investor or an analyst, this (SNCY) DCF Calculator is your go-to resource for accurate valuation. Featuring real data from Sun Country Airlines Holdings, Inc., you can easily adjust forecasts and observe the effects in real-time.


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 701.4 401.5 623.0 894.4 1,049.6 1,242.1 1,469.8 1,739.2 2,058.1 2,435.4
Revenue Growth, % 0 -42.76 55.18 43.57 17.35 18.33 18.33 18.33 18.33 18.33
EBITDA 120.1 91.4 200.2 123.3 226.2 266.7 315.6 373.4 441.9 522.9
EBITDA, % 17.12 22.75 32.14 13.79 21.55 21.47 21.47 21.47 21.47 21.47
Depreciation 34.9 74.0 73.6 69.2 89.5 127.8 151.3 179.0 211.8 250.6
Depreciation, % 4.97 18.42 11.81 7.73 8.52 10.29 10.29 10.29 10.29 10.29
EBIT 85.2 17.4 126.7 54.2 136.8 138.9 164.3 194.4 230.1 272.3
EBIT, % 12.15 4.33 20.33 6.06 13.03 11.18 11.18 11.18 11.18 11.18
Total Cash 56.7 67.7 309.3 92.1 187.4 255.2 302.0 357.3 422.9 500.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 22.4 28.7 30.2 35.1 38.2
Account Receivables, % 3.19 7.15 4.84 3.93 3.64
Inventories 5.3 5.4 5.4 7.7 7.8 11.3 13.4 15.9 18.8 22.2
Inventories, % 0.7518 1.35 0.86756 0.85629 0.74246 0.91297 0.91297 0.91297 0.91297 0.91297
Accounts Payable 43.9 34.0 39.8 62.4 59.0 83.8 99.1 117.3 138.8 164.2
Accounts Payable, % 6.26 8.48 6.39 6.97 5.62 6.74 6.74 6.74 6.74 6.74
Capital Expenditure -69.8 -96.3 -116.3 -187.9 -218.2 -234.5 -277.5 -328.4 -388.6 -459.8
Capital Expenditure, % -9.95 -23.99 -18.67 -21.01 -20.78 -18.88 -18.88 -18.88 -18.88 -18.88
Tax Rate, % 23.34 23.34 23.34 23.34 23.34 23.34 23.34 23.34 23.34 23.34
EBITAT 65.3 14.5 107.8 39.9 104.9 109.8 130.0 153.8 182.0 215.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 46.5 -24.1 69.4 -63.5 -30.4 6.0 6.7 7.9 9.3 11.0
WACC, % 8.46 8.64 8.69 8.38 8.46 8.52 8.52 8.52 8.52 8.52
PV UFCF
SUM PV UFCF 31.4
Long Term Growth Rate, % 3.50
Free cash flow (T + 1) 11
Terminal Value 227
Present Terminal Value 151
Enterprise Value 183
Net Debt 651
Equity Value -469
Diluted Shares Outstanding, MM 59
Equity Value Per Share -8.01

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled financial data for Sun Country Airlines Holdings, Inc. (SNCY).
  • Real-World Data: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Quickly observe how your inputs influence the valuation of Sun Country Airlines.
  • Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.

Key Features

  • Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Sun Country Airlines Holdings, Inc. (SNCY).
  • WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with customizable parameters for accurate assessments.
  • Adjustable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to suit your analysis.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Sun Country Airlines Holdings, Inc. (SNCY).
  • Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.

How It Works

  • Download: Obtain the comprehensive Excel file featuring Sun Country Airlines' financial data.
  • Customize: Tailor your forecasts, including passenger growth, operating margin %, and cost of capital.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Generate various projections and evaluate results instantly.
  • Make Decisions: Leverage the valuation insights to inform your investment strategy for Sun Country Airlines Holdings, Inc. (SNCY).

Why Choose This Calculator?

  • Designed for Industry Experts: A sophisticated tool utilized by analysts, CFOs, and aviation consultants.
  • Accurate Financial Data: Sun Country Airlines' historical and projected financials preloaded for precision.
  • Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly Interface: Step-by-step guidance to navigate through the calculations.

Who Should Use This Product?

  • Investors: Accurately assess Sun Country Airlines’ fair value before making investment choices.
  • CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to SNCY.
  • Consultants: Efficiently customize the template for valuation reports tailored to clients in the airline industry.
  • Entrepreneurs: Gain valuable insights into financial modeling practices adopted by major airlines.
  • Educators: Employ it as a teaching resource to illustrate valuation methodologies in the aviation sector.

What the Template Contains

  • Pre-Filled DCF Model: Sun Country Airlines' financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Sun Country Airlines' 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.

No products were found matching.