United States Cellular Corporation (USM) 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
United States Cellular Corporation (USM) Bundle
Looking to determine the intrinsic value of United States Cellular Corporation? Our USM DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your forecasts and enhance your investment decisions.
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 | 4,022.0 | 4,037.0 | 4,122.0 | 4,169.0 | 3,906.0 | 3,971.8 | 4,038.7 | 4,106.7 | 4,175.9 | 4,246.2 |
Revenue Growth, % | 0 | 0.37295 | 2.11 | 1.14 | -6.31 | 1.68 | 1.68 | 1.68 | 1.68 | 1.68 |
EBITDA | 1,106.0 | 1,149.0 | 1,132.0 | 1,031.0 | 1,056.0 | 1,073.9 | 1,092.0 | 1,110.4 | 1,129.1 | 1,148.1 |
EBITDA, % | 27.5 | 28.46 | 27.46 | 24.73 | 27.04 | 27.04 | 27.04 | 27.04 | 27.04 | 27.04 |
Depreciation | 811.0 | 787.0 | 777.0 | 796.0 | 749.0 | 768.8 | 781.7 | 794.9 | 808.3 | 821.9 |
Depreciation, % | 20.16 | 19.49 | 18.85 | 19.09 | 19.18 | 19.36 | 19.36 | 19.36 | 19.36 | 19.36 |
EBIT | 295.0 | 362.0 | 355.0 | 235.0 | 307.0 | 305.1 | 310.3 | 315.5 | 320.8 | 326.2 |
EBIT, % | 7.33 | 8.97 | 8.61 | 5.64 | 7.86 | 7.68 | 7.68 | 7.68 | 7.68 | 7.68 |
Total Cash | 285.0 | 1,274.0 | 156.0 | 273.0 | 150.0 | 419.6 | 426.6 | 433.8 | 441.1 | 448.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,056.0 | 1,123.0 | 1,169.0 | 1,076.0 | 958.0 | 1,054.7 | 1,072.4 | 1,090.5 | 1,108.9 | 1,127.5 |
Account Receivables, % | 26.26 | 27.82 | 28.36 | 25.81 | 24.53 | 26.55 | 26.55 | 26.55 | 26.55 | 26.55 |
Inventories | 162.0 | 146.0 | 173.0 | 261.0 | 199.0 | 184.3 | 187.4 | 190.5 | 193.7 | 197.0 |
Inventories, % | 4.03 | 3.62 | 4.2 | 6.26 | 5.09 | 4.64 | 4.64 | 4.64 | 4.64 | 4.64 |
Accounts Payable | 304.0 | 387.0 | 360.0 | 356.0 | 248.0 | 323.8 | 329.3 | 334.8 | 340.5 | 346.2 |
Accounts Payable, % | 7.56 | 9.59 | 8.73 | 8.54 | 6.35 | 8.15 | 8.15 | 8.15 | 8.15 | 8.15 |
Capital Expenditure | -916.0 | -1,190.0 | -2,046.0 | -1,187.0 | -738.0 | -1,185.6 | -1,205.6 | -1,225.9 | -1,246.5 | -1,267.5 |
Capital Expenditure, % | -22.77 | -29.48 | -49.64 | -28.47 | -18.89 | -29.85 | -29.85 | -29.85 | -29.85 | -29.85 |
Tax Rate, % | 51.35 | 51.35 | 51.35 | 51.35 | 51.35 | 51.35 | 51.35 | 51.35 | 51.35 | 51.35 |
EBITAT | 202.5 | 331.6 | 305.7 | 97.9 | 149.4 | 205.5 | 208.9 | 212.4 | 216.0 | 219.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -816.5 | -39.4 | -1,063.3 | -292.1 | 232.4 | -217.5 | -230.4 | -234.3 | -238.2 | -242.2 |
WACC, % | 5.26 | 5.73 | 5.61 | 4.7 | 4.85 | 5.23 | 5.23 | 5.23 | 5.23 | 5.23 |
PV UFCF | ||||||||||
SUM PV UFCF | -997.8 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -252 | |||||||||
Terminal Value | -20,499 | |||||||||
Present Terminal Value | -15,888 | |||||||||
Enterprise Value | -16,886 | |||||||||
Net Debt | 3,880 | |||||||||
Equity Value | -20,766 | |||||||||
Diluted Shares Outstanding, MM | 87 | |||||||||
Equity Value Per Share | -238.69 |
What You Will Get
- Real USM Financial Data: Pre-filled with United States Cellular Corporation’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See USM’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life USM Financials: Pre-filled historical and projected data for United States Cellular Corporation (USM).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate United States Cellular’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize United States Cellular’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-formatted Excel file containing United States Cellular Corporation’s (USM) financial data.
- Customize: Modify projections, including subscriber growth, EBITDA margin, and discount rate.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare different outcomes.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for United States Cellular Corporation (USM)?
- User-Friendly Interface: Tailored for both novices and seasoned analysts.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to USM's valuation as you modify inputs.
- Pre-Configured Data: Comes equipped with United States Cellular's actual financial figures for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed decisions.
Who Should Use This Product?
- Finance Students: Understand financial modeling and apply valuation methods using real data from United States Cellular Corporation (USM).
- Academics: Utilize industry-standard models in your teaching or research involving telecommunications.
- Investors: Evaluate your investment hypotheses and assess valuation results for United States Cellular Corporation (USM).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for United States Cellular Corporation (USM).
- Small Business Owners: Discover how major telecom companies like United States Cellular Corporation (USM) are evaluated in the market.
What the Template Contains
- Historical Data: Includes United States Cellular Corporation’s (USM) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate United States Cellular Corporation’s (USM) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of United States Cellular Corporation’s (USM) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.