T-Mobile US, Inc. (TMUS) DCF Valuation

T-Mobile US, Inc. (TMUS) 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

T-Mobile US, Inc. (TMUS) 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:

Whether you’re an investor or analyst, this T-Mobile US, Inc. (TMUS) DCF Calculator is your go-to tool for accurate valuation. Featuring real data from T-Mobile, you can adjust forecasts and instantly observe the effects.


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 44,998.0 68,397.0 80,118.0 79,571.0 78,558.0 91,752.0 107,162.0 125,160.1 146,181.1 170,732.5
Revenue Growth, % 0 52 17.14 -0.68274 -1.27 16.8 16.8 16.8 16.8 16.8
EBITDA 12,354.0 23,578.0 26,382.0 27,133.0 26,933.0 29,955.0 34,986.0 40,862.0 47,724.9 55,740.4
EBITDA, % 27.45 34.47 32.93 34.1 34.28 32.65 32.65 32.65 32.65 32.65
Depreciation 6,616.0 14,151.0 16,383.0 13,651.0 12,818.0 16,389.4 19,142.0 22,356.9 26,111.8 30,497.4
Depreciation, % 14.7 20.69 20.45 17.16 16.32 17.86 17.86 17.86 17.86 17.86
EBIT 5,738.0 9,427.0 9,999.0 13,482.0 14,115.0 13,565.7 15,844.1 18,505.1 21,613.1 25,243.1
EBIT, % 12.75 13.78 12.48 16.94 17.97 14.79 14.79 14.79 14.79 14.79
Total Cash 1,528.0 10,385.0 6,631.0 4,507.0 5,135.0 7,167.0 8,370.7 9,776.6 11,418.6 13,336.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 4,558.0 8,057.0 9,228.0 9,924.0 9,643.0
Account Receivables, % 10.13 11.78 11.52 12.47 12.28
Inventories 964.0 2,527.0 2,567.0 1,884.0 1,678.0 2,485.5 2,902.9 3,390.5 3,959.9 4,625.0
Inventories, % 2.14 3.69 3.2 2.37 2.14 2.71 2.71 2.71 2.71 2.71
Accounts Payable 4,322.0 5,564.0 6,499.0 7,213.0 5,573.0 7,709.1 9,003.9 10,516.1 12,282.3 14,345.1
Accounts Payable, % 9.6 8.13 8.11 9.06 7.09 8.4 8.4 8.4 8.4 8.4
Capital Expenditure -7,358.0 -12,367.0 -21,692.0 -17,301.0 -10,811.0 -17,802.2 -20,792.2 -24,284.3 -28,362.9 -33,126.5
Capital Expenditure, % -16.35 -18.08 -27.08 -21.74 -13.76 -19.4 -19.4 -19.4 -19.4 -19.4
Tax Rate, % 24.38 24.38 24.38 24.38 24.38 24.38 24.38 24.38 24.38 24.38
EBITAT 4,323.1 8,182.5 9,023.3 11,099.3 10,673.2 11,132.7 13,002.4 15,186.2 17,736.8 20,715.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 2,381.1 6,146.5 3,438.3 8,150.3 11,527.2 10,016.2 10,436.7 12,189.5 14,236.8 16,627.9
WACC, % 5.77 5.92 5.97 5.86 5.77 5.86 5.86 5.86 5.86 5.86
PV UFCF
SUM PV UFCF 52,896.4
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 17,293
Terminal Value 930,331
Present Terminal Value 699,846
Enterprise Value 752,743
Net Debt 107,951
Equity Value 644,792
Diluted Shares Outstanding, MM 1,200
Equity Value Per Share 537.20

What You Will Receive

  • Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled real TMUS financial data.
  • Accurate Market Data: Historical performance metrics and forward-looking projections (highlighted in the yellow cells).
  • Adaptive Forecasting: Modify key assumptions such as revenue growth, EBITDA %, and WACC as needed.
  • Instant Calculations: Quickly observe how your inputs influence T-Mobile’s valuation.
  • Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
  • Intuitive Layout: Organized for simplicity and usability, complete with step-by-step guidance.

Key Features

  • Comprehensive T-Mobile Financials: Gain access to precise pre-loaded historical data and future forecasts.
  • Adjustable Forecast Parameters: Modify highlighted cells such as WACC, growth rates, and profit margins.
  • Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow analyses.
  • Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
  • Suitable for All Skill Levels: An intuitive layout designed for investors, CFOs, and consultants alike.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based TMUS DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
  3. Instant Calculations: The model automatically recalculates T-Mobile’s intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to see how they affect the valuation.
  5. Analyze and Decide: Utilize the results to inform your investment or financial strategies.

Why Choose This Calculator for T-Mobile US, Inc. (TMUS)?

  • Designed for Industry Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
  • Accurate Financial Data: T-Mobile's historical and projected financials are preloaded for precision.
  • Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Comprehensive Outputs: Automatically calculates intrinsic value, NPV, and essential financial metrics.
  • User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.

Who Should Use This Product?

  • Professional Investors: Create comprehensive and accurate valuation models for portfolio management related to T-Mobile US, Inc. (TMUS).
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
  • Consultants and Advisors: Deliver precise valuation insights to clients interested in T-Mobile US, Inc. (TMUS) stock.
  • Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
  • Telecom Enthusiasts: Gain insights into how telecommunications companies like T-Mobile US, Inc. (TMUS) are valued in the financial markets.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled T-Mobile US, Inc. (TMUS) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
  • Key Ratios: Incorporates profitability, leverage, and efficiency ratios for T-Mobile US, Inc. (TMUS).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.

No products were found matching.