Laird Superfood, Inc. (LSF) 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
Laird Superfood, Inc. (LSF) Bundle
Evaluate Laird Superfood, Inc.'s (LSF) financial outlook like an expert! This (LSF) DCF Calculator provides you with pre-filled financials and the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your 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 | 13.1 | 26.0 | 36.8 | 35.8 | 34.2 | 45.6 | 60.7 | 80.9 | 107.8 | 143.6 |
Revenue Growth, % | 0 | 98.47 | 41.55 | -2.67 | -4.48 | 33.22 | 33.22 | 33.22 | 33.22 | 33.22 |
EBITDA | -8.2 | -12.5 | -23.0 | -22.2 | -10.4 | -24.2 | -32.2 | -42.9 | -57.1 | -76.1 |
EBITDA, % | -62.23 | -47.89 | -62.38 | -62.06 | -30.37 | -52.99 | -52.99 | -52.99 | -52.99 | -52.99 |
Depreciation | .3 | .5 | 1.0 | 2.2 | .3 | 1.3 | 1.7 | 2.2 | 3.0 | 4.0 |
Depreciation, % | 2.29 | 1.86 | 2.67 | 6.09 | 0.89462 | 2.76 | 2.76 | 2.76 | 2.76 | 2.76 |
EBIT | -8.5 | -12.9 | -23.9 | -24.4 | -10.7 | -25.4 | -33.9 | -45.1 | -60.1 | -80.0 |
EBIT, % | -64.52 | -49.75 | -65.05 | -68.16 | -31.26 | -55.75 | -55.75 | -55.75 | -55.75 | -55.75 |
Total Cash | 6.5 | 65.9 | 31.7 | 17.8 | 7.7 | 28.1 | 37.4 | 49.8 | 66.4 | 88.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .4 | .8 | 1.3 | 1.5 | 1.0 | 1.5 | 2.0 | 2.7 | 3.6 | 4.8 |
Account Receivables, % | 2.94 | 3.23 | 3.45 | 4.17 | 2.99 | 3.35 | 3.35 | 3.35 | 3.35 | 3.35 |
Inventories | 2.4 | 6.3 | 10.2 | 5.7 | 6.3 | 9.6 | 12.7 | 17.0 | 22.6 | 30.1 |
Inventories, % | 18.59 | 24.21 | 27.77 | 15.9 | 18.47 | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 |
Accounts Payable | .7 | 1.3 | .9 | 1.1 | 1.6 | 1.9 | 2.5 | 3.4 | 4.5 | 6.0 |
Accounts Payable, % | 5.53 | 5.06 | 2.41 | 3.02 | 4.81 | 4.17 | 4.17 | 4.17 | 4.17 | 4.17 |
Capital Expenditure | -2.4 | -1.1 | -2.2 | -1.2 | -.1 | -2.9 | -3.9 | -5.2 | -7.0 | -9.3 |
Capital Expenditure, % | -18.61 | -4.08 | -5.98 | -3.23 | -0.42082 | -6.46 | -6.46 | -6.46 | -6.46 | -6.46 |
Tax Rate, % | -0.14974 | -0.14974 | -0.14974 | -0.14974 | -0.14974 | -0.14974 | -0.14974 | -0.14974 | -0.14974 | -0.14974 |
EBITAT | -8.5 | -12.9 | -24.0 | -24.4 | -10.7 | -25.4 | -33.9 | -45.1 | -60.1 | -80.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -12.7 | -17.2 | -30.0 | -18.9 | -10.1 | -30.6 | -39.2 | -52.2 | -69.5 | -92.6 |
WACC, % | 14.87 | 14.87 | 14.87 | 14.87 | 14.87 | 14.87 | 14.87 | 14.87 | 14.87 | 14.87 |
PV UFCF | ||||||||||
SUM PV UFCF | -176.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -94 | |||||||||
Terminal Value | -734 | |||||||||
Present Terminal Value | -367 | |||||||||
Enterprise Value | -544 | |||||||||
Net Debt | -7 | |||||||||
Equity Value | -537 | |||||||||
Diluted Shares Outstanding, MM | 9 | |||||||||
Equity Value Per Share | -57.71 |
What You Will Get
- Real Laird Superfood Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Laird Superfood, Inc. (LSF).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit LSF's unique financial model.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Laird Superfood’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to LSF.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Laird Superfood, Inc. (LSF).
Key Features
- Real-Life LSF Data: Pre-filled with Laird Superfood’s historical financials and future growth projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures to fit your analysis.
- Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop various forecasting scenarios to explore different valuation possibilities.
- User-Friendly Design: Intuitive, organized, and suitable for both professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Laird Superfood's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Laird Superfood, Inc. (LSF)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: Laird Superfood’s historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Testing: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Health Enthusiasts: Discover how to incorporate superfoods into your diet for improved wellness.
- Nutritionists: Utilize our products to enhance dietary plans and client recommendations.
- Investors: Evaluate your investment strategies and assess the market potential of Laird Superfood, Inc. (LSF).
- Chefs: Experiment with premium superfood ingredients to elevate your culinary creations.
- Fitness Professionals: Educate clients on the benefits of superfoods and how they can support an active lifestyle.
What the Template Contains
- Pre-Filled Data: Contains Laird Superfood's historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Assess Laird Superfood's profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing key valuation outcomes.