Financial Statement Analysis
- Profitability Ratios
- Profitability Ratios Formula
- Common Size Income Statement
- Vertical Analysis of Income Statement
- Profit Margin
- Profit Margin Formula
- Profit Percentage Formula
- Profit Formula
- Gross Profit Margin Formula
- Gross Profit Percentage
- Operating Profit Margin Formula
- EBIT Margin Formula
- Operating Income Formula
- Net Profit Margin Formula
- EBITDA Margin
- Degree of Operating Leverage Formula (DOL)
- NOPAT Formula
- Earnings Per Share
- Basic EPS
- Diluted EPS
- Basic EPS vs Diluted EPS
- Return on Equity (ROE)
- Return on Equity Ratio
- Return on Capital Employed (ROCE)
- ROCE Formula (Return on Capital Employed)
- Return on Invested Capital (ROIC)
- Return On Investment (ROI)
- Rate of Return on Investment
- Return on Sales
- ROIC Formula (Return on Invested Capital)
- Return on Investment Formula (ROI)
- ROIC vs ROCE
- ROE vs ROA
- Cash on Cash Return
- Return on Total Assets (ROA)
- Return on Total Assets Formula
- Return on Average Capital Employed
- Capital employed Employed
- Return on Average Assets (ROAA)
- Return on Average Equity (ROAE)
- Return on Assets Formula
- Return on Equity Formula
- DuPont Formula
- Net Interest Margin Formula
- Earnings Per Share Formula
- Diluted EPS Formula
- Contribution Margin Formula
- Unit Contribution Margin
- Revenue Per Employee Ratio
- Operating Leverage
- EBIT vs EBITDA
- Capital Gains Yield
- Tax Equivalent Yield
- LTM Revenue
- Operating Expense Ratio Formula
- Overhead Ratio Formula
- Variable Costing Formula
- Capitalization Rate
- Cap Rate Formula
- Comparative Income Statement
- Capacity Utilization Rate Formula
- Total Expense Ratio Formula
- Markup Percentage Formula
- Ratio Analysis (17+)
- Liquidity Ratios (29+)
- Turnover Ratios (17+)
- Efficiency Ratios (7+)
- Dividend Ratios (9+)
- Debt Ratios (26+)
Net Interest Margin (NIM) Formula
NIM is the ratio every investor should use. Net Interest Margin Ratio talks about the NIM, meaning how much interest an investor receives over how much she pays out.
Here’s the net interest margin formula.
Example of Net Interest Margin Formula
Let’s take a simple example to illustrate net interest margin formula.
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 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.
4.9 (1,067 ratings)
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 NIM 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%.
Explanation of 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.
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.
Use of Net Interest Margin Formula
- 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 formula would be also useful as she would be able to see how much she earns and how much she pays proportionately.
- Actually, net interest margin formula is a measure of how well investment strategy is executed. If the NIM is less, there is a 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 Net Interest Margin Calculator.
|Net Interest Margin Formula =||
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 Formula
Recommended Articles –
This has been a guide to Net Interest Margin formula, its uses along with practical examples. Here we also provide you with Net Interest Margin Calculator with downloadable excel template.