|
Park National Corporation (PRK) DCF Valuation
US | Financial Services | Banks - Regional | AMEX
|
- ✓ 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
Park National Corporation (PRK) Bundle
Whether you’re an investor or analyst, this (PRK) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from Park National Corporation, you can adjust forecasts and observe the effects in real-time.
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 | 394.9 | 453.3 | 459.8 | 483.0 | 462.8 | 482.6 | 503.2 | 524.7 | 547.1 | 570.5 |
Revenue Growth, % | 0 | 14.78 | 1.44 | 5.04 | -4.17 | 4.27 | 4.27 | 4.27 | 4.27 | 4.27 |
EBITDA | 136.2 | 167.7 | 187.5 | 194.3 | 168.9 | 182.4 | 190.2 | 198.3 | 206.8 | 215.6 |
EBITDA, % | 34.49 | 37 | 40.77 | 40.22 | 36.5 | 37.8 | 37.8 | 37.8 | 37.8 | 37.8 |
Depreciation | 11.5 | 13.1 | 15.1 | 15.3 | 15.3 | 15.0 | 15.6 | 16.3 | 17.0 | 17.7 |
Depreciation, % | 2.9 | 2.88 | 3.28 | 3.17 | 3.31 | 3.11 | 3.11 | 3.11 | 3.11 | 3.11 |
EBIT | 124.8 | 154.6 | 172.4 | 179.0 | 153.6 | 167.4 | 174.6 | 182.0 | 189.8 | 197.9 |
EBIT, % | 31.59 | 34.12 | 37.48 | 37.06 | 33.19 | 34.69 | 34.69 | 34.69 | 34.69 | 34.69 |
Total Cash | 1,369.7 | 1,429.8 | 1,973.3 | 1,923.4 | 218.3 | 431.6 | 450.0 | 469.3 | 489.3 | 510.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | 54.3 | 63.3 | 24.1 | 25.1 | 26.2 | 27.3 | 28.4 |
Account Receivables, % | 0 | 0 | 0 | 11.25 | 13.67 | 4.98 | 4.98 | 4.98 | 4.98 | 4.98 |
Inventories | -294.4 | -504.0 | -390.8 | .0 | .0 | -250.5 | -261.2 | -272.4 | -284.0 | -296.1 |
Inventories, % | -74.54 | -111.18 | -84.98 | 0 | 0 | -51.91 | -51.91 | -51.91 | -51.91 | -51.91 |
Accounts Payable | 2.9 | 3.9 | 3.1 | 3.5 | 6.9 | 4.3 | 4.5 | 4.7 | 4.9 | 5.1 |
Accounts Payable, % | 0.74114 | 0.85154 | 0.67763 | 0.72175 | 1.48 | 0.89484 | 0.89484 | 0.89484 | 0.89484 | 0.89484 |
Capital Expenditure | -14.9 | -28.6 | -14.1 | -7.9 | -7.6 | -15.9 | -16.5 | -17.2 | -18.0 | -18.8 |
Capital Expenditure, % | -3.77 | -6.32 | -3.06 | -1.64 | -1.64 | -3.29 | -3.29 | -3.29 | -3.29 | -3.29 |
Tax Rate, % | 17.49 | 17.49 | 17.49 | 17.49 | 17.49 | 17.49 | 17.49 | 17.49 | 17.49 | 17.49 |
EBITAT | 102.7 | 127.9 | 141.0 | 147.1 | 126.7 | 137.8 | 143.7 | 149.8 | 156.2 | 162.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 396.6 | 322.8 | 28.1 | -290.3 | 128.9 | 424.1 | 152.6 | 159.1 | 165.9 | 173.0 |
WACC, % | 9.18 | 9.2 | 9.17 | 9.18 | 9.19 | 9.18 | 9.18 | 9.18 | 9.18 | 9.18 |
PV UFCF | ||||||||||
SUM PV UFCF | 867.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 176 | |||||||||
Terminal Value | 2,457 | |||||||||
Present Terminal Value | 1,584 | |||||||||
Enterprise Value | 2,451 | |||||||||
Net Debt | 207 | |||||||||
Equity Value | 2,243 | |||||||||
Diluted Shares Outstanding, MM | 16 | |||||||||
Equity Value Per Share | 138.05 |
What You Will Get
- Accurate PRK Financials: Access to historical and projected data for precise valuation.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Testing: Explore various scenarios to assess Park National Corporation's future performance.
- User-Friendly Interface: Designed for finance professionals while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Park National Corporation (PRK).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to Park National Corporation (PRK).
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit Park National Corporation (PRK).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Park National Corporation (PRK).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis of Park National Corporation (PRK).
How It Works
- Step 1: Download the prebuilt Excel template featuring Park National Corporation’s (PRK) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the key metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including Park National Corporation’s (PRK) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports using the generated outputs.
Why Choose This Calculator for Park National Corporation (PRK)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Park National Corporation (PRK).
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Park National Corporation’s (PRK) intrinsic value and Net Present Value.
- Ready-to-Use Data: Comes with historical and projected data for reliable analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business consultants focusing on Park National Corporation (PRK).
Who Should Use This Product?
- Investors: Accurately assess Park National Corporation’s (PRK) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for financial reporting and strategic analysis.
- Consultants: Easily customize the template for valuation reports tailored to clients.
- Entrepreneurs: Acquire knowledge of financial modeling techniques employed by leading firms.
- Educators: Implement it as a resource to illustrate valuation methodologies in the classroom.
What the Template Contains
- Historical Data: Includes Park National Corporation’s (PRK) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Park National Corporation’s (PRK) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Park National Corporation’s (PRK) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.