TC Bancshares, Inc. (TCBC) 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
TC Bancshares, Inc. (TCBC) Bundle
Designed for accuracy, our TC Bancshares, Inc. (TCBC) DCF Calculator enables you to evaluate the valuation of TC Bancshares, Inc. using real-world financial data and offers complete flexibility to modify all essential parameters for enhanced 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 | 10.7 | 12.8 | 15.4 | .6 | 14.9 | 16.5 | 18.3 | 20.3 | 22.5 | 24.9 |
Revenue Growth, % | 0 | 19.02 | 20.75 | -96.42 | 2604.43 | 10.84 | 10.84 | 10.84 | 10.84 | 10.84 |
EBITDA | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Depreciation | .3 | .3 | .5 | .3 | .7 | 2.5 | 2.8 | 3.1 | 3.4 | 3.8 |
Depreciation, % | 2.87 | 2.7 | 3.02 | 63.14 | 4.6 | 15.27 | 15.27 | 15.27 | 15.27 | 15.27 |
EBIT | -.3 | -.3 | -.5 | -.3 | -.7 | -2.5 | -2.8 | -3.1 | -3.4 | -3.8 |
EBIT, % | -2.87 | -2.7 | -3.02 | -63.14 | -4.6 | -15.27 | -15.27 | -15.27 | -15.27 | -15.27 |
Total Cash | 55.1 | 53.4 | 81.0 | 68.6 | 25.0 | 16.5 | 18.3 | 20.3 | 22.5 | 24.9 |
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 | -33.4 | -47.6 | -46.5 | -28.0 | .0 | -13.2 | -14.6 | -16.2 | -18.0 | -19.9 |
Inventories, % | -311.64 | -373.31 | -301.67 | -5074.63 | 0 | -80 | -80 | -80 | -80 | -80 |
Accounts Payable | 5.5 | 6.5 | 4.8 | 4.5 | .0 | 7.7 | 8.6 | 9.5 | 10.5 | 11.6 |
Accounts Payable, % | 51.73 | 50.6 | 31.25 | 816.38 | 0 | 46.72 | 46.72 | 46.72 | 46.72 | 46.72 |
Capital Expenditure | -.2 | -.5 | -.1 | -.3 | -2.1 | -2.2 | -2.4 | -2.7 | -3.0 | -3.3 |
Capital Expenditure, % | -1.52 | -3.6 | -0.95649 | -46.28 | -14.26 | -13.32 | -13.32 | -13.32 | -13.32 | -13.32 |
Tax Rate, % | -143.25 | -143.25 | -143.25 | -143.25 | -143.25 | -143.25 | -143.25 | -143.25 | -143.25 | -143.25 |
EBITAT | -.2 | -.3 | -.4 | -.3 | -1.7 | -2.1 | -2.3 | -2.6 | -2.8 | -3.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 38.8 | 14.7 | -2.8 | -19.0 | -35.6 | 19.2 | .3 | .3 | .4 | .4 |
WACC, % | 10.11 | 10.96 | 10.08 | 9.8 | 11.77 | 10.54 | 10.54 | 10.54 | 10.54 | 10.54 |
PV UFCF | ||||||||||
SUM PV UFCF | 18.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 5 | |||||||||
Present Terminal Value | 3 | |||||||||
Enterprise Value | 21 | |||||||||
Net Debt | -12 | |||||||||
Equity Value | 33 | |||||||||
Diluted Shares Outstanding, MM | 5 | |||||||||
Equity Value Per Share | 6.96 |
What You Will Get
- Real TCBC Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on TC Bancshares, Inc.'s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive Financial Data: TC Bancshares, Inc.'s historical financial statements and pre-populated forecasts.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Observe TC Bancshares, Inc.'s intrinsic value update instantly.
- Intuitive Visualizations: Dashboard graphs showcase valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file for TC Bancshares, Inc. (TCBC).
- Step 2: Review TC Bancshares' pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as loan growth, cost of capital, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Evaluate the outputs and utilize the results for your investment strategies.
Why Choose TC Bancshares, Inc. (TCBC) Calculator?
- Accurate Data: Utilize real TC Bancshares financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Ready-made calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately assess TC Bancshares, Inc.'s (TCBC) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for TC Bancshares, Inc. (TCBC) financial reporting and analysis.
- Consultants: Efficiently customize the template for valuation reports tailored to TC Bancshares, Inc. (TCBC) clients.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading banks.
- Educators: Employ it as a teaching resource to illustrate valuation techniques relevant to TC Bancshares, Inc. (TCBC).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations specific to TC Bancshares, Inc. (TCBC).
- Real-World Data: TC Bancshares, Inc.'s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios for TC Bancshares, Inc. (TCBC).
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into TC Bancshares, Inc. (TCBC).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage tailored to TC Bancshares, Inc. (TCBC).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to TC Bancshares, Inc. (TCBC).