Peoples Financial Services Corp. (PFIS) 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
Peoples Financial Services Corp. (PFIS) Bundle
Gain insights into your Peoples Financial Services Corp. (PFIS) valuation analysis using our sophisticated DCF Calculator! This Excel template comes preloaded with real PFIS data, enabling you to adjust forecasts and assumptions to accurately determine the intrinsic value of Peoples Financial Services Corp.
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 | 90.6 | 96.4 | 98.1 | 108.1 | 163.6 | 192.1 | 225.6 | 264.9 | 311.0 | 365.2 |
| Revenue Growth, % | 0 | 6.4 | 1.74 | 10.14 | 51.39 | 17.42 | 17.42 | 17.42 | 17.42 | 17.42 |
| EBITDA | 33.1 | 38.4 | 57.2 | 49.4 | 36.0 | 77.7 | 91.3 | 107.2 | 125.9 | 147.8 |
| EBITDA, % | 36.52 | 39.84 | 58.26 | 45.71 | 22 | 40.47 | 40.47 | 40.47 | 40.47 | 40.47 |
| Depreciation | 4.2 | 4.3 | 3.6 | 4.0 | 3.5 | 7.2 | 8.4 | 9.9 | 11.6 | 13.6 |
| Depreciation, % | 4.65 | 4.41 | 3.71 | 3.73 | 2.14 | 3.73 | 3.73 | 3.73 | 3.73 | 3.73 |
| EBIT | 28.9 | 34.2 | 53.5 | 45.4 | 32.5 | 70.6 | 82.9 | 97.3 | 114.3 | 134.2 |
| EBIT, % | 31.87 | 35.44 | 54.54 | 41.98 | 19.86 | 36.74 | 36.74 | 36.74 | 36.74 | 36.74 |
| Total Cash | 361.6 | 341.1 | 554.8 | 515.6 | 187.4 | 192.1 | 225.6 | 264.9 | 311.0 | 365.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 7.0 | 8.3 | 8.5 | 11.7 | .0 | 13.8 | 16.2 | 19.0 | 22.3 | 26.1 |
| Account Receivables, % | 7.71 | 8.56 | 8.69 | 10.84 | 0 | 7.16 | 7.16 | 7.16 | 7.16 | 7.16 |
| Inventories | -38.6 | -237.3 | -289.1 | -49.7 | .0 | -110.9 | -130.2 | -152.9 | -179.5 | -210.8 |
| Inventories, % | -42.57 | -246.06 | -294.61 | -45.99 | 0 | -57.71 | -57.71 | -57.71 | -57.71 | -57.71 |
| Accounts Payable | 1.3 | .7 | .4 | .9 | 5.8 | 2.7 | 3.1 | 3.7 | 4.3 | 5.1 |
| Accounts Payable, % | 1.41 | 0.76315 | 0.41583 | 0.83555 | 3.52 | 1.39 | 1.39 | 1.39 | 1.39 | 1.39 |
| Capital Expenditure | -5.6 | -2.3 | -4.9 | -7.8 | -5.9 | -9.4 | -11.0 | -12.9 | -15.2 | -17.8 |
| Capital Expenditure, % | -6.18 | -2.38 | -4.98 | -7.25 | -3.62 | -4.88 | -4.88 | -4.88 | -4.88 | -4.88 |
| Tax Rate, % | 15.76 | 15.76 | 15.76 | 15.76 | 15.76 | 15.76 | 15.76 | 15.76 | 15.76 | 15.76 |
| EBITAT | 25.5 | 29.4 | 44.0 | 38.1 | 27.4 | 59.9 | 70.4 | 82.7 | 97.0 | 114.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 57.0 | 228.2 | 93.9 | -207.8 | -8.2 | 151.8 | 85.2 | 100.0 | 117.4 | 137.9 |
| WACC, % | 18.26 | 17.91 | 17.38 | 17.63 | 17.67 | 17.77 | 17.77 | 17.77 | 17.77 | 17.77 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 373.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 141 | |||||||||
| Terminal Value | 892 | |||||||||
| Present Terminal Value | 394 | |||||||||
| Enterprise Value | 767 | |||||||||
| Net Debt | 33 | |||||||||
| Equity Value | 734 | |||||||||
| Diluted Shares Outstanding, MM | 7 | |||||||||
| Equity Value Per Share | 102.66 |
What You Will Receive
- Pre-Configured Financial Model: Peoples Financial Services Corp. (PFIS) data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Real-Time Calculations: Instant updates ensure you observe outcomes as you implement changes.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, allowing for repeated use in detailed forecasting.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as loan growth, interest margins, and operational expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Results: Leverages Peoples Financial Services Corp.'s (PFIS) actual financial data for accurate valuation estimates.
- Streamlined Scenario Analysis: Effortlessly evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Remove the complexity of creating detailed valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template with Peoples Financial Services Corp.'s (PFIS) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Peoples Financial Services Corp.'s (PFIS) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose Peoples Financial Services Corp. (PFIS)?
- Streamlined Process: Skip the hassle of building financial models from the ground up – our tools are readily available.
- Enhanced Accuracy: Dependable financial metrics and calculations minimize valuation errors.
- Completely Customizable: Adjust the platform to align with your specific financial assumptions and forecasts.
- User-Friendly Interface: Intuitive graphs and outputs facilitate straightforward analysis of results.
- Endorsed by Professionals: Crafted for industry experts who prioritize accuracy and convenience.
Who Should Use This Product?
- Investors: Evaluate Peoples Financial Services Corp.'s (PFIS) performance before making investment decisions.
- CFOs and Financial Analysts: Enhance financial analysis and streamline valuation methods for accurate forecasting.
- Startup Founders: Gain insights into how financial services companies like Peoples Financial Services Corp. (PFIS) are valued.
- Consultants: Create detailed valuation reports and analyses for your clients in the financial sector.
- Students and Educators: Utilize current market data to learn and teach financial valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Peoples Financial Services Corp. (PFIS) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Peoples Financial Services Corp. (PFIS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.