|
Valoración de DCF de Becton, Dickinson and Company (BDX)
US | Healthcare | Medical - Instruments & Supplies | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Becton, Dickinson and Company (BDX) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (BDX)! Utilizando datos reales de Becton, Dickinson y Company y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valorar BDX como un inversor experimentado.
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 | 17,117.0 | 20,248.0 | 18,870.0 | 19,372.0 | 20,178.0 | 21,101.5 | 22,067.3 | 23,077.2 | 24,133.4 | 25,238.0 |
Revenue Growth, % | 0 | 18.29 | -6.81 | 2.66 | 4.16 | 4.58 | 4.58 | 4.58 | 4.58 | 4.58 |
EBITDA | 2,972.0 | 4,252.0 | 4,287.0 | 4,275.0 | 4,847.0 | 4,522.9 | 4,729.9 | 4,946.4 | 5,172.8 | 5,409.5 |
EBITDA, % | 17.36 | 21 | 22.72 | 22.07 | 24.02 | 21.43 | 21.43 | 21.43 | 21.43 | 21.43 |
Depreciation | 2,030.0 | 2,091.0 | 2,102.0 | 2,161.0 | 2,286.0 | 2,355.4 | 2,463.2 | 2,575.9 | 2,693.8 | 2,817.1 |
Depreciation, % | 11.86 | 10.33 | 11.14 | 11.16 | 11.33 | 11.16 | 11.16 | 11.16 | 11.16 | 11.16 |
EBIT | 942.0 | 2,161.0 | 2,185.0 | 2,114.0 | 2,561.0 | 2,167.5 | 2,266.7 | 2,370.5 | 2,479.0 | 2,592.4 |
EBIT, % | 5.5 | 10.67 | 11.58 | 10.91 | 12.69 | 10.27 | 10.27 | 10.27 | 10.27 | 10.27 |
Total Cash | 2,845.0 | 2,295.0 | 1,014.0 | 1,424.0 | 2,301.0 | 2,198.1 | 2,298.7 | 2,403.9 | 2,513.9 | 2,629.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2,398.0 | 2,350.0 | 2,191.0 | 2,534.0 | 3,033.0 | 2,757.5 | 2,883.7 | 3,015.7 | 3,153.7 | 3,298.0 |
Account Receivables, % | 14.01 | 11.61 | 11.61 | 13.08 | 15.03 | 13.07 | 13.07 | 13.07 | 13.07 | 13.07 |
Inventories | 2,743.0 | 2,866.0 | 3,224.0 | 3,273.0 | 3,843.0 | 3,511.5 | 3,672.3 | 3,840.3 | 4,016.1 | 4,199.9 |
Inventories, % | 16.03 | 14.15 | 17.09 | 16.9 | 19.05 | 16.64 | 16.64 | 16.64 | 16.64 | 16.64 |
Accounts Payable | 1,355.0 | 1,739.0 | 1,699.0 | 1,641.0 | 1,896.0 | 1,830.6 | 1,914.4 | 2,002.0 | 2,093.6 | 2,189.4 |
Accounts Payable, % | 7.92 | 8.59 | 9 | 8.47 | 9.4 | 8.68 | 8.68 | 8.68 | 8.68 | 8.68 |
Capital Expenditure | -810.0 | -1,231.0 | -973.0 | -874.0 | -725.0 | -1,015.9 | -1,062.4 | -1,111.1 | -1,161.9 | -1,215.1 |
Capital Expenditure, % | -4.73 | -6.08 | -5.16 | -4.51 | -3.59 | -4.81 | -4.81 | -4.81 | -4.81 | -4.81 |
Tax Rate, % | 14.96 | 14.96 | 14.96 | 14.96 | 14.96 | 14.96 | 14.96 | 14.96 | 14.96 | 14.96 |
EBITAT | 835.8 | 2,016.4 | 2,180.1 | 1,887.6 | 2,177.8 | 1,977.4 | 2,067.9 | 2,162.6 | 2,261.5 | 2,365.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,730.2 | 3,185.4 | 3,070.1 | 2,724.6 | 2,924.8 | 3,858.4 | 3,265.5 | 3,415.0 | 3,571.3 | 3,734.7 |
WACC, % | 5.96 | 6.01 | 6.08 | 5.97 | 5.93 | 5.99 | 5.99 | 5.99 | 5.99 | 5.99 |
PV UFCF | ||||||||||
SUM PV UFCF | 15,037.2 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 3,884 | |||||||||
Terminal Value | 195,166 | |||||||||
Present Terminal Value | 145,907 | |||||||||
Enterprise Value | 160,944 | |||||||||
Net Debt | 18,254 | |||||||||
Equity Value | 142,690 | |||||||||
Diluted Shares Outstanding, MM | 291 | |||||||||
Equity Value Per Share | 490.33 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
- Real-World Data: Becton, Dickinson and Company’s (BDX) financial data pre-loaded to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Pre-Loaded Data: Becton, Dickinson and Company’s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Edit WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: See Becton, Dickinson and Company’s intrinsic value recalculate in real time.
- Clear Visual Outputs: Dashboard charts display valuation results and key metrics.
- Built for Accuracy: A professional tool for analysts, investors, and finance experts.
How It Works
- Download: Get the pre-configured Excel file containing Becton, Dickinson and Company's (BDX) financial data.
- Customize: Modify projections, such as revenue growth rates, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and compare results instantly.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Becton, Dickinson and Company (BDX)?
- Accurate Data: Utilize real BDX financials to ensure dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the healthcare sector.
- User-Friendly: An intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Healthcare Professionals: Understand the latest innovations and applications of Becton, Dickinson and Company's (BDX) products.
- Researchers: Utilize BDX's data to enhance studies in medical technology and device development.
- Investors: Evaluate market trends and performance metrics for Becton, Dickinson and Company (BDX) stock.
- Educators: Integrate BDX's case studies into teaching materials for courses in healthcare management.
- Pharmaceutical Companies: Collaborate with BDX to explore synergies in product offerings and market strategies.
What the Template Contains
- Historical Data: Includes Becton, Dickinson and Company’s (BDX) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Becton, Dickinson and Company’s (BDX) 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 Becton, Dickinson and Company’s (BDX) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.