Esquire Financial Holdings, Inc. (ESQ) DCF Valuation

Esquire Financial Holdings, Inc. (ESQ) DCF Valuation

US | Financial Services | Banks - Regional | NASDAQ
Esquire Financial Holdings, Inc. (ESQ) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Esquire Financial Holdings, Inc. (ESQ) Bundle

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

TOTAL:

Whether you’re an investor or an analyst, this (ESQ) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Esquire Financial Holdings, Inc., you can adjust forecasts and immediately observe the effects.


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 45.9 52.1 64.7 84.3 91.9 109.6 130.6 155.8 185.7 221.4
Revenue Growth, % 0 13.42 24.27 30.19 9.04 19.23 19.23 19.23 19.23 19.23
EBITDA 20.0 18.8 24.9 41.4 58.4 50.6 60.3 71.9 85.7 102.2
EBITDA, % 43.61 36.08 38.54 49.07 63.58 46.17 46.17 46.17 46.17 46.17
Depreciation .9 1.0 1.2 1.2 1.3 1.8 2.2 2.6 3.1 3.7
Depreciation, % 1.93 1.84 1.89 1.39 1.39 1.69 1.69 1.69 1.69 1.69
EBIT 19.1 17.8 23.7 40.2 57.1 48.7 58.1 69.3 82.6 98.5
EBIT, % 41.68 34.24 36.65 47.68 62.19 44.49 44.49 44.49 44.49 44.49
Total Cash 208.2 182.8 297.5 351.8 287.3 109.6 130.6 155.8 185.7 221.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 3.2 4.5 4.2 5.8 9.1
Account Receivables, % 7.06 8.7 6.48 6.84 9.94
Inventories -65.0 -121.4 -203.6 .0 .0 -65.7 -78.4 -93.5 -111.4 -132.9
Inventories, % -141.65 -233.15 -314.59 0 0 -60 -60 -60 -60 -60
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 -.6 -3.1 -2.9 -1.2 -3.0 -3.7 -4.4 -5.2 -6.2 -7.4
Capital Expenditure, % -1.41 -6.02 -4.55 -1.47 -3.27 -3.34 -3.34 -3.34 -3.34 -3.34
Tax Rate, % 26.61 26.61 26.61 26.61 26.61 26.61 26.61 26.61 26.61 26.61
EBITAT 14.1 13.1 18.7 29.5 41.9 36.4 43.4 51.7 61.7 73.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 76.2 66.0 99.5 -175.7 36.8 100.9 52.2 62.3 74.2 88.5
WACC, % 8.67 8.66 8.73 8.66 8.66 8.67 8.67 8.67 8.67 8.67
PV UFCF
SUM PV UFCF 297.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 90
Terminal Value 1,352
Present Terminal Value 892
Enterprise Value 1,189
Net Debt -165
Equity Value 1,355
Diluted Shares Outstanding, MM 8
Equity Value Per Share 162.31

What You Will Receive

  • Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real ESQ financials.
  • Authentic Data: Historical performance data and forward-looking estimates (highlighted in the yellow cells).
  • Assumption Flexibility: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
  • Instant Calculations: Quickly observe how your inputs affect Esquire Financial Holdings' valuation.
  • Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Interface: Organized for clarity and simplicity, complete with step-by-step guidance.

Key Features

  • Accurate Financial Data: Gain access to reliable historical figures and future forecasts for Esquire Financial Holdings, Inc. (ESQ).
  • Tailored Forecast Assumptions: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
  • Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
  • User-Friendly Dashboard: Intuitive charts and summaries to effectively visualize your valuation outcomes.
  • Designed for All Skill Levels: A straightforward layout suitable for investors, CFOs, and consultants alike.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Esquire Financial Holdings, Inc. (ESQ) preloaded data.
  • 2. Modify Assumptions: Adjust crucial inputs such as growth rates, WACC, and capital expenditures.
  • 3. See Results in Real-Time: The DCF model automatically calculates intrinsic value and NPV.
  • 4. Explore Scenarios: Evaluate various forecasts to assess different valuation results.
  • 5. Present with Assurance: Deliver professional valuation insights to back your strategic decisions.

Why Choose Esquire Financial Holdings, Inc. (ESQ) Calculator?

  • All-in-One Solution: Combines DCF, WACC, and financial ratio analyses for comprehensive evaluations.
  • Flexible Inputs: Modify the yellow-highlighted fields to explore different financial scenarios.
  • In-Depth Analysis: Automatically computes Esquire's intrinsic value and Net Present Value.
  • Integrated Data: Historical and projected data provide reliable foundations for analysis.
  • High-Quality Standards: Perfect for financial analysts, investors, and business consultants looking for precision.

Who Should Use This Product?

  • Finance Students: Discover financial modeling techniques and apply them to real-world scenarios with Esquire Financial Holdings, Inc. (ESQ).
  • Academics: Integrate advanced financial models into your research or teaching involving Esquire Financial Holdings, Inc. (ESQ).
  • Investors: Evaluate your investment strategies and assess the financial performance of Esquire Financial Holdings, Inc. (ESQ).
  • Analysts: Enhance your analysis with a ready-to-use, customizable financial model tailored for Esquire Financial Holdings, Inc. (ESQ).
  • Small Business Owners: Learn from the financial strategies of large public companies like Esquire Financial Holdings, Inc. (ESQ).

What the Template Contains

  • Preloaded ESQ 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.