Graham Holdings Company (GHC) 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
Graham Holdings Company (GHC) Bundle
Evaluate the financial outlook of Graham Holdings Company (GHC) like an expert! This (GHC) DCF Calculator provides you with pre-loaded financial data and the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with 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 | 2,932.1 | 2,889.1 | 3,186.0 | 3,924.5 | 4,414.9 | 4,905.9 | 5,451.5 | 6,057.7 | 6,731.4 | 7,480.0 |
| Revenue Growth, % | 0 | -1.47 | 10.27 | 23.18 | 12.5 | 11.12 | 11.12 | 11.12 | 11.12 | 11.12 |
| EBITDA | 652.8 | 667.0 | 687.2 | 375.5 | 571.5 | 877.5 | 975.1 | 1,083.5 | 1,204.0 | 1,337.9 |
| EBITDA, % | 22.26 | 23.09 | 21.57 | 9.57 | 12.94 | 17.89 | 17.89 | 17.89 | 17.89 | 17.89 |
| Depreciation | 196.7 | 221.0 | 203.0 | 199.7 | 203.8 | 298.6 | 331.8 | 368.7 | 409.8 | 455.3 |
| Depreciation, % | 6.71 | 7.65 | 6.37 | 5.09 | 4.62 | 6.09 | 6.09 | 6.09 | 6.09 | 6.09 |
| EBIT | 456.1 | 446.1 | 484.2 | 175.7 | 367.7 | 578.9 | 643.3 | 714.8 | 794.3 | 882.6 |
| EBIT, % | 15.56 | 15.44 | 15.2 | 4.48 | 8.33 | 11.8 | 11.8 | 11.8 | 11.8 | 11.8 |
| Total Cash | 800.1 | 1,001.6 | 970.3 | 791.7 | 866.9 | 1,297.3 | 1,441.6 | 1,601.9 | 1,780.1 | 1,978.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 635.0 | 566.5 | 640.2 | 541.3 | 531.9 | 855.6 | 950.7 | 1,056.4 | 1,173.9 | 1,304.5 |
| Account Receivables, % | 21.66 | 19.61 | 20.09 | 13.79 | 12.05 | 17.44 | 17.44 | 17.44 | 17.44 | 17.44 |
| Inventories | 108.9 | 120.6 | 141.5 | 226.8 | 297.2 | 243.7 | 270.8 | 301.0 | 334.4 | 371.6 |
| Inventories, % | 3.72 | 4.18 | 4.44 | 5.78 | 6.73 | 4.97 | 4.97 | 4.97 | 4.97 | 4.97 |
| Accounts Payable | 367.0 | 106.2 | 121.0 | 62.2 | 154.0 | 245.9 | 273.2 | 303.6 | 337.4 | 374.9 |
| Accounts Payable, % | 12.52 | 3.68 | 3.8 | 1.58 | 3.49 | 5.01 | 5.01 | 5.01 | 5.01 | 5.01 |
| Capital Expenditure | -93.5 | -69.6 | -162.5 | -82.7 | -93.4 | -146.4 | -162.7 | -180.8 | -200.9 | -223.2 |
| Capital Expenditure, % | -3.19 | -2.41 | -5.1 | -2.11 | -2.12 | -2.98 | -2.98 | -2.98 | -2.98 | -2.98 |
| Tax Rate, % | 31.34 | 31.34 | 31.34 | 31.34 | 31.34 | 31.34 | 31.34 | 31.34 | 31.34 | 31.34 |
| EBITAT | 350.6 | 329.0 | 379.1 | 96.8 | 252.4 | 408.3 | 453.7 | 504.2 | 560.3 | 622.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 76.9 | 276.4 | 339.8 | 168.7 | 393.6 | 382.3 | 528.0 | 586.7 | 651.9 | 724.4 |
| WACC, % | 8.34 | 8.31 | 8.36 | 8.08 | 8.25 | 8.27 | 8.27 | 8.27 | 8.27 | 8.27 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,227.2 | |||||||||
| Long Term Growth Rate, % | 1.00 | |||||||||
| Free cash flow (T + 1) | 732 | |||||||||
| Terminal Value | 10,068 | |||||||||
| Present Terminal Value | 6,768 | |||||||||
| Enterprise Value | 8,995 | |||||||||
| Net Debt | 1,083 | |||||||||
| Equity Value | 7,912 | |||||||||
| Diluted Shares Outstanding, MM | 5 | |||||||||
| Equity Value Per Share | 1,700.03 |
What You Will Receive
- Pre-Filled Financial Model: Graham Holdings Company’s actual data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate insights as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for versatility, allowing repeated application for in-depth forecasts.
Key Features
- Comprehensive Financial Data: Gain access to precise historical figures and future forecasts for Graham Holdings Company (GHC).
- Adjustable Projection Parameters: Modify highlighted cells for key inputs like WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to help visualize your valuation outcomes.
- Suitable for All Skill Levels: A straightforward design tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Graham Holdings Company (GHC).
- Step 2: Review the pre-filled financial data and forecasts for Graham Holdings.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Graham Holdings Company (GHC)?
- Accurate Data: Utilize authentic Graham Holdings financials for trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the field.
- User-Friendly: Easy-to-navigate design and clear, step-by-step guidance for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Graham Holdings Company (GHC) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Graham Holdings Company (GHC).
- Consultants: Deliver professional valuation insights on Graham Holdings Company (GHC) to clients quickly and accurately.
- Business Owners: Understand how companies like Graham Holdings Company (GHC) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios from Graham Holdings Company (GHC).
What the Template Contains
- Preloaded GHC Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.