Taylor Devices, Inc. (TAYD) 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
Taylor Devices, Inc. (TAYD) Bundle
Evaluate Taylor Devices, Inc.'s (TAYD) financial future like an expert! This (TAYD) DCF Calculator provides pre-filled financials and total flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 28.4 | 22.5 | 30.9 | 40.2 | 44.6 | 51.0 | 58.3 | 66.7 | 76.3 | 87.3 |
Revenue Growth, % | 0 | -20.69 | 37.13 | 30.24 | 10.9 | 14.39 | 14.39 | 14.39 | 14.39 | 14.39 |
EBITDA | 4.4 | .4 | 3.8 | 8.3 | 11.2 | 7.7 | 8.8 | 10.1 | 11.5 | 13.2 |
EBITDA, % | 15.66 | 1.65 | 12.38 | 20.6 | 25.07 | 15.07 | 15.07 | 15.07 | 15.07 | 15.07 |
Depreciation | 1.1 | 1.2 | 1.3 | 1.5 | 1.7 | 2.2 | 2.5 | 2.8 | 3.2 | 3.7 |
Depreciation, % | 4.02 | 5.39 | 4.37 | 3.66 | 3.81 | 4.25 | 4.25 | 4.25 | 4.25 | 4.25 |
EBIT | 3.3 | -.8 | 2.5 | 6.8 | 9.5 | 5.5 | 6.3 | 7.2 | 8.3 | 9.5 |
EBIT, % | 11.64 | -3.74 | 8.01 | 16.94 | 21.26 | 10.82 | 10.82 | 10.82 | 10.82 | 10.82 |
Total Cash | 16.2 | 21.7 | 23.6 | 28.1 | 31.0 | 37.7 | 43.1 | 49.3 | 56.4 | 64.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 7.6 | 5.6 | 7.8 | 9.7 | 9.6 | 12.5 | 14.3 | 16.3 | 18.7 | 21.4 |
Account Receivables, % | 26.69 | 24.97 | 25.28 | 24.07 | 21.46 | 24.49 | 24.49 | 24.49 | 24.49 | 24.49 |
Inventories | 10.1 | 5.8 | 5.9 | 5.9 | 7.5 | 11.4 | 13.1 | 15.0 | 17.1 | 19.6 |
Inventories, % | 35.61 | 25.92 | 18.97 | 14.78 | 16.85 | 22.43 | 22.43 | 22.43 | 22.43 | 22.43 |
Accounts Payable | 1.4 | 1.8 | 1.4 | 1.7 | 1.4 | 2.5 | 2.9 | 3.3 | 3.8 | 4.3 |
Accounts Payable, % | 4.83 | 7.94 | 4.62 | 4.27 | 3.23 | 4.98 | 4.98 | 4.98 | 4.98 | 4.98 |
Capital Expenditure | -1.2 | -1.6 | -1.4 | -3.4 | -1.4 | -2.8 | -3.2 | -3.7 | -4.2 | -4.8 |
Capital Expenditure, % | -4.34 | -7.2 | -4.51 | -8.36 | -3.25 | -5.53 | -5.53 | -5.53 | -5.53 | -5.53 |
Tax Rate, % | 17.6 | 17.6 | 17.6 | 17.6 | 17.6 | 17.6 | 17.6 | 17.6 | 17.6 | 17.6 |
EBITAT | 2.9 | -1.3 | 2.2 | 5.7 | 7.8 | 4.9 | 5.6 | 6.4 | 7.3 | 8.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -13.5 | 4.9 | -.4 | 2.1 | 6.3 | -1.5 | 1.8 | 2.0 | 2.3 | 2.6 |
WACC, % | 9.36 | 9.36 | 9.36 | 9.36 | 9.36 | 9.36 | 9.36 | 9.36 | 9.36 | 9.36 |
PV UFCF | ||||||||||
SUM PV UFCF | 4.9 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 3 | |||||||||
Terminal Value | 30 | |||||||||
Present Terminal Value | 19 | |||||||||
Enterprise Value | 24 | |||||||||
Net Debt | -3 | |||||||||
Equity Value | 27 | |||||||||
Diluted Shares Outstanding, MM | 3 | |||||||||
Equity Value Per Share | 7.70 |
What You Will Gain
- Adjustable Forecast Inputs: Effortlessly modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Data: Taylor Devices, Inc.'s (TAYD) financial information pre-loaded to enhance your analysis.
- Automated DCF Calculations: The template provides Net Present Value (NPV) and intrinsic value calculations automatically.
- Tailored and Professional: A refined Excel model designed to meet your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and optimizing efficiency.
Key Features
- Comprehensive TAYD Data: Pre-filled with Taylor Devices' historical performance metrics and future growth estimates.
- Customizable Assumptions: Modify revenue growth rates, profit margins, discount rates, tax percentages, and capital investment plans.
- Adaptive Valuation Framework: Instant updates to Net Present Value (NPV) and intrinsic value based on your specified parameters.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive Interface: Clean, organized design suitable for both industry experts and novices.
How It Works
- Download the Template: Gain immediate access to the Excel-based TAYD DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically calculates the intrinsic value of Taylor Devices, Inc. (TAYD).
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Taylor Devices, Inc. (TAYD)?
- Designed for Experts: A sophisticated tool utilized by engineers, financial analysts, and project managers.
- Accurate Data: Taylor Devices’ historical and projected financials preloaded for precision.
- Versatile Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance to ensure a smooth experience.
Who Should Use Taylor Devices, Inc. (TAYD)?
- Investors: Gain insights into the performance of a leading manufacturer of shock and vibration control products.
- Financial Analysts: Utilize detailed financial reports to enhance your market analysis.
- Consultants: Leverage industry-specific data for tailored client solutions and recommendations.
- Engineering Professionals: Explore innovative technologies and applications in vibration control systems.
- Students and Educators: Engage with real-world case studies in mechanical engineering and finance courses.
What the Template Contains
- Pre-Filled DCF Model: Taylor Devices, Inc.'s (TAYD) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Taylor Devices, Inc.'s (TAYD) 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.