Telephone and Data Systems, Inc. (TDS) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Telephone and Data Systems, Inc. (TDS) Bundle
Evaluate the financial prospects of Telephone and Data Systems, Inc. (TDS) with expert precision! This (TDS) DCF Calculator comes pre-loaded with financial data and offers you the 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 | 5,176.0 | 5,225.0 | 5,329.0 | 5,413.0 | 5,160.0 | 5,226.3 | 5,293.4 | 5,361.5 | 5,430.3 | 5,500.1 |
Revenue Growth, % | 0 | 0.94668 | 1.99 | 1.58 | -4.67 | 1.28 | 1.28 | 1.28 | 1.28 | 1.28 |
EBITDA | 1,122.0 | 1,190.0 | 1,180.0 | 1,080.0 | 682.0 | 1,042.8 | 1,056.2 | 1,069.8 | 1,083.5 | 1,097.4 |
EBITDA, % | 21.68 | 22.78 | 22.14 | 19.95 | 13.22 | 19.95 | 19.95 | 19.95 | 19.95 | 19.95 |
Depreciation | 932.0 | 909.0 | 895.0 | 929.0 | 915.0 | 910.3 | 922.0 | 933.9 | 945.9 | 958.0 |
Depreciation, % | 18.01 | 17.4 | 16.79 | 17.16 | 17.73 | 17.42 | 17.42 | 17.42 | 17.42 | 17.42 |
EBIT | 190.0 | 281.0 | 285.0 | 151.0 | -233.0 | 132.4 | 134.1 | 135.9 | 137.6 | 139.4 |
EBIT, % | 3.67 | 5.38 | 5.35 | 2.79 | -4.52 | 2.53 | 2.53 | 2.53 | 2.53 | 2.53 |
Total Cash | 465.0 | 1,432.0 | 367.0 | 360.0 | 236.0 | 569.7 | 577.0 | 584.4 | 591.9 | 599.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,160.0 | 1,299.0 | 1,335.0 | 1,240.0 | 1,078.0 | 1,213.8 | 1,229.4 | 1,245.2 | 1,261.2 | 1,277.4 |
Account Receivables, % | 22.41 | 24.86 | 25.05 | 22.91 | 20.89 | 23.22 | 23.22 | 23.22 | 23.22 | 23.22 |
Inventories | 169.0 | 154.0 | 178.0 | 268.0 | 208.0 | 193.7 | 196.2 | 198.7 | 201.3 | 203.9 |
Inventories, % | 3.27 | 2.95 | 3.34 | 4.95 | 4.03 | 3.71 | 3.71 | 3.71 | 3.71 | 3.71 |
Accounts Payable | 374.0 | 508.0 | 481.0 | 506.0 | 360.0 | 442.1 | 447.8 | 453.6 | 459.4 | 465.3 |
Accounts Payable, % | 7.23 | 9.72 | 9.03 | 9.35 | 6.98 | 8.46 | 8.46 | 8.46 | 8.46 | 8.46 |
Capital Expenditure | -957.0 | -1,368.0 | -1,151.0 | -1,775.0 | -1,341.0 | -1,307.1 | -1,323.9 | -1,340.9 | -1,358.1 | -1,375.6 |
Capital Expenditure, % | -18.49 | -26.18 | -21.6 | -32.79 | -25.99 | -25.01 | -25.01 | -25.01 | -25.01 | -25.01 |
Tax Rate, % | -4.82 | -4.82 | -4.82 | -4.82 | -4.82 | -4.82 | -4.82 | -4.82 | -4.82 | -4.82 |
EBITAT | 109.0 | 220.5 | 201.2 | 74.9 | -244.2 | 94.3 | 95.5 | 96.7 | 98.0 | 99.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -871.0 | -228.5 | -141.8 | -741.1 | -594.2 | -341.8 | -318.7 | -322.8 | -327.0 | -331.2 |
WACC, % | 5.07 | 5.64 | 5.43 | 4.86 | 6.22 | 5.45 | 5.45 | 5.45 | 5.45 | 5.45 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,404.7 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -344 | |||||||||
Terminal Value | -23,831 | |||||||||
Present Terminal Value | -18,282 | |||||||||
Enterprise Value | -19,686 | |||||||||
Net Debt | 4,907 | |||||||||
Equity Value | -24,593 | |||||||||
Diluted Shares Outstanding, MM | 113 | |||||||||
Equity Value Per Share | -217.64 |
What You Will Get
- Real TDS Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Explore various scenarios to assess TDS’s future performance.
- User-Friendly Interface: Designed for professionals while remaining easy to use for beginners.
Key Features
- Comprehensive DCF Calculator: Offers both unlevered and levered DCF valuation models tailored for Telephone and Data Systems, Inc. (TDS).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital template with adjustable parameters.
- 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 Telephone and Data Systems, Inc. (TDS).
- Interactive Dashboard and Charts: Visual representations that encapsulate key valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file containing TDS's preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results in Real-Time: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate multiple forecasts to assess various valuation outcomes.
- 5. Present with Assurance: Deliver professional valuation insights to back your strategic decisions.
Why Choose This Calculator for Telephone and Data Systems, Inc. (TDS)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your analytical needs.
- Real-Time Feedback: Observe immediate updates to TDS’s valuation as you tweak the inputs.
- Pre-Loaded Data: Comes equipped with TDS’s actual financial figures for swift evaluations.
- Preferred by Experts: Utilized by investors and analysts to drive informed investment choices.
Who Should Use This Product?
- Investors: Accurately assess Telephone and Data Systems, Inc. (TDS)'s fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to TDS.
- Consultants: Easily modify the template for valuation reports tailored to TDS clients.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading telecommunications firms.
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to TDS.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Telephone and Data Systems, Inc. (TDS) 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 Telephone and Data Systems, Inc. (TDS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.