Waldencast plc (WALD) 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
Waldencast plc (WALD) Bundle
Evaluate Waldencast plc's financial outlook like an expert! This (WALD) DCF Calculator provides pre-filled financials along with the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2021 |
AY2 2022 |
AY3 2023 |
AY4 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 94.4 | 142.5 | 166.1 | 218.1 | 290.0 | 385.5 | 512.4 | 681.1 | 905.4 | |
Revenue Growth, % | 0 | 50.88 | 16.61 | 31.3 | 32.93 | 32.93 | 32.93 | 32.93 | 32.93 | |
EBITDA | 13.9 | 15.0 | -99.3 | -33.5 | -36.1 | -48.0 | -63.8 | -84.8 | -112.7 | |
EBITDA, % | 14.76 | 10.56 | -59.74 | -15.38 | -12.45 | -12.45 | -12.45 | -12.45 | -12.45 | |
Depreciation | 13.4 | 13.9 | 35.2 | 60.5 | 52.8 | 70.2 | 93.4 | 124.1 | 165.0 | |
Depreciation, % | 14.21 | 9.76 | 21.17 | 27.73 | 18.22 | 18.22 | 18.22 | 18.22 | 18.22 | |
EBIT | .5 | 1.1 | -134.4 | -94.0 | -88.9 | -118.2 | -157.1 | -208.9 | -277.7 | |
EBIT, % | 0.54751 | 0.80296 | -80.91 | -43.11 | -30.67 | -30.67 | -30.67 | -30.67 | -30.67 | |
Total Cash | .0 | 12.8 | 8.7 | 22.6 | 17.8 | 23.7 | 31.5 | 41.8 | 55.6 | |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | |
Account Receivables | .0 | 18.7 | 19.5 | 22.4 | 25.5 | 33.9 | 45.1 | 59.9 | 79.7 | |
Account Receivables, % | 0 | 13.15 | 11.76 | 10.28 | 8.8 | 8.8 | 8.8 | 8.8 | 8.8 | |
Inventories | .0 | 21.6 | 54.4 | 55.7 | 53.2 | 70.8 | 94.1 | 125.0 | 166.2 | |
Inventories, % | 0 | 15.17 | 32.74 | 25.53 | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 | |
Accounts Payable | .2 | 12.7 | 24.2 | 28.1 | 26.5 | 35.2 | 46.8 | 62.3 | 82.8 | |
Accounts Payable, % | 0.18823 | 8.9 | 14.59 | 12.88 | 9.14 | 9.14 | 9.14 | 9.14 | 9.14 | |
Capital Expenditure | -1.7 | -1.3 | -2.5 | -2.0 | -3.7 | -5.0 | -6.6 | -8.8 | -11.7 | |
Capital Expenditure, % | -1.81 | -0.90334 | -1.5 | -0.93794 | -1.29 | -1.29 | -1.29 | -1.29 | -1.29 | |
Tax Rate, % | 20.33 | 20.33 | 20.33 | 20.33 | 20.33 | 20.33 | 20.33 | 20.33 | 20.33 | |
EBITAT | .2 | 2.2 | -106.4 | -74.9 | -66.7 | -88.6 | -117.8 | -156.6 | -208.2 | |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 12.1 | -13.0 | -95.8 | -16.8 | -19.8 | -40.6 | -54.0 | -71.7 | -95.3 | |
WACC, % | 5.08 | 7 | 6.32 | 6.34 | 6.19 | 6.19 | 6.19 | 6.19 | 6.19 | |
PV UFCF | ||||||||||
SUM PV UFCF | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | -226.7 | |
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -97 | |||||||||
Terminal Value | -2,322 | |||||||||
Present Terminal Value | -1,720 | |||||||||
Enterprise Value | -1,947 | |||||||||
Net Debt | 155 | |||||||||
Equity Value | -2,102 | |||||||||
Diluted Shares Outstanding, MM | 101 | |||||||||
Equity Value Per Share | -20.76 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled financial data for WALD.
- Real-World Insights: Access to historical data and forward-looking projections (highlighted in the yellow cells).
- Flexible Forecasting: Adjust key assumptions such as revenue growth, EBITDA %, and WACC as needed.
- Instant Calculations: Quickly observe how your inputs affect the valuation of Waldencast plc (WALD).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Interface: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- 🔍 Real-Life WALD Financials: Pre-filled historical and projected data for Waldencast plc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Waldencast’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Waldencast’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Waldencast plc’s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose This Calculator for Waldencast plc (WALD)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses, tailored for Waldencast plc (WALD).
- Flexible Inputs: Modify the yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Waldencast plc’s (WALD) intrinsic value and Net Present Value.
- Preloaded Information: Access historical and projected data for reliable analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focusing on Waldencast plc (WALD).
Who Should Use This Product?
- Professional Investors: Create comprehensive and trustworthy valuation models for analyzing portfolios involving Waldencast plc (WALD).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in investing in Waldencast plc (WALD).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling related to Waldencast plc (WALD).
- Health and Wellness Enthusiasts: Gain insights into how companies like Waldencast plc (WALD) are valued in the health and wellness sector.
What the Template Contains
- Preloaded WALD Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.