Under Armour, Inc. (UA) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Under Armour, Inc. (UA) Bundle
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 | 722.0 | 744.4 | 767.6 | 791.4 | 816.0 |
Account Receivables, % | 13.46 | 11.79 | 10.01 | 12.87 | 13.28 | 12.28 | 12.28 | 12.28 | 12.28 | 12.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.