Farmers National Banc Corp. (FMNB) 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
Farmers National Banc Corp. (FMNB) Bundle
Whether you're an investor or an analyst, this (FMNB) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Farmers National Banc Corp., 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 | 108.0 | 123.3 | 141.3 | 158.9 | 170.5 | 191.2 | 214.4 | 240.4 | 269.6 | 302.3 |
| Revenue Growth, % | 0 | 14.15 | 14.64 | 12.44 | 7.32 | 12.14 | 12.14 | 12.14 | 12.14 | 12.14 |
| EBITDA | 45.9 | 53.4 | 65.7 | 77.7 | 66.0 | 84.1 | 94.3 | 105.8 | 118.6 | 133.0 |
| EBITDA, % | 42.52 | 43.32 | 46.47 | 48.93 | 38.73 | 43.99 | 43.99 | 43.99 | 43.99 | 43.99 |
| Depreciation | 2.8 | 2.8 | 3.2 | 4.9 | 7.3 | 5.6 | 6.2 | 7.0 | 7.8 | 8.8 |
| Depreciation, % | 2.63 | 2.29 | 2.24 | 3.08 | 4.3 | 2.91 | 2.91 | 2.91 | 2.91 | 2.91 |
| EBIT | 43.1 | 50.6 | 62.5 | 72.8 | 58.7 | 78.5 | 88.1 | 98.8 | 110.8 | 124.2 |
| EBIT, % | 39.9 | 41.03 | 44.23 | 45.85 | 34.43 | 41.09 | 41.09 | 41.09 | 41.09 | 41.09 |
| Total Cash | 503.0 | 830.2 | 1,540.5 | 1,289.4 | 103.7 | 176.2 | 197.6 | 221.6 | 248.5 | 278.6 |
| 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 | -1.5 | -3.7 | -1.4 | -5.5 | -3.9 | -4.2 | -4.7 | -5.3 | -6.0 | -6.7 |
| Capital Expenditure, % | -1.35 | -3 | -0.97318 | -3.47 | -2.28 | -2.21 | -2.21 | -2.21 | -2.21 | -2.21 |
| Tax Rate, % | 14.93 | 14.93 | 14.93 | 14.93 | 14.93 | 14.93 | 14.93 | 14.93 | 14.93 | 14.93 |
| EBITAT | 35.8 | 42.1 | 52.2 | 60.6 | 49.9 | 65.7 | 73.6 | 82.6 | 92.6 | 103.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 37.1 | 41.3 | 53.9 | 60.0 | 53.4 | 67.0 | 75.1 | 84.3 | 94.5 | 106.0 |
| WACC, % | 11.05 | 11.08 | 11.09 | 11.07 | 11.21 | 11.1 | 11.1 | 11.1 | 11.1 | 11.1 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 307.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 108 | |||||||||
| Terminal Value | 1,188 | |||||||||
| Present Terminal Value | 702 | |||||||||
| Enterprise Value | 1,009 | |||||||||
| Net Debt | 415 | |||||||||
| Equity Value | 594 | |||||||||
| Diluted Shares Outstanding, MM | 37 | |||||||||
| Equity Value Per Share | 15.84 |
What You Will Get
- Real FMNB Financial Data: Pre-filled with Farmers National Banc Corp.'s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See FMNB's intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Farmers National Banc Corp. (FMNB).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to FMNB.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit FMNB's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Farmers National Banc Corp. (FMNB).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of FMNB.
How It Works
- Step 1: Download the Excel file for Farmers National Banc Corp. (FMNB).
- Step 2: Review the pre-filled financial data and forecasts for Farmers National Banc Corp. (FMNB).
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells) for Farmers National Banc Corp. (FMNB).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions for Farmers National Banc Corp. (FMNB).
- Step 5: Evaluate the outputs and leverage the results for your investment decisions regarding Farmers National Banc Corp. (FMNB).
Why Choose This Calculator for Farmers National Banc Corp. (FMNB)?
- Accurate Data: Utilize real Farmers National Banc Corp. financials for trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and financial consultants.
- User-Friendly: Easy-to-navigate design and step-by-step guidance ensure accessibility for all users.
Who Should Use Farmers National Banc Corp. (FMNB)?
- Investors: Leverage a reliable banking institution for your financial growth and stability.
- Financial Analysts: Utilize comprehensive reports and insights to enhance your market analysis.
- Small Business Owners: Access tailored banking solutions designed to support your business needs.
- Community Members: Engage with a bank that prioritizes local investment and development.
- Students and Educators: Explore banking fundamentals and financial literacy through practical resources.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for Farmers National Banc Corp. (FMNB).
- Real-World Data: Farmers National Banc Corp.'s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios for Farmers National Banc Corp. (FMNB).
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into Farmers National Banc Corp. (FMNB).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage relevant to Farmers National Banc Corp. (FMNB).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results for Farmers National Banc Corp. (FMNB).