Standex International Corporation (SXI) 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
Standex International Corporation (SXI) Bundle
Discover the true value of Standex International Corporation (SXI) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how changes affect Standex International Corporation (SXI) valuation – all within a single Excel template.
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 | 604.5 | 656.2 | 735.3 | 741.0 | 720.6 | 754.2 | 789.3 | 826.1 | 864.5 | 904.8 |
Revenue Growth, % | 0 | 8.55 | 12.05 | 0.77638 | -2.75 | 4.66 | 4.66 | 4.66 | 4.66 | 4.66 |
EBITDA | 99.3 | 92.0 | 116.6 | 191.5 | 121.9 | 134.3 | 140.6 | 147.1 | 154.0 | 161.1 |
EBITDA, % | 16.42 | 14.02 | 15.86 | 25.84 | 16.92 | 17.81 | 17.81 | 17.81 | 17.81 | 17.81 |
Depreciation | 32.3 | 31.0 | 27.5 | 26.8 | 26.8 | 31.9 | 33.4 | 34.9 | 36.6 | 38.3 |
Depreciation, % | 5.34 | 4.72 | 3.74 | 3.62 | 3.72 | 4.23 | 4.23 | 4.23 | 4.23 | 4.23 |
EBIT | 67.0 | 61.0 | 89.1 | 164.7 | 95.1 | 102.4 | 107.2 | 112.2 | 117.4 | 122.9 |
EBIT, % | 11.08 | 9.29 | 12.12 | 22.22 | 13.2 | 13.58 | 13.58 | 13.58 | 13.58 | 13.58 |
Total Cash | 118.8 | 136.4 | 104.8 | 195.7 | 154.2 | 154.6 | 161.8 | 169.3 | 177.2 | 185.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 107.3 | 124.9 | 141.8 | 155.4 | 166.8 | 151.1 | 158.1 | 165.5 | 173.2 | 181.3 |
Account Receivables, % | 17.75 | 19.03 | 19.28 | 20.97 | 23.14 | 20.03 | 20.03 | 20.03 | 20.03 | 20.03 |
Inventories | 85.0 | 91.9 | 105.3 | 98.5 | 87.1 | 102.2 | 107.0 | 112.0 | 117.2 | 122.6 |
Inventories, % | 14.07 | 14 | 14.33 | 13.3 | 12.09 | 13.55 | 13.55 | 13.55 | 13.55 | 13.55 |
Accounts Payable | 54.9 | 74.8 | 74.5 | 68.6 | 63.4 | 73.4 | 76.8 | 80.4 | 84.1 | 88.1 |
Accounts Payable, % | 9.08 | 11.39 | 10.13 | 9.26 | 8.79 | 9.73 | 9.73 | 9.73 | 9.73 | 9.73 |
Capital Expenditure | -21.5 | -21.8 | -23.9 | -24.3 | -20.3 | -24.5 | -25.6 | -26.8 | -28.0 | -29.3 |
Capital Expenditure, % | -3.56 | -3.31 | -3.25 | -3.28 | -2.82 | -3.24 | -3.24 | -3.24 | -3.24 | -3.24 |
Tax Rate, % | 23.18 | 23.18 | 23.18 | 23.18 | 23.18 | 23.18 | 23.18 | 23.18 | 23.18 | 23.18 |
EBITAT | 50.8 | 42.2 | 67.3 | 139.6 | 73.1 | 78.3 | 81.9 | 85.8 | 89.7 | 93.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -75.9 | 46.9 | 40.4 | 129.3 | 74.4 | 96.3 | 81.3 | 85.1 | 89.1 | 93.2 |
WACC, % | 8.84 | 8.81 | 8.84 | 8.87 | 8.84 | 8.84 | 8.84 | 8.84 | 8.84 | 8.84 |
PV UFCF | ||||||||||
SUM PV UFCF | 347.7 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 96 | |||||||||
Terminal Value | 1,645 | |||||||||
Present Terminal Value | 1,077 | |||||||||
Enterprise Value | 1,425 | |||||||||
Net Debt | 34 | |||||||||
Equity Value | 1,391 | |||||||||
Diluted Shares Outstanding, MM | 12 | |||||||||
Equity Value Per Share | 116.84 |
What You Will Receive
- Comprehensive Financial Model: Standex International Corporation’s (SXI) actual data provides an accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other critical parameters.
- Real-Time Calculations: Automatic updates allow you to view results instantly as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation needs.
- Adaptable and Repeatable: Designed for versatility, enabling ongoing use for in-depth forecasts.
Key Features
- Comprehensive SXI Data: Pre-filled with Standex International Corporation’s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth rates, margins, WACC, tax rates, and capital expenditures to suit your analysis.
- Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Testing: Develop multiple forecasting scenarios to evaluate various valuation outcomes.
- User-Friendly Design: Intuitive, organized, and tailored for both professionals and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based SXI DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh to reflect Standex International'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 Standex International Corporation (SXI)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Financial Data: Standex’s historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth user experience.
Who Should Use Standex International Corporation (SXI)?
- Investors: Gain insights into diverse sectors with a reliable investment analysis platform.
- Financial Analysts: Streamline your workflow with comprehensive financial models tailored for (SXI).
- Consultants: Efficiently modify templates for client engagements or strategic assessments involving (SXI).
- Finance Enthusiasts: Explore investment strategies and market trends related to (SXI) for a richer understanding.
- Educators and Students: Utilize (SXI) as a case study for hands-on learning in finance and investment courses.
What the Template Contains
- Preloaded SXI 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.