John Wiley & Sons, Inc. (WLYB) 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
John Wiley & Sons, Inc. (WLYB) Bundle
Evaluate John Wiley & Sons, Inc.'s (WLYB) financial future like an expert! This (WLYB) DCF Calculator comes with pre-filled financial data and offers complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 289.3 | 293.2 | 297.2 | 301.3 | 305.4 |
| Account Receivables, % | 16.89 | 16.05 | 15.94 | 15.35 | 11.97 | 15.24 | 15.24 | 15.24 | 15.24 | 15.24 |
| 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 Get
- Genuine Wiley Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Complete Customization: Modify all key parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Updates: Automatic recalculations to assess the impact of changes on Wiley’s fair value.
- Flexible Excel Template: Designed for quick edits, scenario testing, and comprehensive projections.
- Efficient and Precise: Avoid starting from scratch while ensuring accuracy and adaptability.
Key Features
- Comprehensive Data: John Wiley & Sons, Inc.'s historical financial statements and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Insights: Observe John Wiley & Sons, Inc.'s intrinsic value update instantly.
- Visual Performance Metrics: Interactive dashboard charts showcase valuation outcomes and essential metrics.
- Designed for Precision: A sophisticated tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file for John Wiley & Sons, Inc. (WLYB).
- Step 2: Review the pre-filled financial data and forecasts for John Wiley & Sons, Inc. (WLYB).
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells) for John Wiley & Sons, Inc. (WLYB).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions for John Wiley & Sons, Inc. (WLYB).
- Step 5: Evaluate the outputs and leverage the results for your investment decisions regarding John Wiley & Sons, Inc. (WLYB).
Why Choose John Wiley & Sons, Inc. (WLYB)?
- Extensive Resources: Access a vast library of educational materials and publications.
- Industry Expertise: Benefit from years of experience in academic and professional publishing.
- Innovative Solutions: Explore cutting-edge tools and technologies to enhance learning.
- Global Reach: Connect with a diverse audience across various fields and disciplines.
- Commitment to Quality: Rely on high standards and rigorous peer review processes for all content.
Who Should Use This Product?
- Students: Explore publishing processes and gain insights into the academic world.
- Researchers: Utilize Wiley's resources to enhance your studies and publications.
- Authors: Discover opportunities to publish and promote your work through a reputable platform.
- Educators: Access a wealth of materials to enrich your teaching and curriculum development.
- Corporate Trainers: Leverage Wiley's expertise to develop training programs and workshops.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled John Wiley & Sons, Inc. (WLYB) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for John Wiley & Sons, Inc. (WLYB).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.