Stewart Information Services Corporation (STC) 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
Stewart Information Services Corporation (STC) Bundle
Looking to determine the intrinsic value of Stewart Information Services Corporation? Our STC DCF Calculator integrates real-world data with comprehensive customization features, allowing you to adjust forecasts and enhance your investment choices.
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,940.0 | 2,288.4 | 3,305.8 | 3,069.3 | 2,257.3 | 2,419.9 | 2,594.2 | 2,781.0 | 2,981.3 | 3,196.1 |
| Revenue Growth, % | 0 | 17.96 | 44.46 | -7.15 | -26.45 | 7.2 | 7.2 | 7.2 | 7.2 | 7.2 |
| EBITDA | 143.8 | 240.3 | 475.4 | 308.2 | 143.0 | 235.6 | 252.6 | 270.7 | 290.2 | 311.1 |
| EBITDA, % | 7.41 | 10.5 | 14.38 | 10.04 | 6.34 | 9.74 | 9.74 | 9.74 | 9.74 | 9.74 |
| Depreciation | 22.5 | 19.2 | 36.4 | 57.2 | 62.4 | 37.4 | 40.1 | 43.0 | 46.1 | 49.4 |
| Depreciation, % | 1.16 | 0.8397 | 1.1 | 1.86 | 2.77 | 1.55 | 1.55 | 1.55 | 1.55 | 1.55 |
| EBIT | 121.3 | 221.1 | 439.0 | 251.1 | 80.6 | 198.2 | 212.4 | 227.7 | 244.1 | 261.7 |
| EBIT, % | 6.25 | 9.66 | 13.28 | 8.18 | 3.57 | 8.19 | 8.19 | 8.19 | 8.19 | 8.19 |
| Total Cash | 354.1 | 453.4 | 503.6 | 272.7 | 223.4 | 348.8 | 374.0 | 400.9 | 429.8 | 460.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 72.0 | .0 | .0 | .0 | .0 | 18.0 | 19.3 | 20.6 | 22.1 | 23.7 |
| Account Receivables, % | 3.71 | 0 | 0 | 0 | 0 | 0.7423 | 0.7423 | 0.7423 | 0.7423 | 0.7423 |
| Inventories | -494.7 | -621.6 | -694.8 | .0 | .0 | -356.6 | -382.3 | -409.8 | -439.3 | -470.9 |
| Inventories, % | -25.5 | -27.16 | -21.02 | 0 | 0 | -14.74 | -14.74 | -14.74 | -14.74 | -14.74 |
| Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capital Expenditure | -17.1 | -15.0 | -39.8 | -47.9 | -37.8 | -28.9 | -31.0 | -33.2 | -35.6 | -38.2 |
| Capital Expenditure, % | -0.88015 | -0.65512 | -1.2 | -1.56 | -1.67 | -1.2 | -1.2 | -1.2 | -1.2 | -1.2 |
| Tax Rate, % | 49.99 | 49.99 | 49.99 | 49.99 | 49.99 | 49.99 | 49.99 | 49.99 | 49.99 | 49.99 |
| EBITAT | 81.5 | 156.8 | 327.0 | 175.1 | 40.3 | 131.7 | 141.2 | 151.4 | 162.3 | 174.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 509.6 | 359.9 | 396.7 | -510.4 | 65.0 | 478.8 | 174.7 | 187.3 | 200.8 | 215.2 |
| WACC, % | 8.55 | 8.59 | 8.63 | 8.58 | 8.37 | 8.54 | 8.54 | 8.54 | 8.54 | 8.54 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,023.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 220 | |||||||||
| Terminal Value | 3,355 | |||||||||
| Present Terminal Value | 2,227 | |||||||||
| Enterprise Value | 3,250 | |||||||||
| Net Debt | 348 | |||||||||
| Equity Value | 2,903 | |||||||||
| Diluted Shares Outstanding, MM | 28 | |||||||||
| Equity Value Per Share | 105.48 |
What You Will Receive
- Pre-Filled Financial Model: Stewart Information Services Corporation’s (STC) actual data provides an accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, margins, WACC, and other essential metrics.
- Real-Time Calculations: Automatic updates allow you to view results instantly as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Comprehensive Data: Stewart Information Services Corporation’s historical financial statements and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Analysis: Observe Stewart Information Services Corporation’s intrinsic value recalculated instantly.
- Intuitive Visual Outputs: Dashboard graphs showcase valuation results and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file for Stewart Information Services Corporation (STC).
- Step 2: Review the pre-filled financial data and forecasts for Stewart Information Services.
- 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 decisions.
Why Choose This Calculator for Stewart Information Services Corporation (STC)?
- All-in-One Solution: Offers DCF, WACC, and financial ratio analyses tailored for (STC).
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios for (STC).
- In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value specific to (STC).
- Preloaded Information: Historical and projected data provide a solid foundation for analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and consultants focusing on (STC).
Who Should Use Stewart Information Services Corporation (STC)?
- Real Estate Investors: Utilize comprehensive data solutions to enhance property investment decisions.
- Title Agents: Streamline operations with efficient title and escrow services tailored for your needs.
- Mortgage Professionals: Access reliable tools for managing transactions and ensuring compliance.
- Property Developers: Leverage innovative title solutions to facilitate smoother project financing.
- Legal Professionals: Enhance your practice with expert title insurance and risk management resources.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Stewart Information Services Corporation (STC) 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 Stewart Information Services Corporation (STC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.