Banco Bradesco S.A. (BBDO) 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
Banco Bradesco S.A. (BBDO) Bundle
Evaluate Banco Bradesco S.A.'s financial outlook with expert precision! This (BBDO) DCF Calculator provides you with pre-filled financial data and 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 | 612,656.7 | 508,291.2 | 632,080.1 | 655,771.7 | 618,785.6 | 627,181.2 | 635,690.7 | 644,315.7 | 653,057.6 | 661,918.2 |
| Revenue Growth, % | 0 | -17.03 | 24.35 | 3.75 | -5.64 | 1.36 | 1.36 | 1.36 | 1.36 | 1.36 |
| EBITDA | -.3 | 68,766.8 | 238,354.0 | .0 | .0 | 64,271.6 | 65,143.6 | 66,027.4 | 66,923.3 | 67,831.3 |
| EBITDA, % | -0.000042505606 | 13.53 | 37.71 | 0 | 0 | 10.25 | 10.25 | 10.25 | 10.25 | 10.25 |
| Depreciation | 36,197.3 | 36,538.3 | 35,624.2 | 34,947.4 | 40,235.2 | 38,338.6 | 38,858.8 | 39,386.0 | 39,920.4 | 40,462.0 |
| Depreciation, % | 5.91 | 7.19 | 5.64 | 5.33 | 6.5 | 6.11 | 6.11 | 6.11 | 6.11 | 6.11 |
| EBIT | -36,197.5 | 32,228.5 | 202,729.8 | -34,947.4 | -40,235.2 | 25,933.0 | 26,284.8 | 26,641.4 | 27,002.9 | 27,369.3 |
| EBIT, % | -5.91 | 6.34 | 32.07 | -5.33 | -6.5 | 4.13 | 4.13 | 4.13 | 4.13 | 4.13 |
| Total Cash | 117,177.8 | 147,146.3 | 131,344.2 | 176,178.5 | 256,324.8 | 172,029.2 | 174,363.3 | 176,729.0 | 179,126.8 | 181,557.2 |
| 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 | -3,544,549.0 | -4,466,629.1 | -1,445,510.3 | -1,552,036.5 | .0 | -501,745.0 | -508,552.6 | -515,452.5 | -522,446.1 | -529,534.6 |
| Inventories, % | -578.55 | -878.75 | -228.69 | -236.67 | 0 | -80 | -80 | -80 | -80 | -80 |
| 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 | -32,863.3 | -26,316.0 | -27,214.5 | -58,082.3 | -12,052.2 | -32,176.6 | -32,613.2 | -33,055.7 | -33,504.2 | -33,958.8 |
| Capital Expenditure, % | -5.36 | -5.18 | -4.31 | -8.86 | -1.95 | -5.13 | -5.13 | -5.13 | -5.13 | -5.13 |
| Tax Rate, % | -39.6 | -39.6 | -39.6 | -39.6 | -39.6 | -39.6 | -39.6 | -39.6 | -39.6 | -39.6 |
| EBITAT | -56,870.0 | 125,241.9 | 142,994.9 | -30,123.8 | -56,170.2 | 23,688.8 | 24,010.3 | 24,336.0 | 24,666.2 | 25,000.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 3,491,012.9 | 1,057,544.3 | -2,869,714.2 | 53,267.4 | -1,580,023.7 | 531,595.8 | 37,063.4 | 37,566.3 | 38,076.0 | 38,592.6 |
| WACC, % | 48.37 | 48.37 | 34.25 | 41.76 | 48.37 | 44.22 | 44.22 | 44.22 | 44.22 | 44.22 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 413,920.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 39,364 | |||||||||
| Terminal Value | 93,230 | |||||||||
| Present Terminal Value | 14,941 | |||||||||
| Enterprise Value | 428,862 | |||||||||
| Net Debt | 1,634,874 | |||||||||
| Equity Value | -1,206,012 | |||||||||
| Diluted Shares Outstanding, MM | 10,642 | |||||||||
| Equity Value Per Share | -113.32 |
What You Will Get
- Real Banco Bradesco Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Banco Bradesco S.A. (BBDO).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Banco Bradesco S.A. (BBDO).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Banco Bradesco S.A. (BBDO)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Banco Bradesco S.A. (BBDO).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Banco Bradesco S.A. (BBDO).
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as loan growth, interest rates, and operational costs.
- Instant DCF Valuation: Provides real-time calculations for intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages Banco Bradesco S.A.'s actual financial data for trustworthy valuation results.
- Effortless Scenario Analysis: Evaluate various scenarios and analyze their impacts with ease.
- Efficiency Booster: Streamline the valuation process without the need for intricate model development.
How It Works
- Download: Access the ready-to-use Excel file with Banco Bradesco S.A.'s (BBDO) financial data.
- Customize: Adjust forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations update in real-time.
- Test Scenarios: Create multiple projections and compare outcomes instantly.
- Make Decisions: Use the valuation results to guide your investment strategy.
Why Choose This Calculator for Banco Bradesco S.A. (BBDO)?
- Designed for Financial Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Comprehensive Data: Banco Bradesco's historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance helps navigate through the calculations seamlessly.
Who Should Use This Product?
- Investors: Make informed decisions by accurately estimating Banco Bradesco S.A.'s (BBDO) fair value.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily customize the template for valuation reports tailored to client needs.
- Entrepreneurs: Acquire valuable insights into financial modeling practices employed by leading financial institutions.
- Educators: Implement it as a teaching resource to illustrate various valuation methodologies.
What the Template Contains
- Preloaded BBDO 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.