The Chefs' Warehouse, Inc. (CHEF) 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
The Chefs' Warehouse, Inc. (CHEF) Bundle
Discover the true potential of The Chefs' Warehouse, Inc. (CHEF) with our expert-level DCF Calculator! Adjust essential assumptions, explore various scenarios, and evaluate how different factors influence The Chefs' Warehouse, Inc. (CHEF) valuation – all within a single Excel template.
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 | 1,591.8 | 1,111.6 | 1,745.8 | 2,613.4 | 3,433.8 | 4,360.6 | 5,537.6 | 7,032.4 | 8,930.6 | 11,341.1 |
Revenue Growth, % | 0 | -30.17 | 57.04 | 49.7 | 31.39 | 26.99 | 26.99 | 26.99 | 26.99 | 26.99 |
EBITDA | 76.8 | -68.7 | 10.8 | 85.7 | 156.5 | 61.9 | 78.7 | 99.9 | 126.8 | 161.1 |
EBITDA, % | 4.82 | -6.18 | 0.61927 | 3.28 | 4.56 | 1.42 | 1.42 | 1.42 | 1.42 | 1.42 |
Depreciation | 26.0 | 34.0 | 36.4 | 40.0 | 55.6 | 86.5 | 109.9 | 139.5 | 177.2 | 225.0 |
Depreciation, % | 1.63 | 3.06 | 2.08 | 1.53 | 1.62 | 1.98 | 1.98 | 1.98 | 1.98 | 1.98 |
EBIT | 50.8 | -102.7 | -25.6 | 45.8 | 100.9 | -24.6 | -31.2 | -39.6 | -50.3 | -63.9 |
EBIT, % | 3.19 | -9.24 | -1.46 | 1.75 | 2.94 | -0.56378 | -0.56378 | -0.56378 | -0.56378 | -0.56378 |
Total Cash | 140.2 | 193.3 | 115.2 | 158.8 | 49.9 | 351.7 | 446.6 | 567.1 | 720.2 | 914.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 175.0 | 96.4 | 172.5 | 260.2 | 334.0 | 429.4 | 545.3 | 692.4 | 879.3 | 1,116.7 |
Account Receivables, % | 11 | 8.67 | 9.88 | 9.96 | 9.73 | 9.85 | 9.85 | 9.85 | 9.85 | 9.85 |
Inventories | 124.1 | 82.5 | 144.5 | 245.7 | 284.5 | 359.1 | 456.1 | 579.2 | 735.5 | 934.1 |
Inventories, % | 7.79 | 7.42 | 8.28 | 9.4 | 8.29 | 8.24 | 8.24 | 8.24 | 8.24 | 8.24 |
Accounts Payable | 94.1 | 57.5 | 118.3 | 163.4 | 200.5 | 261.2 | 331.7 | 421.3 | 535.0 | 679.4 |
Accounts Payable, % | 5.91 | 5.17 | 6.78 | 6.25 | 5.84 | 5.99 | 5.99 | 5.99 | 5.99 | 5.99 |
Capital Expenditure | -16.1 | -7.0 | -38.8 | -45.8 | -57.4 | -63.6 | -80.8 | -102.6 | -130.2 | -165.4 |
Capital Expenditure, % | -1.01 | -0.63294 | -2.22 | -1.75 | -1.67 | -1.46 | -1.46 | -1.46 | -1.46 | -1.46 |
Tax Rate, % | 37.64 | 37.64 | 37.64 | 37.64 | 37.64 | 37.64 | 37.64 | 37.64 | 37.64 | 37.64 |
EBITAT | 37.9 | -68.9 | -18.6 | 30.3 | 62.9 | -16.9 | -21.4 | -27.2 | -34.5 | -43.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -157.2 | 41.7 | -98.4 | -119.3 | -14.4 | -103.2 | -134.6 | -171.0 | -217.1 | -275.7 |
WACC, % | 12 | 11.89 | 11.97 | 11.88 | 11.82 | 11.91 | 11.91 | 11.91 | 11.91 | 11.91 |
PV UFCF | ||||||||||
SUM PV UFCF | -617.3 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | -285 | |||||||||
Terminal Value | -3,393 | |||||||||
Present Terminal Value | -1,933 | |||||||||
Enterprise Value | -2,551 | |||||||||
Net Debt | 876 | |||||||||
Equity Value | -3,427 | |||||||||
Diluted Shares Outstanding, MM | 46 | |||||||||
Equity Value Per Share | -75.09 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real CHEF financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect The Chefs' Warehouse’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Real-Life CHEF Data: Pre-filled with The Chefs' Warehouse’s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit 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: Develop multiple forecasting scenarios to evaluate different valuation outcomes.
- User-Friendly Design: Intuitive, organized, and crafted for both professionals and novices.
How It Works
- Step 1: Download the prebuilt Excel template with The Chefs' Warehouse, Inc. (CHEF) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including The Chefs' Warehouse, Inc. (CHEF) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose The Chefs' Warehouse, Inc. (CHEF)?
- Quality Products: We provide top-notch ingredients sourced from reliable suppliers.
- Expert Support: Our knowledgeable staff is always ready to assist with your culinary needs.
- Wide Selection: A diverse range of products to cater to all your cooking requirements.
- Convenient Ordering: Streamlined processes for easy and efficient purchasing.
- Trusted by Professionals: A go-to choice for chefs and restaurants seeking excellence.
Who Should Use This Product?
- Investors: Evaluate The Chefs' Warehouse's valuation before making stock decisions.
- CFOs and Financial Analysts: Optimize valuation methods and assess financial forecasts.
- Restaurant Owners: Understand how leading food distributors like The Chefs' Warehouse are valued.
- Consultants: Provide detailed valuation reports for clients in the food service industry.
- Students and Educators: Utilize real-world data to learn and teach valuation strategies.
What the Template Contains
- Historical Data: Includes The Chefs' Warehouse’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate The Chefs' Warehouse’s 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 The Chefs' Warehouse’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.