Penumbra, Inc. (PEN) 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
Penumbra, Inc. (PEN) Bundle
Explore the financial prospects of Penumbra, Inc. (PEN) with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and expenses to determine the intrinsic value of Penumbra, Inc. (PEN) and enhance your investment strategy.
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 | 547.4 | 560.4 | 747.6 | 847.1 | 1,058.5 | 1,254.5 | 1,486.7 | 1,761.9 | 2,088.0 | 2,474.6 |
| Revenue Growth, % | 0 | 2.38 | 33.4 | 13.32 | 24.95 | 18.51 | 18.51 | 18.51 | 18.51 | 18.51 |
| EBITDA | 47.5 | -22.3 | 7.8 | 6.1 | 112.0 | 42.8 | 50.7 | 60.0 | 71.2 | 84.3 |
| EBITDA, % | 8.68 | -3.99 | 1.05 | 0.71795 | 10.58 | 3.41 | 3.41 | 3.41 | 3.41 | 3.41 |
| Depreciation | 7.9 | 15.7 | 19.5 | 27.6 | 30.6 | 32.6 | 38.6 | 45.8 | 54.2 | 64.3 |
| Depreciation, % | 1.43 | 2.8 | 2.61 | 3.25 | 2.89 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 |
| EBIT | 39.7 | -38.0 | -11.7 | -21.5 | 81.4 | 10.2 | 12.1 | 14.3 | 16.9 | 20.1 |
| EBIT, % | 7.24 | -6.78 | -1.56 | -2.54 | 7.69 | 0.81077 | 0.81077 | 0.81077 | 0.81077 | 0.81077 |
| Total Cash | 189.4 | 264.8 | 254.9 | 188.0 | 289.2 | 415.1 | 492.0 | 583.1 | 691.0 | 818.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 105.9 | 114.6 | 133.9 | 203.4 | 201.8 | 252.9 | 299.7 | 355.1 | 420.9 | 498.8 |
| Account Receivables, % | 19.35 | 20.45 | 17.92 | 24.01 | 19.06 | 20.16 | 20.16 | 20.16 | 20.16 | 20.16 |
| Inventories | 153.0 | 219.5 | 263.5 | 334.0 | 388.0 | 447.7 | 530.6 | 628.8 | 745.2 | 883.2 |
| Inventories, % | 27.95 | 39.17 | 35.25 | 39.43 | 36.66 | 35.69 | 35.69 | 35.69 | 35.69 | 35.69 |
| Accounts Payable | 15.1 | 14.1 | 13.4 | 26.7 | 27.2 | 32.1 | 38.0 | 45.1 | 53.4 | 63.3 |
| Accounts Payable, % | 2.76 | 2.52 | 1.8 | 3.15 | 2.57 | 2.56 | 2.56 | 2.56 | 2.56 | 2.56 |
| Capital Expenditure | -22.1 | -24.8 | -21.2 | -19.3 | -15.2 | -37.6 | -44.6 | -52.9 | -62.7 | -74.3 |
| Capital Expenditure, % | -4.04 | -4.42 | -2.83 | -2.28 | -1.44 | -3 | -3 | -3 | -3 | -3 |
| Tax Rate, % | -14.19 | -14.19 | -14.19 | -14.19 | -14.19 | -14.19 | -14.19 | -14.19 | -14.19 | -14.19 |
| EBITAT | 38.3 | -19.3 | 2.9 | 11.1 | 92.9 | 5.0 | 6.0 | 7.1 | 8.4 | 9.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -219.7 | -104.6 | -62.8 | -107.4 | 56.4 | -105.9 | -123.8 | -146.7 | -173.9 | -206.0 |
| WACC, % | 6.81 | 6.76 | 6.71 | 6.71 | 6.82 | 6.76 | 6.76 | 6.76 | 6.76 | 6.76 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -610.7 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -214 | |||||||||
| Terminal Value | -7,757 | |||||||||
| Present Terminal Value | -5,593 | |||||||||
| Enterprise Value | -6,203 | |||||||||
| Net Debt | 67 | |||||||||
| Equity Value | -6,270 | |||||||||
| Diluted Shares Outstanding, MM | 39 | |||||||||
| Equity Value Per Share | -159.88 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real PEN 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 Penumbra’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 Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for Penumbra, Inc. (PEN).
- Adjustable Forecast Inputs: Modify highlighted fields such as WACC, growth rates, and profit margins to tailor your analysis.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: Utilize user-friendly charts and summaries to effectively visualize your valuation findings.
- Designed for All Skill Levels: A straightforward, intuitive layout suitable for investors, CFOs, and consultants alike.
How It Works
- Download: Get the pre-built Excel file featuring Penumbra, Inc.'s (PEN) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: Watch intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and analyze results instantly.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for Penumbra, Inc. (PEN)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Penumbra, Inc. (PEN).
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Penumbra’s intrinsic value and Net Present Value.
- Preloaded Information: Access historical and forecasted data for precise calculations.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focused on Penumbra, Inc. (PEN).
Who Should Use Penumbra, Inc. (PEN)?
- Healthcare Investors: Make informed investment choices with a comprehensive analysis of Penumbra's market potential.
- Medical Device Analysts: Streamline your evaluations with a detailed financial model tailored for Penumbra's offerings.
- Consultants in Healthcare: Effortlessly customize presentations or reports focused on Penumbra's innovative solutions.
- Medical Technology Enthusiasts: Enhance your knowledge of the industry by exploring Penumbra's advancements and strategies.
- Educators and Students in Healthcare Finance: Utilize it as a hands-on resource for learning about the financial aspects of medical technology.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Penumbra 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 Penumbra, Inc. (PEN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.