First BanCorp. (FBP) 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
First BanCorp. (FBP) Bundle
Looking to determine the intrinsic value of First BanCorp.? Our (FBP) DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your forecasts and enhance your investment choices.
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 | 647.7 | 698.6 | 835.9 | 23.6 | 863.3 | 928.7 | 999.1 | 1,074.8 | 1,156.3 | 1,243.9 |
| Revenue Growth, % | 0 | 7.86 | 19.64 | -97.18 | 3562.1 | 7.58 | 7.58 | 7.58 | 7.58 | 7.58 |
| EBITDA | 260.1 | 142.1 | 464.2 | 478.7 | 425.7 | 492.8 | 530.2 | 570.4 | 613.6 | 660.1 |
| EBITDA, % | 40.15 | 20.34 | 55.53 | 2030.67 | 49.31 | 53.07 | 53.07 | 53.07 | 53.07 | 53.07 |
| Depreciation | 20.7 | 26.0 | 36.4 | 31.1 | 28.2 | 212.7 | 228.9 | 246.2 | 264.9 | 284.9 |
| Depreciation, % | 3.19 | 3.72 | 4.35 | 131.95 | 3.27 | 22.91 | 22.91 | 22.91 | 22.91 | 22.91 |
| EBIT | 239.4 | 116.1 | 427.8 | 447.6 | 397.4 | 465.8 | 501.1 | 539.1 | 580.0 | 624.0 |
| EBIT, % | 36.96 | 16.62 | 51.18 | 1898.71 | 46.04 | 50.16 | 50.16 | 50.16 | 50.16 | 50.16 |
| Total Cash | 2,767.6 | 6,140.9 | 8,996.8 | 5,998.9 | 662.5 | 885.5 | 952.6 | 1,024.8 | 1,102.5 | 1,186.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 464.7 | 542.5 | 636.5 | 69.7 | 77.7 | 621.4 | 668.5 | 719.2 | 773.7 | 832.3 |
| Account Receivables, % | 71.75 | 77.65 | 76.15 | 295.8 | 9 | 66.91 | 66.91 | 66.91 | 66.91 | 66.91 |
| Inventories | -796.5 | -1,646.4 | -2,645.4 | -1,300.1 | .0 | -743.0 | -799.3 | -859.9 | -925.0 | -995.2 |
| Inventories, % | -122.97 | -235.66 | -316.49 | -5515.23 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 180.6 | 276.7 | 214.9 | 231.6 | .0 | 358.9 | 386.1 | 415.3 | 446.8 | 480.7 |
| Accounts Payable, % | 27.88 | 39.61 | 25.7 | 982.4 | 0 | 38.64 | 38.64 | 38.64 | 38.64 | 38.64 |
| Capital Expenditure | -22.5 | -16.1 | -13.3 | -20.5 | -22.6 | -179.8 | -193.4 | -208.0 | -223.8 | -240.8 |
| Capital Expenditure, % | -3.47 | -2.3 | -1.6 | -86.79 | -2.62 | -19.36 | -19.36 | -19.36 | -19.36 | -19.36 |
| Tax Rate, % | 23.8 | 23.8 | 23.8 | 23.8 | 23.8 | 23.8 | 23.8 | 23.8 | 23.8 | 23.8 |
| EBITAT | 167.4 | 102.1 | 281.0 | 305.1 | 302.9 | 342.8 | 368.7 | 396.7 | 426.8 | 459.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 678.0 | 980.2 | 1,147.2 | -446.1 | -1,231.2 | 933.9 | 440.6 | 474.0 | 510.0 | 548.6 |
| WACC, % | 12.06 | 13.08 | 11.81 | 11.96 | 12.41 | 12.26 | 12.26 | 12.26 | 12.26 | 12.26 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,145.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 560 | |||||||||
| Terminal Value | 5,452 | |||||||||
| Present Terminal Value | 3,057 | |||||||||
| Enterprise Value | 5,203 | |||||||||
| Net Debt | -1 | |||||||||
| Equity Value | 5,203 | |||||||||
| Diluted Shares Outstanding, MM | 177 | |||||||||
| Equity Value Per Share | 29.37 |
What You Will Get
- Real First BanCorp. 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 First BanCorp.'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 FBP Data: Pre-loaded with First BanCorp’s historical financial performance and future projections.
- Customizable Assumptions: Tailor inputs for revenue growth, profit margins, WACC, tax rates, and capital expenditures.
- Interactive Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive Interface: Designed for ease of use, catering to both seasoned professionals and newcomers.
How It Works
- Download: Obtain the pre-formatted Excel file featuring First BanCorp.'s (FBP) financial data.
- Customize: Modify forecasts, such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
- Test Scenarios: Generate various projections and instantly evaluate different outcomes.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for First BanCorp. (FBP).
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes First BanCorp.’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on First BanCorp. (FBP).
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing First BanCorp. (FBP) portfolios.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights related to First BanCorp. (FBP) for client consultations.
- Students and Educators: Utilize real-world financial data to enhance learning and practice in financial modeling.
- Banking Enthusiasts: Gain insights into how financial institutions like First BanCorp. (FBP) are valued in the market.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for First BanCorp. (FBP).
- Real-World Data: First BanCorp.'s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for assessing profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Engaging charts and tables providing clear, actionable results.