Lakeland Financial Corporation (LKFN) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Lakeland Financial Corporation (LKFN) Bundle
Explore Lakeland Financial Corporation's (LKFN) financial future with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and costs to uncover the intrinsic value of Lakeland Financial Corporation (LKFN) and refine your investment strategy.
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 | 189.6 | 198.0 | 210.1 | 231.9 | 241.0 | 256.0 | 271.9 | 288.8 | 306.7 | 325.8 |
| Revenue Growth, % | 0 | 4.4 | 6.14 | 10.37 | 3.93 | 6.21 | 6.21 | 6.21 | 6.21 | 6.21 |
| EBITDA | -.6 | -1.7 | 121.0 | 131.0 | .0 | 57.8 | 61.4 | 65.2 | 69.3 | 73.6 |
| EBITDA, % | -0.33643 | -0.86218 | 57.61 | 56.48 | 0 | 22.58 | 22.58 | 22.58 | 22.58 | 22.58 |
| Depreciation | 5.9 | 6.0 | 6.1 | 6.0 | 6.2 | 7.3 | 7.7 | 8.2 | 8.7 | 9.3 |
| Depreciation, % | 3.13 | 3.05 | 2.91 | 2.6 | 2.56 | 2.85 | 2.85 | 2.85 | 2.85 | 2.85 |
| EBIT | -6.6 | -7.7 | 114.9 | 125.0 | -6.2 | 50.5 | 53.6 | 57.0 | 60.5 | 64.3 |
| EBIT, % | -3.46 | -3.91 | 54.7 | 53.89 | -2.56 | 19.73 | 19.73 | 19.73 | 19.73 | 19.73 |
| Total Cash | 707.6 | 984.8 | 2,081.8 | 1,315.8 | 151.8 | 237.1 | 251.8 | 267.4 | 284.0 | 301.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Inventories | -115.2 | -269.1 | -701.1 | -158.4 | .0 | -168.5 | -178.9 | -190.0 | -201.8 | -214.4 |
| Inventories, % | -60.74 | -135.92 | -333.65 | -68.29 | 0 | -65.81 | -65.81 | -65.81 | -65.81 | -65.81 |
| Accounts Payable | 11.6 | 6.0 | 2.6 | 3.2 | 20.9 | 10.5 | 11.1 | 11.8 | 12.5 | 13.3 |
| Accounts Payable, % | 6.12 | 3.01 | 1.25 | 1.37 | 8.67 | 4.08 | 4.08 | 4.08 | 4.08 | 4.08 |
| Capital Expenditure | -8.0 | -5.7 | -6.2 | -4.8 | -6.0 | -7.5 | -7.9 | -8.4 | -9.0 | -9.5 |
| Capital Expenditure, % | -4.22 | -2.89 | -2.93 | -2.08 | -2.49 | -2.92 | -2.92 | -2.92 | -2.92 | -2.92 |
| Tax Rate, % | 15.01 | 15.01 | 15.01 | 15.01 | 15.01 | 15.01 | 15.01 | 15.01 | 15.01 | 15.01 |
| EBITAT | -5.3 | -6.3 | 93.7 | 103.7 | -5.2 | 41.6 | 44.2 | 46.9 | 49.8 | 52.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 119.4 | 142.3 | 522.3 | -437.3 | -145.7 | 199.4 | 55.1 | 58.5 | 62.1 | 66.0 |
| WACC, % | 13.82 | 13.83 | 13.85 | 13.97 | 14.13 | 13.92 | 13.92 | 13.92 | 13.92 | 13.92 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 328.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 67 | |||||||||
| Terminal Value | 565 | |||||||||
| Present Terminal Value | 294 | |||||||||
| Enterprise Value | 623 | |||||||||
| Net Debt | -102 | |||||||||
| Equity Value | 725 | |||||||||
| Diluted Shares Outstanding, MM | 26 | |||||||||
| Equity Value Per Share | 28.17 |
What You Will Receive
- Comprehensive Financial Model: Lakeland Financial Corporation’s (LKFN) actual data provides an accurate DCF valuation.
- Complete Forecast Customization: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates guarantee you see the results instantly as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth financial forecasts.
Key Features
- Comprehensive DCF Model: Features both unlevered and levered DCF valuation frameworks tailored for Lakeland Financial Corporation (LKFN).
- WACC Tool: Pre-configured Weighted Average Cost of Capital calculator with adjustable parameters.
- Customizable Forecast Inputs: Easily adjust growth projections, capital expenditures, and discount rates.
- Integrated Financial Metrics: Evaluate profitability, leverage, and efficiency ratios specific to Lakeland Financial Corporation (LKFN).
- Visual Dashboard and Graphs: Graphical representations provide a clear overview of essential valuation indicators for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based LKFN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other parameters.
- Instant Calculations: The model automatically recalculates Lakeland Financial Corporation’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis decisions.
Why Choose This Calculator for Lakeland Financial Corporation (LKFN)?
- User-Friendly Interface: Suitable for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Lakeland’s valuation as you modify inputs.
- Preloaded Data: Comes with Lakeland’s actual financial information for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Accurately assess Lakeland Financial Corporation’s (LKFN) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for financial reporting and analysis related to Lakeland Financial Corporation (LKFN).
- Consultants: Efficiently customize the template for valuation reports tailored to clients interested in Lakeland Financial Corporation (LKFN).
- Entrepreneurs: Acquire knowledge of financial modeling techniques employed by leading financial institutions like Lakeland Financial Corporation (LKFN).
- Educators: Implement it as a pedagogical resource to illustrate valuation methods associated with Lakeland Financial Corporation (LKFN).
What the Template Contains
- Preloaded LKFN 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.