|
Valoración de DCF de IDT Corporation (IDT)
US | Communication Services | Telecommunications Services | NYSE
|
- ✓ 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
IDT Corporation (IDT) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora IDT DCF! Utilizando datos de Real IDT Corporation y supuestos personalizables, esta herramienta le permite pronosticar, analizar y valorar IDT (IDT) como un inversor experimentado.
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 | 1,345.8 | 1,447.0 | 1,364.1 | 1,238.9 | 1,205.8 | 1,175.5 | 1,145.9 | 1,117.1 | 1,089.0 | 1,061.6 |
Revenue Growth, % | 0 | 7.52 | -5.73 | -9.18 | -2.67 | -2.51 | -2.51 | -2.51 | -2.51 | -2.51 |
EBITDA | 38.1 | 83.0 | 53.0 | 80.9 | 82.3 | 60.7 | 59.1 | 57.7 | 56.2 | 54.8 |
EBITDA, % | 2.83 | 5.74 | 3.89 | 6.53 | 6.82 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 |
Depreciation | 20.4 | 17.8 | 18.1 | 20.1 | 20.4 | 17.4 | 16.9 | 16.5 | 16.1 | 15.7 |
Depreciation, % | 1.52 | 1.23 | 1.33 | 1.63 | 1.69 | 1.48 | 1.48 | 1.48 | 1.48 | 1.48 |
EBIT | 17.7 | 65.2 | 34.9 | 60.8 | 61.9 | 43.3 | 42.2 | 41.2 | 40.1 | 39.1 |
EBIT, % | 1.32 | 4.51 | 2.56 | 4.91 | 5.13 | 3.68 | 3.68 | 3.68 | 3.68 | 3.68 |
Total Cash | 109.2 | 163.6 | 137.7 | 152.2 | 193.0 | 135.9 | 132.5 | 129.2 | 125.9 | 122.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 44.2 | 46.6 | 64.3 | 32.1 | 42.2 | 40.7 | 39.7 | 38.7 | 37.7 | 36.8 |
Account Receivables, % | 3.28 | 3.22 | 4.71 | 2.59 | 3.5 | 3.46 | 3.46 | 3.46 | 3.46 | 3.46 |
Inventories | 149.5 | 161.1 | 129.8 | 141.9 | .0 | 101.6 | 99.0 | 96.5 | 94.1 | 91.8 |
Inventories, % | 11.11 | 11.13 | 9.52 | 11.46 | 0 | 8.64 | 8.64 | 8.64 | 8.64 | 8.64 |
Accounts Payable | 25.2 | 24.5 | 29.1 | 22.2 | 24.8 | 22.4 | 21.9 | 21.3 | 20.8 | 20.3 |
Accounts Payable, % | 1.87 | 1.69 | 2.13 | 1.79 | 2.05 | 1.91 | 1.91 | 1.91 | 1.91 | 1.91 |
Capital Expenditure | -16.0 | -16.8 | -21.9 | -22.0 | -18.9 | -17.2 | -16.7 | -16.3 | -15.9 | -15.5 |
Capital Expenditure, % | -1.19 | -1.16 | -1.6 | -1.77 | -1.57 | -1.46 | -1.46 | -1.46 | -1.46 | -1.46 |
Tax Rate, % | -4.11 | -4.11 | -4.11 | -4.11 | -4.11 | -4.11 | -4.11 | -4.11 | -4.11 | -4.11 |
EBITAT | 21.4 | 96.5 | 27.0 | 40.5 | 64.5 | 38.5 | 37.5 | 36.6 | 35.6 | 34.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -142.7 | 82.7 | 41.5 | 51.9 | 200.2 | -63.7 | 40.7 | 39.7 | 38.7 | 37.7 |
WACC, % | 8.1 | 8.1 | 8.1 | 8.1 | 8.1 | 8.1 | 8.1 | 8.1 | 8.1 | 8.1 |
PV UFCF | ||||||||||
SUM PV UFCF | 61.2 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 38 | |||||||||
Terminal Value | 499 | |||||||||
Present Terminal Value | 338 | |||||||||
Enterprise Value | 399 | |||||||||
Net Debt | -163 | |||||||||
Equity Value | 562 | |||||||||
Diluted Shares Outstanding, MM | 25 | |||||||||
Equity Value Per Share | 22.14 |
What You Will Get
- Editable Forecast Inputs: Adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: IDT Corporation’s financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that caters to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: IDT's historical financial statements and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Observe IDT's intrinsic value update instantly.
- Intuitive Visual Representations: Dashboard graphs showcase valuation outcomes and essential metrics.
- Engineered for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered IDT Corporation (IDT) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for IDT Corporation’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for IDT Corporation (IDT)?
- Accurate Data: Up-to-date IDT financials provide trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the IDT sector.
- User-Friendly: Easy-to-navigate design and clear instructions cater to users of all experience levels.
Who Should Use IDT Corporation (IDT)?
- Investors: Evaluate IDT’s market position before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methods and validate financial forecasts.
- Startup Founders: Understand the valuation strategies of established companies like IDT.
- Consultants: Provide comprehensive valuation insights and reports for clients.
- Students and Educators: Utilize real-world examples to learn and teach valuation principles.
What the Template Contains
- Pre-Filled DCF Model: IDT Corporation’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate IDT Corporation’s 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.