Phibro Animal Health Corporation (PAHC) 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
Phibro Animal Health Corporation (PAHC) Bundle
Whether you’re an investor or analyst, this (PAHC) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Phibro Animal Health Corporation, you can adjust forecasts and instantly observe the effects.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 800.4 | 833.4 | 942.3 | 977.9 | 1,017.7 | 1,081.4 | 1,149.1 | 1,221.0 | 1,297.4 | 1,378.6 |
Revenue Growth, % | 0 | 4.12 | 13.07 | 3.78 | 4.07 | 6.26 | 6.26 | 6.26 | 6.26 | 6.26 |
EBITDA | 102.2 | 105.5 | 114.8 | 116.6 | 69.1 | 121.8 | 129.4 | 137.5 | 146.1 | 155.3 |
EBITDA, % | 12.76 | 12.66 | 12.18 | 11.93 | 6.79 | 11.26 | 11.26 | 11.26 | 11.26 | 11.26 |
Depreciation | 32.3 | 31.9 | 32.7 | 34.0 | 36.2 | 39.7 | 42.2 | 44.9 | 47.7 | 50.7 |
Depreciation, % | 4.04 | 3.83 | 3.47 | 3.48 | 3.55 | 3.67 | 3.67 | 3.67 | 3.67 | 3.67 |
EBIT | 69.8 | 73.6 | 82.1 | 82.6 | 32.9 | 82.1 | 87.2 | 92.7 | 98.5 | 104.6 |
EBIT, % | 8.72 | 8.83 | 8.71 | 8.45 | 3.23 | 7.59 | 7.59 | 7.59 | 7.59 | 7.59 |
Total Cash | 91.3 | 93.2 | 91.2 | 81.3 | 114.6 | 112.1 | 119.2 | 126.6 | 134.6 | 143.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 126.5 | 146.9 | 166.5 | 163.5 | 169.5 | 182.7 | 194.1 | 206.3 | 219.2 | 232.9 |
Account Receivables, % | 15.81 | 17.62 | 17.67 | 16.72 | 16.65 | 16.89 | 16.89 | 16.89 | 16.89 | 16.89 |
Inventories | 196.7 | 216.3 | 259.2 | 277.6 | 265.9 | 286.7 | 304.6 | 323.7 | 343.9 | 365.4 |
Inventories, % | 24.57 | 25.96 | 27.5 | 28.38 | 26.13 | 26.51 | 26.51 | 26.51 | 26.51 | 26.51 |
Accounts Payable | 62.3 | 68.4 | 95.6 | 73.9 | 85.6 | 91.0 | 96.7 | 102.8 | 109.2 | 116.0 |
Accounts Payable, % | 7.78 | 8.2 | 10.14 | 7.55 | 8.41 | 8.42 | 8.42 | 8.42 | 8.42 | 8.42 |
Capital Expenditure | -34.0 | -29.3 | -37.0 | -51.8 | -41.2 | -45.5 | -48.4 | -51.4 | -54.6 | -58.0 |
Capital Expenditure, % | -4.25 | -3.52 | -3.93 | -5.3 | -4.05 | -4.21 | -4.21 | -4.21 | -4.21 | -4.21 |
Tax Rate, % | 77.87 | 77.87 | 77.87 | 77.87 | 77.87 | 77.87 | 77.87 | 77.87 | 77.87 | 77.87 |
EBITAT | 42.2 | 60.2 | 55.8 | 49.8 | 7.3 | 48.0 | 51.1 | 54.2 | 57.6 | 61.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -220.4 | 28.9 | 16.2 | -5.1 | 19.6 | 13.7 | 21.2 | 22.5 | 23.9 | 25.4 |
WACC, % | 5.27 | 5.63 | 5.4 | 5.27 | 4.62 | 5.24 | 5.24 | 5.24 | 5.24 | 5.24 |
PV UFCF | ||||||||||
SUM PV UFCF | 90.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 26 | |||||||||
Terminal Value | 802 | |||||||||
Present Terminal Value | 621 | |||||||||
Enterprise Value | 712 | |||||||||
Net Debt | 455 | |||||||||
Equity Value | 257 | |||||||||
Diluted Shares Outstanding, MM | 41 | |||||||||
Equity Value Per Share | 6.35 |
What You Will Get
- Real PAHC Financials: Access to historical and projected data for precise valuation.
- Adjustable Inputs: Customize WACC, tax rates, revenue growth, and capital expenditures.
- Automatic Calculations: Dynamic computation of intrinsic value and NPV.
- Scenario Analysis: Evaluate various scenarios to assess Phibro’s future performance.
- Clear and Intuitive Design: Designed for professionals but easy to use for beginners.
Key Features
- Accurate Financial Data: Gain access to reliable pre-loaded historical figures and future forecasts for Phibro Animal Health Corporation (PAHC).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Skill Levels: A straightforward, user-friendly layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Phibro Animal Health Corporation (PAHC).
- Step 2: Review the pre-filled financial data and forecasts specific to Phibro Animal Health.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model refresh in real-time as you modify your assumptions.
- Step 5: Evaluate the results and utilize the findings for your investment strategies.
Why Choose This Calculator for Phibro Animal Health Corporation (PAHC)?
- Designed for Industry Experts: A sophisticated tool tailored for veterinarians, animal nutritionists, and financial analysts.
- Comprehensive Data: PAHC’s historical and projected financials included for precise calculations.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Intuitive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Investors: Accurately assess Phibro Animal Health Corporation’s (PAHC) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for financial reporting and analysis related to Phibro Animal Health Corporation.
- Consultants: Efficiently customize the template for valuation reports tailored to clients involving Phibro Animal Health Corporation.
- Entrepreneurs: Acquire knowledge about financial modeling practices employed by leading companies in the animal health sector.
- Educators: Implement it as a teaching resource to illustrate various valuation methodologies relevant to Phibro Animal Health Corporation.
What the Template Contains
- Pre-Filled DCF Model: Phibro Animal Health Corporation’s (PAHC) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Phibro’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.