West Pharmaceutical Services, Inc. (WST) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
West Pharmaceutical Services, Inc. (WST) Bundle
Whether you’re an investor or analyst, this (WST) DCF Calculator is your go-to resource for accurate valuation. Preloaded with real data from West Pharmaceutical Services, Inc., you can adjust forecasts and instantly observe the effects.
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,839.9 | 2,146.9 | 2,831.6 | 2,886.9 | 2,949.8 | 3,338.5 | 3,778.4 | 4,276.3 | 4,839.9 | 5,477.6 |
| Revenue Growth, % | 0 | 16.69 | 31.89 | 1.95 | 2.18 | 13.18 | 13.18 | 13.18 | 13.18 | 13.18 |
| EBITDA | 399.4 | 531.7 | 895.2 | 887.9 | 844.1 | 917.8 | 1,038.8 | 1,175.7 | 1,330.6 | 1,505.9 |
| EBITDA, % | 21.71 | 24.77 | 31.61 | 30.76 | 28.62 | 27.49 | 27.49 | 27.49 | 27.49 | 27.49 |
| Depreciation | 103.4 | 109.1 | 122.3 | 120.6 | 137.3 | 159.3 | 180.3 | 204.0 | 230.9 | 261.3 |
| Depreciation, % | 5.62 | 5.08 | 4.32 | 4.18 | 4.65 | 4.77 | 4.77 | 4.77 | 4.77 | 4.77 |
| EBIT | 296.0 | 422.6 | 772.9 | 767.3 | 706.8 | 758.6 | 858.5 | 971.6 | 1,099.7 | 1,244.6 |
| EBIT, % | 16.09 | 19.68 | 27.3 | 26.58 | 23.96 | 22.72 | 22.72 | 22.72 | 22.72 | 22.72 |
| Total Cash | 439.1 | 615.5 | 762.6 | 894.3 | 853.9 | 930.7 | 1,053.4 | 1,192.2 | 1,349.3 | 1,527.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 319.3 | 385.3 | 489.0 | 507.4 | 512.0 | 584.3 | 661.3 | 748.4 | 847.0 | 958.6 |
| Account Receivables, % | 17.35 | 17.95 | 17.27 | 17.58 | 17.36 | 17.5 | 17.5 | 17.5 | 17.5 | 17.5 |
| Inventories | 235.7 | 321.3 | 378.4 | 414.8 | 434.7 | 469.0 | 530.8 | 600.8 | 679.9 | 769.5 |
| Inventories, % | 12.81 | 14.97 | 13.36 | 14.37 | 14.74 | 14.05 | 14.05 | 14.05 | 14.05 | 14.05 |
| Accounts Payable | 156.8 | 213.1 | 232.2 | 215.4 | 242.4 | 282.6 | 319.9 | 362.0 | 409.7 | 463.7 |
| Accounts Payable, % | 8.52 | 9.93 | 8.2 | 7.46 | 8.22 | 8.47 | 8.47 | 8.47 | 8.47 | 8.47 |
| Capital Expenditure | -126.4 | -174.4 | -253.4 | -284.6 | -362.0 | -307.6 | -348.2 | -394.0 | -446.0 | -504.7 |
| Capital Expenditure, % | -6.87 | -8.12 | -8.95 | -9.86 | -12.27 | -9.21 | -9.21 | -9.21 | -9.21 | -9.21 |
| Tax Rate, % | 14.99 | 14.99 | 14.99 | 14.99 | 14.99 | 14.99 | 14.99 | 14.99 | 14.99 | 14.99 |
| EBITAT | 245.2 | 364.6 | 683.0 | 661.2 | 600.9 | 650.3 | 736.0 | 833.0 | 942.8 | 1,067.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -176.0 | 204.0 | 410.2 | 425.6 | 378.7 | 435.6 | 466.6 | 528.0 | 597.6 | 676.4 |
| WACC, % | 9.12 | 9.12 | 9.12 | 9.12 | 9.12 | 9.12 | 9.12 | 9.12 | 9.12 | 9.12 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,056.2 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 703 | |||||||||
| Terminal Value | 13,742 | |||||||||
| Present Terminal Value | 8,883 | |||||||||
| Enterprise Value | 10,939 | |||||||||
| Net Debt | -545 | |||||||||
| Equity Value | 11,484 | |||||||||
| Diluted Shares Outstanding, MM | 75 | |||||||||
| Equity Value Per Share | 152.51 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: West Pharmaceutical Services, Inc.'s (WST) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for West Pharmaceutical Services, Inc. (WST).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: View intuitive charts and summaries that present your valuation findings clearly.
- Designed for All Skill Levels: A straightforward, accessible layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for West Pharmaceutical Services, Inc. (WST).
- Step 2: Review the pre-filled financial data and forecasts for West Pharmaceutical 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 informed investment decisions.
Why Choose This Calculator for West Pharmaceutical Services, Inc. (WST)?
- Accurate Data: Utilizes verified financials from West Pharmaceutical Services for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Ready-made calculations remove the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the pharmaceutical sector.
- User-Friendly: Simple design and step-by-step guidance ensure accessibility for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling West Pharmaceutical Services, Inc. (WST) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for West Pharmaceutical Services, Inc. (WST).
- Consultants: Deliver professional valuation insights regarding West Pharmaceutical Services, Inc. (WST) to clients quickly and accurately.
- Business Owners: Understand how companies like West Pharmaceutical Services, Inc. (WST) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to West Pharmaceutical Services, Inc. (WST).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled West Pharmaceutical Services, Inc. (WST) 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 West Pharmaceutical Services, Inc. (WST).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.