Bank profitability analysis: income, costs and earnings

Bank profitability analysis traces interest income, funding costs, noninterest income, operating expense and provision through to earnings. Start with a dollar bridge that reconciles two periods, then examine the business lines responsible for the movement. A revenue increase is useful only in the context of the costs and credit expense that accompany it.

The method below uses an illustrative US bank's finance workbook. It focuses on earnings drivers; bank financial ratios owns the separate question of selecting and interpreting profitability, funding and capital ratios.

Agree the finance definitions first

Use one reporting entity, currency and period basis. Quarterly amounts must be discrete quarters, rather than a mixture of standalone and year-to-date figures. Preserve the source ledger categories so the bridge can be reconciled without reconstructing finance's accounting policy.

The FDIC's Quarterly Banking Profile discusses changes in bank earnings through net interest income, noninterest income and noninterest expense. Those categories provide a useful organizing structure, but the business-line allocation in your management workbook still needs its own definition.

For this example, all income and expense inputs are positive amounts. Funding cost is the allocated interest cost that reconciles to the bank's external interest expense. Operating expense excludes funding cost, provision and tax. Provision is the finance-supplied credit expense, not cash collections or the amount charged off during the quarter.

Net interest income = Interest income − Funding cost

Pretax income = Net interest income + Noninterest income − Operating expense − Provision

Net income = Pretax income − Income tax expense

Keep realized gains, unusual items and other income in explicit source categories if the bank reports them. A simplified management bridge must not silently omit a material reported line.

Start with one row per line and quarter

Export business line, quarter, interest income, funding cost, noninterest income, operating expense and provision. Include the allocation version and ledger reconciliation in the workbook's supporting notes.

Here, column A is business line and B is period. Columns C through G contain the five financial inputs in the order shown; H is calculated pretax income. The two quarters have the same line structure and allocation policy.

In H2, enter the following and fill through H7:

=C2-D2+E2-F2-G2

To summarize interest income for the quarter named in J2, use:

=SUMIFS($C$2:$C$7,$B$2:$B$7,J2)

Repeat for the other input columns and pretax income. Google Sheets documents SUMIFS as summing values that meet specified criteria; this formula also works in Excel. Covirage is not affiliated with Google or Microsoft.

Build the bank-wide dollar bridge

The following bank totals come directly from the six line-period rows. A higher income input contributes positively to earnings. A higher expense input contributes negatively.

The proof is 2,200,000 + 500,000 − 700,000 + 120,000 − 170,000 − 250,000 = $1,700,000. Every effect appears once, with an expense increase carrying a negative sign.

Net interest income falls from 7,000,000 − 2,400,000 = $4,600,000 to 7,500,000 − 3,100,000 = $4,400,000. The $500,000 interest-income gain is more than offset by $700,000 of additional funding cost. Do not label the interest-income increase an improvement in net interest earnings.

For the next level of explanation, the rate volume mix analysis article separates bank interest movements into balance, mix and rate effects. Keep that detailed interest bridge outside this bank-wide earnings reconciliation.

Identify which business lines explain the change

Calculate each line's Q2 pretax income less its Q1 pretax income. The signed driver changes below use the same inputs as the bank bridge.

Commercial and Consumer explain the decline, while Treasury partly offsets it. Treasury should review funding allocation and external funding repricing; line finance should explain expense movement; credit finance should reconcile provision. Those are review questions, not conclusions about the underlying causes.

For relationship-level allocation, link through to bank customer profitability. A business-line result does not establish which customer relationships earned an acceptable return.

Reconcile tax and preserve the capital context

Finance supplies tax expense separately for the same reporting entity. These are supplied tax amounts, not a tax forecast or an assumption about the bank's legal tax rate.

Net income changes by −500,000 − (−125,000) = −$375,000. All dollar calculations here are exact; no annualization or rounding is used.

The controller should tie both endpoints to the approved management P&L and maintain a crosswalk to the applicable regulatory reporting basis. The FDIC's current Call Report materials provide the forms and instructions for that reporting context; a management-line allocation still requires an explicit reconciliation.

If the workbook supplies capital, assets or return measures, retain their approved denominator and period basis alongside this bridge. Do not substitute closing capital for average capital or compare annualized and unannualized returns. Use the linked ratio guide for those calculations.

Where it goes wrong

• Internal funding counted twice. Internal charges and credits must eliminate before comparing the bank total with external interest expense.
• Mixed period bases. A cumulative second-quarter export cannot be compared directly with a standalone first quarter.
• Provision confused with charge-offs. Use the supplied income-statement expense; do not subtract another credit-loss measure as well.
• Allocation changes read as performance. Show restated comparatives or a separate policy effect when overhead or funding allocations change.
• Tax or unusual items omitted. A bridge stopping at pretax income must be labeled as such and reconciled separately to net income.

Reconcile your finance workbook in Covirage

Bring the business-line P&L export, allocation notes and supplied tax and capital summaries; Covirage maps the columns, and its tools compute and check the period and line comparisons. The external AI model explains the earnings movement with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See financial planning and analysis reporting for the supporting finance workflow.