Teleflex Incorporated (TFX) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Teleflex Incorporated (TFX) Bundle
Explore Teleflex Incorporated's (TFX) financial future with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate Teleflex Incorporated's (TFX) intrinsic value and refine your investment approach.
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,595.4 | 2,537.2 | 2,809.6 | 2,791.0 | 2,974.5 | 3,081.6 | 3,192.6 | 3,307.6 | 3,426.8 | 3,550.2 |
| Revenue Growth, % | 0 | -2.24 | 10.74 | -0.65925 | 6.57 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 |
| EBITDA | 634.2 | 666.0 | 873.1 | 751.7 | 743.7 | 824.0 | 853.7 | 884.4 | 916.3 | 949.3 |
| EBITDA, % | 24.44 | 26.25 | 31.08 | 26.93 | 25 | 26.74 | 26.74 | 26.74 | 26.74 | 26.74 |
| Depreciation | 214.1 | 227.3 | 237.4 | 230.6 | 242.1 | 259.2 | 268.5 | 278.2 | 288.2 | 298.6 |
| Depreciation, % | 8.25 | 8.96 | 8.45 | 8.26 | 8.14 | 8.41 | 8.41 | 8.41 | 8.41 | 8.41 |
| EBIT | 420.2 | 438.7 | 635.7 | 521.1 | 501.6 | 564.8 | 585.2 | 606.2 | 628.1 | 650.7 |
| EBIT, % | 16.19 | 17.29 | 22.63 | 18.67 | 16.86 | 18.33 | 18.33 | 18.33 | 18.33 | 18.33 |
| Total Cash | 301.1 | 375.9 | 445.1 | 292.0 | 222.8 | 371.1 | 384.5 | 398.3 | 412.7 | 427.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 418.7 | 395.1 | 383.6 | 408.8 | 443.5 | 461.7 | 478.3 | 495.6 | 513.4 | 531.9 |
| Account Receivables, % | 16.13 | 15.57 | 13.65 | 14.65 | 14.91 | 14.98 | 14.98 | 14.98 | 14.98 | 14.98 |
| Inventories | 476.6 | 513.2 | 477.6 | 578.5 | 626.2 | 600.1 | 621.7 | 644.1 | 667.3 | 691.4 |
| Inventories, % | 18.36 | 20.23 | 17 | 20.73 | 21.05 | 19.47 | 19.47 | 19.47 | 19.47 | 19.47 |
| Accounts Payable | 102.9 | 102.5 | 118.2 | 126.8 | 132.2 | 130.7 | 135.4 | 140.3 | 145.3 | 150.6 |
| Accounts Payable, % | 3.97 | 4.04 | 4.21 | 4.54 | 4.45 | 4.24 | 4.24 | 4.24 | 4.24 | 4.24 |
| Capital Expenditure | -102.7 | -90.7 | -71.6 | -79.2 | -91.4 | -98.6 | -102.1 | -105.8 | -109.6 | -113.5 |
| Capital Expenditure, % | -3.96 | -3.57 | -2.55 | -2.84 | -3.07 | -3.2 | -3.2 | -3.2 | -3.2 | -3.2 |
| Tax Rate, % | 17.9 | 17.9 | 17.9 | 17.9 | 17.9 | 17.9 | 17.9 | 17.9 | 17.9 | 17.9 |
| EBITAT | 570.4 | 411.2 | 551.5 | 424.3 | 411.8 | 501.6 | 519.7 | 538.4 | 557.8 | 577.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -110.5 | 534.4 | 780.1 | 458.2 | 485.6 | 668.5 | 652.5 | 676.0 | 700.4 | 725.6 |
| WACC, % | 8.98 | 8.93 | 8.87 | 8.83 | 8.83 | 8.89 | 8.89 | 8.89 | 8.89 | 8.89 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,660.3 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 755 | |||||||||
| Terminal Value | 15,445 | |||||||||
| Present Terminal Value | 10,091 | |||||||||
| Enterprise Value | 12,751 | |||||||||
| Net Debt | 1,704 | |||||||||
| Equity Value | 11,047 | |||||||||
| Diluted Shares Outstanding, MM | 47 | |||||||||
| Equity Value Per Share | 233.54 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Teleflex Incorporated’s (TFX) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Gain access to precise historical records and future forecasts for Teleflex Incorporated (TFX).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help you interpret your valuation findings.
- Designed for All Users: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based TFX DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Teleflex’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to analyze potential valuation shifts.
- Analyze and Decide: Utilize the findings to inform your investment or financial assessment.
Why Choose This Calculator for Teleflex Incorporated (TFX)?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust variables effortlessly to suit your financial analysis.
- Real-Time Valuation: Monitor immediate updates to Teleflex’s valuation as you tweak the inputs.
- Pre-Loaded Data: Comes with Teleflex’s actual financial information for swift evaluations.
- Widely Endorsed: A go-to tool for investors and analysts aiming for informed strategies.
Who Should Use This Product?
- Investors: Evaluate Teleflex Incorporated’s (TFX) valuation before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts for Teleflex Incorporated (TFX).
- Startup Founders: Discover how established companies like Teleflex Incorporated (TFX) are valued in the market.
- Consultants: Provide comprehensive valuation analyses and reports for clients interested in Teleflex Incorporated (TFX).
- Students and Educators: Utilize Teleflex Incorporated’s (TFX) data to practice and instruct on valuation strategies.
What the Template Contains
- Preloaded TFX Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.