PennantPark Investment Corporation (PNNT) DCF Valuation
- ✓ 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
PennantPark Investment Corporation (PNNT) Bundle
Designed for accuracy, our PennantPark Investment Corporation (PNNT) DCF Calculator empowers you to assess the valuation of PennantPark Investment Corporation with real-world financial data and offers complete flexibility to modify all essential parameters for enhanced projections.
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 | 100.2 | 171.3 | 105.0 | 145.4 | 115.3 | 129.7 | 145.9 | 164.1 | 184.6 | 207.6 |
| Revenue Growth, % | 0 | 70.93 | -38.73 | 38.49 | -20.71 | 12.49 | 12.49 | 12.49 | 12.49 | 12.49 |
| EBITDA | 152.9 | -18.5 | .0 | .0 | .0 | 23.1 | 26.0 | 29.3 | 32.9 | 37.0 |
| EBITDA, % | 152.6 | -10.82 | 0 | 0 | 0 | 17.84 | 17.84 | 17.84 | 17.84 | 17.84 |
| Depreciation | 59.8 | -78.1 | 129.8 | -109.2 | .0 | 10.1 | 11.4 | 12.8 | 14.4 | 16.2 |
| Depreciation, % | 59.68 | -45.6 | 123.67 | -75.15 | 0 | 7.79 | 7.79 | 7.79 | 7.79 | 7.79 |
| EBIT | 93.1 | 59.6 | -129.8 | 109.2 | .0 | 26.7 | 30.0 | 33.7 | 38.0 | 42.7 |
| EBIT, % | 92.92 | 34.78 | -123.67 | 75.15 | 0 | 20.57 | 20.57 | 20.57 | 20.57 | 20.57 |
| Total Cash | 25.8 | 20.4 | 52.7 | 38.8 | 49.9 | 40.9 | 46.0 | 51.8 | 58.2 | 65.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 6.4 | 19.4 | 35.5 | 11.9 | 5.3 | 16.7 | 18.8 | 21.1 | 23.7 | 26.7 |
| Account Receivables, % | 6.39 | 11.35 | 33.83 | 8.19 | 4.56 | 12.86 | 12.86 | 12.86 | 12.86 | 12.86 |
| Inventories | .0 | .0 | 90.3 | -5.1 | .0 | 21.4 | 24.1 | 27.1 | 30.5 | 34.3 |
| Inventories, % | 0.000000998 | 0.000000584 | 86.01 | -3.49 | 0 | 16.5 | 16.5 | 16.5 | 16.5 | 16.5 |
| Accounts Payable | 15.5 | 21.4 | 22.7 | 95.4 | 115.8 | 55.8 | 62.8 | 70.6 | 79.4 | 89.4 |
| Accounts Payable, % | 15.49 | 12.49 | 21.61 | 65.61 | 100.46 | 43.04 | 43.04 | 43.04 | 43.04 | 43.04 |
| Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Tax Rate, % | 5.96 | 5.96 | 5.96 | 5.96 | 5.96 | 5.96 | 5.96 | 5.96 | 5.96 | 5.96 |
| EBITAT | 100.7 | 59.4 | -190.5 | 141.3 | .0 | 26.3 | 29.6 | 33.3 | 37.5 | 42.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 169.6 | -25.9 | -165.7 | 223.7 | 22.0 | -56.4 | 43.2 | 48.6 | 54.7 | 61.5 |
| WACC, % | 16.42 | 16.39 | 16.42 | 16.42 | 15.97 | 16.33 | 16.33 | 16.33 | 16.33 | 16.33 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 73.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 63 | |||||||||
| Terminal Value | 438 | |||||||||
| Present Terminal Value | 206 | |||||||||
| Enterprise Value | 279 | |||||||||
| Net Debt | -50 | |||||||||
| Equity Value | 328 | |||||||||
| Diluted Shares Outstanding, MM | 65 | |||||||||
| Equity Value Per Share | 5.03 |
What You Will Get
- Authentic PennantPark Data: Preloaded financials – from revenue to net income – based on actual and projected figures.
- Complete Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to assess the effects of changes on PennantPark’s fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and comprehensive projections.
- Efficient and Precise: Eliminate the need to build models from scratch while ensuring accuracy and adaptability.
Key Features
- Comprehensive Financial Data: Access reliable historical records and future forecasts for PennantPark Investment Corporation (PNNT).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries for clear visualization of your valuation outcomes.
- Designed for All Skill Levels: An accessible layout tailored for investors, CFOs, and financial consultants.
How It Works
- Step 1: Download the prebuilt Excel template featuring PennantPark Investment Corporation’s (PNNT) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including the intrinsic value of PennantPark Investment Corporation (PNNT).
- Step 5: Use the outputs to make informed investment decisions or create comprehensive reports.
Why Choose the PennantPark Investment Corporation (PNNT) Calculator?
- Accuracy: Utilizes real PennantPark financials to ensure precise data.
- Flexibility: Crafted for users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Designed with CFO-level accuracy and ease of use in mind.
- User-Friendly: Intuitive interface suitable for users without extensive financial modeling skills.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling PennantPark Investment Corporation (PNNT) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for PennantPark Investment Corporation (PNNT).
- Consultants: Deliver professional valuation insights on PennantPark Investment Corporation (PNNT) to clients quickly and accurately.
- Business Owners: Understand how companies like PennantPark Investment Corporation (PNNT) are valued to guide your own investment strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to PennantPark Investment Corporation (PNNT).
What the Template Contains
- Preloaded PNNT 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.