Krispy Kreme, Inc. (DNUT) 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
Krispy Kreme, Inc. (DNUT) Bundle
Explore Krispy Kreme, Inc.'s (DNUT) financial potential with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine Krispy Kreme's intrinsic value and refine your investment strategy.
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 | 959.4 | 1,122.0 | 1,384.4 | 1,529.9 | 1,686.1 | 1,943.5 | 2,240.1 | 2,582.0 | 2,976.1 | 3,430.4 |
Revenue Growth, % | 0 | 16.95 | 23.38 | 10.51 | 10.21 | 15.26 | 15.26 | 15.26 | 15.26 | 15.26 |
EBITDA | 100.6 | 78.1 | 136.9 | 141.1 | 134.0 | 173.0 | 199.4 | 229.8 | 264.9 | 305.4 |
EBITDA, % | 10.49 | 6.96 | 9.89 | 9.22 | 7.95 | 8.9 | 8.9 | 8.9 | 8.9 | 8.9 |
Depreciation | 63.8 | 80.4 | 101.6 | 110.3 | 125.9 | 139.2 | 160.5 | 185.0 | 213.2 | 245.8 |
Depreciation, % | 6.65 | 7.17 | 7.34 | 7.21 | 7.47 | 7.17 | 7.17 | 7.17 | 7.17 | 7.17 |
EBIT | 36.8 | -2.3 | 35.3 | 30.8 | 8.1 | 33.8 | 38.9 | 44.8 | 51.7 | 59.6 |
EBIT, % | 3.84 | -0.20071 | 2.55 | 2.01 | 0.47856 | 1.74 | 1.74 | 1.74 | 1.74 | 1.74 |
Total Cash | 37.4 | 38.5 | 38.6 | 35.4 | 38.2 | 57.1 | 65.8 | 75.9 | 87.4 | 100.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 48.4 | 74.4 | 62.2 | 69.4 | 74.9 | 97.7 | 112.6 | 129.8 | 149.6 | 172.4 |
Account Receivables, % | 5.04 | 6.63 | 4.49 | 4.53 | 4.44 | 5.03 | 5.03 | 5.03 | 5.03 | 5.03 |
Inventories | 22.6 | 38.5 | 34.9 | 46.2 | 34.7 | 52.0 | 60.0 | 69.1 | 79.7 | 91.8 |
Inventories, % | 2.35 | 3.43 | 2.52 | 3.02 | 2.06 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 |
Accounts Payable | 138.8 | 148.6 | 182.1 | 225.3 | 156.5 | 252.1 | 290.6 | 335.0 | 386.1 | 445.1 |
Accounts Payable, % | 14.46 | 13.25 | 13.15 | 14.72 | 9.28 | 12.97 | 12.97 | 12.97 | 12.97 | 12.97 |
Capital Expenditure | -76.4 | -97.8 | -119.5 | -111.7 | -121.4 | -154.8 | -178.4 | -205.6 | -237.0 | -273.2 |
Capital Expenditure, % | -7.96 | -8.72 | -8.63 | -7.3 | -7.2 | -7.96 | -7.96 | -7.96 | -7.96 | -7.96 |
Tax Rate, % | 7.49 | 7.49 | 7.49 | 7.49 | 7.49 | 7.49 | 7.49 | 7.49 | 7.49 | 7.49 |
EBITAT | 58.5 | -2.6 | 128.0 | 33.1 | 7.5 | 33.2 | 38.3 | 44.2 | 50.9 | 58.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 113.7 | -52.1 | 159.4 | 56.3 | -50.9 | 73.3 | 36.1 | 41.6 | 47.9 | 55.3 |
WACC, % | 8 | 8 | 8 | 8 | 7.85 | 7.97 | 7.97 | 7.97 | 7.97 | 7.97 |
PV UFCF | ||||||||||
SUM PV UFCF | 204.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 56 | |||||||||
Terminal Value | 944 | |||||||||
Present Terminal Value | 644 | |||||||||
Enterprise Value | 848 | |||||||||
Net Debt | 1,358 | |||||||||
Equity Value | -510 | |||||||||
Diluted Shares Outstanding, MM | 168 | |||||||||
Equity Value Per Share | -3.03 |
What You Will Get
- Pre-Filled Financial Model: Krispy Kreme’s real data facilitates accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Instant Calculations: Real-time updates provide immediate results as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
- Customizable and Reusable: Designed for versatility, allowing repeated application for in-depth forecasts.
Key Features
- Authentic DNUT Data: Pre-loaded with Krispy Kreme’s historical performance metrics and future growth forecasts.
- Completely Customizable Variables: Modify sales growth, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Model: Instantaneous recalculations of Net Present Value (NPV) and intrinsic worth based on your adjustments.
- Forecast Scenario Analysis: Develop various projections to evaluate different valuation possibilities.
- Intuitive User Interface: Clean, organized, and tailored for both industry experts and novices.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Krispy Kreme data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Krispy Kreme’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator?
- Accurate Data: Authentic Krispy Kreme financials provide dependable valuation outcomes.
- Customizable: Tailor essential parameters like growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the industry.
- User-Friendly: Simple layout and guided instructions ensure ease of use for everyone.
Who Should Use This Product?
- Professional Investors: Develop comprehensive valuation models for assessing Krispy Kreme's market performance.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Offer clients precise valuation insights for Krispy Kreme stock (DNUT).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Food Industry Analysts: Gain insights into how companies like Krispy Kreme are valued in the competitive market.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Krispy Kreme, Inc. (DNUT).
- Real-World Data: Krispy Kreme’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for deeper insights into Krispy Kreme's performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Krispy Kreme, Inc. (DNUT).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to Krispy Kreme’s financial health.