John Wiley & Sons, Inc. (WLY) DCF Valuation

John Wiley & Sons, Inc. (WLY) DCF Valuation
  • ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
  • ✓ No Se Necesita Experiencia; Fáciles De Seguir

John Wiley & Sons, Inc. (WLY) 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:

Enhance your investment strategies with the [Symbol] DCF Calculator! Explore the latest financial data for John Wiley & Sons, Inc., adjust growth projections and expenses, and instantly visualize how these changes affect [Symbol] intrinsic value.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2020		 AY2
2021		 AY3
2022		 AY4
2023		 AY5
2024		 FY1
2025		 FY2
2026		 FY3
2027		 FY4
2028		 FY5
2029
Revenue 1,831.5 1,941.5 2,082.9 2,019.9 1,873.0 1,898.4 1,924.2 1,950.3 1,976.8 2,003.6
Revenue Growth, % 0 6.01 7.28 -3.03 -7.27 1.36 1.36 1.36 1.36 1.36
EBITDA 141.6 395.9 445.6 293.6 52.3 253.8 257.2 260.7 264.3 267.8
EBITDA, % 7.73 20.39 21.39 14.54 2.79 13.37 13.37 13.37 13.37 13.37
Depreciation 179.3 205.3 220.4 217.8 181.5 195.2 197.9 200.5 203.3 206.0
Depreciation, % 9.79 10.57 10.58 10.78 9.69 10.28 10.28 10.28 10.28 10.28
EBIT -37.7 190.6 225.3 75.8 -129.2 58.6 59.4 60.2 61.0 61.8
EBIT, % -2.06 9.82 10.81 3.75 -6.9 3.09 3.09 3.09 3.09 3.09
Total Cash 202.5 93.8 100.4 106.7 83.2 115.6 117.1 118.7 120.3 122.0
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 309.4 311.6 332.0 310.1 224.2
Account Receivables, % 16.89 16.05 15.94 15.35 11.97
Inventories 43.6 42.5 36.6 30.7 26.2 35.1 35.6 36.1 36.6 37.1
Inventories, % 2.38 2.19 1.76 1.52 1.4 1.85 1.85 1.85 1.85 1.85
Accounts Payable 93.7 95.8 77.4 84.3 55.7 79.4 80.5 81.6 82.7 83.8
Accounts Payable, % 5.12 4.93 3.72 4.17 2.97 4.18 4.18 4.18 4.18 4.18
Capital Expenditure -90.4 -133.2 -121.7 -106.7 -101.8 -107.7 -109.1 -110.6 -112.1 -113.6
Capital Expenditure, % -4.94 -6.86 -5.84 -5.28 -5.43 -5.67 -5.67 -5.67 -5.67 -5.67
Tax Rate, % -7.1 -7.1 -7.1 -7.1 -7.1 -7.1 -7.1 -7.1 -7.1 -7.1
EBITAT -44.4 160.6 159.3 39.5 -138.4 47.7 48.3 49.0 49.7 50.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -214.8 233.7 225.2 185.1 3.1 85.0 133.7 135.6 137.4 139.3
WACC, % 7.69 7.46 7.26 6.98 7.69 7.42 7.42 7.42 7.42 7.42
PV UFCF
SUM PV UFCF 505.0
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 145
Terminal Value 4,240
Present Terminal Value 2,965
Enterprise Value 3,470
Net Debt 804
Equity Value 2,666
Diluted Shares Outstanding, MM 55
Equity Value Per Share 48.52

What You Will Receive

  • Pre-Filled Financial Model: John Wiley & Sons, Inc.'s (WLY) actual data facilitates accurate DCF valuation.
  • Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
  • Real-Time Calculations: Automatic updates provide immediate results as you adjust inputs.
  • Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
  • Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.

Key Features

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

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review John Wiley & Sons, Inc.'s pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust assumptions.
  5. Step 5: Analyze the outputs and leverage the results for investment decisions.

Why Choose This Calculator?

  • Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one convenient package.
  • Customizable Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
  • Detailed Insights: Automatically computes John Wiley & Sons, Inc.'s intrinsic value and Net Present Value.
  • Preloaded Data: Historical and forecasted data provide reliable starting points for analysis.
  • Professional Quality: Perfect for financial analysts, investors, and business consultants focused on (WLY).

Who Should Use This Product?

  • Investors: Accurately assess John Wiley & Sons, Inc.’s (WLY) fair value prior to making investment choices.
  • CFOs: Utilize a professional-grade DCF model for financial reporting and analysis of John Wiley & Sons, Inc. (WLY).
  • Consultants: Efficiently customize the template for valuation reports tailored to clients interested in John Wiley & Sons, Inc. (WLY).
  • Entrepreneurs: Acquire insights into financial modeling practices employed by leading publishing companies like John Wiley & Sons, Inc. (WLY).
  • Educators: Implement it as a teaching resource to illustrate valuation methodologies relevant to John Wiley & Sons, Inc. (WLY).

What the Template Contains

  • Historical Data: Contains John Wiley & Sons, Inc. (WLY)’s previous financials and foundational forecasts.
  • DCF and Levered DCF Models: Comprehensive templates for calculating the intrinsic value of John Wiley & Sons, Inc. (WLY).
  • WACC Sheet: Pre-configured calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Adjust essential drivers such as growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: An extensive analysis of John Wiley & Sons, Inc. (WLY)’s financials.
  • Interactive Dashboard: Dynamically visualize valuation outcomes and forecasts.

No products were found matching.