Discounted Cash Flow (DCF) Analysis Unlevered

United States Cellular Corporation ... (UZC)

$25.06

-0.01 (-0.04%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 25.06 | undervalue

Operating Data

Year
A/P
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
Revenue 3,996.853,9393,8903,9674,0224,028.784,035.574,042.384,049.194,056.02
Revenue (%)
EBITDA 483.88194-162957991496.59497.43498.27499.11499.95
EBITDA (%)
EBIT ----------
EBIT (%)
Depreciation ----------
Depreciation (%)

Balance Sheet Data

Year
A/P
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
Total Cash 860.19739402597472623.67624.72625.77626.83627.88
Total Cash (%)
Account Receivables 608.20658775908919786.28787.61788.93790.26791.60
Account Receivables (%)
Inventories 149.31138138142162148.21148.46148.71148.96149.21
Inventories (%)
Accounts Payable 274.81309302304296302.21302.72303.23303.74304.25
Accounts Payable (%)
Capital Expenditure ----------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 25.06
Beta 0.237
Diluted Shares Outstanding 88
Cost of Debt
Tax Rate 31.35
After-tax Cost of Debt 5.00%
Risk-Free Rate
Market Risk Premium
Cost of Equity 4.090
Total Debt 1,510
Total Equity 2,205.28
Total Capital 3,715.28
Debt Weighting 40.64
Equity Weighting 59.36
Wacc

Build Up Free Cash

Year
A/P
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
Revenue 3,996.853,9393,8903,9674,0224,028.784,035.574,042.384,049.194,056.02
EBITDA 483.88194-162957991496.59497.43498.27499.11499.95
EBIT ----------
Tax Rate 40.21%41.46%104.41%30.23%31.35%49.53%49.53%49.53%49.53%49.53%
EBIAT ----------
Depreciation ----------
Accounts Receivable --49.80-117-133-11132.72-1.33-1.33-1.33-1.33
Inventories -11.31-0-4-2013.79-0.25-0.25-0.25-0.25
Accounts Payable -34.19-72-86.210.510.510.510.51
Capital Expenditure ----512-650-----
UFCF ----------
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 4.46
Free cash flow (t + 1) -
Terminal Value -
Present Value of Terminal Value -

Intrinsic Value

Enterprise Value -
Net Debt 1,225
Equity Value -
Shares Outstanding 88
Equity Value Per Share -