|
Valoración de DCF de Kingsway Financial Services Inc. (KFS)
US | Consumer Cyclical | Auto - Dealerships | NYSE
|
- ✓ 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
Kingsway Financial Services Inc. (KFS) Bundle
Diseñada para la precisión, nuestra calculadora DCF (KFS) le permite evaluar la valoración de Kingsway Financial Services Inc. utilizando datos financieros del mundo real, ofreciendo flexibilidad completa para modificar todos los parámetros esenciales para mejorar las proyecciones.
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 | 63.2 | 65.7 | 94.8 | 114.7 | 103.2 | 118.5 | 136.1 | 156.2 | 179.3 | 205.9 |
Revenue Growth, % | 0 | 3.96 | 44.22 | 21.01 | -9.98 | 14.8 | 14.8 | 14.8 | 14.8 | 14.8 |
EBITDA | 3.4 | 14.1 | 3.2 | 30.1 | 5.9 | 14.8 | 17.0 | 19.5 | 22.4 | 25.7 |
EBITDA, % | 5.43 | 21.48 | 3.42 | 26.27 | 5.75 | 12.47 | 12.47 | 12.47 | 12.47 | 12.47 |
Depreciation | 66.2 | 57.4 | 84.8 | 91.6 | 6.2 | 86.0 | 98.7 | 113.3 | 130.1 | 149.3 |
Depreciation, % | 104.66 | 87.39 | 89.43 | 79.84 | 6.02 | 72.54 | 72.54 | 72.54 | 72.54 | 72.54 |
EBIT | -62.7 | -43.3 | -81.5 | -61.4 | -.3 | -72.3 | -83.0 | -95.3 | -109.4 | -125.6 |
EBIT, % | -99.23 | -65.91 | -86.02 | -53.57 | -0.27701 | -61 | -61 | -61 | -61 | -61 |
Total Cash | 13.6 | 14.5 | 12.8 | 64.3 | 9.3 | 29.0 | 33.3 | 38.2 | 43.8 | 50.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 17.4 | 20.3 | 20.6 | .0 | 10.1 | 21.3 | 24.4 | 28.1 | 32.2 | 37.0 |
Account Receivables, % | 27.55 | 30.82 | 21.69 | 0 | 9.77 | 17.96 | 17.96 | 17.96 | 17.96 | 17.96 |
Inventories | 43.8 | 66.1 | 39.2 | 88.9 | .0 | 68.3 | 78.4 | 90.0 | 103.3 | 118.6 |
Inventories, % | 69.27 | 100.6 | 41.36 | 77.5 | 0 | 57.63 | 57.63 | 57.63 | 57.63 | 57.63 |
Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Capital Expenditure | -.2 | -.2 | -.8 | 26.5 | -.2 | -.4 | -.5 | -.5 | -.6 | -.7 |
Capital Expenditure, % | -0.33537 | -0.32412 | -0.87576 | 23.07 | -0.19856 | -0.34676 | -0.34676 | -0.34676 | -0.34676 | -0.34676 |
Tax Rate, % | 0.38899 | 0.38899 | 0.38899 | 0.38899 | 0.38899 | 0.38899 | 0.38899 | 0.38899 | 0.38899 | 0.38899 |
EBITAT | -55.5 | -35.9 | 26.2 | -43.4 | -.3 | -49.4 | -56.7 | -65.1 | -74.8 | -85.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -50.7 | -3.9 | 136.8 | 45.4 | 84.5 | -43.4 | 28.2 | 32.4 | 37.2 | 42.7 |
WACC, % | 6.54 | 6.41 | 4.47 | 6.13 | 6.8 | 6.07 | 6.07 | 6.07 | 6.07 | 6.07 |
PV UFCF | ||||||||||
SUM PV UFCF | 72.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 44 | |||||||||
Terminal Value | 1,071 | |||||||||
Present Terminal Value | 797 | |||||||||
Enterprise Value | 870 | |||||||||
Net Debt | 37 | |||||||||
Equity Value | 833 | |||||||||
Diluted Shares Outstanding, MM | 26 | |||||||||
Equity Value Per Share | 31.51 |
What You Will Receive
- Comprehensive Financial Model: Kingsway Financial Services Inc. (KFS) data provides accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other essential parameters.
- Real-Time Calculations: Instant updates allow you to view results as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Adaptable and Reusable: Designed for versatility, enabling repeated application for thorough forecasts.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Kingsway Financial Services Inc. (KFS).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with inputs that can be customized to fit KFS's financials.
- Adjustable Forecast Assumptions: Easily modify growth projections, capital expenditures, and discount rates specific to Kingsway Financial Services Inc. (KFS).
- Integrated Financial Ratios: Assess profitability, leverage, and efficiency ratios relevant to Kingsway Financial Services Inc. (KFS).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for Kingsway Financial Services Inc. (KFS) for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Kingsway Financial Services Inc. (KFS) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Kingsway Financial Services Inc. (KFS)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Kingsway Financial Services Inc. (KFS)?
- Streamlined Process: Skip the hassle of building financial models from the ground up – our tools are ready for immediate use.
- Enhanced Accuracy: Dependable financial insights and calculations minimize valuation errors.
- Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
- User-Friendly Design: Intuitive charts and outputs facilitate straightforward analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize accuracy and functionality.
Who Should Use Kingsway Financial Services Inc. (KFS)?
- Individual Investors: Gain insights to make educated decisions regarding investments in Kingsway Financial Services Inc. (KFS).
- Financial Analysts: Enhance analysis efficiency with comprehensive financial models tailored for Kingsway Financial Services Inc. (KFS).
- Consultants: Provide clients with precise and timely valuation assessments for Kingsway Financial Services Inc. (KFS).
- Business Owners: Learn from the valuation strategies of Kingsway Financial Services Inc. (KFS) to inform your own business approaches.
- Finance Students: Explore practical valuation methodologies using real data from Kingsway Financial Services Inc. (KFS).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Kingsway Financial Services Inc. (KFS) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Kingsway Financial Services Inc. (KFS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.