Saga Communications, Inc. (SGA) DCF Valuation

Saga Communications, Inc. (SGA) 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

Saga Communications, Inc. (SGA) 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:

Explore the financial future of Saga Communications, Inc. (SGA) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Saga Communications, Inc. (SGA) and enhance your investment decision-making.


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 123.1 95.8 108.3 114.9 112.8 111.4 110.0 108.7 107.4 106.1
Revenue Growth, % 0 -22.15 13.08 6.05 -1.85 -1.22 -1.22 -1.22 -1.22 -1.22
EBITDA 25.8 5.7 20.8 18.2 18.1 17.4 17.2 16.9 16.7 16.5
EBITDA, % 20.93 5.9 19.2 15.86 16.05 15.59 15.59 15.59 15.59 15.59
Depreciation 6.9 6.5 5.7 5.2 5.1 6.0 5.9 5.8 5.7 5.7
Depreciation, % 5.64 6.81 5.31 4.5 4.48 5.35 5.35 5.35 5.35 5.35
EBIT 18.8 -.9 15.1 13.1 13.0 11.4 11.3 11.1 11.0 10.9
EBIT, % 15.28 -0.90593 13.89 11.36 11.57 10.24 10.24 10.24 10.24 10.24
Total Cash 44.0 51.4 54.8 46.9 40.2 48.2 47.6 47.0 46.5 45.9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 20.2 16.6 17.2 18.5 18.0
Account Receivables, % 16.42 17.35 15.91 16.06 15.98
Inventories .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0.0000010437 0 0.00000087 0 0.000000383 0.000000383 0.000000383 0.000000383 0.000000383
Accounts Payable 2.1 3.0 3.2 3.6 2.8 3.0 3.0 2.9 2.9 2.9
Accounts Payable, % 1.72 3.14 3 3.17 2.48 2.7 2.7 2.7 2.7 2.7
Capital Expenditure -6.5 -2.5 -4.1 -6.1 -4.4 -4.6 -4.6 -4.5 -4.5 -4.4
Capital Expenditure, % -5.28 -2.61 -3.8 -5.27 -3.86 -4.16 -4.16 -4.16 -4.16 -4.16
Tax Rate, % 26.21 26.21 26.21 26.21 26.21 26.21 26.21 26.21 26.21 26.21
EBITAT 13.4 -1.4 10.9 8.6 9.6 8.7 8.6 8.5 8.4 8.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -4.3 7.1 12.2 6.9 9.9 10.1 10.1 10.0 9.9 9.8
WACC, % 5.7 5.82 5.7 5.67 5.71 5.72 5.72 5.72 5.72 5.72
PV UFCF
SUM PV UFCF 42.3
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 10
Terminal Value 188
Present Terminal Value 142
Enterprise Value 185
Net Debt -22
Equity Value 207
Diluted Shares Outstanding, MM 6
Equity Value Per Share 34.20

What You Will Receive

  • Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real SGA financials.
  • Authentic Data: Historical figures and future projections (displayed in the highlighted cells).
  • Flexible Forecasting: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
  • Instant Calculations: Quickly observe how your inputs affect Saga Communications’ valuation.
  • Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
  • Intuitive Layout: Organized for clarity and simplicity, complete with step-by-step guidance.

Key Features

  • Pre-Loaded Data: Saga Communications, Inc.’s historical financial statements and pre-filled forecasts.
  • Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Instant Results: Watch Saga Communications, Inc.’s intrinsic value update in real time.
  • Clear Visual Outputs: Dashboard charts illustrate valuation results and essential metrics.
  • Built for Accuracy: A professional tool designed for analysts, investors, and finance professionals.

How It Works

  • Download: Get the pre-prepared Excel file containing Saga Communications, Inc.'s (SGA) financial data.
  • Customize: Modify forecasts such as revenue growth, EBITDA %, and WACC to fit your analysis.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
  • Test Scenarios: Develop various projections and instantly compare the results.
  • Make Decisions: Utilize the valuation findings to inform your investment strategy for Saga Communications, Inc. (SGA).

Why Choose This Calculator for Saga Communications, Inc. (SGA)?

  • User-Friendly Interface: Perfectly crafted for both novices and seasoned users.
  • Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
  • Real-Time Valuation: Observe immediate updates to Saga’s valuation with each input change.
  • Pre-Loaded Data: Comes equipped with Saga’s latest financial figures for swift evaluations.
  • Relied Upon by Experts: Favored by investors and analysts for making strategic decisions.

Who Should Use Saga Communications, Inc. (SGA)?

  • Investors: Gain insights and make informed decisions with our comprehensive media analysis tools.
  • Media Analysts: Streamline your research process with easy-to-use templates tailored for the broadcasting industry.
  • Consultants: Effortlessly customize reports for clients focusing on media and communications strategies.
  • Broadcast Enthusiasts: Enhance your knowledge of the media landscape through detailed case studies and examples.
  • Educators and Students: Utilize our resources as a hands-on learning aid in media and communications courses.

What the Template Contains

  • Pre-Filled DCF Model: Saga Communications, Inc.'s (SGA) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Saga Communications, Inc.'s (SGA) 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.