Financial Institutions, Inc. (FISI) 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
Financial Institutions, Inc. (FISI) Bundle
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 | 10.9 | 11.4 | 11.9 | 12.4 | 13.0 |
Account Receivables, % | 0 | 0 | 0 | 26.17 | 0 | 5.23 | 5.23 | 5.23 | 5.23 | 5.23 |
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
- Step 1: Download the Excel file.
- Step 2: Review Financial Institutions, Inc.'s (FISI) pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- 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.