EXCEL BASED CALCULATOR FOR LOAN EMI

If someone has taken the loan (home, auto or any type of). He/she needs to pay the E.M.I. (equal monthly installments) which is consisting of principal as well as the interest. But it is quite difficult to calculate the E.M.I as well as differentiate thee principal amount and the interest amount out of E.M.I. The nature of loan is that as you pay along the E.M.I’s the principal amount increases out of emi and interest reduces.


So I am presenting a loan emi calculator which calculates the E.M.I for your loan amount as well as part it to principal and interest. The features of this calculator are as follows:-
1- It is an excel based calculator.
2- One needs to submit only Loan amount, interest rate & tenor of loan.
3- The remaining calculation will be automatic.
4- It will calculate the equal monthly installment amount with both diminishing interest rate as well as fixed interest rate.
5- Tell outstanding amount after each emi.
6- It is all to all solution for loan amortization schedule.
7- The graph of loan as well interest will also show in this calculator.
8- You can also make some extra payment each month in this calculator.
9- Applies for all type of loan like home loan, auto loan etc.

EXCEL BASED CALCULATOR FOR LOAN EMI