Cumulus Media Inc. (CMLS) DCF Valuation

Cumulus Media Inc. (CMLS) 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

Cumulus Media Inc. (CMLS) 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 outlook of Cumulus Media Inc. (CMLS) with our user-friendly DCF Calculator! Enter your projections for growth, profit margins, and expenses to uncover the intrinsic value of Cumulus Media Inc. (CMLS) and enhance your investment decisions.


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,113.4 816.2 916.5 953.5 844.5 798.5 755.0 713.9 675.0 638.2
Revenue Growth, % 0 -26.69 12.28 4.04 -11.43 -5.45 -5.45 -5.45 -5.45 -5.45
EBITDA 243.0 59.5 119.6 158.4 35.8 100.7 95.2 90.0 85.1 80.5
EBITDA, % 21.83 7.29 13.06 16.61 4.24 12.61 12.61 12.61 12.61 12.61
Depreciation 76.6 70.4 59.9 63.3 58.2 56.8 53.7 50.8 48.0 45.4
Depreciation, % 6.88 8.62 6.54 6.64 6.89 7.11 7.11 7.11 7.11 7.11
EBIT 166.4 -10.9 59.7 95.1 -22.3 43.9 41.5 39.2 37.1 35.1
EBIT, % 14.95 -1.33 6.51 9.98 -2.64 5.49 5.49 5.49 5.49 5.49
Total Cash 15.1 271.8 177.0 107.4 80.7 119.4 112.9 106.8 101.0 95.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 245.4 203.3 198.8 212.3 182.2
Account Receivables, % 22.04 24.9 21.7 22.26 21.57
Inventories 88.9 .0 .0 .0 .0 12.7 12.1 11.4 10.8 10.2
Inventories, % 7.98 0.000000123 0 0 0 1.6 1.6 1.6 1.6 1.6
Accounts Payable 3.2 6.8 6.6 11.0 15.9 7.8 7.4 7.0 6.6 6.2
Accounts Payable, % 0.28596 0.83152 0.72463 1.15 1.88 0.97469 0.97469 0.97469 0.97469 0.97469
Capital Expenditure -29.5 -14.9 -29.1 -31.1 -24.8 -22.1 -20.9 -19.8 -18.7 -17.7
Capital Expenditure, % -2.65 -1.82 -3.17 -3.26 -2.94 -2.77 -2.77 -2.77 -2.77 -2.77
Tax Rate, % -17.06 -17.06 -17.06 -17.06 -17.06 -17.06 -17.06 -17.06 -17.06 -17.06
EBITAT 122.1 -8.2 50.9 78.8 -26.1 36.6 34.6 32.7 30.9 29.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -161.9 181.9 86.1 101.8 42.3 53.0 77.5 73.2 69.3 65.5
WACC, % 6.5 6.7 7.53 7.32 8.8 7.37 7.37 7.37 7.37 7.37
PV UFCF
SUM PV UFCF 273.7
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 66
Terminal Value 958
Present Terminal Value 671
Enterprise Value 945
Net Debt 732
Equity Value 212
Diluted Shares Outstanding, MM 17
Equity Value Per Share 12.30

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real CMLS financials.
  • Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Instantly visualize the effect of your inputs on Cumulus Media's valuation.
  • 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

  • Pre-Loaded Data: Cumulus Media 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: Observe Cumulus Media Inc.’s intrinsic value recalculating in real time.
  • Clear Visual Outputs: Dashboard charts present valuation results and key metrics clearly.
  • Built for Accuracy: A professional tool tailored for analysts, investors, and finance experts.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Cumulus Media Inc.'s (CMLS) preloaded financial data.
  • 2. Adjust Key Inputs: Modify essential parameters such as revenue growth rates, WACC, and capital expenditures.
  • 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV based on your inputs.
  • 4. Explore Different Scenarios: Evaluate various forecasts to understand potential valuation variations.
  • 5. Present with Assurance: Share professional valuation findings to enhance your strategic decisions.

Why Choose This Calculator for Cumulus Media Inc. (CMLS)?

  • All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for Cumulus Media Inc. (CMLS).
  • Flexible Inputs: Modify the highlighted cells to explore different financial scenarios.
  • In-Depth Analysis: Automatically computes Cumulus Media Inc.'s (CMLS) intrinsic value and Net Present Value.
  • Preloaded Information: Features historical and projected data for precise evaluations.
  • Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focusing on Cumulus Media Inc. (CMLS).

Who Should Use Cumulus Media Inc. (CMLS)?

  • Investors: Gain insights into the broadcasting industry with a reliable analysis tool.
  • Market Analysts: Streamline your research with comprehensive data on media trends.
  • Consultants: Easily modify reports for clients in the media sector.
  • Media Enthusiasts: Enhance your knowledge of radio and digital broadcasting dynamics.
  • Educators and Students: Utilize it as a resource for studies in media and communications courses.

What the Template Contains

  • Historical Data: Includes Cumulus Media Inc.'s (CMLS) past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Cumulus Media Inc.'s (CMLS) intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of Cumulus Media Inc.'s (CMLS) financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.