Perrigo Company plc (PRGO) DCF Valuation

Perrigo Company plc (PRGO) 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

Perrigo Company plc (PRGO) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Simplify Perrigo Company plc (PRGO) valuation with this customizable DCF Calculator! Featuring real Perrigo Company plc (PRGO) financials and adjustable forecast inputs, you can test scenarios and uncover Perrigo Company plc (PRGO) fair value in minutes.


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
Account Receivables, % 25.7 12.11 15.78 15.66 15.89
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.

No products were found matching.