|
Local Bounti Corporation (LOCL) DCF Valuation
US | Consumer Defensive | Agricultural Farm Products | NYSE
|
- ✓ 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
Local Bounti Corporation (LOCL) Bundle
Explore the financial potential of Local Bounti Corporation (LOCL) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Local Bounti Corporation (LOCL) and inform your investment decisions.
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 | .0 | .1 | .6 | 19.5 | 27.6 | 44.2 | 70.9 | 113.7 | 182.3 | 292.4 |
| Revenue Growth, % | 0 | 0 | 678.05 | 2952.35 | 41.51 | 60.38 | 60.38 | 60.38 | 60.38 | 60.38 |
| EBITDA | .0 | -7.6 | -50.3 | -83.9 | -85.1 | -26.5 | -42.5 | -68.2 | -109.4 | -175.4 |
| EBITDA, % | 100 | -9268.29 | -7880.25 | -430.88 | -308.95 | -60 | -60 | -60 | -60 | -60 |
| Depreciation | 3.4 | .3 | .7 | 10.4 | 13.1 | 35.5 | 56.9 | 91.2 | 146.3 | 234.6 |
| Depreciation, % | 100 | 350 | 107.21 | 53.54 | 47.65 | 80.24 | 80.24 | 80.24 | 80.24 | 80.24 |
| EBIT | -3.4 | -7.9 | -51.0 | -94.3 | -98.3 | -26.5 | -42.5 | -68.2 | -109.4 | -175.4 |
| EBIT, % | 100 | -9618.29 | -7987.46 | -484.43 | -356.61 | -60 | -60 | -60 | -60 | -60 |
| Total Cash | 2.1 | .0 | 96.7 | 13.7 | 10.3 | 32.0 | 51.4 | 82.4 | 132.2 | 212.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .3 | .1 | 2.7 | 3.1 | 21.4 | 34.3 | 55.1 | 88.3 | 141.6 |
| Account Receivables, % | 100 | 406.1 | 17.24 | 13.82 | 11.17 | 48.45 | 48.45 | 48.45 | 48.45 | 48.45 |
| Inventories | .0 | .2 | .9 | 3.6 | 4.2 | 29.5 | 47.3 | 75.9 | 121.7 | 195.1 |
| Inventories, % | 100 | 296.34 | 144.51 | 18.46 | 15.28 | 66.75 | 66.75 | 66.75 | 66.75 | 66.75 |
| Accounts Payable | .1 | .2 | 1.9 | 13.8 | 14.6 | 37.5 | 60.1 | 96.3 | 154.5 | 247.8 |
| Accounts Payable, % | 100 | 214.63 | 299.69 | 70.64 | 53.13 | 84.75 | 84.75 | 84.75 | 84.75 | 84.75 |
| Capital Expenditure | -3.7 | -3.4 | -29.7 | -81.8 | -162.3 | -35.4 | -56.7 | -90.9 | -145.8 | -233.9 |
| Capital Expenditure, % | 100 | -4173.17 | -4649.84 | -420.22 | -588.83 | -80 | -80 | -80 | -80 | -80 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -3.4 | -8.4 | -50.7 | -85.5 | -98.3 | -26.0 | -41.7 | -66.8 | -107.2 | -171.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -3.6 | -12.1 | -78.4 | -150.3 | -247.5 | -46.7 | -49.6 | -79.6 | -127.7 | -204.7 |
| WACC, % | 8.26 | 8.26 | 8.22 | 7.56 | 8.26 | 8.11 | 8.11 | 8.11 | 8.11 | 8.11 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -380.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -209 | |||||||||
| Terminal Value | -3,416 | |||||||||
| Present Terminal Value | -2,313 | |||||||||
| Enterprise Value | -2,694 | |||||||||
| Net Debt | 317 | |||||||||
| Equity Value | -3,011 | |||||||||
| Diluted Shares Outstanding, MM | 8 | |||||||||
| Equity Value Per Share | -379.00 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-populated financials for Local Bounti Corporation (LOCL).
- Real-Time Data: Access to historical performance data and forward-looking projections (highlighted in the yellow cells).
- Flexible Forecasting: Modify key assumptions such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Instant Calculations: Quickly observe how your inputs affect the valuation of Local Bounti Corporation (LOCL).
- Professional Resource: Designed for use by investors, CFOs, consultants, and financial analysts.
- User-Friendly Interface: Organized for simplicity and ease of navigation, complete with step-by-step guidance.
Key Features
- 🔍 Real-Life LOCL Financials: Pre-filled historical and projected data for Local Bounti Corporation (LOCL).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Local Bounti’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Local Bounti’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 for Local Bounti Corporation (LOCL).
- Step 2: Review the pre-filled financial data and forecasts for Local Bounti Corporation (LOCL).
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Local Bounti Corporation (LOCL)?
- Accuracy: Utilizes actual financial data from Local Bounti Corporation for precise calculations.
- Flexibility: Allows users to easily adjust and test various inputs as needed.
- Time-Saving: Eliminate the need to create a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and standards expected at the CFO level.
- User-Friendly: Intuitive interface designed for users of all financial expertise levels.
Who Should Use This Product?
- Professional Investors: Create comprehensive and accurate valuation models for assessing Local Bounti Corporation (LOCL).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Local Bounti Corporation (LOCL).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Agriculture Enthusiasts: Gain insights into how agricultural companies like Local Bounti Corporation (LOCL) are valued in the market.
What the Template Contains
- Historical Data: Includes Local Bounti Corporation’s (LOCL) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Local Bounti Corporation’s (LOCL) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Local Bounti Corporation’s (LOCL) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.