Discounted Cash Flow (DCF) Analysis Unlevered
Under Armour, Inc. (UAA)
$8.87
-0.07 (-0.78%)
All numbers are in Millions, Currency in USD
Operating Data
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
Revenue | 4,976.55 | 5,193.18 | 5,267.13 | 4,474.67 | 5,683.47 | 5,935.61 | 6,198.94 | 6,473.95 | 6,761.17 | 7,061.12 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
EBITDA | 197.98 | 148.48 | 369.83 | -287.55 | 533.28 | 199.62 | 208.48 | 217.73 | 227.39 | 237.47 |
EBITDA (%) | ||||||||||
EBIT | 24.23 | -33.29 | 183.40 | -452.53 | 392.13 | 1.36 | 1.42 | 1.48 | 1.55 | 1.61 |
EBIT (%) | ||||||||||
Depreciation | 173.75 | 181.77 | 186.42 | 164.98 | 141.14 | 198.27 | 207.06 | 216.25 | 225.84 | 235.86 |
Depreciation (%) |
Balance Sheet Data
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
Total Cash | 312.48 | 557.40 | 788.07 | 1,517.36 | 1,669.45 | 1,130.83 | 1,181 | 1,233.40 | 1,288.12 | 1,345.26 |
---|---|---|---|---|---|---|---|---|---|---|
Total Cash (%) | ||||||||||
Account Receivables | 609.67 | 652.55 | 708.71 | 527.34 | 569.01 | 713.09 | 744.72 | 777.76 | 812.27 | 848.30 |
Account Receivables (%) | ||||||||||
Inventories | 1,158.55 | 1,019.50 | 892.26 | 895.97 | 811.41 | 1,117.69 | 1,167.28 | 1,219.07 | 1,273.15 | 1,329.63 |
Inventories (%) | ||||||||||
Accounts Payable | 561.11 | 560.88 | 618.19 | 575.95 | 613.31 | 682.30 | 712.57 | 744.18 | 777.19 | 811.67 |
Accounts Payable (%) | ||||||||||
Capital Expenditure | -281.34 | -170.39 | -145.80 | -92.29 | -69.76 | -177.98 | -185.87 | -194.12 | -202.73 | -211.72 |
Capital Expenditure (%) |
Weighted Average Cost Of Capital
Share price | $ 8.87 |
---|---|
Beta | 1.625 |
Diluted Shares Outstanding | 454.09 |
Cost of Debt | |
Tax Rate | 7.88 |
After-tax Cost of Debt | 4.61% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 11.052 |
Total Debt | 1,504.31 |
Total Equity | 4,027.77 |
Total Capital | 5,532.08 |
Debt Weighting | 27.19 |
Equity Weighting | 72.81 |
Wacc |
Build Up Free Cash
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
Revenue | 4,976.55 | 5,193.18 | 5,267.13 | 4,474.67 | 5,683.47 | 5,935.61 | 6,198.94 | 6,473.95 | 6,761.17 | 7,061.12 |
---|---|---|---|---|---|---|---|---|---|---|
EBITDA | 197.98 | 148.48 | 369.83 | -287.55 | 533.28 | 199.62 | 208.48 | 217.73 | 227.39 | 237.47 |
EBIT | 24.23 | -33.29 | 183.40 | -452.53 | 392.13 | 1.36 | 1.42 | 1.48 | 1.55 | 1.61 |
Tax Rate | -368.13% | 31.70% | 56.09% | -11.50% | 7.88% | -56.79% | -56.79% | -56.79% | -56.79% | -56.79% |
EBIAT | 113.42 | -22.74 | 80.53 | -504.56 | 361.22 | 2.13 | 2.22 | 2.32 | 2.42 | 2.53 |
Depreciation | 173.75 | 181.77 | 186.42 | 164.98 | 141.14 | 198.27 | 207.06 | 216.25 | 225.84 | 235.86 |
Accounts Receivable | - | -42.88 | -56.17 | 181.37 | -41.67 | -144.07 | -31.64 | -33.04 | -34.50 | -36.04 |
Inventories | - | 139.05 | 127.24 | -3.72 | 84.56 | -306.28 | -49.59 | -51.79 | -54.08 | -56.48 |
Accounts Payable | - | -0.22 | 57.31 | -42.24 | 37.35 | 68.99 | 30.27 | 31.61 | 33.02 | 34.48 |
Capital Expenditure | -281.34 | -170.38 | -145.80 | -92.29 | -69.76 | -177.98 | -185.87 | -194.12 | -202.73 | -211.72 |
UFCF | 5.83 | 84.60 | 249.53 | -296.45 | 512.84 | -358.95 | -27.54 | -28.76 | -30.04 | -31.37 |
WACC | ||||||||||
PV UFCF | -328.41 | -23.05 | -22.03 | -21.05 | -20.11 | |||||
SUM PV UFCF | -414.65 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 9.30 |
Free cash flow (t + 1) | -32 |
Terminal Value | -438.36 |
Present Value of Terminal Value | -281.01 |
Intrinsic Value
Enterprise Value | -695.67 |
---|---|
Net Debt | -165.15 |
Equity Value | -530.52 |
Shares Outstanding | 454.09 |
Equity Value Per Share | -1.17 |