Simmons First National Corporation (SFNC) DCF Valuation

Simmons First National Corporation (SFNC) DCF Valuation
  • ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • ✓ Aucune Expertise N'Est Requise; Facile À Suivre

Simmons First National Corporation (SFNC) 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:

Whether you're an investor or an analyst, this SFNC DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Simmons First National Corporation, you can adjust forecasts and instantly 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 790.6 860.9 768.4 875.1 759.7 757.5 755.3 753.1 750.9 748.7
Revenue Growth, % 0 8.89 -10.75 13.89 -13.2 -0.28977 -0.28977 -0.28977 -0.28977 -0.28977
EBITDA 338.7 368.8 379.7 355.5 .0 266.2 265.4 264.7 263.9 263.1
EBITDA, % 42.84 42.84 49.41 40.62 0 35.14 35.14 35.14 35.14 35.14
Depreciation 36.3 49.0 47.2 49.0 47.9 42.9 42.8 42.7 42.5 42.4
Depreciation, % 4.59 5.7 6.15 5.59 6.3 5.66 5.66 5.66 5.66 5.66
EBIT 302.4 319.8 332.5 306.6 -47.9 223.3 222.6 222.0 221.4 220.7
EBIT, % 38.25 37.14 43.27 35.03 -6.3 29.48 29.48 29.48 29.48 29.48
Total Cash 4,454.5 6,947.3 8,766.1 4,535.8 4,698.7 757.5 755.3 753.1 750.9 748.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 .0 .0 102.9 .0
Account Receivables, % 0 0 0 11.76 0
Inventories -1,343.3 -3,579.8 -1,731.7 .0 .0 -454.5 -453.2 -451.8 -450.5 -449.2
Inventories, % -169.91 -415.81 -225.35 0 0 -60 -60 -60 -60 -60
Accounts Payable 165.4 217.4 201.9 257.9 .0 154.4 153.9 153.5 153.1 152.6
Accounts Payable, % 20.92 25.25 26.27 29.47 0 20.38 20.38 20.38 20.38 20.38
Capital Expenditure -67.8 -13.3 -47.9 -35.3 -33.1 -37.5 -37.4 -37.3 -37.1 -37.0
Capital Expenditure, % -8.58 -1.54 -6.23 -4.03 -4.36 -4.95 -4.95 -4.95 -4.95 -4.95
Tax Rate, % 12.73 12.73 12.73 12.73 12.73 12.73 12.73 12.73 12.73 12.73
EBITAT 238.2 254.9 271.2 256.4 -41.8 183.5 183.0 182.4 181.9 181.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 1,715.4 2,579.1 -1,593.2 -1,508.4 -182.0 780.0 186.7 186.1 185.6 185.1
WACC, % 16.41 16.54 16.79 17.07 17.55 16.87 16.87 16.87 16.87 16.87
PV UFCF
SUM PV UFCF 1,105.0
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 189
Terminal Value 1,269
Present Terminal Value 582
Enterprise Value 1,687
Net Debt 724
Equity Value 963
Diluted Shares Outstanding, MM 127
Equity Value Per Share 7.59

What You Will Get

  • Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
  • Real-World Data: Simmons First National Corporation’s (SFNC) financial data pre-loaded to kickstart your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
  • Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • Comprehensive DCF Model: Features detailed unlevered and levered DCF valuation frameworks tailored for Simmons First National Corporation (SFNC).
  • WACC Tool: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters for personalized analysis.
  • Customizable Forecast Inputs: Adjust growth projections, capital investments, and discount rates as needed.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and operational efficiency ratios specific to Simmons First National Corporation (SFNC).
  • Visual Dashboard and Graphs: Graphical representations provide a clear overview of essential valuation metrics for straightforward interpretation.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Simmons First National Corporation’s (SFNC) data.
  • Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
  • Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Instantly see the recalculated results, including Simmons First National Corporation’s (SFNC) intrinsic value.
  • Step 5: Use the outputs to make informed investment decisions or create comprehensive reports.

Why Choose This Calculator for Simmons First National Corporation (SFNC)?

  • User-Friendly Interface: Tailored for both novices and seasoned investors.
  • Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
  • Real-Time Valuation: Observe immediate updates to SFNC’s valuation as you tweak the inputs.
  • Pre-Configured Data: Comes loaded with SFNC’s current financial metrics for swift evaluations.
  • Relied Upon by Experts: Favored by analysts and investors for making strategic decisions.

Who Should Use This Product?

  • Professional Investors: Develop comprehensive and accurate valuation models for analyzing SFNC's portfolio.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
  • Consultants and Advisors: Deliver precise valuation insights to clients regarding Simmons First National Corporation (SFNC).
  • Students and Educators: Utilize real-time data to practice and instruct on financial modeling techniques.
  • Banking Enthusiasts: Gain insights into how financial institutions like Simmons First National Corporation (SFNC) are valued in the industry.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Simmons First National Corporation (SFNC) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for Simmons First National Corporation (SFNC).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.