Citizens Financial Group logo
Citizens Financial Group Financial Model

Banking Company Financials Example (Free Excel Download)

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.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model provides a comprehensive equity valuation and scenario analysis framework for an equity research analyst evaluating Citizens Financial Group's earnings power, net interest margin trajectory, and the financial accretion of its Private Bank expansion.

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. The bank operates primarily through two business segments: Consumer Banking (approximately 60% of revenue) and Commercial Banking (approximately 40% of revenue). Geographically, the bank has a dense branch footprint across 14 states in the New England, Mid-Atlantic, and Midwest regions, whilst actively expanding its national wealth management and private banking presence in New York, Florida, and California. The business model relies on traditional spread-based banking to generate Net Interest Income, supplemented by fee-based Non-Interest Income from wealth management, capital markets, and card fees. Citizens holds a strong competitive position as a top-15 US bank by assets, competing directly with peers like KeyCorp, Fifth Third, and M&T Bank. Recent major events include the 2023 launch of Citizens Private Bank (which absorbed dozens of former First Republic bankers and reached $14.5 billion in deposits by the end of 2025), and the 2022 acquisitions of Investors Bancorp and HSBC's East Coast branches.

The downloadable Citizens Financial Group 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 & AssumptionsCitizens Financial Group financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$1.32B$1.30B$1.27B$1.53B$1.64B
Net interest income$4.51B$6.01B$6.24B$5.63B$5.85B
Net interest income after provision (benefit) for credit losses$4.92B$5.54B$5.55B$4.95B$5.25B
Net income$2.32B$2.07B$1.61B$1.51B$1.83B

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
1.9%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
15.0%
D&A % of revenue
30.0%
Effective tax rate
20.8%
See 8 more
Capex % of revenue
3.0%
Net working capital % of revenue
0.0%
Other assets % of revenue
500.0%
Other liabilities % of revenue
500.0%
Annual debt paydown
5.0%
Interest rate on debt
10.5%
Dividend payout ratio
42.9%
Buybacks % of net income
34.0%

How to build a detailed financial model for Citizens Financial Group

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

Revenue Deep Dive

Consumer Banking

  • Segment name: Consumer Banking
  • Revenue driver formula: (Average Consumer Loans x Consumer Asset Yield) + (Average Consumer Deposits x Deposit Spread) + Wealth Management Fees + Card and Deposit Fees
  • Historical growth rate: 2% to 4% CAGR
  • Key growth levers and headwinds: Growth is currently driven by the rapid scaling of Citizens Private Bank, which is attracting high-net-worth deposits and wealth AUM. Headwinds include deposit beta pressures (customers shifting to higher-yielding products) and subdued mortgage origination volumes.
  • Pricing dynamics: Highly competitive spot pricing for deposits; loan pricing is a mix of fixed-rate (mortgages, auto) and variable-rate products.
  • Revenue recognition notes: Interest income is recognised over the life of the loans using the effective interest method; wealth fees are recognised over time as services are rendered based on AUM.
  • Seasonality: Mild seasonality, with Q2 and Q3 typically showing stronger mortgage origination and card transaction volumes.

Commercial Banking

  • Segment name: Commercial Banking
  • Revenue driver formula: (Average Commercial Loans x Commercial Asset Yield) + Capital Markets Fees + Treasury Solutions Fees
  • Historical growth rate: 4% to 6% CAGR
  • Key growth levers and headwinds: Driven by middle-market corporate loan demand, M&A advisory pipelines, and loan syndication volumes. Headwinds include elevated interest rates dampening corporate borrowing and commercial real estate (CRE) refinancing risks.
  • Pricing dynamics: Most commercial loans are floating rate (tied to SOFR), meaning asset yields reprice quickly with central bank policy changes.
  • Revenue recognition notes: Capital markets advisory fees are recognised at a point in time upon transaction completion; treasury solutions fees are recognised monthly.
  • Seasonality: Q4 is historically the strongest quarter for capital markets and M&A advisory closures.

Cost Structure

Variable Costs / COGS

  • Line-by-line breakdown: For a bank, "COGS" is effectively Interest Expense. This includes Interest on Deposits, Interest on Short-Term Borrowings, and Interest on Long-Term Debt.
  • Gross margin range: Banks use Net Interest Margin (NIM) instead of gross margin. CFG's NIM has ranged from 2.70% to 3.30% over the last 5 years, landing at 3.06% in Q4 2025.
  • Key input costs: The Federal Funds rate, wholesale funding spreads, and retail deposit betas.
  • How COGS scales: Interest expense scales directly with the volume of interest-bearing liabilities and prevailing market interest rates.

Operating Expenses (Non-Interest Expense)

  • Salaries and Employee Benefits: The largest expense line, driven by headcount. Recently elevated due to aggressive hiring for the Private Bank buildout.
  • Equipment and Software: Significant ongoing investment in digital banking platforms and cloud infrastructure.
  • Outside Services: Consulting, legal, and third-party processing fees.
  • Occupancy: Branch lease costs and corporate real estate. The bank has been optimising its branch network, leading to occasional restructuring charges.
  • Restructuring / one-time charges: Frequent in recent years due to M&A integration (Investors Bancorp) and the "Reimagine the Bank" efficiency programme.

Margin Profile

  • Efficiency Ratio: Non-interest expense divided by total revenue. CFG's efficiency ratio typically ranges from 58% to 65% (reported at 62.2% in Q4 2025). The medium-term target is the mid-50s.
  • Margin trend: NIM compressed during 2023 and 2024 due to rising deposit costs but began expanding in late 2025 as fixed-rate assets repriced higher and funding costs stabilised.
  • Segment-level margins: Commercial Banking typically operates at a lower efficiency ratio (higher margin) than Consumer Banking due to the lack of a heavy retail branch cost base.

Balance Sheet Structure

  • Total assets: Approximately $226 billion as of late 2025.
  • Key asset categories: Loans and Leases (approx $141 billion), Investment Securities (Available-for-Sale and Held-to-Maturity), and Cash/Equivalents.
  • Goodwill & intangibles: Represents approximately 3% to 4% of total assets, stemming from historical acquisitions like Investors Bancorp and JMP Group.
  • Working capital profile: Not applicable in the traditional corporate sense. The key liquidity metric is the Loan-to-Deposit Ratio (LDR), which sits at a conservative 78.3% as of Q4 2025.
  • PP&E: Minor component consisting of branch real estate, leasehold improvements, and capitalised software.
  • Right-of-use assets: Operating leases for branch locations are material but standard for the industry.

Capital Expenditure & Investment

  • Capex as % of revenue: Typically runs at 2% to 3% of total revenue, primarily focused on technology and digital transformation.
  • Maintenance capex vs. growth capex: Heavily skewed towards growth capex (digital banking, wealth management platforms) rather than physical branch maintenance.
  • Capitalised software: Material component of the equipment and software line item, amortised over 3 to 5 years.
  • M&A pattern: Historically a serial bolt-on acquirer (JMP Group, DH Capital, Investors Bancorp). Currently focused on organic growth and absorbing the Private Bank teams hired in 2023.

Debt & Capital Structure

  • Total debt: Long-term debt is approximately $11 billion, alongside $180 billion in deposits.
  • Capital Ratios: Common Equity Tier 1 (CET1) ratio is strong at 10.7% as of Q4 2025, well above the regulatory minimum and the company's 10.0% to 10.5% target range.
  • Credit rating: Investment grade (typically BBB+ / A- range depending on the agency).
  • Key debt instruments: Senior unsecured notes, subordinated debt, and Federal Home Loan Bank (FHLB) advances.
  • Interest rate profile: The bank actively uses interest rate swaps to manage the duration mismatch between floating-rate commercial loans and sticky retail deposits.
  • Share repurchase programme: Highly active. The board authorised a $1.5 billion repurchase programme in 2025, with roughly $125 million executed per quarter.
  • Dividend policy: The bank pays a quarterly dividend of $0.46 per share ($1.84 annualised), representing a payout ratio of approximately 40% to 45%.

Cash Flow Characteristics

  • Operating cash flow conversion: For banks, traditional FCF is not a relevant valuation metric. Analysts focus on Free Cash Flow to Equity (FCFE) or the Dividend Discount Model (DDM).
  • Major non-cash items: Provision for credit losses, depreciation and amortisation, and stock-based compensation.
  • Working capital cash flow impact: Changes in loan balances (use of cash) and deposit balances (source of cash) drive the bank's liquidity position.
  • Cash tax rate: The effective tax rate typically runs between 22% and 24%, benefiting slightly from tax-advantaged investments and low-income housing tax credits.

Sheet Structure

  1. Assumptions: Hardcoded drivers for loan growth, deposit growth, asset yields, deposit betas, efficiency ratio, and capital return policies.
  2. Summary & Scenarios: Dashboard showing EPS, ROTCE, NIM, CET1 ratio, and LDR under base, bull, and bear interest rate scenarios.
  3. Average Balances & Yields: The critical NIM build. Row-level detail for Average Interest-Earning Assets (Commercial Loans, Retail Loans, Investments) and Average Interest-Bearing Liabilities (Interest-bearing Deposits, Borrowings) with corresponding yields and rates.
  4. Income Statement: Mirrors the 10-K. Net Interest Income, Non-Interest Income (split by Capital Markets, Wealth, Card, etc.), Non-Interest Expense (Salaries, Occupancy, etc.), Provision for Credit Losses, and Net Income.
  5. Credit & Asset Quality: Tracks Non-Performing Assets (NPAs), Net Charge-Offs (NCOs), and the Allowance for Credit Losses (ACL) roll-forward.
  6. Balance Sheet: Period-end balances for Assets, Liabilities, and Shareholders' Equity. Must include Accumulated Other Comprehensive Income (AOCI).
  7. Capital & RWA: Calculates Risk-Weighted Assets and builds the Common Equity Tier 1 (CET1) capital ratio.
  8. Valuation: Dividend Discount Model (DDM) and Residual Income model based on ROTCE vs Cost of Equity.

Key Financial Relationships

  1. "Net Interest Income = (Average Interest-Earning Assets x Asset Yield) - (Average Interest-Bearing Liabilities x Cost of Funds)"
  2. "Net Interest Margin (NIM) = Annualised Net Interest Income / Average Interest-Earning Assets"
  3. "Provision for Credit Losses = Net Charge-Offs + Change in Allowance for Credit Losses"
  4. "Allowance for Credit Losses (End of Period) = ACL (Beginning of Period) + Provision for Credit Losses - Net Charge-Offs"
  5. "Efficiency Ratio = Non-Interest Expense / (Net Interest Income + Non-Interest Income)"
  6. "Return on Tangible Common Equity (ROTCE) = (Net Income - Preferred Dividends + Intangible Amortisation) / Average Tangible Common Equity"
  7. "Tangible Book Value per Share = (Total Equity - Preferred Equity - Goodwill - Intangible Assets) / Period-End Shares Outstanding"
  8. "Loan-to-Deposit Ratio = Period-End Total Loans and Leases / Period-End Total Deposits"
  9. "CET1 Ratio = Common Equity Tier 1 Capital / Risk-Weighted Assets"
  10. "Earnings Per Share (Diluted) = (Net Income - Preferred Dividends) / Diluted Weighted Average Shares Outstanding"

Cross-Sheet Dependencies

The Average Balances & Yields sheet is the engine of the model; it feeds Net Interest Income directly into the Income Statement. The Credit & Asset Quality sheet calculates the Provision for Credit Losses, which feeds the Income Statement, whilst the ending ACL balance feeds the Balance Sheet. The Income Statement generates Net Income, which flows into the Balance Sheet via Retained Earnings. The Balance Sheet provides the equity and asset figures required by the Capital & RWA sheet to calculate the CET1 ratio. The CET1 ratio then dictates the capacity for share repurchases and dividends on the Assumptions sheet, creating a dynamic capital return loop.

Sign Convention

  • Assets and Liabilities are entered as positive numbers.
  • Revenue and Income items are positive.
  • Expense items (Interest Expense, Non-Interest Expense, Provision for Credit Losses) are entered as positive numbers and subtracted in the relevant subtotal formulas.
  • Net Charge-Offs are entered as positive numbers.
  • Dividends and Share Repurchases are entered as positive numbers and subtracted from Retained Earnings and Common Stock respectively.

Things Most Likely to Go Wrong

  • Failing to deduct preferred stock dividends from Net Income when calculating EPS and ROTCE, which artificially inflates profitability metrics.
  • Mismatching average balances and period-end balances. NIM must be calculated using average balances, whilst LDR and capital ratios must use period-end balances.
  • Ignoring the impact of Accumulated Other Comprehensive Income (AOCI) on Tangible Book Value. Unrealised losses on Available-for-Sale (AFS) securities flow through AOCI and directly impact TBV per share.
  • Modelling the Provision for Credit Losses simply as a percentage of loans, rather than properly rolling forward the Allowance for Credit Losses (ACL) by adding Provision and subtracting Net Charge-Offs.
  • Underestimating the expense drag of the Private Bank buildout. Salaries and benefits have structurally stepped up, and modelling historical efficiency ratios without adjusting for this will overstate operating leverage.
  • Applying a static deposit beta in a changing interest rate environment. Deposit costs often lag asset yields on the way up and remain sticky on the way down.
  • Forgetting to reduce the diluted share count by the volume of share repurchases executed in the period.
  • Misaligning the tax rate. CFG benefits from specific tax-advantaged investments; using the statutory 21% corporate rate without adjusting for state taxes and tax credits will yield incorrect net income.

Validation Checks

  • "Balance sheet must balance: Total Assets = Total Liabilities + Shareholders' Equity in every period."
  • "Net Interest Margin (NIM) should remain within the 2.80% to 3.50% range based on management guidance and historical performance."
  • "Efficiency Ratio should not drop below 55% or exceed 65%; flag if outside this band."
  • "Loan-to-Deposit Ratio (LDR) should remain below 85% (currently around 78%) to reflect the bank's conservative liquidity posture."
  • "CET1 Ratio must remain above the management target of 10.0%; if it falls below, the model should automatically throttle share repurchases."
  • "Net Charge-Off (NCO) ratio should typically run between 0.35% and 0.55% of average loans; flag if credit quality deteriorates beyond 0.60%."
  • "Return on Tangible Common Equity (ROTCE) should track towards the management medium-term target of 16% to 18%."
  • "Dividend payout ratio should remain between 35% and 45% of Net Income available to common shareholders."

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
Total Loan Growth2.5%Reflects management guidance for modest loan growth driven by Private Bank and retail.
Total Deposit Growth2.0%Assumes stable deposit gathering to fund loan growth whilst running off high-cost brokered deposits.
Net Interest Margin (NIM)3.06%Actual Q4 2025 reported NIM, serving as the baseline for forward projections.
Non-Interest Income Growth6.0%Reflects recovery in Capital Markets and strong Wealth Management fee generation.
Efficiency Ratio62.2%Actual Q4 2025 reported efficiency ratio.
Net Charge-Off (NCO) Ratio0.45%Aligns with recent historical averages and management credit quality commentary.
Effective Tax Rate23.0%Standard blended rate accounting for federal, state, and tax-advantaged investments.
Quarterly Dividend per Share0.46$Actual declared dividend for Q1 2026.
Annual Share Repurchases500$ MillionsBased on the active $1.5 billion authorisation and recent quarterly run-rates of ~$125M.
Target CET1 Ratio10.5%Top end of management's stated 10.0% to 10.5% operating range.
Cost of Equity (Ke)10.0%Standard assumption for a regional bank with CFG's risk profile and beta.
Terminal Growth Rate2.0%Long-term macroeconomic growth assumption for the DDM terminal value.

Data Sources & Benchmarks

  • Filings: SEC EDGAR for CFG 10-K and 10-Q filings; Citizens Investor Relations page for quarterly earnings presentations and financial supplements.
  • Key Peers: KeyCorp (KEY), Truist Financial (TFC), M&T Bank (MTB), Fifth Third Bancorp (FITB), and Regions Financial (RF).
  • Industry Data: Federal Reserve H.8 data for weekly commercial bank balances; FDIC Quarterly Banking Profile for industry-wide NIM and credit quality trends.
  • Consensus Estimates: Bloomberg or FactSet for consensus EPS, NIM, and ROTCE estimates to validate model outputs.

Sources

Frequently asked

What is Citizens Financial Group's core business model?+

Citizens Financial Group operates as one of the largest regional banks in the United States, providing a full range of retail and commercial banking products and services. Its business model relies on generating Net Interest Income from traditional spread-based banking, supplemented by fee-based Non-Interest Income from wealth management, capital markets, and card services.

How does Citizens Financial Group generate its revenue?+

Citizens Financial Group generates revenue primarily through two segments: Consumer Banking, which accounts for approximately 60% of its revenue, and Commercial Banking, contributing about 40%. Key revenue streams include Net Interest Income from its loan and deposit activities, as well as fee-based income from services like wealth management, capital markets, and card fees.

What are the key capital expenditure assumptions for Citizens Financial Group?+

The financial model for Citizens Financial Group assumes capital expenditure typically runs at 3% of total revenue. This spending is heavily skewed towards growth capex, with a primary focus on technology and digital transformation rather than physical branch maintenance.

What is the forecast horizon for the Citizens Financial Group financial model?+

The comprehensive equity valuation and scenario analysis model for Citizens Financial Group provides a forecast horizon spanning from fiscal year 2026 through fiscal year 2030. This extended period allows for a detailed evaluation of the company's future financial performance and strategic initiatives.

What is the primary purpose of the Citizens Financial Group financial model?+

The primary purpose of the Citizens Financial Group financial model is to offer a comprehensive framework for equity valuation and scenario analysis. It is designed to help equity research analysts evaluate the company's earnings power, net interest margin trajectory, and the financial accretion resulting from its Private Bank expansion.

Is an Excel financial model available for Citizens Financial Group?+

Yes, a downloadable Excel financial model is available for Citizens Financial Group. This model provides a comprehensive framework for equity valuation and scenario analysis, aiding equity research analysts in their assessment of the company.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

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.

BAC.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Bank of America logo

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.

BK.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
BNY Mellon logo

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.

C.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Citigroup logo

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.

COF.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Capital One logo

Capital One

Capital One Financial Corporation (COF) is a diversified financial services holding company and one of the largest banks in the United States.

FITB.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Fifth Third Bancorp logo

Fifth Third Bancorp

Fifth Third Bancorp is a diversified financial services company and regional bank headquartered in Cincinnati, Ohio.

GS.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Goldman Sachs logo

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.

HBAN.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Huntington Bancshares logo

Huntington Bancshares

Huntington Bancshares Incorporated (HBAN) is a diversified regional bank holding company headquartered in Columbus, Ohio, providing commercial, consumer, and mortgage banking services.

JPM.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
JPMorgan Chase logo

JPMorgan Chase

JPMorgan Chase is a leading global financial services firm and the largest bank in the United States by total assets, providing investment banking, consumer and commercial banking, financial transaction processing, and asset management.

Explore more Financial Services financial model templates.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview