• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

EMI Calculator

Kasper

New Member
Hi,

I am always confused with calculations for home loan EMIs (especially pre-payment logic).

Do you have any excel template which does this neatly.


Thanks
 

keymaster

New Member
You can use excel formulas PMT, PPMT and IPMT to calculate the EMI, Principle portion of EMI and Interest portion of EMI. PMT gives one value. PPMT changes based on the installment number (month).


You can write correct formulas once you know the pre-payment conditions and terms.
 

keymaster

New Member
You can see examples of these formulas here: http://chandoo.org/excel-formulas/pmt.html

http://chandoo.org/excel-formulas/ipmt.html http://chandoo.org/excel-formulas/ppmt.html
 
Top