Here below down you can download the EMI calculator in Excel format, which will help you to calculate the EMI of Any Loan Like-Home, Car Loan, Personal Loan, etc. So below is the screenshot for the EMI Calculator in Excel Sheet.

Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment .Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest

If we can add a column for EMI paid and then based on that if sheet shows the values like how it changes when we pay extra amount or less amount.
ex – if our emi is 10000 and we paid 12000 this month then what is outstanding amount…

Thanks for the calculation, but it does not have any prepayment option to check. Also, it does not tally with the SBI way of calculating the interest (as per SBI – ‘SBI charges interest on daily reducing balance’). I do not find any excel to match the interest calculated by SBI. Please make it available if you are aware of it. Thank you

it would be good if you could include a new column to enter the pre-payment amount so we can see what difference it makes to the emi going forward once the pre-payment amount is intered

12 written as 12 month and 100 given for percentage calculation, so 12×100 = 1200

Hi,
Canu add the option of repayment, let us say if we pay more than EMI amount and close the loan in 24 months instead of 48 months tenure. so that I can see how much of Interest I have paid in 24 months .

Excellent Guru…..

Please add EMI Payment date also

addition of prepayment colum total intreswt paid coloum req

How we calculate flat interes rate ?

need excel file

Pls tell how to calculate flat emi with separate interst and penal.

good

nice

I WANT TO CALCULATE LOAN SCHEME IN BULK CASES TO DEFINE EMI AMOUNT AND TENURE.

i want month wise principal amount and interest amount for all months

nothing

GOOD

NA

good job

BEST.

I WANT TO DOWNLOAD EXCEL SHEET FOR EMI CALCULATOR

Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment .Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest

do you have flat interest rate calculator excel file

SIR ALSO INSERT THE START DATE END DATE & F.Y TO GENERATE REPORT

Sure Abhishek Ji, i will insert

This is good sheet , I appreciate it . If you can add bulk payment somewhere , that will be excellent

Sandeep Ji, i will try to Add.

Thanks

add one column to show month

ok i will try to add.

superb guru! Thanks 👍👍

Welcome Alok Ji

If we can add a column for EMI paid and then based on that if sheet shows the values like how it changes when we pay extra amount or less amount.

ex – if our emi is 10000 and we paid 12000 this month then what is outstanding amount…

Ok Abhishek ji, i will try to add

Hi buddy,

It should be repayment option for year

Emi calculator is good but I want to advance payment with loan calculation.

i need EHI calculator which will be repaid Hal ferly in a year

Thanks for the calculation, but it does not have any prepayment option to check. Also, it does not tally with the SBI way of calculating the interest (as per SBI – ‘SBI charges interest on daily reducing balance’). I do not find any excel to match the interest calculated by SBI. Please make it available if you are aware of it. Thank you

If we are taking loan disbursement in installments, needs input mechanism for the same

monthly emi jaldi chahiye

it would be good if you could include a new column to enter the pre-payment amount so we can see what difference it makes to the emi going forward once the pre-payment amount is intered

If miss the instalment then add it as a penalty charge

add an option of repayment as well.

User friendly .. well

why have we divided interest rate by 1200?

12 written as 12 month and 100 given for percentage calculation, so 12×100 = 1200

Hi,

Canu add the option of repayment, let us say if we pay more than EMI amount and close the loan in 24 months instead of 48 months tenure. so that I can see how much of Interest I have paid in 24 months .

simple to use . great job.