First National Corporation (FXNC) 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
First National Corporation (FXNC) Bundle
Discover the true value of First National Corporation (FXNC) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how changes affect First National Corporation (FXNC) valuation – all within one convenient 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 | 36.6 | 37.7 | 45.0 | 56.9 | 49.0 | 53.3 | 58.0 | 63.1 | 68.7 | 74.7 |
| Revenue Growth, % | 0 | 3.09 | 19.42 | 26.31 | -13.73 | 8.77 | 8.77 | 8.77 | 8.77 | 8.77 |
| EBITDA | 13.4 | 12.4 | 14.4 | 22.3 | .0 | 15.0 | 16.3 | 17.7 | 19.3 | 21.0 |
| EBITDA, % | 36.73 | 32.83 | 31.88 | 39.16 | 0 | 28.12 | 28.12 | 28.12 | 28.12 | 28.12 |
| Depreciation | 1.6 | 1.5 | 1.4 | 1.5 | .0 | 1.5 | 1.6 | 1.8 | 2.0 | 2.1 |
| Depreciation, % | 4.48 | 3.89 | 3.17 | 2.67 | 0 | 2.84 | 2.84 | 2.84 | 2.84 | 2.84 |
| EBIT | 11.8 | 10.9 | 12.9 | 20.7 | .0 | 13.5 | 14.7 | 16.0 | 17.4 | 18.9 |
| EBIT, % | 32.26 | 28.94 | 28.71 | 36.48 | 0 | 25.28 | 25.28 | 25.28 | 25.28 | 25.28 |
| Total Cash | 166.8 | 267.5 | 465.5 | 229.8 | 87.2 | 53.3 | 58.0 | 63.1 | 68.7 | 74.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | 4.5 | .0 | .9 | .9 | 1.0 | 1.1 | 1.2 |
| Account Receivables, % | 0 | 0 | 0 | 7.99 | 0 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 |
| Inventories | -47.9 | -130.0 | -181.8 | 15.1 | .0 | -29.2 | -31.7 | -34.5 | -37.5 | -40.8 |
| Inventories, % | -130.87 | -344.93 | -403.8 | 26.57 | 0 | -54.69 | -54.69 | -54.69 | -54.69 | -54.69 |
| Accounts Payable | 2.1 | 4.3 | 4.4 | 5.4 | .0 | 3.9 | 4.2 | 4.6 | 5.0 | 5.4 |
| Accounts Payable, % | 5.81 | 11.37 | 9.72 | 9.53 | 0 | 7.29 | 7.29 | 7.29 | 7.29 | 7.29 |
| Capital Expenditure | -1.0 | -.9 | -.8 | -1.2 | -1.9 | -1.4 | -1.5 | -1.6 | -1.8 | -1.9 |
| Capital Expenditure, % | -2.82 | -2.41 | -1.86 | -2.08 | -3.8 | -2.59 | -2.59 | -2.59 | -2.59 | -2.59 |
| Tax Rate, % | 18.48 | 18.48 | 18.48 | 18.48 | 18.48 | 18.48 | 18.48 | 18.48 | 18.48 | 18.48 |
| EBITAT | 9.6 | 8.9 | 10.3 | 16.8 | .0 | 10.9 | 11.9 | 12.9 | 14.0 | 15.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 60.1 | 93.7 | 62.8 | -183.2 | 12.4 | 43.3 | 14.8 | 16.1 | 17.6 | 19.1 |
| WACC, % | 10.16 | 10.17 | 10.09 | 10.15 | 10.19 | 10.15 | 10.15 | 10.15 | 10.15 | 10.15 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 87.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 19 | |||||||||
| Terminal Value | 239 | |||||||||
| Present Terminal Value | 147 | |||||||||
| Enterprise Value | 235 | |||||||||
| Net Debt | -23 | |||||||||
| Equity Value | 257 | |||||||||
| Diluted Shares Outstanding, MM | 6 | |||||||||
| Equity Value Per Share | 40.97 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real FXNC financials.
- Real-World Data: Historical data and forward-looking estimates (as shown in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on First National Corporation’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Financial Data: Gain access to precise historical data and forward-looking projections for First National Corporation (FXNC).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics like WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Visual charts and summaries that make it easy to interpret your valuation findings.
- Suitable for All Skill Levels: An intuitive layout designed for investors, CFOs, and consultants alike.
How It Works
- Download: Get the pre-configured Excel file featuring First National Corporation's (FXNC) financial data.
- Customize: Modify forecasts such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment strategy.
Why Choose This Calculator for First National Corporation (FXNC)?
- Accuracy: Utilizes real financial data from First National Corporation to ensure precise calculations.
- Flexibility: Allows users to easily adjust and test various inputs according to their needs.
- Time-Saving: Eliminates the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and precision expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing FXNC's portfolio.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights regarding First National Corporation (FXNC) to clients.
- Students and Educators: Leverage real-world data to enhance learning and practice in financial modeling.
- Banking Enthusiasts: Gain insights into how banking institutions like First National Corporation (FXNC) are valued in the financial landscape.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for First National Corporation (FXNC).
- Real-World Data: First National Corporation’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.