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.

EMI Calculator (.xls File)

Download Here

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group
Nazim Khan - Author Image

Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]

Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website ( and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.

44 thoughts on “Loan EMI Calculator in Excel (.xls file Download Here)”

  1. 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

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

  3. 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…

  4. 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

  5. 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

  6. 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 .


Leave a Comment