PNC Financial Services Financial Model
Banking Company Financials Example (Free Excel Download)
PNC Financial Services Group is one of the largest diversified financial services institutions in the United States, operating a coast-to-coast retail branch network and a premier corporate banking franchise.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates the equity valuation and capital return capacity of PNC Financial Services Group, focusing on net interest margin trajectory, loan growth, and the financial integration of the recent FirstBank acquisition, to determine if the stock is attractively priced for a fundamental equity investor.
PNC Financial Services Group is one of the largest diversified financial services institutions in the United States, operating a coast-to-coast retail branch network and a premier corporate banking franchise. The company generates revenue through traditional spread-based banking activities and fee-based services such as asset management and capital markets advisory.
PNC operates through three primary business segments: Retail Banking (roughly 45-50% of revenue), Corporate & Institutional Banking (roughly 40-45% of revenue), and the Asset Management Group (roughly 5-10% of revenue). The business model is asset-heavy, relying on a massive deposit base to fund commercial and consumer lending, while leveraging its scale to generate noninterest fee income. PNC is a top-10 US bank by assets and competes directly with other super-regional banks like U.S. Bancorp and Truist, as well as money-center banks. A major recent event is the acquisition of FirstBank Holding Company, which closed in January 2026 for approximately $4.1 billion, adding $26 billion in assets and expanding PNC's presence in Colorado and Arizona.
The downloadable PNC Financial Services financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsPNC Financial Services financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $19.21B | $21.12B | $21.49B | $21.55B | $23.10B |
| Net interest income | $10.65B | $13.01B | $13.92B | $13.50B | $14.41B |
| Total noninterest income | $8.56B | $8.11B | $7.57B | $8.06B | $8.69B |
| Net income | $5.72B | $6.11B | $5.65B | $5.95B | $7.00B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for PNC Financial Services
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
As a bank, PNC's revenue is split into Net Interest Income (NII) and Noninterest Income.
Net Interest Income (NII)
- Segment name: Net Interest Income
- Revenue driver formula: Average Interest-Earning Assets x Net Interest Margin (NIM)
- Historical growth rate: Highly variable based on the interest rate cycle; FY2025 NII was $14.4 billion (up 7% YoY).
- Key growth levers and headwinds: Loan volume growth (guided at 8% for 2026 including FirstBank), deposit beta (how fast deposit costs rise relative to asset yields), and fixed-rate asset repricing.
- Pricing dynamics: Driven by the Federal Reserve's policy rate, the shape of the yield curve, and competitive deposit pricing.
- Seasonality: Day count in the quarter affects NII (Q1 typically has fewer days than Q4).
Noninterest Income
- Segment name: Noninterest Income (Totalled $8.7 billion in FY2025)
- Sub-lines:
- Asset management and brokerage: Driven by AUM and equity market performance.
- Capital markets and advisory: Driven by M&A deal volume and underwriting activity.
- Card and cash management: Driven by consumer and commercial transaction volumes.
- Lending and deposit services: Driven by loan commitment fees and account maintenance fees.
- Residential and commercial mortgage: Driven by origination volumes and valuation of mortgage servicing rights (MSRs).
- Historical growth rate: 3-6% CAGR, though capital markets and mortgage lines are highly cyclical.
- Revenue recognition notes: Fees are generally recognised when the service is provided; MSRs are carried at fair value with changes recorded in current earnings.
Cost Structure
Interest Expense (Cost of Funds)
- Line-by-line breakdown: Interest on deposits, interest on borrowed funds (FHLB advances, senior debt, subordinated notes).
- Dynamics: Scales with the absolute level of interest rates and the mix of noninterest-bearing vs. interest-bearing deposits.
Provision for Credit Losses
- Line-by-line breakdown: Provision for loan and lease losses, provision for unfunded commitments.
- Dynamics: Driven by net charge-offs (NCOs) and changes to the Allowance for Credit Losses (ACL) based on macroeconomic forecasts (CECL methodology). NCOs ran at approximately 0.20% of average loans in FY2025.
Noninterest Expense (Operating Expenses)
- Personnel compensation and benefits: The largest expense, driven by headcount (~55,000 employees) and variable compensation tied to capital markets performance.
- Equipment and occupancy: Branch network costs, lease expenses, and depreciation.
- Technology and third-party services: Cloud migration, cybersecurity, and digital banking investments.
- Marketing and public relations: Customer acquisition costs.
- Restructuring / one-time charges: PNC expects $325 million in merger and integration costs in the first half of 2026 related to the FirstBank acquisition.
Margin Profile
- Net Interest Margin (NIM): Ranged from 2.75% to 2.84% throughout 2024 and 2025.
- Efficiency Ratio (Noninterest Expense / Total Revenue): Typically runs between 59% and 62% (59% in Q4 2025). Lower is better.
- Margin trend: NIM has been expanding slightly due to fixed-rate asset repricing, while the efficiency ratio has improved due to positive operating leverage.
Balance Sheet Structure
- Total assets: Approximately $560 billion (pre-FirstBank), scaling to nearly $590 billion post-acquisition.
- Key asset categories:
- Loans and Leases (~$331 billion): Commercial and industrial (C&I), commercial real estate (CRE), residential real estate, consumer.
- Investment Securities (~$142 billion): Primarily agency MBS and Treasury securities, split between Available-for-Sale (AFS) and Held-to-Maturity (HTM).
- Cash and Due from Banks.
- Goodwill & intangibles: Material due to historical acquisitions (National City, BBVA USA, FirstBank).
- Working capital profile: Not applicable for banks. Focus is on the Loan-to-Deposit Ratio (LDR), which sits around 75%, indicating strong liquidity and deposit funding.
- PP&E: Branch real estate and corporate offices; relatively small percentage of total assets.
Capital Expenditure & Investment
- Capex as % of revenue: Minimal in the traditional sense; banks capitalise software and invest in branch renovations.
- M&A pattern: Transformational and bolt-on acquirer. Acquired BBVA USA in 2021 for $11.6 billion and FirstBank in 2026 for $4.1 billion.
- Capitalised software: Material part of the technology budget, amortised over 3-5 years.
Debt & Capital Structure
- Total debt: Borrowed funds total approximately $65 billion.
- Capital Ratios: Common Equity Tier 1 (CET1) ratio was 10.6% at the end of 2025, well above the regulatory minimum plus the 2.5% Stress Capital Buffer (SCB).
- Credit rating: AA (low) from Morningstar DBRS; highly rated.
- Key debt instruments: Senior notes, subordinated debt (qualifying as Tier 2 capital), FHLB advances.
- Share repurchase programme: Highly active. PNC repurchased $400 million in Q4 2025 and expects $600 to $700 million in Q1 2026.
- Dividend policy: $1.70 per share quarterly ($6.80 annualised), representing a yield of approximately 3.0%.
Cash Flow Characteristics
- Operating cash flow: Not a primary valuation metric for banks.
- Free cash flow: Banks are valued on Free Cash Flow to Equity (FCFE) or via a Dividend Discount Model (DDM), which measures capital available to be distributed to shareholders after meeting regulatory capital requirements.
- Major non-cash items: Provision for credit losses, depreciation, amortisation of intangibles, deferred taxes.
- Cash tax rate: The effective tax rate was 12.7% in Q4 2025 due to favourable resolutions, but management guides to a normalised rate of 19.5% for 2026.
Sheet Structure
- Assumptions: Macroeconomic drivers (Fed Funds rate), loan growth rates, deposit betas, fee income growth, and capital return targets.
- Average Balance Sheet: Average balances for all interest-earning assets and interest-bearing liabilities, with associated yields and rates.
- Income Statement: NII, Noninterest Income, Provision, Noninterest Expense, Taxes, and Net Income.
- Period-End Balance Sheet: Assets, Liabilities, and Shareholders' Equity.
- Loan Book & Credit Quality: Loan balances by category, NCOs, and the Allowance for Credit Losses (ACL) roll-forward.
- Noninterest Income & Expense: Detailed build of fee income lines and operating expense categories.
- Capital & RWA: Calculation of Risk-Weighted Assets, Tier 1 Capital, CET1 Capital, and the CET1 ratio.
- Valuation (DDM): Dividend Discount Model projecting future dividends and share repurchases, discounted at the cost of equity.
Key Financial Relationships
- `Net Interest Income = (Average Interest-Earning Assets x Asset Yield) - (Average Interest-Bearing Liabilities x Cost of Funds)`
- `Net Interest Margin = Net Interest Income / Average Interest-Earning Assets`
- `Total Revenue = Net Interest Income + Total Noninterest Income`
- `Provision for Credit Losses = Net Charge-Offs + Change in Allowance for Credit Losses`
- `Allowance for Credit Losses (End of Period) = ACL (Beginning of Period) + Provision for Credit Losses - Net Charge-Offs`
- `Efficiency Ratio = Total Noninterest Expense / Total Revenue`
- `Pretax, Pre-Provision Earnings (PPNR) = Total Revenue - Total Noninterest Expense`
- `Net Income = PPNR - Provision for Credit Losses - Income Taxes`
- `Risk-Weighted Assets = Total Assets x Average Risk Weighting Percentage`
- `CET1 Ratio = Common Equity Tier 1 Capital / Risk-Weighted Assets`
- `Tangible Book Value = Total Shareholders' Equity - Goodwill - Intangible Assets - Preferred Stock`
- `Return on Tangible Common Equity (ROTCE) = (Net Income - Preferred Dividends) / Average Tangible Common Equity`
Cross-Sheet Dependencies
- The Average Balance Sheet is the engine of the model; it feeds directly into the Income Statement to calculate Net Interest Income.
- The Loan Book & Credit Quality sheet calculates the Provision for Credit Losses, which feeds the Income Statement, and the ending ACL, which feeds the Period-End Balance Sheet.
- Net Income from the Income Statement flows into Retained Earnings on the Period-End Balance Sheet and serves as the starting point for capital generation in the Capital & RWA sheet.
- The Capital & RWA sheet determines how much excess capital is available for share repurchases and dividends, which then loops back to reduce Equity on the Period-End Balance Sheet and reduces share count for EPS calculations.
Sign Convention
- Assets and Liabilities: Entered as positive numbers.
- Revenues and Expenses: Entered as positive numbers. Expenses are subtracted in subtotal formulas (e.g., `Revenue - Expense`).
- Net Charge-Offs: Entered as positive numbers.
- Contra-assets (like ACL): Entered as positive numbers but subtracted from gross loans to reach net loans.
- Dividends and Repurchases: Entered as positive numbers, subtracted from equity in the roll-forward.
Things Most Likely to Go Wrong
- Mixing Average and Period-End Balances: Bank NII is calculated using average balances, not period-end balances. Using period-end balances will distort the NIM calculation.
- FirstBank Integration: The model must account for the $26 billion asset addition in Q1 2026 and the $325 million in one-time integration costs. Failing to step up the balance sheet will result in understated 2026 NII.
- Visa Derivative Adjustments: PNC frequently reports volatile Visa derivative adjustments in its "Other noninterest income" line (e.g., negative $41 million in Q4 2025). These should be modelled as zero in future periods or normalised.
- AOCI Volatility: Accumulated Other Comprehensive Income (AOCI) fluctuates wildly with interest rates due to the mark-to-market on the AFS securities portfolio. The model should hold AOCI flat in the forecast unless specific rate shocks are modelled.
- Provision vs. Charge-offs: Builders often confuse the two. Charge-offs represent actual loan losses; the provision is the income statement expense taken to maintain the balance sheet reserve (ACL).
- Share Count Circularity: Share repurchases reduce the share count, which increases EPS, but repurchases depend on the stock price and excess capital. Use a simple target dollar amount for repurchases to avoid complex circularities.
- Tax Rate Normalisation: The Q4 2025 tax rate was artificially low (12.7%). Using this for the forecast will overstate net income; management guidance is 19.5%.
Validation Checks
- Balance Sheet Check: Total Assets must equal Total Liabilities + Shareholders' Equity in every period.
- Efficiency Ratio Check: Must remain between 58% and 62%. Flag if it drops below 55% or rises above 65%.
- CET1 Ratio Check: Must remain above the regulatory minimum of 7.0% (4.5% base + 2.5% SCB). PNC targets ~10.0%+.
- NIM Check: Should remain between 2.70% and 2.95% based on recent historical ranges.
- Loan-to-Deposit Ratio Check: Should remain between 70% and 85%. If it exceeds 100%, the bank has a severe funding shortfall.
- NCO Ratio Check: Annualised Net Charge-Offs should be between 0.15% and 0.35% of average loans in a benign economic environment.
- Effective Tax Rate Check: Should equal approximately 19.5% in forecast periods.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Average Loan Growth (2026) | 8.0 | % | Management guidance for 2026, inclusive of the FirstBank acquisition. |
| Average Deposit Growth (2026) | 4.0 | % | Estimated to fund loan growth while maintaining a stable LDR. |
| Net Interest Margin (NIM) | 2.85 | % | Slight expansion from Q4 2025 (2.84%) due to fixed-rate asset repricing. |
| Noninterest Income Growth | 6.0 | % | Management guidance for 2026. |
| Core Noninterest Expense Growth | 7.0 | % | Management guidance for 2026 (excluding integration costs). |
| FirstBank Integration Costs | 325 | $ Millions | Hardcoded one-time expense guided for H1 2026. |
| Net Charge-Off (NCO) Ratio | 0.22 | % | Slight normalisation from 2025 levels (0.20%). |
| Effective Tax Rate | 19.5 | % | Management guidance for 2026. |
| Quarterly Dividend per Share | 1.70 | $ | Current declared dividend rate. |
| Q1 2026 Share Repurchases | 650 | $ Millions | Midpoint of management guidance ($600M - $700M). |
| Cost of Equity (Ke) | 9.5 | % | Standard assumption for a large-cap US bank in the current rate environment. |
| Terminal Growth Rate | 2.0 | % | Long-term GDP growth proxy for terminal value in the DDM. |
Data Sources & Benchmarks
- Filings: SEC EDGAR for PNC's 10-K and 10-Q filings; PNC Investor Relations website for earnings supplements and call transcripts.
- Key Peers: U.S. Bancorp (USB), Truist Financial (TFC), Fifth Third Bancorp (FITB), KeyCorp (KEY).
- Industry Data: Federal Reserve H.8 data (Assets and Liabilities of Commercial Banks in the United States) for macro loan and deposit growth trends.
- Consensus Estimates: Bloomberg or FactSet for consensus EPS, NIM, and loan growth estimates.
Sources
Do more with the PNC Financial Services model
Frequently asked
What does PNC Financial Services do?+
PNC Financial Services Group is one of the largest diversified financial services institutions in the United States. It operates a coast-to-coast retail branch network and a premier corporate banking franchise, generating revenue through traditional banking and fee-based services.
How does PNC Financial Services generate revenue?+
PNC's revenue is primarily split into Net Interest Income from its lending activities and Noninterest Income from fee-based services. These fee-based services include asset management and capital markets advisory, leveraging its scale to generate diverse income streams.
What is a key revenue growth assumption for PNC Financial Services in financial models?+
A key revenue growth assumption for PNC Financial Services in financial models is approximately 6.29%. This figure helps project future income, considering factors like net interest margin trajectory and overall loan growth.
What is the purpose of a financial model for PNC Financial Services?+
The purpose of a financial model for PNC Financial Services is to evaluate the company's equity valuation and capital return capacity. It helps determine if the stock is attractively priced for fundamental equity investors by analyzing key financial drivers.
Can I download an Excel financial model for PNC Financial Services?+
Yes, an Excel financial model for PNC Financial Services is available for download. This model provides a forecast horizon from FY2026 to FY2030, incorporating key assumptions for financial analysis.
How has the FirstBank acquisition impacted PNC Financial Services?+
The acquisition of FirstBank Holding Company in January 2026 significantly expanded PNC's presence in Colorado and Arizona. This transaction added approximately $26 billion in assets, influencing PNC's overall balance sheet and future growth trajectory.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Banking Company Financial Models
Browse another company in the same sector.
Bank of America
Bank of America is one of the world's largest financial institutions, serving individual consumers, small and middle-market businesses, and large corporations with a full range of banking, investing, asset management, and risk management products.
BNY Mellon
The Bank of New York Mellon Corporation (BNY Mellon) is a globally systemic financial services institution that primarily operates as a trust bank, providing investment management, investment services, and wealth management to institutions and high-net-worth individuals.
Citigroup
Citigroup is a globally diversified financial services holding company providing consumer and corporate banking, investment banking, wealth management, and markets services across international markets.
Citizens Financial Group
Citizens Financial Group (CFG) is one of the largest regional banks in the United States, providing retail and commercial banking products and services to individuals, small businesses, middle-market companies, and large corporations.
Capital One
Capital One Financial Corporation (COF) is a diversified financial services holding company and one of the largest banks in the United States.
Fifth Third Bancorp
Fifth Third Bancorp is a diversified financial services company and regional bank headquartered in Cincinnati, Ohio.
Goldman Sachs
Goldman Sachs is a leading global financial institution that delivers a broad range of financial services across investment banking, securities, investment management, and consumer banking to a large and diversified client base.
Huntington Bancshares
Huntington Bancshares Incorporated (HBAN) is a diversified regional bank holding company headquartered in Columbus, Ohio, providing commercial, consumer, and mortgage banking services.
Explore more Financial Services financial model templates.
