Scholastic Corporation (SCHL) 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
Scholastic Corporation (SCHL) Bundle
Evaluate Scholastic Corporation's (SCHL) financial outlook like an expert! This (SCHL) DCF Calculator provides pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other critical 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,487.1 | 1,300.3 | 1,642.9 | 1,704.0 | 1,589.7 | 1,632.6 | 1,676.7 | 1,721.9 | 1,768.4 | 1,816.2 |
Revenue Growth, % | 0 | -12.56 | 26.35 | 3.72 | -6.71 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 |
EBITDA | -22.7 | 52.9 | 175.8 | 203.5 | 85.1 | 99.7 | 102.4 | 105.2 | 108.0 | 110.9 |
EBITDA, % | -1.53 | 4.07 | 10.7 | 11.94 | 5.35 | 6.11 | 6.11 | 6.11 | 6.11 | 6.11 |
Depreciation | 90.2 | 85.9 | 83.2 | 89.7 | 67.0 | 88.9 | 91.3 | 93.7 | 96.3 | 98.9 |
Depreciation, % | 6.07 | 6.61 | 5.06 | 5.26 | 4.21 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 |
EBIT | -112.9 | -33.0 | 92.6 | 113.8 | 18.1 | 10.9 | 11.1 | 11.4 | 11.8 | 12.1 |
EBIT, % | -7.59 | -2.54 | 5.64 | 6.68 | 1.14 | 0.6647 | 0.6647 | 0.6647 | 0.6647 | 0.6647 |
Total Cash | 393.8 | 366.5 | 316.6 | 224.5 | 113.7 | 307.8 | 316.1 | 324.6 | 333.4 | 342.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 329.8 | 344.9 | 326.2 | 286.9 | 250.2 | 330.2 | 339.1 | 348.3 | 357.7 | 367.3 |
Account Receivables, % | 22.18 | 26.52 | 19.86 | 16.84 | 15.74 | 20.23 | 20.23 | 20.23 | 20.23 | 20.23 |
Inventories | 270.6 | 269.7 | 281.4 | 334.5 | 264.2 | 301.4 | 309.6 | 317.9 | 326.5 | 335.3 |
Inventories, % | 18.2 | 20.74 | 17.13 | 19.63 | 16.62 | 18.46 | 18.46 | 18.46 | 18.46 | 18.46 |
Accounts Payable | 153.6 | 138.0 | 162.3 | 170.9 | 138.5 | 161.8 | 166.2 | 170.7 | 175.3 | 180.0 |
Accounts Payable, % | 10.33 | 10.61 | 9.88 | 10.03 | 8.71 | 9.91 | 9.91 | 9.91 | 9.91 | 9.91 |
Capital Expenditure | -66.0 | -47.2 | -42.0 | -62.0 | -58.4 | -58.6 | -60.1 | -61.8 | -63.4 | -65.2 |
Capital Expenditure, % | -4.44 | -3.63 | -2.56 | -3.64 | -3.67 | -3.59 | -3.59 | -3.59 | -3.59 | -3.59 |
Tax Rate, % | 25.31 | 25.31 | 25.31 | 25.31 | 25.31 | 25.31 | 25.31 | 25.31 | 25.31 | 25.31 |
EBITAT | -55.0 | -19.8 | 83.6 | 87.6 | 13.5 | 7.6 | 7.8 | 8.0 | 8.2 | 8.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -477.6 | -10.9 | 156.1 | 110.1 | 96.7 | -56.0 | 26.2 | 27.0 | 27.7 | 28.4 |
WACC, % | 8.28 | 8.36 | 8.57 | 8.48 | 8.46 | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 |
PV UFCF | ||||||||||
SUM PV UFCF | 30.8 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 29 | |||||||||
Terminal Value | 539 | |||||||||
Present Terminal Value | 360 | |||||||||
Enterprise Value | 391 | |||||||||
Net Debt | 10 | |||||||||
Equity Value | 381 | |||||||||
Diluted Shares Outstanding, MM | 30 | |||||||||
Equity Value Per Share | 12.52 |
What You Will Get
- Authentic Scholastic Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Scholastic Corporation (SCHL).
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis.
- Immediate Valuation Adjustments: Automatic recalculations to assess the effects of changes on Scholastic’s fair value.
- Flexible Excel Template: Designed for quick modifications, scenario testing, and in-depth projections.
- Efficient and Precise: Avoid the hassle of building models from the ground up while ensuring accuracy and adaptability.
Key Features
- Comprehensive Financial Data: Scholastic Corporation’s historical financial reports and pre-populated projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Instantly view Scholastic’s intrinsic value recalculating on the fly.
- Intuitive Visualizations: Dashboard graphs showcase valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Scholastic Corporation (SCHL) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Scholastic Corporation’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Scholastic Corporation (SCHL)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned users.
- Customizable Inputs: Easily adjust parameters to suit your analysis needs.
- Real-Time Feedback: Observe immediate changes to Scholastic’s valuation as you modify inputs.
- Preloaded Data: Comes equipped with Scholastic's actual financial metrics for swift evaluations.
- Endorsed by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Evaluate Scholastic Corporation’s (SCHL) valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for Scholastic Corporation.
- Startup Founders: Discover how established companies like Scholastic Corporation are valued in the market.
- Consultants: Create detailed valuation reports for clients focusing on Scholastic Corporation.
- Students and Educators: Utilize real-world examples from Scholastic Corporation to learn and teach valuation strategies.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
- Real-World Data: Scholastic Corporation’s (SCHL) historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results.