# U.S. Bancorp (USB) Financial Model Free Excel 3-statement financial model and company analysis for U.S. Bancorp. - Canonical: https://finamodel.com/companies/u-s-bancorp - Industry: Banking - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/USB.xlsx ## Model Purpose This model provides a comprehensive equity valuation and capital adequacy forecast for U.S. Bancorp, enabling an equity research analyst to project net interest margin expansion, fee income growth, and regulatory capital returns under various macroeconomic interest rate scenarios. ## Company Overview U.S. Bancorp is a diversified financial services holding company and the parent company of U.S. Bank National Association, serving millions of retail, business, and institutional customers. The bank provides traditional lending and depository services alongside a highly profitable payments and wealth management franchise. Business segments include: * Consumer and Business Banking (approx. 35-40% of revenue) * Payment Services (approx. 25-30% of revenue) * Wealth, Corporate, Commercial and Institutional Banking (approx. 25-30% of revenue) * Treasury and Corporate Support (remainder) The company operates primarily in the United States, with a strong presence in the Midwest and West Coast following recent acquisitions. Its business model is a traditional commercial banking structure enhanced by a capital-light, fee-generating payments network (Elavon). U.S. Bancorp is one of the largest regional banks in the United States, competing directly with PNC Financial, Truist, and large money-centre banks. A major recent event was the acquisition of MUFG Union Bank, which closed in late 2022 and completed integration in 2023, significantly expanding its California deposit base. In early 2026, the company also announced the pending acquisition of BTIG to bolster its institutional trading and investment banking capabilities. ## Revenue Deep Dive ### Net Interest Income (NII) * **Segment name:** Net Interest Income (Consolidated) * **Revenue driver formula:** Average Earning Assets x Net Interest Margin (NIM) * **Historical growth rate:** Highly variable based on the Federal Reserve rate cycle; recently growing at 2-4% year-over-year. * **Key growth levers and headwinds:** Loan growth, deposit betas, and fixed-asset repricing. A headwind is the shift from noninterest-bearing to interest-bearing deposits. * **Pricing dynamics:** Driven by the yield curve, competitive deposit pricing, and loan spread over SOFR/Prime. * **Revenue recognition notes:** Recognised over the life of the loans using the effective interest method. * **Seasonality:** Day count in the quarter slightly impacts NII (Q1 has fewer days). ### Payment Services * **Segment name:** Payment Services * **Revenue driver formula:** Payment Volume x Merchant Acquiring / Interchange Take Rate * **Historical growth rate:** 5-8% CAGR. * **Key growth levers and headwinds:** Consumer spending resilience, corporate travel and entertainment recovery, and competition from fintechs. * **Pricing dynamics:** Transaction-based fees and volume-based pricing tiers. * **Revenue recognition notes:** Recognised as transactions are processed, net of certain network fees. * **Seasonality:** Q4 is typically the strongest due to holiday retail spending. ### Wealth, Corporate, Commercial and Institutional Banking * **Segment name:** Trust and Investment Management Fees / Commercial Products Revenue * **Revenue driver formula:** Assets Under Management (AUM) x Average Fee Rate + Syndication/Capital Markets Fees * **Historical growth rate:** 4-7% CAGR. * **Key growth levers and headwinds:** Equity and fixed income market performance, corporate debt issuance volumes. * **Pricing dynamics:** Basis points on AUM for wealth; negotiated flat fees for capital markets. * **Revenue recognition notes:** Accrued monthly based on daily or month-end AUM balances. * **Seasonality:** Capital markets revenue can be lumpy; wealth fees are relatively stable. ## Cost Structure ### Interest Expense (Cost of Funds) * **Line-by-line breakdown:** Interest on Deposits, Interest on Short-term Borrowings, Interest on Long-term Debt. * **Gross margin range:** For banks, this is viewed via Net Interest Margin (NIM), which has ranged from 2.60% to 3.15% over the last 5 years (2.77% in Q4 2025). * **Key input costs:** Federal funds rate and competitive deposit pricing. * **How COGS scales with revenue:** Interest expense scales directly with the rate environment and deposit volume. ### Provision for Credit Losses * **Line-by-line breakdown:** Provision for Credit Losses (driven by Net Charge-Offs plus changes in the Allowance for Credit Losses). * **Typical magnitude:** Net charge-off ratio typically runs between 0.25% and 0.60% of average loans (0.54% in Q4 2025). ### Noninterest Expense (Operating Expenses) * **Compensation and Employee Benefits:** The largest expense, driven by headcount and performance-based incentives. * **Technology and Communications:** Significant ongoing investment to digitise the bank and integrate acquisitions. * **Net Occupancy and Equipment:** Branch network costs, which are slowly shrinking as the bank consolidates physical locations. * **Amortisation of Intangibles:** Elevated recently due to the Union Bank acquisition. * **Restructuring / one-time charges:** FDIC special assessments and merger integration costs impacted 2023 and 2024 heavily. ### Margin Profile * **Efficiency Ratio:** Noninterest Expense / (Net Interest Income + Noninterest Income). The 5-year range is 55% to 62%. The Q4 2025 efficiency ratio was 57.4%. * **Margin trend:** Improving (expanding operating leverage) as the bank realises cost synergies from Union Bank and benefits from fixed-asset repricing. * **Return on Tangible Common Equity (ROTCE):** 17% to 22% range (18.4% in Q4 2025). ## Balance Sheet Structure * **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. ## Capital Expenditure & Investment * **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. ## Debt & Capital Structure * **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. ## Cash Flow Characteristics * **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). ## Sheet Structure 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. ## Key Financial Relationships 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" ## Cross-Sheet Dependencies 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). ## Sign Convention * 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. ## Things Most Likely to Go Wrong * 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. ## Validation Checks * "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." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Average Earning Assets Growth | 2.5 | % | Modest organic loan growth following balance sheet optimisation. | | Net Interest Margin (NIM) | 2.77 | % | Based on Q4 2025 actual reported NIM. | | Payment Services Revenue Growth | 6.0 | % | Mid-single-digit target for fee income growth. | | Trust & Investment Mgt Growth | 5.0 | % | Assumes stable equity markets and steady AUM inflows. | | Efficiency Ratio Target | 57.4 | % | Aligns with Q4 2025 actuals and management's mid-to-high 50s target. | | Net Charge-Off Ratio | 0.54 | % | Based on Q4 2025 actual credit performance. | | Effective Tax Rate | 22.0 | % | Standard corporate rate adjusted for tax-advantaged investments like LIHTC. | | Target CET1 Ratio | 10.5 | % | Management target to maintain a buffer above regulatory minimums. | | Dividend Payout Ratio | 40.0 | % | Historical average payout policy for the bank. | | Cost of Equity (Ke) | 9.5 | % | Standard assumption for a large, diversified regional bank. | | Terminal Growth Rate | 2.0 | % | Long-term GDP growth proxy for the terminal value calculation. | ## Data Sources & Benchmarks * **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. ## Sources * 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. --- ## Frequently asked questions ### What is U.S. Bancorp's primary business model? U.S. Bancorp is a diversified financial services holding company and the parent company of U.S. Bank National Association. It provides traditional lending and depository services alongside a highly profitable payments and wealth management franchise. ### How does U.S. Bancorp generate its revenue? U.S. Bancorp generates revenue through its Consumer and Business Banking, Payment Services, and Wealth, Corporate, Commercial and Institutional Banking segments. Its business model combines traditional commercial banking with a capital-light, fee-generating payments network like Elavon. ### What is U.S. Bancorp's capital expenditure strategy? U.S. Bancorp's traditional capital expenditure is minimal, with a focus on technology investments and capitalized software. Its capex is primarily growth-oriented, aimed at improving digital banking and payment processing platforms, including cloud migration and digital sales platform enhancements. ### What is a key revenue growth assumption in the U.S. Bancorp financial model? A key revenue growth assumption in the U.S. Bancorp financial model is 12.62%. This projection helps equity research analysts forecast net interest margin expansion and fee income growth for the company. ### What is the purpose of the U.S. Bancorp financial model? The U.S. Bancorp financial model provides a comprehensive equity valuation and capital adequacy forecast for the company. It enables an equity research analyst to project net interest margin expansion, fee income growth, and regulatory capital returns under various macroeconomic interest rate scenarios. ### Can I download an Excel financial model for U.S. Bancorp? Yes, an Excel financial model for U.S. Bancorp is available for download. This model provides a forecast horizon from FY2026 to FY2030, assisting in detailed financial analysis. [Interactive forecast calculator](https://finamodel.com/companies/u-s-bancorp/forecast)