PennantPark Floating Rate Capital Ltd. (PFLT) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
PennantPark Floating Rate Capital Ltd. (PFLT) Bundle
Whether you’re an investor or analyst, this (PFLT) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from PennantPark Floating Rate Capital Ltd., you can adjust forecasts and immediately observe the effects.
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 | 22.7 | 61.9 | 11.6 | 139.3 | 110.3 | 137.3 | 170.9 | 212.7 | 264.8 | 329.6 |
| Revenue Growth, % | 0 | 173.02 | -81.24 | 1099.73 | -20.85 | 24.48 | 24.48 | 24.48 | 24.48 | 24.48 |
| EBITDA | .0 | .0 | .0 | -28.2 | .0 | -5.6 | -6.9 | -8.6 | -10.7 | -13.4 |
| EBITDA, % | 0 | 0 | 0 | -20.26 | 0 | -4.05 | -4.05 | -4.05 | -4.05 | -4.05 |
| Depreciation | 37.3 | -11.2 | 61.2 | -106.6 | .0 | 28.9 | 36.0 | 44.9 | 55.8 | 69.5 |
| Depreciation, % | 164.41 | -18.04 | 526.7 | -76.53 | 0 | 21.09 | 21.09 | 21.09 | 21.09 | 21.09 |
| EBIT | -37.3 | 11.2 | -61.2 | 78.4 | .0 | -34.5 | -43.0 | -53.5 | -66.6 | -82.8 |
| EBIT, % | -164.41 | 18.04 | -526.7 | 56.27 | 0 | -25.14 | -25.14 | -25.14 | -25.14 | -25.14 |
| Total Cash | 57.5 | 49.8 | 47.9 | 100.0 | 112.1 | 124.2 | 154.6 | 192.4 | 239.5 | 298.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3.7 | 39.4 | 11.0 | 11.0 | 12.8 | 53.2 | 66.3 | 82.5 | 102.7 | 127.8 |
| Account Receivables, % | 16.2 | 63.65 | 94.58 | 7.89 | 11.61 | 38.78 | 38.78 | 38.78 | 38.78 | 38.78 |
| Inventories | 112.9 | 141.3 | .0 | .0 | .0 | 54.9 | 68.4 | 85.1 | 105.9 | 131.8 |
| Inventories, % | 497.75 | 228.29 | 0.000008610298 | 0.000000718 | 0 | 40 | 40 | 40 | 40 | 40 |
| Accounts Payable | 11.1 | 10.2 | 12.5 | 19.5 | 45.0 | 60.5 | 75.3 | 93.7 | 116.6 | 145.2 |
| Accounts Payable, % | 48.88 | 16.5 | 107.38 | 14.02 | 40.83 | 44.05 | 44.05 | 44.05 | 44.05 | 44.05 |
| 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, % | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
| EBITAT | -36.5 | 11.1 | -25.1 | 76.5 | .0 | -30.0 | -37.3 | -46.5 | -57.8 | -72.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -104.7 | -65.2 | 208.1 | -23.1 | 23.7 | -81.0 | -13.0 | -16.1 | -20.1 | -25.0 |
| WACC, % | 15.81 | 15.9 | 12.33 | 15.79 | 15.87 | 15.14 | 15.14 | 15.14 | 15.14 | 15.14 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -114.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -26 | |||||||||
| Terminal Value | -194 | |||||||||
| Present Terminal Value | -96 | |||||||||
| Enterprise Value | -210 | |||||||||
| Net Debt | -112 | |||||||||
| Equity Value | -98 | |||||||||
| Diluted Shares Outstanding, MM | 66 | |||||||||
| Equity Value Per Share | -1.50 |
What You Will Receive
- Pre-Filled Financial Model: PennantPark Floating Rate Capital Ltd.’s (PFLT) actual data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Real-Time Calculations: Automatic updates allow you to view results instantly as you make adjustments.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Comprehensive Financial Data: Gain access to reliable pre-loaded historical figures and future forecasts for PennantPark Floating Rate Capital Ltd. (PFLT).
- Adjustable Forecast Parameters: Modify the 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: Clear and concise charts and summaries to help you visualize your valuation outcomes.
- Suitable for All Levels: An intuitive design tailored for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file featuring PennantPark Floating Rate Capital Ltd.'s (PFLT) financial data.
- 2. Modify Assumptions: Adjust key parameters such as interest rates, investment returns, and operational costs.
- 3. View Results Instantly: The DCF model automatically computes the intrinsic value and NPV based on your inputs.
- 4. Evaluate Scenarios: Analyze various forecasts to understand different valuation possibilities.
- 5. Present with Assurance: Deliver expert valuation insights to enhance your investment strategies.
Why Choose PennantPark Floating Rate Capital Ltd. (PFLT)?
- Streamlined Investments: Benefit from a straightforward investment approach tailored for floating rate opportunities.
- Enhanced Returns: Access to competitive yields through strategic portfolio management.
- Customizable Strategies: Align your investment strategy with your financial goals and risk tolerance.
- User-Friendly Insights: Comprehensive reports and analytics simplify your investment decisions.
- Expertise You Can Trust: Backed by a team of seasoned professionals dedicated to maximizing value.
Who Should Use This Product?
- Finance Students: Master the art of floating rate debt analysis and apply concepts with real market data.
- Academics: Integrate advanced financial models related to floating rate investments into your curriculum or research.
- Investors: Evaluate your investment strategies and analyze the performance of PennantPark Floating Rate Capital Ltd. (PFLT).
- Analysts: Enhance your analytical capabilities with a ready-to-use, customizable model tailored for floating rate securities.
- Small Business Owners: Understand the financial metrics and valuation techniques used by larger firms like PennantPark Floating Rate Capital Ltd. (PFLT).
What the Template Contains
- Historical Data: Includes PennantPark Floating Rate Capital Ltd.'s (PFLT) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate PennantPark's 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 PennantPark's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.