The First Bancorp, Inc. (FNLC) DCF Valuation

The First Bancorp, Inc. (FNLC) 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

The First Bancorp, Inc. (FNLC) 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:

Simplify The First Bancorp, Inc. (FNLC) valuation with this customizable DCF Calculator! Featuring real The First Bancorp, Inc. (FNLC) financials and adjustable forecast inputs, you can test scenarios and uncover The First Bancorp, Inc. (FNLC) fair value in 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 66.7 78.0 85.7 93.0 79.5 83.6 87.9 92.5 97.3 102.4
Revenue Growth, % 0 16.9 9.92 8.58 -14.6 5.2 5.2 5.2 5.2 5.2
EBITDA 30.1 29.7 40.5 47.1 36.1 37.9 39.9 41.9 44.1 46.4
EBITDA, % 45.08 38.14 47.28 50.66 45.49 45.33 45.33 45.33 45.33 45.33
Depreciation 2.0 2.3 2.1 2.1 2.1 2.2 2.3 2.4 2.6 2.7
Depreciation, % 2.97 2.9 2.46 2.21 2.68 2.65 2.65 2.65 2.65 2.65
EBIT 28.1 27.5 38.4 45.1 34.0 35.7 37.5 39.5 41.5 43.7
EBIT, % 42.11 35.24 44.82 48.45 42.81 42.68 42.68 42.68 42.68 42.68
Total Cash 386.3 395.7 407.9 310.9 311.1 83.6 87.9 92.5 97.3 102.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 .0 .0 .0 11.9
Account Receivables, % 0 0 0 0 14.97
Inventories -33.2 -92.6 -94.9 -36.3 .0 -48.3 -50.8 -53.4 -56.2 -59.1
Inventories, % -49.77 -118.75 -110.7 -38.96 0 -57.75 -57.75 -57.75 -57.75 -57.75
Accounts Payable .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Accounts Payable, % 0 0 0 0 0 0 0 0 0 0
Capital Expenditure -1.6 -2.5 -3.8 -1.4 -2.6 -2.5 -2.6 -2.7 -2.9 -3.0
Capital Expenditure, % -2.36 -3.26 -4.38 -1.51 -3.32 -2.97 -2.97 -2.97 -2.97 -2.97
Tax Rate, % 17.32 17.32 17.32 17.32 17.32 17.32 17.32 17.32 17.32 17.32
EBITAT 23.7 23.1 31.7 37.1 28.1 29.7 31.2 32.9 34.6 36.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 57.3 82.2 32.4 -20.9 -20.5 87.1 33.3 35.1 36.9 38.8
WACC, % 23.19 23.14 22.84 22.78 22.86 22.96 22.96 22.96 22.96 22.96
PV UFCF
SUM PV UFCF 141.7
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 40
Terminal Value 189
Present Terminal Value 67
Enterprise Value 209
Net Debt -15
Equity Value 224
Diluted Shares Outstanding, MM 11
Equity Value Per Share 20.23

What You Will Receive

  • Authentic FNLC Data: Preloaded financials – including revenue and EBIT – derived from actual and projected metrics.
  • Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
  • Immediate Valuation Adjustments: Automatic recalculations to assess the effects of changes on FNLC’s fair value.
  • Flexible Excel Template: Designed for quick modifications, scenario analysis, and in-depth forecasts.
  • Efficient and Precise: Avoid the hassle of building models from the ground up while ensuring accuracy and adaptability.

Key Features

  • Customizable Financial Inputs: Adjust essential metrics such as loan growth, interest margins, and operating expenses.
  • Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics with ease.
  • High-Precision Accuracy: Leverages The First Bancorp, Inc.'s (FNLC) actual financial data for credible valuation results.
  • Effortless Scenario Analysis: Explore various assumptions and effortlessly compare the results.
  • Efficiency Boost: Remove the hassle of constructing intricate valuation models from the ground up.

How It Works

  • 1. Access the Template: Download and open the Excel file featuring The First Bancorp, Inc.'s (FNLC) preloaded financial data.
  • 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
  • 3. View Results in Real-Time: The DCF model automatically computes intrinsic value and NPV based on your inputs.
  • 4. Explore Different Scenarios: Analyze various forecasts to evaluate different valuation results.
  • 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making process.

Why Choose The First Bancorp, Inc. (FNLC)?

  • Save Time: Instantly access comprehensive financial tools without starting from scratch.
  • Enhance Accuracy: Utilize reliable data and formulas to minimize valuation errors.
  • Fully Customizable: Adjust the model to align with your unique assumptions and forecasts.
  • Easy to Understand: 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?

  • Individual Investors: Gain insights to make informed decisions regarding investments in The First Bancorp, Inc. (FNLC).
  • Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for FNLC.
  • Consultants: Provide clients with accurate and timely valuation analyses of The First Bancorp, Inc. (FNLC).
  • Business Owners: Learn how the valuation of banks like FNLC can inform your own business strategies.
  • Finance Students: Explore real-world valuation methods using data from The First Bancorp, Inc. (FNLC).

What the Template Contains

  • Pre-Filled DCF Model: The First Bancorp, Inc.'s (FNLC) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to FNLC.
  • Financial Ratios: Evaluate The First Bancorp, Inc.'s (FNLC) profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for FNLC.
  • Financial Statements: Annual and quarterly reports for The First Bancorp, Inc. (FNLC) to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results for FNLC.

No products were found matching.