Salem Media Group, Inc. (SALM) DCF Valuation

Salem Media Group, Inc. (SALM) 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

Salem Media Group, Inc. (SALM) 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 potential of Salem Media Group, Inc. (SALM) with our advanced DCF Calculator! Customize essential assumptions, explore various scenarios, and evaluate how adjustments affect Salem Media Group, Inc. (SALM) valuation – all within one comprehensive Excel template.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2018		 AY2
2019		 AY3
2020		 AY4
2021		 AY5
2022		 FY1
2023		 FY2
2024		 FY3
2025		 FY4
2026		 FY5
2027
Revenue 262.8 253.9 236.2 258.2 267.0 264.9 262.8 260.7 258.7 256.6
Revenue Growth, % 0 -3.38 -6.96 9.32 3.38 -0.78674 -0.78674 -0.78674 -0.78674 -0.78674
EBITDA 35.8 9.6 25.4 38.1 22.0 27.1 26.9 26.7 26.5 26.3
EBITDA, % 13.64 3.77 10.76 14.77 8.26 10.24 10.24 10.24 10.24 10.24
Depreciation 18.2 15.9 14.1 12.8 12.6 15.3 15.2 15.0 14.9 14.8
Depreciation, % 6.94 6.28 5.95 4.97 4.72 5.77 5.77 5.77 5.77 5.77
EBIT 17.6 -6.4 11.4 25.3 9.4 11.8 11.7 11.6 11.6 11.5
EBIT, % 6.7 -2.51 4.81 9.8 3.53 4.47 4.47 4.47 4.47 4.47
Total Cash .1 .0 6.3 1.8 .0 1.8 1.8 1.8 1.8 1.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 33.0 34.9 28.8 30.4 35.7
Account Receivables, % 12.57 13.76 12.18 11.79 13.36
Inventories .7 .7 .5 1.0 1.5 .9 .9 .9 .9 .9
Inventories, % 0.25763 0.2824 0.20953 0.37174 0.56674 0.33761 0.33761 0.33761 0.33761 0.33761
Accounts Payable 2.2 3.5 2.0 2.7 6.5 3.5 3.4 3.4 3.4 3.4
Accounts Payable, % 0.83225 1.37 0.84914 1.03 2.45 1.31 1.31 1.31 1.31 1.31
Capital Expenditure -9.3 -7.8 -4.8 -10.9 -13.4 -9.5 -9.4 -9.3 -9.2 -9.2
Capital Expenditure, % -3.56 -3.07 -2.02 -4.23 -5.01 -3.58 -3.58 -3.58 -3.58 -3.58
Tax Rate, % 10.8 10.8 10.8 10.8 10.8 10.8 10.8 10.8 10.8 10.8
EBITAT 78.2 -7.4 25.8 25.8 8.4 11.6 11.5 11.4 11.3 11.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 55.5 .1 40.0 26.2 5.8 16.9 17.5 17.4 17.2 17.1
WACC, % 6.26 6.26 6.26 6.26 5.61 6.13 6.13 6.13 6.13 6.13
PV UFCF
SUM PV UFCF 72.2
Long Term Growth Rate, % 3.50
Free cash flow (T + 1) 18
Terminal Value 673
Present Terminal Value 500
Enterprise Value 572
Net Debt 210
Equity Value 362
Diluted Shares Outstanding, MM 27
Equity Value Per Share 13.30

What You Will Get

  • Comprehensive SALM Financials: Access historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Real-Time Calculations: Intrinsic value and NPV are updated automatically.
  • Scenario Analysis: Explore various scenarios to assess Salem Media Group's future performance.
  • User-Friendly Design: Designed for professionals while remaining easy for newcomers to navigate.

Key Features

  • 🔍 Real-Life SALM Financials: Pre-filled historical and projected data for Salem Media Group, Inc.
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate Salem's intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize Salem's valuation instantly after making changes.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  • Download: Obtain the pre-prepared Excel file containing Salem Media Group, Inc.'s (SALM) financial data.
  • Customize: Modify forecasts such as revenue growth, EBITDA %, and WACC to fit your analysis.
  • Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Develop various projections and instantly compare the results.
  • Make Decisions: Leverage the valuation outcomes to inform your investment strategies.

Why Choose Salem Media Group, Inc. (SALM)?

  • Extensive Reach: Benefit from a wide audience across various media platforms.
  • Quality Content: Access a diverse range of programming that engages and informs.
  • Proven Track Record: A history of success in delivering impactful media solutions.
  • Innovative Strategies: Leverage cutting-edge marketing techniques to maximize visibility.
  • Expert Team: Work with industry professionals dedicated to achieving your goals.

Who Should Use This Product?

  • Media Investors: Develop comprehensive and accurate valuation models for analyzing investments in Salem Media Group, Inc. (SALM).
  • Corporate Strategy Teams: Evaluate valuation scenarios to inform strategic decisions within the media industry.
  • Consultants and Advisors: Deliver precise valuation insights for clients interested in Salem Media Group, Inc. (SALM).
  • Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling related to media companies.
  • Media Analysts: Gain a deeper understanding of how companies like Salem Media Group, Inc. (SALM) are valued in the marketplace.

What the Template Contains

  • Pre-Filled Data: Contains Salem Media Group’s historical financials and projections.
  • Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using custom inputs.
  • Key Financial Ratios: Evaluate Salem Media Group’s profitability, efficiency, and leverage.
  • Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
  • Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.

No products were found matching.