NextPlat Corp (NXPL) 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
NextPlat Corp (NXPL) Bundle
Explore the financial outlook of NextPlat Corp (NXPL) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of NextPlat Corp (NXPL) and inform your investment decisions.
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 | 5.9 | 5.7 | 7.7 | 11.7 | 37.8 | 55.1 | 80.6 | 117.7 | 171.9 | 251.0 |
Revenue Growth, % | 0 | -3.06 | 36.03 | 51.3 | 222.42 | 46.07 | 46.07 | 46.07 | 46.07 | 46.07 |
EBITDA | -.8 | -1.4 | -6.3 | -6.7 | -19.7 | -25.3 | -36.9 | -54.0 | -78.8 | -115.1 |
EBITDA, % | -13.64 | -24.93 | -81.27 | -57.33 | -52.14 | -45.86 | -45.86 | -45.86 | -45.86 | -45.86 |
Depreciation | .3 | .3 | .4 | .6 | 2.5 | 3.0 | 4.3 | 6.3 | 9.2 | 13.5 |
Depreciation, % | 4.85 | 5.68 | 4.52 | 5.09 | 6.69 | 5.37 | 5.37 | 5.37 | 5.37 | 5.37 |
EBIT | -1.1 | -1.7 | -6.6 | -7.3 | -22.2 | -28.3 | -41.3 | -60.3 | -88.0 | -128.6 |
EBIT, % | -18.49 | -30.6 | -85.79 | -62.42 | -58.83 | -51.23 | -51.23 | -51.23 | -51.23 | -51.23 |
Total Cash | .1 | .7 | 17.3 | 18.9 | 26.3 | 31.3 | 45.7 | 66.8 | 97.5 | 142.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .3 | .3 | .9 | 1.0 | 11.6 | 6.7 | 9.8 | 14.3 | 20.9 | 30.6 |
Account Receivables, % | 5.46 | 4.44 | 12.17 | 8.19 | 30.61 | 12.17 | 12.17 | 12.17 | 12.17 | 12.17 |
Inventories | .4 | .4 | 1.0 | 1.3 | 5.1 | 5.6 | 8.1 | 11.8 | 17.3 | 25.3 |
Inventories, % | 6.24 | 6.35 | 13.17 | 10.99 | 13.6 | 10.07 | 10.07 | 10.07 | 10.07 | 10.07 |
Accounts Payable | .9 | .7 | .8 | 1.2 | 12.1 | 9.0 | 13.2 | 19.3 | 28.1 | 41.1 |
Accounts Payable, % | 15.35 | 13.14 | 10.94 | 10.25 | 32.16 | 16.37 | 16.37 | 16.37 | 16.37 | 16.37 |
Capital Expenditure | -.1 | .0 | -.2 | -.7 | -.6 | -1.4 | -2.0 | -3.0 | -4.3 | -6.3 |
Capital Expenditure, % | -1.2 | -0.61343 | -2.96 | -6.11 | -1.71 | -2.52 | -2.52 | -2.52 | -2.52 | -2.52 |
Tax Rate, % | 83.05 | 83.05 | 83.05 | 83.05 | 83.05 | 83.05 | 83.05 | 83.05 | 83.05 | 83.05 |
EBITAT | -1.1 | -2.4 | -7.8 | -7.4 | -3.8 | -23.6 | -34.4 | -50.3 | -73.4 | -107.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -.7 | -2.2 | -9.0 | -7.4 | -5.4 | -20.7 | -33.6 | -49.1 | -71.7 | -104.7 |
WACC, % | 8.24 | 8.24 | 8.24 | 8.24 | 7.77 | 8.15 | 8.15 | 8.15 | 8.15 | 8.15 |
PV UFCF | ||||||||||
SUM PV UFCF | -209.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -107 | |||||||||
Terminal Value | -1,738 | |||||||||
Present Terminal Value | -1,174 | |||||||||
Enterprise Value | -1,384 | |||||||||
Net Debt | -23 | |||||||||
Equity Value | -1,361 | |||||||||
Diluted Shares Outstanding, MM | 17 | |||||||||
Equity Value Per Share | -77.80 |
What You Will Receive
- Adjustable Forecast Inputs: Modify key assumptions (growth %, margins, WACC) effortlessly to generate various scenarios.
- Comprehensive Data: NextPlat Corp’s financial information pre-loaded to facilitate your analysis.
- Instant DCF Outputs: The template automatically computes Net Present Value (NPV) and intrinsic value for you.
- Tailorable and Professional: A sleek Excel model designed to meet your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and optimizing time.
Key Features
- 🔍 Real-Life NXPL Financials: Pre-filled historical and projected data for NextPlat Corp.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate NextPlat’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize NextPlat’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template featuring NextPlat Corp’s (NXPL) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including NextPlat Corp’s (NXPL) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create comprehensive reports.
Why Choose NextPlat Corp (NXPL) Calculator?
- Precision: Utilizes real-time NextPlat Corp (NXPL) financials for reliable data.
- Adaptability: Built for users to easily experiment and adjust inputs as needed.
- Efficiency: Avoid the complexities of creating a DCF model from the ground up.
- High-Quality: Crafted with the expertise and usability expected at the CFO level.
- Intuitive: Simple to navigate, suitable for users with varying levels of financial expertise.
Who Should Use This Product?
- Professional Investors: Create comprehensive and accurate valuation models for analyzing portfolios involving NextPlat Corp (NXPL).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in NextPlat Corp (NXPL).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Tech Enthusiasts: Gain insights into how tech companies like NextPlat Corp (NXPL) are assessed in the market.
What the Template Contains
- Preloaded NXPL 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.