Owens & Minor, Inc. (OMI) 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
Owens & Minor, Inc. (OMI) Bundle
Take charge of your Owens & Minor, Inc. (OMI) valuation analysis with our sophisticated DCF Calculator! Equipped with real (OMI) data, this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of Owens & Minor, Inc.
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 | 9,210.9 | 8,480.2 | 9,785.3 | 9,955.5 | 10,334.0 | 10,085.4 | 9,842.7 | 9,605.9 | 9,374.8 | 9,149.3 |
| Revenue Growth, % | 0 | -7.93 | 15.39 | 1.74 | 3.8 | -2.41 | -2.41 | -2.41 | -2.41 | -2.41 |
| EBITDA | 163.7 | 277.4 | 415.5 | 367.8 | 400.3 | 340.1 | 331.9 | 324.0 | 316.2 | 308.6 |
| EBITDA, % | 1.78 | 3.27 | 4.25 | 3.69 | 3.87 | 3.37 | 3.37 | 3.37 | 3.37 | 3.37 |
| Depreciation | 96.7 | 93.3 | 90.6 | 228.7 | 287.4 | 164.5 | 160.5 | 156.7 | 152.9 | 149.2 |
| Depreciation, % | 1.05 | 1.1 | 0.92609 | 2.3 | 2.78 | 1.63 | 1.63 | 1.63 | 1.63 | 1.63 |
| EBIT | 67.0 | 184.1 | 324.8 | 139.1 | 112.9 | 175.6 | 171.4 | 167.3 | 163.3 | 159.3 |
| EBIT, % | 0.72708 | 2.17 | 3.32 | 1.4 | 1.09 | 1.74 | 1.74 | 1.74 | 1.74 | 1.74 |
| Total Cash | 67.0 | 83.1 | 55.7 | 69.5 | 243.0 | 107.4 | 104.8 | 102.3 | 99.9 | 97.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 674.7 | 700.8 | 681.6 | 763.5 | 598.3 | 726.4 | 708.9 | 691.9 | 675.2 | 659.0 |
| Account Receivables, % | 7.33 | 8.26 | 6.97 | 7.67 | 5.79 | 7.2 | 7.2 | 7.2 | 7.2 | 7.2 |
| Inventories | 1,146.2 | 1,233.8 | 1,496.0 | 1,333.6 | 1,110.6 | 1,339.8 | 1,307.6 | 1,276.1 | 1,245.4 | 1,215.4 |
| Inventories, % | 12.44 | 14.55 | 15.29 | 13.4 | 10.75 | 13.28 | 13.28 | 13.28 | 13.28 | 13.28 |
| Accounts Payable | 808.0 | 1,000.2 | 1,002.0 | 1,147.4 | 1,171.9 | 1,082.6 | 1,056.6 | 1,031.1 | 1,006.3 | 982.1 |
| Accounts Payable, % | 8.77 | 11.79 | 10.24 | 11.53 | 11.34 | 10.73 | 10.73 | 10.73 | 10.73 | 10.73 |
| Capital Expenditure | -52.2 | -59.2 | -49.7 | -166.6 | -207.9 | -110.1 | -107.4 | -104.9 | -102.3 | -99.9 |
| Capital Expenditure, % | -0.56702 | -0.69802 | -0.5078 | -1.67 | -2.01 | -1.09 | -1.09 | -1.09 | -1.09 | -1.09 |
| Tax Rate, % | 24.53 | 24.53 | 24.53 | 24.53 | 24.53 | 24.53 | 24.53 | 24.53 | 24.53 | 24.53 |
| EBITAT | 52.7 | 147.5 | 260.1 | 286.0 | 85.2 | 145.5 | 142.0 | 138.6 | 135.3 | 132.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -915.7 | 260.2 | 59.8 | 574.0 | 577.4 | -246.7 | 218.8 | 213.5 | 208.4 | 203.4 |
| WACC, % | 5.66 | 5.73 | 5.73 | 6.68 | 5.51 | 5.86 | 5.86 | 5.86 | 5.86 | 5.86 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 461.1 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 210 | |||||||||
| Terminal Value | 8,918 | |||||||||
| Present Terminal Value | 6,708 | |||||||||
| Enterprise Value | 7,169 | |||||||||
| Net Debt | 2,077 | |||||||||
| Equity Value | 5,092 | |||||||||
| Diluted Shares Outstanding, MM | 76 | |||||||||
| Equity Value Per Share | 67.19 |
What You Will Get
- Pre-Filled Financial Model: Owens & Minor, Inc.'s (OMI) actual data facilitates accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other critical factors.
- Instant Calculations: Automatic updates provide real-time results as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, allowing for repeated use in comprehensive forecasts.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Owens & Minor, Inc. (OMI).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to Owens & Minor, Inc. (OMI).
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Owens & Minor, Inc. (OMI) projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Owens & Minor, Inc. (OMI).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of Owens & Minor, Inc. (OMI).
How It Works
- Step 1: Download the Excel file for Owens & Minor, Inc. (OMI).
- Step 2: Review the pre-filled financial data and forecasts specific to Owens & Minor, Inc. (OMI).
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Owens & Minor, Inc. (OMI)?
- Designed for Experts: A sophisticated tool utilized by industry analysts, CFOs, and healthcare consultants.
- Accurate Data: Owens & Minor’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Healthcare Providers: Make informed decisions about purchasing or selling Owens & Minor, Inc. (OMI) stock.
- Financial Analysts: Enhance valuation processes with comprehensive, ready-to-use financial models for Owens & Minor, Inc. (OMI).
- Consultants: Provide clients with accurate and timely valuation insights related to Owens & Minor, Inc. (OMI).
- Business Owners: Gain insights into how healthcare supply companies like Owens & Minor, Inc. (OMI) are valued to inform your own business strategies.
- Finance Students: Explore valuation techniques using real-world data and scenarios specific to Owens & Minor, Inc. (OMI).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for Owens & Minor, Inc. (OMI).
- Real-World Data: Owens & Minor’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into Owens & Minor, Inc. (OMI).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Owens & Minor, Inc. (OMI).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results tailored to Owens & Minor, Inc. (OMI).