|
Valoración de DCF de Katapult Holdings, Inc. (KPLT)
US | Technology | Software - Infrastructure | NASDAQ
|
- ✓ 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
Katapult Holdings, Inc. (KPLT) Bundle
¡Descubra el verdadero potencial de Katapult Holdings, Inc. (KPLT) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los ajustes afectan la valoración de Katapult, todo dentro de una plantilla de Excel conveniente.
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 | 91.9 | 247.2 | 303.1 | 212.1 | 221.6 | 275.4 | 342.2 | 425.2 | 528.4 | 656.6 |
| Revenue Growth, % | 0 | 169.06 | 22.62 | -30.02 | 4.47 | 24.27 | 24.27 | 24.27 | 24.27 | 24.27 |
| EBITDA | 36.9 | 164.4 | 161.4 | 95.9 | 137.1 | 147.0 | 182.7 | 227.1 | 282.2 | 350.6 |
| EBITDA, % | 40.13 | 66.51 | 53.25 | 45.23 | 61.88 | 53.4 | 53.4 | 53.4 | 53.4 | 53.4 |
| Depreciation | .2 | .8 | 301.5 | 220.0 | 126.9 | 141.7 | 176.0 | 218.8 | 271.8 | 337.8 |
| Depreciation, % | 0.18715 | 0.32189 | 99.45 | 103.72 | 57.26 | 51.45 | 51.45 | 51.45 | 51.45 | 51.45 |
| EBIT | 36.7 | 163.6 | -140.0 | -124.0 | 10.2 | 3.3 | 4.1 | 5.2 | 6.4 | 8.0 |
| EBIT, % | 39.94 | 66.19 | -46.2 | -58.48 | 4.62 | 1.21 | 1.21 | 1.21 | 1.21 | 1.21 |
| Total Cash | 1.6 | 65.6 | 92.5 | 65.4 | 21.4 | 54.7 | 67.9 | 84.4 | 104.9 | 130.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .9 | 1.6 | 2.0 | .0 | 5.0 | 2.5 | 3.1 | 3.9 | 4.8 | 6.0 |
| Account Receivables, % | 1.01 | 0.66181 | 0.66213 | 0 | 2.26 | 0.91721 | 0.91721 | 0.91721 | 0.91721 | 0.91721 |
| Inventories | -.9 | 5.2 | 8.2 | .0 | .0 | 2.1 | 2.6 | 3.2 | 4.0 | 5.0 |
| Inventories, % | -1.01 | 2.11 | 2.7 | 0 | 0 | 0.76156 | 0.76156 | 0.76156 | 0.76156 | 0.76156 |
| Accounts Payable | .9 | 1.7 | 2.0 | 1.3 | .9 | 1.8 | 2.3 | 2.9 | 3.5 | 4.4 |
| Accounts Payable, % | 1 | 0.68285 | 0.66939 | 0.59593 | 0.40751 | 0.6714 | 0.6714 | 0.6714 | 0.6714 | 0.6714 |
| Capital Expenditure | -.1 | -.4 | -1.4 | -1.5 | -1.0 | -1.0 | -1.3 | -1.6 | -2.0 | -2.5 |
| Capital Expenditure, % | -0.08924976 | -0.17638 | -0.47375 | -0.70955 | -0.43955 | -0.3777 | -0.3777 | -0.3777 | -0.3777 | -0.3777 |
| Tax Rate, % | -0.45204 | -0.45204 | -0.45204 | -0.45204 | -0.45204 | -0.45204 | -0.45204 | -0.45204 | -0.45204 | -0.45204 |
| EBITAT | 53.4 | 160.2 | -136.6 | -123.9 | 10.3 | 3.3 | 4.1 | 5.1 | 6.3 | 7.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 54.5 | 154.4 | 160.5 | 104.0 | 130.8 | 145.2 | 178.2 | 221.4 | 275.1 | 341.9 |
| WACC, % | 18.21 | 17.87 | 17.81 | 18.19 | 18.21 | 18.06 | 18.06 | 18.06 | 18.06 | 18.06 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 676.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 349 | |||||||||
| Terminal Value | 2,172 | |||||||||
| Present Terminal Value | 947 | |||||||||
| Enterprise Value | 1,623 | |||||||||
| Net Debt | 65 | |||||||||
| Equity Value | 1,558 | |||||||||
| Diluted Shares Outstanding, MM | 4 | |||||||||
| Equity Value Per Share | 381.13 |
What You Will Receive
- Pre-Filled Financial Model: Katapult Holdings, Inc. (KPLT) data provides accurate DCF valuation insights.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates allow you to see results instantly as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation purposes.
- Flexible and Reusable: Designed for adaptability, enabling frequent use for in-depth forecasts.
Key Features
- Real-Life KPLT Data: Pre-filled with Katapult Holdings’ historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Katapult Holdings, Inc. (KPLT) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Katapult Holdings, Inc. (KPLT)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator?
- Designed for Experts: An advanced tool tailored for analysts, CFOs, and financial consultants.
- Accurate Data: Katapult Holdings, Inc.'s (KPLT) historical and projected financials integrated for precision.
- Flexible Scenario Analysis: Effortlessly model various forecasts and assumptions.
- Comprehensive Results: Instantly computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Investors: Accurately assess Katapult Holdings, Inc.'s (KPLT) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial analysis and reporting related to Katapult Holdings, Inc. (KPLT).
- Consultants: Efficiently customize the template for valuation reports tailored to clients interested in Katapult Holdings, Inc. (KPLT).
- Entrepreneurs: Acquire insights into the financial modeling practices of successful companies like Katapult Holdings, Inc. (KPLT).
- Educators: Employ it as a teaching resource to illustrate valuation methodologies using Katapult Holdings, Inc. (KPLT) as a case study.
What the Template Contains
- Preloaded KPLT 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.