U.S. Bancorp Financial Model

• Total assets: Approximately $695 billion as of late 2025.
• Key asset categories: Commercial Loans, Commercial Real Estate (CRE) Loans, Residential Mortgages, Credit Card Loans, and Investment Securities (Available-for-Sale and Held-to-Maturity).
• Goodwill & intangibles: Material due to historical acquisitions (Elavon, Union Bank).
• Working capital profile: Not applicable in the traditional corporate sense. Banks manage liquidity via the Loan-to-Deposit Ratio (typically 70-75% for U.S. Bancorp) and Liquidity Coverage Ratio (LCR).
• PP&E: Minor relative to total assets; consists of branch real estate and data centres.
• Right-of-use assets: Operating leases for branches are present but not a primary driver of balance sheet risk.

• Capex as % of revenue: Traditional capex is minimal. The bank focuses on technology investments and capitalised software.
• Maintenance capex vs. growth capex: Primarily growth-oriented technology spend to improve digital banking and payment processing platforms.
• Major capex programmes underway: Cloud migration and digital sales platform enhancements.
• M&A pattern: Transformational (Union Bank in 2022) and strategic bolt-ons (BTIG announced for 2026).
• Typical acquisition multiple paid: Usually 1.5x to 2.0x tangible book value for bank acquisitions.

• Total debt: The bank relies primarily on deposits ($522 billion), supplemented by short-term borrowings and long-term senior/subordinated debt.
• Capital Ratios: Common Equity Tier 1 (CET1) ratio is the critical metric. It stood at 10.8% at the end of 2025.
• Credit rating: Highly rated (typically A+/A1 or better), reflecting a conservative credit culture.
• Key debt instruments: Senior notes, subordinated debt (Tier 2 capital), and preferred stock (Additional Tier 1 capital).
• Interest rate profile: A mix of fixed and floating, heavily managed through interest rate swaps to achieve the desired asset-liability duration match.
• Share repurchase programme: Active when capital exceeds the internal target of roughly 10.0% to 10.5% CET1.
• Dividend policy: Target payout ratio of approximately 35% to 45% of earnings.

• Operating cash flow conversion: Not a relevant metric for banks. Analysts focus on Net Income Available to Common Shareholders and Capital Generation.
• Free cash flow margin: Replaced by "Free Capital Generation" (Net Income minus Dividends minus Capital required to fund Risk-Weighted Asset growth).
• Major non-cash items: Provision for credit losses, depreciation, and amortisation of intangibles.
• Working capital cash flow impact: Replaced by deposit inflows/outflows and loan originations/paydowns.
• Cash tax rate vs. GAAP effective tax rate: Effective tax rate is typically 21-23%. The bank benefits significantly from tax-advantaged investments like low-income housing tax credits (LIHTC).

1. Assumptions: Macroeconomic drivers (Fed Funds rate, GDP growth), loan growth rates by category, deposit betas, fee income growth rates, and capital return targets.
2. Summary: Dashboard showing EPS, ROTCE, Efficiency Ratio, CET1 Ratio, and Net Interest Margin trends.
3. Average Balances & Yields: The core engine of the bank model. Projects average earning assets, average interest-bearing liabilities, yields, and rates to calculate Net Interest Income.
4. Income Statement: Consolidated statement of income, separating Net Interest Income, Noninterest Income (by segment), Noninterest Expense, and Provision for Credit Losses.
5. Credit & Reserves: Roll-forward of the Allowance for Credit Losses (Beginning Balance + Provision - Net Charge-Offs = Ending Balance) and nonperforming asset tracking.
6. Balance Sheet: Period-end balances for all asset, liability, and equity line items. Must include Accumulated Other Comprehensive Income (AOCI) tracking.
7. Capital & RWA: Calculation of Risk-Weighted Assets, Tier 1 Capital, CET1 Ratio, and the mechanics of share repurchases and dividends.
8. Valuation: Dividend Discount Model (DDM) and Residual Income Model, as DCF is inappropriate for banks.

1. "Net Interest Income = (Average Earning Assets x Asset Yield) - (Average Interest-Bearing Liabilities x Cost of Funds)"
2. "Net Interest Margin = Annualised Net Interest Income / Average Earning Assets"
3. "Payment Services Revenue = Payment Volume x Blended Take Rate"
4. "Total Noninterest Income = Payment Services + Trust and Investment Management + Mortgage Banking + Commercial Products + Other"
5. "Allowance for Credit Losses (Ending) = Allowance (Beginning) + Provision for Credit Losses - Net Charge-Offs"
6. "Net Charge-Offs = Average Total Loans x Net Charge-Off Ratio"
7. "Efficiency Ratio = Total Noninterest Expense / (Net Interest Income + Total Noninterest Income)"
8. "Pre-Provision Net Revenue (PPNR) = Net Interest Income + Noninterest Income - Noninterest Expense"
9. "Net Income Available to Common = Net Income - Preferred Dividends"
10. "CET1 Capital = Common Equity - Goodwill - Intangibles +/- AOCI Adjustments"
11. "CET1 Ratio = CET1 Capital / Risk-Weighted Assets"
12. "Return on Tangible Common Equity (ROTCE) = Annualised Net Income Available to Common / Average Tangible Common Equity"

The Average Balances & Yields sheet is the foundation. It feeds Net Interest Income into the Income Statement. The Income Statement generates Net Income, which feeds into the Capital & RWA sheet to build Common Equity. The Credit & Reserves sheet calculates the Provision for Credit Losses, which flows back to the Income Statement, while the ending Allowance balance flows to the Balance Sheet. The Capital & RWA sheet determines excess capital, which dictates the share buybacks in the Assumptions sheet, creating a circular reference loop (buybacks reduce equity, which changes average share count, which changes EPS).

• Assets and Liabilities are positive on the Balance Sheet.
• Contra-assets (like Allowance for Credit Losses) are negative on the Balance Sheet.
• Revenues and Expenses are positive on the Income Statement.
• In formulas, subtract Expenses and Provision from Revenue to calculate Net Income.
• Net Charge-Offs are positive inputs in the Credit sheet but are subtracted from the Allowance roll-forward.

• Failing to account for the day count in each quarter will cause Net Interest Income and NIM calculations to be slightly off.
• Ignoring the impact of Accumulated Other Comprehensive Income (AOCI) on tangible book value. Unrealised losses on the Available-for-Sale securities portfolio directly impact equity.
• Modelling the Provision for Credit Losses as a flat percentage of loans rather than explicitly forecasting Net Charge-Offs and changes to the Allowance reserve.
• Forgetting to deduct preferred stock dividends from Net Income when calculating Earnings Per Share and Return on Tangible Common Equity.
• Misaligning period-end balances (Balance Sheet) with average balances (NIM calculation). NII must be calculated using average balances.
• Overestimating share repurchases. The model must restrict buybacks if the CET1 ratio falls below the management target of 10.0% to 10.5%.
• Treating Trust and Investment Management fees as a flat growth rate rather than linking them to underlying equity and fixed income market performance.
• Failing to adjust historical data for the MUFG Union Bank acquisition, making pre-2023 and post-2023 loan and deposit balances look like organic growth rather than a step-function increase.

• "Balance sheet must balance: Total Assets = Total Liabilities + Total Equity in every period."
• "Efficiency ratio should remain in the 55% to 60% range; flag if it drops below 50% or exceeds 65%."
• "CET1 ratio must remain above the regulatory minimum and management target (flag if < 10.0%)."
• "Net Interest Margin should be between 2.60% and 3.10% based on historical performance."
• "Net Charge-Off ratio should be between 0.25% and 0.75%; flag if credit quality deteriorates beyond this band without a corresponding spike in Provision."
• "Loan-to-Deposit ratio should remain between 65% and 85% to ensure adequate liquidity."
• "Dividend payout ratio should remain between 35% and 45% of Net Income Available to Common."

• Filings: U.S. Bancorp Investor Relations page, SEC EDGAR (10-K, 10-Q, 8-K, and Call Reports).
• Key Peers: PNC Financial Services (PNC), Truist Financial (TFC), Fifth Third Bancorp (FITB), Bank of America (BAC).
• Industry Data: Federal Reserve H.8 (Assets and Liabilities of Commercial Banks), FDIC Quarterly Banking Profile.
• Consensus Estimates: FactSet or Bloomberg for EPS, NIM, and Efficiency Ratio consensus.

• U.S. Bancorp Q4 2025 Earnings Release and Supplement (January 20, 2026).
• U.S. Bancorp 2025 Annual Report on Form 10-K (February 2026).
• SEC EDGAR Database for historical filings.
• Analyst reports and financial news summaries regarding U.S. Bancorp's Q4 2025 performance and 2026 outlook.