The First of Long Island Corporation (FLIC) DCF Valuation

The First of Long Island Corporation (FLIC) 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

The First of Long Island Corporation (FLIC) 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:

Enhance your investment strategies with the (FLIC) DCF Calculator! Explore authentic financial data from The First of Long Island Corporation, adjust growth predictions and expenses, and observe how these adjustments influence the intrinsic value of (FLIC) 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 110.8 116.1 119.4 128.1 93.5 90.7 88.0 85.3 82.8 80.3
Revenue Growth, % 0 4.81 2.81 7.33 -27.01 -3.01 -3.01 -3.01 -3.01 -3.01
EBITDA 56.0 55.9 62.0 64.5 35.2 43.3 42.0 40.7 39.5 38.3
EBITDA, % 50.55 48.14 51.92 50.36 37.66 47.73 47.73 47.73 47.73 47.73
Depreciation 6.2 6.4 8.7 6.3 5.8 5.3 5.2 5.0 4.9 4.7
Depreciation, % 5.61 5.49 7.27 4.93 6.15 5.89 5.89 5.89 5.89 5.89
EBIT 49.8 49.5 53.3 58.2 29.5 38.0 36.8 35.7 34.6 33.6
EBIT, % 44.94 42.65 44.65 45.44 31.51 41.84 41.84 41.84 41.84 41.84
Total Cash 736.5 873.9 778.0 747.6 60.9 84.4 81.8 79.4 77.0 74.7
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 .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0 0 0 0 0 0 0 0 0
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 -2.9 -3.0 -7.7 -3.6 -2.9 -3.2 -3.1 -3.0 -2.9 -2.8
Capital Expenditure, % -2.6 -2.59 -6.45 -2.81 -3.06 -3.5 -3.5 -3.5 -3.5 -3.5
Tax Rate, % 10.96 10.96 10.96 10.96 10.96 10.96 10.96 10.96 10.96 10.96
EBITAT 41.6 41.2 43.1 46.9 26.2 31.7 30.7 29.8 28.9 28.0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 44.9 44.6 44.1 49.6 29.1 33.8 32.8 31.8 30.9 29.9
WACC, % 9.31 9.29 9.1 9.08 9.77 9.31 9.31 9.31 9.31 9.31
PV UFCF
SUM PV UFCF 123.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 31
Terminal Value 418
Present Terminal Value 268
Enterprise Value 391
Net Debt 507
Equity Value -115
Diluted Shares Outstanding, MM 23
Equity Value Per Share -5.09

What You Will Receive

  • Authentic FLIC Data: Preloaded financial information – from revenue to EBIT – based on actual and projected metrics.
  • Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
  • Immediate Valuation Updates: Automatic recalculations to evaluate the effects of changes on FLIC’s fair value.
  • Flexible Excel Template: Designed for quick modifications, scenario analysis, and detailed forecasting.
  • Efficient and Precise: Avoid constructing models from the ground up while ensuring accuracy and adaptability.

Key Features

  • Customizable Financial Inputs: Adjust essential parameters such as loan growth, net interest margin, and operating expenses.
  • Instant DCF Valuation: Quickly computes intrinsic value, NPV, and various financial metrics.
  • High-Precision Results: Leverages The First of Long Island Corporation’s (FLIC) actual financial data for accurate valuation predictions.
  • Simplified Scenario Testing: Easily explore various assumptions and analyze outcomes side by side.
  • Efficiency Booster: Avoid the complexity of constructing detailed valuation models from the ground up.

How It Works

  • 1. Access the Template: Download and open the Excel file featuring The First of Long Island Corporation’s (FLIC) preloaded data.
  • 2. Modify Assumptions: Adjust critical inputs such as growth rates, WACC, and capital expenditures.
  • 3. View Results Quickly: The DCF model automatically calculates intrinsic value and NPV in real-time.
  • 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation possibilities.
  • 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making.

Why Choose This Calculator for The First of Long Island Corporation (FLIC)?

  • User-Friendly Interface: Perfect for both novices and seasoned professionals.
  • Customizable Inputs: Adjust parameters easily to suit your financial analysis.
  • Real-Time Valuation: Monitor immediate updates to FLIC’s valuation as you tweak the inputs.
  • Preloaded Data: Comes with FLIC’s actual financial metrics for swift evaluations.
  • Endorsed by Experts: Favored by investors and analysts for making well-informed choices.

Who Should Use This Product?

  • Investors: Accurately assess The First of Long Island Corporation’s (FLIC) fair value prior to making investment choices.
  • CFOs: Utilize a high-quality DCF model for financial reporting and analysis specific to FLIC.
  • Consultants: Easily modify the template for valuation reports tailored to FLIC clients.
  • Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading companies like FLIC.
  • Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to FLIC.

What the Template Contains

  • Preloaded FLIC Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
  • DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
  • Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
  • Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
  • Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
  • Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.

No products were found matching.