Financial Statement Analysis
 Ratio Analysis of Financial Statements (Formula, Types, Excel)
 Ratio Analysis Advantages
 Ratio Analysis
 Liquidity Ratios
 Cash Ratio
 Cash Ratio Formula
 Quick Ratio
 Quick Ratio Formula
 Current Ratio
 Current Ratio Formula
 Acid Test Ratio Formula
 Defensive Interval Ratio
 Working Capital Ratio
 Working Capital Formula
 Net Working Capital Formula
 Changes in Net Working Capital
 Cash Flow from Operations Ratio
 Cash Reserve Ratio
 Operating Cycle Formula
 Current Ratio vs Quick Ratio
 Bid Ask Spread
 Liquidity vs Solvency
 Liquidity
 Solvency
 Solvency Ratios
 Equity Ratio
 Capital Adequacy Ratio
 Liquidity Risk
 Altman Z Score
 Turnover Ratios
 Inventory Turnover Ratio
 Accounts Receivable Turnover
 Accounts Receivables Turnover Ratio
 Accounts Payable Turnover Ratio
 Days Inventory Outstanding
 Days in Inventory
 Days Sales Outstanding
 Average Collection Period
 Days Payable Outstanding
 Cash Conversion Cycle
 Cash Conversion Cycle (CCC) Formula
 Fixed Asset Turnover Ratio Formula
 Debtor Days Formula
 Working Capital Turnover Ratio
 Profitability Ratios
 Profitability Ratios Formula
 Common Size Income Statement
 Vertical Analysis of Income Statement
 Profit Margin
 Gross Profit Margin Formula
 Gross Profit Percentage
 Operating Profit Margin Formula
 EBIT Margin Formula
 Operating Income Formula
 Net Profit Margin Formula
 EBIDTA Margin
 Degree of Operating Leverage Formula (DOL)
 NOPAT Formula
 OIBDA
 Earnings Per Share
 Basic EPS
 Diluted EPS
 Basic EPS vs Diluted EPS
 Return on Equity (ROE)
 Return on Capital Employed (ROCE)
 Return on Invested Capital (ROIC)
 Return on Sales
 ROIC Formula (Return on Invested Capital)
 Return on Investment Formula (ROI)
 ROIC vs ROCE
 ROE vs ROA
 CFROI
 Cash on Cash Return
 Return on Total Assets (ROA)
 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
 EBITDAR
 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
 Efficiency Ratios
 Dividend Ratios
 Debt Ratios
 Debt to Equity Ratio
 Debt Coverage Ratio
 Debt Ratio
 Debt to Asset Ratio Formula
 Coverage Ratio
 Coverage Ratio Formula
 Debt to Income Ratio Formula (DTI)
 Capital Gearing Ratio
 Capitalization Ratio
 Interest Coverage Ratio
 Times Interest Earned Ratio
 Debt Service Coverage Ratio (DSCR)
 DSCR Formula (Debt service coverage ratio)
 Financial Leverage Ratio
 Financial Leverage Formula
 Degree of Financial Leverage Formula
 Net Debt Formula
 Leverage Ratios
 Leverage Ratios Formula
 Operating Leverage vs Financial Leverage
 Current Yield
 Debt Yield Ratio
 Solvency Ratio Formula
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.
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.
4.8 (388 ratings)
 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%.
Recommended Courses
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.
Interest Received  
Interest Paid  
Average Invested Assets  
Net Interest Margin Formula =  
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.
Leave a Reply