Karat Packaging Inc. (KRT) 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
Karat Packaging Inc. (KRT) Bundle
Whether you're an investor or an analyst, this (KRT) DCF Calculator is your go-to tool for accurate valuation. Loaded with real data from Karat Packaging Inc., you can adjust forecasts and observe the effects in real-time.
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 | 224.9 | 295.5 | 364.2 | 423.0 | 405.7 | 473.3 | 552.2 | 644.2 | 751.6 | 876.9 |
Revenue Growth, % | 0 | 31.39 | 23.26 | 16.12 | -4.09 | 16.67 | 16.67 | 16.67 | 16.67 | 16.67 |
EBITDA | 11.8 | 36.3 | 33.2 | 48.8 | 60.8 | 50.3 | 58.7 | 68.5 | 79.9 | 93.2 |
EBITDA, % | 5.24 | 12.27 | 9.11 | 11.53 | 14.98 | 10.63 | 10.63 | 10.63 | 10.63 | 10.63 |
Depreciation | 6.0 | 8.6 | 10.0 | 14.2 | 15.8 | 14.7 | 17.2 | 20.0 | 23.4 | 27.3 |
Depreciation, % | 2.65 | 2.9 | 2.76 | 3.36 | 3.88 | 3.11 | 3.11 | 3.11 | 3.11 | 3.11 |
EBIT | 5.8 | 27.7 | 23.1 | 34.5 | 45.0 | 35.6 | 41.5 | 48.4 | 56.5 | 65.9 |
EBIT, % | 2.59 | 9.37 | 6.35 | 8.16 | 11.1 | 7.52 | 7.52 | 7.52 | 7.52 | 7.52 |
Total Cash | .8 | .4 | 6.5 | 16.0 | 49.4 | 17.3 | 20.2 | 23.5 | 27.5 | 32.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 21.7 | 23.8 | 32.8 | 29.9 | 27.8 | 38.5 | 44.9 | 52.4 | 61.1 | 71.3 |
Account Receivables, % | 9.65 | 8.07 | 9 | 7.07 | 6.84 | 8.13 | 8.13 | 8.13 | 8.13 | 8.13 |
Inventories | 35.4 | 49.0 | 58.5 | 71.2 | 71.5 | 78.4 | 91.5 | 106.7 | 124.5 | 145.3 |
Inventories, % | 15.75 | 16.57 | 16.05 | 16.84 | 17.63 | 16.57 | 16.57 | 16.57 | 16.57 | 16.57 |
Accounts Payable | 24.1 | 25.1 | 20.5 | 23.5 | 23.8 | 34.3 | 40.0 | 46.7 | 54.5 | 63.6 |
Accounts Payable, % | 10.73 | 8.5 | 5.62 | 5.56 | 5.86 | 7.25 | 7.25 | 7.25 | 7.25 | 7.25 |
Capital Expenditure | -34.8 | -36.5 | -12.4 | -14.7 | -9.3 | -35.0 | -40.9 | -47.7 | -55.6 | -64.9 |
Capital Expenditure, % | -15.48 | -12.35 | -3.4 | -3.49 | -2.3 | -7.4 | -7.4 | -7.4 | -7.4 | -7.4 |
Tax Rate, % | 24.46 | 24.46 | 24.46 | 24.46 | 24.46 | 24.46 | 24.46 | 24.46 | 24.46 | 24.46 |
EBITAT | 3.4 | 22.1 | 17.5 | 25.1 | 34.0 | 25.8 | 30.1 | 35.1 | 40.9 | 47.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -58.4 | -20.5 | -8.0 | 17.8 | 42.5 | -1.6 | -7.4 | -8.6 | -10.1 | -11.7 |
WACC, % | 8.49 | 8.59 | 8.57 | 8.55 | 8.57 | 8.55 | 8.55 | 8.55 | 8.55 | 8.55 |
PV UFCF | ||||||||||
SUM PV UFCF | -29.5 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | -12 | |||||||||
Terminal Value | -240 | |||||||||
Present Terminal Value | -160 | |||||||||
Enterprise Value | -189 | |||||||||
Net Debt | 48 | |||||||||
Equity Value | -237 | |||||||||
Diluted Shares Outstanding, MM | 20 | |||||||||
Equity Value Per Share | -11.86 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real KRT financials.
- Real-World Data: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Karat Packaging'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 KRT Financials: Pre-filled historical and projected data for Karat Packaging Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Karat’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Karat’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-prepared Excel file featuring Karat Packaging Inc.'s (KRT) financial data.
- Customize: Modify projections, including sales growth, EBITDA %, and discount rates.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly analyze different outcomes.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose the Karat Packaging Calculator?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Karat Packaging Inc. (KRT).
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Karat Packaging’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable starting points for analysis.
- Professional Standard: Perfect for financial analysts, investors, and business advisors working with Karat Packaging Inc. (KRT).
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for assessing Karat Packaging Inc. (KRT) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Karat Packaging Inc. (KRT).
- Students and Educators: Utilize real-world data to practice and teach financial modeling techniques.
- Packaging Industry Enthusiasts: Gain insights into how companies like Karat Packaging Inc. (KRT) are valued in the marketplace.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring thorough valuation calculations.
- Real-World Data: Karat Packaging Inc.’s (KRT) historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results.