Nortech Systems Incorporated (NSYS) 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
Nortech Systems Incorporated (NSYS) Bundle
Optimize your time and improve precision with our (NSYS) DCF Calculator! Utilizing real data from Nortech Systems Incorporated and customizable assumptions, this tool enables you to forecast, analyze, and value (NSYS) like a seasoned investor.
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 | 116.3 | 104.1 | 115.2 | 134.1 | 139.3 | 146.5 | 153.9 | 161.8 | 170.1 | 178.8 |
Revenue Growth, % | 0 | -10.51 | 10.63 | 16.46 | 3.88 | 5.11 | 5.11 | 5.11 | 5.11 | 5.11 |
EBITDA | 2.4 | 1.6 | 5.0 | 3.9 | 8.0 | 4.9 | 5.1 | 5.4 | 5.6 | 5.9 |
EBITDA, % | 2.1 | 1.51 | 4.31 | 2.89 | 5.74 | 3.31 | 3.31 | 3.31 | 3.31 | 3.31 |
Depreciation | 2.2 | 2.2 | 2.0 | 1.9 | 2.1 | 2.5 | 2.7 | 2.8 | 2.9 | 3.1 |
Depreciation, % | 1.91 | 2.11 | 1.69 | 1.43 | 1.47 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 |
EBIT | .2 | -.6 | 3.0 | 2.0 | 6.0 | 2.3 | 2.4 | 2.6 | 2.7 | 2.8 |
EBIT, % | 0.19255 | -0.5917 | 2.62 | 1.46 | 4.27 | 1.59 | 1.59 | 1.59 | 1.59 | 1.59 |
Total Cash | .4 | .4 | .6 | 1.0 | 1.0 | .8 | .8 | .9 | .9 | .9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 26.2 | 21.5 | 28.5 | 28.6 | 33.8 | 33.2 | 34.9 | 36.7 | 38.6 | 40.6 |
Account Receivables, % | 22.54 | 20.68 | 24.71 | 21.33 | 24.23 | 22.7 | 22.7 | 22.7 | 22.7 | 22.7 |
Inventories | 14.3 | 13.9 | 19.4 | 22.4 | 21.7 | 21.9 | 23.0 | 24.2 | 25.4 | 26.7 |
Inventories, % | 12.27 | 13.37 | 16.87 | 16.73 | 15.55 | 14.96 | 14.96 | 14.96 | 14.96 | 14.96 |
Accounts Payable | 14.0 | 11.2 | 12.7 | 14.8 | 15.9 | 16.5 | 17.3 | 18.2 | 19.2 | 20.1 |
Accounts Payable, % | 12.05 | 10.8 | 11.04 | 11.03 | 11.43 | 11.27 | 11.27 | 11.27 | 11.27 | 11.27 |
Capital Expenditure | -.8 | -.5 | -1.4 | -2.4 | -1.3 | -1.5 | -1.6 | -1.6 | -1.7 | -1.8 |
Capital Expenditure, % | -0.65158 | -0.49853 | -1.18 | -1.82 | -0.92154 | -1.01 | -1.01 | -1.01 | -1.01 | -1.01 |
Tax Rate, % | -25.76 | -25.76 | -25.76 | -25.76 | -25.76 | -25.76 | -25.76 | -25.76 | -25.76 | -25.76 |
EBITAT | .3 | -.8 | 2.7 | 1.1 | 7.5 | 2.1 | 2.2 | 2.3 | 2.4 | 2.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -24.7 | 3.2 | -7.7 | -.5 | 5.0 | 4.0 | 1.3 | 1.4 | 1.4 | 1.5 |
WACC, % | 6.16 | 6.16 | 6.01 | 5.56 | 6.16 | 6.01 | 6.01 | 6.01 | 6.01 | 6.01 |
PV UFCF | ||||||||||
SUM PV UFCF | 8.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 2 | |||||||||
Terminal Value | 38 | |||||||||
Present Terminal Value | 29 | |||||||||
Enterprise Value | 37 | |||||||||
Net Debt | 13 | |||||||||
Equity Value | 24 | |||||||||
Diluted Shares Outstanding, MM | 3 | |||||||||
Equity Value Per Share | 8.27 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real NSYS financials.
- Real-World Data: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Nortech Systems' valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Nortech Systems Incorporated (NSYS).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Nortech Systems Incorporated (NSYS).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Nortech Systems Incorporated’s (NSYS) preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation results.
- 5. Present with Assurance: Showcase professional valuation insights to bolster your decision-making process.
Why Choose This Calculator for Nortech Systems Incorporated (NSYS)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust variables effortlessly to suit your financial analysis.
- Real-Time Valuation: Instantly observe changes in Nortech’s valuation as you modify inputs.
- Preloaded Data: Comes with Nortech's historical financial information for immediate evaluation.
- Relied Upon by Experts: Utilized by analysts and investors to support strategic decisions.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Nortech Systems Incorporated (NSYS) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to Nortech Systems Incorporated (NSYS).
- Consultants: Deliver professional valuation insights on Nortech Systems Incorporated (NSYS) to clients quickly and accurately.
- Business Owners: Understand how companies like Nortech Systems Incorporated (NSYS) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Nortech Systems Incorporated (NSYS).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Nortech Systems Incorporated (NSYS) 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 Nortech Systems Incorporated (NSYS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.