Loan EMI Calculator in Excel (.xls file Download Here)
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.
29 thoughts on “Loan EMI Calculator in Excel (.xls file Download Here)”
How we calculate flat interes rate ?
need excel file
Pls tell how to calculate flat emi with separate interst and penal.
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
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.
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
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