Telephone and Data Systems, Inc. (TDS) DCF Valuation

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

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 22.41 24.86 25.05 22.91 20.89
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.