The New York Times Company (NYT) DCF Valuation

The New York Times Company (NYT) DCF Valuation

US | Communication Services | Publishing | NYSE
The New York Times Company (NYT) 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

The New York Times Company (NYT) Bundle

Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Assess The New York Times Company's (NYT) financial outlook like an expert! This (NYT) DCF Calculator comes with pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to match your projections.


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,812.2 1,783.6 2,074.9 2,308.3 2,426.2 2,614.8 2,818.2 3,037.4 3,273.6 3,528.2
Revenue Growth, % 0 -1.58 16.33 11.25 5.1 7.78 7.78 7.78 7.78 7.78
EBITDA 257.9 186.9 358.3 328.6 398.9 380.0 409.5 441.3 475.7 512.7
EBITDA, % 14.23 10.48 17.27 14.23 16.44 14.53 14.53 14.53 14.53 14.53
Depreciation 68.0 70.7 67.0 92.6 95.3 98.8 106.5 114.7 123.7 133.3
Depreciation, % 3.75 3.96 3.23 4.01 3.93 3.78 3.78 3.78 3.78 3.78
EBIT 189.9 116.2 291.3 236.0 303.6 281.2 303.0 326.6 352.0 379.4
EBIT, % 10.48 6.51 14.04 10.22 12.51 10.75 10.75 10.75 10.75 10.75
Total Cash 432.2 595.2 661.0 347.4 451.6 641.9 691.8 745.6 803.6 866.1
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 213.4 183.7 232.9 217.5 242.5
Account Receivables, % 11.78 10.3 11.23 9.42 9.99
Inventories 29.1 29.5 33.2 54.9 .0 37.8 40.8 44.0 47.4 51.1
Inventories, % 1.61 1.65 1.6 2.38 0 1.45 1.45 1.45 1.45 1.45
Accounts Payable 116.6 123.2 127.1 114.6 116.9 153.0 164.9 177.7 191.5 206.4
Accounts Payable, % 6.43 6.9 6.12 4.97 4.82 5.85 5.85 5.85 5.85 5.85
Capital Expenditure -45.4 -34.5 -34.6 -37.0 -22.7 -45.2 -48.7 -52.5 -56.6 -61.0
Capital Expenditure, % -2.51 -1.93 -1.67 -1.6 -0.93436 -1.73 -1.73 -1.73 -1.73 -1.73
Tax Rate, % 23.2 23.2 23.2 23.2 23.2 23.2 23.2 23.2 23.2 23.2
EBITAT 161.6 100.7 220.6 173.9 233.2 223.8 241.2 260.0 280.2 302.0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 58.3 172.9 203.9 210.8 338.0 242.4 286.5 308.8 332.8 358.7
WACC, % 9.23 9.23 9.23 9.23 9.23 9.23 9.23 9.23 9.23 9.23
PV UFCF
SUM PV UFCF 1,163.3
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 369
Terminal Value 5,928
Present Terminal Value 3,812
Enterprise Value 4,975
Net Debt -247
Equity Value 5,222
Diluted Shares Outstanding, MM 166
Equity Value Per Share 31.52

What You Will Receive

  • Pre-Filled Financial Model: The New York Times Company's actual data facilitates accurate DCF valuation.
  • Comprehensive Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
  • Real-Time Calculations: Automatic updates provide immediate results as adjustments are made.
  • Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
  • Customizable and Reusable: Designed for adaptability, allowing for repeated use in detailed forecasting.

Key Features

  • Comprehensive NYT Data: Pre-filled with The New York Times Company's historical financials and future projections.
  • Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
  • Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your inputs.
  • Scenario Testing: Develop multiple forecasting scenarios to explore various valuation outcomes.
  • User-Friendly Design: Intuitive, organized, and crafted for both professionals and novices.

How It Works

  1. Download the Template: Get instant access to the Excel-based NYT DCF Calculator.
  2. Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
  3. Instant Calculations: The model automatically updates The New York Times Company's intrinsic value.
  4. Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
  5. Analyze and Decide: Use the results to guide your investment or financial analysis.

Why Choose The New York Times Company (NYT)?

  • Stay Informed: Access a wealth of news and insights from a trusted source.
  • Quality Journalism: Experience in-depth reporting and analysis from seasoned professionals.
  • Engaging Content: Discover a variety of articles, podcasts, and multimedia experiences.
  • Personalized Experience: Tailor your news feed to match your interests and preferences.
  • Proven Track Record: Join millions of readers who rely on us for accurate and timely information.

Who Should Use This Product?

  • Journalism Students: Explore reporting techniques and apply them using real-world examples from The New York Times (NYT).
  • Researchers: Utilize data and insights from The New York Times (NYT) in academic projects or studies.
  • Media Analysts: Evaluate media trends and analyze readership metrics for The New York Times (NYT).
  • Content Creators: Enhance your storytelling skills by examining professional articles from The New York Times (NYT).
  • Small Business Owners: Understand how media coverage impacts businesses by analyzing articles from The New York Times (NYT).

What the Template Contains

  • Historical Data: Includes The New York Times Company's (NYT) past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate The New York Times Company's (NYT) 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 The New York Times Company's (NYT) financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.