Under Armour, Inc. (UA) DCF Valuation

Under Armour, Inc. (UA) 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

Under Armour, Inc. (UA) 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 Under Armour, Inc. (UA) financial prospects like an expert! This (UA) DCF Calculator provides pre-filled financial data along with the complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2020
AY2
2021
AY3
2022
AY4
2023
AY5
2024
FY1
2025
FY2
2026
FY3
2027
FY4
2028
FY5
2029
Revenue 5,267.1 4,474.7 5,683.5 5,903.6 5,701.9 5,879.0 6,061.6 6,249.9 6,444.0 6,644.2
Revenue Growth, % 0 -15.05 27.01 3.87 -3.42 3.11 3.11 3.11 3.11 3.11
EBITDA 417.5 321.3 708.5 421.4 372.3 484.9 500.0 515.5 531.5 548.0
EBITDA, % 7.93 7.18 12.47 7.14 6.53 8.25 8.25 8.25 8.25 8.25
Depreciation 186.4 165.0 141.1 137.6 142.6 171.0 176.3 181.8 187.4 193.2
Depreciation, % 3.54 3.69 2.48 2.33 2.5 2.91 2.91 2.91 2.91 2.91
EBIT 231.1 156.3 567.3 283.8 229.8 313.9 323.7 333.7 344.1 354.8
EBIT, % 4.39 3.49 9.98 4.81 4.03 5.34 5.34 5.34 5.34 5.34
Total Cash 788.1 1,517.4 1,669.5 711.9 858.7 1,238.9 1,277.4 1,317.0 1,357.9 1,400.1
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 708.7 527.3 569.0 759.9 757.3
Account Receivables, % 13.46 11.79 10.01 12.87 13.28
Inventories 892.3 896.0 811.4 1,190.3 958.5 1,037.2 1,069.4 1,102.6 1,136.9 1,172.2
Inventories, % 16.94 20.02 14.28 20.16 16.81 17.64 17.64 17.64 17.64 17.64
Accounts Payable 618.2 576.0 613.3 649.1 483.7 645.3 665.3 686.0 707.3 729.2
Accounts Payable, % 11.74 12.87 10.79 11 8.48 10.98 10.98 10.98 10.98 10.98
Capital Expenditure -145.8 -92.3 -69.8 -187.8 -150.3 -139.6 -144.0 -148.4 -153.1 -157.8
Capital Expenditure, % -2.77 -2.06 -1.23 -3.18 -2.64 -2.38 -2.38 -2.38 -2.38 -2.38
Tax Rate, % 11.46 11.46 11.46 11.46 11.46 11.46 11.46 11.46 11.46 11.46
EBITAT 101.5 174.3 522.6 381.5 203.4 266.6 274.8 283.4 292.2 301.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -840.7 382.4 674.2 -202.6 264.6 416.1 272.6 281.0 289.8 298.8
WACC, % 9.44 10.13 10.03 10.13 9.99 9.94 9.94 9.94 9.94 9.94
PV UFCF
SUM PV UFCF 1,199.8
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 308
Terminal Value 4,433
Present Terminal Value 2,760
Enterprise Value 3,960
Net Debt 584
Equity Value 3,375
Diluted Shares Outstanding, MM 451
Equity Value Per Share 7.48

What You Will Get

  • Real Under Armour Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Under Armour’s fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.

Key Features

  • Real-Life UA Data: Pre-filled with Under Armour’s historical financials and forward-looking projections.
  • Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
  • Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
  • Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
  • User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.

How It Works

  • Download: Obtain the pre-built Excel file featuring Under Armour, Inc.'s (UA) financial data.
  • Customize: Modify forecasts such as revenue growth, EBITDA %, and WACC to fit your analysis.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
  • Test Scenarios: Generate various projections and instantly compare the results.
  • Make Decisions: Leverage the valuation findings to inform your investment choices.

Why Choose This Calculator for Under Armour, Inc. (UA)?

  • Accurate Data: Up-to-date Under Armour financials provide dependable valuation outcomes.
  • Customizable: Tailor essential parameters like growth rates, WACC, and tax rates to fit your forecasts.
  • Time-Saving: Ready-made calculations save you from starting from ground zero.
  • Professional-Grade Tool: Created for investors, analysts, and consultants in the sports apparel industry.
  • User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.

Who Should Use This Product?

  • Professional Investors: Develop comprehensive and trustworthy valuation models for portfolio evaluation.
  • Corporate Finance Teams: Assess valuation scenarios to inform internal decision-making.
  • Consultants and Advisors: Offer clients precise valuation insights for Under Armour, Inc. (UA).
  • Students and Educators: Utilize real-world data to practice and teach financial modeling techniques.
  • Sports Enthusiasts: Gain insight into how athletic brands like Under Armour, Inc. (UA) are valued in the marketplace.

What the Template Contains

  • Pre-Filled DCF Model: Under Armour’s financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Under Armour's profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.