Telos Corporation (TLS) 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
Telos Corporation (TLS) Bundle
Evaluate Telos Corporation's financial outlook with expertise! This (TLS) DCF Calculator provides pre-filled financial data and offers complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 159.2 | 179.9 | 242.4 | 216.9 | 145.4 | 146.9 | 148.5 | 150.0 | 151.6 | 153.2 |
Revenue Growth, % | 0 | 13 | 34.75 | -10.54 | -32.97 | 1.06 | 1.06 | 1.06 | 1.06 | 1.06 |
EBITDA | 10.2 | 19.4 | -36.8 | -46.6 | -24.2 | -10.6 | -10.7 | -10.8 | -10.9 | -11.1 |
EBITDA, % | 6.41 | 10.79 | -15.16 | -21.49 | -16.63 | -7.22 | -7.22 | -7.22 | -7.22 | -7.22 |
Depreciation | 5.0 | 5.4 | 5.6 | 5.9 | 9.4 | 5.2 | 5.2 | 5.3 | 5.3 | 5.4 |
Depreciation, % | 3.12 | 2.98 | 2.32 | 2.72 | 6.49 | 3.52 | 3.52 | 3.52 | 3.52 | 3.52 |
EBIT | 5.2 | 14.1 | -42.4 | -52.5 | -33.6 | -15.8 | -15.9 | -16.1 | -16.3 | -16.5 |
EBIT, % | 3.28 | 7.81 | -17.48 | -24.21 | -23.11 | -10.74 | -10.74 | -10.74 | -10.74 | -10.74 |
Total Cash | 6.8 | 106.0 | 126.6 | 119.3 | 99.3 | 70.1 | 70.9 | 71.6 | 72.4 | 73.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 27.9 | 30.9 | 59.8 | 40.1 | 30.4 | 29.0 | 29.3 | 29.7 | 30.0 | 30.3 |
Account Receivables, % | 17.55 | 17.18 | 24.68 | 18.47 | 20.93 | 19.76 | 19.76 | 19.76 | 19.76 | 19.76 |
Inventories | 2.0 | 3.3 | 1.2 | 2.9 | 1.4 | 1.7 | 1.7 | 1.8 | 1.8 | 1.8 |
Inventories, % | 1.23 | 1.84 | 0.51437 | 1.33 | 0.97676 | 1.18 | 1.18 | 1.18 | 1.18 | 1.18 |
Accounts Payable | 13.6 | 14.7 | 7.9 | 12.6 | 8.3 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 |
Accounts Payable, % | 8.54 | 8.15 | 3.25 | 5.81 | 5.71 | 6.29 | 6.29 | 6.29 | 6.29 | 6.29 |
Capital Expenditure | -6.5 | -7.5 | -13.2 | -13.7 | -15.5 | -9.0 | -9.1 | -9.2 | -9.3 | -9.4 |
Capital Expenditure, % | -4.1 | -4.15 | -5.43 | -6.32 | -10.65 | -6.13 | -6.13 | -6.13 | -6.13 | -6.13 |
Tax Rate, % | -0.10469 | -0.10469 | -0.10469 | -0.10469 | -0.10469 | -0.10469 | -0.10469 | -0.10469 | -0.10469 | -0.10469 |
EBITAT | 5.0 | 14.1 | -42.4 | -52.6 | -33.6 | -15.6 | -15.8 | -16.0 | -16.1 | -16.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -12.9 | 8.8 | -83.6 | -37.5 | -32.9 | -17.4 | -19.9 | -20.1 | -20.3 | -20.5 |
WACC, % | 8.82 | 8.84 | 8.84 | 8.84 | 8.84 | 8.83 | 8.83 | 8.83 | 8.83 | 8.83 |
PV UFCF | ||||||||||
SUM PV UFCF | -76.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -21 | |||||||||
Terminal Value | -306 | |||||||||
Present Terminal Value | -201 | |||||||||
Enterprise Value | -277 | |||||||||
Net Debt | -88 | |||||||||
Equity Value | -189 | |||||||||
Diluted Shares Outstanding, MM | 69 | |||||||||
Equity Value Per Share | -2.73 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to generate various scenarios for Telos Corporation (TLS).
- Real-World Data: Telos Corporation's financial data pre-filled to accelerate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and optimizing efficiency.
Key Features
- Comprehensive Data: Telos Corporation’s historical financial statements along with pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Calculations: Observe the intrinsic value of Telos Corporation (TLS) update instantly.
- Insightful Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- Download: Obtain the pre-configured Excel file containing Telos Corporation’s (TLS) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation findings to inform your investment approach.
Why Choose Telos Corporation (TLS) Calculator?
- All-in-One Solution: Combines DCF, WACC, and financial ratio evaluations into a single resource.
- Flexible Parameters: Modify the yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Telos Corporation’s intrinsic value and Net Present Value.
- Integrated Data: Features both historical and projected data for reliable analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions regarding investments in Telos Corporation (TLS).
- Financial Analysts: Enhance analysis efficiency with comprehensive financial models tailored for Telos Corporation (TLS).
- Consultants: Provide clients with accurate and timely valuation assessments of Telos Corporation (TLS).
- Business Owners: Learn from the valuation methods of Telos Corporation (TLS) to inform your own business strategies.
- Finance Students: Acquire practical knowledge of valuation techniques using real data from Telos Corporation (TLS).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Telos Corporation (TLS) 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 Telos Corporation (TLS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.