YETI Holdings, Inc. (YETI) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
YETI Holdings, Inc. (YETI) Bundle
Evaluate YETI Holdings, Inc. (YETI) financial prospects like an expert! This (YETI) DCF Calculator comes with pre-filled financial data and offers full flexibility to modify revenue growth, WACC, profit margins, and other crucial assumptions to align with your predictions.
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 | 913.7 | 1,091.7 | 1,411.0 | 1,595.2 | 1,658.7 | 1,931.4 | 2,248.9 | 2,618.7 | 3,049.2 | 3,550.5 |
Revenue Growth, % | 0 | 19.48 | 29.24 | 13.06 | 3.98 | 16.44 | 16.44 | 16.44 | 16.44 | 16.44 |
EBITDA | 118.0 | 244.9 | 303.8 | 160.5 | 271.9 | 321.9 | 374.8 | 436.4 | 508.2 | 591.7 |
EBITDA, % | 12.91 | 22.43 | 21.53 | 10.06 | 16.39 | 16.67 | 16.67 | 16.67 | 16.67 | 16.67 |
Depreciation | 29.0 | 30.5 | 32.1 | 39.8 | 46.4 | 52.3 | 60.9 | 70.9 | 82.5 | 96.1 |
Depreciation, % | 3.17 | 2.8 | 2.27 | 2.5 | 2.8 | 2.71 | 2.71 | 2.71 | 2.71 | 2.71 |
EBIT | 89.0 | 214.4 | 271.7 | 120.6 | 225.5 | 269.6 | 313.9 | 365.5 | 425.6 | 495.6 |
EBIT, % | 9.74 | 19.63 | 19.26 | 7.56 | 13.59 | 13.96 | 13.96 | 13.96 | 13.96 | 13.96 |
Total Cash | 72.5 | 253.3 | 312.2 | 234.7 | 439.0 | 364.8 | 424.8 | 494.6 | 575.9 | 670.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 82.7 | 65.4 | 109.5 | 79.4 | 95.8 | 129.6 | 150.9 | 175.8 | 204.7 | 238.3 |
Account Receivables, % | 9.05 | 5.99 | 7.76 | 4.98 | 5.77 | 6.71 | 6.71 | 6.71 | 6.71 | 6.71 |
Inventories | 185.7 | 140.1 | 318.9 | 371.4 | 337.2 | 383.8 | 446.9 | 520.4 | 606.0 | 705.6 |
Inventories, % | 20.32 | 12.83 | 22.6 | 23.28 | 20.33 | 19.87 | 19.87 | 19.87 | 19.87 | 19.87 |
Accounts Payable | 83.8 | 123.6 | 191.3 | 140.8 | 190.4 | 210.0 | 244.5 | 284.7 | 331.5 | 386.0 |
Accounts Payable, % | 9.17 | 11.32 | 13.56 | 8.83 | 11.48 | 10.87 | 10.87 | 10.87 | 10.87 | 10.87 |
Capital Expenditure | -48.7 | -22.9 | -65.8 | -56.9 | -50.7 | -72.3 | -84.2 | -98.0 | -114.1 | -132.9 |
Capital Expenditure, % | -5.33 | -2.1 | -4.66 | -3.57 | -3.05 | -3.74 | -3.74 | -3.74 | -3.74 | -3.74 |
Tax Rate, % | 24.81 | 24.81 | 24.81 | 24.81 | 24.81 | 24.81 | 24.81 | 24.81 | 24.81 | 24.81 |
EBITAT | 66.8 | 162.8 | 215.2 | 93.1 | 169.5 | 206.3 | 240.2 | 279.6 | 325.6 | 379.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -137.5 | 273.0 | 26.4 | 3.1 | 232.7 | 125.4 | 167.0 | 194.4 | 226.4 | 263.6 |
WACC, % | 13.93 | 13.93 | 13.94 | 13.93 | 13.93 | 13.93 | 13.93 | 13.93 | 13.93 | 13.93 |
PV UFCF | ||||||||||
SUM PV UFCF | 641.8 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 273 | |||||||||
Terminal Value | 2,616 | |||||||||
Present Terminal Value | 1,363 | |||||||||
Enterprise Value | 2,004 | |||||||||
Net Debt | -263 | |||||||||
Equity Value | 2,267 | |||||||||
Diluted Shares Outstanding, MM | 87 | |||||||||
Equity Value Per Share | 25.94 |
What You Will Get
- Real YETI 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 YETI’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
- Pre-Loaded Data: YETI Holdings, Inc.’s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: Observe YETI’s intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and key metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Download the Template: Gain immediate access to the Excel-based YETI DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates YETI’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for YETI Holdings, Inc. (YETI)?
- Accuracy: Utilizes authentic YETI financial data for precise calculations.
- Flexibility: Allows users to easily adjust and experiment with various inputs.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive interface that caters to users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Accurately assess YETI’s fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to YETI.
- Consultants: Efficiently modify the template for valuation reports tailored to YETI clients.
- Entrepreneurs: Understand financial modeling techniques employed by leading companies like YETI.
- Educators: Implement it as a teaching resource to illustrate valuation methods relevant to YETI.
What the Template Contains
- Pre-Filled DCF Model: YETI Holdings, Inc.’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate YETI’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.