Banco de Chile (BCH) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Banco de Chile (BCH) Bundle
Enhance your investment strategies with the Banco de Chile (BCH) DCF Calculator! Analyze actual financial data, adjust growth projections and expenses, and instantly observe how these modifications affect the intrinsic value of Banco de Chile (BCH).
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 | 2,022.6 | 1,943.3 | 2,236.3 | 3,125.2 | 2,846.7 | 3,145.5 | 3,475.8 | 3,840.6 | 4,243.8 | 4,689.3 |
| Revenue Growth, % | 0 | -3.92 | 15.08 | 39.75 | -8.91 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 |
| EBITDA | 836.2 | 674.7 | 1,056.9 | 1,775.8 | .0 | 1,133.3 | 1,252.3 | 1,383.7 | 1,529.0 | 1,689.5 |
| EBITDA, % | 41.34 | 34.72 | 47.26 | 56.82 | 0 | 36.03 | 36.03 | 36.03 | 36.03 | 36.03 |
| Depreciation | 71.3 | 74.2 | 77.7 | 85.2 | 93.4 | 105.8 | 116.9 | 129.2 | 142.8 | 157.8 |
| Depreciation, % | 3.53 | 3.82 | 3.47 | 2.73 | 3.28 | 3.36 | 3.36 | 3.36 | 3.36 | 3.36 |
| EBIT | 764.9 | 600.5 | 979.3 | 1,690.6 | -93.4 | 1,027.5 | 1,135.3 | 1,254.5 | 1,386.2 | 1,531.7 |
| EBIT, % | 37.81 | 30.9 | 43.79 | 54.1 | -3.28 | 32.66 | 32.66 | 32.66 | 32.66 | 32.66 |
| Total Cash | 4,865.3 | 4,486.3 | 7,725.4 | 7,589.9 | 2,913.0 | 3,145.5 | 3,475.8 | 3,840.6 | 4,243.8 | 4,689.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 107.6 | 121.9 | 1,795.8 | 2,307.7 | 2,578.5 | 1,612.5 | 1,781.7 | 1,968.8 | 2,175.5 | 2,403.8 |
| Account Receivables, % | 5.32 | 6.27 | 80.3 | 73.84 | 90.58 | 51.26 | 51.26 | 51.26 | 51.26 | 51.26 |
| Inventories | -7,960.3 | -10,729.3 | -11,451.8 | -11,028.6 | -5,560.0 | -3,145.5 | -3,475.8 | -3,840.6 | -4,243.8 | -4,689.3 |
| Inventories, % | -393.56 | -552.11 | -512.08 | -352.89 | -195.32 | -100 | -100 | -100 | -100 | -100 |
| Accounts Payable | 234.1 | 276.3 | 325.9 | 383.9 | 340.8 | 406.5 | 449.2 | 496.3 | 548.4 | 606.0 |
| Accounts Payable, % | 11.57 | 14.22 | 14.57 | 12.28 | 11.97 | 12.92 | 12.92 | 12.92 | 12.92 | 12.92 |
| Capital Expenditure | -66.9 | -48.5 | -66.6 | -79.0 | -87.7 | -90.5 | -100.0 | -110.5 | -122.1 | -134.9 |
| Capital Expenditure, % | -3.31 | -2.5 | -2.98 | -2.53 | -3.08 | -2.88 | -2.88 | -2.88 | -2.88 | -2.88 |
| Tax Rate, % | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 |
| EBITAT | 594.7 | 409.4 | 799.3 | 1,450.5 | -75.6 | 810.4 | 895.5 | 989.5 | 1,093.3 | 1,208.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 8,685.9 | 3,232.0 | -91.3 | 579.4 | -5,852.4 | -557.0 | 1,116.0 | 1,233.1 | 1,362.6 | 1,505.6 |
| WACC, % | 5.45 | 5.44 | 5.45 | 5.45 | 5.45 | 5.45 | 5.45 | 5.45 | 5.45 | 5.45 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,784.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,536 | |||||||||
| Terminal Value | 44,549 | |||||||||
| Present Terminal Value | 34,171 | |||||||||
| Enterprise Value | 37,955 | |||||||||
| Net Debt | 7,680 | |||||||||
| Equity Value | 30,275 | |||||||||
| Diluted Shares Outstanding, MM | 101,017 | |||||||||
| Equity Value Per Share | 0.30 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real BCH financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Banco de Chile’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
- Real-Life BCH Data: Pre-filled with Banco de Chile’s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Download the Template: Get immediate access to the Excel-based BCH DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Banco de Chile’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Banco de Chile (BCH)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Banco de Chile (BCH).
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Banco de Chile’s intrinsic value and Net Present Value.
- Preloaded Financials: Historical and projected data provide reliable starting points for analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focusing on Banco de Chile (BCH).
Who Should Use This Product?
- Investors: Evaluate Banco de Chile’s valuation before making stock transactions.
- CFOs and Financial Analysts: Optimize valuation procedures and assess financial forecasts.
- Startup Founders: Understand the valuation methods applied to established banks like Banco de Chile.
- Consultants: Provide comprehensive valuation reports for clients in the financial sector.
- Students and Educators: Utilize real-time data to practice and instruct on valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Banco de Chile (BCH) 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 Banco de Chile (BCH).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.