Live Oak Bancshares, Inc. (LOB) 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
Live Oak Bancshares, Inc. (LOB) Bundle
As an investor or analyst, the Live Oak Bancshares, Inc. (LOB) DCF Calculator is your go-to tool for accurate valuation. Loaded with real data on Live Oak Bancshares, Inc., you can adjust forecasts and observe the effects in real-time.
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 | 206.0 | 284.6 | 442.0 | 391.9 | 119.5 | 123.3 | 127.2 | 131.2 | 135.3 | 139.6 |
| Revenue Growth, % | 0 | 38.18 | 55.29 | -11.34 | -69.51 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 |
| EBITDA | 42.8 | 69.1 | 232.2 | 231.1 | 104.1 | 60.1 | 62.0 | 63.9 | 65.9 | 68.0 |
| EBITDA, % | 20.79 | 24.27 | 52.53 | 58.98 | 87.12 | 48.74 | 48.74 | 48.74 | 48.74 | 48.74 |
| Depreciation | 20.0 | 21.7 | 21.4 | 20.8 | 21.3 | 11.2 | 11.5 | 11.9 | 12.2 | 12.6 |
| Depreciation, % | 9.69 | 7.62 | 4.83 | 5.3 | 17.8 | 9.05 | 9.05 | 9.05 | 9.05 | 9.05 |
| EBIT | 22.9 | 47.4 | 210.8 | 210.3 | 82.8 | 48.9 | 50.5 | 52.1 | 53.7 | 55.4 |
| EBIT, % | 11.1 | 16.65 | 47.69 | 53.67 | 69.32 | 39.69 | 39.69 | 39.69 | 39.69 | 39.69 |
| Total Cash | 674.0 | 1,053.8 | 1,098.0 | 1,299.0 | 1,708.7 | 123.3 | 127.2 | 131.2 | 135.3 | 139.6 |
| 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 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capital Expenditure | -37.2 | -21.0 | -3.1 | -43.8 | -46.8 | -18.9 | -19.5 | -20.1 | -20.7 | -21.4 |
| Capital Expenditure, % | -18.06 | -7.37 | -0.69731 | -11.17 | -39.2 | -15.3 | -15.3 | -15.3 | -15.3 | -15.3 |
| Tax Rate, % | 10.78 | 10.78 | 10.78 | 10.78 | 10.78 | 10.78 | 10.78 | 10.78 | 10.78 | 10.78 |
| EBITAT | 17.6 | 59.5 | 167.0 | 176.2 | 73.9 | 42.0 | 43.3 | 44.7 | 46.1 | 47.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | .3 | 60.2 | 185.3 | 153.2 | 48.3 | 34.3 | 35.4 | 36.5 | 37.6 | 38.8 |
| WACC, % | 26.61 | 31.02 | 27.07 | 27.93 | 28.97 | 28.32 | 28.32 | 28.32 | 28.32 | 28.32 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 90.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 40 | |||||||||
| Terminal Value | 150 | |||||||||
| Present Terminal Value | 43 | |||||||||
| Enterprise Value | 134 | |||||||||
| Net Debt | -559 | |||||||||
| Equity Value | 693 | |||||||||
| Diluted Shares Outstanding, MM | 45 | |||||||||
| Equity Value Per Share | 15.37 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real LOB financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Live Oak Bancshares, Inc.'s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Accurate Live Oak Financials: Access reliable pre-loaded historical data and future forecasts for Live Oak Bancshares, Inc. (LOB).
- Customizable Forecast Inputs: Modify highlighted cells for key metrics like WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to help visualize your valuation outcomes.
- Designed for All Users: A straightforward, easy-to-navigate layout suitable for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Live Oak Bancshares, Inc.'s (LOB) preloaded data.
- 2. Adjust Assumptions: Modify essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates the intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Present with Assurance: Share professional valuation insights to bolster your decision-making.
Why Choose This Calculator for Live Oak Bancshares, Inc. (LOB)?
- Accuracy: Utilizes real Live Oak financials to ensure data precision.
- Flexibility: Tailored for users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexity of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability standards of CFOs in mind.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Professional Investors: Create comprehensive and accurate valuation models for portfolio assessment of Live Oak Bancshares, Inc. (LOB).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding Live Oak Bancshares, Inc. (LOB).
- Students and Educators: Utilize real-world financial data to enhance learning and practice in financial modeling.
- Banking Sector Enthusiasts: Gain insights into how financial institutions like Live Oak Bancshares, Inc. (LOB) are valued in the marketplace.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Live Oak Bancshares, Inc. (LOB) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Live Oak Bancshares, Inc. (LOB).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.