Bausch Health Companies Inc. (BHC) 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
Bausch Health Companies Inc. (BHC) Bundle
Designed for accuracy, our (BHC) DCF Calculator enables you to evaluate the valuation of Bausch Health Companies Inc. using real-world financial data, while offering 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 | 5,969.3 | 5,570.9 | 5,853.4 | 5,638.2 | 6,077.5 | 6,115.7 | 6,154.1 | 6,192.8 | 6,231.7 | 6,270.9 |
| Revenue Growth, % | 0 | -6.67 | 5.07 | -3.68 | 7.79 | 0.62822 | 0.62822 | 0.62822 | 0.62822 | 0.62822 |
| EBITDA | 1,313.8 | 1,771.9 | 1,344.2 | 1,818.9 | 1,556.3 | 1,646.9 | 1,657.3 | 1,667.7 | 1,678.2 | 1,688.7 |
| EBITDA, % | 22.01 | 31.81 | 22.96 | 32.26 | 25.61 | 26.93 | 26.93 | 26.93 | 26.93 | 26.93 |
| Depreciation | 1,473.6 | 1,333.5 | 1,067.6 | 929.1 | 877.2 | 1,195.9 | 1,203.5 | 1,211.0 | 1,218.6 | 1,226.3 |
| Depreciation, % | 24.69 | 23.94 | 18.24 | 16.48 | 14.43 | 19.56 | 19.56 | 19.56 | 19.56 | 19.56 |
| EBIT | -159.8 | 438.4 | 276.5 | 889.8 | 679.0 | 451.0 | 453.8 | 456.7 | 459.5 | 462.4 |
| EBIT, % | -2.68 | 7.87 | 4.72 | 15.78 | 11.17 | 7.37 | 7.37 | 7.37 | 7.37 | 7.37 |
| Total Cash | 2,250.7 | 419.9 | 403.9 | 391.4 | 657.2 | 855.0 | 860.3 | 865.7 | 871.2 | 876.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,276.3 | 1,094.5 | 1,231.9 | 1,242.3 | 1,386.7 | 1,307.8 | 1,316.0 | 1,324.3 | 1,332.6 | 1,341.0 |
| Account Receivables, % | 21.38 | 19.65 | 21.05 | 22.03 | 22.82 | 21.38 | 21.38 | 21.38 | 21.38 | 21.38 |
| Inventories | 768.3 | 759.3 | 689.2 | 756.5 | 1,071.6 | 847.9 | 853.2 | 858.6 | 864.0 | 869.4 |
| Inventories, % | 12.87 | 13.63 | 11.77 | 13.42 | 17.63 | 13.86 | 13.86 | 13.86 | 13.86 | 13.86 |
| Accounts Payable | 349.1 | 233.9 | 282.5 | 361.6 | 499.0 | 360.8 | 363.0 | 365.3 | 367.6 | 369.9 |
| Accounts Payable, % | 5.85 | 4.2 | 4.83 | 6.41 | 8.21 | 5.9 | 5.9 | 5.9 | 5.9 | 5.9 |
| Capital Expenditure | -192.9 | -214.5 | -196.4 | -186.0 | -188.8 | -206.0 | -207.3 | -208.6 | -209.9 | -211.2 |
| Capital Expenditure, % | -3.23 | -3.85 | -3.36 | -3.3 | -3.11 | -3.37 | -3.37 | -3.37 | -3.37 | -3.37 |
| Tax Rate, % | -51.79 | -51.79 | -51.79 | -51.79 | -51.79 | -51.79 | -51.79 | -51.79 | -51.79 | -51.79 |
| EBITAT | -155.1 | 262.4 | 253.0 | 1,462.3 | 1,030.7 | 404.5 | 407.0 | 409.6 | 412.1 | 414.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -569.9 | 1,457.1 | 1,105.5 | 2,206.8 | 1,397.2 | 1,558.7 | 1,391.9 | 1,400.6 | 1,409.4 | 1,418.3 |
| WACC, % | 6.09 | 4.22 | 5.81 | 6.24 | 6.24 | 5.72 | 5.72 | 5.72 | 5.72 | 5.72 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 6,106.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,447 | |||||||||
| Terminal Value | 38,859 | |||||||||
| Present Terminal Value | 29,420 | |||||||||
| Enterprise Value | 35,527 | |||||||||
| Net Debt | 14,880 | |||||||||
| Equity Value | 20,646 | |||||||||
| Diluted Shares Outstanding, MM | 365 | |||||||||
| Equity Value Per Share | 56.58 |
What You Will Get
- Real BHC Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Explore various scenarios to assess Bausch Health’s future performance.
- User-Friendly Design: Tailored for professionals while remaining approachable for newcomers.
Key Features
- 🔍 Real-Life BHC Financials: Pre-filled historical and projected data for Bausch Health Companies Inc. (BHC).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Bausch Health's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Bausch Health's valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Bausch Health data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Bausch Health's intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Bausch Health Companies Inc. (BHC)?
- All-in-One Solution: Features DCF, WACC, and various financial ratio analyses tailored for BHC.
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios for Bausch Health.
- In-Depth Analysis: Automatically computes Bausch Health’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide a solid foundation for analysis.
- High Standards: Perfect for financial analysts, investors, and business consultants focusing on BHC.
Who Should Use This Product?
- Healthcare Investors: Develop comprehensive and accurate valuation models for assessing Bausch Health Companies Inc. (BHC).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the healthcare sector.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Bausch Health Companies Inc. (BHC).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling related to healthcare companies.
- Pharmaceutical Enthusiasts: Gain insights into the valuation methods used for companies like Bausch Health Companies Inc. (BHC) in the market.
What the Template Contains
- Historical Data: Includes Bausch Health Companies Inc.'s (BHC) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Bausch Health Companies Inc.'s (BHC) 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 Bausch Health Companies Inc.'s (BHC) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.