Financial Institutions, Inc. (FISI) DCF Valuation

Financial Institutions, Inc. (FISI) 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

Financial Institutions, Inc. (FISI) 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:

Discover the true value of Financial Institutions, Inc. (FISI) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and examine how changes affect Financial Institutions, Inc. (FISI) valuation – all within a single Excel template.


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 169.9 182.1 199.6 212.4 200.3 209.0 218.2 227.7 237.6 248.0
Revenue Growth, % 0 7.13 9.61 6.41 -5.68 4.37 4.37 4.37 4.37 4.37
EBITDA 67.6 53.6 105.3 79.1 .0 66.6 69.5 72.5 75.7 79.0
EBITDA, % 39.8 29.45 52.75 37.24 0 31.85 31.85 31.85 31.85 31.85
Depreciation 8.2 5.9 5.6 5.8 .0 5.7 5.9 6.2 6.5 6.8
Depreciation, % 4.83 3.23 2.82 2.75 0 2.73 2.73 2.73 2.73 2.73
EBIT 59.4 47.7 99.6 73.2 .0 60.9 63.5 66.3 69.2 72.2
EBIT, % 34.97 26.22 49.93 34.49 0 29.12 29.12 29.12 29.12 29.12
Total Cash 530.9 721.9 1,257.6 1,084.8 124.4 193.2 201.6 210.4 219.6 229.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 .0 .0 55.6 .0
Account Receivables, % 0 0 0 26.17 0
Inventories .0 -146.8 -97.2 -151.4 .0 -83.9 -87.5 -91.4 -95.3 -99.5
Inventories, % 0 -80.66 -48.69 -71.28 0 -40.13 -40.13 -40.13 -40.13 -40.13
Accounts Payable .0 .0 .0 6.0 19.4 5.2 5.5 5.7 5.9 6.2
Accounts Payable, % 0 0 0 2.82 9.69 2.5 2.5 2.5 2.5 2.5
Capital Expenditure -3.6 -4.3 -9.4 -8.4 -3.0 -6.1 -6.4 -6.7 -7.0 -7.3
Capital Expenditure, % -2.14 -2.34 -4.71 -3.94 -1.49 -2.93 -2.93 -2.93 -2.93 -2.93
Tax Rate, % 20.28 20.28 20.28 20.28 20.28 20.28 20.28 20.28 20.28 20.28
EBITAT 48.9 40.0 79.6 58.4 .0 49.4 51.5 53.8 56.1 58.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 53.4 188.5 26.2 60.5 -85.4 107.7 54.5 56.9 59.4 61.9
WACC, % 17.83 18.08 17.46 17.43 17.43 17.64 17.64 17.64 17.64 17.64
PV UFCF
SUM PV UFCF 224.3
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 63
Terminal Value 404
Present Terminal Value 179
Enterprise Value 404
Net Debt 219
Equity Value 185
Diluted Shares Outstanding, MM 15
Equity Value Per Share 11.93

What You Will Get

  • Real FISI Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on FISI’s fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.

Key Features

  • Comprehensive FISI Data: Comes pre-loaded with Financial Institutions, Inc.'s historical performance metrics and future forecasts.
  • Customizable Financial Inputs: Modify key variables such as loan growth, interest margins, capital ratios, and operational expenses.
  • Interactive Valuation Framework: Automatically recalculates Net Present Value (NPV) and intrinsic value in response to your adjustments.
  • Flexible Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
  • Intuitive User Interface: Designed for ease of use, catering to both experienced professionals and newcomers.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review Financial Institutions, Inc.'s (FISI) pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
  5. Step 5: Analyze the outputs and utilize the results for your investment decisions.

Why Choose This Calculator for Financial Institutions, Inc. (FISI)?

  • Accuracy: Utilizes real financial data from Financial Institutions, Inc. for precise calculations.
  • Flexibility: Allows users to easily adjust and test various input scenarios.
  • Time-Saving: Eliminates the need to create a financial model from the ground up.
  • Professional-Grade: Crafted with the expertise and standards expected at the CFO level.
  • User-Friendly: Designed for ease of use, accommodating those with minimal financial modeling skills.

Who Should Use This Product?

  • Investors: Accurately assess the fair value of Financial Institutions, Inc. (FISI) prior to making investment choices.
  • CFOs: Utilize a high-quality DCF model for financial reporting and comprehensive analysis.
  • Consultants: Efficiently modify the template for client valuation reports.
  • Entrepreneurs: Acquire knowledge of financial modeling practices employed by leading financial firms.
  • Educators: Implement it as a teaching resource to illustrate valuation techniques.

What the Template Contains

  • Pre-Filled Data: Contains Financial Institutions, Inc. (FISI) historical financials and projections.
  • Discounted Cash Flow Model: An editable DCF valuation model with automatic computation features.
  • Weighted Average Cost of Capital (WACC): A specific sheet for calculating WACC using user-defined inputs.
  • Key Financial Ratios: Evaluate Financial Institutions, Inc. (FISI) in terms of profitability, efficiency, and leverage.
  • Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
  • Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.