|
Perrigo Company PLC (PRGO) DCF Valoración
IE | Healthcare | Drug Manufacturers - Specialty & Generic | NYSE
|
- ✓ 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
Perrigo Company plc (PRGO) Bundle
¡Simplifique la valoración de Perrigo Company PLC (PRGO) con esta calculadora DCF personalizable! Con la Real Perrigo Company PLC (PRGO) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Perrigo Company PLC (PRGO) en minutos.
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 | 4,837.4 | 5,063.3 | 4,138.7 | 4,451.6 | 4,655.6 | 4,638.7 | 4,622.0 | 4,605.2 | 4,588.6 | 4,571.9 |
| Revenue Growth, % | 0 | 4.67 | -18.26 | 7.56 | 4.58 | -0.362 | -0.362 | -0.362 | -0.362 | -0.362 |
| EBITDA | 612.9 | 661.9 | 915.6 | 507.2 | 575.9 | 664.5 | 662.1 | 659.7 | 657.3 | 655.0 |
| EBITDA, % | 12.67 | 13.07 | 22.12 | 11.39 | 12.37 | 14.33 | 14.33 | 14.33 | 14.33 | 14.33 |
| Depreciation | 396.5 | 384.8 | 312.2 | 338.6 | 359.5 | 358.7 | 357.4 | 356.1 | 354.9 | 353.6 |
| Depreciation, % | 8.2 | 7.6 | 7.54 | 7.61 | 7.72 | 7.73 | 7.73 | 7.73 | 7.73 | 7.73 |
| EBIT | 216.4 | 277.1 | 603.4 | 168.6 | 216.4 | 305.8 | 304.7 | 303.6 | 302.5 | 301.4 |
| EBIT, % | 4.47 | 5.47 | 14.58 | 3.79 | 4.65 | 6.59 | 6.59 | 6.59 | 6.59 | 6.59 |
| Total Cash | 354.3 | 641.5 | 1,864.9 | 600.7 | 751.3 | 878.4 | 875.3 | 872.1 | 868.9 | 865.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,243.2 | 613.2 | 652.9 | 697.1 | 739.6 | 789.8 | 786.9 | 784.1 | 781.3 | 778.4 |
| Account Receivables, % | 25.7 | 12.11 | 15.78 | 15.66 | 15.89 | 17.03 | 17.03 | 17.03 | 17.03 | 17.03 |
| Inventories | 967.3 | 1,200.2 | 1,020.2 | 1,150.3 | 1,140.9 | 1,101.2 | 1,097.2 | 1,093.2 | 1,089.3 | 1,085.3 |
| Inventories, % | 20 | 23.7 | 24.65 | 25.84 | 24.51 | 23.74 | 23.74 | 23.74 | 23.74 | 23.74 |
| Accounts Payable | 520.2 | 451.6 | 411.2 | 537.3 | 477.7 | 481.9 | 480.1 | 478.4 | 476.6 | 474.9 |
| Accounts Payable, % | 10.75 | 8.92 | 9.94 | 12.07 | 10.26 | 10.39 | 10.39 | 10.39 | 10.39 | 10.39 |
| Capital Expenditure | -137.7 | -170.4 | -152.1 | -96.4 | -101.7 | -132.1 | -131.6 | -131.1 | -130.7 | -130.2 |
| Capital Expenditure, % | -2.85 | -3.37 | -3.68 | -2.17 | -2.18 | -2.85 | -2.85 | -2.85 | -2.85 | -2.85 |
| Tax Rate, % | -53.01 | -53.01 | -53.01 | -53.01 | -53.01 | -53.01 | -53.01 | -53.01 | -53.01 | -53.01 |
| EBITAT | 184.9 | 301.6 | -305.3 | 158.7 | 331.1 | 232.1 | 231.3 | 230.4 | 229.6 | 228.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,246.6 | 844.5 | -45.3 | 352.7 | 496.2 | 452.4 | 462.2 | 460.6 | 458.9 | 457.2 |
| WACC, % | 5.15 | 5.5 | 3.09 | 5.36 | 5.5 | 4.92 | 4.92 | 4.92 | 4.92 | 4.92 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,988.1 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 476 | |||||||||
| Terminal Value | 51,679 | |||||||||
| Present Terminal Value | 40,647 | |||||||||
| Enterprise Value | 42,635 | |||||||||
| Net Debt | 3,322 | |||||||||
| Equity Value | 39,313 | |||||||||
| Diluted Shares Outstanding, MM | 135 | |||||||||
| Equity Value Per Share | 290.56 |
What You Will Receive
- Adjustable Forecast Variables: Effortlessly modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Financial Data: Perrigo Company plc’s (PRGO) financial information pre-loaded to facilitate your analysis.
- Instant DCF Calculations: The template automatically computes Net Present Value (NPV) and intrinsic value for your convenience.
- Tailored and Professional Design: A sleek Excel model that can be customized to fit your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Perrigo's historical financial statements and pre-filled forecasts.
- Customizable Assumptions: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Monitor Perrigo’s intrinsic value recalculating instantly.
- Visual Data Presentation: Dashboard charts illustrate valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool for analysts, investors, and finance professionals.
How It Works
- 1. Open the Template: Download and open the Excel file containing Perrigo Company plc’s (PRGO) preloaded data.
- 2. Edit Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
- 4. Test Scenarios: Evaluate multiple forecasts to explore various valuation outcomes.
- 5. Use with Confidence: Present professional valuation insights to bolster your decision-making.
Why Choose This Calculator for Perrigo Company plc (PRGO)?
- Accuracy: Up-to-date Perrigo financial data guarantees reliable results.
- Flexibility: Users can easily adjust and experiment with various inputs.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Intuitive interface suitable for users of all financial backgrounds.
Who Should Use This Product?
- Finance Students: Master valuation methods and apply them to real-world data with Perrigo Company plc (PRGO).
- Academics: Integrate industry-standard models into your research or teaching focused on Perrigo Company plc (PRGO).
- Investors: Validate your investment hypotheses and evaluate valuation results for Perrigo Company plc (PRGO).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for Perrigo Company plc (PRGO).
- Small Business Owners: Discover how major public companies like Perrigo Company plc (PRGO) are appraised and analyzed.
What the Template Contains
- Pre-Filled Data: Includes Perrigo Company plc’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Perrigo’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.