Utz Brands, Inc. (UTZ) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Utz Brands, Inc. (UTZ) Bundle
Evaluate Utz Brands, Inc.'s (UTZ) financial outlook like an expert! This (UTZ) DCF Calculator comes with pre-filled financial data and offers total flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | .0 | 768.2 | 1,180.7 | 1,408.4 | 1,438.2 | 1,708.2 | 2,029.0 | 2,409.9 | 2,862.3 | 3,399.7 |
Revenue Growth, % | 0 | 0 | 53.69 | 19.28 | 2.12 | 18.77 | 18.77 | 18.77 | 18.77 | 18.77 |
EBITDA | -1.0 | -16.1 | 131.5 | 93.3 | 100.8 | 419.1 | 497.8 | 591.3 | 702.3 | 834.1 |
EBITDA, % | 100 | -2.09 | 11.14 | 6.62 | 7.01 | 24.54 | 24.54 | 24.54 | 24.54 | 24.54 |
Depreciation | -9.0 | 29.3 | 83.1 | 86.5 | 79.5 | 418.6 | 497.2 | 590.5 | 701.4 | 833.1 |
Depreciation, % | 100 | 3.81 | 7.04 | 6.14 | 5.53 | 24.5 | 24.5 | 24.5 | 24.5 | 24.5 |
EBIT | 8.0 | -45.4 | 48.4 | 6.8 | 21.3 | 342.2 | 406.4 | 482.7 | 573.3 | 681.0 |
EBIT, % | 100 | -5.9 | 4.1 | 0.47962 | 1.48 | 20.03 | 20.03 | 20.03 | 20.03 | 20.03 |
Total Cash | .6 | 46.8 | 41.9 | 72.9 | 52.0 | 404.6 | 480.6 | 570.8 | 678.0 | 805.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | 126.0 | 138.1 | 146.3 | 140.4 | 506.5 | 601.5 | 714.5 | 848.6 | 1,007.9 |
Account Receivables, % | 100 | 16.4 | 11.7 | 10.38 | 9.76 | 29.65 | 29.65 | 29.65 | 29.65 | 29.65 |
Inventories | .0 | 59.8 | 79.5 | 118.0 | 104.7 | 444.7 | 528.2 | 627.4 | 745.2 | 885.1 |
Inventories, % | 100 | 7.79 | 6.73 | 8.38 | 7.28 | 26.04 | 26.04 | 26.04 | 26.04 | 26.04 |
Accounts Payable | 49.0 | 57.3 | 95.4 | 114.4 | 124.4 | 452.0 | 536.8 | 637.6 | 757.3 | 899.5 |
Accounts Payable, % | 100 | 7.45 | 8.08 | 8.12 | 8.65 | 26.46 | 26.46 | 26.46 | 26.46 | 26.46 |
Capital Expenditure | .0 | -20.0 | -33.5 | -88.0 | -55.7 | -53.2 | -63.1 | -75.0 | -89.1 | -105.8 |
Capital Expenditure, % | 100 | -2.6 | -2.84 | -6.25 | -3.87 | -3.11 | -3.11 | -3.11 | -3.11 | -3.11 |
Tax Rate, % | 36.51 | 36.51 | 36.51 | 36.51 | 36.51 | 36.51 | 36.51 | 36.51 | 36.51 | 36.51 |
EBITAT | 8.0 | -71.8 | 24.1 | 2.5 | 13.5 | 239.7 | 284.7 | 338.1 | 401.6 | 477.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 48.0 | -240.1 | 80.0 | -26.6 | 66.5 | 226.6 | 625.0 | 742.3 | 881.7 | 1,047.2 |
WACC, % | 7.91 | 7.91 | 6.55 | 6.21 | 6.93 | 7.1 | 7.1 | 7.1 | 7.1 | 7.1 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,773.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,068 | |||||||||
Terminal Value | 20,937 | |||||||||
Present Terminal Value | 14,857 | |||||||||
Enterprise Value | 17,630 | |||||||||
Net Debt | 933 | |||||||||
Equity Value | 16,697 | |||||||||
Diluted Shares Outstanding, MM | 81 | |||||||||
Equity Value Per Share | 205.93 |
What You Will Get
- Real Utz Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Utz Brands, Inc. (UTZ).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates to suit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Utz’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections.
- Time-Saving and Accurate: Avoid the hassle of building models from scratch while ensuring precision and flexibility.
Key Features
- 🔍 Real-Life UTZ Financials: Pre-filled historical and projected data for Utz Brands, Inc. (UTZ).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Utz’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Utz’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Get the pre-formatted Excel file containing Utz Brands, Inc. (UTZ) financial data.
- Customize: Modify projections such as revenue growth, EBITDA %, and WACC as needed.
- Update Automatically: Watch the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose Utz Brands, Inc. (UTZ)?
- Save Time: Quickly access essential information without the need for extensive research.
- Enhance Quality: High-quality ingredients ensure superior taste and satisfaction.
- Fully Customizable: Choose from a variety of products to meet your snacking preferences.
- Easy to Enjoy: Convenient packaging makes snacking on the go effortless.
- Trusted by Consumers: A brand known for its commitment to excellence and customer satisfaction.
Who Should Use This Product?
- Investors: Evaluate Utz Brands, Inc. (UTZ) valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of established brands like Utz.
- Consultants: Provide comprehensive valuation analyses and reports for clients.
- Students and Educators: Utilize current data to teach and learn valuation practices.
What the Template Contains
- Historical Data: Includes Utz Brands, Inc.'s (UTZ) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Utz Brands, Inc.'s (UTZ) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Utz Brands, Inc.'s (UTZ) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.