Net Interest Margin Tracker Excel: Q2 2026 Bank Earnings Dashboard (2026)

Net interest margin is the number every bank analyst reaches for first when the Q2 2026 earnings reports start landing, and this guide gives you an Excel tracker to follow it across the whole group in one place. Bank earnings season kicks off on July 14, 2026, when JPMorgan Chase, Bank of America, Citigroup and Wells Fargo all report before the open, with Goldman Sachs, Morgan Stanley, PNC, U.S. Bancorp, Truist and Capital One following through the rest of the month. Net interest margin, or NIM, measures the spread a bank captures between what it earns on loans and securities and what it pays out on deposits and borrowings. It is the core profit engine of a lending business, and small moves in it swing billions of dollars in net interest income. This post walks through how to build a net interest margin tracker in Excel, which metrics sit next to NIM in a real bank screen, and how to model what a Federal Reserve rate move does to the spread. It comes with a free template built on live MarketXLS formulas.

This is educational analysis, not investment advice. The bank tickers below are used to show how the formulas and the tracker work, not as recommendations to buy or sell anything.

Net Interest Margin Tracker Excel: The Banks at a Glance

Net interest margin is not one story across the sector, it is several. Traditional deposit-funded lenders such as Wells Fargo, U.S. Bancorp and PNC live and die on NIM because spread income is the bulk of their revenue. The trading and advisory houses, Goldman Sachs and Morgan Stanley, run much thinner margins because fee income dominates their model. Money-center giants such as JPMorgan and Bank of America sit in the middle, blending huge loan books with markets and card businesses. A card-heavy lender like Capital One shows a very high NIM because credit-card yields dwarf deposit costs. A good tracker has to put all of these side by side so you can compare a spread-driven regional against a fee-driven investment bank honestly.

Here is the quick-reference table the template is built around.

The template ranks all ten on NIM, net interest income, valuation and returns, and gives each a simple score so you can sort the group the way a bank analyst would.

What Net Interest Margin Actually Measures

Net interest margin is defined as net interest income divided by average earning assets:

NIM = (Interest Income - Interest Expense) / Average Earning Assets

Interest income is what the bank earns on loans, mortgages, credit cards and its securities portfolio. Interest expense is what it pays depositors and bondholders. The difference is net interest income, the raw dollar profit from lending. Dividing by average earning assets turns that dollar figure into a percentage margin, which lets you compare a small regional against a trillion-dollar giant on a level footing.

A rising NIM means the bank is earning a wider spread, usually because loan yields are climbing faster than deposit costs. A falling NIM signals the opposite: deposit costs are catching up, a dynamic analysts call a rising deposit beta. Deposit beta is the share of a rate move that a bank has to pass through to depositors. A low deposit beta is good for the bank because it keeps funding cheap while asset yields rise. A high deposit beta squeezes the margin.

Because NIM depends on average earning assets, a figure that only appears inside each bank's earnings release and filings, it is the one input in the tracker you type in by hand from the report. Everything around it, from price to net interest income to return on equity, is pulled live by MarketXLS. That split is deliberate: the tracker automates everything that can be automated and leaves the single reported metric as a clean yellow input.

The Q2 2026 Setup for Bank Margins

Heading into the July reports, the debate over bank margins comes down to three moving parts, and the tracker is built to help you watch each one.

The first is the path of the Fed. When the policy rate is high and stable, asset-sensitive banks earn a wider spread because their floating-rate loans reprice up while a chunk of their deposits stay cheap. When the Fed cuts, that tailwind can reverse, though a lower rate can also slow deposit repricing. The Rate Scenario sheet in the template lets you flex a rate move and watch the estimated effect on net interest income.

The second is loan growth. Net interest income is margin times the size of the earning-asset base, so even a flat NIM produces more dollars of income if the loan book is growing. Analysts will be listening for management commentary on whether loan demand is accelerating.

The third is deposit competition. If customers keep shifting cash from checking accounts into higher-yield money-market and savings products, deposit costs rise and the margin compresses. The blended deposit beta is one of the most important sentences in any bank earnings call.

None of this is a forecast. The point of the tracker is to give you a structured place to record what actually gets reported, compare it across the group, and see how the market reacts.

Building the Net Interest Margin Tracker in Excel

The heart of the workbook is the NIM Dashboard sheet. Each bank sits on its own row, and every data point is a live MarketXLS formula except the NIM input. Here is how the key columns are built.

Company name and price come straight from the ticker:

=NAME("JPM")            → JPMorgan Chase & Co.
=QM_Last("JPM")         → Live last price

Market capitalization is pulled and scaled to billions for readability:

=MarketCapitalization("JPM")/1000000000

Net interest income is computed directly from the two interest line items, using the trailing-twelve-month figures so you always have a rolling annual number:

=(HF_Interest_Income("JPM",2026,,"TTM") - HF_Interest_Expense("JPM",2026,,"TTM"))/1000000000

The valuation and quality columns each map to a single MarketXLS function:

=PERatio("JPM")          → Price to earnings (TTM)
=PriceToBook("JPM")      → Price to book, the key bank valuation gauge
=ReturnOnEquity("JPM")   → Return on equity (TTM)
=ReturnOnAssets("JPM")   → Return on assets (TTM)
=DividendYield("JPM")    → Dividend yield (TTM)
=EarningsPerShare("JPM") → Trailing EPS
=Beta("JPM")             → Beta versus the market

Price to book deserves special mention. For most companies analysts lean on the price to earnings ratio, but banks are valued heavily on price to book because their balance sheet is the business. A bank trading below one times book is priced as if it will destroy value; one trading well above book is being credited with durable, high-return franchises. Putting P/B, ROE and NIM in the same row lets you see whether a premium multiple is actually earned by superior returns.

The last column is a score. It counts how many of three tests each bank passes: NIM above your minimum, ROE above your minimum, and P/B below your maximum. Those three thresholds are yellow input cells at the top of the sheet, so you can tighten or loosen the screen without touching a formula:

=IF(F7>=$C$4,1,0)+IF(I7>=$E$4,1,0)+IF(H7<=$G$4,1,0)

A bank scoring 3 clears all three of your hurdles; a bank scoring 0 clears none. It is a starting point for research, not a verdict.

Modeling a Rate Move: The Scenario Sheet

The Rate Scenario sheet answers the question every bank investor asks before an earnings call: what happens to net interest income if the Fed moves? You enter three assumptions in the yellow cells. The base net interest income is the starting dollar figure, which you can seed from the dashboard. Asset sensitivity captures how many basis points of net interest income the bank gains for every 100 basis points of rate increase. Deposit beta captures how quickly deposit costs follow.

The sheet then walks through five scenarios, from a 100 basis point cut to a 100 basis point hike, and estimates the change in net interest income for each:

NII change % = (Fed move in bps / 100) x asset sensitivity x (1 - deposit beta adjustment)
New NII      = Base NII x (1 + NII change %)

Rate hikes light up green as a tailwind for the margin, cuts light up red as a headwind, and the no-change row stays neutral. It is a simplified educational model, not a precise forecast, but it makes the core intuition concrete: an asset-sensitive bank with a low deposit beta is the biggest beneficiary of higher-for-longer rates, while a high deposit beta erodes that advantage quickly.

Inside the Template

The workbook has six sheets, each doing one job.

The How To Use sheet is a short tutorial that explains NIM, walks through the layout, and lists every MarketXLS function used so you can rebuild any part yourself.

The NIM Dashboard is the main screener, with the ten banks, their live metrics, the NIM input column, and the three-part score driven by your yellow threshold cells.

The Rate Scenario sheet is the net-interest-income sensitivity model described above, letting you flex a Fed move and a deposit beta.

The Earnings Playbook lists the expected Q2 2026 report date for each bank and the specific line items worth watching in each print, from JPMorgan's investment banking rebound to Capital One's card losses and Discover integration. A live EPS column lets you cross-check the trailing figure.

The Allocation sheet turns a portfolio value you type in into a dollar allocation, share count and estimated annual dividend for each bank, and rolls up a blended portfolio yield. Weights are yellow inputs so you can build equal-weight or custom baskets.

The Comparison Matrix ranks the group across NIM, ROE, ROA, P/E, P/B, dividend yield and beta, with color scales that shade the strongest values green and the weakest red, plus a composite overall rank. In the live version these cells link straight back to the dashboard, so the matrix updates the moment you recalculate.

Download the templates:

• - Pre-filled with illustrative data so you can see the layout, with the MarketXLS formula shown for each value
• - Live-updating formulas that refresh every metric on open

To use the live version, install the MarketXLS Excel add-in, open the workbook, and recalculate. The prices, market caps, interest income, returns and yields all pull in automatically. Type each bank's reported NIM into the yellow column as the earnings releases come out, and the score and matrix update instantly.

How Analysts Read NIM Alongside the Other Numbers

Net interest margin never travels alone. A useful bank read stacks it against a handful of companions, all of which sit in the tracker.

Return on equity tells you whether the bank turns that margin into shareholder returns efficiently. Two banks can post the same NIM, but the one with tighter cost control and lower loan losses drops more of it to the bottom line. Return on assets strips out leverage and shows how productive the balance sheet is on its own terms.

Price to book anchors the valuation. A bank with a high, stable NIM and a mid-teens ROE can justify trading at a premium to book; a bank with a thin margin and single-digit ROE usually trades at a discount, and the tracker's comparison matrix makes that relationship visible at a glance.

Dividend yield rounds out the picture for income-focused investors, and the allocation sheet lets you estimate the blended yield of a bank basket sized to your own portfolio. None of these figures is a signal on its own. Read together, they tell you whether a bank is cheap for a reason or cheap by mistake, which is exactly the judgment earnings season is meant to inform.

Frequently Asked Questions

What is a good net interest margin for a bank? There is no single universal figure because it depends on the business model. Large deposit-funded commercial banks often run a NIM somewhere in the range of two to three percent, super-regionals can sit a touch higher, and card-heavy lenders run far higher because credit-card yields are much larger than deposit costs. Investment banks run very low NIM because fees, not spread, drive their revenue. The more useful exercise is to compare a bank against its own history and its direct peers, which is exactly what the tracker is built for.

How do I calculate net interest margin in Excel? Net interest margin is net interest income divided by average earning assets. In the template, net interest income is computed live with =(HF_Interest_Income(ticker,2026,,"TTM") - HF_Interest_Expense(ticker,2026,,"TTM")). Average earning assets is reported in each bank's filing, so the NIM percentage itself is entered in a yellow input cell from the earnings release. That keeps the automated figures fully live while giving you one clean field for the reported margin.

When do the big banks report Q2 2026 earnings? The major US banks kick off Q2 2026 earnings season on July 14, 2026, with JPMorgan Chase, Bank of America, Citigroup and Wells Fargo all reporting before the market open. Goldman Sachs, Morgan Stanley, PNC, U.S. Bancorp, Truist and Capital One follow across the rest of July. The Earnings Playbook sheet lists the expected date for each name, though dates can shift, so confirm on each bank's investor relations page.

Why is price to book more important than P/E for banks? A bank's balance sheet is its business, so its equity base is the clearest measure of its intrinsic scale. Price to book compares the market value to that equity base, which is why analysts lean on it more heavily than the price to earnings ratio for financials. Reading P/B next to return on equity shows whether a premium valuation is earned by high returns or simply hoped for, and the tracker places both in the same row.

What is deposit beta and why does it matter for NIM? Deposit beta is the share of a change in market interest rates that a bank passes through to its depositors. A low deposit beta means the bank keeps funding cheap even as rates rise, which widens the margin. A high deposit beta means deposit costs climb quickly and compress the spread. The Rate Scenario sheet lets you flex the deposit beta assumption and see its estimated effect on net interest income.

Does this template give buy or sell recommendations? No. The tracker is an educational tool for organizing and comparing bank fundamentals. The score and ranking are simple, transparent filters based on thresholds you set yourself. They are a starting point for your own research, not a recommendation to buy or sell any security.

The Bottom Line

Net interest margin is the pulse of a bank, and Q2 2026 earnings season is when the whole sector takes its reading at once. A well-built tracker lets you follow NIM, net interest income, returns and valuation for the ten largest US banks in a single Excel view, record each reported margin as it lands, and see instantly how the group stacks up. Pairing NIM with price to book, ROE and a rate-sensitivity model turns a wall of headlines into a structured comparison you can actually reason about.

The free template does the heavy lifting with live MarketXLS formulas, so the only thing you type is the reported margin from each release. Download both versions above, and if you want to see how MarketXLS pulls thousands of live data points straight into Excel, explore MarketXLS or book a demo to see it built around your own workflow.