The Honest Company, Inc. (HNST) 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 Honest Company, Inc. (HNST) Bundle
Engineered for accuracy, our (HNST) DCF Calculator enables you to evaluate The Honest Company, Inc. valuation using up-to-date financial data and complete flexibility to modify all essential parameters for improved forecasts.
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 | 235.6 | 300.5 | 318.6 | 313.7 | 344.4 | 380.4 | 420.1 | 464.1 | 512.6 | 566.2 |
| Revenue Growth, % | 0 | 27.56 | 6.03 | -1.57 | 9.79 | 10.45 | 10.45 | 10.45 | 10.45 | 10.45 |
| EBITDA | -23.8 | -8.7 | -32.7 | -47.0 | -36.2 | -37.1 | -41.0 | -45.2 | -50.0 | -55.2 |
| EBITDA, % | -10.1 | -2.89 | -10.26 | -14.99 | -10.5 | -9.75 | -9.75 | -9.75 | -9.75 | -9.75 |
| Depreciation | 7.7 | 4.9 | 4.1 | 2.8 | 2.7 | 6.0 | 6.6 | 7.3 | 8.0 | 8.9 |
| Depreciation, % | 3.26 | 1.62 | 1.3 | 0.87773 | 0.79567 | 1.57 | 1.57 | 1.57 | 1.57 | 1.57 |
| EBIT | -31.5 | -13.5 | -36.8 | -49.8 | -38.9 | -43.0 | -47.5 | -52.5 | -58.0 | -64.1 |
| EBIT, % | -13.35 | -4.51 | -11.56 | -15.87 | -11.29 | -11.32 | -11.32 | -11.32 | -11.32 | -11.32 |
| Total Cash | 85.0 | 63.7 | 93.2 | 15.2 | 32.8 | 76.8 | 84.8 | 93.6 | 103.4 | 114.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 24.3 | 22.8 | 31.8 | 42.3 | 43.1 | 41.0 | 45.3 | 50.0 | 55.2 | 61.0 |
| Account Receivables, % | 10.3 | 7.59 | 9.97 | 13.5 | 12.51 | 10.77 | 10.77 | 10.77 | 10.77 | 10.77 |
| Inventories | 52.5 | 76.7 | 75.7 | 115.7 | 73.5 | 98.7 | 109.0 | 120.4 | 133.0 | 147.0 |
| Inventories, % | 22.3 | 25.51 | 23.75 | 36.88 | 21.34 | 25.96 | 25.96 | 25.96 | 25.96 | 25.96 |
| Accounts Payable | 20.8 | 31.1 | 28.7 | 24.8 | 22.3 | 32.4 | 35.8 | 39.5 | 43.6 | 48.2 |
| Accounts Payable, % | 8.82 | 10.36 | 9.02 | 7.89 | 6.47 | 8.51 | 8.51 | 8.51 | 8.51 | 8.51 |
| Capital Expenditure | -.7 | -.2 | -.2 | -1.6 | -1.8 | -1.1 | -1.2 | -1.4 | -1.5 | -1.7 |
| Capital Expenditure, % | -0.28058 | -0.06655087 | -0.06904365 | -0.51554 | -0.53664 | -0.29367 | -0.29367 | -0.29367 | -0.29367 | -0.29367 |
| Tax Rate, % | -0.19151 | -0.19151 | -0.19151 | -0.19151 | -0.19151 | -0.19151 | -0.19151 | -0.19151 | -0.19151 | -0.19151 |
| EBITAT | -31.5 | -13.6 | -36.9 | -49.9 | -39.0 | -43.0 | -47.5 | -52.5 | -58.0 | -64.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -80.5 | -21.3 | -43.4 | -103.3 | .9 | -51.2 | -53.4 | -59.0 | -65.2 | -72.0 |
| WACC, % | 12.78 | 12.78 | 12.78 | 12.78 | 12.78 | 12.78 | 12.78 | 12.78 | 12.78 | 12.78 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -208.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -73 | |||||||||
| Terminal Value | -681 | |||||||||
| Present Terminal Value | -373 | |||||||||
| Enterprise Value | -581 | |||||||||
| Net Debt | -3 | |||||||||
| Equity Value | -578 | |||||||||
| Diluted Shares Outstanding, MM | 95 | |||||||||
| Equity Value Per Share | -6.12 |
What You Will Get
- Real Honest Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for The Honest Company, Inc. (HNST).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on The Honest Company, Inc.'s (HNST) fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections tailored to The Honest Company, Inc. (HNST).
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility in your financial assessments.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for The Honest Company, Inc. (HNST).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable inputs for accurate assessments.
- Customizable Forecast Assumptions: Easily modify growth projections, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for The Honest Company, Inc. (HNST).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file featuring The Honest Company’s preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Present with Confidence: Deliver professional valuation insights to inform your decisions.
Why Choose This Calculator?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses tailored for The Honest Company, Inc. (HNST).
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes The Honest Company’s intrinsic value and Net Present Value.
- Preloaded Data: Access historical and forecasted data for reliable analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focused on The Honest Company, Inc. (HNST).
Who Should Use This Product?
- Parents: Discover safe and effective products for your family's needs.
- Health-Conscious Consumers: Learn about natural ingredients and their benefits.
- Eco-Friendly Advocates: Explore sustainable practices and products from The Honest Company, Inc. (HNST).
- Retailers: Enhance your inventory with trusted, high-quality products from The Honest Company, Inc. (HNST).
- Investors: Analyze market trends and growth potential in the consumer goods sector with The Honest Company, Inc. (HNST).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled The Honest Company historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for The Honest Company, Inc. (HNST).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.