LendingClub Corporation (LC) 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
LendingClub Corporation (LC) Bundle
Evaluate LendingClub Corporation's (LC) financial outlook like an expert! This (LC) DCF Calculator comes with pre-populated financials and offers full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 731.9 | 304.9 | 802.4 | 1,166.5 | 864.6 | 996.8 | 1,149.2 | 1,324.9 | 1,527.4 | 1,760.9 |
| Revenue Growth, % | 0 | -58.35 | 163.21 | 45.38 | -25.88 | 15.29 | 15.29 | 15.29 | 15.29 | 15.29 |
| EBITDA | .0 | .0 | .0 | 218.4 | 107.0 | 62.0 | 71.5 | 82.4 | 95.0 | 109.5 |
| EBITDA, % | 0 | 0 | 0 | 18.72 | 12.38 | 6.22 | 6.22 | 6.22 | 6.22 | 6.22 |
| Depreciation | 872.4 | 605.0 | 802.6 | 1,086.1 | 47.2 | 794.6 | 916.0 | 1,056.1 | 1,217.5 | 1,403.7 |
| Depreciation, % | 119.2 | 198.46 | 100.03 | 93.11 | 5.46 | 79.71 | 79.71 | 79.71 | 79.71 | 79.71 |
| EBIT | -872.4 | -605.0 | -802.6 | -867.7 | 59.9 | -732.6 | -844.6 | -973.7 | -1,122.5 | -1,294.1 |
| EBIT, % | -119.2 | -198.46 | -100.03 | -74.38 | 6.92 | -73.49 | -73.49 | -73.49 | -73.49 | -73.49 |
| Total Cash | 514.7 | 667.2 | 950.7 | 1,402.7 | 2,872.8 | 937.6 | 1,081.0 | 1,246.2 | 1,436.7 | 1,656.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 31.9 | 15.4 | .0 | .0 | .0 | 18.8 | 21.7 | 25.0 | 28.8 | 33.2 |
| Account Receivables, % | 4.35 | 5.07 | 0 | 0 | 0 | 1.88 | 1.88 | 1.88 | 1.88 | 1.88 |
| Inventories | 565.5 | 628.5 | 614.4 | 1,093.6 | .0 | 692.9 | 798.9 | 921.0 | 1,061.8 | 1,224.1 |
| Inventories, % | 77.26 | 206.16 | 76.57 | 93.75 | 0 | 69.52 | 69.52 | 69.52 | 69.52 | 69.52 |
| Accounts Payable | 20.1 | 46.9 | 101.0 | 98.2 | 54.6 | 90.6 | 104.4 | 120.4 | 138.8 | 160.0 |
| Accounts Payable, % | 2.75 | 15.38 | 12.58 | 8.42 | 6.32 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 |
| Capital Expenditure | -50.7 | -31.1 | -34.4 | -69.5 | -59.5 | -68.3 | -78.8 | -90.8 | -104.7 | -120.7 |
| Capital Expenditure, % | -6.92 | -10.22 | -4.29 | -5.96 | -6.88 | -6.85 | -6.85 | -6.85 | -6.85 | -6.85 |
| Tax Rate, % | 28.71 | 28.71 | 28.71 | 28.71 | 28.71 | 28.71 | 28.71 | 28.71 | 28.71 | 28.71 |
| EBITAT | -868.3 | -604.7 | -808.5 | -1,642.5 | 42.7 | -689.8 | -795.2 | -916.8 | -1,056.9 | -1,218.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -623.8 | -50.7 | 43.3 | -1,107.8 | 1,080.4 | -639.2 | -52.9 | -60.9 | -70.3 | -81.0 |
| WACC, % | 27.95 | 28.01 | 28.02 | 28.02 | 23.86 | 27.17 | 27.17 | 27.17 | 27.17 | 27.17 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -616.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -83 | |||||||||
| Terminal Value | -328 | |||||||||
| Present Terminal Value | -99 | |||||||||
| Enterprise Value | -715 | |||||||||
| Net Debt | -1,195 | |||||||||
| Equity Value | 480 | |||||||||
| Diluted Shares Outstanding, MM | 108 | |||||||||
| Equity Value Per Share | 4.43 |
What You Will Get
- Real LendingClub Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for LendingClub Corporation (LC).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis of LendingClub Corporation (LC).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on LendingClub Corporation (LC)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to LendingClub Corporation (LC).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for LendingClub Corporation (LC).
Key Features
- Comprehensive Financial Data: LendingClub Corporation's historical financial reports and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, loan growth, and net interest margins.
- Real-Time Calculations: Instantly view LendingClub's intrinsic value as it updates dynamically.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered LendingClub Corporation (LC) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for LendingClub Corporation (LC)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose LendingClub Calculator?
- Save Time: Instantly access a ready-to-use DCF model without starting from scratch.
- Enhance Accuracy: Utilize dependable financial data and formulas to minimize valuation errors.
- Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
- User-Friendly: Intuitive charts and outputs simplify the analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize precision and functionality.
Who Should Use This Product?
- Investors: Accurately assess LendingClub Corporation’s (LC) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to LendingClub Corporation (LC).
- Consultants: Easily customize the template for valuation reports tailored to LendingClub Corporation (LC) clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading financial institutions like LendingClub Corporation (LC).
- Educators: Implement it as a teaching resource to illustrate valuation methodologies using LendingClub Corporation (LC) as a case study.
What the Template Contains
- Pre-Filled Data: Includes LendingClub Corporation’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 LendingClub Corporation’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.