Pyxis Tankers Inc. (PXS) 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
Pyxis Tankers Inc. (PXS) Bundle
Enhance your investment strategy with the (PXS) DCF Calculator! Utilize actual Pyxis Tankers Inc. financial data, adjust growth predictions and expenses, and immediately observe how these changes affect the intrinsic value of (PXS).
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 | 27.8 | 21.7 | 25.3 | 58.3 | 45.5 | 53.8 | 63.5 | 75.1 | 88.8 | 105.0 |
Revenue Growth, % | 0 | -21.77 | 16.72 | 130.24 | -22.07 | 18.22 | 18.22 | 18.22 | 18.22 | 18.22 |
EBITDA | 3.0 | 2.2 | -3.7 | 24.3 | 48.6 | 15.9 | 18.8 | 22.2 | 26.2 | 31.0 |
EBITDA, % | 10.83 | 9.92 | -14.79 | 41.68 | 106.8 | 29.53 | 29.53 | 29.53 | 29.53 | 29.53 |
Depreciation | 5.6 | 4.7 | 5.3 | 6.5 | 5.9 | 9.3 | 11.0 | 13.0 | 15.4 | 18.2 |
Depreciation, % | 20.03 | 21.51 | 20.93 | 11.11 | 12.96 | 17.31 | 17.31 | 17.31 | 17.31 | 17.31 |
EBIT | -2.6 | -2.5 | -9.1 | 17.8 | 42.7 | 7.3 | 8.6 | 10.2 | 12.1 | 14.3 |
EBIT, % | -9.21 | -11.59 | -35.72 | 30.57 | 93.85 | 13.58 | 13.58 | 13.58 | 13.58 | 13.58 |
Total Cash | 1.4 | 1.6 | 6.2 | 7.6 | 54.5 | 16.1 | 19.1 | 22.5 | 26.6 | 31.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1.2 | 3.0 | 1.7 | 11.1 | 5.2 | 5.9 | 7.0 | 8.3 | 9.8 | 11.6 |
Account Receivables, % | 4.48 | 13.68 | 6.77 | 18.99 | 11.34 | 11.05 | 11.05 | 11.05 | 11.05 | 11.05 |
Inventories | .5 | .7 | 1.6 | 1.9 | 1.0 | 1.8 | 2.1 | 2.5 | 2.9 | 3.5 |
Inventories, % | 1.81 | 3.14 | 6.18 | 3.28 | 2.1 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 |
Accounts Payable | 4.5 | 3.6 | 3.1 | 2.6 | 1.7 | 5.8 | 6.8 | 8.0 | 9.5 | 11.2 |
Accounts Payable, % | 16.35 | 16.77 | 12.17 | 4.46 | 3.73 | 10.7 | 10.7 | 10.7 | 10.7 | 10.7 |
Capital Expenditure | -.5 | -.6 | -43.2 | -3.6 | -32.0 | -19.5 | -23.0 | -27.2 | -32.1 | -38.0 |
Capital Expenditure, % | -1.86 | -2.61 | -170.45 | -6.09 | -70.4 | -36.19 | -36.19 | -36.19 | -36.19 | -36.19 |
Tax Rate, % | -0.54566 | -0.54566 | -0.54566 | -0.54566 | -0.54566 | -0.54566 | -0.54566 | -0.54566 | -0.54566 | -0.54566 |
EBITAT | -4.3 | -4.2 | -11.5 | 17.8 | 42.9 | 7.3 | 8.6 | 10.2 | 12.1 | 14.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 3.5 | -2.9 | -49.5 | 10.6 | 22.8 | -.4 | -3.7 | -4.4 | -5.2 | -6.2 |
WACC, % | 7.77 | 7.77 | 7.77 | 7.77 | 7.77 | 7.77 | 7.77 | 7.77 | 7.77 | 7.77 |
PV UFCF | ||||||||||
SUM PV UFCF | -15.2 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | -6 | |||||||||
Terminal Value | -85 | |||||||||
Present Terminal Value | -59 | |||||||||
Enterprise Value | -74 | |||||||||
Net Debt | 26 | |||||||||
Equity Value | -100 | |||||||||
Diluted Shares Outstanding, MM | 13 | |||||||||
Equity Value Per Share | -7.96 |
What You Will Get
- Comprehensive PXS Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Pyxis Tankers’ future performance.
- User-Friendly Interface: Designed for industry professionals while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Model: Features both unlevered and levered DCF valuation frameworks tailored for Pyxis Tankers Inc. (PXS).
- Customizable WACC Tool: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Flexible Forecast Inputs: Easily alter growth projections, capital expenditures, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Pyxis Tankers Inc. (PXS).
- Interactive Dashboard and Visuals: Graphical representations highlight essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file for Pyxis Tankers Inc. (PXS).
- Step 2: Review Pyxis Tankers' pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the results and leverage the outputs for your investment strategies.
Why Choose Pyxis Tankers Inc. (PXS) Calculator?
- Accuracy: Utilizes real Pyxis Tankers financial data for precise calculations.
- Flexibility: Allows users to easily adjust and test various input parameters.
- Time-Saving: Eliminates the need to create a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and standards expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users with varying financial backgrounds.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing PXS investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Offer clients precise valuation insights for Pyxis Tankers Inc. (PXS).
- Students and Educators: Utilize real-world data to learn and teach financial modeling techniques.
- Maritime Industry Enthusiasts: Gain insights into how shipping companies like Pyxis Tankers Inc. (PXS) are valued in the market.
What the Template Contains
- Pre-Filled Data: Features Pyxis Tankers Inc.'s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for PXS.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs specific to Pyxis Tankers Inc.
- Key Financial Ratios: Assess Pyxis Tankers Inc.'s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates for accurate forecasting.
- Clear Dashboard: Visual representations through charts and tables summarizing key valuation results for PXS.