First Bancorp (FBNC) DCF Valuation

First Bancorp (FBNC) DCF Valuation
  • ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
  • ✓ No Se Necesita Experiencia; Fáciles De Seguir

First Bancorp (FBNC) Bundle

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

TOTAL:

Streamline First Bancorp (FBNC) valuation with this user-friendly DCF Calculator! With real First Bancorp (FBNC) financial data and adjustable forecast inputs, you can easily test various scenarios and determine First Bancorp (FBNC) 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 274.8 299.5 320.0 392.8 546.2 652.3 778.9 930.1 1,110.7 1,326.3
Revenue Growth, % 0 8.98 6.86 22.76 39.05 19.41 19.41 19.41 19.41 19.41
EBITDA 131.5 116.7 134.2 200.5 .0 234.6 280.2 334.5 399.5 477.0
EBITDA, % 47.86 38.98 41.95 51.05 0 35.97 35.97 35.97 35.97 35.97
Depreciation 12.6 11.8 11.7 12.5 19.2 24.6 29.4 35.1 41.9 50.0
Depreciation, % 4.57 3.94 3.64 3.19 3.52 3.77 3.77 3.77 3.77 3.77
EBIT 119.0 104.9 122.6 188.0 -19.2 210.0 250.8 299.5 357.6 427.0
EBIT, % 43.29 35.04 38.31 47.86 -3.52 32.2 32.2 32.2 32.2 32.2
Total Cash 1,053.2 1,820.4 3,091.6 270.3 237.9 537.9 642.4 767.1 916.0 1,093.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 .0 .0 .0 .0
Account Receivables, % 0 0 0 0 0
Inventories -251.8 -390.0 -490.1 -300.7 .0 -480.3 -573.6 -684.9 -817.9 -976.6
Inventories, % -91.64 -130.23 -153.16 -76.54 0 -73.64 -73.64 -73.64 -73.64 -73.64
Accounts Payable 2.2 .9 .6 2.7 5.7 3.9 4.7 5.6 6.7 8.0
Accounts Payable, % 0.78386 0.30187 0.18968 0.69698 1.04 0.60314 0.60314 0.60314 0.60314 0.60314
Capital Expenditure -3.5 -12.4 -9.4 -5.3 -4.4 -13.7 -16.4 -19.5 -23.3 -27.9
Capital Expenditure, % -1.29 -4.13 -2.94 -1.35 -0.80934 -2.1 -2.1 -2.1 -2.1 -2.1
Tax Rate, % 21.09 21.09 21.09 21.09 21.09 21.09 21.09 21.09 21.09 21.09
EBITAT 94.2 82.9 97.5 149.2 -15.2 166.3 198.6 237.1 283.1 338.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 357.2 219.3 199.5 -30.9 -298.1 655.7 305.6 364.9 435.7 520.3
WACC, % 11.81 11.8 11.83 11.82 11.79 11.81 11.81 11.81 11.81 11.81
PV UFCF
SUM PV UFCF 1,668.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 531
Terminal Value 5,411
Present Terminal Value 3,096
Enterprise Value 4,765
Net Debt 333
Equity Value 4,432
Diluted Shares Outstanding, MM 41
Equity Value Per Share 107.67

What You Will Get

  • Real FBNC Financial Data: Pre-filled with First Bancorp’s historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See First Bancorp’s intrinsic value update instantly based on your changes.
  • Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
  • User-Friendly Design: Simple structure and clear instructions for all experience levels.

Key Features

  • Real-Life FBNC Data: Pre-filled with First Bancorp’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

  1. Download the Template: Get instant access to the Excel-based FBNC DCF Calculator.
  2. Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
  3. Instant Calculations: The model automatically updates First Bancorp’s intrinsic value.
  4. Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
  5. Analyze and Decide: Use the results to guide your investment or financial analysis.

Why Choose First Bancorp (FBNC) Calculator?

  • Save Time: Quickly access a pre-built DCF model without starting from scratch.
  • Enhance Accuracy: Utilize dependable financial data and formulas to minimize valuation errors.
  • Completely Customizable: Adjust the model to suit your specific assumptions and forecasts.
  • User-Friendly: Intuitive charts and outputs simplify the analysis of results.
  • Endorsed by Professionals: Crafted for experts who prioritize precision and ease of use.

Who Should Use This Product?

  • Investors: Evaluate First Bancorp’s (FBNC) valuation before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation workflows and assess financial forecasts.
  • Startup Founders: Understand the valuation methods applied to established banks like First Bancorp.
  • Consultants: Provide clients with detailed and professional valuation assessments.
  • Students and Educators: Utilize actual market data to practice and teach valuation strategies.

What the Template Contains

  • Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for First Bancorp (FBNC).
  • Real-World Data: First Bancorp's historical and projected financials preloaded for analysis.
  • Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for deeper insights into First Bancorp (FBNC).
  • Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to First Bancorp (FBNC).
  • Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to First Bancorp (FBNC).

No products were found matching.