TowneBank (TOWN) 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
TowneBank (TOWN) Bundle
Evaluate TowneBank's financial outlook like an expert! This (TOWN) DCF Calculator provides you with pre-filled financial data and the 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 | 563.2 | 662.2 | 679.0 | 686.4 | 675.4 | 708.5 | 743.3 | 779.7 | 817.9 | 858.0 |
Revenue Growth, % | 0 | 17.58 | 2.53 | 1.09 | -1.59 | 4.9 | 4.9 | 4.9 | 4.9 | 4.9 |
EBITDA | 205.6 | 230.4 | 311.0 | 265.7 | 220.4 | 267.1 | 280.1 | 293.9 | 308.3 | 323.4 |
EBITDA, % | 36.51 | 34.79 | 45.8 | 38.72 | 32.64 | 37.69 | 37.69 | 37.69 | 37.69 | 37.69 |
Depreciation | 28.4 | 29.1 | 28.8 | 28.7 | 34.2 | 32.5 | 34.1 | 35.8 | 37.5 | 39.3 |
Depreciation, % | 5.05 | 4.39 | 4.24 | 4.18 | 5.07 | 4.59 | 4.59 | 4.59 | 4.59 | 4.59 |
EBIT | 177.2 | 201.3 | 282.2 | 237.1 | 186.2 | 234.6 | 246.1 | 258.1 | 270.8 | 284.0 |
EBIT, % | 31.46 | 30.4 | 41.56 | 34.54 | 27.57 | 33.11 | 33.11 | 33.11 | 33.11 | 33.11 |
Total Cash | 1,883.9 | 3,232.5 | 5,102.8 | 152.6 | 189.0 | 496.3 | 520.6 | 546.1 | 572.9 | 601.0 |
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 | -36.7 | -45.8 | -31.2 | -52.3 | -44.1 | -45.6 | -47.8 | -50.2 | -52.6 | -55.2 |
Capital Expenditure, % | -6.52 | -6.91 | -4.6 | -7.62 | -6.53 | -6.44 | -6.44 | -6.44 | -6.44 | -6.44 |
Tax Rate, % | 17.46 | 17.46 | 17.46 | 17.46 | 17.46 | 17.46 | 17.46 | 17.46 | 17.46 | 17.46 |
EBITAT | 139.5 | 145.5 | 217.2 | 189.0 | 153.7 | 183.1 | 192.1 | 201.5 | 211.3 | 221.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 131.2 | 128.8 | 214.8 | 165.4 | 143.8 | 170.0 | 178.3 | 187.0 | 196.2 | 205.8 |
WACC, % | 13.84 | 13.31 | 13.69 | 13.92 | 14.15 | 13.78 | 13.78 | 13.78 | 13.78 | 13.78 |
PV UFCF | ||||||||||
SUM PV UFCF | 639.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 210 | |||||||||
Terminal Value | 1,782 | |||||||||
Present Terminal Value | 934 | |||||||||
Enterprise Value | 1,573 | |||||||||
Net Debt | -636 | |||||||||
Equity Value | 2,209 | |||||||||
Diluted Shares Outstanding, MM | 75 | |||||||||
Equity Value Per Share | 29.59 |
What You Will Get
- Real TOWN Financial Data: Pre-filled with TowneBank’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See TowneBank’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Financial Data: TowneBank’s (TOWN) historical financial statements and anticipated forecasts.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Observe TowneBank’s (TOWN) intrinsic value update instantly.
- Intuitive Visualizations: Dashboard charts 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 prebuilt Excel template featuring TowneBank’s (TOWN) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including TowneBank’s (TOWN) intrinsic value.
- Step 5: Make informed investment choices or create reports based on the outputs.
Why Choose This Calculator for TowneBank (TOWN)?
- Accuracy: Reliable TowneBank financials guarantee precise data.
- Flexibility: Built to allow users to easily test and adjust inputs.
- Time-Saving: Avoid the complexity of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Accurately assess TowneBank’s fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis.
- Consultants: Efficiently customize the template for valuation reports for clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading financial institutions.
- Educators: Implement it as a teaching resource to illustrate valuation methodologies.
What the Template Contains
- Preloaded TOWN 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.