First Commonwealth Financial Corporation (FCF) 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
First Commonwealth Financial Corporation (FCF) Bundle
Designed for accuracy, our (FCF) DCF Calculator enables you to evaluate the valuation of First Commonwealth Financial Corporation using real-world financial data while offering complete flexibility to modify all key parameters for improved projections.
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 | 355.3 | 362.7 | 385.3 | 410.9 | 467.3 | 500.7 | 536.6 | 575.1 | 616.3 | 660.4 |
| Revenue Growth, % | 0 | 2.08 | 6.22 | 6.65 | 13.71 | 7.17 | 7.17 | 7.17 | 7.17 | 7.17 |
| EBITDA | 1.7 | 1.4 | 2.3 | 2.8 | 215.7 | 48.4 | 51.9 | 55.6 | 59.6 | 63.8 |
| EBITDA, % | 0.47475 | 0.38898 | 0.60317 | 0.68966 | 46.17 | 9.67 | 9.67 | 9.67 | 9.67 | 9.67 |
| Depreciation | 17.3 | 17.2 | 14.8 | 15.7 | 18.2 | 21.2 | 22.7 | 24.3 | 26.1 | 28.0 |
| Depreciation, % | 4.88 | 4.74 | 3.84 | 3.82 | 3.89 | 4.23 | 4.23 | 4.23 | 4.23 | 4.23 |
| EBIT | -15.7 | -15.8 | -12.5 | -12.9 | 197.6 | 27.2 | 29.1 | 31.2 | 33.5 | 35.9 |
| EBIT, % | -4.41 | -4.35 | -3.24 | -3.13 | 42.28 | 5.43 | 5.43 | 5.43 | 5.43 | 5.43 |
| Total Cash | 1,040.9 | 1,200.0 | 1,449.6 | 916.9 | 147.0 | 432.1 | 463.1 | 496.2 | 531.8 | 569.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 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 | -17.4 | -7.6 | -10.6 | -11.2 | -22.0 | -17.2 | -18.5 | -19.8 | -21.2 | -22.7 |
| Capital Expenditure, % | -4.89 | -2.1 | -2.76 | -2.73 | -4.72 | -3.44 | -3.44 | -3.44 | -3.44 | -3.44 |
| Tax Rate, % | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 |
| EBITAT | -12.4 | -12.6 | -10.0 | -10.3 | 157.1 | 21.7 | 23.3 | 24.9 | 26.7 | 28.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -12.5 | -3.1 | -5.8 | -5.8 | 153.2 | 25.7 | 27.5 | 29.5 | 31.6 | 33.9 |
| WACC, % | 10.42 | 10.46 | 10.46 | 10.46 | 10.43 | 10.45 | 10.45 | 10.45 | 10.45 | 10.45 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 109.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 35 | |||||||||
| Terminal Value | 409 | |||||||||
| Present Terminal Value | 249 | |||||||||
| Enterprise Value | 359 | |||||||||
| Net Debt | 603 | |||||||||
| Equity Value | -244 | |||||||||
| Diluted Shares Outstanding, MM | 102 | |||||||||
| Equity Value Per Share | -2.40 |
What You Will Get
- Real FCF Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess First Commonwealth’s future performance.
- User-Friendly Design: Crafted for professionals but easy for newcomers to navigate.
Key Features
- 🔍 Real-Life FCF Financials: Pre-filled historical and projected data for First Commonwealth Financial Corporation (FCF).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate First Commonwealth’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize First Commonwealth’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template featuring First Commonwealth Financial Corporation’s (FCF) data.
- Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including First Commonwealth Financial Corporation’s intrinsic value.
- Step 5: Make informed investment choices or create reports based on the outputs.
Why Choose First Commonwealth Financial Corporation (FCF)?
- Save Time: No need to navigate complex financial processes – our services are streamlined for efficiency.
- Enhance Accuracy: Access to dependable financial insights minimizes valuation errors.
- Fully Customizable: Adjust our offerings to align with your specific financial goals and forecasts.
- Easy to Understand: Intuitive reports and visualizations simplify the analysis of your financial data.
- Trusted by Professionals: Our solutions are crafted for those who prioritize accuracy and user-friendliness.
Who Should Use This Product?
- Investors: Evaluate First Commonwealth Financial Corporation’s (FCF) valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of established financial institutions like First Commonwealth Financial Corporation.
- Consultants: Provide comprehensive valuation analyses and reports for clients in the financial sector.
- Students and Educators: Utilize current data from First Commonwealth Financial Corporation to teach and practice financial valuation techniques.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for First Commonwealth Financial Corporation (FCF).
- Real-World Data: First Commonwealth Financial Corporation’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios for (FCF).
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into First Commonwealth Financial Corporation (FCF).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to (FCF).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to First Commonwealth Financial Corporation (FCF).