TAT Technologies Ltd. (TATT) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
TAT Technologies Ltd. (TATT) Bundle
Whether you’re an investor or analyst, this TAT Technologies Ltd. (TATT) DCF Calculator is your go-to resource for accurate valuation. Preloaded with real data from TAT Technologies, you can adjust forecasts and instantly observe the effects.
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 | 102.0 | 75.4 | 78.0 | 84.6 | 113.8 | 114.6 | 115.5 | 116.3 | 117.2 | 118.1 |
Revenue Growth, % | 0 | -26.14 | 3.47 | 8.44 | 34.58 | 0.74232 | 0.74232 | 0.74232 | 0.74232 | 0.74232 |
EBITDA | 7.7 | .2 | 1.0 | 3.0 | 11.1 | 5.2 | 5.2 | 5.2 | 5.3 | 5.3 |
EBITDA, % | 7.59 | 0.32909 | 1.27 | 3.5 | 9.79 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 |
Depreciation | 4.3 | 4.1 | 4.9 | 3.7 | 4.7 | 5.6 | 5.6 | 5.7 | 5.7 | 5.8 |
Depreciation, % | 4.21 | 5.39 | 6.26 | 4.38 | 4.14 | 4.88 | 4.88 | 4.88 | 4.88 | 4.88 |
EBIT | 3.5 | -3.8 | -3.9 | -.7 | 6.4 | -.4 | -.4 | -.4 | -.4 | -.5 |
EBIT, % | 3.38 | -5.07 | -4.99 | -0.88226 | 5.65 | -0.38135 | -0.38135 | -0.38135 | -0.38135 | -0.38135 |
Total Cash | 16.0 | 24.1 | 12.9 | 7.7 | 16.6 | 20.2 | 20.3 | 20.5 | 20.6 | 20.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 20.3 | 11.4 | 13.9 | 15.6 | 20.0 | 20.4 | 20.5 | 20.7 | 20.8 | 21.0 |
Account Receivables, % | 19.91 | 15.07 | 17.81 | 18.48 | 17.58 | 17.77 | 17.77 | 17.77 | 17.77 | 17.77 |
Inventories | 43.9 | 41.2 | 41.0 | 45.8 | 51.3 | 57.2 | 57.6 | 58.1 | 58.5 | 58.9 |
Inventories, % | 43.03 | 54.7 | 52.59 | 54.12 | 45.06 | 49.9 | 49.9 | 49.9 | 49.9 | 49.9 |
Accounts Payable | 11.8 | 12.2 | 9.1 | 10.2 | 10.0 | 13.8 | 13.9 | 14.0 | 14.1 | 14.3 |
Accounts Payable, % | 11.59 | 16.22 | 11.66 | 12.1 | 8.78 | 12.07 | 12.07 | 12.07 | 12.07 | 12.07 |
Capital Expenditure | -3.4 | -5.4 | -16.8 | -16.2 | -5.6 | -12.9 | -13.0 | -13.1 | -13.2 | -13.3 |
Capital Expenditure, % | -3.34 | -7.17 | -21.55 | -19.17 | -4.9 | -11.23 | -11.23 | -11.23 | -11.23 | -11.23 |
Tax Rate, % | 1.54 | 1.54 | 1.54 | 1.54 | 1.54 | 1.54 | 1.54 | 1.54 | 1.54 | 1.54 |
EBITAT | 1.8 | -2.6 | -3.3 | -.8 | 6.3 | -.4 | -.4 | -.4 | -.4 | -.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -49.7 | 8.1 | -20.7 | -18.6 | -4.7 | -10.1 | -8.2 | -8.2 | -8.3 | -8.3 |
WACC, % | 7.99 | 8.09 | 8.19 | 8.28 | 8.28 | 8.17 | 8.17 | 8.17 | 8.17 | 8.17 |
PV UFCF | ||||||||||
SUM PV UFCF | -34.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -9 | |||||||||
Terminal Value | -138 | |||||||||
Present Terminal Value | -93 | |||||||||
Enterprise Value | -128 | |||||||||
Net Debt | 14 | |||||||||
Equity Value | -142 | |||||||||
Diluted Shares Outstanding, MM | 9 | |||||||||
Equity Value Per Share | -15.60 |
What You Will Get
- Real TAT Technologies Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for TAT Technologies Ltd. (TATT).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to TAT Technologies Ltd. (TATT).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on TAT Technologies Ltd. (TATT)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for TAT Technologies Ltd. (TATT).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for TAT Technologies Ltd. (TATT).
Key Features
- Comprehensive TATT Data: Pre-loaded with TAT Technologies Ltd.'s historical performance metrics and future projections.
- Customizable Financial Inputs: Modify revenue growth rates, profit margins, discount rates, tax assumptions, and capital investments.
- Interactive Valuation Framework: Automatically recalculates Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Designed to be straightforward and accessible for both seasoned professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered TAT Technologies Ltd. (TATT) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for TAT Technologies Ltd. (TATT)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for TAT Technologies Ltd. (TATT)?
- Designed for Experts: An advanced tool tailored for analysts, CFOs, and financial consultants.
- Comprehensive Data: TAT Technologies' historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance makes the process straightforward.
Who Should Use TAT Technologies Ltd. (TATT)?
- Professional Investors: Develop comprehensive and accurate valuation models for investment analysis.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Offer clients precise valuation insights for TAT Technologies Ltd. (TATT).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Aerospace and Defense Enthusiasts: Gain insights into how companies like TAT Technologies Ltd. (TATT) are valued in their respective sectors.
What the Template Contains
- Pre-Filled Data: Includes TAT Technologies Ltd.'s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze TAT Technologies Ltd.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.