How to caluculate the revised period of Home Loan?

I have taken a floating rate housing loan and have made a part pre-payment. The interest rate have also reduced twice since the date the loan was disbursed to my account. I have opted for reduction in the loan tenure instead of reduction in the instalment amount. Can somebody provide me the formula/excel sheet format to calculate the revised tenure of the loan?

4 Replies to “How to caluculate the revised period of Home Loan?”

  1. Type the following formula in a cell
    and press the enter.
    For example if loan to be repaid is 2100000
    rate is 9.75% and EMI is Rs. 19500 then type in the following manner
    =nper(9.75%/12,19500,-2100000,0,0) then press the enter
    You will find the number of EMI

Leave a Reply

Your email address will not be published. Required fields are marked *

seventeen + fifteen =