|
Nexstar Media Group, Inc. (NXST) DCF Valuation
US | Communication Services | Entertainment | NASDAQ
|
- ✓ 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
Nexstar Media Group, Inc. (NXST) Bundle
Whether you're an investor or analyst, this (NXST) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Nexstar Media Group, Inc., you can adjust forecasts and instantly observe the effects.
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 | 3,039.3 | 4,501.3 | 4,648.4 | 5,211.0 | 4,933.0 | 5,650.0 | 6,471.2 | 7,411.7 | 8,489.0 | 9,722.8 |
| Revenue Growth, % | 0 | 48.1 | 3.27 | 12.1 | -5.33 | 14.53 | 14.53 | 14.53 | 14.53 | 14.53 |
| EBITDA | 1,086.4 | 2,004.8 | 1,964.5 | 2,215.8 | 1,789.0 | 2,275.0 | 2,605.7 | 2,984.4 | 3,418.2 | 3,915.0 |
| EBITDA, % | 35.74 | 44.54 | 42.26 | 42.52 | 36.27 | 40.27 | 40.27 | 40.27 | 40.27 | 40.27 |
| Depreciation | 408.7 | 564.9 | 588.5 | 662.1 | 941.0 | 796.0 | 911.7 | 1,044.2 | 1,195.9 | 1,369.7 |
| Depreciation, % | 13.45 | 12.55 | 12.66 | 12.71 | 19.08 | 14.09 | 14.09 | 14.09 | 14.09 | 14.09 |
| EBIT | 677.7 | 1,439.9 | 1,376.0 | 1,553.7 | 848.0 | 1,479.1 | 1,694.1 | 1,940.3 | 2,222.3 | 2,545.3 |
| EBIT, % | 22.3 | 31.99 | 29.6 | 29.82 | 17.19 | 26.18 | 26.18 | 26.18 | 26.18 | 26.18 |
| Total Cash | 232.1 | 152.7 | 190.9 | 204.1 | 147.0 | 248.9 | 285.1 | 326.6 | 374.0 | 428.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 883.9 | 904.8 | 1,021.1 | 1,079.4 | 1,095.0 | 1,288.9 | 1,476.2 | 1,690.8 | 1,936.5 | 2,218.0 |
| Account Receivables, % | 29.08 | 20.1 | 21.97 | 20.71 | 22.2 | 22.81 | 22.81 | 22.81 | 22.81 | 22.81 |
| Inventories | 168.6 | .0 | .0 | 15.6 | .0 | 66.1 | 75.7 | 86.7 | 99.3 | 113.7 |
| Inventories, % | 5.55 | 0.0000000222 | 0.0000000215 | 0.29937 | 0 | 1.17 | 1.17 | 1.17 | 1.17 | 1.17 |
| Accounts Payable | 157.4 | 218.4 | 248.2 | 197.7 | 235.0 | 270.4 | 309.7 | 354.7 | 406.2 | 465.3 |
| Accounts Payable, % | 5.18 | 4.85 | 5.34 | 3.79 | 4.76 | 4.79 | 4.79 | 4.79 | 4.79 | 4.79 |
| Capital Expenditure | -197.5 | -217.0 | -150.8 | -157.3 | -149.0 | -232.8 | -266.6 | -305.4 | -349.8 | -400.6 |
| Capital Expenditure, % | -6.5 | -4.82 | -3.24 | -3.02 | -3.02 | -4.12 | -4.12 | -4.12 | -4.12 | -4.12 |
| Tax Rate, % | 13.72 | 13.72 | 13.72 | 13.72 | 13.72 | 13.72 | 13.72 | 13.72 | 13.72 | 13.72 |
| EBITAT | 418.0 | 1,057.8 | 1,049.6 | 1,239.5 | 731.7 | 1,116.7 | 1,279.0 | 1,464.9 | 1,677.8 | 1,921.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -266.0 | 1,614.5 | 1,400.9 | 1,619.9 | 1,561.0 | 1,455.3 | 1,766.4 | 2,023.1 | 2,317.1 | 2,653.9 |
| WACC, % | 7.22 | 7.63 | 7.73 | 7.85 | 8.08 | 7.71 | 7.71 | 7.71 | 7.71 | 7.71 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 8,045.9 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 2,667 | |||||||||
| Terminal Value | 37,017 | |||||||||
| Present Terminal Value | 25,539 | |||||||||
| Enterprise Value | 33,585 | |||||||||
| Net Debt | 6,983 | |||||||||
| Equity Value | 26,602 | |||||||||
| Diluted Shares Outstanding, MM | 36 | |||||||||
| Equity Value Per Share | 742.38 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Nexstar Media Group, Inc.'s (NXST) financial data pre-filled to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adjusts to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life NXST Financials: Pre-filled historical and projected data for Nexstar 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 Nexstar’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Nexstar’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based NXST DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Nexstar Media Group's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Nexstar Media Group, Inc. (NXST)?
- Accuracy: Utilizes real Nexstar financials for precise data.
- Flexibility: Allows users to easily adjust and test various inputs.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive interface suitable for users with all levels of financial modeling experience.
Who Should Use This Product?
- Media Investors: Create comprehensive and dependable valuation models for analyzing Nexstar Media Group, Inc. (NXST) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within media operations.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Nexstar Media Group, Inc. (NXST).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling related to media companies.
- Media Industry Analysts: Gain insights into how companies like Nexstar Media Group, Inc. (NXST) are valued in the competitive media landscape.
What the Nexstar Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Nexstar Media Group.
- Real-World Data: Nexstar’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results regarding Nexstar Media Group, Inc. (NXST).