Webster Financial Corporation (WBS) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Webster Financial Corporation (WBS) Bundle
Designed for accuracy, our WBS (Webster Financial Corporation) DCF Calculator enables you to evaluate the valuation of WBS using real-world financial data and provides complete flexibility to modify all essential parameters for improved 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 | 1,237.5 | 1,174.9 | 1,223.3 | 2,472.5 | 2,500.2 | 3,126.3 | 3,909.3 | 4,888.4 | 6,112.7 | 7,643.7 |
| Revenue Growth, % | 0 | -5.06 | 4.12 | 102.12 | 1.12 | 25.05 | 25.05 | 25.05 | 25.05 | 25.05 |
| EBITDA | 531.5 | 323.2 | 575.4 | 880.6 | .0 | 957.3 | 1,197.1 | 1,496.9 | 1,871.8 | 2,340.6 |
| EBITDA, % | 42.95 | 27.5 | 47.03 | 35.62 | 0 | 30.62 | 30.62 | 30.62 | 30.62 | 30.62 |
| Depreciation | 37.5 | 36.7 | 35.9 | 73.6 | .0 | 75.5 | 94.4 | 118.0 | 147.5 | 184.5 |
| Depreciation, % | 3.03 | 3.12 | 2.94 | 2.98 | 0 | 2.41 | 2.41 | 2.41 | 2.41 | 2.41 |
| EBIT | 494.0 | 286.5 | 539.5 | 807.0 | .0 | 881.9 | 1,102.7 | 1,378.9 | 1,724.3 | 2,156.1 |
| EBIT, % | 39.92 | 24.38 | 44.1 | 32.64 | 0 | 28.21 | 28.21 | 28.21 | 28.21 | 28.21 |
| Total Cash | 3,183.7 | 3,589.9 | 4,696.4 | 8,732.6 | 1,483.1 | 2,872.0 | 3,591.3 | 4,490.7 | 5,615.4 | 7,021.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | 1,618.2 | .0 | 409.2 | 511.7 | 639.9 | 800.1 | 1,000.5 |
| Account Receivables, % | 0 | 0 | 0 | 65.45 | 0 | 13.09 | 13.09 | 13.09 | 13.09 | 13.09 |
| Inventories | -257.9 | -265.8 | -462.1 | .0 | .0 | -507.9 | -635.1 | -794.2 | -993.1 | -1,241.8 |
| Inventories, % | -20.84 | -22.62 | -37.77 | 0 | 0 | -16.25 | -16.25 | -16.25 | -16.25 | -16.25 |
| 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 | -25.7 | -21.3 | -16.6 | -28.8 | -40.3 | -50.2 | -62.7 | -78.4 | -98.1 | -122.6 |
| Capital Expenditure, % | -2.08 | -1.81 | -1.36 | -1.16 | -1.61 | -1.6 | -1.6 | -1.6 | -1.6 | -1.6 |
| Tax Rate, % | 19.98 | 19.98 | 19.98 | 19.98 | 19.98 | 19.98 | 19.98 | 19.98 | 19.98 | 19.98 |
| EBITAT | 388.4 | 225.8 | 413.1 | 651.6 | .0 | 696.3 | 870.7 | 1,088.8 | 1,361.4 | 1,702.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 658.2 | 249.0 | 628.8 | -1,383.8 | 1,577.9 | 820.3 | 927.1 | 1,159.2 | 1,449.6 | 1,812.6 |
| WACC, % | 15.52 | 15.54 | 15.32 | 15.73 | 15.66 | 15.55 | 15.55 | 15.55 | 15.55 | 15.55 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,848.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,849 | |||||||||
| Terminal Value | 13,641 | |||||||||
| Present Terminal Value | 6,621 | |||||||||
| Enterprise Value | 10,470 | |||||||||
| Net Debt | 1,693 | |||||||||
| Equity Value | 8,777 | |||||||||
| Diluted Shares Outstanding, MM | 172 | |||||||||
| Equity Value Per Share | 51.06 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real WBS financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Quickly observe the effects of your inputs on Webster Financial Corporation's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Real-Life WBS Data: Pre-filled with Webster Financial Corporation's historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures to suit your analysis.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Testing: Create multiple forecast scenarios to explore various valuation outcomes.
- User-Friendly Design: Intuitive, structured interface tailored for both professionals and beginners.
How It Works
- Download the Template: Gain immediate access to the Excel-based WBS DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically refreshes Webster Financial’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation changes.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Webster Financial Corporation (WBS)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Insights: Observe immediate updates to Webster Financial's valuation as you tweak inputs.
- Pre-Loaded Data: Comes equipped with Webster Financial's actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Evaluate Webster Financial Corporation’s (WBS) performance before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methods and validate financial forecasts for (WBS).
- Startup Founders: Understand the valuation strategies of established financial institutions like Webster Financial Corporation (WBS).
- Consultants: Provide expert valuation analyses and reports for clients focusing on (WBS).
- Students and Educators: Utilize real-time data from Webster Financial Corporation (WBS) to teach and learn valuation practices.
What the Template Contains
- Historical Data: Includes Webster Financial Corporation’s (WBS) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Webster Financial Corporation’s (WBS) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Webster Financial Corporation’s (WBS) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.