Bio-Rad Laboratories, Inc. (BIO) 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
Bio-Rad Laboratories, Inc. (BIO) Bundle
Looking to assess Bio-Rad Laboratories, Inc.'s intrinsic value? Our BIO DCF Calculator integrates real-world data with comprehensive customization features, enabling you to refine projections and enhance your investment strategies.
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 | 2,311.7 | 2,545.6 | 2,922.5 | 2,802.2 | 2,671.3 | 2,779.0 | 2,891.1 | 3,007.8 | 3,129.1 | 3,255.4 |
| Revenue Growth, % | 0 | 10.12 | 14.81 | -4.12 | -4.67 | 4.03 | 4.03 | 4.03 | 4.03 | 4.03 |
| EBITDA | 2,459.0 | 5,104.7 | 5,627.5 | -4,489.0 | -608.3 | 985.1 | 1,024.8 | 1,066.1 | 1,109.1 | 1,153.9 |
| EBITDA, % | 106.37 | 200.53 | 192.55 | -160.19 | -22.77 | 35.45 | 35.45 | 35.45 | 35.45 | 35.45 |
| Depreciation | 174.5 | 175.2 | 176.9 | 177.2 | 145.9 | 179.4 | 186.6 | 194.1 | 201.9 | 210.1 |
| Depreciation, % | 7.55 | 6.88 | 6.05 | 6.32 | 5.46 | 6.45 | 6.45 | 6.45 | 6.45 | 6.45 |
| EBIT | 2,284.5 | 4,929.5 | 5,450.6 | -4,666.2 | -754.2 | 948.2 | 986.4 | 1,026.2 | 1,067.6 | 1,110.7 |
| EBIT, % | 98.82 | 193.65 | 186.5 | -166.51 | -28.23 | 34.12 | 34.12 | 34.12 | 34.12 | 34.12 |
| Total Cash | 1,120.2 | 996.7 | 875.5 | 1,796.2 | 1,607.1 | 1,344.1 | 1,398.3 | 1,454.8 | 1,513.4 | 1,574.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 392.7 | 419.4 | 423.5 | 494.6 | 489.0 | 466.4 | 485.2 | 504.8 | 525.1 | 546.3 |
| Account Receivables, % | 16.99 | 16.48 | 14.49 | 17.65 | 18.31 | 16.78 | 16.78 | 16.78 | 16.78 | 16.78 |
| Inventories | 554.0 | 622.3 | 572.2 | 719.3 | 780.5 | 683.0 | 710.5 | 739.2 | 769.0 | 800.0 |
| Inventories, % | 23.97 | 24.44 | 19.58 | 25.67 | 29.22 | 24.58 | 24.58 | 24.58 | 24.58 | 24.58 |
| Accounts Payable | 107.0 | 139.5 | 141.9 | 135.0 | 144.6 | 140.0 | 145.7 | 151.6 | 157.7 | 164.1 |
| Accounts Payable, % | 4.63 | 5.48 | 4.86 | 4.82 | 5.41 | 5.04 | 5.04 | 5.04 | 5.04 | 5.04 |
| Capital Expenditure | -98.5 | -98.9 | -120.8 | -114.2 | -156.7 | -123.5 | -128.5 | -133.7 | -139.1 | -144.7 |
| Capital Expenditure, % | -4.26 | -3.89 | -4.13 | -4.07 | -5.87 | -4.44 | -4.44 | -4.44 | -4.44 | -4.44 |
| Tax Rate, % | 25.03 | 25.03 | 25.03 | 25.03 | 25.03 | 25.03 | 25.03 | 25.03 | 25.03 | 25.03 |
| EBITAT | 1,776.9 | 3,831.2 | 4,264.0 | -3,598.1 | -565.4 | 731.6 | 761.1 | 791.8 | 823.8 | 857.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,013.2 | 3,844.9 | 4,368.5 | -3,760.2 | -622.2 | 903.1 | 778.5 | 809.9 | 842.6 | 876.6 |
| WACC, % | 8.18 | 8.18 | 8.18 | 8.18 | 8.17 | 8.18 | 8.18 | 8.18 | 8.18 | 8.18 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,346.8 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 881 | |||||||||
| Terminal Value | 11,474 | |||||||||
| Present Terminal Value | 7,745 | |||||||||
| Enterprise Value | 11,092 | |||||||||
| Net Debt | 1,002 | |||||||||
| Equity Value | 10,090 | |||||||||
| Diluted Shares Outstanding, MM | 29 | |||||||||
| Equity Value Per Share | 345.45 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real BIO financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Bio-Rad's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Bio-Rad Laboratories, Inc. (BIO).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to Bio-Rad.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Bio-Rad's financial strategies.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Bio-Rad Laboratories, Inc. (BIO).
- Visual Dashboard and Charts: Graphical representations summarize key valuation metrics for streamlined analysis.
How It Works
- Step 1: Download the prebuilt Excel template with Bio-Rad Laboratories, Inc.'s (BIO) data included.
- Step 2: Explore the pre-filled sheets and understand the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Bio-Rad Laboratories, Inc.'s (BIO) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Modify parameters easily to suit your specific analysis.
- Real-Time Adjustments: Observe immediate changes to Bio-Rad’s valuation as you tweak inputs.
- Preloaded Data: Comes with Bio-Rad’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Accurately assess Bio-Rad’s fair value before making investment choices.
- CFOs: Utilize a high-quality DCF model for financial reporting and analysis.
- Consultants: Easily customize the template for valuation reports tailored to clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading biotech firms.
- Educators: Implement it as a teaching resource to illustrate valuation techniques.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Bio-Rad Laboratories 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 Bio-Rad Laboratories, Inc. (BIO).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.