Alico, Inc. (ALCO) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Alico, Inc. (ALCO) Bundle
Engineered for accuracy, our Alico, Inc. (ALCO) DCF Calculator empowers you to evaluate Alico's valuation using up-to-date financial data, offering complete flexibility to modify all essential parameters for enhanced projections.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 92.5 | 108.6 | 91.9 | 39.8 | 46.6 | 54.9 | 64.6 | 75.9 | 89.3 | 105.1 |
Revenue Growth, % | 0 | 17.36 | -15.31 | -56.66 | 17.06 | 17.65 | 17.65 | 17.65 | 17.65 | 17.65 |
EBITDA | 51.9 | 29.6 | 31.5 | 22.9 | 29.5 | 26.1 | 30.8 | 36.2 | 42.6 | 50.1 |
EBITDA, % | 56.08 | 27.23 | 34.27 | 57.36 | 63.25 | 47.64 | 47.64 | 47.64 | 47.64 | 47.64 |
Depreciation | 14.5 | 15.1 | 15.2 | 15.5 | 15.0 | 12.9 | 15.1 | 17.8 | 20.9 | 24.6 |
Depreciation, % | 15.7 | 13.93 | 16.56 | 38.87 | 32.18 | 23.45 | 23.45 | 23.45 | 23.45 | 23.45 |
EBIT | 37.4 | 14.4 | 16.3 | 7.4 | 14.5 | 13.3 | 15.6 | 18.4 | 21.6 | 25.4 |
EBIT, % | 40.38 | 13.3 | 17.7 | 18.5 | 31.07 | 24.19 | 24.19 | 24.19 | 24.19 | 24.19 |
Total Cash | 3.2 | .9 | .9 | 1.1 | 3.2 | 1.6 | 1.9 | 2.2 | 2.6 | 3.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 5.1 | 9.3 | 1.4 | 1.9 | .8 | 2.4 | 2.9 | 3.4 | 4.0 | 4.7 |
Account Receivables, % | 5.54 | 8.6 | 1.57 | 4.8 | 1.65 | 4.43 | 4.43 | 4.43 | 4.43 | 4.43 |
Inventories | 40.9 | 43.4 | 27.7 | 52.5 | 30.1 | 30.6 | 36.0 | 42.3 | 49.8 | 58.6 |
Inventories, % | 44.16 | 39.96 | 30.11 | 131.71 | 64.5 | 55.74 | 55.74 | 55.74 | 55.74 | 55.74 |
Accounts Payable | 3.5 | 7.3 | 3.4 | 6.3 | 3.4 | 4.1 | 4.8 | 5.7 | 6.7 | 7.8 |
Accounts Payable, % | 3.82 | 6.7 | 3.66 | 15.84 | 7.21 | 7.45 | 7.45 | 7.45 | 7.45 | 7.45 |
Capital Expenditure | -22.2 | -41.2 | -20.9 | -16.7 | -17.9 | -18.1 | -21.3 | -25.0 | -29.4 | -34.6 |
Capital Expenditure, % | -23.96 | -37.98 | -22.69 | -41.8 | -38.31 | -32.95 | -32.95 | -32.95 | -32.95 | -32.95 |
Tax Rate, % | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 |
EBITAT | 28.2 | 10.9 | 15.7 | 5.5 | 9.2 | 10.2 | 12.0 | 14.1 | 16.6 | 19.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -21.9 | -18.3 | 29.7 | -18.0 | 27.0 | 3.6 | .8 | .9 | 1.1 | 1.3 |
WACC, % | 6.67 | 6.67 | 6.97 | 6.66 | 6.51 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 |
PV UFCF | ||||||||||
SUM PV UFCF | 6.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1 | |||||||||
Terminal Value | 28 | |||||||||
Present Terminal Value | 20 | |||||||||
Enterprise Value | 27 | |||||||||
Net Debt | 89 | |||||||||
Equity Value | -62 | |||||||||
Diluted Shares Outstanding, MM | 8 | |||||||||
Equity Value Per Share | -8.18 |
What You Will Get
- Real ALCO Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Alico, Inc.'s future performance.
- User-Friendly Design: Crafted for professionals while remaining approachable for newcomers.
Key Features
- Accurate Alico Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Tailored Forecast Assumptions: Modify highlighted cells for variables such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic adjustments to DCF, Net Present Value (NPV), and cash flow evaluations.
- User-Friendly Dashboard: Intuitive charts and summaries for clear visualization of your valuation findings.
- Designed for All Skill Levels: A straightforward, user-centric layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Alico, Inc. (ALCO).
- Step 2: Review Alico’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 adjust assumptions.
- Step 5: Analyze the outputs and utilize the results for investment decisions.
Why Choose This Calculator for Alico, Inc. (ALCO)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Watch as Alico’s valuation updates instantly with your input changes.
- Pre-Loaded Data: Comes equipped with Alico’s latest financial metrics for swift evaluations.
- Professional Endorsement: Favored by investors and analysts for making educated choices.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive valuation models for Alico, Inc. (ALCO) to enhance portfolio decisions.
- Corporate Finance Departments: Evaluate valuation scenarios to inform strategic planning for Alico, Inc. (ALCO).
- Financial Consultants: Deliver precise valuation analyses for clients interested in Alico, Inc. (ALCO).
- Academic Professionals and Students: Utilize real-time data to learn and teach financial modeling techniques related to Alico, Inc. (ALCO).
- Agriculture Sector Enthusiasts: Gain insights into how agricultural companies like Alico, Inc. (ALCO) are appraised in the marketplace.
What the Template Contains
- Pre-Filled Data: Includes Alico, Inc.'s historical financials and forecasts.
- 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: Analyze Alico, Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.