First Bank (FRBA) DCF Valuation

First Bank (FRBA) DCF Valuation

US | Financial Services | Banks - Regional | NASDAQ
First Bank (FRBA) 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 Bank (FRBA) Bundle

Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Streamline First Bank (FRBA) valuation with this flexible DCF Calculator! Equipped with real First Bank (FRBA) financials and modifiable forecast inputs, you can explore various scenarios and determine First Bank (FRBA) fair value in just minutes.


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 62.4 75.9 89.6 97.5 95.9 107.1 119.7 133.7 149.4 166.9
Revenue Growth, % 0 21.72 18.1 8.76 -1.68 11.72 11.72 11.72 11.72 11.72
EBITDA 20.7 27.9 48.3 49.4 .0 37.4 41.8 46.6 52.1 58.2
EBITDA, % 33.16 36.71 53.88 50.72 0 34.89 34.89 34.89 34.89 34.89
Depreciation 1.7 1.9 1.6 1.6 2.8 2.5 2.7 3.1 3.4 3.8
Depreciation, % 2.67 2.48 1.76 1.6 2.97 2.3 2.3 2.3 2.3 2.3
EBIT 19.0 26.0 46.7 47.9 -2.8 34.9 39.0 43.6 48.7 54.4
EBIT, % 30.49 34.23 52.12 49.12 -2.97 32.6 32.6 32.6 32.6 32.6
Total Cash 95.3 161.6 251.3 212.6 215.2 107.1 119.7 133.7 149.4 166.9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 4.8 6.8 5.7 8.2 .0
Account Receivables, % 7.71 8.97 6.34 8.37 0
Inventories -94.1 -107.2 -163.1 -135.4 .0 -85.7 -95.7 -106.9 -119.5 -133.5
Inventories, % -150.82 -141.26 -181.98 -138.85 0 -80 -80 -80 -80 -80
Accounts Payable 1.1 .6 .4 1.2 2.8 1.5 1.7 1.9 2.1 2.4
Accounts Payable, % 1.73 0.73908 0.44509 1.25 2.93 1.42 1.42 1.42 1.42 1.42
Capital Expenditure -1.0 -.4 -.2 -1.9 -3.1 -1.6 -1.8 -2.0 -2.3 -2.5
Capital Expenditure, % -1.65 -0.47296 -0.21083 -1.96 -3.25 -1.51 -1.51 -1.51 -1.51 -1.51
Tax Rate, % 23.05 23.05 23.05 23.05 23.05 23.05 23.05 23.05 23.05 23.05
EBITAT 13.4 19.4 35.4 36.3 -2.2 26.1 29.2 32.6 36.4 40.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 104.4 31.6 93.7 6.5 -128.1 104.6 39.6 44.2 49.4 55.2
WACC, % 14.11 14.64 14.76 14.75 14.9 14.63 14.63 14.63 14.63 14.63
PV UFCF
SUM PV UFCF 207.2
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 56
Terminal Value 446
Present Terminal Value 225
Enterprise Value 432
Net Debt 19
Equity Value 413
Diluted Shares Outstanding, MM 22
Equity Value Per Share 18.71

What You Will Get

  • Real First Bank 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 Bank’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 FRBA Data: Pre-loaded with First Bank’s historical performance metrics and future financial forecasts.
  • Customizable Variables: Tailor inputs for interest rates, loan growth, operating expenses, and capital reserves.
  • Interactive Valuation Model: Real-time adjustments to Net Present Value (NPV) and intrinsic value based on your configurations.
  • Scenario Analysis: Develop various forecasting scenarios to evaluate different financial outcomes.
  • User-Centric Interface: Intuitive, organized, and suitable for both experienced professionals and newcomers.

How It Works

  • 1. Access the Template: Download and open the Excel file containing First Bank’s (FRBA) preloaded data.
  • 2. Modify Assumptions: Adjust key parameters such as growth rates, WACC, and capital expenditures.
  • 3. Receive Instant Results: The DCF model automatically computes intrinsic value and NPV.
  • 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation results.
  • 5. Utilize with Assurance: Deliver professional valuation insights to back your decisions.

Why Choose This Calculator for First Bank (FRBA)?

  • Accurate Data: Utilize real financial metrics from First Bank for dependable valuation outcomes.
  • Customizable: Tailor essential variables such as growth rates, WACC, and tax rates to fit your forecasts.
  • Time-Saving: Ready-made calculations save you the hassle of starting from the ground up.
  • Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
  • User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.

Who Should Use First Bank (FRBA)?

  • Investors: Gain insights and make informed decisions with our comprehensive banking solutions.
  • Financial Advisors: Streamline your advisory process with tailored financial products for your clients.
  • Business Owners: Access flexible financing options to support your business growth and expansion.
  • Community Members: Enjoy personalized banking services that cater to your unique financial needs.
  • Students and Educators: Utilize our resources to enhance financial literacy and understanding of banking principles.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled First Bank (FRBA) historical data and forecasts, including revenue, net income, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate in-depth analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for First Bank (FRBA).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify result analysis.

No products were found matching.