|
Valoración de DCF de Kewaunee Scientific Corporation (Kequ)
US | Consumer Cyclical | Furnishings, Fixtures & Appliances | 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
Kewaunee Scientific Corporation (KEQU) Bundle
¡Simplifique la valoración de Kewaunee Scientific Corporation (KQU) con esta calculadora DCF personalizable! Con el Real Kewaunee Scientific Corporation (Kequ) Financials y los aportes de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Kewaunee Scientific Corporation (KQU) en minutos.
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 | 147.5 | 147.5 | 168.9 | 219.5 | 203.8 | 222.7 | 243.5 | 266.2 | 291.0 | 318.1 |
| Revenue Growth, % | 0 | -0.04812254 | 14.51 | 29.98 | -7.17 | 9.32 | 9.32 | 9.32 | 9.32 | 9.32 |
| EBITDA | .3 | .5 | .9 | 8.2 | 18.0 | 6.1 | 6.6 | 7.2 | 7.9 | 8.7 |
| EBITDA, % | 0.19046 | 0.31125 | 0.54242 | 3.72 | 8.86 | 2.72 | 2.72 | 2.72 | 2.72 | 2.72 |
| Depreciation | 2.7 | 2.7 | 2.8 | 2.9 | 3.1 | 3.6 | 3.9 | 4.3 | 4.7 | 5.2 |
| Depreciation, % | 1.8 | 1.82 | 1.64 | 1.31 | 1.53 | 1.62 | 1.62 | 1.62 | 1.62 | 1.62 |
| EBIT | -2.4 | -2.2 | -1.9 | 5.3 | 14.9 | 2.5 | 2.7 | 2.9 | 3.2 | 3.5 |
| EBIT, % | -1.61 | -1.51 | -1.1 | 2.41 | 7.32 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
| Total Cash | 4.4 | 5.2 | 4.4 | 8.1 | 23.3 | 10.8 | 11.8 | 12.9 | 14.1 | 15.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 28.1 | 32.9 | 54.7 | 46.1 | 45.1 | 52.0 | 56.9 | 62.2 | 68.0 | 74.3 |
| Account Receivables, % | 19.02 | 22.3 | 32.4 | 20.99 | 22.12 | 23.37 | 23.37 | 23.37 | 23.37 | 23.37 |
| Inventories | 15.3 | 16.5 | 23.8 | 21.9 | 20.7 | 24.9 | 27.2 | 29.7 | 32.5 | 35.5 |
| Inventories, % | 10.39 | 11.2 | 14.09 | 9.97 | 10.15 | 11.16 | 11.16 | 11.16 | 11.16 | 11.16 |
| Accounts Payable | 13.1 | 16.8 | 27.3 | 23.6 | 23.3 | 26.1 | 28.5 | 31.2 | 34.1 | 37.3 |
| Accounts Payable, % | 8.89 | 11.38 | 16.18 | 10.75 | 11.42 | 11.72 | 11.72 | 11.72 | 11.72 | 11.72 |
| Capital Expenditure | -2.5 | -2.4 | -1.9 | -4.1 | -4.4 | -3.8 | -4.1 | -4.5 | -4.9 | -5.4 |
| Capital Expenditure, % | -1.67 | -1.63 | -1.13 | -1.89 | -2.15 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 |
| Tax Rate, % | -42.95 | -42.95 | -42.95 | -42.95 | -42.95 | -42.95 | -42.95 | -42.95 | -42.95 | -42.95 |
| EBITAT | -3.8 | -3.1 | -4.5 | 1.6 | 21.3 | 2.1 | 2.3 | 2.5 | 2.8 | 3.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -33.9 | -5.1 | -22.2 | 7.1 | 22.0 | -6.4 | -2.6 | -2.8 | -3.1 | -3.4 |
| WACC, % | 8.39 | 8.39 | 8.39 | 7.75 | 8.39 | 8.26 | 8.26 | 8.26 | 8.26 | 8.26 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -14.9 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | -3 | |||||||||
| Terminal Value | -44 | |||||||||
| Present Terminal Value | -30 | |||||||||
| Enterprise Value | -44 | |||||||||
| Net Debt | -12 | |||||||||
| Equity Value | -32 | |||||||||
| Diluted Shares Outstanding, MM | 3 | |||||||||
| Equity Value Per Share | -10.94 |
What You Will Get
- Comprehensive KEQU Financials: Access both historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Kewaunee's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Financial Data: Gain access to precise historical figures and future forecasts for Kewaunee Scientific Corporation (KEQU).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries designed to help visualize your valuation outcomes.
- Suitable for All Experience Levels: A straightforward, user-centric layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based KEQU DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional factors.
- Instant Calculations: The model automatically recalculates Kewaunee Scientific Corporation's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the findings to inform your investment or financial strategy.
Why Choose This Calculator for Kewaunee Scientific Corporation (KEQU)?
- All-in-One Tool: Combines DCF, WACC, and financial ratio analyses tailored for Kewaunee Scientific Corporation.
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios for (KEQU).
- In-Depth Analysis: Automatically computes Kewaunee's intrinsic value and Net Present Value.
- Preloaded Information: Access historical and projected data for precise calculations.
- Expert-Level Quality: Perfect for financial analysts, investors, and business advisors focusing on (KEQU).
Who Should Use Kewaunee Scientific Corporation (KEQU)?
- Individual Investors: Gain insights to make informed decisions about investing in Kewaunee Scientific Corporation (KEQU) stock.
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for Kewaunee Scientific Corporation (KEQU).
- Consultants: Provide clients with accurate and timely valuation insights related to Kewaunee Scientific Corporation (KEQU).
- Business Owners: Learn how companies like Kewaunee Scientific Corporation (KEQU) are valued to inform your own business strategies.
- Finance Students: Explore real-world valuation techniques using data and scenarios from Kewaunee Scientific Corporation (KEQU).
What the Template Contains
- Pre-Filled DCF Model: Kewaunee Scientific Corporation’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Kewaunee’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.