Mifos

How to calculate the EMI

EMI (Equated Monthly Installment) is the amount payable to the lending institution every month, till the loan is paid back in full. It consists of a portion of the interest as well as the principal.  This is what is due at each installment of a loan.


Declining Balance Interest (EMI of Principal and Interest)

Declining Balance Interest with equal principal installment

Flat Interest Rate

Definition

Interest is computed at periodic intervals on the amount of the original principal that has not yet been repaid. Since the borrower only pays interest on that amount of original principal that has not yet been repaid, interest paid will be smaller every period.

The exception from the EMI computed in the first column is that interest is calculated using equal principal installments. The client pays equal installments of principal for the duration of the loan, and the interest is calculated on principal that has not been paid for the loan period.

Flat interest refers to charging interest on the full original loan amount, rather than on the declining balance.

This is the most common calculation used in Grameen Style MFIs (most MFIs).

Formula

EMI = i*P / [1- (1+i)^-n]

Where,

P = Loan amount

r = Rate of interest per year

n = Term of the loan in periods

l = Length of a period (fraction of a year, i.e., 1/12 = 1 month, 14/360 = bi-weekly.)

i = Interest rate per period (r*l)

Formula Interest = (P-Pp) * r * n

Where,

P = loan amount

Pp= Principal paid

r = rate of interest

n = term of loan

Interest = P*r*n

Where

P = loan amount- Initial amount

r = rate of interest

n = term of the loan

Examples

P=1000, r = 5/100, l = 6/12 n = 2, i = 0.025

EMI = 0.025 * 1000 / [1-(1+0.025)^-2]

EMI = 8.83

The way to apply payments is as follows:

Calculate interest in the principal due: If balance = 00, and i = 0.025, interest is

Calculate the amount to principal which is the monthly payment minus the interest due: 8.83 - = 3.83

Calculate the principal remaining, which is the previous principal remaining minus the amount applied to principal: 00 - 3.83 = 6.17 (remaining balance)

Once next payment is received, repeat steps 1 to 3.

Note: Due to rounding of computed values, it could potentially be off by a maximum of N number of pennies after the full term of the loan. It will never be short if we round up, rather, principal could end up with a few more pennies.

Principal = 15,000

Int. Rate = 25 %

No of payments = 25

Payment schedule (Every 2 weeks) = 14 days

Principal = 15,000/25 = 600

For Installment 1:

Total due = Principal + Interest = 600 + 143.83 = 743.83

For Installment 2:

Interest = (15000-600)*.25*14/365 = 140

Total due = 600 + 140 = 740

 

Continue calculating for remaining installments

P=100, r = 3/100 per month, n = 4

Interest = 100 *(3/100) * 4 = 12

Monthly payments of 112 / 4 = 84