Finward Bancorp (FNWD) DCF Valuation

Finward Bancorp (FNWD) DCF Valuation

US | Financial Services | Banks - Regional | NASDAQ
Finward Bancorp (FNWD) 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

Finward Bancorp (FNWD) Bundle

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 Finward Bancorp (FNWD) DCF Calculator! Utilize authentic financial data, adjust growth projections and expenses, and instantly observe how these modifications affect the intrinsic value of Finward Bancorp (FNWD).


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 53.8 64.0 64.5 78.7 65.3 69.3 73.6 78.1 82.9 88.1
Revenue Growth, % 0 18.95 0.76996 21.91 -16.98 6.16 6.16 6.16 6.16 6.16
EBITDA 15.8 21.9 20.9 22.5 15.2 20.5 21.8 23.1 24.5 26.1
EBITDA, % 29.36 34.21 32.45 28.64 23.29 29.59 29.59 29.59 29.59 29.59
Depreciation 1.9 3.2 4.6 6.0 7.2 4.7 5.0 5.3 5.7 6.0
Depreciation, % 3.53 5 7.07 7.59 10.97 6.83 6.83 6.83 6.83 6.83
EBIT 13.9 18.7 16.4 16.6 8.0 15.8 16.8 17.8 18.9 20.0
EBIT, % 25.83 29.21 25.38 21.05 12.32 22.76 22.76 22.76 22.76 22.76
Total Cash 324.5 430.6 560.1 31.3 81.9 61.0 64.7 68.7 73.0 77.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 4.0 4.7 5.4 1,521.1 .0
Account Receivables, % 7.48 7.36 8.44 1933.75 0
Inventories -54.5 -27.1 -40.3 1,832.1 .0 -14.5 -15.4 -16.4 -17.4 -18.5
Inventories, % -101.32 -42.28 -62.5 2329.13 0 -20.96 -20.96 -20.96 -20.96 -20.96
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 -3.0 -3.7 -3.1 -3.0 -1.1 -3.0 -3.2 -3.4 -3.6 -3.9
Capital Expenditure, % -5.65 -5.83 -4.85 -3.85 -1.76 -4.39 -4.39 -4.39 -4.39 -4.39
Tax Rate, % -4.16 -4.16 -4.16 -4.16 -4.16 -4.16 -4.16 -4.16 -4.16 -4.16
EBITAT 12.1 15.3 15.0 15.1 8.4 14.2 15.1 16.1 17.0 18.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 61.5 -13.4 28.9 -3,370.0 3,367.5 13.4 16.8 17.8 18.9 20.1
WACC, % 17.7 16.84 18.33 18.28 19.65 18.16 18.16 18.16 18.16 18.16
PV UFCF
SUM PV UFCF 52.5
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 20
Terminal Value 127
Present Terminal Value 55
Enterprise Value 107
Net Debt -6
Equity Value 113
Diluted Shares Outstanding, MM 4
Equity Value Per Share 26.40

What You Will Get

  • Editable Forecast Inputs: Seamlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: Finward Bancorp’s (FNWD) financial data pre-loaded to facilitate your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
  • 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

  • 🔍 Real-Life FNWD Financials: Pre-filled historical and projected data for Finward Bancorp (FNWD).
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate Finward Bancorp’s intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize Finward Bancorp’s valuation instantly after making changes.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Finward Bancorp’s (FNWD) preloaded data.
  • 2. Modify Assumptions: Adjust key parameters such as growth rates, WACC, and capital expenditures.
  • 3. View Results in Real-Time: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
  • 4. Explore 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 This Calculator for Finward Bancorp (FNWD)?

  • Accurate Data: Up-to-date Finward Bancorp financials provide dependable valuation outcomes.
  • Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
  • Time-Saving: Ready-made calculations save you from starting from ground zero.
  • Professional-Grade Tool: Created for investors, analysts, and financial consultants.
  • User-Friendly: Simple layout and guided instructions ensure accessibility for all users.

Who Should Use This Product?

  • Investors: Accurately assess Finward Bancorp’s (FNWD) fair value prior to making investment choices.
  • CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
  • Consultants: Efficiently customize the template for valuation reports tailored to clients.
  • Entrepreneurs: Acquire insights into financial modeling practices employed by leading banks.
  • Educators: Implement it as a teaching resource to illustrate valuation techniques.

What the Template Contains

  • Historical Data: Contains Finward Bancorp’s past financials and baseline forecasts.
  • DCF and Levered DCF Models: Comprehensive templates to calculate Finward Bancorp’s intrinsic value.
  • WACC Sheet: Pre-configured calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Adjust key drivers such as growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A thorough breakdown of Finward Bancorp’s financials.
  • Interactive Dashboard: Dynamically visualize valuation results and projections.

No products were found matching.