WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Investment Banking Tutorials » Financial Statement Analysis » Net Interest Margin

Net Interest Margin

What is Net Interest Margin?

Net Interest Margin is a popular profitability ratio used by banks, which helps them determine the success of firms in investing in comparison to the expenses on the same investments and is calculated as Investment income minus interest expenses (this step is referred to as netting) divided by the average earning assets.

Net Interest Margin (NIM) Formula

This ratio talks about the NIM, meaning how much interest an investor receives over how much she pays out.

Here’s the formula.

Net Interest Margin = (Interest Received – Interest Paid) / Average Invested Assets

Net-Interest-Margin-Formula

When an investor invests money in bonds or other investment instruments, she gets a percentage of interest on her investments.

At the same time, if we assume that the money that is being invested is actually borrowed, then the investor (and the borrower) also need to pay interest to the lender of the money.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

In this formula, we are trying to find out the difference between the interest that is received and the interest that is paid. And then, we would compare the difference between the average invested assets to find out the proportion.

Average invested assets are the average of all the investments. We take average invested assets to find out the median of all invested assets so that we can ease out the differences among the invested assets.

Examples

Let’s take a simple example to illustrate this concept

You can download this Net Interest Margin Ratio Excel Template here – Net Interest Margin Ratio Excel Template

Xavier has been experimenting with different investment instruments. Recently he has tried a bunch of investments, and he wants to see how he is doing. He has borrowed $100,000 from the bank and invested the entire amount in an investment instrument. The bank is charging him a 10% simple interest on the loan. And he has been getting 9% quarterly compounded from the investment. Find out the NIM (if any).

In this scenario, we need to find out the interest rate for each side.

First, we will find out how much Xavier has to pay to the bank. And then, we will calculate the interest that Xavier will receive.

  • Xavier will pay = ($100,000 * 10%) = $10,000 to the bank.
  • And Xavier will receive at the end of the year = [$100,000 * (1 + 0.9/4)4 – 1)] = [$100,000 * (2.252 – 1)] = [$100,000 * 1.252] = $125,200 from the investment.
  • The interest received from the investment would be = ($125,200 – $100,000) = $25,200.

Using the Net Interest Margin formula, we get –

  • NIM = (Interest Received – Interest Paid) / Average Invested Assets
  • Or, NIM = ($25,200 – $10,000) / $100,000 = $15,200 / $100,000 = 15.2%.

Use of Net Interest Margin

  • This is a ratio every bank uses. It’s because banks are in the business of taking deposits from investors and then using the same money to earn interests in other investments.
  • NIM is one of the most common ratios used to compare the performance of the banks.
  • For an individual investor, the net interest margin would also be useful as she would be able to see how much she earns and how much she pays proportionately.
  • Actually, NIM is a measure of how well an investment strategy is executed. If the NIM is less, there is room for improvement, and if the NIM is well on target, then maybe the investor may continue with the same sort of investments (the range and the instruments, both).

Net Interest Margin Calculator

You can use the following Calculator.

Interest Received
Interest Paid
Average Invested Assets
Net Interest Margin Formula =
 

Net Interest Margin Formula =
Interest Received − Interest Paid
=
Average Invested Assets
0-0
= 0
0

NIM in Excel (with excel template)

Let us now do the same example above in Excel. This is very simple. You need to provide the two inputs of Interest Received and Interest Paid.

You can easily calculate the Net Interest Margin ratio in the template provided.

Net Interest margin in excel

Net Interest Margin Formula

Recommended Articles –

This has been a guide to Net Interest Margin and its meaning. Here we discuss the formula to calculate NIM in banks along with practical examples, its uses, and interpretations. You can learn more about from the following articles –

  • Book to Bill Ratio
  • Net Worth Calculator
  • Margin Debt Example
  • Compare – Margin vs. Profit
  • Contribution Margin Formula
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Ratio Analysis Course

Step by Step Guide to Calculating Financial Ratios in excel

WallStreetMojo

Download Net Interest Margin Ratio Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More