Banco Santander-Chile (BSAC) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Banco Santander-Chile (BSAC) Bundle
As an investor or analyst, this (BSAC) DCF Calculator serves as your go-to resource for accurate valuation. Loaded with real data from Banco Santander-Chile, you can easily adjust forecasts and observe the effects in real-time.
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 | 1,925.9 | 2,058.1 | 2,293.3 | 2,222.9 | 1,489.5 | 1,423.3 | 1,360.1 | 1,299.7 | 1,241.9 | 1,186.7 |
| Revenue Growth, % | 0 | 6.87 | 11.42 | -3.07 | -32.99 | -4.44 | -4.44 | -4.44 | -4.44 | -4.44 |
| EBITDA | 814.5 | 768.3 | 1,206.9 | 1,029.6 | .0 | 508.3 | 485.7 | 464.2 | 443.5 | 423.8 |
| EBITDA, % | 42.29 | 37.33 | 52.63 | 46.32 | 0 | 35.71 | 35.71 | 35.71 | 35.71 | 35.71 |
| Depreciation | 107.0 | 110.4 | 123.1 | 131.1 | 145.0 | 90.9 | 86.8 | 83.0 | 79.3 | 75.8 |
| Depreciation, % | 5.56 | 5.36 | 5.37 | 5.9 | 9.73 | 6.38 | 6.38 | 6.38 | 6.38 | 6.38 |
| EBIT | 707.5 | 657.9 | 1,083.8 | 898.5 | -145.0 | 417.5 | 398.9 | 381.2 | 364.2 | 348.1 |
| EBIT, % | 36.74 | 31.97 | 47.26 | 40.42 | -9.73 | 29.33 | 29.33 | 29.33 | 29.33 | 29.33 |
| Total Cash | 8,578.9 | 11,258.1 | 11,233.3 | 11,401.7 | 10,605.5 | 1,423.3 | 1,360.1 | 1,299.7 | 1,241.9 | 1,186.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 273.1 | 205.3 | 341.4 | 513.4 | 385.5 | 250.6 | 239.4 | 228.8 | 218.6 | 208.9 |
| Account Receivables, % | 14.18 | 9.97 | 14.89 | 23.1 | 25.88 | 17.6 | 17.6 | 17.6 | 17.6 | 17.6 |
| Inventories | -12,820.3 | -12,804.9 | -13,647.2 | -15,581.8 | .0 | -1,138.7 | -1,088.1 | -1,039.7 | -993.5 | -949.4 |
| Inventories, % | -665.68 | -622.15 | -595.1 | -700.98 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 378.9 | 379.5 | 613.2 | 608.2 | 496.5 | 357.4 | 341.5 | 326.3 | 311.8 | 298.0 |
| Accounts Payable, % | 19.68 | 18.44 | 26.74 | 27.36 | 33.33 | 25.11 | 25.11 | 25.11 | 25.11 | 25.11 |
| Capital Expenditure | -84.5 | -86.5 | -87.5 | -114.3 | -57.1 | -60.9 | -58.2 | -55.6 | -53.1 | -50.8 |
| Capital Expenditure, % | -4.39 | -4.2 | -3.82 | -5.14 | -3.84 | -4.28 | -4.28 | -4.28 | -4.28 | -4.28 |
| Tax Rate, % | 16.19 | 16.19 | 16.19 | 16.19 | 16.19 | 16.19 | 16.19 | 16.19 | 16.19 | 16.19 |
| EBITAT | 551.2 | 518.2 | 850.1 | 789.9 | -121.5 | 339.7 | 324.6 | 310.2 | 296.4 | 283.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 13,499.7 | 594.9 | 1,825.6 | 2,564.5 | -15,599.3 | 1,504.1 | 297.9 | 284.7 | 272.0 | 259.9 |
| WACC, % | 7.09 | 7.09 | 7.09 | 7.1 | 7.09 | 7.09 | 7.09 | 7.09 | 7.09 | 7.09 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,287.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 265 | |||||||||
| Terminal Value | 5,206 | |||||||||
| Present Terminal Value | 3,696 | |||||||||
| Enterprise Value | 5,983 | |||||||||
| Net Debt | 6,705 | |||||||||
| Equity Value | -721 | |||||||||
| Diluted Shares Outstanding, MM | 188,446 | |||||||||
| Equity Value Per Share | 0.00 |
What You Will Get
- Real Banco Santander-Chile Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Banco Santander-Chile (BSAC).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Banco Santander-Chile (BSAC).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Banco Santander-Chile’s (BSAC) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Banco Santander-Chile (BSAC).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Banco Santander-Chile (BSAC).
Key Features
- Real-Life BSAC Data: Pre-filled with Banco Santander-Chile’s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop multiple forecast scenarios to evaluate various valuation results.
- User-Friendly Design: Intuitive, organized, and tailored for both professionals and newcomers.
How It Works
- 1. Access the Template: Download and open the Excel file containing Banco Santander-Chile’s (BSAC) preloaded data.
- 2. Adjust Assumptions: Modify key parameters such as growth rates, WACC, and capital expenditures.
- 3. Review Results Instantly: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation results.
- 5. Present with Assurance: Share professional valuation insights to back your decisions.
Why Choose This Calculator for Banco Santander-Chile (BSAC)?
- User-Friendly Interface: Tailored for both novice users and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Banco Santander-Chile’s valuation as you tweak inputs.
- Pre-Configured Data: Comes with Banco Santander-Chile’s actual financial information for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use Banco Santander-Chile (BSAC)?
- Investors: Make informed investment choices with insights from a leading financial institution.
- Financial Analysts: Streamline your analysis with comprehensive reports and data from a trusted source.
- Consultants: Leverage detailed market insights for client strategies and presentations.
- Finance Enthusiasts: Expand your knowledge of banking operations and market trends with real-time data.
- Educators and Students: Utilize resources for practical applications in finance and banking studies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Banco Santander-Chile (BSAC) 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 Santander-Chile (BSAC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.